public List<Promotion> GetList(int page, int pageSize, string whereCondition)
{
List<SqlParameter> param = new List<SqlParameter>();
param.Add(new SqlParameter("@Page", page));
param.Add(new SqlParameter("@PageSize", pageSize));
param.Add(new SqlParameter("@WhereCondition", whereCondition));
DataTable dt = new SqlHelper().ExecuteQuery("p_get_Promotion_ApplyFor", param);
var lst = new List<Promotion>();
foreach (DataRow row in dt.Rows)
{
var item = new Promotion();
item.PromotionID = !row.IsNull("PromotionID") ? row["PromotionID"].ToString() : "";
item.TransporterName = !row.IsNull("TransporterName") ? row["TransporterName"].ToString() : "";
item.PromotionName = !row.IsNull("PromotionName") ? row["PromotionName"].ToString() : "";
//item.ProvinceID = !row.IsNull("ProvinceID") ? row["ProvinceID"].ToString() : "";
item.TransporterID = !row.IsNull("TransporterID") ? row["TransporterID"].ToString() : "";
//item.ProvinceName = !row.IsNull("ProvinceName") ? row["ProvinceName"].ToString() : "";
item.StartDate = !row.IsNull("StartDate") ? DateTime.Parse(row["StartDate"].ToString()) : DateTime.Parse("1900-01-01");
item.EndDate = !row.IsNull("EndDate") ? DateTime.Parse(row["EndDate"].ToString()) : DateTime.Parse("1900-01-01");
item.UpdatedAt = !row.IsNull("UpdatedAt") ? DateTime.Parse(row["UpdatedAt"].ToString()) : DateTime.Parse("1900-01-01");
item.CreatedAt = !row.IsNull("CreatedAt") ? DateTime.Parse(row["CreatedAt"].ToString()) : DateTime.Parse("1900-01-01");
item.UpdatedBy = !row.IsNull("UpdatedBy") ? row["UpdatedBy"].ToString() : "";
item.CreatedBy = !row.IsNull("CreatedBy") ? row["CreatedBy"].ToString() : "";
item.Note = !row.IsNull("Note") ? row["Note"].ToString() : "";
item.conNote = !row.IsNull("conNote") ? row["conNote"].ToString() : "";
//item.Description = !row.IsNull("Description") ? row["Description"].ToString() : "";
item.DecaMinOrdAmt = !row.IsNull("DecaMinOrdAmt") ? Double.Parse(row["DecaMinOrdAmt"].ToString()) : 0;
item.DecaMaxOrdAmt = !row.IsNull("DecaMaxOrdAmt") ? Double.Parse(row["DecaMaxOrdAmt"].ToString()) : 0;
item.DecaPercentAmt = !row.IsNull("DecaPercentAmt") ? Double.Parse(row["DecaPercentAmt"].ToString()) : 0;
item.MerchantMinOrdAmt = !row.IsNull("MerchantMinOrdAmt") ? Double.Parse(row["MerchantMinOrdAmt"].ToString()) : 0;
item.MerchantMaxOrdAmt = !row.IsNull("MerchantMaxOrdAmt") ? Double.Parse(row["MerchantMaxOrdAmt"].ToString()) : 0;
item.MerchantPercentAmt = !row.IsNull("MerchantPercentAmt") ? Double.Parse(row["MerchantPercentAmt"].ToString()) : 0;
item.DecaMinOrdQty = !row.IsNull("DecaMinOrdQty") ? Double.Parse(row["DecaMinOrdQty"].ToString()) : 0;
item.DecaMaxOrdQty = !row.IsNull("DecaMaxOrdQty") ? Double.Parse(row["DecaMaxOrdQty"].ToString()) : 0;
item.DecaPercentQty = !row.IsNull("DecaPercentQty") ? Double.Parse(row["DecaPercentQty"].ToString()) : 0;
item.MerchantMinOrdQty = !row.IsNull("MerchantMinOrdQty") ? Double.Parse(row["MerchantMinOrdQty"].ToString()) : 0;
item.MerchantMaxOrdQty = !row.IsNull("MerchantMaxOrdQty") ? Double.Parse(row["MerchantMaxOrdQty"].ToString()) : 0;
item.MerchantPercentQty = !row.IsNull("MerchantPercentQty") ? Double.Parse(row["MerchantPercentQty"].ToString()) : 0;
item.Status = !row.IsNull("Status") ? Convert.ToBoolean(row["Status"].ToString()) : false;
item.IsAllMerchant = !row.IsNull("IsAllMerchant") ? Convert.ToBoolean(row["IsAllMerchant"].ToString()) : false;
if (item.IsAllMerchant)
{
item.MerchantName = "Áp dụng cho tất cả các gian hàng";
item.MerchantID = "";
}
else
{
item.MerchantID = !row.IsNull("MerchantID") ? row["MerchantID"].ToString() : "";
item.MerchantName = !row.IsNull("MerchantName") ? row["MerchantName"].ToString() : "";
}
item.IsAllDistric = !row.IsNull("IsAllDistric") ? Convert.ToBoolean(row["IsAllDistric"].ToString()) : false;
if (item.IsAllDistric)
{
item.DistrictName = "Áp dụng cho tất cả quận huyện";
item.DistrictID = "";
}
else
{
item.DistrictID = !row.IsNull("DistrictID") ? row["DistrictID"].ToString() : "";
item.DistrictName = !row.IsNull("DistrictName") ? row["DistrictName"].ToString() : "";
}
lst.Add(item);
}
return lst;
}
public List <Promotion> GetList(int page, int pageSize, string whereCondition)
{
List <SqlParameter> param = new List <SqlParameter>();
param.Add(new SqlParameter("@Page", page));
param.Add(new SqlParameter("@PageSize", pageSize));
param.Add(new SqlParameter("@WhereCondition", whereCondition));
DataTable dt = new SqlHelper().ExecuteQuery("p_get_Promotion_ApplyFor", param);
var lst = new List <Promotion>();
foreach (DataRow row in dt.Rows)
{
var item = new Promotion();
item.PromotionID = !row.IsNull("PromotionID") ? row["PromotionID"].ToString() : "";
item.TransporterName = !row.IsNull("TransporterName") ? row["TransporterName"].ToString() : "";
item.PromotionName = !row.IsNull("PromotionName") ? row["PromotionName"].ToString() : "";
//item.ProvinceID = !row.IsNull("ProvinceID") ? row["ProvinceID"].ToString() : "";
item.TransporterID = !row.IsNull("TransporterID") ? row["TransporterID"].ToString() : "";
//item.ProvinceName = !row.IsNull("ProvinceName") ? row["ProvinceName"].ToString() : "";
item.StartDate = !row.IsNull("StartDate") ? DateTime.Parse(row["StartDate"].ToString()) : DateTime.Parse("1900-01-01");
item.EndDate = !row.IsNull("EndDate") ? DateTime.Parse(row["EndDate"].ToString()) : DateTime.Parse("1900-01-01");
item.UpdatedAt = !row.IsNull("UpdatedAt") ? DateTime.Parse(row["UpdatedAt"].ToString()) : DateTime.Parse("1900-01-01");
item.CreatedAt = !row.IsNull("CreatedAt") ? DateTime.Parse(row["CreatedAt"].ToString()) : DateTime.Parse("1900-01-01");
item.UpdatedBy = !row.IsNull("UpdatedBy") ? row["UpdatedBy"].ToString() : "";
item.CreatedBy = !row.IsNull("CreatedBy") ? row["CreatedBy"].ToString() : "";
item.Note = !row.IsNull("Note") ? row["Note"].ToString() : "";
item.conNote = !row.IsNull("conNote") ? row["conNote"].ToString() : "";
//item.Description = !row.IsNull("Description") ? row["Description"].ToString() : "";
item.DecaMinOrdAmt = !row.IsNull("DecaMinOrdAmt") ? Double.Parse(row["DecaMinOrdAmt"].ToString()) : 0;
item.DecaMaxOrdAmt = !row.IsNull("DecaMaxOrdAmt") ? Double.Parse(row["DecaMaxOrdAmt"].ToString()) : 0;
item.DecaPercentAmt = !row.IsNull("DecaPercentAmt") ? Double.Parse(row["DecaPercentAmt"].ToString()) : 0;
item.MerchantMinOrdAmt = !row.IsNull("MerchantMinOrdAmt") ? Double.Parse(row["MerchantMinOrdAmt"].ToString()) : 0;
item.MerchantMaxOrdAmt = !row.IsNull("MerchantMaxOrdAmt") ? Double.Parse(row["MerchantMaxOrdAmt"].ToString()) : 0;
item.MerchantPercentAmt = !row.IsNull("MerchantPercentAmt") ? Double.Parse(row["MerchantPercentAmt"].ToString()) : 0;
item.DecaMinOrdQty = !row.IsNull("DecaMinOrdQty") ? Double.Parse(row["DecaMinOrdQty"].ToString()) : 0;
item.DecaMaxOrdQty = !row.IsNull("DecaMaxOrdQty") ? Double.Parse(row["DecaMaxOrdQty"].ToString()) : 0;
item.DecaPercentQty = !row.IsNull("DecaPercentQty") ? Double.Parse(row["DecaPercentQty"].ToString()) : 0;
item.MerchantMinOrdQty = !row.IsNull("MerchantMinOrdQty") ? Double.Parse(row["MerchantMinOrdQty"].ToString()) : 0;
item.MerchantMaxOrdQty = !row.IsNull("MerchantMaxOrdQty") ? Double.Parse(row["MerchantMaxOrdQty"].ToString()) : 0;
item.MerchantPercentQty = !row.IsNull("MerchantPercentQty") ? Double.Parse(row["MerchantPercentQty"].ToString()) : 0;
item.Status = !row.IsNull("Status") ? Convert.ToBoolean(row["Status"].ToString()) : false;
item.IsAllMerchant = !row.IsNull("IsAllMerchant") ? Convert.ToBoolean(row["IsAllMerchant"].ToString()) : false;
if (item.IsAllMerchant)
{
item.MerchantName = "Áp dụng cho tất cả các gian hàng";
item.MerchantID = "";
}
else
{
item.MerchantID = !row.IsNull("MerchantID") ? row["MerchantID"].ToString() : "";
item.MerchantName = !row.IsNull("MerchantName") ? row["MerchantName"].ToString() : "";
}
item.IsAllDistric = !row.IsNull("IsAllDistric") ? Convert.ToBoolean(row["IsAllDistric"].ToString()) : false;
if (item.IsAllDistric)
{
item.DistrictName = "Áp dụng cho tất cả quận huyện";
item.DistrictID = "";
}
else
{
item.DistrictID = !row.IsNull("DistrictID") ? row["DistrictID"].ToString() : "";
item.DistrictName = !row.IsNull("DistrictName") ? row["DistrictName"].ToString() : "";
}
lst.Add(item);
}
return(lst);
}