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