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