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