internal string InserRelazioneDealer(Relazioni rel)
{
sqlop = new SqlOperations();
sqlop.databaseConnection = ConfigurationManager.ConnectionStrings["cs"].ToString();
DbParameter[] dbp = new DbParameter[4];
dbp[0] = new SqlParameter();
dbp[0].ParameterName = "NomeRelazione";
dbp[0].DbType = DbType.String;
dbp[0].Direction = ParameterDirection.Input;
dbp[0].Value = rel.NomeRelazione;
dbp[1] = new SqlParameter();
dbp[1].ParameterName = "IDTipoDealer";
dbp[1].DbType = DbType.Int32;
dbp[1].Direction = ParameterDirection.Input;
dbp[1].Value = rel.IDTipoDealer;
dbp[2] = new SqlParameter();
dbp[2].ParameterName = "IDDealer1";
dbp[2].DbType = DbType.Int32;
dbp[2].Direction = ParameterDirection.Input;
dbp[2].Value = rel.IDDealerConsumer;
dbp[3] = new SqlParameter();
dbp[3].ParameterName = "IDDealer2";
dbp[3].DbType = DbType.Int32;
dbp[3].Direction = ParameterDirection.Input;
dbp[3].Value = rel.IDDealer;
SqlCommandObject sco = new SqlCommandObject();
sco.SPName = "Dealer.SP_RelazioniDealer_Insert";
sco.SPParams = dbp;
DataTable dt;
string proc = sqlop.ExecuteProcedure(sco, out dt);
if (proc != string.Empty)
{
return(proc);
}
return("");
}
protected void SalvaRSButton_Click(object sender, ImageClickEventArgs e)
{
try
{
Relazioni rel = new Relazioni();
rel.NomeRelazione = txtNomeRelazione.Text;
rel.IDDealerConsumer = Convert.ToInt32(IDDealerScelto1HF.Value);
rel.IDDealer = Convert.ToInt32(IDDealerScelto2HF.Value);
rel.IDTipoDealer = Convert.ToInt32(ddlTipoDealer2.SelectedValue);
if ((rel.IDDealerConsumer != rel.IDDealer) || (rel.IDTipoDealer == 2))
{
string err = proxyADS.InserRelazioneDealer(rel);
if (err == "")
{
PopupMessaggio.ShowMsgBox("Relazione creata correttamente.", false);
inizializzaPagina();
}
else
{
if (err.Contains("IX_RelazioneConsumer") || err.Contains("IX_RelazioneBusiness"))
{
throw new Exception("Relazione esistente.");
}
else
{
throw new Exception("Relazione non creata correttamente.");
}
}
}
else
{
throw new Exception("Relazione non creata correttamente.");
}
}
catch (Exception ex)
{
PopupMessaggio.ShowMsgBox(ex.Message, true);
}
finally
{
resetDealer1();
resetDealer2();
}
}
internal string InserRelazioneDealer(Relazioni rel)
{
sqlop = new SqlOperations();
sqlop.databaseConnection = ConfigurationManager.ConnectionStrings["cs"].ToString();
DbParameter[] dbp = new DbParameter[4];
dbp[0] = new SqlParameter();
dbp[0].ParameterName = "NomeRelazione";
dbp[0].DbType = DbType.String;
dbp[0].Direction = ParameterDirection.Input;
dbp[0].Value = rel.NomeRelazione;
dbp[1] = new SqlParameter();
dbp[1].ParameterName = "IDTipoDealer";
dbp[1].DbType = DbType.Int32;
dbp[1].Direction = ParameterDirection.Input;
dbp[1].Value = rel.IDTipoDealer;
dbp[2] = new SqlParameter();
dbp[2].ParameterName = "IDDealer1";
dbp[2].DbType = DbType.Int32;
dbp[2].Direction = ParameterDirection.Input;
dbp[2].Value = rel.IDDealerConsumer;
dbp[3] = new SqlParameter();
dbp[3].ParameterName = "IDDealer2";
dbp[3].DbType = DbType.Int32;
dbp[3].Direction = ParameterDirection.Input;
dbp[3].Value = rel.IDDealer;
SqlCommandObject sco = new SqlCommandObject();
sco.SPName = "Dealer.SP_RelazioniDealer_Insert";
sco.SPParams = dbp;
DataTable dt;
string proc = sqlop.ExecuteProcedure(sco, out dt);
if (proc != string.Empty)
return proc;
return "";
}
