//public static List<assetRecord> GetAsset() //{ // niapsEntities1 db = new niapsEntities1(); // var result = db.assetRecords.OrderBy(re => re.datePurchased); // return result.ToList(); // <a href="updateAsset.aspx?assetId=update</a> //} public void getAsset() { niapsEntities1 db = new niapsEntities1(); var result = db.assetRecords.OrderBy(re => re.datePurchased); StringBuilder sb = new StringBuilder(); int count = 1; foreach (var value in result) { if (value.status.Equals("active")) { sb.Append(string.Format(@" <tr> <td> {0}</td><td>{1} </td><td>{2} </td><td>{3}</td><td>{4} </td><td>{5} </td><td>{6} </td><td>{7} </td><td><a href=""niaAssetDetails.aspx?assetId={8}"">detail</a></td><td> <a href=""updateAsset.aspx?assetId={9}"">update</a></td> </tr> ", count, value.assetId, value.name, value.datePurchased.ToShortDateString(), value.receivingDept, value.coverDate.ToShortDateString(), value.expirydate.ToShortDateString(), value.status, value.assetId, value.assetId)); count++; } else { sb.Append(string.Format(@" <tr> <td> {0}</td><td>{1} </td><td>{2} </td><td>{3}</td><td>{4} </td><td style=""color:red"">{5} </td><td>{6} </td><td>{7} </td><td><a href=""niaAssetDetails.aspx?assetId={8}"">detail</a></td><td> <a href=""updateAsset.aspx?assetId={9}"">update</a></td> </tr> ", count, value.assetId, value.name, value.datePurchased.ToShortDateString(), value.receivingDept, value.coverDate.ToShortDateString(), value.expirydate.ToShortDateString(), value.status, value.assetId, value.assetId)); count++; } } assetLabel.Text = sb.ToString(); }
public static List <staffRecord> GetStaff() { niapsEntities1 db = new niapsEntities1(); var result = db.staffRecords.Where(s => s.status == "active"); return(result.ToList()); }
public string getOldRecord() { niapsEntities1 db = new niapsEntities1(); string sId = getStaffId(); var staffRec = db.staffRecords.Where(st => st.staffId == sId).First(); string sid = staffRec.staffId; // string lname= staffRec.lName; string fname = staffRec.fName; // string gender = staffRec.gender; // string dob= staffRec.dateOfBirth.ToShortDateString(); string mname = staffRec.middleName; // string des = staffRec.designation; // string age=staffRec.age.ToString(); string gsm = staffRec.mobile; string address = staffRec.address; string email = staffRec.email; string mstatus = staffRec.marritalStatus; // string foid = staffRec.formOfIdentification; // string idNumber = staffRec.idNumber; // string edate = staffRec.dateOfEmployment.ToShortDateString(); string status = staffRec.status; string uname = Session["fullName"].ToString(); var message = " An update occured on Staff No: " + sid + " by "; message += uname + " Initial Record: First Name: " + fname + ", Middle Name: " + mname + ", GSM:" + gsm + ", Address:" + address + ", Email:" + email + ", Status: " + status + ", Marital Status: " + mstatus; db.Dispose(); return(message); }
public void getUsers() { niapsEntities1 db = new niapsEntities1(); // news ne = new news(); var msg = db.adminUsers.OrderByDescending(n => n.status == "active"); StringBuilder sb = new StringBuilder(); sb.Append(string.Format(@"<tbody>")); foreach (var value in msg) { if (value.status.Equals("active")) { sb.Append(string.Format(@" <tr> <td>{15}</td> <td>{0}</td><td>{1} </td> <td>{2}</td><td><a href= ""supdateUser.aspx?uid= {3}&uname={4}&role={5}&status={6}"">de/activate</a></td> <td><a href= ""sdeleteUser.aspx?uid= {7}&uname={8}&role={9}&status={10}"">delete</a></td><td><a href= ""smodifyUserPassword.aspx?uid= {11}&uname={12}&role={13}&status={14}"">modify password</a></td> </tr> " , value.userName, verifyRole(value.role), value.status, value.userId, value.userName, value.role, value.status, value.userId, value.userName, value.role, value.status, value.userId, value.userName, value.role, value.status, value.full_name)); } else { sb.Append(string.Format(@" <tr> <td>{15}</td> <td>{0}</td><td>{1} </td> <td style=""color:red"">{2}</td><td><a href= ""supdateUser.aspx?uid= {3}&uname={4}&role={5}&status={6}"">de/activate</a></td> <td><a href= ""sdeleteUser.aspx?uid= {7}&uname={8}&role={9}&status={10}"">delete</a></td><td><a href= ""smodifyUserPassword.aspx?uid= {11}&uname={12}&role={13}&status={14}"">modify password</a></td> </tr> " , value.userName, verifyRole(value.role), value.status, value.userId, value.userName, value.role, value.status, value.userId, value.userName, value.role, value.status, value.userId, value.userName, value.role, value.status, value.full_name)); } } sb.Append(string.Format(@"</tbody>")); newsLabel.Text = sb.ToString(); db.Dispose(); }
protected void modify_Click(object sender, EventArgs e) { try { string firstPsw = psw.Text; string confirmPsw = cpsw.Text; if (firstPsw == confirmPsw) { niapsEntities1 ctx = new niapsEntities1(); int id = Int32.Parse(Request.QueryString["uid"].ToString()); var result = ctx.adminUsers.FirstOrDefault(us => us.userId == id); result.password = CreateHash(firstPsw); ctx.SaveChanges(); msg.Text = "Password modified successfully"; cpsw.Text = ""; psw.Text = ""; } else { msg.Text = "Password does not match! try again"; } } catch { msg.Text = "Password does not match! try again"; } }
protected void create_Click(object sender, EventArgs e) { try { niapsEntities1 db = new niapsEntities1(); currentStaffRecord cst = new currentStaffRecord(); cst.staffId = sid.Text; cst.designation = designation.Text; cst.department = dept.Text; cst.qualification = qualification.Text; string djDay = doeday.Text; string djMonth = doemonth.Text; string djYear = doeyear.Text; string dateJoined = djDay + "-" + djMonth + "-" + djYear; CultureInfo provider = new CultureInfo("en-US"); Thread.CurrentThread.CurrentCulture = provider; cst.date_Joined = DateTime.Parse(dateJoined); cst.degree = degree.Text; cst.probationPeriod = Int32.Parse(pperiod.Text); cst.dateOfConfirmation = DateTime.Parse(confirm.Text); db.currentStaffRecords.Add(cst); db.SaveChanges(); // db.Dispose(); string message = "Registration Completed Successfully"; Response.Redirect("message.aspx?msg=" + message); } catch (Exception ex) { msg.Text = "Error creating Current Employment Records"; msg.Text += ex; } }
public void getAllStaff() { niapsEntities1 db = new niapsEntities1(); StringBuilder sb = new StringBuilder(); var result = db.staffRecords; sb.Append(string.Format(@"<table class=""table""><thead> <tr><td>Staff Id</td><td>Last Name</td><td >First Name</td><td>Middle Name</td><td>Gender</td><td>Status</td><td colspan=""2""></td></tr></thead><tbody>")); foreach (var value2 in result) { if (value2.status.Equals("active")) { sb.Append(string.Format(@"<tr> <td> {0}</td><td>{1} </td><td> {2}</td><td>{3} </td><td>{4} </td><td>{5} </td><td><a href=""staffDetails.aspx?staffId={6}"">detail</a></td><td><a href=""updateStaff.aspx?staffId={7}"">update</a></td><td><a href=""deactivateStaff.aspx?staffId={8}"">de/activate</a></td> </tr> ", value2.staffId, value2.lName, value2.fName, value2.middleName, value2.gender, value2.status, value2.staffId, value2.staffId, value2.staffId)); } else { sb.Append(string.Format(@"<tr> <td> {0}</td><td>{1} </td><td> {2}</td><td>{3} </td><td>{4} </td><td style=""color:red"">{5} </td><td><a href=""staffDetails.aspx?staffId={6}"">detail</a></td><td><a href=""updateStaff.aspx?staffId={7}"">update</a></td><td><a href=""deactivateStaff.aspx?staffId={8}"">de/activate</a></td> </tr> ", value2.staffId, value2.lName, value2.fName, value2.middleName, value2.gender, value2.status, value2.staffId, value2.staffId, value2.staffId)); } } sb.Append(string.Format(@"</tbody></table>")); staffDetail.Text = sb.ToString(); }
public void getNews() { niapsEntities1 db = new niapsEntities1(); // news ne = new news(); var msg = db.news.OrderByDescending(n => n.date); StringBuilder sb = new StringBuilder(); int i = 1; foreach (var value in msg) { sb.Append(string.Format(@"<table class=""table""> <tr> <td>Title:</td><td>{0} </td> </tr> <tr> <td></td><td>{1}<a href=""newsRoom.aspx"">read more...</a></td> </tr> <tr> <td>Author:</td><td>{2} Date: {3}</td> </tr> <tr> <td></td><td></td> </tr> </table>" , value.postebBy, niaps_ver_1._0.truncString.TruncateAtWord(value.message, 70), value.newsBy, value.date.ToShortDateString())); if (i.Equals(5)) { break; } i++; } news.Text = sb.ToString(); db.Dispose(); }
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"); } niapsEntities1 db = new niapsEntities1(); var query = db.questions; StringBuilder sb = new StringBuilder(); qst.Text = "<table><tr><td>Question No</td><td>Question</td><td>Action</td></tr>"; foreach (var value in query) { sb.Append(string.Format(@" <tr> <td> {0}</td><td>{1} </td><td><a href=""updateQuestion.aspx?qid={2}"">edit</a></td> </tr> ", value.qstId, value.question1, value.id)); qst.Text += sb.ToString(); } qst.Text += "</table>"; }
public static List <adminUser> GetUser() { niapsEntities1 db = new niapsEntities1(); var result = db.adminUsers; return(result.ToList()); }
protected void search_Click(object sender, EventArgs e) { niapsEntities1 db = new niapsEntities1(); StringBuilder sb = new StringBuilder(); string par = param.Text; var result = db.staffRecords.Where(st => st.lName.StartsWith(par) || st.fName.StartsWith(par) || st.middleName.StartsWith(par)); if (result.Any()) { sb.Append(string.Format(@"<table class=""table""><thead> <tr><th>Staff Id</th><th>Last Name</th><th>First Name</th><th>Middle Name</th><th>Gender</th><th>Status</th><th></th></tr></thead><tbody>")); foreach (var value2 in result) { sb.Append(string.Format(@"<tr> <td> {0}</td><td>{1} </td><td> {2}</td><td>{3} </td><td>{4} </td><td>{5} </td><td><a href=""staffDetails.aspx?staffId={6}"">detail</a></td><td><a href=""updateStaff.aspx?staffId={7}"">update</a></td><td><a href=""deactivateStaff.aspx?staffId={8}"">de/activate</a></td> </tr> ", value2.staffId, value2.lName, value2.fName, value2.middleName, value2.gender, value2.status, value2.staffId, value2.staffId, value2.staffId)); } sb.Append(string.Format(@"</tbody></table>")); staffDetail.Text = sb.ToString(); } else { sb.Append(string.Format(@"<table class=""table""> <tr><td Style=""Text-color:Red; Text-align:Center"">No record found</td></tr>")); staffDetail.Text = sb.ToString(); } }
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"); } niapsEntities1 db = new niapsEntities1(); var query = db.currentStaffRecords; StringBuilder sb = new StringBuilder(); foreach (var value in query) { sb.Append(string.Format(@" <tr> <td> {0}</td><td>{1} </td><td> {2}</td><td> {3}</td><td> {4}</td><td> {5}</td><td> {6}</td><td><a href=""updateCurrentStaff.aspx?eid={7}"">update</a></td> </tr> ", value.staffId, value.designation, value.department, value.degree, value.qualification, value.date_Joined, value.dateOfConfirmation, value.Id)); qst.Text += sb.ToString(); } }
public static List <query> GetQuery() { niapsEntities1 db = new niapsEntities1(); var result = db.queries.OrderBy(r => r.dateIssued); return(result.ToList()); }
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"); } niapsEntities1 db = new niapsEntities1(); // news ne = new news(); var query = db.leaves.OrderBy(l => l.startDate); StringBuilder sb = new StringBuilder(); int count = 1; foreach (var value in query) { sb.Append(string.Format(@" <tr> <td> {0}</td><td>{1} </td><td> {2}</td><td>{3} </td><td>{4} </td><td>{5} </td> </tr> ", count, value.name, value.leaveDaysGranted, value.startDate.ToShortDateString(), value.endDate.ToShortDateString(), value.totalUnusedLeaveDays)); count++; } leave.Text = sb.ToString(); }
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"); } niapsEntities1 db = new niapsEntities1(); var query = db.qualifications; StringBuilder sb = new StringBuilder(); foreach (var value in query) { sb.Append(string.Format(@" <tr> <td> {0}</td><td>{1} </td><td> {2}</td><td> {3}</td><td> {4}</td><td><a href=""updateQualification.aspx?qid={5}"">update</a></td> </tr> ", value.staffId, value.typeOfQualification, value.name, value.institution, value.dateObtained, value.qualificationId)); qst.Text += sb.ToString(); } }
protected void btnReview_Click(object sender, EventArgs e) { niapsEntities1 db = new niapsEntities1(); // string sId = Session["staffId"].ToString(); try { string sId = stId.Text; var update = db.answerToQuestions.FirstOrDefault(up => up.staffId == sId); update.answer1 = TextBox1.Text; update.answer2 = TextBox2.Text; update.answer3 = TextBox3.Text; update.answer4 = TextBox4.Text; update.answer5 = TextBox5.Text; update.answer6 = TextBox6.Text; update.answer7 = TextBox7.Text; update.answer8 = TextBox8.Text; update.answer9 = TextBox9.Text; update.answer10 = TextBox10.Text; update.answer11 = TextBox11.Text; update.answer12 = TextBox12.Text; update.answer13 = TextBox13.Text; update.answer14 = TextBox14.Text; update.answer15 = TextBox15.Text; update.answer16 = TextBox16.Text; db.SaveChanges(); msg.Text = "Update Successful"; } catch (Exception) { msg.Text = "Update failed"; } }
public List <staffNextOfKin> getNextOfKin() { niapsEntities1 db = new niapsEntities1(); string sId = Session["staffId"].ToString(); // string sId = Request.QueryString["staffId"].ToString(); var result = db.staffNextOfKins.Where(sr => sr.staffId == sId).ToList(); return(result.ToList()); }
public List <currentStaffRecord> getCurrentEmployment() { niapsEntities1 db = new niapsEntities1(); string sId = Session["staffId"].ToString(); //string sId = Request.QueryString["staffId"].ToString(); var result = db.currentStaffRecords.Where(sr => sr.staffId == sId).ToList(); return(result.ToList()); }
protected void btnPost_Click(object sender, EventArgs e) { niapsEntities1 db = new niapsEntities1(); question qstn = new question(); qstn.question1 = qst.Text; qstn.qstId = Int32.Parse(qstno.Text); db.questions.Add(qstn); db.SaveChanges(); }
protected void btnUser_Click(object sender, EventArgs e) { niapsEntities1 db = new niapsEntities1(); adminUser admu = new adminUser(); if (usname.Text == string.Empty) { unameMsg.Text = "*"; pswMsg.Text = ""; fnameMsg.Text = ""; } else if (psword.Text == string.Empty) { pswMsg.Text = "*"; fnameMsg.Text = ""; unameMsg.Text = ""; } else if (fname.Text == string.Empty) { fnameMsg.Text = "*"; unameMsg.Text = ""; pswMsg.Text = ""; } else { try { var test = db.adminUsers.Where(u => u.userName == usname.Text).First(); if (test.userName != string.Empty) { unameMsg.Text = "user name already taken"; } } catch (Exception) { admu.userName = usname.Text; admu.full_name = fname.Text; admu.password = CreateHash(psword.Text); admu.role = roles.SelectedValue; admu.status = "active"; db.adminUsers.Add(admu); db.SaveChanges(); unameMsg.Text = ""; usname.Text = ""; psword.Text = ""; pswMsg.Text = ""; fname.Text = ""; fnameMsg.Text = ""; roles.Text = "-select-"; msg.Text = "User Created Successfully"; } } }
protected void sname_SelectedIndexChanged(object sender, EventArgs e) { niapsEntities1 db = new niapsEntities1(); string stid = sname.SelectedValue; sid.Text = stid; var other = db.staffRecords.Where(ot => ot.staffId == stid).First(); string firstName = other.fName; string middleName = other.middleName; string onames = firstName + " " + middleName; otherNames.Text = onames; }
protected void sname_SelectedIndexChanged(object sender, EventArgs e) { niapsEntities1 db = new niapsEntities1(); string stid = sname.SelectedValue; var other = db.staffRecords.Where(ot => ot.staffId == stid).First(); string firstName = other.fName; string middleName = other.middleName; string onames = firstName + " " + middleName + " Id: " + stid; otherNames.Text = onames; var bqtn = db.currentStaffRecords.Where(qt => qt.staffId == stid).First(); bq.Text = bqtn.degree + ". " + bqtn.qualification; }
protected void btnUser_Click(object sender, EventArgs e) { string rol = Session["role"].ToString(); string userName = Session["uname"].ToString(); string password = oldPsw.Text; try { using (niapsEntities1 ctx = new niapsEntities1()) { try { var myp = ctx.adminUsers.Where(cp => cp.userName == userName && cp.role == rol).First(); if (ValidatePassword(password, myp.password) == true) { //try //{ string firstPsw = psw.Text; string confirmPsw = cpsw.Text; if (firstPsw == confirmPsw) { int id = myp.userId; var result = ctx.adminUsers.FirstOrDefault(us => us.userId == id); result.password = CreateHash(firstPsw); ctx.SaveChanges(); msg.Text = "Password changed successfully"; cpsw.Text = ""; psw.Text = ""; oldPsw.Text = ""; } } } catch { msg.Text = "Password Confirmation Failed! Your password is wrong"; } } // oldPsw.Text = mycompany.email; } catch (Exception) { msg.Text = "The Passwords did not Match"; } }
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) { } }
public string getOldRecord() { niapsEntities1 db = new niapsEntities1(); string sId = getStaffId(); var staffRec = db.currentStaffRecords.Where(st => st.staffId == sId).First(); string sid = staffRec.staffId; string id = staffRec.Id.ToString(); string des = staffRec.designation; string disc = staffRec.qualification; string dept = staffRec.department; string uname = Session["fullName"].ToString(); var message = " An update occured on Record No:" + id + " by"; message += uname + " Initial Record: Staff Id: " + sid + ", Designation: " + des + ", Discipline:" + disc + ", Department:" + dept; return(message); }
protected void update_Click(object sender, EventArgs e) { niapsEntities1 db = new niapsEntities1(); string i = Request.QueryString["eid"].ToString(); int sid = Int32.Parse(i); var str = db.currentStaffRecords.FirstOrDefault(ai => ai.Id == sid); // DateTime result; str.department = dept.Text; str.designation = designation.Text; str.qualification = disc.Text; str.degree = degree.Text; db.SaveChanges(); msg.Text = "Record updated successfully"; // Response.Redirect("viewCurrentStaffRec.aspx?msg=" + msgs); }
protected void deactivate_Click(object sender, EventArgs e) { niapsEntities1 db = new niapsEntities1(); string stid = Request.QueryString["staffId"]; var update = db.staffRecords.FirstOrDefault(cs => cs.staffId == stid); if (dt.Checked) { update.status = "inactive"; db.SaveChanges(); msg.Text = "staff deactivated"; } else { update.status = "active"; db.SaveChanges(); msg.Text = "staff activated"; } }
protected void Page_Load(object sender, EventArgs e) { niapsEntities1 db = new niapsEntities1(); // news ne = new news(); var msg = db.news.OrderByDescending(n => n.date); int i = 1; StringBuilder sb = new StringBuilder(); foreach (var value in msg) { sb.Append(string.Format(@" <tr> <td>{0}</td><td>{1}</td><td>{2}</td><td>{3}</td><td><a href=""update.aspx?newsId={4}"">update</a></td> </tr> ", i, value.postebBy, value.newsBy, value.date.ToShortDateString(), value.newsId)); i++; } newsLabel.Text = sb.ToString(); db.Dispose(); }
protected void filter_SelectedIndexChanged(object sender, EventArgs e) { niapsEntities1 db = new niapsEntities1(); StringBuilder sb = new StringBuilder(); var result = db.leaves.Where(st => st.staffId == filter.SelectedValue); sb.Append(string.Format(@"<table class=""table""><thead> <tr><td>Staff Id</td><td>Name</td><td>Leave Start Date</td><td>Leave End Date</td><td></td></tr></thead>")); foreach (var value2 in result) { sb.Append(string.Format(@"<tr> <td> {0}</td><td>{1} </td><td> {2}</td><td>{3} </td><td><a href=""updateStaffLeave.aspx?staffId={4}&qid={5}"">update</a></td> </tr> ", value2.staffId, value2.name, value2.startDate.ToShortDateString(), value2.endDate.ToShortDateString(), value2.staffId, value2.leaveId)); } sb.Append(string.Format(@"</table>")); qdetail.Text = sb.ToString(); }
public List <staffRecord> GetStaffDetail() { niapsEntities1 db = new niapsEntities1(); string sId = Session["staffId"].ToString(); var result1 = db.staffRecords.Where(sr => sr.staffId == sId).First(); var result2 = db.states.Where(s => s.stateCode == result1.state).First(); int lgaCode = Int32.Parse(result1.Lga); var result3 = db.LGAs.Where(s3 => s3.LGACode == lgaCode).First(); var result = db.staffRecords.Where(sr => sr.staffId == sId).ToList(); foreach (var mc in result.Where(x => x.state == result1.state)) { mc.state = result2.state1; } foreach (var m in result.Where(x => x.Lga == result1.Lga)) { m.Lga = result3.name; } return(result.ToList()); }