protected void create_Click(object sender, EventArgs e)
{
try{
qualification qu = new qualification();
qu.staffId = sid.Text;
qu.name = basicQ.Text;
string day = qday.Text;
string month = qmonth.Text;
string year = qyear.Text;
string result = day + "-" + month + "-" + year;
CultureInfo provider = new CultureInfo("en-US");
Thread.CurrentThread.CurrentCulture = provider;
DateTime dateo = DateTime.Parse(result);
qu.dateObtained = dateo;
qu.typeOfQualification = degree.Text;
qu.institution = inst.Text;
db.qualifications.Add(qu);
db.SaveChanges();
Response.Redirect("enterEmploymentRecord.aspx?staffId=" + sid.Text);
}
catch (Exception ex)
{
msg.Text = ex.Message;
}
}
public void DeleteQualification(int id)
{
qualification qualificsToDelete = MCDB.qualifications.Where(x => x.qualification_id == id).FirstOrDefault();
MCDB.qualifications.Remove(qualificsToDelete);
MCDB.SaveChanges();
}
public async Task <IHttpActionResult> Putqualification(int id, qualification qualification)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != qualification.idQualification)
{
return(BadRequest());
}
db.Entry(qualification).State = EntityState.Modified;
try
{
await db.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!qualificationExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public JsonResult Edit(qualification QualificationObj)
{
try
{
QualificationObj.date_of_entry = DateTime.Now;
var db = new qhsedbEntities();
if (ModelState.IsValid)
{
QualificationObj.id = QualificationObj.id;
db.Entry(QualificationObj).State = EntityState.Modified;
// loanRequest.LoanDate = loanRequest.LoanDate;
db.SaveChanges();
}
return(Json("Edited Qualification System", JsonRequestBehavior.AllowGet));
}
catch (Exception e)
{
return(Json(e.Message, JsonRequestBehavior.AllowGet));
}
}
public ActionResult SaveAdmin()
{
string strRet;
uls_dbDataContext db = new uls_dbDataContext();
string adminType = Request.Form["hdnAdminType"];
string strID;
string strDescr = Request.Form["txtDescription"];
string strCompany = Request.Form["ddlAdminCompany"];
string strOperation = Request.Form["hdnAdminOper"];
try
{
if (adminType == "AdminCertifications")
{
qualification qual;
if (strOperation == "Add")
{
strID = Request.Form["txtID"];
qual = new qualification();
qual.qualID = strID;
qual.qualDesc = strDescr;
qual.qualCompany = strCompany;
db.qualifications.InsertOnSubmit(qual);
}
else
{
strID = Request.Form["hdnAdminID"];
qual = db.qualifications.Single(q => q.qualID == strID);
qual.qualDesc = strDescr;
}
}
db.SubmitChanges();
strRet = "Success";
}
catch (Exception ex)
{
string msg = ex.Message;
strRet = msg;
}
finally
{
db.Dispose();
}
return(Content(strRet));
}
//adding a course
public void AddQualification(qualificationVM _qualficVM)
{
qualification qualifcToAdd = new qualification();
qualifcToAdd.qualification_id = _qualficVM.qualification_id;
qualifcToAdd.qualification_name = _qualficVM.qualification_name;
qualifcToAdd.qualification_date = _qualficVM.qualification_date;
qualifcToAdd.organization = _qualficVM.organization;
MCDB.qualifications.Add(qualifcToAdd);
MCDB.SaveChanges();
}
public async Task <IHttpActionResult> Getqualification(int id)
{
qualification qualification = await db.qualifications.FindAsync(id);
if (qualification == null)
{
return(NotFound());
}
return(Ok(qualification));
}
public IHttpActionResult Getqualification(int id)
{
qualification qualification = db.qualifications.Find(id);
if (qualification == null)
{
return(NotFound());
}
return(Ok(qualification));
}
public async Task <IHttpActionResult> Postqualification(qualification qualification)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.qualifications.Add(qualification);
await db.SaveChangesAsync();
return(CreatedAtRoute("DefaultApi", new { id = qualification.idQualification }, qualification));
}
//updating news
public void UpdateQualifications(qualificationVM qualifics)
{
qualification qualificsToUpdate = MCDB.qualifications.FirstOrDefault(x => x.qualification_id == qualifics.qualification_id);
//MCDB.Entry(courseToDelete).State = System.Data.Entity.EntityState.Modified;
qualificsToUpdate.qualification_id = qualifics.qualification_id;
qualificsToUpdate.qualification_name = qualifics.qualification_name;
qualificsToUpdate.qualification_date = qualifics.qualification_date;
qualificsToUpdate.organization = qualifics.organization;
MCDB.SaveChanges();
}
public IHttpActionResult Postqualification(qualification qualification)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.qualifications.Add(qualification);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = qualification.Qid }, qualification));
}
public ActionResult Create(qualification qualifications)
{
if (ModelState.IsValid)
{
var db = new qhsedbEntities();
db.qualifications.Add(qualifications);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(qualifications));
}
public async Task <IHttpActionResult> Deletequalification(int id)
{
qualification qualification = await db.qualifications.FindAsync(id);
if (qualification == null)
{
return(NotFound());
}
db.qualifications.Remove(qualification);
await db.SaveChangesAsync();
return(Ok(qualification));
}
public IHttpActionResult Deletequalification(int id)
{
qualification qualification = db.qualifications.Find(id);
if (qualification == null)
{
return(NotFound());
}
db.qualifications.Remove(qualification);
db.SaveChanges();
return(Ok(qualification));
}
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
var db = new qhsedbEntities();
qualification qualifications = db.qualifications.Find(id);
if (qualifications == null)
{
return(HttpNotFound());
}
return(View(qualifications));
}
public qualificationVM getQualificssById(int id)
{
qualification qualificsToGet = MCDB.qualifications.Where(x => x.qualification_id == id).FirstOrDefault();
qualificationVM _qualificsVM = new qualificationVM();
if (qualificsToGet != null)
{
_qualificsVM.qualification_id = qualificsToGet.qualification_id;
_qualificsVM.qualification_name = qualificsToGet.qualification_name;
_qualificsVM.qualification_date = qualificsToGet.qualification_date;
_qualificsVM.organization = qualificsToGet.organization;
return(_qualificsVM);
}
else
{
return(null);
}
}
public JsonResult AddQualification(qualification QualificationObj)
{
try
{
QualificationObj.date_of_entry = DateTime.Now;
var db = new qhsedbEntities();
db.qualifications.Add(QualificationObj);
db.SaveChanges();
return(Json("Added New Qualification Entry Successfully", JsonRequestBehavior.AllowGet));
}
catch (Exception e)
{
return(Json(e.Message, JsonRequestBehavior.AllowGet));
}
}
public ActionResult DeleteAdminQual(string id)
{
uls_dbDataContext db = new uls_dbDataContext();
string strRet;
try
{
qualification qual = db.qualifications.Single(q => q.qualID == id);
db.qualifications.DeleteOnSubmit(qual);
db.SubmitChanges();
strRet = "Success";
}
catch (Exception)
{
strRet = "Failure";
}
return(Content(strRet));
}
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
var db = new qhsedbEntities();
qualification qualifications = db.qualifications.Find(id);
if (qualifications == null)
{
return(HttpNotFound());
}
var QualificationRow = db.qualifications.Find(id);
db.qualifications.Remove(QualificationRow);
db.SaveChanges();
return(RedirectToAction("Index"));
}
protected void create_Click(object sender, EventArgs e)
{
if (sid.Text == string.Empty)
{
sidError.Text = "*";
}
else if (fname.Text == string.Empty)
{
fnameError.Text = "*";
}
else if (mname.Text == string.Empty)
{
mError.Text = "*";
}
else if (lname.Text == string.Empty)
{
lError.Text = "*";
}
else if (dob.Text == string.Empty)
{
dobError.Text = "*";
}
else if (gender.Text.Equals("-select-"))
{
genderError.Text = "*";
}
else if (ms.Text.Equals("-select-"))
{
msError.Text = "*";
}
else if (mobile.Text == string.Empty)
{
mobileError.Text = "*";
}
else if (addr.Text == string.Empty)
{
addrError.Text = "*";
}
else if (email.Text == string.Empty)
{
eError.Text = "*";
}
else if (foid.Text == string.Empty)
{
msg.Text = "*";
}
else if (basicQ.Text == string.Empty)
{
bqError.Text = "*";
}
else if (inst.Text == string.Empty)
{
iError.Text = "*";
}
else if (degree.Text == string.Empty)
{
dgError.Text = "*";
}
else if (ddLga.Text.Equals("-select-"))
{
lgaError.Text = "*";
}
else if (ddState.Text.Equals("-select-"))
{
lgaError.Text = "*";
}
else if (rel.Text == string.Empty)
{
relError.Text = "*";
}
else if (phone.Text == string.Empty)
{
gsmError.Text = "*";
}
else if (kaddr.Text == string.Empty)
{
kaddrError.Text = "*";
}
else if (sex.Text.Equals("-select-"))
{
sexError.Text = "*";
}
else if (klname.Text == string.Empty)
{
klnError.Text = "*";
}
else if (userName.Text == string.Empty)
{
userError.Text = "*";
}
// else if (dop.Text == string.Empty) { msg.Text = "*"; }
else if (txtFile.FileName == string.Empty)
{
pp.Text = "*";
}
else if (kfname.Text == string.Empty)
{
kfnError.Text = "*";
}
else
{
string dateOB = dob.Text;
string dateO = dop.Text;
DateTime dateOfBirth = DateTime.Parse(dateOB);
DateTime dateOptained = DateTime.Parse(dateO);
int i = dateOptained.Year - dateOfBirth.Year;
if (i < 14)
{
dateError.Text = "invalid date";
}
staffRecord sr = new staffRecord();
try
{
sr.staffId = sid.Text;
sr.fName = fname.Text;
sr.lName = lname.Text;
sr.gender = gender.SelectedValue;
string dateString = dob.Text;
DateTime result;
result = DateTime.Parse(dateString);
sr.dateOfBirth = result;
string staffAge = ((DateTime.Now.Year) - (result.Year)).ToString();
sr.email = email.Text;
sr.mobile = mobile.Text;
sr.address = addr.Text;
sr.state = ddState.SelectedValue.ToString();
sr.Lga = ddLga.SelectedValue.ToString();
sr.middleName = mname.Text;
sr.marritalStatus = ms.Text;
sr.formOfIdentification = foid.Text;
string theFile = txtFile.PostedFile.FileName;
string filepath = MapPath("images/") + theFile;
try
{
txtFile.PostedFile.SaveAs(filepath);
}
catch (Exception)
{
msg.Text = "Record was not saved!";
// msg.Text += fx.Message;
}
sr.passport = "~/PrivateWeb/images/" + theFile.ToString();
sr.age = Int32.Parse(staffAge);
sr.idNumber = pid.Text;
sr.status = "active";
db.staffRecords.Add(sr);
db.SaveChanges();
//populate user table with staff login parameters
user use = new user();
use.email = email.Text;
use.staffId = sid.Text;
use.role = "staff";
use.username = userName.Text;
string temPsw = randomPsw();
use.password = CreateHash(temPsw);
use.status = "active";
db.users.Add(use);
db.SaveChanges();
qualification qu = new qualification();
string bq = basicQ.Text;
string dg = degree.Text;
Session["basicqualification"] = bq;
Session["degree"] = dg;
qu.staffId = sid.Text;
qu.name = basicQ.Text;
if (dop.Text != string.Empty)
{
string result2 = dop.Text;
DateTime dateo = DateTime.Parse(result2);
qu.dateObtained = dateo;
}
else
{
dateError.Text = "*";
}
qu.typeOfQualification = degree.Text;
qu.institution = inst.Text;
db.qualifications.Add(qu);
db.SaveChanges();
// Response.Redirect("enterEmploymentRecord.aspx?staffId=" + sid.Text);
staffNextOfKin st = new staffNextOfKin();
st.staffId = sid.Text;
st.fName = kfname.Text;
st.lname = klname.Text;
st.gender = sex.Text;
st.address = kaddr.Text;
st.contactMobile = phone.Text;
st.relationship = rel.Text;
db.staffNextOfKins.Add(st);
db.SaveChanges();
pendingLeave pl = new pendingLeave();
pl.staffId = sid.Text;
pl.staffPendingLeave = 0;
db.pendingLeaves.Add(pl);
db.SaveChanges();
try
{
System.Net.Mail.MailMessage mail = new System.Net.Mail.MailMessage();
mail.To.Add(email.Text);
mail.From = new MailAddress("*****@*****.**", "NIAPS", System.Text.Encoding.UTF8);
mail.Subject = "Your NIAPS Logon Detail";
mail.SubjectEncoding = System.Text.Encoding.UTF8;
mail.Body = "Your account details on NIA Personnel System (NIAPS) are: <b />user name =" + userName.Text + " <b />password ="******"*****@*****.**", "niaps123");
client.Port = 587;
client.Host = "smtp.gmail.com";
client.EnableSsl = true;
client.Send(mail);
Response.Redirect("enterEmploymentRecord.aspx?staffId=" + sid.Text + "&lname=" + lname.Text + "&fname=" + fname.Text + "&mname=" + mname.Text + "&bq=" + bq + "°ree=" + dg);
}
catch (Exception) {
Response.Redirect("enterEmploymentRecord.aspx?staffId=" + sid.Text + "&lname=" + lname.Text + "&fname=" + fname.Text + "&mname=" + mname.Text + "&bq=" + bq + "°ree=" + dg);
}
}
catch (FormatException)
{
msg.Text = "error, Could not create staff";
}
catch (Exception)
{
msg.Text = "Could not create staff.. Staff already exist";
}
}
}
protected void create_Click(object sender, EventArgs e)
{
if (basicQ.Text.Equals("") || basicQ.Text.Equals(null))
{
bqError.Text = "*";
}
if (degree.Text.Equals("-select-") || degree.Text.Equals(null))
{
degreeError.Text = "*";
}
if ((dateO.Text.Equals("") || dateO.Text.Equals(null)))
{
dateError.Text = "*";
}
if (inst.Text.Equals("") || inst.Text.Equals(null))
{
instError.Text = "*";
}
if (sname.Text.Equals("") || sname.Text.Equals(null))
{
snameError.Text = "*";
}
try
{
qualification qu = new qualification();
string stid = sname.SelectedValue;
qu.staffId = stid;
qu.name = basicQ.Text;
string result = dateO.Text;
CultureInfo provider = new CultureInfo("en-US");
Thread.CurrentThread.CurrentCulture = provider;
DateTime dateo = DateTime.Parse(result);
qu.dateObtained = dateo;
qu.typeOfQualification = degree.Text;
qu.institution = inst.Text;
db.qualifications.Add(qu);
db.SaveChanges();
// msg.Text = "Additional Qualification created Successfully";
System.Web.HttpContext.Current.Response.Write(string.Format(@"<SCRIPT LANGUAGE=""JavaScript"">alert(""Additional Qualification created Successfully... click OK to continue!"")</SCRIPT>"));
System.Web.HttpContext.Current.Response.Write(string.Format(@"<SCRIPT LANGUAGE=""JavaScript"">alert(window.location = ""furtherQualification.aspx"") </SCRIPT>"));
bqError.Text = "";
degreeError.Text = "";
dateError.Text = "";
instError.Text = "";
snameError.Text = "";
degree.Text = "-select-";
inst.Text = "";
basicQ.Text = "";
dateO.Text = "";
// Response.Redirect("furtherQualification.aspx");
}
catch (Exception)
{
msg.Text = "Could not create Additional Qualification";
}
}
