public ApiResponse <StateMasterModel> GetStateDetail(int?stateid) { var response = new ApiResponse <StateMasterModel>(); List <StateMasterModel> stateModelList = new List <StateMasterModel>(); try { if (stateid == 0) { StateMasterModel StateModel = new StateMasterModel(); stateModelList.Add(StateModel); } else { var StateIDParam = new SqlParameter { ParameterName = "StateID", DbType = DbType.Int32, Value = (object)stateid ?? DBNull.Value }; stateModelList = _repository.ExecuteSQL <StateMasterModel>("usp_mst_StateMaster_get", StateIDParam).ToList(); } response.Success = true; response.Data = stateModelList; } catch (Exception ex) { _logger.Error(ex); response.Message.Add(ex.Message); } return(response); }
public BaseApiResponse AddOrUpdateState(int userid, StateMasterModel StateObj) { var response = new BaseApiResponse(); try { var stateIDParam = new SqlParameter { ParameterName = "StateID", DbType = DbType.Int32, Value = StateObj.StateID }; var stateNameParam = new SqlParameter { ParameterName = "StateName", DbType = DbType.String, Value = StateObj.StateName }; var countryIDParam = new SqlParameter { ParameterName = "CountryID", DbType = DbType.Int32, Value = StateObj.CountryID }; var userIdParam = new SqlParameter { ParameterName = "CreatedBy", DbType = DbType.Int32, Value = userid }; var isActiveParam = new SqlParameter { ParameterName = "IsActive", DbType = DbType.Boolean, Value = (Object)StateObj.IsActive != null ? StateObj.IsActive : (object)DBNull.Value }; var result = 0; result = _repository.ExecuteSQL <int>("usp_mst_StateMaster_insert_update", stateIDParam, stateNameParam, countryIDParam, userIdParam, isActiveParam).FirstOrDefault(); response.Success = result > 0; response.InsertedId = result; } catch (Exception ex) { _logger.Error(ex); response.Message.Add(ex.Message); } return(response); }
public BaseApiResponse AddOrUpdateState(int UserId, StateMasterModel StateObj) { return(this._iStateService.AddOrUpdateState(UserId, StateObj)); }