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