I have a web part with grid view and I want to edit a cell of "Utente" and update this with modify. This cell gets the data from the list. How can I do that? You can help?
my aspx
public GestioneAttivita()
{
}
protected override void OnInit(EventArgs e)
{
base.OnInit(e);
InitializeControl();
}
protected void Page_Load(object sender, EventArgs e)
{
// _id = Page.Request.QueryString("ID");
if (!Page.IsPostBack)
{
SPSecurity.RunWithElevatedPrivileges(delegate ()
{
using (SPSite ElevatedSite = new SPSite(SPContext.Current.Web.Site.ID))
using (SPWeb ElevatedWeb = ElevatedSite.OpenWeb(SPContext.Current.Web.ID))
{
CaricaTendinaAttivita(ElevatedWeb);
CaricaTendinaEsito(ElevatedWeb);
CaricaTendinaCausale(ElevatedWeb);
CaricaTendinaUtente(ElevatedWeb);
CaricaItem(ElevatedWeb);
}
});
}
}
protected void btnCerca_Click(object sender, EventArgs e)
{
SPSecurity.RunWithElevatedPrivileges(delegate ()
{
using (SPSite ElevatedSite = new SPSite(SPContext.Current.Web.Site.ID))
using (SPWeb ElevatedWeb = ElevatedSite.OpenWeb(SPContext.Current.Web.ID))
{
CaricaItem(ElevatedWeb);
}
});
}
protected void btnAnnulla_Click(object sender, EventArgs e)
{
SPSecurity.RunWithElevatedPrivileges(delegate ()
{
using (SPSite ElevatedSite = new SPSite(SPContext.Current.Web.Site.ID))
using (SPWeb ElevatedWeb = ElevatedSite.OpenWeb(SPContext.Current.Web.ID))
{
PulisciControlli();
CaricaItem(ElevatedWeb);
}
});
}
private void PulisciControlli()
{
ddlAttivita.SelectedValue = "";
ddlEsito.SelectedValue = "";
ddlCausale.SelectedValue = "";
ddlUtente.SelectedValue = "";
txtOrigineCSV.Text = "";
ddlAttivita.Enabled = false;
ddlUtente.Enabled = false;
ddlEsito.Enabled = false;
ddlCausale.Enabled = false;
txtOrigineCSV.Enabled = false;
}
private void CaricaItem(SPWeb web)
{
SPList listaGestAtt = web.GetList(web.ServerRelativeUrl + "/Lists/" + ddlListaDiRiferimento.SelectedValue);
var value = ddlAttivita.SelectedItem.Text;
SPListItemCollection items = null;
if (!String.IsNullOrEmpty(ddlListaDiRiferimento.SelectedValue))
{
SPQuery query = new SPQuery();
query.Query = "" + ddlListaDiRiferimento.SelectedValue + "";
items = listaGestAtt.GetItems(query);
if (!String.IsNullOrEmpty(ddlAttivita.SelectedValue))
{
SPQuery queryAttivita = new SPQuery();
queryAttivita.Query = "" + ddlAttivita.SelectedItem.Text + "";
items = listaGestAtt.GetItems(queryAttivita);
}
if (!String.IsNullOrEmpty(ddlUtente.SelectedValue))
{
SPQuery queryUtente = new SPQuery();
queryUtente.Query = "" + ddlUtente.SelectedItem.Text + "";
items = listaGestAtt.GetItems(queryUtente);
}
if (!String.IsNullOrEmpty(ddlEsito.SelectedValue))
{
SPQuery queryEsito = new SPQuery();
queryEsito.Query = "" + ddlEsito.SelectedItem.Text + "";
items = listaGestAtt.GetItems(queryEsito);
}
if (!String.IsNullOrEmpty(ddlCausale.SelectedValue))
{
SPQuery queryCausale = new SPQuery();
queryCausale.Query = "" + ddlCausale.SelectedItem.Text + "";
items = listaGestAtt.GetItems(queryCausale);
}
if (!String.IsNullOrEmpty(txtOrigineCSV.Text))
{
SPQuery queryOrigineCSV = new SPQuery();
queryOrigineCSV.Query = "" + txtOrigineCSV.Text + "";
items = listaGestAtt.GetItems(queryOrigineCSV);
}
}
else
{
items = listaGestAtt.Items;
}
var itemBindabili = from SPListItem i in items.Cast()
select new
{
ID = i.ID,
Titolo = i("Title"),
Attivita = new SPFieldLookupValue(i("Attivit_x00e0_") as String).LookupValue,
OrigineCSV = new SPFieldLookupValue(i("OrigineCSV") as String).LookupValue,
IDUtente = ControllaID(web, Convert.ToString(i("Utente"))),
Utente = ControllaUtente(web, Convert.ToString(i("Utente"))),
Esito = new SPFieldLookupValue(i("Esito") as String).LookupValue,
Causale = new SPFieldLookupValue(i("Causale") as String).LookupValue,
Data = i("Created"),
};
grdItems.DataSource = itemBindabili.ToList();
grdItems.DataBind();
}
private string ControllaUtente(SPWeb web, string fieldValue)
{
if (!string.IsNullOrEmpty(fieldValue))
return new SPFieldUserValue(web, fieldValue).User.Name;
else
return (fieldValue);
}
private int ControllaID(SPWeb web, string fieldValue)
{
if (!string.IsNullOrEmpty(fieldValue))
return new SPFieldUserValue(web, fieldValue).User.ID;
else
return -1;
}
protected void ddlListaDiRiferimento_SelectedIndexChanged(object sender, EventArgs e)
{
string value = ddlListaDiRiferimento.SelectedValue;
CaricaItem(SPContext.Current.Web);
if (!String.IsNullOrEmpty(ddlListaDiRiferimento.SelectedValue))
{
ddlAttivita.Enabled = true;
ddlEsito.Enabled = true;
ddlCausale.Enabled = true;
ddlUtente.Enabled = true;
txtOrigineCSV.Enabled = true;
}
}
private void CaricaTendinaAttivita(SPWeb Elevatedweb)
{
ddlAttivita.ClearSelection();
ddlAttivita.Items.Clear();
SPList list = Elevatedweb.Lists.TryGetList("Attività");
SPQuery query = new SPQuery();
query.Query = "";
SPListItemCollection collection = list.GetItems(query);
ddlAttivita.DataSource = collection;
ddlAttivita.DataTextField = "Title";
ddlAttivita.DataValueField = "ID";
ddlAttivita.Items.Clear();
ddlAttivita.Items.Insert(0, new ListItem("", ""));
ddlAttivita.DataBind();
}
private void CaricaTendinaEsito(SPWeb Elevatedweb)
{
ddlEsito.ClearSelection();
ddlEsito.Items.Clear();
SPList list = Elevatedweb.Lists.TryGetList("Esiti");
SPQuery query = new SPQuery();
query.Query = "";
SPListItemCollection collection = list.GetItems(query);
ddlEsito.DataSource = collection;
ddlEsito.DataTextField = "Title";
ddlEsito.DataValueField = "ID";
ddlEsito.Items.Clear();
ddlEsito.Items.Insert(0, new ListItem("", ""));
ddlEsito.DataBind();
}
private void CaricaTendinaCausale(SPWeb Elevatedweb)
{
ddlCausale.ClearSelection();
ddlCausale.Items.Clear();
SPList list = Elevatedweb.Lists.TryGetList("Specifica");
SPQuery query = new SPQuery();
query.Query = "";
SPListItemCollection collection = list.GetItems(query);
ddlCausale.DataSource = collection;
ddlCausale.DataTextField = "Title";
ddlCausale.DataValueField = "ID";
ddlCausale.Items.Clear();
ddlCausale.Items.Insert(0, new ListItem("", ""));
ddlCausale.DataBind();
}
private void CaricaTendinaUtente(SPWeb Elevatedweb)
{
using (SPWeb Web = new SPSite("http://lavorazioni.contacts/siti/crm").OpenWeb())
{
SPList lUtenti = Web.Lists.TryGetList("CSC");
SPQuery query = new SPQuery();
query.Query = "";
SPListItemCollection collection = lUtenti.GetItems(query);
var itemBindabili = from SPListItem i in collection.Cast()
select new
{
IDUtente = ControllaID(Web, Convert.ToString(i("Account"))),
Utente = ControllaUtente(Web, Convert.ToString(i("Account"))),
};
ddlUtente.DataSource = itemBindabili;
ddlUtente.DataTextField = "Utente";
ddlUtente.DataValueField = "IDUtente";
ddlUtente.Items.Insert(0, new ListItem("", ""));
ddlUtente.DataBind();
}
}
protected void Update(object sender, EventArgs e)
{
}
protected void txtUtente_Changed(object sender, CommandEventArgs e)
{
int row = int.Parse(e.CommandName);
int cell = int.Parse(e.CommandArgument.ToString());
}
/* protected void grdItems_SelectedIndexChanged(object sender, SPWeb web, EventArgs e)
{
int id = Convert.ToInt32(grdItems.SelectedValue);
SPWeb currentWeb = SPContext.Current.Web;
//SPList listaGestAtt = web.GetList(web.ServerRelativeUrl + "/Lists/CONGIUNTIVW"); //web.GetList(web.ServerRelativeUrl + "/Lists/CONGIUNTIVW");
SPList listaGestAtt = web.GetList(web.ServerRelativeUrl + "/Lists/" + ddlListaDiRiferimento.SelectedValue);
SPListItem Item = listaGestAtt.GetItemById(Convert.ToInt32(id));
lblSelectTitleValue.Text = Item.Title;
pnlModifica.Visible = true;
}
protected void grdItems_RowDeleting(object sender, SPWeb web, System.Web.UI.WebControls.GridViewDeleteEventArgs e)
{
string id = grdItems.DataKeys(e.RowIndex).Value.ToString();
SPWeb currentWeb = SPContext.Current.Web;
SPList listaGestAtt = web.GetList(web.ServerRelativeUrl + "/Lists/CONGIUNTIVW");
SPListItem Item = listaGestAtt.GetItemById(Convert.ToInt32(id));
Item.Delete();
SPSecurity.RunWithElevatedPrivileges(delegate ()
{
using (SPSite ElevatedSite = new SPSite(SPContext.Current.Web.Site.ID))
using (SPWeb ElevatedWeb = ElevatedSite.OpenWeb(SPContext.Current.Web.ID))
{
CaricaItem(ElevatedWeb);
}
});
}
protected void grdItems_PageIndexChanging(object sender, System.Web.UI.WebControls.GridViewPageEventArgs e)
{
int index = e.NewPageIndex;
grdItems.PageIndex = e.NewPageIndex;
SPSecurity.RunWithElevatedPrivileges(delegate ()
{
using (SPSite ElevatedSite = new SPSite(SPContext.Current.Web.Site.ID))
using (SPWeb ElevatedWeb = ElevatedSite.OpenWeb(SPContext.Current.Web.ID))
{
CaricaItem(ElevatedWeb);
}
});
}*/
}
}
