public static bool saveData(VMSertifikasi sert)
{
try
{
using (DBSpecEntities db = new DBSpecEntities())
{
x_sertifikasi dt = new x_sertifikasi();
dt.created_by = 098765;
dt.created_on = System.DateTime.Now;
dt.is_delete = false;
dt.certificate_name = sert.certificate_name;
dt.publisher = sert.publisher;
dt.valid_start_month = sert.valid_start_month;
dt.valid_start_year = sert.valid_start_year;
dt.until_month = sert.until_month;
dt.until_year = sert.until_year;
dt.notes = sert.notes;
dt.id = sert.id;
dt.biodata_id = sert.id_biodata;
db.x_sertifikasi.Add(dt);
db.SaveChanges();
//x_biodata dt2 = new x_biodata();
//dt2.id = sert.id;
//db.x_biodata.Add(dt2);
//db.SaveChanges();
//x_biodata dt2 = new x_biodata();
//dt2.id = sert.biodata_id;
//db.x_biodata.Add(dt2);
//db.SaveChanges();
//x_biodata dt2 = new x_biodata();
//dt2.id = sert.biodata_id;
//db.x_biodata.Add(dt2);
//db.SaveChanges();
}
return(true);
}
catch (Exception)
{
return(false);
throw;
}
}
public static bool deleteData(long id)
{
try
{
using (DBSpecEntities db = new DBSpecEntities())
{
x_sertifikasi dt = db.x_sertifikasi.Where(a => a.id == id).FirstOrDefault();
dt.is_delete = true;
db.Entry(dt).State = EntityState.Modified;
db.SaveChanges();
}
return(true);
}
catch (Exception)
{
return(false);
throw;
}
}
public static ResponseResult Delete(SertifikasiViewModel entity)
{
//id -->categoryId
//CategoryViewModel entity --> int id
ResponseResult result = new ResponseResult();
try
{
using (var db = new WFHContext())
{
x_sertifikasi sertifikasi = db.x_sertifikasi
.Where(o => o.id == entity.id)
.FirstOrDefault();
if (sertifikasi != null)
{
//db.x_sertifikasi.Remove(sertifikasi);
sertifikasi.is_delete = true;
sertifikasi.deleted_on = DateTime.Now;
sertifikasi.deleted_by = entity.user_id;
db.SaveChanges();
result.Entity = entity;
}
else
{
result.Success = false;
result.Message = "sertifikasi not found";
}
}
}
catch (Exception ex)
{
result.Success = false;
result.Message = ex.Message;
}
return(result);
}
public static bool updateData(VMSertifikasi sert)
{
try
{
using (DBSpecEntities db = new DBSpecEntities())
{
x_sertifikasi dt = db.x_sertifikasi.Where(a => a.id == sert.id).FirstOrDefault();
dt.certificate_name = sert.certificate_name;
dt.publisher = sert.publisher;
dt.valid_start_month = sert.valid_start_month;
dt.valid_start_year = sert.valid_start_year;
dt.until_month = sert.until_month;
dt.until_year = sert.until_year;
dt.notes = sert.notes;
//dt.modified_by = sert.modified_by;
//dt.modified_on = System.DateTime.Now;
//dt.deleted_by = sert.deleted_by;
//dt.deleted_on = System.DateTime.Now;
//dt.created_by = sert.created_by;
//dt.created_on = System.DateTime.Now;
dt.biodata_id = sert.id;
db.Entry(dt).State = EntityState.Modified;
db.SaveChanges();
}
return(true);
}
catch (Exception)
{
return(false);
throw;
}
}
public static ResponseResult Update(SertifikasiViewModel entity)
{
ResponseResult result = new ResponseResult();
try
{
using (var db = new WFHContext())
{
#region Create New/ Insert
if (entity.id == 0)
{
x_sertifikasi sertifikasi = new x_sertifikasi();
sertifikasi.certificate_name = entity.certificate_name;
sertifikasi.publisher = entity.publisher;
sertifikasi.valid_start_year = entity.valid_start_year;
sertifikasi.valid_start_month = entity.valid_start_month;
sertifikasi.until_year = entity.until_year;
sertifikasi.until_month = entity.until_month;
sertifikasi.created_by = entity.user_id;
sertifikasi.created_on = DateTime.Now;
sertifikasi.is_delete = false;
sertifikasi.biodata_id = entity.biodata_id;
sertifikasi.notes = entity.notes;
db.x_sertifikasi.Add(sertifikasi);
db.SaveChanges();
result.Entity = entity;
}
#endregion Edit
#region
else
{
x_sertifikasi sertifikasi = db.x_sertifikasi //
.Where(o => o.id == entity.id)
.FirstOrDefault();
if (sertifikasi != null) // category bisa ditulis cat saja
{
//disini ditulis semua nama tabelnya
sertifikasi.certificate_name = entity.certificate_name;
sertifikasi.publisher = entity.publisher;
sertifikasi.valid_start_year = entity.valid_start_year;
sertifikasi.valid_start_month = entity.valid_start_month;
sertifikasi.modified_by = entity.user_id;
sertifikasi.modified_on = DateTime.Now;
sertifikasi.until_year = entity.until_year;
sertifikasi.until_month = entity.until_month;
sertifikasi.notes = entity.notes;
sertifikasi.biodata_id = entity.biodata_id;
db.SaveChanges();
result.Entity = entity;
}
else
{
result.Success = false;
result.Message = "sertifikasi not found";
}
}
#endregion
}
}
catch (Exception ex)
{
result.Success = false;
result.Message = ex.Message;
}
return(result);
}
