public static Responses Update(M_SouvenirViewModel entity) { Responses result = new Responses(); try { using (var db = new MarcomContext()) { if (entity.Id != 0) { m_souvenir souvenir = db.m_souvenir.Where(o => o.id == entity.Id).FirstOrDefault(); if (souvenir != null) { souvenir.id = entity.Id; souvenir.code = entity.Code; souvenir.name = entity.Name; souvenir.description = entity.Description; souvenir.m_unit_id = entity.mUnitId; souvenir.is_delete = entity.isDelete; souvenir.updated_by = "Asyam"; souvenir.updated_date = DateTime.Now; db.SaveChanges(); } } else { m_souvenir souvenir = new m_souvenir(); souvenir.id = entity.Id; souvenir.code = entity.Code; souvenir.name = entity.Name; souvenir.description = entity.Description; souvenir.m_unit_id = entity.mUnitId; souvenir.is_delete = false; souvenir.created_by = "Asyam"; souvenir.created_date = DateTime.Now; db.m_souvenir.Add(souvenir); db.SaveChanges(); } } } catch (Exception ex) { result.Message = ex.Message; result.Success = false; } return(result); }
public static bool Delete(int id) { bool res = false; using (AppEntity db = new AppEntity()) { m_souvenir data = db.m_souvenir.Find(id); data.id = data.id; data.code = data.code; data.name = data.name; data.is_active = false; data.updated_by = 1; data.updated_date = DateTime.Now; try { db.SaveChanges(); res = true; } catch (Exception) { throw; } } return(res); }
public static bool Update(MSouvenirVM model) { bool res = false; using (AppEntity db = new AppEntity()) { m_souvenir data = db.m_souvenir.Find(model.id); data.code = model.code; data.name = model.name; data.description = model.description; data.m_unit_id = model.m_unit_id; data.updated_by = 1; data.updated_date = DateTime.Now; try { db.SaveChanges(); res = true; } catch (Exception) { throw; } } return(res); }
public static bool Insert(MSouvenirVM model) { bool res = false; using (AppEntity db = new AppEntity()) { m_souvenir data = new m_souvenir() { code = model.code, name = model.name, description = model.description, m_unit_id = model.m_unit_id, created_by = 1, created_date = DateTime.Now, is_active = true }; db.m_souvenir.Add(data); try { db.SaveChanges(); res = true; } catch (Exception) { throw; } } return(res); }
public static Responses Delete(int id) { Responses result = new Responses(); try { using (var db = new MarcomContext()) { m_souvenir souvenir = db.m_souvenir.Where(o => o.id == id).FirstOrDefault(); if (souvenir != null) { souvenir.is_delete = true; db.SaveChanges(); } } } catch (Exception ex) { result.Message = ex.Message; result.Success = false; } return(result); }
public static string CreateSouvenir(SouvenirViewModel paramDataSou) { string latestSaveCode = string.Empty; using (var db = new MarkomApplicationDBEntities()) { using (var dbContextTransaction = db.Database.BeginTransaction()) { try { m_souvenir c = new m_souvenir(); c.code = SouvenirCode(); c.name = paramDataSou.name; c.m_unit_id = paramDataSou.mUnitId; c.description = paramDataSou.description; c.is_delete = paramDataSou.isDelete; c.create_by = paramDataSou.createBy; c.create_date = paramDataSou.createDate; db.m_souvenir.Add(c); db.SaveChanges(); dbContextTransaction.Commit(); //get latest save code latestSaveCode = c.code; } catch (Exception ex) { Message = ex.Message; dbContextTransaction.Rollback(); //throw; } } } return(latestSaveCode); }