public Int32 Save(PromoBySupplierItemsDetails Details)
{
try
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQL = "CALL procSavePromoBySupplierItems(@PromoBySupplierItemsID, @PromoBySupplierID, @ContactID, @ProductGroupID," +
"@ProductSubGroupID, @ProductID, @VariationMatrixID," +
"@PromoBySupplierValue, @CouponRemarks, @CreatedOn, @LastModified);";
cmd.Parameters.AddWithValue("PromoBySupplierItemsID", Details.PromoBySupplierItemsID);
cmd.Parameters.AddWithValue("PromoBySupplierID", Details.PromoBySupplierID);
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("PromoBySupplierValue", Details.PromoBySupplierValue);
cmd.Parameters.AddWithValue("CouponRemarks", Details.CouponRemarks);
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 void Update(PromoBySupplierItemsDetails Details)
{
try
{
Save(Details);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public Int64 Insert(PromoBySupplierItemsDetails Details)
{
try
{
Save(Details);
return Int64.Parse(base.getLAST_INSERT_ID(this));
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
private void SaveRecord()
{
PromoBySupplierItemsDetails clsDetails = new PromoBySupplierItemsDetails();
clsDetails.PromoBySupplierID = Convert.ToInt64(lblPromoBySupplierID.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.PromoBySupplierValue = Convert.ToDecimal(txtPromoBySupplierValue.Text);
clsDetails.CouponRemarks = txtCouponRemarks.Text;
PromoBySupplierItems clsPromoBySupplierItems = new PromoBySupplierItems();
clsPromoBySupplierItems.Insert(clsDetails);
clsPromoBySupplierItems.CommitAndDispose();
LoadList();
}
private PromoBySupplierItemsDetails setDetails(System.Data.DataTable dt)
{
PromoBySupplierItemsDetails Details = new PromoBySupplierItemsDetails();
foreach (System.Data.DataRow dr in dt.Rows)
{
Details.PromoBySupplierItemsID = Int64.Parse(dr["PromoBySupplierItemsID"].ToString());
Details.PromoBySupplierID = Int64.Parse(dr["PromoBySupplierID"].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.PromoBySupplierValue = Decimal.Parse(dr["PromoBySupplierValue"].ToString());
Details.CouponRemarks = dr["CouponRemarks"].ToString();
}
return Details;
}
