public void Submit()
{
WireTestSoftwareDBEntities db = new WireTestSoftwareDBEntities();
int TypeID = Convert.ToInt32(comboBox2.SelectedValue);
int WireID = Convert.ToInt32(comboBox1.SelectedValue);
int CatagoryID = Convert.ToInt32(comboBox3.SelectedValue);
int UnitID = Convert.ToInt32(comboBox4.SelectedValue);
int Visibilty = Convert.ToInt32(comboBox5.SelectedValue);
var obj = db.tb_ParamName.FirstOrDefault(u => u.Type == TypeID && u.WireID == WireID && u.CatagoryID == CatagoryID && u.Name == txtParamName.Text && u.UnitID == UnitID && u.Enable == 1);
if (obj == null)
{
tb_ParamName objParamName = new tb_ParamName();
objParamName.Name = txtParamName.Text;
objParamName.Type = Convert.ToInt32(comboBox2.SelectedValue);
objParamName.WireID = Convert.ToInt32(comboBox1.SelectedValue);
objParamName.CatagoryID = Convert.ToInt32(comboBox3.SelectedValue);
objParamName.UnitID = Convert.ToInt32(comboBox4.SelectedValue);
objParamName.ShowParam = Visibilty;
objParamName.Enable = 1;
objParamName.Status = "Active";
objParamName.CreatedDate = DateTime.Now.Date;
db.tb_ParamName.Add(objParamName);
db.SaveChanges();
}
else
{
MessageBox.Show("This Parameter Already Exists!");
}
}
public void Update(int ID)
{
WireTestSoftwareDBEntities db = new WireTestSoftwareDBEntities();
tb_ParamName objParamName = db.tb_ParamName.FirstOrDefault(u => u.ID == ID && u.Enable == 1);
objParamName.Name = txtParamName.Text;
objParamName.Type = Convert.ToInt32(comboBox2.SelectedValue);
objParamName.WireID = Convert.ToInt32(comboBox1.SelectedValue);
objParamName.CatagoryID = Convert.ToInt32(comboBox3.SelectedValue);
objParamName.UnitID = Convert.ToInt32(comboBox4.SelectedValue);
objParamName.ShowParam = Convert.ToInt32(comboBox5.SelectedValue);
db.SaveChanges();
}
