protected void Page_Load(object sender, EventArgs e) { try { string name = Session["fullName"].ToString(); string role = Session["role"].ToString(); } catch (Exception) { Response.Redirect("../Default.aspx"); } if (!IsPostBack) { niapsEntities1 db = new niapsEntities1(); int sId = Int32.Parse(getStaffId()); var staffRec = db.currentStaffRecords.Where(st => st.Id == sId).First(); stid.Text = staffRec.staffId; dept.Text = staffRec.department; degree.Text = staffRec.degree; doj.Text = (staffRec.date_Joined).ToString(); disc.Text = staffRec.qualification; doc.Text = staffRec.dateOfConfirmation.ToString(); designation.Text = staffRec.designation; var ste = db.staffRecords.Where(s => s.staffId == staffRec.staffId).First(); lname.Text = ste.lName; fname.Text = ste.fName; } try { niapsEntities1 db = new niapsEntities1(); string name = Session["fullName"].ToString(); // Insert the update transaction into the staff update history table first staffUpdateHistory stu = new staffUpdateHistory(); stu.staffId = stid.Text; stu.updatDate = DateTime.Now; stu.updatedBy = name; string message = getOldRecord(); // message += ": New Record: Staff Name:" + lname.Text + ", " + fname.Text + " " + mname.Text + ", Designation:" + des.Text + ",GSM: " + gsm.Text + "Email:" + email.Text + "" + ", Address" + address.Text + ", Marital Status:" + mstatus.Text + ",Status:" + status.Text; stu.description = message; db.staffUpdateHistories.Add(stu); db.SaveChanges(); } catch (Exception) { } }
protected void update_Click(object sender, EventArgs e) { try { niapsEntities1 db = new niapsEntities1(); string uname = Session["fullName"].ToString(); staffUpdateHistory stu = new staffUpdateHistory(); stu.staffId = stid.Text; stu.updatDate = DateTime.Now; stu.updatedBy = uname; string message = getOldRecord(); stu.description = message; db.staffUpdateHistories.Add(stu); db.SaveChanges(); niapsEntities1 db2 = new niapsEntities1(); string sid = stid.Text; var str = db2.staffRecords.FirstOrDefault(ai => ai.staffId == sid); // str.staffId = sid; str.lName = lname.Text; str.fName = fname.Text; str.gender = gender.Text; string date1 = dob.Text; DateTime dobirth = DateTime.Parse(date1); str.dateOfBirth = dobirth; str.middleName = mname.Text; // str.designation = des.Text; str.age = Int32.Parse(age.Text); str.mobile = gsm.Text; var lg = db.LGAs.Where(l => l.name == lga.Text).First(); string loc = lg.LGACode.ToString(); str.Lga = loc; var ste = db.states.Where(s => s.state1 == state.Text).First(); str.state = ste.stateCode; str.address = address.Text; str.email = email.Text; str.marritalStatus = mstatus.Text; str.formOfIdentification = foid.Text; str.idNumber = idNumber.Text; db2.SaveChanges(); niapsEntities1 db3 = new niapsEntities1(); string sId = Request.QueryString["staffId"].ToString(); var kin = db3.staffNextOfKins.FirstOrDefault(ki => ki.staffId == sId); kin.lname = kinLastName.Text; kin.fName = kinFirstName.Text; kin.address = kinAddress.Text; kin.gender = kinGender.Text; kin.contactMobile = kinGsm.Text; kin.relationship = relationship.Text; db3.SaveChanges(); niapsEntities1 db4 = new niapsEntities1(); var empl = db4.currentStaffRecords.FirstOrDefault(emp => emp.staffId == sId); empl.degree = degree.Text; empl.designation = designation.Text; empl.qualification = disc.Text; empl.dateOfConfirmation = DateTime.Parse(dc.Text); empl.date_Joined = DateTime.Parse(djoined.Text); empl.probationPeriod = Int32.Parse(pbp.Text); empl.department = dept.Text; db4.SaveChanges(); stid.Text = ""; lname.Text = ""; fname.Text = ""; gender.Text = ""; dob.Text = ""; mname.Text = ""; age.Text = ""; gsm.Text = ""; lga.Text = ""; state.Text = ""; address.Text = ""; email.Text = ""; mstatus.Text = ""; foid.Text = ""; idNumber.Text = ""; kinLastName.Text = ""; kinFirstName.Text = ""; kinAddress.Text = ""; kinGender.Text = ""; kinGsm.Text = ""; relationship.Text = ""; degree.Text = ""; designation.Text = ""; disc.Text = ""; dc.Text = ""; djoined.Text = ""; pbp.Text = ""; msg.Text = "staff updated successfully"; } catch (Exception) { msg.Text = "error occured! could not update"; } }