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); }