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"; } }