public StateModel SaveState(StateModel _objdata) { tbl_States _objState = new tbl_States(); try { using (newconecommerce dataContext = new newconecommerce()) { dataContext.Database.Connection.Open(); _objState.v_State = _objdata.strStateName; _objState.int_CountryId = _objdata.intCountryId; _objState.dt_Created_On = DateTime.Now; _objState.b_IsActive = true; dataContext.tbl_States.Add(_objState); dataContext.SaveChanges(); dataContext.Database.Connection.Close(); _objdata.StatusMessaage = "State save sucessfully."; return(_objdata); } } catch (Exception ex) { throw ex; } }
public StateModel UpdateState(StateModel _objdata) { tbl_States _objproduct = new tbl_States(); try { using (newconecommerce dataContext = new newconecommerce()) { dataContext.Database.Connection.Open(); var _query = dataContext.tbl_States.Where(x => x.int_Id == _objdata.intStateId).FirstOrDefault(); if (_query != null) { tbl_States _log = new tbl_States(); _log = dataContext.tbl_States.Where(x => x.int_Id == _objdata.intStateId).FirstOrDefault(); _log.v_State = _objdata.strStateName; _log.int_CountryId = _objdata.intCountryId; dataContext.SaveChanges(); dataContext.Database.Connection.Close(); } _objdata.StatusMessaage = "State Updated sucessfully."; return(_objdata); } } catch (Exception ex) { throw ex; } }
public StateModel DeleteState(int intStateId) { StateModel _objdata = new StateModel(); tbl_States _objState = new tbl_States(); try { using (newconecommerce dataContext = new newconecommerce()) { dataContext.Database.Connection.Open(); var _query = dataContext.tbl_States.Where(x => x.int_Id == intStateId).FirstOrDefault(); if (_query != null) { tbl_States _log = new tbl_States(); _log = dataContext.tbl_States.Where(x => x.int_Id == intStateId).FirstOrDefault(); _log.b_IsActive = false; dataContext.SaveChanges(); dataContext.Database.Connection.Close(); } _objdata.StatusMessaage = "State deleted sucessfully."; return(_objdata); } } catch (Exception) { throw; } }