//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());
}
