public Int32 Save(PromoBySupplierDetails Details)
{
try
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQL = "CALL procSavePromoBySupplier(@PromoBySupplierID, @PromoBySupplierCode, @PromoBySupplierName, @PromoLevel, @StartDate, @EndDate, @PromoTypeID, @Status, @CreatedOn, @LastModified);";
cmd.Parameters.AddWithValue("PromoBySupplierID", Details.PromoBySupplierID);
cmd.Parameters.AddWithValue("PromoBySupplierCode", Details.PromoBySupplierCode);
cmd.Parameters.AddWithValue("PromoBySupplierName", Details.PromoBySupplierName);
cmd.Parameters.AddWithValue("PromoLevel", Details.PromoLevel.ToString("d"));
cmd.Parameters.AddWithValue("StartDate", Details.StartDate.ToString("yyyy-MM-dd HH:mm:ss"));
cmd.Parameters.AddWithValue("EndDate", Details.EndDate.ToString("yyyy-MM-dd HH:mm:ss"));
cmd.Parameters.AddWithValue("PromoTypeID", Details.PromoTypeID);
cmd.Parameters.AddWithValue("Status", Details.Status);
cmd.Parameters.AddWithValue("CreatedOn", Details.CreatedOn == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.CreatedOn);
cmd.Parameters.AddWithValue("LastModified", Details.LastModified == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.LastModified);
cmd.CommandText = SQL;
return(base.ExecuteNonQuery(cmd));
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public PromoBySupplierDetails getPromoBySupplierID()
{
try
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQL = "SELECT " +
"PromoBySupplierID " +
"FROM tblPromoBySupplier " +
"WHERE 1=1 " +
"AND Status = 1 " +
"AND DATE_FORMAT(StartDate, '%Y-%m-%d %H:%i') <= DATE_FORMAT(NOW(), '%Y-%m-%d %H:%i') " +
"AND DATE_FORMAT(EndDate, '%Y-%m-%d %H:%i') >= DATE_FORMAT(NOW(), '%Y-%m-%d %H:%i');";
cmd.CommandText = SQL;
string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName);
base.MySqlDataAdapterFill(cmd, dt);
PromoBySupplierDetails clsPromoBySupplierDetails = new PromoBySupplierDetails();
foreach (System.Data.DataRow dr in dt.Rows)
{
clsPromoBySupplierDetails = Details(Int64.Parse(dr["PromoBySupplierID"].ToString())); break;
}
return(clsPromoBySupplierDetails);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public void Update(PromoBySupplierDetails Details)
{
try
{
Save(Details);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public void Update(PromoBySupplierDetails Details)
{
try
{
Save(Details);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public System.Data.DataTable ListAstDataTable(PromoBySupplierDetails SearchKey, string SortField = "PromoBySupplierID", SortOption SortOrder = SortOption.Ascending, Int32 limit = 0)
{
try
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQL = "SELECT " +
"PromoBySupplierID, " +
"PromoBySupplierCode, " +
"PromoBySupplierName, " +
"PromoLevel, " +
"StartDate, " +
"EndDate, " +
"Status, " +
"a.PromoTypeID, " +
"PromoTypeCode, " +
"PromoTypeName " +
"FROM tblPromoBySupplier a INNER JOIN " +
"tblPromoType b ON a.PromoTypeID = b.PromoTypeID " +
"WHERE 1=1 ";
if (!string.IsNullOrEmpty(SearchKey.PromoBySupplierCode))
{
SQL += "AND PromoBySupplierCode LIKE @PromoBySupplierCode ";
cmd.Parameters.AddWithValue("@PromoBySupplierCode", SearchKey.PromoBySupplierCode);
}
if (!string.IsNullOrEmpty(SearchKey.PromoBySupplierName))
{
SQL += "AND PromoBySupplierCode LIKE @PromoBySupplierName ";
cmd.Parameters.AddWithValue("@PromoBySupplierName", SearchKey.PromoBySupplierName);
}
if (!string.IsNullOrEmpty(SearchKey.PromoTypeCode))
{
SQL += "AND PromoBySupplierCode LIKE @PromoTypeCode ";
cmd.Parameters.AddWithValue("@PromoTypeCode", SearchKey.PromoTypeCode);
}
SQL += "ORDER BY " + SortField + " ";
SQL += SortOrder == SortOption.Ascending ? "ASC " : "DESC ";
SQL += limit == 0 ? "" : "LIMIT " + limit.ToString() + " ";
cmd.CommandText = SQL;
string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName);
base.MySqlDataAdapterFill(cmd, dt);
return(dt);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public Int64 Insert(PromoBySupplierDetails Details)
{
try
{
Save(Details);
return Int64.Parse(base.getLAST_INSERT_ID(this));
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public Int64 Insert(PromoBySupplierDetails Details)
{
try
{
Save(Details);
return(Int64.Parse(base.getLAST_INSERT_ID(this)));
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public PromoBySupplierDetails Details(Int64 PromoBySupplierID)
{
try
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQL = "SELECT " +
"PromoBySupplierID, " +
"PromoBySupplierCode, " +
"PromoBySupplierName, " +
"PromoLevel, " +
"StartDate, " +
"EndDate, " +
"Status, " +
"a.PromoTypeID, " +
"PromoTypeCode, " +
"PromoTypeName " +
"FROM tblPromoBySupplier a " +
"INNER JOIN tblPromoType b ON a.PromoTypeID = b.PromoTypeID " +
"WHERE a.PromoBySupplierID = @PromoBySupplierID;";
cmd.Parameters.AddWithValue("@PromoBySupplierID", PromoBySupplierID);
cmd.CommandText = SQL;
string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName);
base.MySqlDataAdapterFill(cmd, dt);
PromoBySupplierDetails Details = new PromoBySupplierDetails();
foreach (System.Data.DataRow dr in dt.Rows)
{
Details.PromoBySupplierID = Int64.Parse(dr["PromoBySupplierID"].ToString());
Details.PromoBySupplierCode = "" + dr["PromoBySupplierCode"].ToString();
Details.PromoBySupplierName = "" + dr["PromoBySupplierName"].ToString();
Details.PromoLevel = (PromoLevel)Enum.Parse(typeof(PromoLevel), dr["PromoLevel"].ToString());
Details.StartDate = DateTime.Parse(dr["StartDate"].ToString());
Details.EndDate = DateTime.Parse(dr["EndDate"].ToString());
Details.PromoTypeID = Int32.Parse(dr["PromoTypeID"].ToString());
Details.PromoTypeCode = "" + dr["PromoTypeCode"].ToString();
Details.PromoTypeName = "" + dr["PromoTypeName"].ToString();
}
return(Details);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
private void LoadList()
{
PromoBySupplier clsPromoBySupplier = new PromoBySupplier();
DataClass clsDataClass = new DataClass();
string SortField = "PromoBySupplierName";
if (Request.QueryString["sortfield"]!=null)
{ SortField = Common.Decrypt(Request.QueryString["sortfield"].ToString(), Session.SessionID); }
SortOption sortoption = SortOption.Ascending;
if (Request.QueryString["sortoption"]!=null)
{ sortoption = (SortOption) Enum.Parse(typeof(SortOption), Common.Decrypt(Request.QueryString["sortoption"], Session.SessionID), true); }
PromoBySupplierDetails clsSearchKey = new PromoBySupplierDetails();
if (Request.QueryString["Search"]!=null)
{
clsSearchKey.PromoBySupplierCode = Common.Decrypt((string)Request.QueryString["search"], Session.SessionID);
}
PageData.DataSource = clsPromoBySupplier.ListAstDataTable(clsSearchKey, SortField, sortoption).DefaultView;
clsPromoBySupplier.CommitAndDispose();
int iPageSize = Convert.ToInt16(Session["PageSize"]) ;
PageData.AllowPaging = true;
PageData.PageSize = iPageSize;
try
{
PageData.CurrentPageIndex = Convert.ToInt16(cboCurrentPage.SelectedItem.Value) - 1;
lstItem.DataSource = PageData;
lstItem.DataBind();
}
catch
{
PageData.CurrentPageIndex = 1;
lstItem.DataSource = PageData;
lstItem.DataBind();
}
cboCurrentPage.Items.Clear();
for (int i=0; i < PageData.PageCount;i++)
{
int iValue = i + 1;
cboCurrentPage.Items.Add(new ListItem(iValue.ToString(),iValue.ToString()));
if (PageData.CurrentPageIndex == i)
{ cboCurrentPage.Items[i].Selected = true;}
else
{ cboCurrentPage.Items[i].Selected = false;}
}
lblDataCount.Text = " of " + " " + PageData.PageCount;
}
private long SaveRecord()
{
long lngRetValue = 0;
string stScript = string.Empty;
DateTime dteStartDateTime = DateTime.MinValue;
try { dteStartDateTime = Convert.ToDateTime(txtStartDate.Text + " " + txtStartTime.Text); }
catch
{
stScript += "<Script>";
stScript += "window.alert('Please enter a valid start date time of promo.')";
stScript += "</Script>";
Response.Write(stScript);
return lngRetValue;
}
DateTime dteEndDateTime = DateTime.MinValue;
try { dteEndDateTime = Convert.ToDateTime(txtEndDate.Text + " " + txtEndTime.Text); }
catch
{
stScript += "<Script>";
stScript += "window.alert('Please enter a valid end date time of promo.')";
stScript += "</Script>";
Response.Write(stScript);
return lngRetValue;
}
PromoBySupplier clsPromoBySupplier = new PromoBySupplier();
PromoBySupplierDetails clsDetails = new PromoBySupplierDetails();
clsDetails.PromoBySupplierID = Convert.ToInt64(lblPromoBySupplierID.Text);
clsDetails.PromoBySupplierCode = txtPromoBySupplierCode.Text;
clsDetails.PromoBySupplierName = txtPromoBySupplierName.Text;
clsDetails.PromoLevel = (PromoLevel)Enum.Parse(typeof(PromoLevel), cboPromoLevel.SelectedItem.Value);
clsDetails.StartDate = dteStartDateTime;
clsDetails.EndDate = dteEndDateTime;
clsDetails.PromoTypeID = Constants.C_DEF_PROMO_TYPE_ID;
clsPromoBySupplier.Update(clsDetails);
clsPromoBySupplier.CommitAndDispose();
lngRetValue = clsDetails.PromoBySupplierID;
return lngRetValue;
}
public Int32 Save(PromoBySupplierDetails Details)
{
try
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQL = "CALL procSavePromoBySupplier(@PromoBySupplierID, @PromoBySupplierCode, @PromoBySupplierName, @PromoLevel, @StartDate, @EndDate, @PromoTypeID, @Status, @CreatedOn, @LastModified);";
cmd.Parameters.AddWithValue("PromoBySupplierID", Details.PromoBySupplierID);
cmd.Parameters.AddWithValue("PromoBySupplierCode", Details.PromoBySupplierCode);
cmd.Parameters.AddWithValue("PromoBySupplierName", Details.PromoBySupplierName);
cmd.Parameters.AddWithValue("PromoLevel", Details.PromoLevel.ToString("d"));
cmd.Parameters.AddWithValue("StartDate", Details.StartDate.ToString("yyyy-MM-dd HH:mm:ss"));
cmd.Parameters.AddWithValue("EndDate", Details.EndDate.ToString("yyyy-MM-dd HH:mm:ss"));
cmd.Parameters.AddWithValue("PromoTypeID", Details.PromoTypeID);
cmd.Parameters.AddWithValue("Status", Details.Status);
cmd.Parameters.AddWithValue("CreatedOn", Details.CreatedOn == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.CreatedOn);
cmd.Parameters.AddWithValue("LastModified", Details.LastModified == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.LastModified);
cmd.CommandText = SQL;
return base.ExecuteNonQuery(cmd);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public System.Data.DataTable ListAstDataTable(PromoBySupplierDetails SearchKey, string SortField = "PromoBySupplierID", SortOption SortOrder = SortOption.Ascending, Int32 limit = 0)
{
try
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQL = "SELECT " +
"PromoBySupplierID, " +
"PromoBySupplierCode, " +
"PromoBySupplierName, " +
"PromoLevel, " +
"StartDate, " +
"EndDate, " +
"Status, " +
"a.PromoTypeID, " +
"PromoTypeCode, " +
"PromoTypeName " +
"FROM tblPromoBySupplier a INNER JOIN " +
"tblPromoType b ON a.PromoTypeID = b.PromoTypeID " +
"WHERE 1=1 ";
if (!string.IsNullOrEmpty(SearchKey.PromoBySupplierCode))
{
SQL += "AND PromoBySupplierCode LIKE @PromoBySupplierCode ";
cmd.Parameters.AddWithValue("@PromoBySupplierCode", SearchKey.PromoBySupplierCode);
}
if (!string.IsNullOrEmpty(SearchKey.PromoBySupplierName))
{
SQL += "AND PromoBySupplierCode LIKE @PromoBySupplierName ";
cmd.Parameters.AddWithValue("@PromoBySupplierName", SearchKey.PromoBySupplierName);
}
if (!string.IsNullOrEmpty(SearchKey.PromoTypeCode))
{
SQL += "AND PromoBySupplierCode LIKE @PromoTypeCode ";
cmd.Parameters.AddWithValue("@PromoTypeCode", SearchKey.PromoTypeCode);
}
SQL += "ORDER BY " + SortField + " ";
SQL += SortOrder == SortOption.Ascending ? "ASC " : "DESC ";
SQL += limit == 0 ? "" : "LIMIT " + limit.ToString() + " ";
cmd.CommandText = SQL;
string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName);
base.MySqlDataAdapterFill(cmd, dt);
return dt;
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public PromoBySupplierDetails Details(Int64 PromoBySupplierID)
{
try
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQL= "SELECT " +
"PromoBySupplierID, " +
"PromoBySupplierCode, " +
"PromoBySupplierName, " +
"PromoLevel, " +
"StartDate, " +
"EndDate, " +
"Status, " +
"a.PromoTypeID, " +
"PromoTypeCode, " +
"PromoTypeName " +
"FROM tblPromoBySupplier a " +
"INNER JOIN tblPromoType b ON a.PromoTypeID = b.PromoTypeID " +
"WHERE a.PromoBySupplierID = @PromoBySupplierID;";
cmd.Parameters.AddWithValue("@PromoBySupplierID", PromoBySupplierID);
cmd.CommandText = SQL;
string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName);
base.MySqlDataAdapterFill(cmd, dt);
PromoBySupplierDetails Details = new PromoBySupplierDetails();
foreach (System.Data.DataRow dr in dt.Rows)
{
Details.PromoBySupplierID = Int64.Parse(dr["PromoBySupplierID"].ToString());
Details.PromoBySupplierCode = "" + dr["PromoBySupplierCode"].ToString();
Details.PromoBySupplierName = "" + dr["PromoBySupplierName"].ToString();
Details.PromoLevel = (PromoLevel) Enum.Parse(typeof(PromoLevel), dr["PromoLevel"].ToString());
Details.StartDate = DateTime.Parse(dr["StartDate"].ToString());
Details.EndDate = DateTime.Parse(dr["EndDate"].ToString());
Details.PromoTypeID = Int32.Parse(dr["PromoTypeID"].ToString());
Details.PromoTypeCode = "" + dr["PromoTypeCode"].ToString();
Details.PromoTypeName = "" + dr["PromoTypeName"].ToString();
}
return Details;
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public PromoBySupplierDetails getPromoBySupplierID()
{
try
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQL = "SELECT " +
"PromoBySupplierID " +
"FROM tblPromoBySupplier " +
"WHERE 1=1 " +
"AND Status = 1 " +
"AND DATE_FORMAT(StartDate, '%Y-%m-%d %H:%i') <= DATE_FORMAT(NOW(), '%Y-%m-%d %H:%i') " +
"AND DATE_FORMAT(EndDate, '%Y-%m-%d %H:%i') >= DATE_FORMAT(NOW(), '%Y-%m-%d %H:%i');";
cmd.CommandText = SQL;
string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName);
base.MySqlDataAdapterFill(cmd, dt);
PromoBySupplierDetails clsPromoBySupplierDetails = new PromoBySupplierDetails();
foreach (System.Data.DataRow dr in dt.Rows)
{
clsPromoBySupplierDetails = Details(Int64.Parse(dr["PromoBySupplierID"].ToString())); break;
}
return clsPromoBySupplierDetails;
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public bool ApplyPromoBySupplierValue(PromoBySupplierDetails clsPromoBySupplierDetails, Int64 ContactID, Int64 ProductGroupID, Int64 ProductSubGroupID, Int64 ProductID, Int64 VariationMatrixID, out decimal PromoBySupplierValue, out string CouponRemarks, int BranchID = 0)
{
string strSpecialSupplierIDs = "";
PromoBySupplierValue = 0;
CouponRemarks = "";
bool boHasPromoBySupplier = true;
try
{
if (ProductID != 0)
{
Data.Products clsProduct = new Data.Products(base.Connection, base.Transaction);
Data.ProductDetails clsProductDetails = clsProduct.Details1(BranchID, ProductID);
ProductSubGroupID = clsProductDetails.ProductSubGroupID;
ProductGroupID = clsProductDetails.ProductGroupID;
}
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQL = "";
string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName);
/*******************************Up to Contact, Group, Sub, Prod and VarM ID *****************************/
SQL = "SELECT " +
"PromoBySupplierItemsID, " +
"a.PromoBySupplierID, " +
"ProductGroupID, " +
"ProductSubGroupID, " +
"ProductID, " +
"VariationMatrixID, " +
"PromoBySupplierValue, " +
"CouponRemarks " +
"FROM tblPromoBySupplierItems a " +
"INNER JOIN tblPromoBySupplier b ON a.PromoBySupplierID = b.PromoBySupplierID AND a.PromoBySupplierID = @PromoBySupplierID " +
"WHERE " + (string.IsNullOrEmpty(strSpecialSupplierIDs) ? "ContactID = @ContactID " : "ContactID IN (@ContactID, " + strSpecialSupplierIDs + ") ") +
"AND ProductGroupID = @ProductGroupID " +
"AND ProductSubGroupID = @ProductSubGroupID " +
"AND ProductID = @ProductID " +
"AND VariationMatrixID = @VariationMatrixID " +
"AND Status = 1 " +
"AND DATE_FORMAT(StartDate, '%Y-%m-%d %H:%i') <= DATE_FORMAT(NOW(), '%Y-%m-%d %H:%i') " +
"AND DATE_FORMAT(EndDate, '%Y-%m-%d %H:%i') >= DATE_FORMAT(NOW(), '%Y-%m-%d %H:%i') ORDER BY PromoBySupplierValue ASC LIMIT 1;";
cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.Parameters.AddWithValue("@PromoBySupplierID", clsPromoBySupplierDetails.PromoBySupplierID);
cmd.Parameters.AddWithValue("@ContactID", ContactID);
cmd.Parameters.AddWithValue("@ProductGroupID", ProductGroupID);
cmd.Parameters.AddWithValue("@ProductSubGroupID", ProductSubGroupID);
cmd.Parameters.AddWithValue("@ProductID", ProductID);
cmd.Parameters.AddWithValue("@VariationMatrixID", VariationMatrixID);
cmd.CommandText = SQL;
dt = new System.Data.DataTable(strDataTableName);
base.MySqlDataAdapterFill(cmd, dt);
foreach (System.Data.DataRow dr in dt.Rows)
{
PromoBySupplierValue = decimal.Parse(dr["PromoBySupplierValue"].ToString());
CouponRemarks = dr["CouponRemarks"].ToString();
return boHasPromoBySupplier;
}
/*******************************Up to Contact, Sub, Prod and VariationsMatrix ID *****************************/
SQL = "SELECT " +
"PromoBySupplierItemsID, " +
"a.PromoBySupplierID, " +
"ProductGroupID, " +
"ProductSubGroupID, " +
"ProductID, " +
"VariationMatrixID, " +
"PromoBySupplierValue, " +
"CouponRemarks " +
"FROM tblPromoBySupplierItems a " +
"INNER JOIN tblPromoBySupplier b ON a.PromoBySupplierID = b.PromoBySupplierID AND a.PromoBySupplierID = @PromoBySupplierID " +
"WHERE " + (string.IsNullOrEmpty(strSpecialSupplierIDs) ? "ContactID = @ContactID " : "ContactID IN (@ContactID, " + strSpecialSupplierIDs + ") ") +
"AND ProductGroupID = 0 " +
"AND ProductSubGroupID = @ProductSubGroupID " +
"AND ProductID = @ProductID " +
"AND VariationMatrixID = @VariationMatrixID " +
"AND Status = 1 " +
"AND DATE_FORMAT(StartDate, '%Y-%m-%d %H:%i') <= DATE_FORMAT(NOW(), '%Y-%m-%d %H:%i') " +
"AND DATE_FORMAT(EndDate, '%Y-%m-%d %H:%i') >= DATE_FORMAT(NOW(), '%Y-%m-%d %H:%i') ORDER BY PromoBySupplierValue ASC LIMIT 1;";
cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.Parameters.AddWithValue("@PromoBySupplierID", clsPromoBySupplierDetails.PromoBySupplierID);
cmd.Parameters.AddWithValue("@ContactID", ContactID);
cmd.Parameters.AddWithValue("@ProductSubGroupID", ProductSubGroupID);
cmd.Parameters.AddWithValue("@ProductID", ProductID);
cmd.Parameters.AddWithValue("@VariationMatrixID", VariationMatrixID);
cmd.CommandText = SQL;
dt = new System.Data.DataTable(strDataTableName);
base.MySqlDataAdapterFill(cmd, dt);
foreach (System.Data.DataRow dr in dt.Rows)
{
PromoBySupplierValue = decimal.Parse(dr["PromoBySupplierValue"].ToString());
CouponRemarks = dr["CouponRemarks"].ToString();
return boHasPromoBySupplier;
}
/*******************************Up to Contact, Prod and VariationsMatrix ID *****************************/
SQL = "SELECT " +
"PromoBySupplierItemsID, " +
"a.PromoBySupplierID, " +
"ProductGroupID, " +
"ProductSubGroupID, " +
"ProductID, " +
"VariationMatrixID, " +
"PromoBySupplierValue, " +
"CouponRemarks " +
"FROM tblPromoBySupplierItems a " +
"INNER JOIN tblPromoBySupplier b ON a.PromoBySupplierID = b.PromoBySupplierID AND a.PromoBySupplierID = @PromoBySupplierID " +
"WHERE " + (string.IsNullOrEmpty(strSpecialSupplierIDs) ? "ContactID = @ContactID " : "ContactID IN (@ContactID, " + strSpecialSupplierIDs + ") ") +
"AND ProductGroupID = 0 " +
"AND ProductSubGroupID = 0 " +
"AND ProductID = @ProductID " +
"AND VariationMatrixID = @VariationMatrixID " +
"AND Status = 1 " +
"AND DATE_FORMAT(StartDate, '%Y-%m-%d %H:%i') <= DATE_FORMAT(NOW(), '%Y-%m-%d %H:%i') " +
"AND DATE_FORMAT(EndDate, '%Y-%m-%d %H:%i') >= DATE_FORMAT(NOW(), '%Y-%m-%d %H:%i') ORDER BY PromoBySupplierValue ASC LIMIT 1;";
cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.Parameters.AddWithValue("@PromoBySupplierID", clsPromoBySupplierDetails.PromoBySupplierID);
cmd.Parameters.AddWithValue("@ContactID", ContactID);
cmd.Parameters.AddWithValue("@ProductID", ProductID);
cmd.Parameters.AddWithValue("@VariationMatrixID", VariationMatrixID);
cmd.CommandText = SQL;
dt = new System.Data.DataTable(strDataTableName);
base.MySqlDataAdapterFill(cmd, dt);
foreach (System.Data.DataRow dr in dt.Rows)
{
PromoBySupplierValue = decimal.Parse(dr["PromoBySupplierValue"].ToString());
CouponRemarks = dr["CouponRemarks"].ToString();
return boHasPromoBySupplier;
}
/*******************************Up to Contact, VariationsMatrix ID *****************************/
SQL = "SELECT " +
"PromoBySupplierItemsID, " +
"a.PromoBySupplierID, " +
"ProductGroupID, " +
"ProductSubGroupID, " +
"ProductID, " +
"VariationMatrixID, " +
"PromoBySupplierValue, " +
"CouponRemarks " +
"FROM tblPromoBySupplierItems a " +
"INNER JOIN tblPromoBySupplier b ON a.PromoBySupplierID = b.PromoBySupplierID AND a.PromoBySupplierID = @PromoBySupplierID " +
"WHERE " + (string.IsNullOrEmpty(strSpecialSupplierIDs) ? "ContactID = @ContactID " : "ContactID IN (@ContactID, " + strSpecialSupplierIDs + ") ") +
"AND ProductGroupID = 0 " +
"AND ProductSubGroupID = 0 " +
"AND ProductID = 0 " +
"AND VariationMatrixID = @VariationMatrixID " +
"AND Status = 1 " +
"AND DATE_FORMAT(StartDate, '%Y-%m-%d %H:%i') <= DATE_FORMAT(NOW(), '%Y-%m-%d %H:%i') " +
"AND DATE_FORMAT(EndDate, '%Y-%m-%d %H:%i') >= DATE_FORMAT(NOW(), '%Y-%m-%d %H:%i') ORDER BY PromoBySupplierValue ASC LIMIT 1;";
cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.Parameters.AddWithValue("@PromoBySupplierID", clsPromoBySupplierDetails.PromoBySupplierID);
cmd.Parameters.AddWithValue("@ContactID", ContactID);
cmd.Parameters.AddWithValue("@VariationMatrixID", VariationMatrixID);
cmd.CommandText = SQL;
dt = new System.Data.DataTable(strDataTableName);
base.MySqlDataAdapterFill(cmd, dt);
foreach (System.Data.DataRow dr in dt.Rows)
{
PromoBySupplierValue = decimal.Parse(dr["PromoBySupplierValue"].ToString());
CouponRemarks = dr["CouponRemarks"].ToString();
return boHasPromoBySupplier;
}
/*******************************Up to Contact, Group, Sub, Prod ID *****************************/
SQL = "SELECT " +
"PromoBySupplierItemsID, " +
"a.PromoBySupplierID, " +
"ProductGroupID, " +
"ProductSubGroupID, " +
"ProductID, " +
"VariationMatrixID, " +
"PromoBySupplierValue, " +
"CouponRemarks " +
"FROM tblPromoBySupplierItems a " +
"INNER JOIN tblPromoBySupplier b ON a.PromoBySupplierID = b.PromoBySupplierID AND a.PromoBySupplierID = @PromoBySupplierID " +
"WHERE " + (string.IsNullOrEmpty(strSpecialSupplierIDs) ? "ContactID = @ContactID " : "ContactID IN (@ContactID, " + strSpecialSupplierIDs + ") ") +
"AND ProductGroupID = @ProductGroupID " +
"AND ProductSubGroupID = @ProductSubGroupID " +
"AND ProductID = @ProductID " +
"AND VariationMatrixID = 0 " +
"AND Status = 1 " +
"AND DATE_FORMAT(StartDate, '%Y-%m-%d %H:%i') <= DATE_FORMAT(NOW(), '%Y-%m-%d %H:%i') " +
"AND DATE_FORMAT(EndDate, '%Y-%m-%d %H:%i') >= DATE_FORMAT(NOW(), '%Y-%m-%d %H:%i') ORDER BY PromoBySupplierValue ASC LIMIT 1;";
cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.Parameters.AddWithValue("@PromoBySupplierID", clsPromoBySupplierDetails.PromoBySupplierID);
cmd.Parameters.AddWithValue("@ContactID", ContactID);
cmd.Parameters.AddWithValue("@ProductGroupID", ProductGroupID);
cmd.Parameters.AddWithValue("@ProductSubGroupID", ProductSubGroupID);
cmd.Parameters.AddWithValue("@ProductID", ProductID);
cmd.CommandText = SQL;
dt = new System.Data.DataTable(strDataTableName);
base.MySqlDataAdapterFill(cmd, dt);
foreach (System.Data.DataRow dr in dt.Rows)
{
PromoBySupplierValue = decimal.Parse(dr["PromoBySupplierValue"].ToString());
CouponRemarks = dr["CouponRemarks"].ToString();
return boHasPromoBySupplier;
}
/*******************************Up to Contact, Sub, Prod ID *****************************/
SQL = "SELECT " +
"PromoBySupplierItemsID, " +
"a.PromoBySupplierID, " +
"ProductGroupID, " +
"ProductSubGroupID, " +
"ProductID, " +
"VariationMatrixID, " +
"PromoBySupplierValue, " +
"CouponRemarks " +
"FROM tblPromoBySupplierItems a " +
"INNER JOIN tblPromoBySupplier b ON a.PromoBySupplierID = b.PromoBySupplierID AND a.PromoBySupplierID = @PromoBySupplierID " +
"WHERE " + (string.IsNullOrEmpty(strSpecialSupplierIDs) ? "ContactID = @ContactID " : "ContactID IN (@ContactID, " + strSpecialSupplierIDs + ") ") +
"AND ProductGroupID = 0 " +
"AND ProductSubGroupID = @ProductSubGroupID " +
"AND ProductID = @ProductID " +
"AND VariationMatrixID = 0 " +
"AND Status = 1 " +
"AND DATE_FORMAT(StartDate, '%Y-%m-%d %H:%i') <= DATE_FORMAT(NOW(), '%Y-%m-%d %H:%i') " +
"AND DATE_FORMAT(EndDate, '%Y-%m-%d %H:%i') >= DATE_FORMAT(NOW(), '%Y-%m-%d %H:%i') ORDER BY PromoBySupplierValue ASC LIMIT 1;";
cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.Parameters.AddWithValue("@PromoBySupplierID", clsPromoBySupplierDetails.PromoBySupplierID);
cmd.Parameters.AddWithValue("@ContactID", ContactID);
cmd.Parameters.AddWithValue("@ProductSubGroupID", ProductSubGroupID);
cmd.Parameters.AddWithValue("@ProductID", ProductID);
cmd.CommandText = SQL;
dt = new System.Data.DataTable(strDataTableName);
base.MySqlDataAdapterFill(cmd, dt);
foreach (System.Data.DataRow dr in dt.Rows)
{
PromoBySupplierValue = decimal.Parse(dr["PromoBySupplierValue"].ToString());
CouponRemarks = dr["CouponRemarks"].ToString();
return boHasPromoBySupplier;
}
/*******************************Up to Contact, Prod ID *****************************/
SQL = "SELECT " +
"PromoBySupplierItemsID, " +
"a.PromoBySupplierID, " +
"ProductGroupID, " +
"ProductSubGroupID, " +
"ProductID, " +
"VariationMatrixID, " +
"PromoBySupplierValue, " +
"CouponRemarks " +
"FROM tblPromoBySupplierItems a " +
"INNER JOIN tblPromoBySupplier b ON a.PromoBySupplierID = b.PromoBySupplierID AND a.PromoBySupplierID = @PromoBySupplierID " +
"WHERE " + (string.IsNullOrEmpty(strSpecialSupplierIDs) ? "ContactID = @ContactID " : "ContactID IN (@ContactID, " + strSpecialSupplierIDs + ") ") +
"AND ProductGroupID = 0 " +
"AND ProductSubGroupID = 0 " +
"AND ProductID = @ProductID " +
"AND VariationMatrixID = 0 " +
"AND Status = 1 " +
"AND DATE_FORMAT(StartDate, '%Y-%m-%d %H:%i') <= DATE_FORMAT(NOW(), '%Y-%m-%d %H:%i') " +
"AND DATE_FORMAT(EndDate, '%Y-%m-%d %H:%i') >= DATE_FORMAT(NOW(), '%Y-%m-%d %H:%i') ORDER BY PromoBySupplierValue ASC LIMIT 1;";
cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.Parameters.AddWithValue("@PromoBySupplierID", clsPromoBySupplierDetails.PromoBySupplierID);
cmd.Parameters.AddWithValue("@ContactID", ContactID);
cmd.Parameters.AddWithValue("@ProductID", ProductID);
cmd.CommandText = SQL;
dt = new System.Data.DataTable(strDataTableName);
base.MySqlDataAdapterFill(cmd, dt);
foreach (System.Data.DataRow dr in dt.Rows)
{
PromoBySupplierValue = decimal.Parse(dr["PromoBySupplierValue"].ToString());
CouponRemarks = dr["CouponRemarks"].ToString();
return boHasPromoBySupplier;
}
/*******************************Up to Contact, Group, Sub *****************************/
SQL = "SELECT " +
"PromoBySupplierItemsID, " +
"a.PromoBySupplierID, " +
"ProductGroupID, " +
"ProductSubGroupID, " +
"ProductID, " +
"VariationMatrixID, " +
"PromoBySupplierValue, " +
"CouponRemarks " +
"FROM tblPromoBySupplierItems a " +
"INNER JOIN tblPromoBySupplier b ON a.PromoBySupplierID = b.PromoBySupplierID AND a.PromoBySupplierID = @PromoBySupplierID " +
"WHERE " + (string.IsNullOrEmpty(strSpecialSupplierIDs) ? "ContactID = @ContactID " : "ContactID IN (@ContactID, " + strSpecialSupplierIDs + ") ") +
"AND ProductGroupID = @ProductGroupID " +
"AND ProductSubGroupID = @ProductSubGroupID " +
"AND ProductID = 0 " +
"AND VariationMatrixID = 0 " +
"AND Status = 1 " +
"AND DATE_FORMAT(StartDate, '%Y-%m-%d %H:%i') <= DATE_FORMAT(NOW(), '%Y-%m-%d %H:%i') " +
"AND DATE_FORMAT(EndDate, '%Y-%m-%d %H:%i') >= DATE_FORMAT(NOW(), '%Y-%m-%d %H:%i') ORDER BY PromoBySupplierValue ASC LIMIT 1;";
cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.Parameters.AddWithValue("@PromoBySupplierID", clsPromoBySupplierDetails.PromoBySupplierID);
cmd.Parameters.AddWithValue("@ContactID", ContactID);
cmd.Parameters.AddWithValue("@ProductGroupID", ProductGroupID);
cmd.Parameters.AddWithValue("@ProductSubGroupID", ProductSubGroupID);
cmd.CommandText = SQL;
dt = new System.Data.DataTable(strDataTableName);
base.MySqlDataAdapterFill(cmd, dt);
foreach (System.Data.DataRow dr in dt.Rows)
{
PromoBySupplierValue = decimal.Parse(dr["PromoBySupplierValue"].ToString());
CouponRemarks = dr["CouponRemarks"].ToString();
return boHasPromoBySupplier;
}
/*******************************Up to Contact, Sub *****************************/
SQL = "SELECT " +
"PromoBySupplierItemsID, " +
"a.PromoBySupplierID, " +
"ProductGroupID, " +
"ProductSubGroupID, " +
"ProductID, " +
"VariationMatrixID, " +
"PromoBySupplierValue, " +
"CouponRemarks " +
"FROM tblPromoBySupplierItems a " +
"INNER JOIN tblPromoBySupplier b ON a.PromoBySupplierID = b.PromoBySupplierID AND a.PromoBySupplierID = @PromoBySupplierID " +
"WHERE " + (string.IsNullOrEmpty(strSpecialSupplierIDs) ? "ContactID = @ContactID " : "ContactID IN (@ContactID, " + strSpecialSupplierIDs + ") ") +
"AND ProductGroupID = 0 " +
"AND ProductSubGroupID = @ProductSubGroupID " +
"AND ProductID = 0 " +
"AND VariationMatrixID = 0 " +
"AND Status = 1 " +
"AND DATE_FORMAT(StartDate, '%Y-%m-%d %H:%i') <= DATE_FORMAT(NOW(), '%Y-%m-%d %H:%i') " +
"AND DATE_FORMAT(EndDate, '%Y-%m-%d %H:%i') >= DATE_FORMAT(NOW(), '%Y-%m-%d %H:%i') ORDER BY PromoBySupplierValue ASC LIMIT 1;";
cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.Parameters.AddWithValue("@PromoBySupplierID", clsPromoBySupplierDetails.PromoBySupplierID);
cmd.Parameters.AddWithValue("@ContactID", ContactID);
cmd.Parameters.AddWithValue("@ProductSubGroupID", ProductSubGroupID);
cmd.CommandText = SQL;
dt = new System.Data.DataTable(strDataTableName);
base.MySqlDataAdapterFill(cmd, dt);
foreach (System.Data.DataRow dr in dt.Rows)
{
PromoBySupplierValue = decimal.Parse(dr["PromoBySupplierValue"].ToString());
CouponRemarks = dr["CouponRemarks"].ToString();
return boHasPromoBySupplier;
}
/*******************************Up to Contact *****************************/
SQL = "SELECT " +
"PromoBySupplierItemsID, " +
"a.PromoBySupplierID, " +
"ProductGroupID, " +
"ProductSubGroupID, " +
"ProductID, " +
"VariationMatrixID, " +
"PromoBySupplierValue, " +
"CouponRemarks " +
"FROM tblPromoBySupplierItems a " +
"INNER JOIN tblPromoBySupplier b ON a.PromoBySupplierID = b.PromoBySupplierID AND a.PromoBySupplierID = @PromoBySupplierID " +
"WHERE " + (string.IsNullOrEmpty(strSpecialSupplierIDs) ? "ContactID = @ContactID " : "ContactID IN (@ContactID, " + strSpecialSupplierIDs + ") ") +
"AND ProductGroupID = 0 " +
"AND ProductSubGroupID = 0 " +
"AND ProductID = 0 " +
"AND VariationMatrixID = 0 " +
"AND Status = 1 " +
"AND DATE_FORMAT(StartDate, '%Y-%m-%d %H:%i') <= DATE_FORMAT(NOW(), '%Y-%m-%d %H:%i') " +
"AND DATE_FORMAT(EndDate, '%Y-%m-%d %H:%i') >= DATE_FORMAT(NOW(), '%Y-%m-%d %H:%i') ORDER BY PromoBySupplierValue ASC LIMIT 1;";
cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.Parameters.AddWithValue("@PromoBySupplierID", clsPromoBySupplierDetails.PromoBySupplierID);
cmd.Parameters.AddWithValue("@ContactID", ContactID);
cmd.CommandText = SQL;
dt = new System.Data.DataTable(strDataTableName);
base.MySqlDataAdapterFill(cmd, dt);
foreach (System.Data.DataRow dr in dt.Rows)
{
PromoBySupplierValue = decimal.Parse(dr["PromoBySupplierValue"].ToString());
CouponRemarks = dr["CouponRemarks"].ToString();
return boHasPromoBySupplier;
}
/*******************************Up to Group, Sub, Prod and VarM ID *****************************/
SQL = "SELECT " +
"PromoBySupplierItemsID, " +
"a.PromoBySupplierID, " +
"ProductGroupID, " +
"ProductSubGroupID, " +
"ProductID, " +
"VariationMatrixID, " +
"PromoBySupplierValue, " +
"CouponRemarks " +
"FROM tblPromoBySupplierItems a " +
"INNER JOIN tblPromoBySupplier b ON a.PromoBySupplierID = b.PromoBySupplierID AND a.PromoBySupplierID = @PromoBySupplierID " +
"WHERE " + (string.IsNullOrEmpty(strSpecialSupplierIDs) ? "ContactID = 0 " : "ContactID IN (0, " + strSpecialSupplierIDs + ") ") +
"AND ProductGroupID = @ProductGroupID " +
"AND ProductSubGroupID = @ProductSubGroupID " +
"AND ProductID = @ProductID " +
"AND VariationMatrixID = @VariationMatrixID " +
"AND Status = 1 " +
"AND DATE_FORMAT(StartDate, '%Y-%m-%d %H:%i') <= DATE_FORMAT(NOW(), '%Y-%m-%d %H:%i') " +
"AND DATE_FORMAT(EndDate, '%Y-%m-%d %H:%i') >= DATE_FORMAT(NOW(), '%Y-%m-%d %H:%i') ORDER BY PromoBySupplierValue ASC LIMIT 1;";
cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.Parameters.AddWithValue("@PromoBySupplierID", clsPromoBySupplierDetails.PromoBySupplierID);
cmd.Parameters.AddWithValue("@ProductGroupID", ProductGroupID);
cmd.Parameters.AddWithValue("@ProductSubGroupID", ProductSubGroupID);
cmd.Parameters.AddWithValue("@ProductID", ProductID);
cmd.Parameters.AddWithValue("@VariationMatrixID", VariationMatrixID);
cmd.CommandText = SQL;
dt = new System.Data.DataTable(strDataTableName);
base.MySqlDataAdapterFill(cmd, dt);
foreach (System.Data.DataRow dr in dt.Rows)
{
PromoBySupplierValue = decimal.Parse(dr["PromoBySupplierValue"].ToString());
CouponRemarks = dr["CouponRemarks"].ToString();
return boHasPromoBySupplier;
}
/*******************************Up to Sub, Prod and VariationMatrix ID *****************************/
SQL = "SELECT " +
"PromoBySupplierItemsID, " +
"a.PromoBySupplierID, " +
"ProductGroupID, " +
"ProductSubGroupID, " +
"ProductID, " +
"VariationMatrixID, " +
"PromoBySupplierValue, " +
"CouponRemarks " +
"FROM tblPromoBySupplierItems a " +
"INNER JOIN tblPromoBySupplier b ON a.PromoBySupplierID = b.PromoBySupplierID AND a.PromoBySupplierID = @PromoBySupplierID " +
"WHERE " + (string.IsNullOrEmpty(strSpecialSupplierIDs) ? "ContactID = 0 " : "ContactID IN (0, " + strSpecialSupplierIDs + ") ") +
"AND ProductGroupID =0 " +
"AND ProductSubGroupID = @ProductSubGroupID " +
"AND ProductID = @ProductID " +
"AND VariationMatrixID = @VariationMatrixID " +
"AND Status = 1 " +
"AND DATE_FORMAT(StartDate, '%Y-%m-%d %H:%i') <= DATE_FORMAT(NOW(), '%Y-%m-%d %H:%i') " +
"AND DATE_FORMAT(EndDate, '%Y-%m-%d %H:%i') >= DATE_FORMAT(NOW(), '%Y-%m-%d %H:%i') ORDER BY PromoBySupplierValue ASC LIMIT 1;";
cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.Parameters.AddWithValue("@PromoBySupplierID", clsPromoBySupplierDetails.PromoBySupplierID);
cmd.Parameters.AddWithValue("@ProductSubGroupID", ProductSubGroupID);
cmd.Parameters.AddWithValue("@ProductID", ProductID);
cmd.Parameters.AddWithValue("@VariationMatrixID", VariationMatrixID);
cmd.CommandText = SQL;
dt = new System.Data.DataTable(strDataTableName);
base.MySqlDataAdapterFill(cmd, dt);
foreach (System.Data.DataRow dr in dt.Rows)
{
PromoBySupplierValue = decimal.Parse(dr["PromoBySupplierValue"].ToString());
CouponRemarks = dr["CouponRemarks"].ToString();
return boHasPromoBySupplier;
}
/*******************************Up to Prod and VariationMatrix ID *****************************/
SQL = "SELECT " +
"PromoBySupplierItemsID, " +
"a.PromoBySupplierID, " +
"ProductGroupID, " +
"ProductSubGroupID, " +
"ProductID, " +
"VariationMatrixID, " +
"PromoBySupplierValue, " +
"CouponRemarks " +
"FROM tblPromoBySupplierItems a " +
"INNER JOIN tblPromoBySupplier b ON a.PromoBySupplierID = b.PromoBySupplierID AND a.PromoBySupplierID = @PromoBySupplierID " +
"WHERE " + (string.IsNullOrEmpty(strSpecialSupplierIDs) ? "ContactID = 0 " : "ContactID IN (0, " + strSpecialSupplierIDs + ") ") +
"AND ProductGroupID = 0 " +
"AND ProductSubGroupID = 0 " +
"AND ProductID = @ProductID " +
"AND VariationMatrixID = @VariationMatrixID " +
"AND Status = 1 " +
"AND DATE_FORMAT(StartDate, '%Y-%m-%d %H:%i') <= DATE_FORMAT(NOW(), '%Y-%m-%d %H:%i') " +
"AND DATE_FORMAT(EndDate, '%Y-%m-%d %H:%i') >= DATE_FORMAT(NOW(), '%Y-%m-%d %H:%i') ORDER BY PromoBySupplierValue ASC LIMIT 1;";
cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.Parameters.AddWithValue("@PromoBySupplierID", clsPromoBySupplierDetails.PromoBySupplierID);
cmd.Parameters.AddWithValue("@ProductID", ProductID);
cmd.Parameters.AddWithValue("@VariationMatrixID", VariationMatrixID);
cmd.CommandText = SQL;
dt = new System.Data.DataTable(strDataTableName);
base.MySqlDataAdapterFill(cmd, dt);
foreach (System.Data.DataRow dr in dt.Rows)
{
PromoBySupplierValue = decimal.Parse(dr["PromoBySupplierValue"].ToString());
CouponRemarks = dr["CouponRemarks"].ToString();
return boHasPromoBySupplier;
}
/*******************************Up to VariationsMatrix ID *****************************/
SQL = "SELECT " +
"PromoBySupplierItemsID, " +
"a.PromoBySupplierID, " +
"ProductGroupID, " +
"ProductSubGroupID, " +
"ProductID, " +
"VariationMatrixID, " +
"PromoBySupplierValue, " +
"CouponRemarks " +
"FROM tblPromoBySupplierItems a " +
"INNER JOIN tblPromoBySupplier b ON a.PromoBySupplierID = b.PromoBySupplierID AND a.PromoBySupplierID = @PromoBySupplierID " +
"WHERE " + (string.IsNullOrEmpty(strSpecialSupplierIDs) ? "ContactID = 0 " : "ContactID IN (0, " + strSpecialSupplierIDs + ") ") +
"AND ProductGroupID = 0 " +
"AND ProductSubGroupID = 0 " +
"AND ProductID = 0 " +
"AND VariationMatrixID = @VariationMatrixID " +
"AND Status = 1 " +
"AND DATE_FORMAT(StartDate, '%Y-%m-%d %H:%i') <= DATE_FORMAT(NOW(), '%Y-%m-%d %H:%i') " +
"AND DATE_FORMAT(EndDate, '%Y-%m-%d %H:%i') >= DATE_FORMAT(NOW(), '%Y-%m-%d %H:%i') ORDER BY PromoBySupplierValue ASC LIMIT 1;";
cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.Parameters.AddWithValue("@PromoBySupplierID", clsPromoBySupplierDetails.PromoBySupplierID);
cmd.Parameters.AddWithValue("@VariationMatrixID", VariationMatrixID);
cmd.CommandText = SQL;
dt = new System.Data.DataTable(strDataTableName);
base.MySqlDataAdapterFill(cmd, dt);
foreach (System.Data.DataRow dr in dt.Rows)
{
PromoBySupplierValue = decimal.Parse(dr["PromoBySupplierValue"].ToString());
CouponRemarks = dr["CouponRemarks"].ToString();
return boHasPromoBySupplier;
}
/*******************************Up to group, Sub, Prod ID *****************************/
SQL = "SELECT " +
"PromoBySupplierItemsID, " +
"a.PromoBySupplierID, " +
"ProductGroupID, " +
"ProductSubGroupID, " +
"ProductID, " +
"VariationMatrixID, " +
"PromoBySupplierValue, " +
"CouponRemarks " +
"FROM tblPromoBySupplierItems a " +
"INNER JOIN tblPromoBySupplier b ON a.PromoBySupplierID = b.PromoBySupplierID AND a.PromoBySupplierID = @PromoBySupplierID " +
"WHERE " + (string.IsNullOrEmpty(strSpecialSupplierIDs) ? "ContactID = 0 " : "ContactID IN (0, " + strSpecialSupplierIDs + ") ") +
"AND ProductGroupID = @ProductGroupID " +
"AND ProductSubGroupID = @ProductSubGroupID " +
"AND ProductID = @ProductID " +
"AND VariationMatrixID = 0 " +
"AND Status = 1 " +
"AND DATE_FORMAT(StartDate, '%Y-%m-%d %H:%i') <= DATE_FORMAT(NOW(), '%Y-%m-%d %H:%i') " +
"AND DATE_FORMAT(EndDate, '%Y-%m-%d %H:%i') >= DATE_FORMAT(NOW(), '%Y-%m-%d %H:%i') ORDER BY PromoBySupplierValue ASC LIMIT 1;";
cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.Parameters.AddWithValue("@PromoBySupplierID", clsPromoBySupplierDetails.PromoBySupplierID);
cmd.Parameters.AddWithValue("@ProductGroupID", ProductGroupID);
cmd.Parameters.AddWithValue("@ProductSubGroupID", ProductSubGroupID);
cmd.Parameters.AddWithValue("@ProductID", ProductID);
cmd.CommandText = SQL;
dt = new System.Data.DataTable(strDataTableName);
base.MySqlDataAdapterFill(cmd, dt);
foreach (System.Data.DataRow dr in dt.Rows)
{
PromoBySupplierValue = decimal.Parse(dr["PromoBySupplierValue"].ToString());
CouponRemarks = dr["CouponRemarks"].ToString();
return boHasPromoBySupplier;
}
/*******************************Up to Sub, Prod ID *****************************/
SQL = "SELECT " +
"PromoBySupplierItemsID, " +
"a.PromoBySupplierID, " +
"ProductGroupID, " +
"ProductSubGroupID, " +
"ProductID, " +
"VariationMatrixID, " +
"PromoBySupplierValue, " +
"CouponRemarks " +
"FROM tblPromoBySupplierItems a " +
"INNER JOIN tblPromoBySupplier b ON a.PromoBySupplierID = b.PromoBySupplierID AND a.PromoBySupplierID = @PromoBySupplierID " +
"WHERE " + (string.IsNullOrEmpty(strSpecialSupplierIDs) ? "ContactID = 0 " : "ContactID IN (0, " + strSpecialSupplierIDs + ") ") +
"AND ProductGroupID = 0 " +
"AND ProductSubGroupID = @ProductSubGroupID " +
"AND ProductID = @ProductID " +
"AND VariationMatrixID = 0 " +
"AND Status = 1 " +
"AND DATE_FORMAT(StartDate, '%Y-%m-%d %H:%i') <= DATE_FORMAT(NOW(), '%Y-%m-%d %H:%i') " +
"AND DATE_FORMAT(EndDate, '%Y-%m-%d %H:%i') >= DATE_FORMAT(NOW(), '%Y-%m-%d %H:%i') ORDER BY PromoBySupplierValue ASC LIMIT 1;";
cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.Parameters.AddWithValue("@PromoBySupplierID", clsPromoBySupplierDetails.PromoBySupplierID);
cmd.Parameters.AddWithValue("@ProductSubGroupID", ProductSubGroupID);
cmd.Parameters.AddWithValue("@ProductID", ProductID);
cmd.CommandText = SQL;
dt = new System.Data.DataTable(strDataTableName);
base.MySqlDataAdapterFill(cmd, dt);
foreach (System.Data.DataRow dr in dt.Rows)
{
PromoBySupplierValue = decimal.Parse(dr["PromoBySupplierValue"].ToString());
CouponRemarks = dr["CouponRemarks"].ToString();
return boHasPromoBySupplier;
}
/*******************************Up to group, Sub, Prod and VariationMatrix ID *****************************/
SQL = "SELECT " +
"PromoBySupplierItemsID, " +
"a.PromoBySupplierID, " +
"ProductGroupID, " +
"ProductSubGroupID, " +
"ProductID, " +
"VariationMatrixID, " +
"PromoBySupplierValue, " +
"CouponRemarks " +
"FROM tblPromoBySupplierItems a " +
"INNER JOIN tblPromoBySupplier b ON a.PromoBySupplierID = b.PromoBySupplierID AND a.PromoBySupplierID = @PromoBySupplierID " +
"WHERE " + (string.IsNullOrEmpty(strSpecialSupplierIDs) ? "ContactID = 0 " : "ContactID IN (0, " + strSpecialSupplierIDs + ") ") +
"AND ProductGroupID = 0 " +
"AND ProductSubGroupID = 0 " +
"AND ProductID = @ProductID " +
"AND VariationMatrixID = 0 " +
"AND Status = 1 " +
"AND DATE_FORMAT(StartDate, '%Y-%m-%d %H:%i') <= DATE_FORMAT(NOW(), '%Y-%m-%d %H:%i') " +
"AND DATE_FORMAT(EndDate, '%Y-%m-%d %H:%i') >= DATE_FORMAT(NOW(), '%Y-%m-%d %H:%i') ORDER BY PromoBySupplierValue ASC LIMIT 1;";
cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.Parameters.AddWithValue("@PromoBySupplierID", clsPromoBySupplierDetails.PromoBySupplierID);
cmd.Parameters.AddWithValue("@ProductID", ProductID);
cmd.CommandText = SQL;
dt = new System.Data.DataTable(strDataTableName);
base.MySqlDataAdapterFill(cmd, dt);
foreach (System.Data.DataRow dr in dt.Rows)
{
PromoBySupplierValue = decimal.Parse(dr["PromoBySupplierValue"].ToString());
CouponRemarks = dr["CouponRemarks"].ToString();
return boHasPromoBySupplier;
}
/*******************************Up to group, Sub ID *****************************/
SQL = "SELECT " +
"PromoBySupplierItemsID, " +
"a.PromoBySupplierID, " +
"ProductGroupID, " +
"ProductSubGroupID, " +
"ProductID, " +
"VariationMatrixID, " +
"PromoBySupplierValue, " +
"CouponRemarks " +
"FROM tblPromoBySupplierItems a " +
"INNER JOIN tblPromoBySupplier b ON a.PromoBySupplierID = b.PromoBySupplierID AND a.PromoBySupplierID = @PromoBySupplierID " +
"WHERE " + (string.IsNullOrEmpty(strSpecialSupplierIDs) ? "ContactID = 0 " : "ContactID IN (0, " + strSpecialSupplierIDs + ") ") +
"AND ProductGroupID = @ProductGroupID " +
"AND ProductSubGroupID = @ProductSubGroupID " +
"AND ProductID = 0 " +
"AND VariationMatrixID = 0 " +
"AND Status = 1 " +
"AND DATE_FORMAT(StartDate, '%Y-%m-%d %H:%i') <= DATE_FORMAT(NOW(), '%Y-%m-%d %H:%i') " +
"AND DATE_FORMAT(EndDate, '%Y-%m-%d %H:%i') >= DATE_FORMAT(NOW(), '%Y-%m-%d %H:%i') ORDER BY PromoBySupplierValue ASC LIMIT 1;";
cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.Parameters.AddWithValue("@PromoBySupplierID", clsPromoBySupplierDetails.PromoBySupplierID);
cmd.Parameters.AddWithValue("@ProductGroupID", ProductGroupID);
cmd.Parameters.AddWithValue("@ProductSubGroupID", ProductSubGroupID);
cmd.CommandText = SQL;
dt = new System.Data.DataTable(strDataTableName);
base.MySqlDataAdapterFill(cmd, dt);
foreach (System.Data.DataRow dr in dt.Rows)
{
PromoBySupplierValue = decimal.Parse(dr["PromoBySupplierValue"].ToString());
CouponRemarks = dr["CouponRemarks"].ToString();
return boHasPromoBySupplier;
}
/*******************************Up to Sub ID *****************************/
SQL = "SELECT " +
"PromoBySupplierItemsID, " +
"a.PromoBySupplierID, " +
"ProductGroupID, " +
"ProductSubGroupID, " +
"ProductID, " +
"VariationMatrixID, " +
"PromoBySupplierValue, " +
"CouponRemarks " +
"FROM tblPromoBySupplierItems a " +
"INNER JOIN tblPromoBySupplier b ON a.PromoBySupplierID = b.PromoBySupplierID AND a.PromoBySupplierID = @PromoBySupplierID " +
"WHERE " + (string.IsNullOrEmpty(strSpecialSupplierIDs) ? "ContactID = 0 " : "ContactID IN (0, " + strSpecialSupplierIDs + ") ") +
"AND ProductGroupID = 0 " +
"AND ProductSubGroupID = @ProductSubGroupID " +
"AND ProductID = 0 " +
"AND VariationMatrixID = 0 " +
"AND Status = 1 " +
"AND DATE_FORMAT(StartDate, '%Y-%m-%d %H:%i') <= DATE_FORMAT(NOW(), '%Y-%m-%d %H:%i') " +
"AND DATE_FORMAT(EndDate, '%Y-%m-%d %H:%i') >= DATE_FORMAT(NOW(), '%Y-%m-%d %H:%i') ORDER BY PromoBySupplierValue ASC LIMIT 1;";
cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.Parameters.AddWithValue("@PromoBySupplierID", clsPromoBySupplierDetails.PromoBySupplierID);
cmd.Parameters.AddWithValue("@ProductSubGroupID", ProductSubGroupID);
cmd.CommandText = SQL;
dt = new System.Data.DataTable(strDataTableName);
base.MySqlDataAdapterFill(cmd, dt);
foreach (System.Data.DataRow dr in dt.Rows)
{
PromoBySupplierValue = decimal.Parse(dr["PromoBySupplierValue"].ToString());
CouponRemarks = dr["CouponRemarks"].ToString();
return boHasPromoBySupplier;
}
/*******************************Up to group ID *****************************/
SQL = "SELECT " +
"PromoBySupplierItemsID, " +
"a.PromoBySupplierID, " +
"ProductGroupID, " +
"ProductSubGroupID, " +
"ProductID, " +
"VariationMatrixID, " +
"PromoBySupplierValue, " +
"CouponRemarks " +
"FROM tblPromoBySupplierItems a " +
"INNER JOIN tblPromoBySupplier b ON a.PromoBySupplierID = b.PromoBySupplierID AND a.PromoBySupplierID = @PromoBySupplierID " +
"WHERE " + (string.IsNullOrEmpty(strSpecialSupplierIDs) ? "ContactID = 0 " : "ContactID IN (0, " + strSpecialSupplierIDs + ") ") +
"AND ProductGroupID = @ProductGroupID " +
"AND ProductSubGroupID = 0 " +
"AND ProductID = 0 " +
"AND VariationMatrixID = 0 " +
"AND Status = 1 " +
"AND DATE_FORMAT(StartDate, '%Y-%m-%d %H:%i') <= DATE_FORMAT(NOW(), '%Y-%m-%d %H:%i') " +
"AND DATE_FORMAT(EndDate, '%Y-%m-%d %H:%i') >= DATE_FORMAT(NOW(), '%Y-%m-%d %H:%i') ORDER BY PromoBySupplierValue ASC LIMIT 1;";
cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.Parameters.AddWithValue("@PromoBySupplierID", clsPromoBySupplierDetails.PromoBySupplierID);
cmd.Parameters.AddWithValue("@ProductGroupID", ProductGroupID);
cmd.CommandText = SQL;
dt = new System.Data.DataTable(strDataTableName);
base.MySqlDataAdapterFill(cmd, dt);
foreach (System.Data.DataRow dr in dt.Rows)
{
PromoBySupplierValue = decimal.Parse(dr["PromoBySupplierValue"].ToString());
CouponRemarks = dr["CouponRemarks"].ToString();
return boHasPromoBySupplier;
}
/*******************************Up to all *****************************/
SQL = "SELECT " +
"PromoBySupplierItemsID, " +
"a.PromoBySupplierID, " +
"ProductGroupID, " +
"ProductSubGroupID, " +
"ProductID, " +
"VariationMatrixID, " +
"PromoBySupplierValue, " +
"CouponRemarks " +
"FROM tblPromoBySupplierItems a " +
"INNER JOIN tblPromoBySupplier b ON a.PromoBySupplierID = b.PromoBySupplierID AND a.PromoBySupplierID = @PromoBySupplierID " +
"WHERE " + (string.IsNullOrEmpty(strSpecialSupplierIDs) ? "ContactID = 0 " : "ContactID IN (0, " + strSpecialSupplierIDs + ") ") +
"AND ProductGroupID = 0 " +
"AND ProductSubGroupID = 0 " +
"AND ProductID = 0 " +
"AND VariationMatrixID = 0 " +
"AND Status = 1 " +
"AND DATE_FORMAT(StartDate, '%Y-%m-%d %H:%i') <= DATE_FORMAT(NOW(), '%Y-%m-%d %H:%i') " +
"AND DATE_FORMAT(EndDate, '%Y-%m-%d %H:%i') >= DATE_FORMAT(NOW(), '%Y-%m-%d %H:%i') ORDER BY PromoBySupplierValue ASC LIMIT 1;";
cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.Parameters.AddWithValue("@PromoBySupplierID", clsPromoBySupplierDetails.PromoBySupplierID);
cmd.CommandText = SQL;
dt = new System.Data.DataTable(strDataTableName);
base.MySqlDataAdapterFill(cmd, dt);
foreach (System.Data.DataRow dr in dt.Rows)
{
PromoBySupplierValue = decimal.Parse(dr["PromoBySupplierValue"].ToString());
CouponRemarks = dr["CouponRemarks"].ToString();
return boHasPromoBySupplier;
}
}
catch (Exception ex)
{
base.ThrowException(ex);
}
return false;
}
