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;
}
}
