protected void InsertFarm(object sender, EventArgs e) { var farmManager = new FarmManager(ConfigurationManager.ConnectionStrings["AdditionalInformation"].ConnectionString); var farm = farmManager.GetFarmByName(FermaName.Text); if (farm != null) { FarmValidation.Text = "Ferma " + FermaName.Text + " exista deja!"; FarmValidation.Visible = true; FarmValidation.ForeColor = Color.Red; } else { farm = new FCCL_DAL.Entities.Ferme_CCL { Cod = FermaCod.Text, CodPostal = CodPostal.Text, Email = FarmEmail.Text, FabricaId = Convert.ToInt32(Asociatia.SelectedValue), Fax = Fax.Text, Ferme = "F", FermierId = 0, Judet = Judet.SelectedValue, JudetId = Convert.ToInt32(Judet.SelectedValue), Nume = FermaName.Text, Numar = Numar.Text, Oras = Localitate.Text, PersoanaDeContact = PersContact.Text, Telefon = Telefon.Text, TelPersoanaContact = TelPersContact.Text, Strada = Strada.Text, SendSms = SendSms.Checked }; var result = farmManager.InsertFarm(farm); if (result) { Response.Redirect("~/EditareFerme.aspx"); } else { FarmValidation.Text = "Ferma " + FermaName.Text + " nu poate fi inserata!"; FarmValidation.Visible = true; FarmValidation.ForeColor = Color.Red; } } }
protected void UpdateFarm(object sender, EventArgs e) { var farmManager = new FarmManager(ConfigurationManager.ConnectionStrings["AdditionalInformation"].ConnectionString); var farm = new FCCL_DAL.Entities.Ferme_CCL { Id = Convert.ToInt32(IdFerma.Text), Cod = FermaCod.Text, CodPostal = CodPostal.Text, Email = FarmEmail.Text, FabricaId = Convert.ToInt32(Asociatia.SelectedValue), Fax = Fax.Text, Ferme = "F", FermierId = 0, Judet = Judet.SelectedItem.Value, JudetId = Convert.ToInt32(Judet.SelectedItem.Value), Nume = FermaName.Text, Numar = Numar.Text, Oras = Localitate.Text, PersoanaDeContact = PersContact.Text, Telefon = Telefon.Text, TelPersoanaContact = TelPersContact.Text, Strada = Strada.Text, SendSms = SendSms.Checked }; var result = farmManager.UpdateFarm(farm); if (result) Response.Redirect("~/EditareFerme.aspx"); else { FarmValidation.Text = "Ferma " + FermaName.Text + " nu poate fi updatata!"; FarmValidation.Visible = true; FarmValidation.ForeColor = Color.Red; } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { FCCL_DAL.Entities.Ferme_CCL farm = null; if (Request.Params["ID"] != null) { var farmManager = new FarmManager(ConfigurationManager.ConnectionStrings["AdditionalInformation"].ConnectionString); farm = farmManager.GetFarmById(Convert.ToInt32(Request.Params["ID"])); } var fabricaManager = new FactoryManager(ConfigurationManager.ConnectionStrings["AdditionalInformation"].ConnectionString); var fabrici = fabricaManager.GetFactories(); Asociatia.DataSource = fabrici; if (farm != null && farm.FabricaId != null) { Asociatia.SelectedValue = farm.FabricaId.ToString(); } Asociatia.DataBind(); var countyManager = new CountyManager(ConfigurationManager.ConnectionStrings["fccl2ConnectionString"].ConnectionString); var counties = countyManager.GetAllCounties(); Judet.DataSource = counties; if (farm != null && farm.JudetId != null) { Judet.SelectedValue = farm.JudetId.ToString(); } Judet.DataBind(); InsertF.Visible = true; if (farm != null) { //populate farm table IdFerma.Text = farm.Id.ToString(); FermaCod.Text = farm.Cod; FermaName.Text = farm.Nume; FarmEmail.Text = farm.Email; Localitate.Text = farm.Oras; Strada.Text = farm.Strada; Numar.Text = farm.Numar; CodPostal.Text = farm.CodPostal; Telefon.Text = farm.Telefon; Fax.Text = farm.Fax; PersContact.Text = farm.PersoanaDeContact; TelPersContact.Text = farm.TelPersoanaContact; SendSms.Checked = farm.SendSms; //populate user table var userManager = new UserManager(ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString); var userInfo = userManager.GetUserInformationByCod(farm.Cod); if (userInfo != null) { UserId.Value = userInfo.UserId.ToString(); Nume.Text = userInfo.LastName; Prenume.Text = userInfo.FirstName; UserNameLbl.Text = userInfo.UserName; Email.Text = userInfo.Email; Update.Visible = true; ResetareParola.Visible = true; UserNameLbl.Visible = true; Parola.Visible = false; } else { Insert.Visible = true; UserName.Visible = true; } UserCodLbl.Text = farm.Cod; UpdateF.Visible = true; DeleteF.Visible = true; } } }
public bool UpdateFarm(Ferme_CCL farm) { var cn = new SqlConnection(connectionString); int affectedRows = 0; try { var cmd = new SqlCommand( "UPDATE Ferme_CCL SET Cod = @Cod,Nume = @Nume,FabricaID = @FabricaID,Strada = @Strada,Numar = @Numar, Oras = @Oras,Judet = @Judet,CodPostal = @CodPostal,Telefon = @Telefon,Fax = @Fax,Email = @Email,FermierID = @FermierID,PersonaDeContact = @PersonaDeContact,TelPersoanaContact = @TelPersoanaContact,Ferme_CCL = @Ferme_CCL,JudetID =@JudetID,SendSms = @SendSms WHERE ID = @Id"); cmd.Parameters.AddWithValue("@ID", farm.Id); cmd.Parameters.AddWithValue("@Cod", farm.Cod); cmd.Parameters.AddWithValue("@Nume", farm.Nume); cmd.Parameters.AddWithValue("@FabricaID", farm.FabricaId); cmd.Parameters.AddWithValue("@Strada", farm.Strada); cmd.Parameters.AddWithValue("@Numar", farm.Numar); cmd.Parameters.AddWithValue("@Oras", farm.Oras); cmd.Parameters.AddWithValue("@Judet", farm.Judet); cmd.Parameters.AddWithValue("@CodPostal", farm.CodPostal); cmd.Parameters.AddWithValue("@Telefon", farm.Telefon); cmd.Parameters.AddWithValue("@Fax", farm.Fax); cmd.Parameters.AddWithValue("@Email", farm.Email); cmd.Parameters.AddWithValue("@FermierID", farm.FermierId); cmd.Parameters.AddWithValue("@PersonaDeContact", farm.PersoanaDeContact); cmd.Parameters.AddWithValue("@TelPersoanaContact", farm.TelPersoanaContact); cmd.Parameters.AddWithValue("@Ferme_CCL", farm.Ferme); cmd.Parameters.AddWithValue("@JudetID", farm.JudetId); cmd.Parameters.AddWithValue("@SendSms", farm.SendSms); cmd.Connection = cn; cn.Open(); affectedRows = cmd.ExecuteNonQuery(); } catch (Exception ex) { logger.Error(string.Format("UpdateFarm|farm:{0} ERROR:{1}", farm.Id, ex.Message)); } finally { cn.Close(); } return affectedRows > 0; }
public bool InsertFarm(Ferme_CCL farm) { var cn = new SqlConnection(connectionString); int affectedRows = 0; try { var cmd = new SqlCommand( "INSERT INTO Ferme_CCL(Cod,Nume,FabricaID,Strada,Numar,Oras,Judet,CodPostal,Telefon,Fax,Email,FermierID,PersonaDeContact,TelPersoanaContact,Ferme_CCL,JudetID,SendSms) VALUES (@Cod,@Nume,@FabricaID,@Strada,@Numar,@Oras,@Judet,@CodPostal,@Telefon,@Fax,@Email,@FermierID,@PersonaDeContact,@TelPersoanaContact,@Ferme_CCL,@JudetID,@SendSms)"); cmd.Parameters.AddWithValue("@Cod", farm.Cod); cmd.Parameters.AddWithValue("@Nume", farm.Nume); cmd.Parameters.AddWithValue("@FabricaID", farm.FabricaId); cmd.Parameters.AddWithValue("@Strada", farm.Strada); cmd.Parameters.AddWithValue("@Numar", farm.Numar); cmd.Parameters.AddWithValue("@Oras", farm.Oras); cmd.Parameters.AddWithValue("@Judet", farm.Judet); cmd.Parameters.AddWithValue("@CodPostal", farm.CodPostal); cmd.Parameters.AddWithValue("@Telefon", farm.Telefon); cmd.Parameters.AddWithValue("@Fax", farm.Fax); cmd.Parameters.AddWithValue("@Email", farm.Email); cmd.Parameters.AddWithValue("@FermierID", farm.FermierId); cmd.Parameters.AddWithValue("@PersonaDeContact", farm.PersoanaDeContact); cmd.Parameters.AddWithValue("@TelPersoanaContact", farm.TelPersoanaContact); cmd.Parameters.AddWithValue("@Ferme_CCL", farm.Ferme); cmd.Parameters.AddWithValue("@JudetID", farm.JudetId); cmd.Parameters.AddWithValue("@SendSms", farm.SendSms); cmd.Connection = cn; cn.Open(); affectedRows = cmd.ExecuteNonQuery(); } catch (Exception ex) { logger.Error(string.Format("InsertFarm|farm:{0} ERROR:{1}", farm.Id, ex.Message)); } finally { cn.Close(); } return affectedRows > 0; }
public Ferme_CCL GetFarmByName(string numeFerma) { Ferme_CCL farm = null; var cn = new SqlConnection(connectionString); SqlDataReader reader = null; try { var cmd = new SqlCommand( "SELECT Cod,Ferme_CCL,ID,Nume,FabricaID,Strada,Numar,Oras,Judet,JudetID,Telefon,Email,FermierID,CodPostal,Fax,PersonaDeContact,TelPersoanaContact,SendSms FROM Ferme_CCL WHERE Cod IS NOT NULL AND Nume = @nume", cn); cmd.Parameters.AddWithValue("@nume", numeFerma); cn.Open(); reader = cmd.ExecuteReader(); if (reader.Read()) { farm = new Ferme_CCL { Cod = reader[0] as String, Ferme = reader[1] as String, Id = reader[2] as Int32?, Nume = reader[3] as String, FabricaId = reader[4] as Int32?, Strada = reader[5] as String, Numar = reader[6] as String, Oras = reader[7] as String, Judet = reader[8] as String, JudetId = reader[9] as Int32?, Telefon = reader[10] as String, Email = reader[11] as String, FermierId = reader[12] as Int32?, CodPostal = reader[13] as String, Fax = reader[14] as String, PersoanaDeContact = reader[15] as String, TelPersoanaContact = reader[16] as String, SendSms = (bool) reader[17] }; } } catch (Exception ex) { logger.Error(string.Format("GetFarmByName|numeFerma:{0} ERROR:{1}", numeFerma,ex.Message)); } finally { if (reader != null) reader.Close(); cn.Close(); } return farm; }