public static bool DeleteAgencyStatus(AgencyStatusModel model)
{
DataSet ds = new DataSet();
using (IDbConnection connection = OpenConnection())
{
var p = new DynamicParameters();
p.Add("@CultureId", model.CultureId);
p.Add("@id", model.Id);
p.Add("@Code", model.Code, DbType.Int32, ParameterDirection.Output);
p.Add("@Message", model.Message, DbType.String, ParameterDirection.Output);
var success = connection.Query <bool>("usp_Delete_AgencyStatus_General", p,
commandType: CommandType.StoredProcedure).First();
return(success);
}
}
public static IEnumerable <AgencyStatusModel> GetAgencyStatus(AgencyStatusModel model)
{
DataSet ds = new DataSet();
using (IDbConnection connection = OpenConnection())
{
var p = new DynamicParameters();
p.Add("@CultureId", model.CultureId);
p.Add("@id", model.Id);
p.Add("@Code", model.Code, DbType.Int32, ParameterDirection.Output);
p.Add("@Message", model.Message, DbType.String, ParameterDirection.Output);
var result = connection.Query <AgencyStatusModel>("usp_GetAgencyStatus_General", p,
commandType: CommandType.StoredProcedure).ToList();
if (result != null && result.Count() > 0)
{
return(result);
}
}
return(null);
}
public static int AddAgencyStatus(AgencyStatusModel model)
{
DataSet ds = new DataSet();
using (IDbConnection connection = OpenConnection())
{
var p = new DynamicParameters();
p.Add("@CultureId", model.CultureId);
p.Add("@Description", model.Description);
p.Add("@Code", model.Code, DbType.Int32, ParameterDirection.Output);
p.Add("@Message", model.Message, DbType.String, ParameterDirection.Output);
var result = connection.Query <AccountModel>("usp_Create_AgencyStatus_General", p,
commandType: CommandType.StoredProcedure).First();
if (result != null)
{
return(result.Id);
}
}
return(0);
}
