private void UpdateCompanyChanges() { try { strmaincNum = ViewState["CNum"].ToString(); companyNum = int.Parse(strmaincNum); using (var dtx = new TrustCompanyEntities()) { Comp = dtx.Companies.Where(s => s.CNum == companyNum).FirstOrDefault <Company>(); } if (Comp != null) { string newstrCompanyNum = txtCompanyNum.Text; int newintCompanyNum = int.Parse(newstrCompanyNum); Comp.CNum = newintCompanyNum; Comp.Cname = txtCompanyName.Text; Comp.Address = txtAddress.Text; Comp.Telephone = txtTelephone.Text; } using (var dbCtx = new TrustCompanyEntities()) { dbCtx.Entry(Comp).State = System.Data.Entity.EntityState.Modified; dbCtx.SaveChanges(); } lblUpdateRow.Visible = true; lblUpdateRow.Text = "Company Updated"; } catch (Exception ex) { lblUpdateRow.Visible = true; lblUpdateRow.Text = ex.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 InsertChanges() { try { string strInCompanyNum = ViewState["CompanyNum"].ToString(); int intCompanyNum = int.Parse(strInCompanyNum); string strFname = txtFName.Text; string strLname = txtLName.Text; string strGender = rblGender.SelectedValue; string strEmpId = txtEmployeeId.Text; int empId = int.Parse(strEmpId); string strNewBirthDate = dt2.Value; DateTime birthDate; birthDate = new DateTime(Convert.ToInt16(strNewBirthDate.Substring(0, 4)), Convert.ToInt16(strNewBirthDate.Substring(5, 2)), Convert.ToInt16(strNewBirthDate.Substring(8, 2))); using (var db = new TrustCompanyEntities()) { var employees = db.Set <CompanyEmployee>(); employees.Add(new CompanyEmployee { CNum = intCompanyNum, Fname = strFname, Lname = strLname, Gender = strGender, EmployeeId = empId, BirthDate = birthDate }); db.SaveChanges(); lblRowInsert.Visible = true; } } catch (Exception ex) { lblRowInsert.Visible = true; lblRowInsert.Text = ex.Message; } }
private void InsertChanges() { try { string newstrCompanyNum = txtCompanyNum.Text; int newintCompanyNum = int.Parse(newstrCompanyNum); string strCompanyName = txtCompanyName.Text; string strAddress = txtAddress.Text; string strTelephone = txtTelephone.Text; using (var db = new TrustCompanyEntities()) { var companies = db.Set <Company>(); companies.Add(new Company { CNum = newintCompanyNum, Cname = strCompanyName, Address = strAddress, Telephone = strTelephone }); db.SaveChanges(); lblRowInsert.Visible = true; } } catch (Exception ex) { lblRowInsert.Visible = true; lblRowInsert.Text = ex.Message; } }
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 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; } }