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