public int SaveNewCertificate(CertificateViewModel vmCert, string loggedInUser) { SSDF_Certificate sDF_Certificate = new SSDF_Certificate(); sDF_Certificate.CertificateDate = vmCert.CertificateDate; //sDF_Certificate.CertificateID = vmCert.CertificateID; sDF_Certificate.CertificateLevel = vmCert.Certifikat; sDF_Certificate.CertificateNumber = vmCert.CertifikatNummer; sDF_Certificate.FirstName = vmCert.Förnamn; sDF_Certificate.LastName = vmCert.Efternamn; sDF_Certificate.PersonNo = vmCert.Personnummer; sDF_Certificate.Instructor = vmCert.Instruktör; //TODO Fixa sDF_Certificate.CreatedBy = loggedInUser; sDF_Certificate.CreatedDate = DateTime.Now; sDF_Certificate.LastEditBy = loggedInUser; sDF_Certificate.LastEditDate = DateTime.Now; try { db.SSDF_Certificate.Add(sDF_Certificate); db.SaveChanges(); } catch (Exception ex) { return(99); } return(0); }
public int SaveEditCertificate(CertificateViewModel vmCert, string loggedInUser) { SSDF_Certificate sDF_Certificate = db.SSDF_Certificate.Find(vmCert.CertificateID); sDF_Certificate.CertificateDate = vmCert.CertificateDate; sDF_Certificate.CertificateID = vmCert.CertificateID; sDF_Certificate.CertificateLevel = vmCert.Certifikat; sDF_Certificate.CertificateNumber = vmCert.CertifikatNummer; sDF_Certificate.FirstName = vmCert.Förnamn; sDF_Certificate.LastName = vmCert.Efternamn; sDF_Certificate.PersonNo = vmCert.Personnummer; sDF_Certificate.Instructor = vmCert.Instruktör; //TODO Fixa sDF_Certificate.LastEditBy = loggedInUser; sDF_Certificate.LastEditDate = DateTime.Now; try { db.Entry(sDF_Certificate).State = EntityState.Modified; db.SaveChanges(); } catch (Exception ex) { return(99); } return(0); }
public ActionResult DeleteConfirmed(int id) { SSDF_Certificate sSDF_Certificate = db.SSDF_Certificate.Find(id); db.SSDF_Certificate.Remove(sSDF_Certificate); db.SaveChanges(); return(RedirectToAction("Index")); }
// GET: SSDF_Certificate/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } SSDF_Certificate sSDF_Certificate = db.SSDF_Certificate.Find(id); if (sSDF_Certificate == null) { return(HttpNotFound()); } return(View(sSDF_Certificate)); }
public CertificateViewModel(SSDF_Certificate cert) { CertificateID = cert.CertificateID; CertificateDate = cert.CertificateDate; Certifikat = cert.CertificateLevel; Förnamn = cert.FirstName; Efternamn = cert.LastName; Personnummer = cert.PersonNo; CertifikatNummer = cert.CertificateNumber; Instruktör = cert.Instructor; CertPicture = addPicture(cert.CertificateLevel); Instruktörsnummer = cert.InstructorNo; MachineId = cert.MachineID; }
public CertificateViewModel FindCertificateById(int?id) { if (id == null) { return(null); } SSDF_Certificate sSDF_Certificate = db.SSDF_Certificate.Find(id); var vmcert = new CertificateViewModel(sSDF_Certificate); vmcert.CertCodes = db.SSDF_CertCodes.Select(x => new System.Web.Mvc.SelectListItem { Value = x.CertCode, Text = x.Description }); return(vmcert); }