private void DeleteEmployee() { try { strempId = ViewState["EmpId"].ToString(); empId = int.Parse(strempId); using (var dtx = new TrustCompanyEntities()) { empComp = dtx.CompanyEmployees.Where(s => s.EmployeeId == empId).FirstOrDefault <CompanyEmployee>(); dtx.Entry(empComp).State = EntityState.Deleted; dtx.SaveChanges(); lblUpdateRow.Text = "Employee Removed"; strCompanyNum = ViewState["CompanyNum"].ToString(); strcompanyName = ViewState["CompanyName"].ToString(); Response.Redirect("Employees.aspx?id=" + strCompanyNum + "&cName=" + strcompanyName, false); } } catch (Exception ex) { lblUpdateRow.Visible = true; lblUpdateRow.Text = ex.InnerException.InnerException.Message; } }
private void DeleteCompany() { try { strmaincNum = ViewState["CNum"].ToString(); companyNum = int.Parse(strmaincNum); using (var dtx = new TrustCompanyEntities()) { empComp = dtx.CompanyEmployees.Where(s => s.CNum == companyNum).FirstOrDefault <CompanyEmployee>(); if (empComp != null) { throw new Exception("Company has to be Empty From Employees"); } Comp = dtx.Companies.Where(s => s.CNum == companyNum).FirstOrDefault <Company>(); dtx.Entry(Comp).State = EntityState.Deleted; dtx.SaveChanges(); } lblUpdateRow.Visible = true; lblUpdateRow.Text = "Company Removed"; } catch (Exception ex) { lblUpdateRow.Visible = true; lblUpdateRow.Text = ex.Message; } }
private void UpdateChanges() { try { string strEmpId = ViewState["EmpId"].ToString(); empId = int.Parse(strEmpId); using (var dtx = new TrustCompanyEntities()) { empComp = dtx.CompanyEmployees.Where(s => s.EmployeeId == empId).FirstOrDefault <CompanyEmployee>(); } if (empComp != null) { empComp.Fname = txtFName.Text; empComp.Lname = txtLName.Text; string strEmployeeId = txtEmployeeId.Text; empComp.EmployeeId = int.Parse(strEmployeeId); string gender = rblGender.SelectedValue; empComp.Gender = gender; string strNewBirthDate = dt1.Value; BirthDate = new DateTime(Convert.ToInt16(strNewBirthDate.Substring(0, 4)), Convert.ToInt16(strNewBirthDate.Substring(5, 2)), Convert.ToInt16(strNewBirthDate.Substring(8, 2))); empComp.BirthDate = BirthDate; } using (var dbCtx = new TrustCompanyEntities()) { dbCtx.Entry(empComp).State = System.Data.Entity.EntityState.Modified; dbCtx.SaveChanges(); } lblUpdateRow.Visible = true; } catch (Exception ex) { lblUpdateRow.Visible = true; lblUpdateRow.Text = ex.Message; } }