public int Save(Entities.Region e) { DataLayer.Region region = (from r in Context.Regions where r.Id == e.Id select r).FirstOrDefault(); bool isNew = false; if (region == null) { region = new DataLayer.Region(); isNew = true; } region.Text = e.Text; region.CityId = e.CityId; region.DistrictId = e.DistrictId; region.Status = e.Status; region.NeighborId = e.NeighborId; try { if (isNew) { Context.Regions.InsertOnSubmit(region); } Context.SubmitChanges(); return(region.Id); } catch (Exception ex) { string data = className + ex.Message.ToString(); Logs.LogWrite(string.Format(Configs.ERROR_ACTION, data)); return((int)Enums.Errors.EXIST); } }
public int Update(Entities.Region e) { DataLayer.Region region = (from p in Context.Regions where p.Id == e.Id select p).FirstOrDefault(); if (region == null) { return((int)Enums.Errors.NOT_EXIST); } region.Text = e.Text; region.CityId = e.CityId; region.DistrictId = e.DistrictId; region.Status = e.Status; region.NeighborId = e.NeighborId; try { Context.SubmitChanges(); return(region.Id); } catch (Exception ex) { string data = className + ex.Message.ToString(); Logs.LogWrite(string.Format(Configs.ERROR_ACTION, data)); return((int)Enums.Errors.EXIST); } }
public int Insert(Entities.Region e) { DataLayer.Region p = new DataLayer.Region(); p.Text = e.Text; p.CityId = e.CityId; p.DistrictId = e.DistrictId; p.Status = e.Status; p.NeighborId = e.NeighborId; try { Context.Regions.InsertOnSubmit(p); Context.SubmitChanges(); } catch (Exception ex) { string data = className + ex.Message.ToString(); Logs.LogWrite(string.Format(Configs.ERROR_ACTION, data)); return((int)Enums.Errors.INSERT_ERROR); } return(p.Id); }
public int Delete(int id) { try { DataLayer.Region region = (from u in Context.Regions where u.Id == id select u).FirstOrDefault(); if (region != null) { Context.Regions.DeleteOnSubmit(region); Context.SubmitChanges(); return(id); } else { return((int)Enums.Errors.NOT_EXIST); } } catch { return((int)Enums.Errors.DELETE_ERROR); } }