private Int64 SaveRecord() { ContactDetails clsDetails = new ContactDetails(); clsDetails.ContactCode = txtVendorCode.Text; clsDetails.ContactName = txtVendorName.Text; clsDetails.ContactGroupID = Convert.ToInt32(cboGroup.SelectedItem.Value); clsDetails.ModeOfTerms = (ModeOfTerms)Enum.Parse(typeof(ModeOfTerms), cboModeOfTerms.SelectedItem.Value); clsDetails.Terms = Convert.ToInt32(txtTerms.Text); clsDetails.Address = txtAddress.Text; clsDetails.BusinessName = txtBusinessName.Text; clsDetails.TelephoneNo = txtTelephoneNo.Text; clsDetails.Remarks = txtRemarks.Text; clsDetails.Debit = Convert.ToDecimal(txtDebit.Text); clsDetails.Credit = Convert.ToDecimal(txtCredit.Text); clsDetails.IsCreditAllowed = chkIsCreditAllowed.Checked; //if (chkIsCreditAllowed.Checked == false) //else // clsDetails.IsCreditAllowed = 1; clsDetails.CreditLimit = Convert.ToDecimal(txtCreditLimit.Text); clsDetails.DepartmentID = Convert.ToInt16(cboDepartment.SelectedItem.Value); clsDetails.PositionID = Convert.ToInt16(cboPosition.SelectedItem.Value); // 13Mar2015 : Added for Pharmaceuticals clsDetails.TINNo = txtTINNo.Text; clsDetails.LTONo = txtLTONo.Text; Contacts clsContact = new Contacts(); Int64 id = clsContact.Insert(clsDetails); clsContact.CommitAndDispose(); return id; }
public void Suspend(Int64 TransactionID, decimal GrossSales, decimal SubTotal, decimal NetSales, ContactDetails details) { try { MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; string SQL = "UPDATE tblTransactions SET " + "CustomerID = @CustomerID," + "CustomerName = @CustomerName, " + "CustomerGroupName = @CustomerGroupName, " + "TransactionStatus = @TransactionStatus, " + "GrossSales = @GrossSales, " + "SubTotal = @SubTotal, " + "NetSales = @NetSales, " + "DateSuspended = NOW(), " + "LastModified = NOW() " + "WHERE TransactionID = @TransactionID;"; cmd.Parameters.AddWithValue("@CustomerID", details.ContactID); cmd.Parameters.AddWithValue("@CustomerName", details.ContactName); cmd.Parameters.AddWithValue("@CustomerGroupName", details.ContactGroupName); cmd.Parameters.AddWithValue("@GrossSales", GrossSales); cmd.Parameters.AddWithValue("@SubTotal", SubTotal); cmd.Parameters.AddWithValue("@NetSales", NetSales); cmd.Parameters.AddWithValue("@TransactionStatus", TransactionStatus.Suspended.ToString("d")); cmd.Parameters.AddWithValue("@TransactionID", TransactionID); cmd.CommandText = SQL; base.ExecuteNonQuery(cmd); } catch (Exception ex) { throw base.ThrowException(ex); } }
private void SaveRecord() { Contacts clsContact = new Contacts(); ContactDetails clsDetails = new ContactDetails(); clsDetails.ContactID = Convert.ToInt32(lblContactID.Text); clsDetails.ContactCode = txtContactCode.Text; clsDetails.ContactName = txtContactName.Text; clsDetails.ContactGroupID = Convert.ToInt32(cboGroup.SelectedItem.Value); clsDetails.ModeOfTerms = (ModeOfTerms)Enum.Parse(typeof(ModeOfTerms), cboModeOfTerms.SelectedItem.Value); clsDetails.Terms = Convert.ToInt32(txtTerms.Text); clsDetails.Address = txtAddress.Text; clsDetails.BusinessName = txtBusinessName.Text; clsDetails.TelephoneNo = txtTelephoneNo.Text; clsDetails.Remarks = txtRemarks.Text; clsDetails.Debit = Convert.ToDecimal(txtDebit.Text); clsDetails.Credit = Convert.ToDecimal(txtCredit.Text); clsDetails.IsCreditAllowed = chkIsCreditAllowed.Checked; //if (chkIsCreditAllowed.Checked == false) // clsDetails.IsCreditAllowed = 0; //else // clsDetails.IsCreditAllowed = 1; clsDetails.CreditLimit = Convert.ToDecimal(txtCreditLimit.Text); clsDetails.DepartmentID = Convert.ToInt16(cboDepartment.SelectedItem.Value); clsDetails.PositionID = Convert.ToInt16(cboPosition.SelectedItem.Value); clsContact.Update(clsDetails); clsContact.CommitAndDispose(); }
private ContactDetails setDetails(System.Data.DataTable dt) { ContactDetails Details = new ContactDetails(); try { foreach(System.Data.DataRow dr in dt.Rows) { Details.ContactID = Int64.Parse(dr["ContactID"].ToString()); Details.SequenceNo = Int32.Parse(dr["SequenceNo"].ToString()); Details.ContactCode = "" + dr["ContactCode"].ToString(); Details.ContactName = "" + dr["ContactName"].ToString(); Details.ContactGroupID = Int32.Parse(dr["ContactGroupID"].ToString()); Details.ContactGroupName = "" + dr["ContactGroupName"].ToString(); Details.ModeOfTerms = (ModeOfTerms)Enum.Parse(typeof(ModeOfTerms), dr["ModeOfTerms"].ToString()); Details.Terms = Int32.Parse(dr["Terms"].ToString()); Details.Address = "" + dr["Address"].ToString(); Details.BusinessName = "" + dr["BusinessName"].ToString(); Details.TelephoneNo = "" + dr["TelephoneNo"].ToString(); Details.Remarks = "" + dr["Remarks"].ToString(); Details.Debit = decimal.Parse(dr["Debit"].ToString()); Details.Credit =decimal.Parse(dr["Credit"].ToString()); Details.CreditLimit = decimal.Parse(dr["CreditLimit"].ToString()); Details.IsCreditAllowed = bool.Parse(dr["IsCreditAllowed"].ToString()); Details.DateCreated = DateTime.Parse(dr["DateCreated"].ToString()); Details.Deleted = bool.Parse(dr["Deleted"].ToString()); Details.DepartmentID = Int16.Parse(dr["DepartmentID"].ToString()); Details.DepartmentName = "" + dr["DepartmentName"].ToString(); Details.PositionID = Int16.Parse(dr["PositionID"].ToString()); Details.PositionName = "" + dr["PositionName"].ToString(); Details.LastCheckInDate = DateTime.Parse(dr["LastCheckInDate"].ToString()); Details.TINNo = "" + dr["TINNo"].ToString(); Details.LTONo = "" + dr["LTONo"].ToString(); Details.PriceLevel = (PriceLevel)Enum.Parse(typeof(PriceLevel), dr["PriceLevel"].ToString()); Details.isLock = bool.Parse(dr["isLock"].ToString()); } // Sep 14, 2011 : Lemu - for reward points ContactReward clsContactReward = new ContactReward(base.Connection, base.Transaction); Details.RewardDetails = clsContactReward.Details(Details.ContactID); // Nov 2, 2011 : Lemu - for credit ContactCreditCardInfos clsContactCredit = new ContactCreditCardInfos(base.Connection, base.Transaction); Details.CreditDetails = clsContactCredit.Details(Details.ContactID); Details.CreditDetails.CreditLimit = Details.CreditLimit; if (!Details.IsCreditAllowed) Details.CreditDetails.CreditActive = Details.IsCreditAllowed; else { Details.CreditDetails.CreditActive = checkCreditActive(Details.CreditDetails.CreditCardStatus); } // Oct 12, 2013 : - get additional details Details.AdditionalDetails = new ContactAddOns(base.Connection, base.Transaction).Details(Details.ContactID); } catch (Exception ex) { throw base.ThrowException(ex); } return Details; }
public Int32 Save(ContactDetails Details) { try { MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; string SQL = "CALL procSaveContact(@ContactID, @SequenceNo, @ContactCode, @ContactName, @ContactGroupID, @ModeOfTerms," + "@Terms, @Address, @BusinessName, @TelephoneNo, @Remarks, @Debit, @Credit," + "@CreditLimit, @IsCreditAllowed, @DateCreated, @Deleted, @DepartmentID," + "@PositionID, @isLock, @CreatedOn, @LastModified);"; cmd.Parameters.AddWithValue("ContactID", Details.ContactID); cmd.Parameters.AddWithValue("SequenceNo", Details.SequenceNo); cmd.Parameters.AddWithValue("ContactCode", Details.ContactCode); cmd.Parameters.AddWithValue("ContactName", Details.ContactName); cmd.Parameters.AddWithValue("ContactGroupID", Details.ContactGroupID); cmd.Parameters.AddWithValue("ModeOfTerms", Details.ModeOfTerms); cmd.Parameters.AddWithValue("Terms", Details.Terms); cmd.Parameters.AddWithValue("Address", Details.Address); cmd.Parameters.AddWithValue("BusinessName", Details.BusinessName); cmd.Parameters.AddWithValue("TelephoneNo", Details.TelephoneNo); cmd.Parameters.AddWithValue("Remarks", Details.Remarks); cmd.Parameters.AddWithValue("Debit", Details.Debit); cmd.Parameters.AddWithValue("Credit", Details.Credit); cmd.Parameters.AddWithValue("CreditLimit", Details.CreditLimit); cmd.Parameters.AddWithValue("IsCreditAllowed", Details.IsCreditAllowed); cmd.Parameters.AddWithValue("DateCreated", Details.DateCreated); cmd.Parameters.AddWithValue("Deleted", Details.Deleted); cmd.Parameters.AddWithValue("DepartmentID", Details.DepartmentID); cmd.Parameters.AddWithValue("PositionID", Details.PositionID); cmd.Parameters.AddWithValue("isLock", Details.isLock); 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(ContactDetails Details) { try { MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; string SQL= "UPDATE tblContacts SET " + "SequenceNo = @SequenceNo, " + "ContactCode = @ContactCode, " + "ContactName = @ContactName, " + "ContactGroupID = @ContactGroupID, " + "ModeOfTerms = @ModeOfTerms, " + "Terms = @Terms, " + "Address = @Address, " + "BusinessName = @BusinessName, " + "TelephoneNo = @TelephoneNo, " + "Remarks = @Remarks, " + "Debit = @Debit, " + "Credit = @Credit, " + "CreditLimit = @CrdtLimit, " + "IsCreditAllowed = @IsCreditAllowed, " + "DepartmentID = @DepartmentID, " + "PositionID = @PositionID, " + "TINNo = @TINNo, " + "LTONo = @LTONo " + "WHERE ContactID = @ContactID;"; cmd.Parameters.AddWithValue("@SequenceNo", Details.SequenceNo); cmd.Parameters.AddWithValue("@ContactCode", Details.ContactCode); cmd.Parameters.AddWithValue("@ContactName", Details.ContactName); cmd.Parameters.AddWithValue("@ContactGroupID", Details.ContactGroupID); cmd.Parameters.AddWithValue("@ModeOfTerms", Details.ModeOfTerms.ToString("d")); cmd.Parameters.AddWithValue("@Terms", Details.Terms); cmd.Parameters.AddWithValue("@Address", Details.Address); cmd.Parameters.AddWithValue("@BusinessName", Details.BusinessName); cmd.Parameters.AddWithValue("@TelephoneNo", Details.TelephoneNo); cmd.Parameters.AddWithValue("@Remarks", Details.Remarks); cmd.Parameters.AddWithValue("@Debit", Details.Debit); cmd.Parameters.AddWithValue("@Credit", Details.Credit); cmd.Parameters.AddWithValue("@CrdtLimit", Details.CreditLimit); cmd.Parameters.AddWithValue("@IsCreditAllowed", Details.IsCreditAllowed); cmd.Parameters.AddWithValue("@DepartmentID", Details.DepartmentID); cmd.Parameters.AddWithValue("@PositionID", Details.PositionID); cmd.Parameters.AddWithValue("@TINNo", Details.TINNo); cmd.Parameters.AddWithValue("@LTONo", Details.LTONo); cmd.Parameters.AddWithValue("@ContactID", Details.ContactID); cmd.CommandText = SQL; base.ExecuteNonQuery(cmd); //Sep 15, 2013 Include the sepecific details if there's any if (Details.AdditionalDetails.ContactID != 0) _ContactAddOns.Save(Details.AdditionalDetails); } catch (Exception ex) { throw base.ThrowException(ex); } }
public long Insert(ContactDetails Details) { try { MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; string SQL="INSERT INTO tblContacts (" + "SequenceNo, " + "ContactCode, " + "ContactName, " + "ContactGroupID, " + "ModeOfTerms, " + "Terms, " + "Address, " + "BusinessName, " + "TelephoneNo, " + "Remarks, " + "Debit, " + "Credit, " + "CreditLimit, " + "IsCreditAllowed, " + "DateCreated," + "DepartmentID," + "PositionID," + "TINNo," + "LTONo" + ") VALUES (" + "@SequenceNo, " + "@ContactCode, " + "@ContactName, " + "@ContactGroupID, " + "@ModeOfTerms, " + "@Terms, " + "@Address, " + "@BusinessName, " + "@TelephoneNo, " + "@Remarks, " + "@Debit, " + "@Credit, " + "@CrdtLimit, " + "@IsCreditAllowed, " + "@DateCreated," + "@DepartmentID," + "@PositionID," + "@TINNo," + "@LTONo" + ");"; cmd.Parameters.AddWithValue("@SequenceNo", Details.SequenceNo); cmd.Parameters.AddWithValue("@ContactCode", Details.ContactCode); cmd.Parameters.AddWithValue("@ContactName", Details.ContactName); cmd.Parameters.AddWithValue("@ContactGroupID", Details.ContactGroupID); cmd.Parameters.AddWithValue("@ModeOfTerms", Details.ModeOfTerms.ToString("d")); cmd.Parameters.AddWithValue("@Terms", Details.Terms); cmd.Parameters.AddWithValue("@Address", Details.Address); cmd.Parameters.AddWithValue("@BusinessName", Details.BusinessName); cmd.Parameters.AddWithValue("@TelephoneNo", Details.TelephoneNo); cmd.Parameters.AddWithValue("@Remarks", Details.Remarks); cmd.Parameters.AddWithValue("@Debit", Details.Debit); cmd.Parameters.AddWithValue("@Credit", Details.Credit); cmd.Parameters.AddWithValue("@CrdtLimit", Details.CreditLimit); cmd.Parameters.AddWithValue("@IsCreditAllowed", Details.IsCreditAllowed); cmd.Parameters.AddWithValue("@DepartmentID", Details.DepartmentID); cmd.Parameters.AddWithValue("@PositionID", Details.PositionID); cmd.Parameters.AddWithValue("@TINNo", Details.TINNo); cmd.Parameters.AddWithValue("@LTONo", Details.LTONo); cmd.Parameters.AddWithValue("@DateCreated", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); cmd.CommandText = SQL; base.ExecuteNonQuery(cmd); Int64 iID = Int64.Parse(base.getLAST_INSERT_ID(this)); // 15Sep2013 : Include the sepecific details if there's any if (!string.IsNullOrEmpty(Details.AdditionalDetails.Salutation)) { Details.AdditionalDetails.ContactID = iID; _ContactAddOns.Save(Details.AdditionalDetails); } else { Details.AdditionalDetails.ContactID = iID; Details.AdditionalDetails.Salutation = "Mr"; Details.AdditionalDetails.FirstName = Details.ContactCode; Details.AdditionalDetails.LastName = Details.ContactName; Details.AdditionalDetails.Address1 = Details.Address; Details.AdditionalDetails.AnniversaryDate = DateTime.Now; Details.AdditionalDetails.BirthDate = Details.DateCreated; Details.AdditionalDetails.BusinessPhoneNo = Details.TelephoneNo; Details.AdditionalDetails.CountryCode = "PH"; Details.AdditionalDetails.CountryID = 1; } return iID; } catch (Exception ex) { throw base.ThrowException(ex); } }
private void Upload1() { //string fn = System.IO.Path.GetFileName(TextBox1.Text); //string SaveLocation = "/RetailPlus/temp/uploaded_" + fn; //System.IO.File.Copy(TextBox1.Text, SaveLocation); //txtPath.PostedFile.SaveAs(SaveLocation); XmlTextReader xmlReader = new XmlTextReader(TextBox1.Text); xmlReader.WhitespaceHandling = WhitespaceHandling.None; Branch clsBranch = new Branch(); BranchDetails clsBranchDetails = clsBranch.Details(Convert.ToInt16(cboBranchUpload.SelectedItem.Value.ToString())); clsBranch.CommitAndDispose(); RemoteBranchInventory clsBranchInventory = new RemoteBranchInventory(); clsBranchInventory.GetConnectionToBranch(clsBranchDetails.DBIP); Contacts clsBranchContact = new Contacts(clsBranchInventory.Connection, clsBranchInventory.Transaction); ContactDetails clsBranchContactDetails; ContactGroups clsBranchContactGroup = new ContactGroups(clsBranchInventory.Connection, clsBranchInventory.Transaction); ContactGroupDetails clsContactGroupDetails; Data.Unit clsBranchUnit = new Data.Unit(clsBranchInventory.Connection, clsBranchInventory.Transaction); UnitDetails clsUnitDetails; ProductGroup clsBranchProductGroup = new Data.ProductGroup(clsBranchInventory.Connection, clsBranchInventory.Transaction); ProductGroupDetails clsBranchProductGroupDetails; ProductSubGroup clsBranchProductSubGroup = new Data.ProductSubGroup(clsBranchInventory.Connection, clsBranchInventory.Transaction); ProductSubGroupDetails clsBranchProductSubGroupDetails; //Data.Variation clsBranchVariation = new Variation(clsBranchInventory.Connection, clsBranchInventory.Transaction); Products clsBranchProduct = new Products(clsBranchInventory.Connection, clsBranchInventory.Transaction); ProductDetails clsBranchProductDetails; ProductVariations clsBranchProductVariation = new ProductVariations(clsBranchInventory.Connection, clsBranchInventory.Transaction); ProductVariationDetails clsBranchProductVariationDetails; long lngBranchProductID = 0; long lngProductCtr = 0; long lngProductInserted = 0; while (xmlReader.Read()) { switch (xmlReader.NodeType) { case XmlNodeType.Element: if (xmlReader.Name == "Item") { lngProductCtr++; clsBranchProductDetails = new ProductDetails(); clsBranchProductDetails.BarCode = xmlReader.GetAttribute("BarCode"); clsBranchProductDetails.ProductCode = xmlReader.GetAttribute("ProductCode"); lblError.Text += "Checking <b>" + clsBranchProductDetails.ProductCode + "</b> if exist... "; //check product by barcode clsBranchProductDetails.ProductID = clsBranchProduct.Details(Constants.BRANCH_ID_MAIN, clsBranchProductDetails.BarCode).ProductID; lngBranchProductID = clsBranchProductDetails.ProductID; if (clsBranchProductDetails.ProductID != 0) { lblError.Text += " [Y] barcode exist... next item...<br />"; break; } //check product by product code clsBranchProductDetails.ProductID = clsBranchProduct.Details(Constants.BRANCH_ID_MAIN, clsBranchProductDetails.ProductCode).ProductID; lngBranchProductID = clsBranchProductDetails.ProductID; if (clsBranchProductDetails.ProductID != 0) { clsBranchProduct.UpdateBarcode(clsBranchProductDetails.ProductID, clsBranchProductDetails.BarCode); lblError.Text += " [Y] barcode not exist, product code exist. barcode updated. next item...<br />"; break; } lblError.Text += " [N] inserting product... "; clsBranchProductDetails.BarCode = xmlReader.GetAttribute("BarCode"); clsBranchProductDetails.ProductDesc = xmlReader.GetAttribute("ProductDesc"); clsBranchProductDetails.ProductGroupCode = xmlReader.GetAttribute("ProductGroupCode"); clsBranchProductDetails.ProductGroupName = xmlReader.GetAttribute("ProductGroupName"); clsBranchProductDetails.ProductSubGroupCode = xmlReader.GetAttribute("ProductSubGroupCode"); clsBranchProductDetails.ProductSubGroupName = xmlReader.GetAttribute("ProductSubGroupName"); clsBranchProductDetails.BaseUnitCode = xmlReader.GetAttribute("BaseUnitCode"); clsBranchProductDetails.BaseUnitName = xmlReader.GetAttribute("BaseUnitName"); clsBranchProductDetails.DateCreated = DateTime.Now; clsBranchProductDetails.Price = Convert.ToDecimal(xmlReader.GetAttribute("Price")); clsBranchProductDetails.PurchasePrice = Convert.ToDecimal(xmlReader.GetAttribute("PurchasePrice")); clsBranchProductDetails.IncludeInSubtotalDiscount = Convert.ToBoolean(xmlReader.GetAttribute("IncludeInSubtotalDiscount")); clsBranchProductDetails.VAT = Convert.ToDecimal(xmlReader.GetAttribute("VAT")); clsBranchProductDetails.EVAT = Convert.ToDecimal(xmlReader.GetAttribute("EVAT")); clsBranchProductDetails.LocalTax = Convert.ToDecimal(xmlReader.GetAttribute("LocalTax")); clsBranchProductDetails.Quantity = 0; clsBranchProductDetails.MinThreshold = Convert.ToDecimal(xmlReader.GetAttribute("MinThreshold")); clsBranchProductDetails.MaxThreshold = Convert.ToDecimal(xmlReader.GetAttribute("MaxThreshold")); clsBranchProductDetails.ChartOfAccountIDPurchase = int.Parse(xmlReader.GetAttribute("ChartOfAccountIDPurchase")); clsBranchProductDetails.ChartOfAccountIDSold = int.Parse(xmlReader.GetAttribute("ChartOfAccountIDSold")); clsBranchProductDetails.ChartOfAccountIDInventory = int.Parse(xmlReader.GetAttribute("ChartOfAccountIDInventory")); clsBranchProductDetails.ChartOfAccountIDTaxPurchase = int.Parse(xmlReader.GetAttribute("ChartOfAccountIDTaxPurchase")); clsBranchProductDetails.ChartOfAccountIDTaxSold = int.Parse(xmlReader.GetAttribute("ChartOfAccountIDTaxSold")); clsBranchProductDetails.IsItemSold = Convert.ToBoolean(xmlReader.GetAttribute("IsItemSold")); clsBranchProductDetails.WillPrintProductComposition = Convert.ToBoolean(xmlReader.GetAttribute("WillPrintProductComposition")); clsBranchProductDetails.UpdatedBy = long.Parse(xmlReader.GetAttribute("UpdatedBy")); clsBranchProductDetails.UpdatedOn = Convert.ToDateTime(xmlReader.GetAttribute("UpdatedOn")); clsBranchProductDetails.PercentageCommision = decimal.Parse(xmlReader.GetAttribute("PercentageCommision")); clsBranchProductDetails.QuantityIN = decimal.Parse(xmlReader.GetAttribute("QuantityIN")); clsBranchProductDetails.QuantityOUT = decimal.Parse(xmlReader.GetAttribute("QuantityOUT")); clsBranchProductDetails.SupplierCode = xmlReader.GetAttribute("ContactCode"); clsBranchProductDetails.SupplierID = clsBranchContact.Details(clsBranchProductDetails.SupplierCode).ContactID; if (clsBranchProductDetails.SupplierID == 0) { clsBranchContactDetails = new ContactDetails(); clsBranchContactDetails.ContactGroupID = clsBranchContactGroup.Details(xmlReader.GetAttribute("ContactGroupCode")).ContactGroupID; if (clsBranchContactDetails.ContactGroupID == 0) { clsContactGroupDetails = new ContactGroupDetails(); clsContactGroupDetails.ContactGroupCode = xmlReader.GetAttribute("ContactCode"); clsContactGroupDetails.ContactGroupName = xmlReader.GetAttribute("ContactCode"); clsContactGroupDetails.ContactGroupCategory = (ContactGroupCategory)Enum.Parse(typeof(ContactGroupCategory), xmlReader.GetAttribute("ContactGroupCategory")); clsBranchContactDetails.ContactGroupID = clsBranchContactGroup.Insert(clsContactGroupDetails); } clsBranchContactDetails.ContactCode = xmlReader.GetAttribute("ContactCode"); clsBranchContactDetails.ContactName = xmlReader.GetAttribute("ContactName"); clsBranchContactDetails.ModeOfTerms = (ModeOfTerms)Enum.Parse(typeof(ModeOfTerms), xmlReader.GetAttribute("ModeOfTerms")); clsBranchContactDetails.Terms = Convert.ToInt32(xmlReader.GetAttribute("Terms")); clsBranchContactDetails.Address = xmlReader.GetAttribute("Address"); clsBranchContactDetails.BusinessName = xmlReader.GetAttribute("BusinessName"); clsBranchContactDetails.TelephoneNo = xmlReader.GetAttribute("TelephoneNo"); clsBranchContactDetails.Remarks = xmlReader.GetAttribute("Remarks"); clsBranchContactDetails.Debit = Convert.ToDecimal(xmlReader.GetAttribute("Debit")); clsBranchContactDetails.Credit = Convert.ToDecimal(xmlReader.GetAttribute("Credit")); clsBranchContactDetails.IsCreditAllowed = Convert.ToBoolean(xmlReader.GetAttribute("IsCreditAllowed")); clsBranchContactDetails.CreditLimit = Convert.ToDecimal(xmlReader.GetAttribute("CreditLimit")); clsBranchContactDetails.ContactID = clsBranchContact.Insert(clsBranchContactDetails); } clsBranchProductDetails.BaseUnitCode = xmlReader.GetAttribute("BaseUnitCode"); clsBranchProductDetails.BaseUnitID = clsBranchUnit.Details(clsBranchProductDetails.BaseUnitCode).UnitID; if (clsBranchProductDetails.BaseUnitID == 0) { clsUnitDetails = new UnitDetails(); clsUnitDetails.UnitCode = xmlReader.GetAttribute("BaseUnitCode"); clsUnitDetails.UnitName = xmlReader.GetAttribute("BaseUnitName"); clsBranchProductDetails.BaseUnitID = clsBranchUnit.Insert(clsUnitDetails); } clsBranchProductDetails.ProductGroupCode = xmlReader.GetAttribute("ProductGroupCode"); clsBranchProductDetails.ProductGroupID = clsBranchProductGroup.Details(clsBranchProductDetails.ProductGroupCode).ProductGroupID; if (clsBranchProductDetails.ProductGroupID == 0) { lblError.Text += "inserting product group...."; clsBranchProductGroupDetails = new ProductGroupDetails(); clsBranchProductGroupDetails.ProductGroupCode = xmlReader.GetAttribute("ProductGroupCode"); clsBranchProductGroupDetails.ProductGroupName = xmlReader.GetAttribute("ProductGroupName"); clsBranchProductGroupDetails.UnitDetails = new UnitDetails { UnitID = clsBranchProductDetails.BaseUnitID }; clsBranchProductGroupDetails.Price = clsBranchProductDetails.Price; clsBranchProductGroupDetails.PurchasePrice = clsBranchProductDetails.PurchasePrice; clsBranchProductGroupDetails.IncludeInSubtotalDiscount = clsBranchProductDetails.IncludeInSubtotalDiscount; clsBranchProductGroupDetails.VAT = clsBranchProductDetails.VAT; clsBranchProductGroupDetails.EVAT = clsBranchProductDetails.EVAT; clsBranchProductGroupDetails.LocalTax = clsBranchProductDetails.LocalTax; clsBranchProductDetails.ProductGroupID = clsBranchProductGroup.Insert(clsBranchProductGroupDetails); } clsBranchProductDetails.ProductSubGroupCode = xmlReader.GetAttribute("ProductSubGroupCode"); clsBranchProductDetails.ProductSubGroupID = clsBranchProductSubGroup.Details(clsBranchProductDetails.ProductSubGroupCode).ProductSubGroupID; if (clsBranchProductDetails.ProductSubGroupID == 0) { lblError.Text += "inserting product sub-group...."; clsBranchProductSubGroupDetails = new ProductSubGroupDetails(); clsBranchProductSubGroupDetails.ProductGroupID = clsBranchProductDetails.ProductGroupID; clsBranchProductSubGroupDetails.ProductSubGroupCode = xmlReader.GetAttribute("ProductSubGroupCode"); clsBranchProductSubGroupDetails.ProductSubGroupName = xmlReader.GetAttribute("ProductSubGroupName"); clsBranchProductSubGroupDetails.BaseUnitID = clsBranchProductDetails.BaseUnitID; clsBranchProductSubGroupDetails.Price = clsBranchProductDetails.Price; clsBranchProductSubGroupDetails.PurchasePrice = clsBranchProductDetails.PurchasePrice; clsBranchProductSubGroupDetails.IncludeInSubtotalDiscount = clsBranchProductDetails.IncludeInSubtotalDiscount; clsBranchProductSubGroupDetails.VAT = clsBranchProductDetails.VAT; clsBranchProductSubGroupDetails.EVAT = clsBranchProductDetails.EVAT; clsBranchProductSubGroupDetails.LocalTax = clsBranchProductDetails.LocalTax; clsBranchProductDetails.ProductSubGroupID = clsBranchProductSubGroup.Insert(clsBranchProductSubGroupDetails); } clsBranchProductDetails.ProductID = clsBranchProduct.Insert(clsBranchProductDetails); lngBranchProductID = clsBranchProductDetails.ProductID; lngProductInserted++; lblError.Text += " [done]. next item...<br />"; } else if (xmlReader.Name == "Variation") { if (lngBranchProductID != 0) { clsBranchProductVariationDetails = new ProductVariationDetails(); clsBranchProductVariationDetails.VariationID = clsBranchProductVariation.Details(lngBranchProductID, xmlReader.GetAttribute("VariationCode")).VariationID; if (clsBranchProductVariationDetails.VariationID == 0) { clsBranchProductVariationDetails.ProductID = lngBranchProductID; clsBranchProductVariationDetails.VariationCode = xmlReader.GetAttribute("VariationCode"); clsBranchProductVariationDetails.VariationType = xmlReader.GetAttribute("VariationType"); clsBranchProductVariation.Insert(clsBranchProductVariationDetails); } } } else { lblError.Text += "<b>" + xmlReader.Name + ":</b>" + xmlReader.Value + "<br />"; } break; case XmlNodeType.Text: lblError.Text += "<b>" + xmlReader.LocalName + ":</b>" + xmlReader.Value + "<br />"; break; } } xmlReader.Close(); clsBranchInventory.CommitAndDispose(); lblError.Text = "<b>" + lngProductInserted.ToString() + " out of " + lngProductCtr.ToString() + " has been successfully transferred.</b><br /><br />" + lblError.Text; }
private void SaveRecord() { Security.AccessUserDetails clsAccessUserDetails = (Security.AccessUserDetails)Session["AccessUserDetails"]; Contacts clsContact = new Contacts(); ContactDetails clsDetails = new ContactDetails(); clsDetails.ContactID = Convert.ToInt32(lblContactID.Text); clsDetails.ContactCode = txtContactCode.Text; clsDetails.ContactName = txtLastName.Text + ", " + txtFirstName.Text + " " + txtMiddleName.Text; clsDetails.ContactGroupID = Convert.ToInt32(cboGroup.SelectedItem.Value); clsDetails.ModeOfTerms = (ModeOfTerms)Enum.Parse(typeof(ModeOfTerms), cboModeOfTerms.SelectedItem.Value); clsDetails.Terms = Convert.ToInt32(txtTerms.Text); clsDetails.Address = txtAddress.Text; clsDetails.BusinessName = txtBusinessName.Text; clsDetails.TelephoneNo = txtTelephoneNo.Text; clsDetails.Remarks = txtRemarks.Text; clsDetails.Debit = Convert.ToDecimal(txtDebit.Text); clsDetails.Credit = Convert.ToDecimal(txtCredit.Text); clsDetails.IsCreditAllowed = chkIsCreditAllowed.Checked; clsDetails.CreditLimit = Convert.ToDecimal(txtCreditLimit.Text); clsDetails.DepartmentID = Convert.ToInt16(cboDepartment.SelectedItem.Value); clsDetails.PositionID = Convert.ToInt16(cboPosition.SelectedItem.Value); ContactAddOnDetails clsAddOnDetails = new ContactAddOnDetails(); clsAddOnDetails.ContactID = clsDetails.ContactID; clsAddOnDetails.Salutation = cboSalutation.SelectedItem.Value; clsAddOnDetails.FirstName = txtFirstName.Text; clsAddOnDetails.MiddleName = txtMiddleName.Text; clsAddOnDetails.LastName = txtLastName.Text; clsAddOnDetails.SpouseName = ""; DateTime dteBirthDate = Constants.C_DATE_MIN_VALUE; dteBirthDate = DateTime.TryParse(txtBirthDate.Text, out dteBirthDate) ? dteBirthDate : Constants.C_DATE_MIN_VALUE; clsAddOnDetails.BirthDate = dteBirthDate; clsAddOnDetails.SpouseBirthDate = Constants.C_DATE_MIN_VALUE; clsAddOnDetails.AnniversaryDate = Constants.C_DATE_MIN_VALUE; clsAddOnDetails.Address1 = txtAddress.Text; clsAddOnDetails.Address2 = string.Empty; clsAddOnDetails.City = string.Empty; clsAddOnDetails.State = string.Empty; clsAddOnDetails.ZipCode = string.Empty; clsAddOnDetails.CountryID = Constants.C_DEF_COUNTRY_ID; clsAddOnDetails.CountryCode = Constants.C_DEF_COUNTRY_CODE; clsAddOnDetails.BusinessPhoneNo = txtTelephoneNo.Text; clsAddOnDetails.HomePhoneNo = string.Empty; clsAddOnDetails.MobileNo = txtMobileNo.Text; clsAddOnDetails.FaxNo = string.Empty; clsAddOnDetails.EmailAddress = string.Empty; clsDetails.AdditionalDetails = clsAddOnDetails; clsContact.Update(clsDetails); clsContact.CommitAndDispose(); }
private void Import() { if (txtPath.HasFile) { string fn = System.IO.Path.GetFileName(txtPath.PostedFile.FileName); if (fn.Contains("_" + Constants.PURCHASE_ORDER_CODE) == false) { string stScript = "<Script>"; stScript += "window.alert('Please select a VALID Transfer In file to upload.')"; stScript += "</Script>"; Response.Write(stScript); return; } string SaveLocation = "/RetailPlus/temp/uploaded_" + fn; txtPath.PostedFile.SaveAs(SaveLocation); XmlTextReader xmlReader = new XmlTextReader(SaveLocation); xmlReader.WhitespaceHandling = WhitespaceHandling.None; TransferOut clsTransferOut = new TransferOut(); clsTransferOut.GetConnection(); TransferOutDetails clsTransferOutDetails = new TransferOutDetails(); TransferOutItem clsTransferOutItem = new TransferOutItem(clsTransferOut.Connection, clsTransferOut.Transaction); TransferOutItemDetails clsTransferOutItemDetails; Contacts clsContact = new Contacts(clsTransferOut.Connection, clsTransferOut.Transaction); ContactDetails clsContactDetails; ContactGroups clsContactGroup = new ContactGroups(clsTransferOut.Connection, clsTransferOut.Transaction); ContactGroupDetails clsContactGroupDetails; Data.Unit clsUnit = new Data.Unit(clsTransferOut.Connection, clsTransferOut.Transaction); UnitDetails clsUnitDetails; ProductGroup clsProductGroup = new Data.ProductGroup(clsTransferOut.Connection, clsTransferOut.Transaction); ProductGroupDetails clsProductGroupDetails; ProductSubGroup clsProductSubGroup = new Data.ProductSubGroup(clsTransferOut.Connection, clsTransferOut.Transaction); ProductSubGroupDetails clsProductSubGroupDetails; Products clsProduct = new Products(clsTransferOut.Connection, clsTransferOut.Transaction); ProductDetails clsProductDetails; ProductVariations clsProductVariation = new ProductVariations(clsTransferOut.Connection, clsTransferOut.Transaction); ProductVariationDetails clsProductVariationDetails; Branch clsBranch = new Branch(clsTransferOut.Connection, clsTransferOut.Transaction); BranchDetails clsBranchDetails; long lngProductID = 0; long lngProductCtr = 0; while (xmlReader.Read()) { switch (xmlReader.NodeType) { case XmlNodeType.Element: if (xmlReader.Name == "TransferOutDetails") { clsTransferOutDetails.TransferOutNo = lnkTransferOutNo.Text; clsTransferOutDetails.TransferOutDate = DateTime.Parse(lblTransferOutDate.Text); clsTransferOutDetails.SupplierCode = xmlReader.GetAttribute("SupplierCode").ToString(); clsTransferOutDetails.SupplierContact = xmlReader.GetAttribute("SupplierContact").ToString(); clsTransferOutDetails.SupplierAddress = xmlReader.GetAttribute("SupplierAddress").ToString(); clsTransferOutDetails.SupplierTelephoneNo = xmlReader.GetAttribute("SupplierTelephoneNo").ToString(); clsTransferOutDetails.SupplierModeOfTerms = int.Parse(xmlReader.GetAttribute("SupplierModeOfTerms").ToString()); clsTransferOutDetails.SupplierTerms = int.Parse(xmlReader.GetAttribute("SupplierTerms").ToString()); clsTransferOutDetails.SupplierID = clsContact.Details(xmlReader.GetAttribute("SupplierCode").ToString()).ContactID; if (clsTransferOutDetails.SupplierID == 0) { clsContactDetails = new ContactDetails(); clsContactDetails.ContactCode = clsTransferOutDetails.SupplierCode; clsContactDetails.ContactName = xmlReader.GetAttribute("SupplierName").ToString(); clsContactDetails.BusinessName = clsTransferOutDetails.SupplierContact; clsContactDetails.Address = clsTransferOutDetails.SupplierAddress; clsContactDetails.TelephoneNo = clsTransferOutDetails.SupplierTelephoneNo; clsContactDetails.ModeOfTerms = (ModeOfTerms)Enum.Parse(typeof(ModeOfTerms), clsTransferOutDetails.SupplierModeOfTerms.ToString()); clsContactDetails.Terms = clsTransferOutDetails.SupplierTerms; clsContactDetails.Remarks = "Added in from Imported TransferOut #"; clsContactDetails.ContactGroupID = int.Parse(Contacts.DEFAULT_SUPPLIER_ID.ToString("d")); clsContactDetails.DateCreated = DateTime.Now; clsTransferOutDetails.SupplierID = clsContact.Insert(clsContactDetails); } clsTransferOutDetails.RequiredDeliveryDate = DateTime.Parse(xmlReader.GetAttribute("RequiredDeliveryDate").ToString()); clsTransferOutDetails.BranchID = clsBranch.Details(xmlReader.GetAttribute("BranchCode")).BranchID; if (clsTransferOutDetails.BranchID == 0) { clsBranchDetails = new BranchDetails(); clsBranchDetails.BranchCode = xmlReader.GetAttribute("BranchCode"); clsBranchDetails.BranchName = xmlReader.GetAttribute("BranchName"); clsBranchDetails.Address = xmlReader.GetAttribute("BranchAddress"); clsBranchDetails.DBIP = xmlReader.GetAttribute("BranchDBIP"); clsBranchDetails.DBPort = xmlReader.GetAttribute("BranchDBPort"); clsBranchDetails.Remarks = xmlReader.GetAttribute("BranchRemarks"); clsTransferOutDetails.BranchID = clsBranch.Insert(clsBranchDetails); } clsTransferOutDetails.TransferrerID = long.Parse(xmlReader.GetAttribute("TransferrerID")); clsTransferOutDetails.TransferrerName = xmlReader.GetAttribute("TransferrerName"); clsTransferOutDetails.SubTotal = decimal.Parse(xmlReader.GetAttribute("SubTotal")); clsTransferOutDetails.Discount = decimal.Parse(xmlReader.GetAttribute("Discount")); clsTransferOutDetails.DiscountApplied = decimal.Parse(xmlReader.GetAttribute("DiscountApplied")); clsTransferOutDetails.DiscountType = (DiscountTypes)Enum.Parse(typeof(DiscountTypes), xmlReader.GetAttribute("DiscountType")); clsTransferOutDetails.VAT = decimal.Parse(xmlReader.GetAttribute("VAT")); clsTransferOutDetails.VatableAmount = decimal.Parse(xmlReader.GetAttribute("VatableAmount")); clsTransferOutDetails.EVAT = decimal.Parse(xmlReader.GetAttribute("EVAT")); clsTransferOutDetails.EVatableAmount = decimal.Parse(xmlReader.GetAttribute("EVatableAmount")); clsTransferOutDetails.LocalTax = decimal.Parse(xmlReader.GetAttribute("LocalTax")); clsTransferOutDetails.Freight = decimal.Parse(xmlReader.GetAttribute("Freight")); clsTransferOutDetails.Deposit = decimal.Parse(xmlReader.GetAttribute("Deposit")); clsTransferOutDetails.UnpaidAmount = decimal.Parse(xmlReader.GetAttribute("UnpaidAmount")); clsTransferOutDetails.PaidAmount = decimal.Parse(xmlReader.GetAttribute("PaidAmount")); clsTransferOutDetails.TotalItemDiscount = decimal.Parse(xmlReader.GetAttribute("TotalItemDiscount")); clsTransferOutDetails.Status = (TransferOutStatus)Enum.Parse(typeof(TransferOutStatus), xmlReader.GetAttribute("Status")); clsTransferOutDetails.Remarks = xmlReader.GetAttribute("Remarks"); clsTransferOutDetails.SupplierDRNo = xmlReader.GetAttribute("SupplierDRNo"); clsTransferOutDetails.DeliveryDate = DateTime.Parse(xmlReader.GetAttribute("DeliveryDate")); clsTransferOutDetails.CancelledDate = DateTime.Parse(xmlReader.GetAttribute("CancelledDate")); clsTransferOutDetails.Remarks = xmlReader.GetAttribute("Remarks"); clsTransferOutDetails.CancelledRemarks = xmlReader.GetAttribute("CancelledRemarks"); clsTransferOutDetails.CancelledByID = long.Parse(xmlReader.GetAttribute("CancelledByID")); clsTransferOut.Update(clsTransferOutDetails); } else if (xmlReader.Name == "TransferOutItem") { clsTransferOutItemDetails = new TransferOutItemDetails(); clsTransferOutItemDetails.TransferOutID = long.Parse(lblTransferOutID.Text); clsTransferOutItemDetails.ProductCode = xmlReader.GetAttribute("ProductCode"); clsTransferOutItemDetails.BarCode = xmlReader.GetAttribute("BarCode"); clsTransferOutItemDetails.Description = xmlReader.GetAttribute("ProductDesc"); clsTransferOutItemDetails.ProductSubGroup = xmlReader.GetAttribute("ItemProductSubGroup"); clsTransferOutItemDetails.ProductGroup = xmlReader.GetAttribute("ItemProductGroup"); clsTransferOutItemDetails.ProductUnitID = Convert.ToInt32(xmlReader.GetAttribute("ItemProductUnitID")); clsTransferOutItemDetails.ProductUnitCode = xmlReader.GetAttribute("ItemProductUnitCode"); clsTransferOutItemDetails.Quantity = Convert.ToDecimal(xmlReader.GetAttribute("ItemQuantity")); clsTransferOutItemDetails.UnitCost = Convert.ToDecimal(xmlReader.GetAttribute("ItemUnitCost")); clsTransferOutItemDetails.Discount = Convert.ToDecimal(xmlReader.GetAttribute("ItemDiscount")); clsTransferOutItemDetails.DiscountApplied = Convert.ToDecimal(xmlReader.GetAttribute("ItemDiscountApplied")); clsTransferOutItemDetails.DiscountType = (DiscountTypes)Enum.Parse(typeof(DiscountTypes), xmlReader.GetAttribute("ItemDiscountType")); clsTransferOutItemDetails.Amount = Convert.ToDecimal(xmlReader.GetAttribute("ItemAmount")); clsTransferOutItemDetails.IsVatable = Convert.ToBoolean(Convert.ToInt16(xmlReader.GetAttribute("ItemIsVatable"))); clsTransferOutItemDetails.VatableAmount = Convert.ToDecimal(xmlReader.GetAttribute("ItemVatableAmount")); clsTransferOutItemDetails.EVatableAmount = Convert.ToDecimal(xmlReader.GetAttribute("ItemEVatableAmount")); clsTransferOutItemDetails.LocalTax = Convert.ToDecimal(xmlReader.GetAttribute("ItemLocalTax")); clsTransferOutItemDetails.VAT = Convert.ToDecimal(xmlReader.GetAttribute("ItemVAT")); clsTransferOutItemDetails.EVAT = Convert.ToDecimal(xmlReader.GetAttribute("ItemEVAT")); clsTransferOutItemDetails.LocalTax = Convert.ToDecimal(xmlReader.GetAttribute("ItemLocalTax")); clsTransferOutItemDetails.isVATInclusive = Convert.ToBoolean(Convert.ToInt16(xmlReader.GetAttribute("ItemisVATInclusive"))); clsTransferOutItemDetails.IsVatable = Convert.ToBoolean(Convert.ToInt16(xmlReader.GetAttribute("ItemIsVatable"))); clsTransferOutItemDetails.TransferOutItemStatus = (TransferOutItemStatus)Enum.Parse(typeof(TransferOutItemStatus), xmlReader.GetAttribute("ItemTransferOutItemStatus")); clsTransferOutItemDetails.VariationMatrixID = Convert.ToInt64(xmlReader.GetAttribute("ItemVariationMatrixID")); clsTransferOutItemDetails.MatrixDescription = xmlReader.GetAttribute("ItemBaseVariationDescription"); clsTransferOutItemDetails.ProductGroup = xmlReader.GetAttribute("ProductGroup"); clsTransferOutItemDetails.ProductSubGroup = xmlReader.GetAttribute("ProductSubGroup"); clsTransferOutItemDetails.Remarks = xmlReader.GetAttribute("ItemRemarks"); clsTransferOutItemDetails.SellingPrice = Convert.ToDecimal(xmlReader.GetAttribute("ItemSellingPrice")); clsTransferOutItemDetails.SellingVAT = Convert.ToDecimal(xmlReader.GetAttribute("ItemSellingVAT")); clsTransferOutItemDetails.SellingEVAT = Convert.ToDecimal(xmlReader.GetAttribute("ItemSellingEVAT")); clsTransferOutItemDetails.SellingLocalTax = Convert.ToDecimal(xmlReader.GetAttribute("ItemSellingLocalTax")); clsTransferOutItemDetails.OldSellingPrice = Convert.ToDecimal(xmlReader.GetAttribute("ItemOldSellingPrice")); clsTransferOutItemDetails.ProductID = clsProduct.Details(clsTransferOutItemDetails.BarCode).ProductID; lngProductID = clsTransferOutItemDetails.ProductID; if (clsTransferOutItemDetails.ProductID == 0) { clsTransferOutItemDetails.ProductID = clsProduct.Details(clsTransferOutItemDetails.ProductCode).ProductID; if (clsTransferOutItemDetails.ProductID == 0) { //insert new product clsProductDetails = new ProductDetails(); clsProductDetails.BarCode = clsTransferOutItemDetails.BarCode; clsProductDetails.ProductCode = clsTransferOutItemDetails.ProductCode; clsProductDetails.ProductDesc = clsTransferOutItemDetails.Description; clsProductDetails.ProductGroupCode = xmlReader.GetAttribute("ProductGroupCode"); clsProductDetails.ProductGroupName = xmlReader.GetAttribute("ProductGroupName"); clsProductDetails.ProductSubGroupCode = xmlReader.GetAttribute("ProductSubGroupCode"); clsProductDetails.ProductSubGroupName = xmlReader.GetAttribute("ProductSubGroupName"); clsProductDetails.BaseUnitCode = xmlReader.GetAttribute("BaseUnitCode"); clsProductDetails.BaseUnitName = xmlReader.GetAttribute("BaseUnitName"); clsProductDetails.DateCreated = DateTime.Now; clsProductDetails.Price = Convert.ToDecimal(xmlReader.GetAttribute("Price")); clsProductDetails.PurchasePrice = Convert.ToDecimal(xmlReader.GetAttribute("PurchasePrice")); clsProductDetails.IncludeInSubtotalDiscount = Convert.ToBoolean(xmlReader.GetAttribute("IncludeInSubtotalDiscount")); clsProductDetails.VAT = Convert.ToDecimal(xmlReader.GetAttribute("VAT")); clsProductDetails.EVAT = Convert.ToDecimal(xmlReader.GetAttribute("EVAT")); clsProductDetails.LocalTax = Convert.ToDecimal(xmlReader.GetAttribute("LocalTax")); clsProductDetails.Quantity = 0; clsProductDetails.MinThreshold = Convert.ToDecimal(xmlReader.GetAttribute("MinThreshold")); clsProductDetails.MaxThreshold = Convert.ToDecimal(xmlReader.GetAttribute("MaxThreshold")); clsProductDetails.ChartOfAccountIDPurchase = int.Parse(xmlReader.GetAttribute("ChartOfAccountIDPurchase")); clsProductDetails.ChartOfAccountIDSold = int.Parse(xmlReader.GetAttribute("ChartOfAccountIDSold")); clsProductDetails.ChartOfAccountIDInventory = int.Parse(xmlReader.GetAttribute("ChartOfAccountIDInventory")); clsProductDetails.ChartOfAccountIDTaxPurchase = int.Parse(xmlReader.GetAttribute("ChartOfAccountIDTaxPurchase")); clsProductDetails.ChartOfAccountIDTaxSold = int.Parse(xmlReader.GetAttribute("ChartOfAccountIDTaxSold")); clsProductDetails.IsItemSold = Convert.ToBoolean(xmlReader.GetAttribute("IsItemSold")); clsProductDetails.WillPrintProductComposition = Convert.ToBoolean(xmlReader.GetAttribute("WillPrintProductComposition")); clsProductDetails.UpdatedBy = long.Parse(xmlReader.GetAttribute("UpdatedBy")); clsProductDetails.UpdatedOn = Convert.ToDateTime(xmlReader.GetAttribute("UpdatedOn")); clsProductDetails.PercentageCommision = decimal.Parse(xmlReader.GetAttribute("PercentageCommision")); clsProductDetails.QuantityIN = clsProductDetails.Quantity; clsProductDetails.QuantityOUT = 0; clsProductDetails.SupplierCode = clsTransferOutDetails.SupplierCode; clsProductDetails.SupplierID = clsContact.Details(clsProductDetails.SupplierCode).ContactID; if (clsProductDetails.SupplierID == 0) { clsContactDetails = new ContactDetails(); clsContactDetails.ContactGroupID = clsContactGroup.Details(int.Parse(ContactGroupCategory.SUPPLIER.ToString("d"))).ContactGroupID; if (clsContactDetails.ContactGroupID == 0) { clsContactGroupDetails = new ContactGroupDetails(); clsContactGroupDetails.ContactGroupCode = xmlReader.GetAttribute("SUP"); clsContactGroupDetails.ContactGroupName = xmlReader.GetAttribute("Default Supplier Group"); clsContactGroupDetails.ContactGroupCategory = ContactGroupCategory.SUPPLIER; clsContactDetails.ContactGroupID = clsContactGroup.Insert(clsContactGroupDetails); } clsContactDetails.ContactCode = clsTransferOutDetails.SupplierCode; clsContactDetails.ContactName = clsTransferOutDetails.SupplierContact; clsContactDetails.ModeOfTerms = (ModeOfTerms)Enum.Parse(typeof(ModeOfTerms), clsTransferOutDetails.SupplierModeOfTerms.ToString()); clsContactDetails.Terms = clsTransferOutDetails.SupplierTerms; clsContactDetails.Address = clsTransferOutDetails.SupplierAddress; clsContactDetails.BusinessName = clsTransferOutDetails.SupplierContact; clsContactDetails.TelephoneNo = clsTransferOutDetails.SupplierTelephoneNo; clsContactDetails.Remarks = "Added in XML import"; clsContactDetails.Debit = 0; clsContactDetails.Credit = 0; clsContactDetails.IsCreditAllowed = false; clsContactDetails.CreditLimit = 0; clsProductDetails.SupplierID = clsContact.Insert(clsContactDetails); } clsProductDetails.BaseUnitID = clsUnit.Details(clsProductDetails.BaseUnitCode).UnitID; if (clsProductDetails.BaseUnitID == 0) { clsUnitDetails = new UnitDetails(); clsUnitDetails.UnitCode = clsProductDetails.BaseUnitCode; clsUnitDetails.UnitName = clsProductDetails.BaseUnitName; clsProductDetails.BaseUnitID = clsUnit.Insert(clsUnitDetails); } clsProductDetails.ProductGroupID = clsProductGroup.Details(clsProductDetails.ProductGroupCode).ProductGroupID; if (clsProductDetails.ProductGroupID == 0) { clsProductGroupDetails = new ProductGroupDetails(); clsProductGroupDetails.ProductGroupCode = clsProductDetails.ProductGroupCode; clsProductGroupDetails.ProductGroupName = clsProductDetails.ProductGroupName; clsProductGroupDetails.UnitDetails = new UnitDetails { UnitID = clsProductDetails.BaseUnitID }; clsProductGroupDetails.Price = clsProductDetails.Price; clsProductGroupDetails.PurchasePrice = clsProductDetails.PurchasePrice; clsProductGroupDetails.IncludeInSubtotalDiscount = clsProductDetails.IncludeInSubtotalDiscount; clsProductGroupDetails.VAT = clsProductDetails.VAT; clsProductGroupDetails.EVAT = clsProductDetails.EVAT; clsProductGroupDetails.LocalTax = clsProductDetails.LocalTax; clsProductDetails.ProductGroupID = clsProductGroup.Insert(clsProductGroupDetails); } clsProductDetails.ProductSubGroupID = clsProductSubGroup.Details(clsProductDetails.ProductSubGroupCode).ProductSubGroupID; if (clsProductDetails.ProductSubGroupID == 0) { clsProductSubGroupDetails = new ProductSubGroupDetails(); clsProductSubGroupDetails.ProductGroupID = clsProductDetails.ProductGroupID; clsProductSubGroupDetails.ProductSubGroupCode = clsProductDetails.ProductSubGroupCode; clsProductSubGroupDetails.ProductSubGroupName = clsProductDetails.ProductSubGroupName; clsProductSubGroupDetails.BaseUnitID = clsProductDetails.BaseUnitID; clsProductSubGroupDetails.Price = clsProductDetails.Price; clsProductSubGroupDetails.PurchasePrice = clsProductDetails.PurchasePrice; clsProductSubGroupDetails.IncludeInSubtotalDiscount = clsProductDetails.IncludeInSubtotalDiscount; clsProductSubGroupDetails.VAT = clsProductDetails.VAT; clsProductSubGroupDetails.EVAT = clsProductDetails.EVAT; clsProductSubGroupDetails.LocalTax = clsProductDetails.LocalTax; clsProductDetails.ProductSubGroupID = clsProductSubGroup.Insert(clsProductSubGroupDetails); } clsTransferOutItemDetails.ProductID = clsProduct.Insert(clsProductDetails); } else { //product code already exist but not the same barcode clsProduct.UpdateBarcode(clsTransferOutItemDetails.ProductID, clsTransferOutItemDetails.BarCode); } lngProductID = clsTransferOutItemDetails.ProductID; } clsTransferOutItem.Insert(clsTransferOutItemDetails); clsTransferOutDetails = new TransferOutDetails(); clsTransferOutDetails.TransferOutID = clsTransferOutItemDetails.TransferOutID; clsTransferOutDetails.DiscountApplied = Convert.ToDecimal(txtTransferOutDiscountApplied.Text); clsTransferOutDetails.DiscountType = (DiscountTypes)Enum.Parse(typeof(DiscountTypes), cboTransferOutDiscountType.SelectedItem.Value); clsTransferOutDetails.Discount2Applied = Convert.ToDecimal(txtTransferOutDiscount2Applied.Text); clsTransferOutDetails.Discount2Type = (DiscountTypes)Enum.Parse(typeof(DiscountTypes), cboTransferOutDiscount2Type.SelectedItem.Value); clsTransferOutDetails.Discount3Applied = Convert.ToDecimal(txtTransferOutDiscount2Applied.Text); clsTransferOutDetails.Discount3Type = (DiscountTypes)Enum.Parse(typeof(DiscountTypes), cboTransferOutDiscount3Type.SelectedItem.Value); clsTransferOut = new TransferOut(clsTransferOutItem.Connection, clsTransferOutItem.Transaction); clsTransferOut.UpdateDiscount(clsTransferOutItemDetails.TransferOutID, clsTransferOutDetails.DiscountApplied, clsTransferOutDetails.DiscountType, clsTransferOutDetails.Discount2Applied, clsTransferOutDetails.Discount2Type, clsTransferOutDetails.Discount3Applied, clsTransferOutDetails.Discount3Type); clsTransferOutDetails = clsTransferOut.Details(clsTransferOutItemDetails.TransferOutID); UpdateFooter(clsTransferOutDetails); lngProductCtr++; } else if (xmlReader.Name == "Variation") { if (lngProductID != 0) { clsProductVariationDetails = new ProductVariationDetails(); clsProductVariationDetails.VariationID = clsProductVariation.Details(lngProductID, xmlReader.GetAttribute("VariationCode")).VariationID; if (clsProductVariationDetails.VariationID == 0) { clsProductVariationDetails.ProductID = lngProductID; clsProductVariationDetails.VariationCode = xmlReader.GetAttribute("VariationCode"); clsProductVariationDetails.VariationType = xmlReader.GetAttribute("VariationType"); clsProductVariation.Insert(clsProductVariationDetails); } } } else { //lblError.Text += "<b>" + xmlReader.Name + ":</b>" + xmlReader.Value + "<br />"; } break; case XmlNodeType.Text: //lblError.Text += "<b>" + xmlReader.LocalName + ":</b>" + xmlReader.Value + "<br />"; break; } } xmlReader.Close(); clsTransferOut.CommitAndDispose(); LoadRecord(); LoadItems(); } else { string stScript = "<Script>"; stScript += "window.alert('Please select Transfer In file to upload.')"; stScript += "</Script>"; Response.Write(stScript); } }
private void Upload() { if( ( txtPath.PostedFile != null ) && ( txtPath.PostedFile.ContentLength > 0 ) ) { string fn = System.IO.Path.GetFileName(txtPath.PostedFile.FileName); string SaveLocation = "/RetailPlus/temp/uploaded_" + fn; txtPath.PostedFile.SaveAs(SaveLocation); XmlTextReader reader = new XmlTextReader(SaveLocation); reader.WhitespaceHandling = WhitespaceHandling.None; Stock clsStock = new Stock(); clsStock.GetConnection(); string strStockTransactionNo = null; long StockID = 0; long ContactID = 0; int UnitID = 0; long ProductGroupID = 0; long ProductSubGroupID = 0; long ProductID = 0; long ProductBaseMatrixID = 0; VariationDetails clsVariationDetails; int VariationID = 0; StockItemDetails clsStockItemDetails = new StockItemDetails(); while (reader.Read()) { switch (reader.NodeType) { case XmlNodeType.Element: if (reader.Name == "Stock") { strStockTransactionNo = reader.GetAttribute("TransactionNo"); StockID = clsStock.Details(reader.GetAttribute("TransactionNo")).StockID; if (StockID > 0) { clsStock.CommitAndDispose(); Label1.Text = "<b>This file has already been added to inventory.<br />"; Label1.Text += "Please refer to transaction No: " + strStockTransactionNo + ".</b>"; reader.Close(); return; } Contacts clsContact = new Contacts(clsStock.Connection, clsStock.Transaction); ContactID = clsContact.Details(reader.GetAttribute("ContactCode")).ContactID; if (ContactID == 0) { ContactDetails clsContactDetails = new ContactDetails(); clsContactDetails.ContactCode = reader.GetAttribute("ContactCode"); clsContactDetails.ContactName = reader.GetAttribute("ContactName"); clsContactDetails.ContactGroupID = Convert.ToInt32(reader.GetAttribute("ContactGroupID")); clsContactDetails.ModeOfTerms = (ModeOfTerms)Enum.Parse(typeof(ModeOfTerms), reader.GetAttribute("ModeOfTerms")); clsContactDetails.Terms = Convert.ToInt32(reader.GetAttribute("Terms")); clsContactDetails.Address = reader.GetAttribute("Address"); clsContactDetails.BusinessName = reader.GetAttribute("BusinessName"); clsContactDetails.TelephoneNo = reader.GetAttribute("TelephoneNo"); clsContactDetails.Remarks = reader.GetAttribute("Remarks"); clsContactDetails.Debit = Convert.ToDecimal(reader.GetAttribute("Debit")); clsContactDetails.Credit = Convert.ToDecimal(reader.GetAttribute("Credit")); clsContactDetails.IsCreditAllowed = Convert.ToBoolean(reader.GetAttribute("IsCreditAllowed")); clsContactDetails.CreditLimit = Convert.ToDecimal(reader.GetAttribute("CreditLimit")); ContactID = clsContact.Insert(clsContactDetails); } StockDetails clsStockDetails = new StockDetails(); clsStockDetails.TransactionNo = reader.GetAttribute("TransactionNo"); clsStockDetails.StockTypeID = Convert.ToInt16(Constants.STOCK_TYPE_TRANSFER_FROM_BRANCH_ID); clsStockDetails.StockDate = DateTime.Now; clsStockDetails.SupplierID = ContactID; clsStockDetails.Remarks = reader.GetAttribute("StockRemarks") + Environment.NewLine + "Original Stock Date: " + reader.GetAttribute("StockDate"); StockItemDetails[] itemDetails = new StockItemDetails[0]; clsStockDetails.StockItems = itemDetails; StockID = clsStock.Insert(clsStockDetails); } else if (reader.Name == "Item") { Data.Unit clsUnit = new Data.Unit(clsStock.Connection, clsStock.Transaction); UnitID = clsUnit.Details(reader.GetAttribute("ProductUnitCode")).UnitID; if (UnitID == 0) { UnitDetails clsUnitDetails = new UnitDetails(); clsUnitDetails.UnitCode = reader.GetAttribute("ProductUnitCode"); clsUnitDetails.UnitName = reader.GetAttribute("ProductUnitName"); UnitID = clsUnit.Insert(clsUnitDetails); } ProductGroup clsProductGroup = new ProductGroup(clsStock.Connection, clsStock.Transaction); ProductGroupID = clsProductGroup.Details(reader.GetAttribute("ProductGroupCode")).ProductGroupID; if (ProductGroupID == 0) { Label1.Text += "inserting product group...."; ProductGroupDetails clsProductGroupDetails = new ProductGroupDetails(); clsProductGroupDetails.ProductGroupCode = reader.GetAttribute("ProductGroupCode"); clsProductGroupDetails.ProductGroupName = reader.GetAttribute("ProductGroupName"); clsProductGroupDetails.UnitDetails = new UnitDetails { UnitID = UnitID }; clsProductGroupDetails.Price = Convert.ToDecimal(reader.GetAttribute("Price")); clsProductGroupDetails.PurchasePrice = Convert.ToDecimal(reader.GetAttribute("PurchasePrice")); clsProductGroupDetails.IncludeInSubtotalDiscount = Convert.ToBoolean(reader.GetAttribute("IncludeInSubtotalDiscount")); clsProductGroupDetails.VAT = Convert.ToDecimal(reader.GetAttribute("VAT")); clsProductGroupDetails.EVAT = Convert.ToDecimal(reader.GetAttribute("EVAT")); clsProductGroupDetails.LocalTax = Convert.ToDecimal(reader.GetAttribute("LocalTax")); ProductGroupID = clsProductGroup.Insert(clsProductGroupDetails); } ProductSubGroup clsProductSubGroup = new ProductSubGroup(clsStock.Connection, clsStock.Transaction); ProductSubGroupID = clsProductSubGroup.Details(reader.GetAttribute("ProductSubGroupCode")).ProductSubGroupID; if (ProductSubGroupID == 0) { Label1.Text += "inserting product sub-group...."; ProductSubGroupDetails clsProductSubGroupDetails = new ProductSubGroupDetails(); clsProductSubGroupDetails.ProductGroupID = ProductGroupID; clsProductSubGroupDetails.ProductSubGroupCode = reader.GetAttribute("ProductSubGroupCode"); clsProductSubGroupDetails.ProductSubGroupName = reader.GetAttribute("ProductSubGroupName"); clsProductSubGroupDetails.BaseUnitID = UnitID; clsProductSubGroupDetails.Price = Convert.ToDecimal(reader.GetAttribute("Price")); clsProductSubGroupDetails.PurchasePrice = Convert.ToDecimal(reader.GetAttribute("PurchasePrice")); clsProductSubGroupDetails.IncludeInSubtotalDiscount = Convert.ToBoolean(reader.GetAttribute("IncludeInSubtotalDiscount")); clsProductSubGroupDetails.VAT = Convert.ToDecimal(reader.GetAttribute("VAT")); clsProductSubGroupDetails.EVAT = Convert.ToDecimal(reader.GetAttribute("EVAT")); clsProductSubGroupDetails.LocalTax = Convert.ToDecimal(reader.GetAttribute("LocalTax")); ProductSubGroupID = clsProductSubGroup.Insert(clsProductSubGroupDetails); } Products clsProduct = new Products(clsStock.Connection, clsStock.Transaction); ProductID = clsProduct.Details(reader.GetAttribute("BarCode")).ProductID; if (ProductID == 0) { Label1.Text += "inserting product...."; ProductDetails clsProductDetails = new ProductDetails(); clsProductDetails.ProductCode = reader.GetAttribute("ProductCode"); clsProductDetails.BarCode = reader.GetAttribute("BarCode"); clsProductDetails.ProductDesc = reader.GetAttribute("ProductDesc"); clsProductDetails.ProductGroupID = ProductGroupID; clsProductDetails.ProductSubGroupID = ProductSubGroupID; clsProductDetails.ProductDesc = reader.GetAttribute("ProductDesc"); clsProductDetails.BaseUnitID = UnitID; clsProductDetails.Price = Convert.ToDecimal(reader.GetAttribute("Price")); clsProductDetails.PurchasePrice = Convert.ToDecimal(reader.GetAttribute("PurchasePrice")); clsProductDetails.IncludeInSubtotalDiscount = Convert.ToBoolean(reader.GetAttribute("IncludeInSubtotalDiscount")); clsProductDetails.VAT = Convert.ToDecimal(reader.GetAttribute("VAT")); clsProductDetails.EVAT = Convert.ToDecimal(reader.GetAttribute("EVAT")); clsProductDetails.LocalTax = Convert.ToDecimal(reader.GetAttribute("LocalTax")); clsProductDetails.Quantity = 0; clsProductDetails.MinThreshold = Convert.ToDecimal(reader.GetAttribute("MinThreshold")); clsProductDetails.MaxThreshold = Convert.ToDecimal(reader.GetAttribute("MaxThreshold")); clsProductDetails.SupplierID = Contacts.DEFAULT_SUPPLIER_ID; ProductID = clsProduct.Insert(clsProductDetails); } //ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix(clsStock.Connection, clsStock.Transaction); //ProductBaseMatrixID = clsProductVariationsMatrix.BaseDetails(0, 0, ProductID, reader["ItemBaseVariationDescription"].ToString()).MatrixID; //if (ProductBaseMatrixID == 0) //{ // ProductBaseMatrixDetails clsBaseDetails = new ProductBaseMatrixDetails(); // clsBaseDetails.ProductID = ProductID; // clsBaseDetails.Description = reader.GetAttribute("ItemBaseVariationDescription"); // clsBaseDetails.UnitID = UnitID; // clsBaseDetails.Price = Convert.ToDecimal(reader.GetAttribute("Price")); // clsBaseDetails.PurchasePrice = Convert.ToDecimal(reader.GetAttribute("PurchasePrice")); // clsBaseDetails.IncludeInSubtotalDiscount = Convert.ToBoolean(reader.GetAttribute("IncludeInSubtotalDiscount")); // clsBaseDetails.Quantity = 0; // clsBaseDetails.VAT = Convert.ToDecimal(reader.GetAttribute("VAT")); // clsBaseDetails.EVAT = Convert.ToDecimal(reader.GetAttribute("EVAT")); // clsBaseDetails.LocalTax = Convert.ToDecimal(reader.GetAttribute("LocalTax")); // clsBaseDetails.MinThreshold = Convert.ToDecimal(reader.GetAttribute("MinThreshold")); // clsBaseDetails.MaxThreshold = Convert.ToDecimal(reader.GetAttribute("MaxThreshold")); // ProductBaseMatrixID = clsProductVariationsMatrix.InsertBaseVariation(clsBaseDetails); // clsBaseDetails.MatrixID = ProductBaseMatrixID; //} clsStockItemDetails = new StockItemDetails(); clsStockItemDetails.StockID = StockID; clsStockItemDetails.ProductID = ProductID; clsStockItemDetails.VariationMatrixID = ProductBaseMatrixID; clsStockItemDetails.ProductUnitID = UnitID; clsStockItemDetails.StockTypeID = Convert.ToInt16(Constants.STOCK_TYPE_TRANSFER_FROM_BRANCH_ID); clsStockItemDetails.StockDate = DateTime.Now; clsStockItemDetails.Quantity = Convert.ToDecimal(reader.GetAttribute("ItemQuantity")); clsStockItemDetails.Remarks = reader.GetAttribute("ItemRemarks"); Security.AccessUserDetails clsAccessUserDetails = (Security.AccessUserDetails)Session["AccessUserDetails"]; clsStock.AddItem(Constants.BRANCH_ID_MAIN, strStockTransactionNo, clsAccessUserDetails.Name, clsStockItemDetails, StockDirections.Increment); } else if (reader.Name == "Variation" && reader.GetAttribute("VariationCode") != null) { Variation clsVariation = new Variation(clsStock.Connection, clsStock.Transaction); VariationID = clsVariation.Details(reader.GetAttribute("VariationCode")).VariationID; if (VariationID == 0 ) { clsVariationDetails = new VariationDetails(); clsVariationDetails.VariationCode = reader.GetAttribute("VariationCode"); clsVariationDetails.VariationType = reader.GetAttribute("VariationType"); VariationID = clsVariation.Insert(clsVariationDetails); } ProductVariationDetails clsProductVariationDetails = new ProductVariationDetails(); clsProductVariationDetails.ProductID = ProductID; clsProductVariationDetails.VariationID = VariationID; ProductVariations clsProductVariation = new ProductVariations(clsStock.Connection, clsStock.Transaction); if (clsProductVariation.isExist(clsProductVariationDetails) == false) { long ProductVariationID = clsProductVariation.Insert(clsProductVariationDetails); } } else if (reader.Name == "VariationMatrix" && reader.GetAttribute("VariationCode") != null) { Variation clsVariation = new Variation(clsStock.Connection, clsStock.Transaction); VariationID = clsVariation.Details(reader.GetAttribute("VariationCode")).VariationID; if (VariationID == 0) { clsVariationDetails = new VariationDetails(); clsVariationDetails.VariationCode = reader.GetAttribute("VariationCode"); clsVariationDetails.VariationType = reader.GetAttribute("VariationType"); VariationID = clsVariation.Insert(clsVariationDetails); } ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix(clsStock.Connection, clsStock.Transaction); if (clsProductVariationsMatrix.isExist(ProductBaseMatrixID, VariationID) == false) { ProductVariationsMatrixDetails clsProductVariationsMatrixDetails = new ProductVariationsMatrixDetails(); clsProductVariationsMatrixDetails.ProductID = ProductID; clsProductVariationsMatrixDetails.MatrixID = ProductBaseMatrixID; clsProductVariationsMatrixDetails.VariationID = VariationID; clsProductVariationsMatrixDetails.Description = reader.GetAttribute("Description"); clsProductVariationsMatrix.SaveVariation(clsProductVariationsMatrixDetails); } } else { Label1.Text = "<b>Reader Name:<b>" + reader.Name + "<br />"; } break; case XmlNodeType.Text: Label1.Text = "<b>" + reader.LocalName + ":<b>" + reader.Value + "<br />"; break; } } reader.Close(); clsStock.CommitAndDispose(); Label1.Text = "<b>Transaction No.: " + strStockTransactionNo + " has been successfully transferred.<br />"; } else { Response.Write("Please select a file to upload."); } }
//public bool ApplyPromoValue(ContactDetails clsContactDetails, Int64 ProductID, Int64 VariationMatrixID, out PromoTypes PromoType, out decimal PromoQuantity, out decimal PromoValue, out bool InPercent, int BranchID = 0) //{ // Int64 ContactID = clsContactDetails.ContactID; // string ContactIDs = ""; // if (clsContactDetails.ContactID != Constants.ZERO) // { // if (!string.IsNullOrEmpty(ContactIDs)) // ContactIDs = "," + clsContactDetails.ContactID.ToString(); // else // ContactIDs = clsContactDetails.ContactID.ToString(); // } // // rewardcardmember // if (clsContactDetails.RewardDetails.RewardCardStatus == RewardCardStatus.ManualActivated) // { // if (!string.IsNullOrEmpty(ContactIDs)) // ContactIDs = "," + Constants.PLUSCARDMEMBERSID_STRING; // else // ContactIDs = Constants.PLUSCARDMEMBERSID_STRING; // } // // icc card members // if (clsContactDetails.CreditDetails.GuarantorID == Constants.ZERO && // clsContactDetails.CreditDetails.CreditCardStatus == CreditCardStatus.ManualActivated) // { // if (!string.IsNullOrEmpty(ContactIDs)) // ContactIDs = "," + Constants.PLUSCARDMEMBERSID_STRING; // else // ContactIDs = Constants.PLUSCARDMEMBERSID_STRING; // } // PromoType = PromoTypes.NotApplicable; // PromoQuantity = 0; // PromoValue = 0; // InPercent = false; // bool boHasPromo = false; // try // { // Data.Products clsProduct = new Data.Products(base.Connection, base.Transaction); // Data.ProductDetails clsProductDetails = clsProduct.Details1(BranchID, ProductID); // Int64 ProductSubGroupID = clsProductDetails.ProductSubGroupID; // Int64 ProductGroupID = clsProductDetails.ProductGroupID; // MySqlCommand cmd = new MySqlCommand(); // cmd.CommandType = System.Data.CommandType.Text; // string SQL = "SELECT " + // "PromoID " + // "FROM tblPromo " + // "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); // foreach (System.Data.DataRow dr in dt.Rows) // { // boHasPromo = true; // break; // } // if (boHasPromo == false) //return agad if no Promo is affected by date // return boHasPromo; // /*******************************Up to Contact, Group, Sub, Prod and VarM ID only*****************************/ // SQL = "SELECT " + // "PromoItemsID, " + // "a.PromoID, " + // "PromoTypeID, " + // "ProductGroupID, " + // "ProductSubGroupID, " + // "ProductID, " + // "VariationMatrixID, " + // "Quantity, " + // "PromoValue, " + // "InPercent " + // "FROM tblPromoItems a " + // "INNER JOIN tblPromo b ON a.PromoID = b.PromoID " + // "WHERE ContactID = @ContactID " + // "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');"; // cmd = new MySqlCommand(); // cmd.CommandType = System.Data.CommandType.Text; // 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) // { // PromoType = (PromoTypes)Enum.Parse(typeof(PromoTypes), dr["PromoTypeID"].ToString()); // PromoQuantity = decimal.Parse(dr["Quantity"].ToString()); // PromoValue = decimal.Parse(dr["PromoValue"].ToString()); // InPercent = bool.Parse(dr["InPercent"].ToString()); // return boHasPromo; // } // /*******************************Up to Contact, Sub, Prod and VariationsMatrix ID only*****************************/ // SQL = "SELECT " + // "PromoItemsID, " + // "a.PromoID, " + // "PromoTypeID, " + // "ProductGroupID, " + // "ProductSubGroupID, " + // "ProductID, " + // "VariationMatrixID, " + // "Quantity, " + // "PromoValue, " + // "InPercent " + // "FROM tblPromoItems a " + // "INNER JOIN tblPromo b ON a.PromoID = b.PromoID " + // "WHERE ContactID = @ContactID " + // "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');"; // cmd = new MySqlCommand(); // cmd.CommandType = System.Data.CommandType.Text; // 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) // { // PromoType = (PromoTypes)Enum.Parse(typeof(PromoTypes), dr["PromoTypeID"].ToString()); // PromoQuantity = decimal.Parse(dr["Quantity"].ToString()); // PromoValue = decimal.Parse(dr["PromoValue"].ToString()); // InPercent = bool.Parse(dr["InPercent"].ToString()); // return boHasPromo; // } // /*******************************Up to Contact, Prod and VariationsMatrix ID only*****************************/ // SQL = "SELECT " + // "PromoItemsID, " + // "a.PromoID, " + // "PromoTypeID, " + // "ProductGroupID, " + // "ProductSubGroupID, " + // "ProductID, " + // "VariationMatrixID, " + // "Quantity, " + // "PromoValue, " + // "InPercent " + // "FROM tblPromoItems a " + // "INNER JOIN tblPromo b ON a.PromoID = b.PromoID " + // "WHERE ContactID = @ContactID " + // "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');"; // cmd = new MySqlCommand(); // cmd.CommandType = System.Data.CommandType.Text; // 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) // { // PromoType = (PromoTypes)Enum.Parse(typeof(PromoTypes), dr["PromoTypeID"].ToString()); // PromoQuantity = decimal.Parse(dr["Quantity"].ToString()); // PromoValue = decimal.Parse(dr["PromoValue"].ToString()); // InPercent = bool.Parse(dr["InPercent"].ToString()); // return boHasPromo; // } // /*******************************Up to Contact, VariationsMatrix ID only*****************************/ // SQL = "SELECT " + // "PromoItemsID, " + // "a.PromoID, " + // "PromoTypeID, " + // "ProductGroupID, " + // "ProductSubGroupID, " + // "ProductID, " + // "VariationMatrixID, " + // "Quantity, " + // "PromoValue, " + // "InPercent " + // "FROM tblPromoItems a " + // "INNER JOIN tblPromo b ON a.PromoID = b.PromoID " + // "WHERE ContactID = @ContactID " + // "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');"; // cmd = new MySqlCommand(); // cmd.CommandType = System.Data.CommandType.Text; // 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) // { // PromoType = (PromoTypes)Enum.Parse(typeof(PromoTypes), dr["PromoTypeID"].ToString()); // PromoQuantity = decimal.Parse(dr["Quantity"].ToString()); // PromoValue = decimal.Parse(dr["PromoValue"].ToString()); // InPercent = bool.Parse(dr["InPercent"].ToString()); // return boHasPromo; // } // /*******************************Up to Contact, Group, Sub, Prod ID only*****************************/ // SQL = "SELECT " + // "PromoItemsID, " + // "a.PromoID, " + // "PromoTypeID, " + // "ProductGroupID, " + // "ProductSubGroupID, " + // "ProductID, " + // "VariationMatrixID, " + // "Quantity, " + // "PromoValue, " + // "InPercent " + // "FROM tblPromoItems a " + // "INNER JOIN tblPromo b ON a.PromoID = b.PromoID " + // "WHERE ContactID = @ContactID " + // "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');"; // cmd = new MySqlCommand(); // cmd.CommandType = System.Data.CommandType.Text; // 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) // { // PromoType = (PromoTypes)Enum.Parse(typeof(PromoTypes), dr["PromoTypeID"].ToString()); // PromoQuantity = decimal.Parse(dr["Quantity"].ToString()); // PromoValue = decimal.Parse(dr["PromoValue"].ToString()); // InPercent = bool.Parse(dr["InPercent"].ToString()); // return boHasPromo; // } // /*******************************Up to Contact, Sub, Prod ID only*****************************/ // SQL = "SELECT " + // "PromoItemsID, " + // "a.PromoID, " + // "PromoTypeID, " + // "ProductGroupID, " + // "ProductSubGroupID, " + // "ProductID, " + // "VariationMatrixID, " + // "Quantity, " + // "PromoValue, " + // "InPercent " + // "FROM tblPromoItems a " + // "INNER JOIN tblPromo b ON a.PromoID = b.PromoID " + // "WHERE ContactID = @ContactID " + // "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');"; // cmd = new MySqlCommand(); // cmd.CommandType = System.Data.CommandType.Text; // 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) // { // PromoType = (PromoTypes)Enum.Parse(typeof(PromoTypes), dr["PromoTypeID"].ToString()); // PromoQuantity = decimal.Parse(dr["Quantity"].ToString()); // PromoValue = decimal.Parse(dr["PromoValue"].ToString()); // InPercent = bool.Parse(dr["InPercent"].ToString()); // return boHasPromo; // } // /*******************************Up to Contact, Prod ID only*****************************/ // SQL = "SELECT " + // "PromoItemsID, " + // "a.PromoID, " + // "PromoTypeID, " + // "ProductGroupID, " + // "ProductSubGroupID, " + // "ProductID, " + // "VariationMatrixID, " + // "Quantity, " + // "PromoValue, " + // "InPercent " + // "FROM tblPromoItems a " + // "INNER JOIN tblPromo b ON a.PromoID = b.PromoID " + // "WHERE ContactID = @ContactID " + // "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');"; // cmd = new MySqlCommand(); // cmd.CommandType = System.Data.CommandType.Text; // 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) // { // PromoType = (PromoTypes)Enum.Parse(typeof(PromoTypes), dr["PromoTypeID"].ToString()); // PromoQuantity = decimal.Parse(dr["Quantity"].ToString()); // PromoValue = decimal.Parse(dr["PromoValue"].ToString()); // InPercent = bool.Parse(dr["InPercent"].ToString()); // return boHasPromo; // } // /*******************************Up to Contact, Group, Sub only*****************************/ // SQL = "SELECT " + // "PromoItemsID, " + // "a.PromoID, " + // "PromoTypeID, " + // "ProductGroupID, " + // "ProductSubGroupID, " + // "ProductID, " + // "VariationMatrixID, " + // "Quantity, " + // "PromoValue, " + // "InPercent " + // "FROM tblPromoItems a " + // "INNER JOIN tblPromo b ON a.PromoID = b.PromoID " + // "WHERE ContactID = @ContactID " + // "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');"; // cmd = new MySqlCommand(); // cmd.CommandType = System.Data.CommandType.Text; // 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) // { // PromoType = (PromoTypes)Enum.Parse(typeof(PromoTypes), dr["PromoTypeID"].ToString()); // PromoQuantity = decimal.Parse(dr["Quantity"].ToString()); // PromoValue = decimal.Parse(dr["PromoValue"].ToString()); // InPercent = bool.Parse(dr["InPercent"].ToString()); // return boHasPromo; // } // /*******************************Up to Contact, Sub only*****************************/ // SQL = "SELECT " + // "PromoItemsID, " + // "a.PromoID, " + // "PromoTypeID, " + // "ProductGroupID, " + // "ProductSubGroupID, " + // "ProductID, " + // "VariationMatrixID, " + // "Quantity, " + // "PromoValue, " + // "InPercent " + // "FROM tblPromoItems a " + // "INNER JOIN tblPromo b ON a.PromoID = b.PromoID " + // "WHERE ContactID = @ContactID " + // "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');"; // cmd = new MySqlCommand(); // cmd.CommandType = System.Data.CommandType.Text; // 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) // { // PromoType = (PromoTypes)Enum.Parse(typeof(PromoTypes), dr["PromoTypeID"].ToString()); // PromoQuantity = decimal.Parse(dr["Quantity"].ToString()); // PromoValue = decimal.Parse(dr["PromoValue"].ToString()); // InPercent = bool.Parse(dr["InPercent"].ToString()); // return boHasPromo; // } // /*******************************Up to Contact only*****************************/ // SQL = "SELECT " + // "PromoItemsID, " + // "a.PromoID, " + // "PromoTypeID, " + // "ProductGroupID, " + // "ProductSubGroupID, " + // "ProductID, " + // "VariationMatrixID, " + // "Quantity, " + // "PromoValue, " + // "InPercent " + // "FROM tblPromoItems a " + // "INNER JOIN tblPromo b ON a.PromoID = b.PromoID " + // "WHERE ContactID = @ContactID " + // "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');"; // cmd = new MySqlCommand(); // cmd.CommandType = System.Data.CommandType.Text; // 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) // { // PromoType = (PromoTypes)Enum.Parse(typeof(PromoTypes), dr["PromoTypeID"].ToString()); // PromoQuantity = decimal.Parse(dr["Quantity"].ToString()); // PromoValue = decimal.Parse(dr["PromoValue"].ToString()); // InPercent = bool.Parse(dr["InPercent"].ToString()); // return boHasPromo; // } // /*******************************Up to Group, Sub, Prod and VarM ID only*****************************/ // SQL = "SELECT " + // "PromoItemsID, " + // "a.PromoID, " + // "PromoTypeID, " + // "ProductGroupID, " + // "ProductSubGroupID, " + // "ProductID, " + // "VariationMatrixID, " + // "Quantity, " + // "PromoValue, " + // "InPercent " + // "FROM tblPromoItems a " + // "INNER JOIN tblPromo b ON a.PromoID = b.PromoID " + // "WHERE ContactID = 0 " + // "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');"; // cmd = new MySqlCommand(); // cmd.CommandType = System.Data.CommandType.Text; // 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) // { // PromoType = (PromoTypes)Enum.Parse(typeof(PromoTypes), dr["PromoTypeID"].ToString()); // PromoQuantity = decimal.Parse(dr["Quantity"].ToString()); // PromoValue = decimal.Parse(dr["PromoValue"].ToString()); // InPercent = bool.Parse(dr["InPercent"].ToString()); // return boHasPromo; // } // /*******************************Up to Sub, Prod and VariationMatrix ID only*****************************/ // SQL = "SELECT " + // "PromoItemsID, " + // "a.PromoID, " + // "PromoTypeID, " + // "ProductGroupID, " + // "ProductSubGroupID, " + // "ProductID, " + // "VariationMatrixID, " + // "Quantity, " + // "PromoValue, " + // "InPercent " + // "FROM tblPromoItems a " + // "INNER JOIN tblPromo b ON a.PromoID = b.PromoID " + // "WHERE ContactID = 0 " + // "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');"; // cmd = new MySqlCommand(); // cmd.CommandType = System.Data.CommandType.Text; // 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) // { // PromoType = (PromoTypes)Enum.Parse(typeof(PromoTypes), dr["PromoTypeID"].ToString()); // PromoQuantity = decimal.Parse(dr["Quantity"].ToString()); // PromoValue = decimal.Parse(dr["PromoValue"].ToString()); // InPercent = bool.Parse(dr["InPercent"].ToString()); // return boHasPromo; // } // /*******************************Up to Prod and VariationMatrix ID only*****************************/ // SQL = "SELECT " + // "PromoItemsID, " + // "a.PromoID, " + // "PromoTypeID, " + // "ProductGroupID, " + // "ProductSubGroupID, " + // "ProductID, " + // "VariationMatrixID, " + // "Quantity, " + // "PromoValue, " + // "InPercent " + // "FROM tblPromoItems a " + // "INNER JOIN tblPromo b ON a.PromoID = b.PromoID " + // "WHERE ContactID = 0 " + // "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');"; // cmd = new MySqlCommand(); // cmd.CommandType = System.Data.CommandType.Text; // 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) // { // PromoType = (PromoTypes)Enum.Parse(typeof(PromoTypes), dr["PromoTypeID"].ToString()); // PromoQuantity = decimal.Parse(dr["Quantity"].ToString()); // PromoValue = decimal.Parse(dr["PromoValue"].ToString()); // InPercent = bool.Parse(dr["InPercent"].ToString()); // return boHasPromo; // } // /*******************************Up to VariationsMatrix ID only*****************************/ // SQL = "SELECT " + // "PromoItemsID, " + // "a.PromoID, " + // "PromoTypeID, " + // "ProductGroupID, " + // "ProductSubGroupID, " + // "ProductID, " + // "VariationMatrixID, " + // "Quantity, " + // "PromoValue, " + // "InPercent " + // "FROM tblPromoItems a " + // "INNER JOIN tblPromo b ON a.PromoID = b.PromoID " + // "WHERE ContactID = 0 " + // "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');"; // cmd = new MySqlCommand(); // cmd.CommandType = System.Data.CommandType.Text; // 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) // { // PromoType = (PromoTypes)Enum.Parse(typeof(PromoTypes), dr["PromoTypeID"].ToString()); // PromoQuantity = decimal.Parse(dr["Quantity"].ToString()); // PromoValue = decimal.Parse(dr["PromoValue"].ToString()); // InPercent = bool.Parse(dr["InPercent"].ToString()); // return boHasPromo; // } // /*******************************Up to group, Sub, Prod ID only*****************************/ // SQL = "SELECT " + // "PromoItemsID, " + // "a.PromoID, " + // "PromoTypeID, " + // "ProductGroupID, " + // "ProductSubGroupID, " + // "ProductID, " + // "VariationMatrixID, " + // "Quantity, " + // "PromoValue, " + // "InPercent " + // "FROM tblPromoItems a " + // "INNER JOIN tblPromo b ON a.PromoID = b.PromoID " + // "WHERE ContactID = 0 " + // "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');"; // cmd = new MySqlCommand(); // cmd.CommandType = System.Data.CommandType.Text; // 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) // { // PromoType = (PromoTypes)Enum.Parse(typeof(PromoTypes), dr["PromoTypeID"].ToString()); // PromoQuantity = decimal.Parse(dr["Quantity"].ToString()); // PromoValue = decimal.Parse(dr["PromoValue"].ToString()); // InPercent = bool.Parse(dr["InPercent"].ToString()); // return boHasPromo; // } // /*******************************Up to Sub, Prod ID only*****************************/ // SQL = "SELECT " + // "PromoItemsID, " + // "a.PromoID, " + // "PromoTypeID, " + // "ProductGroupID, " + // "ProductSubGroupID, " + // "ProductID, " + // "VariationMatrixID, " + // "Quantity, " + // "PromoValue, " + // "InPercent " + // "FROM tblPromoItems a " + // "INNER JOIN tblPromo b ON a.PromoID = b.PromoID " + // "WHERE ContactID = 0 " + // "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');"; // cmd = new MySqlCommand(); // cmd.CommandType = System.Data.CommandType.Text; // 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) // { // PromoType = (PromoTypes)Enum.Parse(typeof(PromoTypes), dr["PromoTypeID"].ToString()); // PromoQuantity = decimal.Parse(dr["Quantity"].ToString()); // PromoValue = decimal.Parse(dr["PromoValue"].ToString()); // InPercent = bool.Parse(dr["InPercent"].ToString()); // return boHasPromo; // } // /*******************************Up to group, Sub, Prod and VariationMatrix ID only*****************************/ // SQL = "SELECT " + // "PromoItemsID, " + // "a.PromoID, " + // "PromoTypeID, " + // "ProductGroupID, " + // "ProductSubGroupID, " + // "ProductID, " + // "VariationMatrixID, " + // "Quantity, " + // "PromoValue, " + // "InPercent " + // "FROM tblPromoItems a " + // "INNER JOIN tblPromo b ON a.PromoID = b.PromoID " + // "WHERE ContactID = 0 " + // "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');"; // cmd = new MySqlCommand(); // cmd.CommandType = System.Data.CommandType.Text; // 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) // { // PromoType = (PromoTypes)Enum.Parse(typeof(PromoTypes), dr["PromoTypeID"].ToString()); // PromoQuantity = decimal.Parse(dr["Quantity"].ToString()); // PromoValue = decimal.Parse(dr["PromoValue"].ToString()); // InPercent = bool.Parse(dr["InPercent"].ToString()); // return boHasPromo; // } // /*******************************Up to group, Sub ID only*****************************/ // SQL = "SELECT " + // "PromoItemsID, " + // "a.PromoID, " + // "PromoTypeID, " + // "ProductGroupID, " + // "ProductSubGroupID, " + // "ProductID, " + // "VariationMatrixID, " + // "Quantity, " + // "PromoValue, " + // "InPercent " + // "FROM tblPromoItems a " + // "INNER JOIN tblPromo b ON a.PromoID = b.PromoID " + // "WHERE ContactID = 0 " + // "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');"; // cmd = new MySqlCommand(); // cmd.CommandType = System.Data.CommandType.Text; // 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) // { // PromoType = (PromoTypes)Enum.Parse(typeof(PromoTypes), dr["PromoTypeID"].ToString()); // PromoQuantity = decimal.Parse(dr["Quantity"].ToString()); // PromoValue = decimal.Parse(dr["PromoValue"].ToString()); // InPercent = bool.Parse(dr["InPercent"].ToString()); // return boHasPromo; // } // /*******************************Up to Sub ID only*****************************/ // SQL = "SELECT " + // "PromoItemsID, " + // "a.PromoID, " + // "PromoTypeID, " + // "ProductGroupID, " + // "ProductSubGroupID, " + // "ProductID, " + // "VariationMatrixID, " + // "Quantity, " + // "PromoValue, " + // "InPercent " + // "FROM tblPromoItems a " + // "INNER JOIN tblPromo b ON a.PromoID = b.PromoID " + // "WHERE ContactID = 0 " + // "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');"; // cmd = new MySqlCommand(); // cmd.CommandType = System.Data.CommandType.Text; // 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) // { // PromoType = (PromoTypes)Enum.Parse(typeof(PromoTypes), dr["PromoTypeID"].ToString()); // PromoQuantity = decimal.Parse(dr["Quantity"].ToString()); // PromoValue = decimal.Parse(dr["PromoValue"].ToString()); // InPercent = bool.Parse(dr["InPercent"].ToString()); // return boHasPromo; // } // /*******************************Up to group ID only*****************************/ // SQL = "SELECT " + // "PromoItemsID, " + // "a.PromoID, " + // "PromoTypeID, " + // "ProductGroupID, " + // "ProductSubGroupID, " + // "ProductID, " + // "VariationMatrixID, " + // "Quantity, " + // "PromoValue, " + // "InPercent " + // "FROM tblPromoItems a " + // "INNER JOIN tblPromo b ON a.PromoID = b.PromoID " + // "WHERE ContactID = 0 " + // "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');"; // cmd = new MySqlCommand(); // cmd.CommandType = System.Data.CommandType.Text; // 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) // { // PromoType = (PromoTypes)Enum.Parse(typeof(PromoTypes), dr["PromoTypeID"].ToString()); // PromoQuantity = decimal.Parse(dr["Quantity"].ToString()); // PromoValue = decimal.Parse(dr["PromoValue"].ToString()); // InPercent = bool.Parse(dr["InPercent"].ToString()); // return boHasPromo; // } // /*******************************Up to all only*****************************/ // SQL = "SELECT " + // "PromoItemsID, " + // "a.PromoID, " + // "PromoTypeID, " + // "ProductGroupID, " + // "ProductSubGroupID, " + // "ProductID, " + // "VariationMatrixID, " + // "Quantity, " + // "PromoValue, " + // "InPercent " + // "FROM tblPromoItems a " + // "INNER JOIN tblPromo b ON a.PromoID = b.PromoID " + // "WHERE ContactID = 0 " + // "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');"; // cmd = new MySqlCommand(); // cmd.CommandType = System.Data.CommandType.Text; // cmd.CommandText = SQL; // dt = new System.Data.DataTable(strDataTableName); // base.MySqlDataAdapterFill(cmd, dt); // foreach (System.Data.DataRow dr in dt.Rows) // { // PromoType = (PromoTypes)Enum.Parse(typeof(PromoTypes), dr["PromoTypeID"].ToString()); // PromoQuantity = decimal.Parse(dr["Quantity"].ToString()); // PromoValue = decimal.Parse(dr["PromoValue"].ToString()); // InPercent = bool.Parse(dr["InPercent"].ToString()); // return boHasPromo; // } // } // catch (Exception ex) // { // base.ThrowException(ex); // } // return false; //} public bool ApplyPromoValue(ContactDetails clsContactDetails, Int64 ProductID, Int64 VariationMatrixID, out PromoTypes PromoType, out decimal PromoQuantity, out decimal PromoValue, out bool InPercent, int BranchID = 0) { Int64 ContactID = clsContactDetails.ContactID; string strSpecialContactIDs = ""; // rewardcardmember // make sure that it is not the default if (clsContactDetails.ContactID != Constants.C_RETAILPLUS_CUSTOMERID && clsContactDetails.RewardDetails.RewardActive) { if (!string.IsNullOrEmpty(strSpecialContactIDs)) strSpecialContactIDs += "," + Constants.PLUSCARDMEMBERSID_STRING; else strSpecialContactIDs = Constants.PLUSCARDMEMBERSID_STRING; } // icc card members // make sure that it is not the default if (clsContactDetails.ContactID != Constants.C_RETAILPLUS_CUSTOMERID && clsContactDetails.CreditDetails.GuarantorID == Constants.ZERO && clsContactDetails.CreditDetails.CreditActive) { if (!string.IsNullOrEmpty(strSpecialContactIDs)) strSpecialContactIDs += "," + Constants.ICCARDMEMBERSID_STRING; else strSpecialContactIDs = Constants.ICCARDMEMBERSID_STRING; } // gcc card members // make sure that it is not the default if (clsContactDetails.ContactID != Constants.C_RETAILPLUS_CUSTOMERID && clsContactDetails.CreditDetails.GuarantorID != Constants.ZERO && clsContactDetails.CreditDetails.CreditActive) { if (!string.IsNullOrEmpty(strSpecialContactIDs)) strSpecialContactIDs += "," + Constants.GCCARDMEMBERSID_STRING; else strSpecialContactIDs = Constants.GCCARDMEMBERSID_STRING; } PromoType = PromoTypes.NotApplicable; PromoQuantity = 0; PromoValue = 0; InPercent = false; bool boHasPromo = false; try { Data.Products clsProduct = new Data.Products(base.Connection, base.Transaction); Data.ProductDetails clsProductDetails = clsProduct.Details1(BranchID, ProductID); Int64 ProductSubGroupID = clsProductDetails.ProductSubGroupID; Int64 ProductGroupID = clsProductDetails.ProductGroupID; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; string SQL = "SELECT " + "PromoID " + "FROM tblPromo " + "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); foreach (System.Data.DataRow dr in dt.Rows) { boHasPromo = true; break; } if (boHasPromo == false) //return agad if no Promo is affected by date return boHasPromo; /*******************************Up to Contact, Group, Sub, Prod and VarM ID only*****************************/ SQL = "SELECT " + "PromoItemsID, " + "a.PromoID, " + "PromoTypeID, " + "ProductGroupID, " + "ProductSubGroupID, " + "ProductID, " + "VariationMatrixID, " + "Quantity, " + "PromoValue, " + "InPercent " + "FROM tblPromoItems a " + "INNER JOIN tblPromo b ON a.PromoID = b.PromoID " + "WHERE " + (string.IsNullOrEmpty(strSpecialContactIDs) ? "ContactID = @ContactID " : "ContactID IN (@ContactID, " + strSpecialContactIDs + ") ") + "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 PromoValue ASC LIMIT 1;"; cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; 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) { PromoType = (PromoTypes)Enum.Parse(typeof(PromoTypes), dr["PromoTypeID"].ToString()); PromoQuantity = decimal.Parse(dr["Quantity"].ToString()); PromoValue = decimal.Parse(dr["PromoValue"].ToString()); InPercent = bool.Parse(dr["InPercent"].ToString()); return boHasPromo; } /*******************************Up to Contact, Sub, Prod and VariationsMatrix ID only*****************************/ SQL = "SELECT " + "PromoItemsID, " + "a.PromoID, " + "PromoTypeID, " + "ProductGroupID, " + "ProductSubGroupID, " + "ProductID, " + "VariationMatrixID, " + "Quantity, " + "PromoValue, " + "InPercent " + "FROM tblPromoItems a " + "INNER JOIN tblPromo b ON a.PromoID = b.PromoID " + "WHERE " + (string.IsNullOrEmpty(strSpecialContactIDs) ? "ContactID = @ContactID " : "ContactID IN (@ContactID, " + strSpecialContactIDs + ") ") + "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 PromoValue ASC LIMIT 1;"; cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; 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) { PromoType = (PromoTypes)Enum.Parse(typeof(PromoTypes), dr["PromoTypeID"].ToString()); PromoQuantity = decimal.Parse(dr["Quantity"].ToString()); PromoValue = decimal.Parse(dr["PromoValue"].ToString()); InPercent = bool.Parse(dr["InPercent"].ToString()); return boHasPromo; } /*******************************Up to Contact, Prod and VariationsMatrix ID only*****************************/ SQL = "SELECT " + "PromoItemsID, " + "a.PromoID, " + "PromoTypeID, " + "ProductGroupID, " + "ProductSubGroupID, " + "ProductID, " + "VariationMatrixID, " + "Quantity, " + "PromoValue, " + "InPercent " + "FROM tblPromoItems a " + "INNER JOIN tblPromo b ON a.PromoID = b.PromoID " + "WHERE " + (string.IsNullOrEmpty(strSpecialContactIDs) ? "ContactID = @ContactID " : "ContactID IN (@ContactID, " + strSpecialContactIDs + ") ") + "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 PromoValue ASC LIMIT 1;"; cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; 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) { PromoType = (PromoTypes)Enum.Parse(typeof(PromoTypes), dr["PromoTypeID"].ToString()); PromoQuantity = decimal.Parse(dr["Quantity"].ToString()); PromoValue = decimal.Parse(dr["PromoValue"].ToString()); InPercent = bool.Parse(dr["InPercent"].ToString()); return boHasPromo; } /*******************************Up to Contact, VariationsMatrix ID only*****************************/ SQL = "SELECT " + "PromoItemsID, " + "a.PromoID, " + "PromoTypeID, " + "ProductGroupID, " + "ProductSubGroupID, " + "ProductID, " + "VariationMatrixID, " + "Quantity, " + "PromoValue, " + "InPercent " + "FROM tblPromoItems a " + "INNER JOIN tblPromo b ON a.PromoID = b.PromoID " + "WHERE " + (string.IsNullOrEmpty(strSpecialContactIDs) ? "ContactID = @ContactID " : "ContactID IN (@ContactID, " + strSpecialContactIDs + ") ") + "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 PromoValue ASC LIMIT 1;"; cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; 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) { PromoType = (PromoTypes)Enum.Parse(typeof(PromoTypes), dr["PromoTypeID"].ToString()); PromoQuantity = decimal.Parse(dr["Quantity"].ToString()); PromoValue = decimal.Parse(dr["PromoValue"].ToString()); InPercent = bool.Parse(dr["InPercent"].ToString()); return boHasPromo; } /*******************************Up to Contact, Group, Sub, Prod ID only*****************************/ SQL = "SELECT " + "PromoItemsID, " + "a.PromoID, " + "PromoTypeID, " + "ProductGroupID, " + "ProductSubGroupID, " + "ProductID, " + "VariationMatrixID, " + "Quantity, " + "PromoValue, " + "InPercent " + "FROM tblPromoItems a " + "INNER JOIN tblPromo b ON a.PromoID = b.PromoID " + "WHERE " + (string.IsNullOrEmpty(strSpecialContactIDs) ? "ContactID = @ContactID " : "ContactID IN (@ContactID, " + strSpecialContactIDs + ") ") + "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 PromoValue ASC LIMIT 1;"; cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; 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) { PromoType = (PromoTypes)Enum.Parse(typeof(PromoTypes), dr["PromoTypeID"].ToString()); PromoQuantity = decimal.Parse(dr["Quantity"].ToString()); PromoValue = decimal.Parse(dr["PromoValue"].ToString()); InPercent = bool.Parse(dr["InPercent"].ToString()); return boHasPromo; } /*******************************Up to Contact, Sub, Prod ID only*****************************/ SQL = "SELECT " + "PromoItemsID, " + "a.PromoID, " + "PromoTypeID, " + "ProductGroupID, " + "ProductSubGroupID, " + "ProductID, " + "VariationMatrixID, " + "Quantity, " + "PromoValue, " + "InPercent " + "FROM tblPromoItems a " + "INNER JOIN tblPromo b ON a.PromoID = b.PromoID " + "WHERE " + (string.IsNullOrEmpty(strSpecialContactIDs) ? "ContactID = @ContactID " : "ContactID IN (@ContactID, " + strSpecialContactIDs + ") ") + "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 PromoValue ASC LIMIT 1;"; cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; 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) { PromoType = (PromoTypes)Enum.Parse(typeof(PromoTypes), dr["PromoTypeID"].ToString()); PromoQuantity = decimal.Parse(dr["Quantity"].ToString()); PromoValue = decimal.Parse(dr["PromoValue"].ToString()); InPercent = bool.Parse(dr["InPercent"].ToString()); return boHasPromo; } /*******************************Up to Contact, Prod ID only*****************************/ SQL = "SELECT " + "PromoItemsID, " + "a.PromoID, " + "PromoTypeID, " + "ProductGroupID, " + "ProductSubGroupID, " + "ProductID, " + "VariationMatrixID, " + "Quantity, " + "PromoValue, " + "InPercent " + "FROM tblPromoItems a " + "INNER JOIN tblPromo b ON a.PromoID = b.PromoID " + "WHERE " + (string.IsNullOrEmpty(strSpecialContactIDs) ? "ContactID = @ContactID " : "ContactID IN (@ContactID, " + strSpecialContactIDs + ") ") + "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 PromoValue ASC LIMIT 1;"; cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; 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) { PromoType = (PromoTypes)Enum.Parse(typeof(PromoTypes), dr["PromoTypeID"].ToString()); PromoQuantity = decimal.Parse(dr["Quantity"].ToString()); PromoValue = decimal.Parse(dr["PromoValue"].ToString()); InPercent = bool.Parse(dr["InPercent"].ToString()); return boHasPromo; } /*******************************Up to Contact, Group, Sub only*****************************/ SQL = "SELECT " + "PromoItemsID, " + "a.PromoID, " + "PromoTypeID, " + "ProductGroupID, " + "ProductSubGroupID, " + "ProductID, " + "VariationMatrixID, " + "Quantity, " + "PromoValue, " + "InPercent " + "FROM tblPromoItems a " + "INNER JOIN tblPromo b ON a.PromoID = b.PromoID " + "WHERE " + (string.IsNullOrEmpty(strSpecialContactIDs) ? "ContactID = @ContactID " : "ContactID IN (@ContactID, " + strSpecialContactIDs + ") ") + "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 PromoValue ASC LIMIT 1;"; cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; 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) { PromoType = (PromoTypes)Enum.Parse(typeof(PromoTypes), dr["PromoTypeID"].ToString()); PromoQuantity = decimal.Parse(dr["Quantity"].ToString()); PromoValue = decimal.Parse(dr["PromoValue"].ToString()); InPercent = bool.Parse(dr["InPercent"].ToString()); return boHasPromo; } /*******************************Up to Contact, Sub only*****************************/ SQL = "SELECT " + "PromoItemsID, " + "a.PromoID, " + "PromoTypeID, " + "ProductGroupID, " + "ProductSubGroupID, " + "ProductID, " + "VariationMatrixID, " + "Quantity, " + "PromoValue, " + "InPercent " + "FROM tblPromoItems a " + "INNER JOIN tblPromo b ON a.PromoID = b.PromoID " + "WHERE " + (string.IsNullOrEmpty(strSpecialContactIDs) ? "ContactID = @ContactID " : "ContactID IN (@ContactID, " + strSpecialContactIDs + ") ") + "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 PromoValue ASC LIMIT 1;"; cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; 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) { PromoType = (PromoTypes)Enum.Parse(typeof(PromoTypes), dr["PromoTypeID"].ToString()); PromoQuantity = decimal.Parse(dr["Quantity"].ToString()); PromoValue = decimal.Parse(dr["PromoValue"].ToString()); InPercent = bool.Parse(dr["InPercent"].ToString()); return boHasPromo; } /*******************************Up to Contact only*****************************/ SQL = "SELECT " + "PromoItemsID, " + "a.PromoID, " + "PromoTypeID, " + "ProductGroupID, " + "ProductSubGroupID, " + "ProductID, " + "VariationMatrixID, " + "Quantity, " + "PromoValue, " + "InPercent " + "FROM tblPromoItems a " + "INNER JOIN tblPromo b ON a.PromoID = b.PromoID " + "WHERE " + (string.IsNullOrEmpty(strSpecialContactIDs) ? "ContactID = @ContactID " : "ContactID IN (@ContactID, " + strSpecialContactIDs + ") ") + "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 PromoValue ASC LIMIT 1;"; cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; 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) { PromoType = (PromoTypes)Enum.Parse(typeof(PromoTypes), dr["PromoTypeID"].ToString()); PromoQuantity = decimal.Parse(dr["Quantity"].ToString()); PromoValue = decimal.Parse(dr["PromoValue"].ToString()); InPercent = bool.Parse(dr["InPercent"].ToString()); return boHasPromo; } /*******************************Up to Group, Sub, Prod and VarM ID only*****************************/ SQL = "SELECT " + "PromoItemsID, " + "a.PromoID, " + "PromoTypeID, " + "ProductGroupID, " + "ProductSubGroupID, " + "ProductID, " + "VariationMatrixID, " + "Quantity, " + "PromoValue, " + "InPercent " + "FROM tblPromoItems a " + "INNER JOIN tblPromo b ON a.PromoID = b.PromoID " + "WHERE " + (string.IsNullOrEmpty(strSpecialContactIDs) ? "ContactID = 0 " : "ContactID IN (0, " + strSpecialContactIDs + ") ") + "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 PromoValue ASC LIMIT 1;"; cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; 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) { PromoType = (PromoTypes)Enum.Parse(typeof(PromoTypes), dr["PromoTypeID"].ToString()); PromoQuantity = decimal.Parse(dr["Quantity"].ToString()); PromoValue = decimal.Parse(dr["PromoValue"].ToString()); InPercent = bool.Parse(dr["InPercent"].ToString()); return boHasPromo; } /*******************************Up to Sub, Prod and VariationMatrix ID only*****************************/ SQL = "SELECT " + "PromoItemsID, " + "a.PromoID, " + "PromoTypeID, " + "ProductGroupID, " + "ProductSubGroupID, " + "ProductID, " + "VariationMatrixID, " + "Quantity, " + "PromoValue, " + "InPercent " + "FROM tblPromoItems a " + "INNER JOIN tblPromo b ON a.PromoID = b.PromoID " + "WHERE " + (string.IsNullOrEmpty(strSpecialContactIDs) ? "ContactID = 0 " : "ContactID IN (0, " + strSpecialContactIDs + ") ") + "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 PromoValue ASC LIMIT 1;"; cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; 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) { PromoType = (PromoTypes)Enum.Parse(typeof(PromoTypes), dr["PromoTypeID"].ToString()); PromoQuantity = decimal.Parse(dr["Quantity"].ToString()); PromoValue = decimal.Parse(dr["PromoValue"].ToString()); InPercent = bool.Parse(dr["InPercent"].ToString()); return boHasPromo; } /*******************************Up to Prod and VariationMatrix ID only*****************************/ SQL = "SELECT " + "PromoItemsID, " + "a.PromoID, " + "PromoTypeID, " + "ProductGroupID, " + "ProductSubGroupID, " + "ProductID, " + "VariationMatrixID, " + "Quantity, " + "PromoValue, " + "InPercent " + "FROM tblPromoItems a " + "INNER JOIN tblPromo b ON a.PromoID = b.PromoID " + "WHERE " + (string.IsNullOrEmpty(strSpecialContactIDs) ? "ContactID = 0 " : "ContactID IN (0, " + strSpecialContactIDs + ") ") + "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 PromoValue ASC LIMIT 1;"; cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; 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) { PromoType = (PromoTypes)Enum.Parse(typeof(PromoTypes), dr["PromoTypeID"].ToString()); PromoQuantity = decimal.Parse(dr["Quantity"].ToString()); PromoValue = decimal.Parse(dr["PromoValue"].ToString()); InPercent = bool.Parse(dr["InPercent"].ToString()); return boHasPromo; } /*******************************Up to VariationsMatrix ID only*****************************/ SQL = "SELECT " + "PromoItemsID, " + "a.PromoID, " + "PromoTypeID, " + "ProductGroupID, " + "ProductSubGroupID, " + "ProductID, " + "VariationMatrixID, " + "Quantity, " + "PromoValue, " + "InPercent " + "FROM tblPromoItems a " + "INNER JOIN tblPromo b ON a.PromoID = b.PromoID " + "WHERE " + (string.IsNullOrEmpty(strSpecialContactIDs) ? "ContactID = 0 " : "ContactID IN (0, " + strSpecialContactIDs + ") ") + "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 PromoValue ASC LIMIT 1;"; cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; 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) { PromoType = (PromoTypes)Enum.Parse(typeof(PromoTypes), dr["PromoTypeID"].ToString()); PromoQuantity = decimal.Parse(dr["Quantity"].ToString()); PromoValue = decimal.Parse(dr["PromoValue"].ToString()); InPercent = bool.Parse(dr["InPercent"].ToString()); return boHasPromo; } /*******************************Up to group, Sub, Prod ID only*****************************/ SQL = "SELECT " + "PromoItemsID, " + "a.PromoID, " + "PromoTypeID, " + "ProductGroupID, " + "ProductSubGroupID, " + "ProductID, " + "VariationMatrixID, " + "Quantity, " + "PromoValue, " + "InPercent " + "FROM tblPromoItems a " + "INNER JOIN tblPromo b ON a.PromoID = b.PromoID " + "WHERE " + (string.IsNullOrEmpty(strSpecialContactIDs) ? "ContactID = 0 " : "ContactID IN (0, " + strSpecialContactIDs + ") ") + "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 PromoValue ASC LIMIT 1;"; cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; 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) { PromoType = (PromoTypes)Enum.Parse(typeof(PromoTypes), dr["PromoTypeID"].ToString()); PromoQuantity = decimal.Parse(dr["Quantity"].ToString()); PromoValue = decimal.Parse(dr["PromoValue"].ToString()); InPercent = bool.Parse(dr["InPercent"].ToString()); return boHasPromo; } /*******************************Up to Sub, Prod ID only*****************************/ SQL = "SELECT " + "PromoItemsID, " + "a.PromoID, " + "PromoTypeID, " + "ProductGroupID, " + "ProductSubGroupID, " + "ProductID, " + "VariationMatrixID, " + "Quantity, " + "PromoValue, " + "InPercent " + "FROM tblPromoItems a " + "INNER JOIN tblPromo b ON a.PromoID = b.PromoID " + "WHERE " + (string.IsNullOrEmpty(strSpecialContactIDs) ? "ContactID = 0 " : "ContactID IN (0, " + strSpecialContactIDs + ") ") + "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 PromoValue ASC LIMIT 1;"; cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; 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) { PromoType = (PromoTypes)Enum.Parse(typeof(PromoTypes), dr["PromoTypeID"].ToString()); PromoQuantity = decimal.Parse(dr["Quantity"].ToString()); PromoValue = decimal.Parse(dr["PromoValue"].ToString()); InPercent = bool.Parse(dr["InPercent"].ToString()); return boHasPromo; } /*******************************Up to group, Sub, Prod and VariationMatrix ID only*****************************/ SQL = "SELECT " + "PromoItemsID, " + "a.PromoID, " + "PromoTypeID, " + "ProductGroupID, " + "ProductSubGroupID, " + "ProductID, " + "VariationMatrixID, " + "Quantity, " + "PromoValue, " + "InPercent " + "FROM tblPromoItems a " + "INNER JOIN tblPromo b ON a.PromoID = b.PromoID " + "WHERE " + (string.IsNullOrEmpty(strSpecialContactIDs) ? "ContactID = 0 " : "ContactID IN (0, " + strSpecialContactIDs + ") ") + "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 PromoValue ASC LIMIT 1;"; cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; 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) { PromoType = (PromoTypes)Enum.Parse(typeof(PromoTypes), dr["PromoTypeID"].ToString()); PromoQuantity = decimal.Parse(dr["Quantity"].ToString()); PromoValue = decimal.Parse(dr["PromoValue"].ToString()); InPercent = bool.Parse(dr["InPercent"].ToString()); return boHasPromo; } /*******************************Up to group, Sub ID only*****************************/ SQL = "SELECT " + "PromoItemsID, " + "a.PromoID, " + "PromoTypeID, " + "ProductGroupID, " + "ProductSubGroupID, " + "ProductID, " + "VariationMatrixID, " + "Quantity, " + "PromoValue, " + "InPercent " + "FROM tblPromoItems a " + "INNER JOIN tblPromo b ON a.PromoID = b.PromoID " + "WHERE " + (string.IsNullOrEmpty(strSpecialContactIDs) ? "ContactID = 0 " : "ContactID IN (0, " + strSpecialContactIDs + ") ") + "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 PromoValue ASC LIMIT 1;"; cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; 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) { PromoType = (PromoTypes)Enum.Parse(typeof(PromoTypes), dr["PromoTypeID"].ToString()); PromoQuantity = decimal.Parse(dr["Quantity"].ToString()); PromoValue = decimal.Parse(dr["PromoValue"].ToString()); InPercent = bool.Parse(dr["InPercent"].ToString()); return boHasPromo; } /*******************************Up to Sub ID only*****************************/ SQL = "SELECT " + "PromoItemsID, " + "a.PromoID, " + "PromoTypeID, " + "ProductGroupID, " + "ProductSubGroupID, " + "ProductID, " + "VariationMatrixID, " + "Quantity, " + "PromoValue, " + "InPercent " + "FROM tblPromoItems a " + "INNER JOIN tblPromo b ON a.PromoID = b.PromoID " + "WHERE " + (string.IsNullOrEmpty(strSpecialContactIDs) ? "ContactID = 0 " : "ContactID IN (0, " + strSpecialContactIDs + ") ") + "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 PromoValue ASC LIMIT 1;"; cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; 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) { PromoType = (PromoTypes)Enum.Parse(typeof(PromoTypes), dr["PromoTypeID"].ToString()); PromoQuantity = decimal.Parse(dr["Quantity"].ToString()); PromoValue = decimal.Parse(dr["PromoValue"].ToString()); InPercent = bool.Parse(dr["InPercent"].ToString()); return boHasPromo; } /*******************************Up to group ID only*****************************/ SQL = "SELECT " + "PromoItemsID, " + "a.PromoID, " + "PromoTypeID, " + "ProductGroupID, " + "ProductSubGroupID, " + "ProductID, " + "VariationMatrixID, " + "Quantity, " + "PromoValue, " + "InPercent " + "FROM tblPromoItems a " + "INNER JOIN tblPromo b ON a.PromoID = b.PromoID " + "WHERE " + (string.IsNullOrEmpty(strSpecialContactIDs) ? "ContactID = 0 " : "ContactID IN (0, " + strSpecialContactIDs + ") ") + "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 PromoValue ASC LIMIT 1;"; cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; 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) { PromoType = (PromoTypes)Enum.Parse(typeof(PromoTypes), dr["PromoTypeID"].ToString()); PromoQuantity = decimal.Parse(dr["Quantity"].ToString()); PromoValue = decimal.Parse(dr["PromoValue"].ToString()); InPercent = bool.Parse(dr["InPercent"].ToString()); return boHasPromo; } /*******************************Up to all only*****************************/ SQL = "SELECT " + "PromoItemsID, " + "a.PromoID, " + "PromoTypeID, " + "ProductGroupID, " + "ProductSubGroupID, " + "ProductID, " + "VariationMatrixID, " + "Quantity, " + "PromoValue, " + "InPercent " + "FROM tblPromoItems a " + "INNER JOIN tblPromo b ON a.PromoID = b.PromoID " + "WHERE " + (string.IsNullOrEmpty(strSpecialContactIDs) ? "ContactID = 0 " : "ContactID IN (0, " + strSpecialContactIDs + ") ") + "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 PromoValue ASC LIMIT 1;"; cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; dt = new System.Data.DataTable(strDataTableName); base.MySqlDataAdapterFill(cmd, dt); foreach (System.Data.DataRow dr in dt.Rows) { PromoType = (PromoTypes)Enum.Parse(typeof(PromoTypes), dr["PromoTypeID"].ToString()); PromoQuantity = decimal.Parse(dr["Quantity"].ToString()); PromoValue = decimal.Parse(dr["PromoValue"].ToString()); InPercent = bool.Parse(dr["InPercent"].ToString()); return boHasPromo; } } catch (Exception ex) { base.ThrowException(ex); } return false; }
private Int64 SaveRecord() { ContactDetails clsDetails = new ContactDetails(); clsDetails.ContactCode = txtContactCode.Text; clsDetails.ContactName = txtLastName.Text + ", " + txtFirstName.Text + " " + txtMiddleName.Text; clsDetails.ContactGroupID = Convert.ToInt32(cboGroup.SelectedItem.Value); clsDetails.ModeOfTerms = ModeOfTerms.Days; clsDetails.Terms = Convert.ToInt32("0"); clsDetails.Address = txtAddress.Text; clsDetails.BusinessName = txtBusinessName.Text; clsDetails.TelephoneNo = txtTelephoneNo.Text; clsDetails.Remarks = txtRemarks.Text; clsDetails.Debit = Convert.ToDecimal("0"); clsDetails.Credit = Convert.ToDecimal("0"); clsDetails.IsCreditAllowed = true; clsDetails.CreditLimit = Convert.ToDecimal(0); clsDetails.DepartmentID = Convert.ToInt16(cboDepartment.SelectedItem.Value); clsDetails.PositionID = Convert.ToInt16(cboPosition.SelectedItem.Value); ContactAddOnDetails clsAddOnDetails = new ContactAddOnDetails(); clsAddOnDetails.ContactID = clsDetails.ContactID; clsAddOnDetails.Salutation = cboSalutation.SelectedItem.Value; clsAddOnDetails.FirstName = txtFirstName.Text; clsAddOnDetails.MiddleName = txtMiddleName.Text; clsAddOnDetails.LastName = txtLastName.Text; clsAddOnDetails.SpouseName = ""; DateTime dteBirthDate = Constants.C_DATE_MIN_VALUE; dteBirthDate = DateTime.TryParse(txtBirthDate.Text, out dteBirthDate) ? dteBirthDate : Constants.C_DATE_MIN_VALUE; clsAddOnDetails.BirthDate = dteBirthDate; clsAddOnDetails.SpouseBirthDate = Constants.C_DATE_MIN_VALUE; clsAddOnDetails.AnniversaryDate = Constants.C_DATE_MIN_VALUE; clsAddOnDetails.Address1 = txtAddress.Text; clsAddOnDetails.Address2 = string.Empty; clsAddOnDetails.City = string.Empty; clsAddOnDetails.State = string.Empty; clsAddOnDetails.ZipCode = string.Empty; clsAddOnDetails.CountryID = Constants.C_DEF_COUNTRY_ID; clsAddOnDetails.CountryCode = Constants.C_DEF_COUNTRY_CODE; clsAddOnDetails.BusinessPhoneNo = txtTelephoneNo.Text; clsAddOnDetails.HomePhoneNo = string.Empty; clsAddOnDetails.MobileNo = txtMobileNo.Text; clsAddOnDetails.FaxNo = string.Empty; clsAddOnDetails.EmailAddress = string.Empty; clsDetails.AdditionalDetails = clsAddOnDetails; Contacts clsContact = new Contacts(); Int64 id = clsContact.Insert(clsDetails); clsContact.CommitAndDispose(); return id; }
private void IssueCreditCard() { if (mboIsInTransaction) { MessageBox.Show("Sorry you cannot issue a Credit Card while there is an ongoing transaction." + Environment.NewLine + "Please finish the transaction first.", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } DialogResult loginresult = GetWriteAccessAndLogin(mclsSalesTransactionDetails.CashierID, AccessTypes.CreditCardIssuance); if (loginresult == DialogResult.OK) { try { DialogResult result; Data.CardTypeDetails clsCardTypeDetails = new Data.CardTypeDetails(); Data.ContactDetails clsGuarantorDetails = new AceSoft.RetailPlus.Data.ContactDetails(); ContactCreditTypeSelectWnd clsContactCreditTypeSelectWnd = new ContactCreditTypeSelectWnd(); clsContactCreditTypeSelectWnd.TerminalDetails = mclsTerminalDetails; clsContactCreditTypeSelectWnd.ShowDialog(this); clsCardTypeDetails = clsContactCreditTypeSelectWnd.CardTypeDetails; result = clsContactCreditTypeSelectWnd.Result; clsContactCreditTypeSelectWnd.Close(); clsContactCreditTypeSelectWnd.Dispose(); if (result != DialogResult.OK) { return; } Data.ContactDetails clsContactDetails; ContactSelectWnd clsContactWnd = new ContactSelectWnd(); clsContactWnd.EnableContactAddUpdate = GetWriteAccess(mclsSalesTransactionDetails.CashierID, AccessTypes.Contacts) == System.Windows.Forms.DialogResult.OK; clsContactWnd.SysConfigDetails = mclsSysConfigDetails; clsContactWnd.TerminalDetails = mclsTerminalDetails; if (clsCardTypeDetails.WithGuarantor) { MessageBox.Show("Please select a GUARANTOR to issue Credit Card.", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Warning); clsContactWnd.ContactGroupCategory = AceSoft.RetailPlus.Data.ContactGroupCategory.CUSTOMER; clsContactWnd.Header = "Select GUARANTOR to issue Credit Card."; clsContactWnd.ShowDialog(this); clsGuarantorDetails = clsContactWnd.Details; result = clsContactWnd.Result; clsContactWnd.Close(); clsContactWnd.Dispose(); if (result != DialogResult.OK) { return; } MessageBox.Show(clsGuarantorDetails.ContactName + " has been selected as guarantor." + Environment.NewLine + "Please select the CUSTOMER to issue Credit Card.", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Warning); } clsContactWnd = new ContactSelectWnd(); clsContactWnd.ContactGroupCategory = AceSoft.RetailPlus.Data.ContactGroupCategory.CUSTOMER; clsContactWnd.Header = "Select CUSTOMER to issue Credit Card."; clsContactWnd.ShowDialog(this); clsContactDetails = clsContactWnd.Details; result = clsContactWnd.Result; clsContactWnd.Close(); clsContactWnd.Dispose(); if (result != DialogResult.OK) { return; } if (clsContactDetails.ContactID == Constants.ZERO || clsContactDetails.ContactID == Constants.C_RETAILPLUS_CUSTOMERID) { return; } if (!clsCardTypeDetails.WithGuarantor) clsGuarantorDetails = clsContactDetails; clsEvent.AddEvent("[" + lblCashier.Text + "] Issuing credit card no to " + clsContactDetails.ContactName); Data.Contacts clsContact = new Data.Contacts(mConnection, mTransaction); mConnection = clsContact.Connection; mTransaction = clsContact.Transaction; clsContactDetails = clsContact.Details(clsContactDetails.ContactID); clsContact.CommitAndDispose(); if (clsContactDetails.CreditDetails.CreditCardNo != string.Empty && clsContactDetails.CreditDetails.CreditCardNo != null) { clsEvent.AddEventLn("Cancelled!"); clsEvent.AddEventLn("Credit Card No: " + clsContactDetails.CreditDetails.CreditCardNo + " was already issued to " + clsContactDetails.ContactName + " on " + clsContactDetails.CreditDetails.CreditAwardDate.ToString("MMM dd, yyyy hh:mm tt")); MessageBox.Show("Credit Card No: " + clsContactDetails.CreditDetails.CreditCardNo + " was already issued to " + clsContactDetails.ContactName + " on " + clsContactDetails.CreditDetails.CreditAwardDate.ToString("MMM dd, yyyy hh:mm tt") + "." + Environment.NewLine + " Please select another customer to issue Credit Card.", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } clsEvent.AddEvent("[" + lblCashier.Text + "] Issuing credit card no to " + clsContactDetails.ContactName); ContactCreditWnd clsContactCreditWnd = new ContactCreditWnd(); clsContactCreditWnd.Header = "Credit Card Issuance"; clsContactCreditWnd.CardTypeDetails = clsCardTypeDetails; clsContactCreditWnd.Guarantor = clsGuarantorDetails; clsContactCreditWnd.ContactDetails = clsContactDetails; clsContactCreditWnd.CreditCardStatus = CreditCardStatus.New; clsContactCreditWnd.TerminalDetails = mclsTerminalDetails; clsContactCreditWnd.ShowDialog(this); result = clsContactCreditWnd.Result; clsContactDetails = clsContactCreditWnd.ContactDetails; clsContactCreditWnd.Close(); clsContactCreditWnd.Dispose(); if (result == DialogResult.OK) { Data.Products clsProducts = new Data.Products(mConnection, mTransaction); mConnection = clsProducts.Connection; mTransaction = clsProducts.Transaction; if (clsProducts.Details(Data.Products.DEFAULT_CREDIT_CARD_MEMBERSHIP_FEE_BARCODE).ProductID == 0) { clsProducts.CREATE_CREDIT_CARD_MEMBERSHIP_FEE_BARCODE_PRODUCT(); Methods.InsertAuditLog(mclsTerminalDetails, "System Administrator", AccessTypes.RewardCardChange, "CREDIT_CARD_MEMBERSHIP_FEE_BARCODE product has been created coz it's not configured"); } clsProducts.CommitAndDispose(); MessageBox.Show("Credit Card No: " + clsContactDetails.CreditDetails.CreditCardNo + " was issued to " + clsContactDetails.ContactName + "." + Environment.NewLine + "Please collect the payment then close the transaction.", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Warning); clsEvent.AddEventLn("Done!", true); clsEvent.AddEventLn("Credit Card No: " + clsContactDetails.CreditDetails.CreditCardNo + " was issued to " + clsContactDetails.ContactName + ".", true); LocalDB clsLocalDB = new LocalDB(mConnection, mTransaction); mConnection = clsLocalDB.Connection; mTransaction = clsLocalDB.Transaction; clsEvent.AddEvent("[" + lblCashier.Text + "] Creating " + Data.Products.DEFAULT_CREDIT_CARD_MEMBERSHIP_FEE_BARCODE + "transaction for customer: "); LoadContact(AceSoft.RetailPlus.Data.ContactGroupCategory.CUSTOMER, clsContactDetails); if (!this.CreateTransaction()) return; txtBarCode.Text = Data.Products.DEFAULT_CREDIT_CARD_MEMBERSHIP_FEE_BARCODE; ReadBarCode(); int iRow = dgItems.CurrentRowIndex; txtBarCode.Text = ""; CloseTransaction(); clsLocalDB.CommitAndDispose(); } else { clsEvent.AddEventLn("Cancelled!"); } } catch (Exception ex) { InsertErrorLogToFile(ex, "ERROR!!! Issuing internal credit-card."); } Cursor.Current = Cursors.Default; } }
public void UpdateContact(Int64 TransactionID, DateTime TransactionDate, ContactDetails details) { try { string SQL = "CALL procTransactionContactUpdate(@TransactionID, @CustomerID, @CustomerName, @CustomerGroupName, @ModeOfTerms, @Terms);"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; cmd.Parameters.AddWithValue("@TransactionID", TransactionID); cmd.Parameters.AddWithValue("@CustomerID", details.ContactID); cmd.Parameters.AddWithValue("@CustomerName", details.ContactName); cmd.Parameters.AddWithValue("@CustomerGroupName", details.ContactGroupName); cmd.Parameters.AddWithValue("@ModeOfTerms", details.ModeOfTerms.ToString("d")); cmd.Parameters.AddWithValue("@Terms", details.Terms); base.ExecuteNonQuery(cmd); } catch (Exception ex) { throw base.ThrowException(ex); } }
private void SaveRecord() { Contacts clsContact = new Contacts(); ContactDetails clsDetails = new ContactDetails(); clsDetails.ContactID = Convert.ToInt32(lblContactID.Text); clsDetails.ContactCode = lblCustomerCode.Text; clsDetails.ContactName = txtLastName.Text + ", " + txtFirstName.Text + " " + txtMiddleName.Text; clsDetails.ContactGroupID = Convert.ToInt32(cboGroup.SelectedItem.Value); clsDetails.ModeOfTerms = ModeOfTerms.Months; clsDetails.Terms = 0; clsDetails.Address = txtAddress1.Text + " " + txtAddress2.Text + " " + txtCity.Text + " " + txtState.Text + " " + txtZipCode.Text; clsDetails.BusinessName = txtBusinessName.Text; clsDetails.TelephoneNo = txtBusinessPhoneNo.Text; clsDetails.Remarks = txtRemarks.Text; clsDetails.Debit = 0; clsDetails.Credit = 0; clsDetails.IsCreditAllowed = false; clsDetails.CreditLimit = 0; clsDetails.DepartmentID = Convert.ToInt16(cboDepartment.SelectedItem.Value); clsDetails.PositionID = Convert.ToInt16(cboPosition.SelectedItem.Value); DateTime dteBirthDate = Constants.C_DATE_MIN_VALUE; DateTime dteSpouseBirthDate = Constants.C_DATE_MIN_VALUE; DateTime dteAnniversaryDate = Constants.C_DATE_MIN_VALUE; dteBirthDate = DateTime.TryParse(txtBirthDate.Text, out dteBirthDate) ? dteBirthDate : Constants.C_DATE_MIN_VALUE; dteSpouseBirthDate = DateTime.TryParse(txtSpouseBirthDate.Text, out dteSpouseBirthDate) ? dteSpouseBirthDate : Constants.C_DATE_MIN_VALUE; dteAnniversaryDate = DateTime.TryParse(txtAnniversaryDate.Text, out dteAnniversaryDate) ? dteAnniversaryDate : Constants.C_DATE_MIN_VALUE; ContactAddOnDetails clsAddOnDetails = new ContactAddOnDetails(); clsAddOnDetails.ContactID = clsDetails.ContactID; clsAddOnDetails.Salutation = cboSalutation.SelectedItem.Value; clsAddOnDetails.FirstName = txtFirstName.Text; clsAddOnDetails.MiddleName = txtMiddleName.Text; clsAddOnDetails.LastName = txtLastName.Text; clsAddOnDetails.SpouseName = txtSpouseName.Text; clsAddOnDetails.BirthDate = dteBirthDate; clsAddOnDetails.SpouseBirthDate = dteSpouseBirthDate; clsAddOnDetails.AnniversaryDate = dteAnniversaryDate; clsAddOnDetails.Address1 = txtAddress1.Text; clsAddOnDetails.Address2 = txtAddress2.Text; clsAddOnDetails.City = txtCity.Text; clsAddOnDetails.State = txtState.Text; clsAddOnDetails.ZipCode = txtZipCode.Text; clsAddOnDetails.CountryID = int.Parse(cboCountry.SelectedItem.Value); clsAddOnDetails.CountryCode = cboCountry.SelectedItem.Text; clsAddOnDetails.BusinessPhoneNo = txtBusinessPhoneNo.Text; clsAddOnDetails.HomePhoneNo = txtHomePhoneNo.Text; clsAddOnDetails.MobileNo = txtMobileNo.Text; clsAddOnDetails.FaxNo = txtFaxNo.Text; clsAddOnDetails.EmailAddress = txtEmailAddress.Text; clsDetails.AdditionalDetails = clsAddOnDetails; clsContact.Update(clsDetails); clsContact.CommitAndDispose(); }
public void UpdateAgent(Int64 TransactionID, DateTime TransactionDate, ContactDetails details) { try { string SQL = "CALL procTransactionAgentUpdate(@TransactionID, @AgentID, @AgentName, @AgentPositionName, @AgentDepartmentName);"; MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = SQL; cmd.Parameters.AddWithValue("@TransactionID", TransactionID); cmd.Parameters.AddWithValue("@AgentID", details.ContactID); cmd.Parameters.AddWithValue("@AgentName", details.ContactName); cmd.Parameters.AddWithValue("@AgentPositionName", details.PositionName); cmd.Parameters.AddWithValue("@AgentDepartmentName", details.DepartmentName); base.ExecuteNonQuery(cmd); } catch (Exception ex) { throw base.ThrowException(ex); } }
private Int64 SaveRecord() { ContactDetails clsDetails = new ContactDetails(); ERPConfig clsERPConfig = new ERPConfig(); BarcodeHelper ean13 = new BarcodeHelper(BarcodeHelper.CustomerCode_Country_Code, BarcodeHelper.CustomerCode_ManufacturerCode, clsERPConfig.get_LastCustomerCode()); clsDetails.ContactCode = ean13.CountryCode + ean13.ManufacturerCode + ean13.ProductCode + ean13.ChecksumDigit; clsERPConfig.CommitAndDispose(); clsDetails.ContactName = txtLastName.Text + ", " + txtFirstName.Text + " " + txtMiddleName.Text; clsDetails.ContactGroupID = Convert.ToInt32(cboGroup.SelectedItem.Value); clsDetails.ModeOfTerms = ModeOfTerms.Months; clsDetails.Terms = 0; clsDetails.Address = txtAddress1.Text + " " + txtAddress2.Text + " " + txtCity.Text + " " + txtState.Text + " " + txtZipCode.Text; clsDetails.BusinessName = txtBusinessName.Text; clsDetails.TelephoneNo = txtBusinessPhoneNo.Text; clsDetails.Remarks = txtRemarks.Text; clsDetails.Debit = 0; clsDetails.Credit = 0; clsDetails.IsCreditAllowed = false; clsDetails.CreditLimit = 0; clsDetails.DepartmentID = Convert.ToInt16(cboDepartment.SelectedItem.Value); clsDetails.PositionID = Convert.ToInt16(cboPosition.SelectedItem.Value); DateTime dteBirthDate = Constants.C_DATE_MIN_VALUE; DateTime dteSpouseBirthDate = Constants.C_DATE_MIN_VALUE; DateTime dteAnniversaryDate = Constants.C_DATE_MIN_VALUE; dteBirthDate = DateTime.TryParse(txtBirthDate.Text, out dteBirthDate) ? dteBirthDate : Constants.C_DATE_MIN_VALUE; dteSpouseBirthDate = DateTime.TryParse(txtSpouseBirthDate.Text, out dteSpouseBirthDate) ? dteSpouseBirthDate : Constants.C_DATE_MIN_VALUE; dteAnniversaryDate = DateTime.TryParse(txtAnniversaryDate.Text, out dteAnniversaryDate) ? dteAnniversaryDate : Constants.C_DATE_MIN_VALUE; ContactAddOnDetails clsAddOnDetails = new ContactAddOnDetails(); clsAddOnDetails.ContactID = clsDetails.ContactID; clsAddOnDetails.Salutation = cboSalutation.SelectedItem.Value; clsAddOnDetails.FirstName = txtFirstName.Text; clsAddOnDetails.MiddleName = txtMiddleName.Text; clsAddOnDetails.LastName = txtLastName.Text; clsAddOnDetails.SpouseName = txtSpouseName.Text; clsAddOnDetails.BirthDate = dteBirthDate; clsAddOnDetails.SpouseBirthDate = dteSpouseBirthDate; clsAddOnDetails.AnniversaryDate = dteAnniversaryDate; clsAddOnDetails.Address1 = txtAddress1.Text; clsAddOnDetails.Address2 = txtAddress2.Text; clsAddOnDetails.City = txtCity.Text; clsAddOnDetails.State = txtState.Text; clsAddOnDetails.ZipCode = txtZipCode.Text; clsAddOnDetails.CountryID = int.Parse(cboCountry.SelectedItem.Value); clsAddOnDetails.CountryCode = cboCountry.SelectedItem.Text; clsAddOnDetails.BusinessPhoneNo = txtBusinessPhoneNo.Text; clsAddOnDetails.HomePhoneNo = txtHomePhoneNo.Text; clsAddOnDetails.MobileNo = txtMobileNo.Text; clsAddOnDetails.FaxNo = txtFaxNo.Text; clsAddOnDetails.EmailAddress = txtEmailAddress.Text; clsDetails.AdditionalDetails = clsAddOnDetails; Contacts clsContact = new Contacts(); Int64 id = clsContact.Insert(clsDetails); clsContact.CommitAndDispose(); return id; }