protected void Button1_Click(object sender, EventArgs e) { try { EMPDATA E = new EMPDATA(); E.EMPNO = int.Parse(txtEno.Text); E.ENAME = txtEname.Text; E.JOB = txtJob.Text; E.MGR = int.Parse(txtManagerID.Text); E.HIREDATE = DateTime.Parse(txtHireDate.Text); E.SAL = int.Parse(txtSal.Text); E.COMM = int.Parse(txtCommission.Text); E.DEPTNO = int.Parse(txtDeptno.Text); D.EMPDATAs.Add(E); D.SaveChanges(); } catch (DbUpdateException E) { SqlException ex = E.GetBaseException() as SqlException; if (ex.Message.Contains("EMP_PK")) { Label1.Text = "No Duplicate Empno"; } else if (ex.Message.Contains("FK__EMPDATA__DEPTNO__2B0A656D")) { Label1.Text = "No Deptno Number"; } else { Label1.Text = ex.Message; } } }
protected void Button1_Click(object sender, EventArgs e) { int eno = int.Parse(txtEno.Text); var E = from E1 in D.EMPDATAs where E1.EMPNO == eno select E1; EMPDATA ED = E.First(); int c = 0; bool b = int.TryParse(txtCommission.Text, out c); ED.JOB = txtJob.Text; ED.MGR = int.Parse(txtManagerID.Text); ED.HIREDATE = DateTime.Parse(txtHireDate.Text); ED.SAL = int.Parse(txtSal.Text); if (c != 0) { ED.COMM = c; } ED.DEPTNO = int.Parse(txtDeptno.Text); EMPDATA emp = E.First(); D.EMPDATAs.Remove(emp); D.SaveChanges(); }