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