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