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 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();
}
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 activate_Click(object sender, EventArgs e)
{
try
{
var idc = db.indicators.FirstOrDefault(ic => ic.IndicatorId == "fi");
idc.quarter = qtr.SelectedValue;
idc.year = yr.SelectedValue;
db.SaveChanges();
db.Dispose();
System.Web.HttpContext.Current.Response.Write(string.Format(@"<SCRIPT LANGUAGE=""JavaScript"">alert(""indicator added successfully... click OK to continue!"")</SCRIPT>"));
System.Web.HttpContext.Current.Response.Write(string.Format(@"<SCRIPT LANGUAGE=""JavaScript"">alert(window.location = ""superAdminDashboard.aspx"") </SCRIPT>"));
}
catch (Exception) {
msg.Text = "update failed... pls, try again";
}
}
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 btnPost_Click(object sender, EventArgs e)
{
if (author.Text == string.Empty)
{
aError.Text = "*";
}
else if (postBy.Text == string.Empty)
{
tError.Text = "*";
}
else if (news.Text == string.Empty)
{
nError.Text = "*";
}
else
{
try
{
news ne = new news();
ne.newsBy = author.Text;
ne.postebBy = postBy.Text;
ne.message = news.Text;
DateTime dt = DateTime.Now;
ne.date = dt;
db.news.Add(ne);
db.SaveChanges();
db.Dispose();
System.Web.HttpContext.Current.Response.Write(string.Format(@"<SCRIPT LANGUAGE=""JavaScript"">alert(""News Posted Successfully... click OK to continue!"")</SCRIPT>"));
System.Web.HttpContext.Current.Response.Write(string.Format(@"<SCRIPT LANGUAGE=""JavaScript"">alert(window.location = ""postNews.aspx"") </SCRIPT>"));
// msg.Text = "News posted successfully";
author.Text = "";
postBy.Text = "";
news.Text = "";
}
catch (Exception)
{
msg.Text = "News failed";
}
}
}
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)
{
int nId = Int32.Parse(Request.QueryString["newsId"].ToString());
var rnews = db.news.Where(rn => rn.newsId == nId).First();
author.Text = rnews.newsBy;
postBy.Text = rnews.postebBy;
news.Text = rnews.message;
db.Dispose();
// if (stat.Equals("active")) { dt.Checked = false; } else { dt.Checked = true; }
}
}
protected void Page_Load(object sender, EventArgs e)
{
niapsEntities1 db = new niapsEntities1();
// news ne = new news();
var msg = db.staffUpdateHistories.OrderByDescending(n => n.updatDate);
StringBuilder sb = new StringBuilder();
foreach (var value in msg)
{
sb.Append(string.Format(@"<table class=""table"">
<tr>
<td>Staff ID:</td><td>{0} </td>
</tr>
<tr>
<td>Staff Name:</td><td>{1}</td>
</tr>
<tr>
<td>Description:</td><td>{2} Date Mordified: {3}</td>
</tr>
</table>" , value.staffId, value.updatedBy, value.description, value.updatDate.ToShortDateString()));
}
sArchive.Text = sb.ToString();
db.Dispose();
}
protected void Page_Load(object sender, EventArgs e)
{
niapsEntities1 db = new niapsEntities1();
// news ne = new news();
var msg = db.assetUpdateHistories.OrderByDescending(n => n.updateDate);
StringBuilder sb = new StringBuilder();
foreach (var value in msg)
{
sb.Append(string.Format(@"<table class=""table"">
<tr>
<td>Asset ID:</td><td>{0} </td>
</tr>
<tr>
<td>Description:</td><td>{1}</td>
</tr>
<tr>
<td>Date:</td><td>{2}</td>
</tr>
</table>" , value.assetId, value.message, value.updateDate.ToShortDateString()));
}
aArchive.Text = sb.ToString();
db.Dispose();
}
protected void Page_Load(object sender, EventArgs e)
{
niapsEntities1 db = new niapsEntities1();
// news ne = new news();
var msg = db.news.OrderByDescending(n => n.date);
StringBuilder sb = new StringBuilder();
foreach (var value in msg)
{
sb.Append(string.Format(@"<table id=""box-table-a"">
<tr>
<td>Title:</td><td>{0} </td>
</tr>
<tr>
<td></td><td>{1}</td>
</tr>
<tr>
<td>Author:</td><td>{2} Date: {3}</td>
</tr>
</table>" , value.postebBy, value.message, value.newsBy, value.date.ToShortDateString()));
}
newsLabel.Text = sb.ToString();
db.Dispose();
}
