public Int64 Insert(PromoItemsDetails Details)
{
try
{
Save(Details);
string SQL = "SELECT LAST_INSERT_ID();";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
System.Data.DataTable dt = new System.Data.DataTable("LAST_INSERT_ID");
base.MySqlDataAdapterFill(cmd, dt);
Int64 iID = 0;
foreach (System.Data.DataRow dr in dt.Rows)
{
iID = Int64.Parse(dr[0].ToString());
}
return iID;
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
private void SaveRecord()
{
PromoItemsDetails clsDetails = new PromoItemsDetails();
clsDetails.PromoID = Convert.ToInt64(lblPromoID.Text);
clsDetails.ContactID = Convert.ToInt64(cboContact.SelectedItem.Value);
clsDetails.ProductGroupID = Convert.ToInt64(cboProductGroup.SelectedItem.Value);
clsDetails.ProductSubGroupID = Convert.ToInt64(cboSubGroup.SelectedItem.Value);
clsDetails.ProductID = Convert.ToInt64(cboProducts.SelectedItem.Value);
clsDetails.VariationMatrixID = Convert.ToInt64(cboProductVariation.SelectedItem.Value);
clsDetails.Quantity = Convert.ToDecimal(txtQuantity.Text);
clsDetails.PromoValue = Convert.ToDecimal(txtPromoValue.Text);
clsDetails.InPercent = chkInPercentage.Checked;
PromoItems clsPromoItems = new PromoItems();
clsPromoItems.Insert(clsDetails);
clsPromoItems.CommitAndDispose();
LoadList();
}
public void Update(PromoItemsDetails Details)
{
try
{
Save(Details);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public PromoItemsDetails DetailsByProductID(Int64 ProductID)
{
try
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQL= "";
SQL = "SELECT " +
"PromoItemsID, " +
"a.PromoID, " +
"ContactID, " +
"ProductGroupID, " +
"ProductSubGroupID, " +
"ProductID, " +
"VariationMatrixID, " +
"Quantity, " +
"PromoValue, " +
"InPercent " +
"FROM tblPromoItems a " +
"INNER JOIN tblPromo b ON a.PromoID = b.PromoID " +
"WHERE ProductID = @ProductID " +
"AND DATE_FORMAT(StartDate, '%Y-%m-%d %H:%i') >= CURRENT_DATE " +
"AND DATE_FORMAT(EndDate, '%Y-%m-%d %H:%i') <= CURRENT_DATE;";
cmd.Parameters.AddWithValue("@ProductID", ProductID);
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);
PromoItemsDetails Details = new PromoItemsDetails();
foreach (System.Data.DataRow dr in dt.Rows)
{
Details.PromoItemsID = Int64.Parse(dr["PromoItemsID"].ToString());
Details.PromoID = Int64.Parse(dr["PromoID"].ToString());
Details.ContactID = Int64.Parse(dr["ContactID"].ToString());
Details.ProductGroupID = Int64.Parse(dr["ProductGroupID"].ToString());
Details.ProductSubGroupID = Int64.Parse(dr["ProductSubGroupID"].ToString());
Details.ProductID = Int64.Parse(dr["ProductID"].ToString());
Details.VariationMatrixID = Int64.Parse(dr["VariationMatrixID"].ToString());
Details.Quantity = Decimal.Parse(dr["Quantity"].ToString());
Details.PromoValue = Decimal.Parse(dr["PromoValue"].ToString());
Details.InPercent = bool.Parse(dr["InPercent"].ToString());
}
return Details;
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public Int32 Save(PromoItemsDetails Details)
{
try
{
string SQL = "CALL procSavePromoItems(@PromoItemsID, @PromoID, @ContactID, @ProductGroupID," +
"@ProductSubGroupID, @ProductID, @VariationMatrixID, @Quantity," +
"@PromoValue, @InPercent, @CreatedOn, @LastModified);";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
cmd.Parameters.AddWithValue("PromoItemsID", Details.PromoItemsID);
cmd.Parameters.AddWithValue("PromoID", Details.PromoID);
cmd.Parameters.AddWithValue("ContactID", Details.ContactID);
cmd.Parameters.AddWithValue("ProductGroupID", Details.ProductGroupID);
cmd.Parameters.AddWithValue("ProductSubGroupID", Details.ProductSubGroupID);
cmd.Parameters.AddWithValue("ProductID", Details.ProductID);
cmd.Parameters.AddWithValue("VariationMatrixID", Details.VariationMatrixID);
cmd.Parameters.AddWithValue("Quantity", Details.Quantity);
cmd.Parameters.AddWithValue("PromoValue", Details.PromoValue);
cmd.Parameters.AddWithValue("InPercent", Details.InPercent);
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);
return base.ExecuteNonQuery(cmd);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
