protected void Button1_Click(object sender, EventArgs e)
{
int eno = int.Parse(txtempno.Text);
var E = from E1 in d.EMPDATAs
where E1.EMPNO == eno
select E1;
EMPDATA emp = E.First();
int c = 0;
bool b = int.TryParse(txtcomm.Text, out c);
emp.ENAME = txtename.Text;
emp.JOB = txtjob.Text;
emp.MGR = int.Parse(txtmgr.Text);
emp.HIREDATE = DateTime.Parse(txthiredate.Text);
emp.SAL = int.Parse(txtsal.Text);
// emp.COMM = Convert.ToInt32(txtcomm.Text);//because comm has null values,null will be converted to 0 but it will not handle empty
if (c != 0)
{
emp.COMM = c;
}
emp.DEPTNO = int.Parse(txtdeptno.Text);
d.SaveChanges();
}
protected void Button1_Click(object sender, EventArgs e)
{
try
{
EMPDATA E = new EMPDATA();
E.EMPNO = int.Parse(txtempno.Text);
E.ENAME = txtename.Text;
E.JOB = txtjob.Text;
E.MGR = int.Parse(txtmgr.Text);
E.HIREDATE = DateTime.Parse(txthiredate.Text);
E.SAL = int.Parse(txtsal.Text);
E.COMM = int.Parse(txtcomm.Text);
E.DEPTNO = int.Parse(txtdeptno.Text);
D.EMPDATAs.Add(E);
D.SaveChanges();
label.Text = "1 row added successfully";
txtempno.Text = "";
txtename.Text = "";
txtjob.Text = "";
txtmgr.Text = "";
txtcomm.Text = "";
txtsal.Text = "";
txtdeptno.Text = "";
txthiredate.Text = "";
}
catch (DbUpdateException s)
{
SqlException ex = s.GetBaseException() as SqlException;
if (ex.Message.Contains("EMP_PK"))
{
label.Text = "no duplicate empno";
}
else if (ex.Message.Contains("FK__EMPDATA__DEPTNO__236943A5"))
{
label.Text = "no deptno exists";
}
else
{
label.Text = ex.Message;
}
txtempno.Text = "";
txtename.Text = "";
txtjob.Text = "";
txtmgr.Text = "";
txtcomm.Text = "";
txtsal.Text = "";
txtdeptno.Text = "";
txthiredate.Text = "";
}
}
