private void salveazaPremiuNou_Click(object sender, EventArgs e)
{
if(ValidareForm())
{
PremiiModel model = new PremiiModel(
loculOcupatValue.Text,
valoarePremiuValue.Text,
numeleLoculuiValue.Text,
procentPremiuValue.Text);
foreach (IDataConnection db in GlobalConfig.Connections)
{
db.CrearePremii(model);
}
loculOcupatValue.Text = "";
valoarePremiuValue.Text = "0";
numeleLoculuiValue.Text = "";
procentPremiuValue.Text = "0";
}
else
{
MessageBox.Show("Acest formular contine informatii invalide ! Va rugam ca sa verificati informatiile apoi incercati din nou !");
}
}
public PremiiModel CrearePremii(PremiiModel model)
{
using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(GlobalConfig.CnnString("UABCSDB")))
{
var p = new DynamicParameters();
p.Add("@NumarLoc", model.LoculOcupat);
p.Add("@NumeLoC", model.LocNume);
p.Add("@ValoarePremiu", model.ValoarePremiu);
p.Add("@ProcentPremiu", model.ProcentPremiu);
p.Add("@Id", 0, dbType: DbType.Int32, direction: ParameterDirection.Output);
connection.Execute("dbo.spAdauga_Premiu", p, commandType: CommandType.StoredProcedure);
model.Id = p.Get <int>("@id");
return(model);
}
}
public PremiiModel CrearePremii(PremiiModel model)
{
model.Id = 1;
return(model);
}
