internal string UpdateDealer(int IDUtente, DealerUpdate myDealerUpdate)
{
sqlop = new SqlOperations();
sqlop.databaseConnection = ConfigurationManager.ConnectionStrings["cs"].ToString();
DbParameter[] dbp = new DbParameter[2];
dbp[0] = new SqlParameter();
dbp[0].ParameterName = "IDUtente";
dbp[0].DbType = DbType.String;
dbp[0].Direction = ParameterDirection.Input;
dbp[0].Value = IDUtente;
XDocument DealerUpdateXml = new XDocument(
new XElement("DealerUpdate",
new XElement("Dealer",
new XAttribute("IDDealer", myDealerUpdate.IDDealer),
new XElement("Variazioni"))));
foreach (DealerUpdateFields myDealerUpdateFields in myDealerUpdate.DealerUpdateFieldsList)
{
if (myDealerUpdateFields.IsDatoModificato)
{
XElement newElement = DealerUpdateXml.Element("DealerUpdate").Element("Dealer").Element("Variazioni");
newElement.Add(new XElement("Variazione",
new XAttribute("NomeCampo", myDealerUpdateFields.NomeCampo),
new XAttribute("DatoVecchio", myDealerUpdateFields.DatoVecchio),
new XAttribute("DatoNuovo", myDealerUpdateFields.DatoNuovo)));
}
}
dbp[1] = new SqlParameter();
dbp[1].ParameterName = "DealerUpdateXml";
dbp[1].DbType = DbType.String;
dbp[1].Direction = ParameterDirection.Input;
dbp[1].Value = DealerUpdateXml.ToString();
SqlCommandObject sco = new SqlCommandObject();
sco.SPName = "Dealer.SP_Dealer_Update";
sco.SPParams = dbp;
DataTable dt;
string proc = sqlop.ExecuteProcedure(sco, out dt);
if (proc != string.Empty)
{
return(proc);
}
return("Scheda Dealer aggiornata con successo");
}
internal string UpdateDealer(int IDUtente, DealerUpdate myDealerUpdate)
{
sqlop = new SqlOperations();
sqlop.databaseConnection = ConfigurationManager.ConnectionStrings["cs"].ToString();
DbParameter[] dbp = new DbParameter[2];
dbp[0] = new SqlParameter();
dbp[0].ParameterName = "IDUtente";
dbp[0].DbType = DbType.String;
dbp[0].Direction = ParameterDirection.Input;
dbp[0].Value = IDUtente;
XDocument DealerUpdateXml = new XDocument(
new XElement("DealerUpdate",
new XElement("Dealer",
new XAttribute("IDDealer", myDealerUpdate.IDDealer),
new XElement("Variazioni"))));
foreach (DealerUpdateFields myDealerUpdateFields in myDealerUpdate.DealerUpdateFieldsList)
{
if (myDealerUpdateFields.IsDatoModificato)
{
XElement newElement = DealerUpdateXml.Element("DealerUpdate").Element("Dealer").Element("Variazioni");
newElement.Add(new XElement("Variazione",
new XAttribute("NomeCampo", myDealerUpdateFields.NomeCampo),
new XAttribute("DatoVecchio", myDealerUpdateFields.DatoVecchio),
new XAttribute("DatoNuovo", myDealerUpdateFields.DatoNuovo)));
}
}
dbp[1] = new SqlParameter();
dbp[1].ParameterName = "DealerUpdateXml";
dbp[1].DbType = DbType.String;
dbp[1].Direction = ParameterDirection.Input;
dbp[1].Value = DealerUpdateXml.ToString();
SqlCommandObject sco = new SqlCommandObject();
sco.SPName = "Dealer.SP_Dealer_Update";
sco.SPParams = dbp;
DataTable dt;
string proc = sqlop.ExecuteProcedure(sco, out dt);
if (proc != string.Empty)
return proc;
return "Scheda Dealer aggiornata con successo";
}
