public static ProductDetails setSyncProductDetails(XmlReader xmlReader)
{
ProductDetails clsProductDetails = new ProductDetails();
clsProductDetails.ProductID = Int64.Parse(xmlReader.GetAttribute("ProductID").ToString());
clsProductDetails.ProductCode = xmlReader.GetAttribute("ProductCode").ToString();
clsProductDetails.ProductDesc = xmlReader.GetAttribute("ProductDesc").ToString();
clsProductDetails.ProductSubGroupID = Int64.Parse(xmlReader.GetAttribute("ProductSubGroupID").ToString());
clsProductDetails.BaseUnitID = Int32.Parse(xmlReader.GetAttribute("BaseUnitID").ToString());
clsProductDetails.DateCreated = DateTime.TryParse(xmlReader.GetAttribute("DateCreated").ToString(), out clsProductDetails.DateCreated) ? clsProductDetails.DateCreated : DateTime.Now;
clsProductDetails.Deleted = bool.Parse(xmlReader.GetAttribute("Deleted").ToString());
clsProductDetails.IncludeInSubtotalDiscount = bool.Parse(xmlReader.GetAttribute("IncludeInSubtotalDiscount").ToString());
clsProductDetails.WillPrintProductComposition = bool.Parse(xmlReader.GetAttribute("WillPrintProductComposition").ToString());
clsProductDetails.Active = bool.Parse(xmlReader.GetAttribute("Active").ToString());
clsProductDetails.PercentageCommision = decimal.Parse(xmlReader.GetAttribute("PercentageCommision").ToString());
clsProductDetails.RID = Int64.Parse(xmlReader.GetAttribute("RID").ToString());
clsProductDetails.RewardPoints = decimal.Parse(xmlReader.GetAttribute("RewardPoints").ToString());
clsProductDetails.SequenceNo = Int64.Parse(xmlReader.GetAttribute("SequenceNo").ToString());
clsProductDetails.IsCreditChargeExcluded = bool.Parse(xmlReader.GetAttribute("IsCreditChargeExcluded").ToString());
clsProductDetails.LastModified = DateTime.TryParse(xmlReader.GetAttribute("LastModified").ToString(), out clsProductDetails.LastModified) ? clsProductDetails.LastModified : DateTime.Now;
clsProductDetails.MinThreshold = decimal.Parse(xmlReader.GetAttribute("MinThreshold").ToString());
clsProductDetails.MaxThreshold = decimal.Parse(xmlReader.GetAttribute("MaxThreshold").ToString());
clsProductDetails.SupplierID = Constants.C_RETAILPLUS_SUPPLIERID; // 20Aug2015 : This is only for insert, do not overwrite during update sync
return clsProductDetails;
}
protected void Page_Load(object sender, System.EventArgs e)
{
const string defaultHeading = "Master Files";
string stHeading = defaultHeading;
const string defaultTitle = "Product Variation Combinations";
SiteTitle.Title = defaultTitle;
const SearchCategoryID defaultSearchIndex = SearchCategoryID.ProductVariationsMatrix;
SearchCategoryID SearchIndex = defaultSearchIndex;
HorizontalNavBar.PageNavigatorid = HorizontalNavID.MasterFiles;
if (Request.QueryString["task"]!=null)
{
Products clsProduct = new Products();
ProductDetails clsDetails = new ProductDetails();
long prodid = Convert.ToInt64(Common.Decrypt(Request.QueryString["prodid"].ToString(), Session.SessionID));
clsDetails = clsProduct.Details(prodid);
clsProduct.CommitAndDispose();
string productCode = " for : " + clsDetails.ProductCode;
string task = Common.Decrypt(Request.QueryString["task"].ToString(),Session.SessionID);
switch(task)
{
case "add":
stHeading = "Create New Product Variation Combination";
SearchIndex = SearchCategoryID.ProductVariationsMatrix;
ctrlInsert.Visible = true;
break;
case "edit":
stHeading = "Modify Product Variation Combination";
SearchIndex = SearchCategoryID.ProductVariationsMatrix;
ctrlUpdate.Visible = true;
break;
case "det":
stHeading = "Product Variation Details";
SearchIndex = SearchCategoryID.ProductVariationsMatrix;
ctrlDetails.Visible = true;
break;
case "list":
stHeading = "Product Variation Combinations List ";
SearchIndex = SearchCategoryID.ProductVariationsMatrix;
ctrlList.Visible = true;
break;
default:
break;
}
LargeHeading.Text = stHeading + productCode;
RightBodySectionSearch.SearchIDSelectedItem = SearchIndex;
}
}
protected void cmdProductCode_Click(object sender, System.Web.UI.ImageClickEventArgs e)
{
DataClass clsDataClass = new DataClass();
Data.Products clsProduct = new Data.Products();
cboProductCode.DataTextField = "ProductCode";
cboProductCode.DataValueField = "ProductID";
ProductDetails clsSearchKeys = new ProductDetails();
clsSearchKeys.ProductCode = txtProductCode.Text;
cboProductCode.DataSource = clsProduct.ListAsDataTable(clsSearchKeys: clsSearchKeys, limit: 100).DefaultView;
cboProductCode.DataBind();
clsProduct.CommitAndDispose();
if (cboProductCode.Items.Count == 0)
cboProductCode.Items.Add(new ListItem("No product", "0"));
cboProductCode.SelectedIndex = 0;
cboProductCode_SelectedIndexChanged(null, null);
}
private Int64 SaveRecord()
{
ProductDetails clsDetails = new ProductDetails();
clsDetails.ProductCode = txtProductCode.Text;
clsDetails.BarCode = txtBarcode.Text;
clsDetails.BarCode2 = txtBarcode2.Text;
clsDetails.BarCode3 = txtBarcode3.Text;
clsDetails.ProductDesc = txtProductDesc.Text;
clsDetails.ProductGroupID = Convert.ToInt64(cboProductGroup.SelectedItem.Value);
clsDetails.ProductSubGroupID = Convert.ToInt64(cboProductSubGroup.SelectedItem.Value);
clsDetails.BaseUnitID = Convert.ToInt32(cboProductUnit.SelectedItem.Value);
clsDetails.Price = Convert.ToDecimal(txtProductPrice.Text);
clsDetails.WSPrice = Convert.ToDecimal(txtWSPrice.Text);
clsDetails.PurchasePrice = Convert.ToDecimal(txtPurchasePrice.Text);
clsDetails.PercentageCommision = Convert.ToDecimal(txtPercentageCommision.Text);
clsDetails.IncludeInSubtotalDiscount = chkIncludeInSubtotalDiscount.Checked;
clsDetails.VAT = Convert.ToDecimal(txtVAT.Text);
clsDetails.EVAT = Convert.ToDecimal(txtEVAT.Text);
clsDetails.LocalTax = Convert.ToDecimal(txtLocalTax.Text);
clsDetails.Quantity = Convert.ToDecimal(txtQuantity.Text);
clsDetails.MinThreshold = Convert.ToDecimal(txtMinThreshold.Text);
clsDetails.MaxThreshold = Convert.ToDecimal(txtMaxThreshold.Text);
clsDetails.SupplierID = Convert.ToInt64(cboSupplier.SelectedItem.Value);
clsDetails.IsItemSold = Convert.ToBoolean(chkIsItemSold.Checked);
clsDetails.WillPrintProductComposition = Convert.ToBoolean(chkWillPrintProductComposition.Checked);
Products clsProduct = new Products();
Int64 id = clsProduct.Insert(clsDetails);
clsDetails.ProductID = id;
long lngUID = long.Parse(Session["UID"].ToString());
InvAdjustmentDetails clsInvAdjustmentDetails = new InvAdjustmentDetails();
clsInvAdjustmentDetails.UID = lngUID;
clsInvAdjustmentDetails.InvAdjustmentDate = DateTime.Now;
clsInvAdjustmentDetails.ProductID = id;
clsInvAdjustmentDetails.ProductCode = clsDetails.ProductCode;
clsInvAdjustmentDetails.Description = clsDetails.ProductDesc;
clsInvAdjustmentDetails.VariationMatrixID = 0;
clsInvAdjustmentDetails.MatrixDescription = null;
clsInvAdjustmentDetails.UnitID = clsDetails.BaseUnitID;
clsInvAdjustmentDetails.UnitCode = cboProductUnit.SelectedItem.Text;
clsInvAdjustmentDetails.QuantityBefore = 0;
clsInvAdjustmentDetails.QuantityNow = clsDetails.Quantity;
clsInvAdjustmentDetails.MinThresholdBefore = 0;
clsInvAdjustmentDetails.MinThresholdNow = clsDetails.MinThreshold;
clsInvAdjustmentDetails.MaxThresholdBefore = 0;
clsInvAdjustmentDetails.MaxThresholdNow = clsDetails.MaxThreshold;
clsInvAdjustmentDetails.Remarks = "newly added. beginning balance.";
InvAdjustment clsInvAdjustment = new InvAdjustment(clsProduct.Connection, clsProduct.Transaction);
clsInvAdjustment.Insert(clsInvAdjustmentDetails);
if (chkVariations.Checked == true)
{
clsProduct.InheritSubGroupVariations(clsDetails.ProductSubGroupID, clsDetails.ProductID);
}
if (chkVariationsMatrix.Checked == true)
{
if (chkVariations.Checked == false)
{
clsProduct.InheritSubGroupVariations(clsDetails.ProductSubGroupID, clsDetails.ProductID);
}
clsProduct.InheritSubGroupVariationsMatrix(clsDetails.ProductSubGroupID, clsDetails.ProductID, clsDetails);
}
if (chkUnitMatrix.Checked == true)
{
clsProduct.InheritSubGroupUnitMatrix(clsDetails.ProductSubGroupID, clsDetails.ProductID);
}
// Aug 26, 2011 : Lemu
// Update Required Inventory Days (RID)
clsDetails.RID = Convert.ToInt64(txtRID.Text);
clsProduct.UpdateRID(clsDetails.ProductID, clsDetails.RID);
clsProduct.CommitAndDispose();
return 0;
}
private void SaveRecord()
{
ProductDetails clsDetails = new ProductDetails();
clsDetails.ProductID = Convert.ToInt64(lblProductID.Text);
clsDetails.ProductCode = txtProductCode.Text;
clsDetails.BarCode = txtBarcode.Text;
clsDetails.BarCode2 = txtBarcode2.Text;
clsDetails.BarCode3 = txtBarcode3.Text;
clsDetails.ProductDesc = txtProductDesc.Text;
clsDetails.ProductGroupID = Convert.ToInt64(cboProductGroup.SelectedItem.Value);
clsDetails.ProductSubGroupID = Convert.ToInt64(cboProductSubGroup.SelectedItem.Value);
clsDetails.BaseUnitID = Convert.ToInt32(cboProductUnit.SelectedItem.Value);
clsDetails.Price = Convert.ToDecimal(txtProductPrice.Text);
clsDetails.Price1 = Convert.ToDecimal(txtPrice1.Text);
clsDetails.Price2 = Convert.ToDecimal(txtPrice2.Text);
clsDetails.Price3 = Convert.ToDecimal(txtPrice3.Text);
clsDetails.Price4 = Convert.ToDecimal(txtPrice4.Text);
clsDetails.Price5 = Convert.ToDecimal(txtPrice5.Text);
clsDetails.WSPrice = Convert.ToDecimal(txtWSPrice.Text);
clsDetails.PurchasePrice = Convert.ToDecimal(txtPurchasePrice.Text);
clsDetails.PercentageCommision = Convert.ToDecimal(txtPercentageCommision.Text);
clsDetails.IncludeInSubtotalDiscount = chkIncludeInSubtotalDiscount.Checked;
clsDetails.Quantity = Convert.ToDecimal(txtQuantity.Text);
clsDetails.VAT = Convert.ToDecimal(txtVAT.Text);
clsDetails.EVAT = Convert.ToDecimal(txtEVAT.Text);
clsDetails.LocalTax = Convert.ToDecimal(txtLocalTax.Text);
clsDetails.MinThreshold = Convert.ToDecimal(txtMinThreshold.Text);
clsDetails.MaxThreshold = Convert.ToDecimal(txtMaxThreshold.Text);
clsDetails.SupplierID = Convert.ToInt64(cboSupplier.SelectedItem.Value);
clsDetails.IsItemSold = Convert.ToBoolean(chkIsItemSold.Checked);
clsDetails.WillPrintProductComposition = Convert.ToBoolean(chkWillPrintProductComposition.Checked);
clsDetails.UpdatedBy = Convert.ToInt64(Session["UID"].ToString());
clsDetails.UpdatedOn = DateTime.Now;
clsDetails.RID = Convert.ToInt64(txtRID.Text);
clsDetails.SequenceNo = Convert.ToInt64(txtSequenceNo.Text);
Products clsProduct = new Products();
clsProduct.Update(clsDetails);
// Aug 26, 2011 : Lemu
// Update Requried Inventory Days (RID)
clsProduct.UpdateRID(clsDetails.ProductID, clsDetails.RID);
clsProduct.CommitAndDispose();
}
private void AddItemToInventory(long pvtDebitMemoID)
{
DebitMemoDetails clsDebitMemoDetails = Details(pvtDebitMemoID);
ERPConfig clsERPConfig = new ERPConfig(base.Connection, base.Transaction);
ERPConfigDetails clsERPConfigDetails = clsERPConfig.Details();
DebitMemoItems clsDebitMemoItems = new DebitMemoItems(base.Connection, base.Transaction);
ProductUnit clsProductUnit = new ProductUnit(base.Connection, base.Transaction);
ProductDetails clsProductDetails = new ProductDetails();
Products clsProduct = new Products(base.Connection, base.Transaction);
ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix(base.Connection, base.Transaction);
ProductPackage clsProductPackage = new ProductPackage(base.Connection, base.Transaction);
MatrixPackage clsMatrixPackage = new MatrixPackage(base.Connection, base.Transaction);
Inventory clsInventory = new Inventory(base.Connection, base.Transaction);
ProductPackagePriceHistoryDetails clsProductPackagePriceHistoryDetails;
ProductPackagePriceHistory clsProductPackagePriceHistory = new ProductPackagePriceHistory(base.Connection, base.Transaction);
System.Data.DataTable dt = clsDebitMemoItems.ListAsDataTable(pvtDebitMemoID, SortField: "DebitMemoItemID", SortOrder: SortOption.Ascending);
foreach (System.Data.DataRow dr in dt.Rows)
{
long lngProductID = Convert.ToInt64(dr["ProductID"]);
int intProductUnitID = Convert.ToInt16(dr["ProductUnitID"]);
decimal decItemQuantity = Convert.ToDecimal(dr["Quantity"]);
decimal decQuantity = clsProductUnit.GetBaseUnitValue(lngProductID, intProductUnitID, decItemQuantity);
long lngVariationMatrixID = Convert.ToInt64(dr["VariationMatrixID"]);
string strMatrixDescription = dr["MatrixDescription"].ToString();
string strProductCode = dr["ProductCode"].ToString();
string strProductUnitCode = dr["ProductUnitCode"].ToString();
decimal decNewUnitCost = Convert.ToDecimal(dr["UnitCost"]);
decimal decAmount = Convert.ToDecimal(dr["Amount"]);
//decimal decSellingPrice = Convert.ToDecimal(dr["SellingPrice"]);
decimal decVAT = Convert.ToDecimal(dr["VAT"]);
//decimal decEVAT = Convert.ToDecimal(dr["EVAT"]);
//decimal decLocalTax = Convert.ToDecimal(dr["LocalTax"]);
clsProductDetails = clsProduct.Details1(clsDebitMemoDetails.BranchID, lngProductID);
/*******************************************
* Add in the Purchase Price History based on Debit Memo
* ****************************************/
// Update ProductPackagePriceHistory first to get the history
clsProductPackagePriceHistoryDetails = new ProductPackagePriceHistoryDetails();
clsProductPackagePriceHistoryDetails.UID = clsDebitMemoDetails.PurchaserID;
clsProductPackagePriceHistoryDetails.PackageID = clsProductPackage.GetPackageID(lngProductID, intProductUnitID);
clsProductPackagePriceHistoryDetails.ChangeDate = DateTime.Now;
clsProductPackagePriceHistoryDetails.PurchasePrice = decNewUnitCost * (decItemQuantity / decQuantity);
clsProductPackagePriceHistoryDetails.Price = -1;
clsProductPackagePriceHistoryDetails.VAT = -1;
clsProductPackagePriceHistoryDetails.EVAT = -1;
clsProductPackagePriceHistoryDetails.LocalTax = -1;
clsProductPackagePriceHistoryDetails.Remarks = "Based on DebitMemo #: " + clsDebitMemoDetails.MemoNo;
clsProductPackagePriceHistory.Insert(clsProductPackagePriceHistoryDetails);
/*******************************************
* Subtract from Inventory : Remove this since this is a Debit Memo
* ****************************************/
//clsProduct.SubtractQuantity(lngProductID, decQuantity);
//if (lngVariationMatrixID != 0)
//{
// clsProductVariationsMatrix.SubtractQuantity(lngVariationMatrixID, decQuantity);
//}
/*******************************************
* Update Purchasing Information
* ****************************************/
int iBaseUnitID = clsProduct.get_BaseUnitID(lngProductID);
if (iBaseUnitID != intProductUnitID)
{
clsProduct.UpdatePurchasing(lngProductID, lngVariationMatrixID, clsDebitMemoDetails.SupplierID, iBaseUnitID, (decItemQuantity * decNewUnitCost) / decQuantity);
}
clsProduct.UpdatePurchasing(lngProductID, lngVariationMatrixID, clsDebitMemoDetails.SupplierID, intProductUnitID, decNewUnitCost);
/*******************************************
* Add to Inventory Analysis
* ****************************************/
InventoryDetails clsInventoryDetails = new InventoryDetails();
clsInventoryDetails.PostingDateFrom = clsERPConfigDetails.PostingDateFrom;
clsInventoryDetails.PostingDateTo = clsERPConfigDetails.PostingDateTo;
clsInventoryDetails.PostingDate = clsDebitMemoDetails.PostingDate;
clsInventoryDetails.ReferenceNo = clsDebitMemoDetails.MemoNo;
clsInventoryDetails.ContactID = clsDebitMemoDetails.SupplierID;
clsInventoryDetails.ContactCode = clsDebitMemoDetails.SupplierCode;
clsInventoryDetails.ProductID = lngProductID;
clsInventoryDetails.ProductCode = strProductCode;
clsInventoryDetails.VariationMatrixID = lngVariationMatrixID;
clsInventoryDetails.MatrixDescription = strMatrixDescription;
clsInventoryDetails.PDebitQuantity = decQuantity;
clsInventoryDetails.PDebitCost = decAmount - decVAT;
clsInventoryDetails.PDebitVAT = decAmount;
clsInventory.Insert(clsInventoryDetails);
}
}
protected void imgProductQuickAdd_Click(object sender, System.Web.UI.ImageClickEventArgs e)
{
try
{
if (!string.IsNullOrEmpty(txtProductCode.Text))
{
ProductDetails clsDetails = new ProductDetails();
clsDetails.ProductCode = txtProductCode.Text;
clsDetails.BarCode = txtProductCode.Text;
clsDetails.ProductDesc = txtProductCode.Text;
clsDetails.ProductGroupID = ProductGroup.DEFAULT_GROUP_ID;
clsDetails.ProductSubGroupID = ProductSubGroup.DEFAULT_SUB_GROUP_ID;
clsDetails.BaseUnitID = Data.Unit.DEFAULT_UNIT_ID;
clsDetails.Price = 0;
clsDetails.PurchasePrice = 0;
clsDetails.IncludeInSubtotalDiscount = true;
clsDetails.VAT = Constants.DEFAULTS_VAT;
clsDetails.EVAT = 0;
clsDetails.LocalTax = 0;
clsDetails.Quantity = 0;
clsDetails.MinThreshold = 0;
clsDetails.MaxThreshold = 0;
clsDetails.SupplierID = Contacts.DEFAULT_SUPPLIER_ID;
clsDetails.IsItemSold = true;
clsDetails.WillPrintProductComposition = false;
Products clsProduct = new Products();
long id = clsProduct.Insert(clsDetails);
clsDetails.ProductID = id;
long lngUID = long.Parse(Session["UID"].ToString());
InvAdjustmentDetails clsInvAdjustmentDetails = new InvAdjustmentDetails();
clsInvAdjustmentDetails.UID = lngUID;
clsInvAdjustmentDetails.InvAdjustmentDate = DateTime.Now;
clsInvAdjustmentDetails.ProductID = id;
clsInvAdjustmentDetails.ProductCode = clsDetails.ProductCode;
clsInvAdjustmentDetails.Description = clsDetails.ProductDesc;
clsInvAdjustmentDetails.VariationMatrixID = 0;
clsInvAdjustmentDetails.MatrixDescription = null;
clsInvAdjustmentDetails.UnitID = clsDetails.BaseUnitID;
clsInvAdjustmentDetails.UnitCode = cboProductUnit.SelectedItem.Text;
clsInvAdjustmentDetails.QuantityBefore = 0;
clsInvAdjustmentDetails.QuantityNow = clsDetails.Quantity;
clsInvAdjustmentDetails.MinThresholdBefore = 0;
clsInvAdjustmentDetails.MinThresholdNow = clsDetails.MinThreshold;
clsInvAdjustmentDetails.MaxThresholdBefore = 0;
clsInvAdjustmentDetails.MaxThresholdNow = clsDetails.MaxThreshold;
clsInvAdjustmentDetails.Remarks = "newly added. beginning balance.";
InvAdjustment clsInvAdjustment = new InvAdjustment(clsProduct.Connection, clsProduct.Transaction);
clsInvAdjustment.Insert(clsInvAdjustmentDetails);
clsProduct.InheritSubGroupVariations(clsDetails.ProductSubGroupID, clsDetails.ProductID);
clsProduct.CommitAndDispose();
cmdProductCode_Click(null, null);
}
}
catch { }
}
private void ExportToFile()
{
DataClass clsDataClass = new DataClass();
PO clsPO = new PO();
PODetails clsPODetails = clsPO.Details(long.Parse(lblPOID.Text));
POItem clsPOItem = new POItem(clsPO.Connection, clsPO.Transaction);
DataTable dtaPOItems = clsPOItem.ListAsDataTable(clsPODetails.POID, null, SortOption.Ascending);
Branch clsBranch = new Branch(clsPO.Connection, clsPO.Transaction);
BranchDetails clsBranchDetails;
Contacts clsContact = new Contacts(clsPO.Connection, clsPO.Transaction);
ContactDetails clsContactDetails;
Products clsProduct = new Products(clsPO.Connection, clsPO.Transaction);
ProductDetails clsProductDetails;
ProductVariations clsProductVariation = new ProductVariations(clsPO.Connection, clsPO.Transaction);
DataTable dtaProductVariation;
ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix(clsPO.Connection, clsPO.Transaction);
DataTable dtaProductVariationsMatrix;
string xmlFileName = Server.MapPath(@"\RetailPlus\temp\" + lblBranchCode.Text.Replace(" ", "").Trim() + "_" + clsPODetails.PONo + "_" + clsPODetails.PODate.ToString("yyyyMMddHHmmssffff") + ".xml");
XmlTextWriter writer = new XmlTextWriter(xmlFileName, System.Text.Encoding.UTF8);
writer.Formatting = Formatting.Indented;
writer.WriteStartDocument();
writer.WriteComment("This file represents the Purchase Order Details of PO No: '" + clsPODetails.PONo + "' for " + lblBranchCode.Text + " branch.");
writer.WriteComment("Save this in your local file. Goto 'File', click 'Save As', select the location in your local directory, click 'Save'.");
writer.WriteStartElement("PODetails");
writer.WriteAttributeString("POID", XmlConvert.ToString(clsPODetails.POID));
writer.WriteAttributeString("PONo", clsPODetails.PONo);
writer.WriteAttributeString("PODate", clsPODetails.PODate.ToString("MM/dd/yyyy HH:mm:ss"));
/******Supplier information******/
clsContactDetails = clsContact.Details(clsPODetails.SupplierID);
writer.WriteAttributeString("SupplierID", XmlConvert.ToString(clsContactDetails.ContactID));
writer.WriteAttributeString("SupplierCode", clsContactDetails.ContactCode);
writer.WriteAttributeString("SupplierName", clsContactDetails.ContactName);
writer.WriteAttributeString("SupplierContact", clsContactDetails.BusinessName);
writer.WriteAttributeString("SupplierAddress", clsPODetails.SupplierAddress);
writer.WriteAttributeString("SupplierTelephoneNo", clsPODetails.SupplierTelephoneNo);
writer.WriteAttributeString("SupplierModeOfTerms", XmlConvert.ToString(clsPODetails.SupplierModeOfTerms));
writer.WriteAttributeString("SupplierTerms", XmlConvert.ToString(clsPODetails.SupplierTerms));
writer.WriteAttributeString("SupplierContactGroupName", clsContactDetails.ContactGroupName);
/******End Of Supplier Information******/
writer.WriteAttributeString("RequiredDeliveryDate", clsPODetails.RequiredDeliveryDate.ToString("MM/dd/yyyy HH:mm:ss"));
/******Branch & Purchaser Information******/
clsBranchDetails = clsBranch.Details(short.Parse(clsPODetails.BranchID.ToString()));
writer.WriteAttributeString("BranchID", XmlConvert.ToString(clsPODetails.BranchID));
writer.WriteAttributeString("BranchCode", clsPODetails.BranchCode);
writer.WriteAttributeString("BranchName", clsPODetails.BranchName);
writer.WriteAttributeString("BranchAddress", clsPODetails.BranchAddress);
writer.WriteAttributeString("BranchDBIP", clsBranchDetails.DBIP);
writer.WriteAttributeString("BranchDBPort", clsBranchDetails.DBPort);
writer.WriteAttributeString("BranchRemarks", clsBranchDetails.Remarks);
writer.WriteAttributeString("PurchaserID", clsPODetails.PurchaserID.ToString());
writer.WriteAttributeString("PurchaserName", clsPODetails.PurchaserName);
/******End Of Branch & Purchaser Information******/
/******Amount Information******/
writer.WriteAttributeString("SubTotal", XmlConvert.ToString(clsPODetails.SubTotal));
writer.WriteAttributeString("Discount", XmlConvert.ToString(clsPODetails.Discount));
writer.WriteAttributeString("DiscountApplied", XmlConvert.ToString(clsPODetails.DiscountApplied));
writer.WriteAttributeString("DiscountType", clsPODetails.DiscountType.ToString("d"));
writer.WriteAttributeString("VAT", XmlConvert.ToString(clsPODetails.VAT));
writer.WriteAttributeString("VatableAmount", XmlConvert.ToString(clsPODetails.VatableAmount));
writer.WriteAttributeString("EVAT", XmlConvert.ToString(clsPODetails.EVAT));
writer.WriteAttributeString("EVatableAmount", XmlConvert.ToString(clsPODetails.EVatableAmount));
writer.WriteAttributeString("LocalTax", XmlConvert.ToString(clsPODetails.LocalTax));
writer.WriteAttributeString("Freight", XmlConvert.ToString(clsPODetails.Freight));
writer.WriteAttributeString("Deposit", XmlConvert.ToString(clsPODetails.Deposit));
writer.WriteAttributeString("UnpaidAmount", XmlConvert.ToString(clsPODetails.UnpaidAmount));
writer.WriteAttributeString("PaidAmount", XmlConvert.ToString(clsPODetails.PaidAmount));
writer.WriteAttributeString("TotalItemDiscount", XmlConvert.ToString(clsPODetails.TotalItemDiscount));
writer.WriteAttributeString("Status", clsPODetails.Status.ToString("d"));
writer.WriteAttributeString("Remarks", clsPODetails.Remarks);
writer.WriteAttributeString("SupplierDRNo", clsPODetails.SupplierDRNo);
writer.WriteAttributeString("DeliveryDate", clsPODetails.DeliveryDate.ToString("MM/dd/yyyy HH:mm:ss"));
writer.WriteAttributeString("CancelledDate", clsPODetails.CancelledDate.ToString("MM/dd/yyyy HH:mm:ss"));
writer.WriteAttributeString("CancelledRemarks", clsPODetails.CancelledRemarks);
writer.WriteAttributeString("CancelledByID", XmlConvert.ToString(clsPODetails.CancelledByID));
/******End Of Branch Information******/
foreach (DataRow row in dtaPOItems.Rows)
{
clsProductDetails = new ProductDetails();
clsProductDetails = clsProduct.Details(Convert.ToInt64(row["ProductID"].ToString()));
writer.WriteStartElement("POItem");
writer.WriteAttributeString("POItemID", row["POItemID"].ToString());
writer.WriteAttributeString("POID", row["POID"].ToString());
writer.WriteAttributeString("ProductID", row["ProductID"].ToString());
/*****Product Information*****/
writer.WriteAttributeString("ProductCode", clsProductDetails.ProductCode);
writer.WriteAttributeString("BarCode", clsProductDetails.BarCode);
writer.WriteAttributeString("ProductDesc", clsProductDetails.ProductDesc);
writer.WriteAttributeString("MatrixDescription", row["MatrixDescription"].ToString());
writer.WriteAttributeString("ProductSubGroupID", clsProductDetails.ProductSubGroupID.ToString());
writer.WriteAttributeString("ProductSubGroupCode", clsProductDetails.ProductSubGroupCode);
writer.WriteAttributeString("ProductSubGroupName", clsProductDetails.ProductSubGroupName);
writer.WriteAttributeString("ProductGroupID", clsProductDetails.ProductGroupID.ToString());
writer.WriteAttributeString("ProductGroupCode", clsProductDetails.ProductGroupCode);
writer.WriteAttributeString("ProductGroupName", clsProductDetails.ProductGroupName);
writer.WriteAttributeString("BaseUnitID", clsProductDetails.BaseUnitID.ToString());
writer.WriteAttributeString("BaseUnitCode", clsProductDetails.BaseUnitCode);
writer.WriteAttributeString("BaseUnitName", clsProductDetails.BaseUnitName);
writer.WriteAttributeString("DateCreated", clsProductDetails.DateCreated.ToString("MM/dd/yy HH:mm:ss"));
writer.WriteAttributeString("Deleted", clsProductDetails.Deleted.ToString());
writer.WriteAttributeString("Price", clsProductDetails.Price.ToString());
writer.WriteAttributeString("PurchasePrice", clsProductDetails.PurchasePrice.ToString());
writer.WriteAttributeString("IncludeInSubtotalDiscount", clsProductDetails.IncludeInSubtotalDiscount.ToString());
writer.WriteAttributeString("VAT", clsProductDetails.VAT.ToString());
writer.WriteAttributeString("EVAT", clsProductDetails.EVAT.ToString());
writer.WriteAttributeString("LocalTax", clsProductDetails.LocalTax.ToString());
writer.WriteAttributeString("Quantity", clsProductDetails.Quantity.ToString());
writer.WriteAttributeString("MinThreshold", clsProductDetails.MinThreshold.ToString());
writer.WriteAttributeString("MaxThreshold", clsProductDetails.MaxThreshold.ToString());
writer.WriteAttributeString("ChartOfAccountIDPurchase", clsProductDetails.ChartOfAccountIDPurchase.ToString());
writer.WriteAttributeString("ChartOfAccountIDSold", clsProductDetails.ChartOfAccountIDSold.ToString());
writer.WriteAttributeString("ChartOfAccountIDInventory", clsProductDetails.ChartOfAccountIDInventory.ToString());
writer.WriteAttributeString("ChartOfAccountIDTaxPurchase", clsProductDetails.ChartOfAccountIDTaxPurchase.ToString());
writer.WriteAttributeString("ChartOfAccountIDTaxSold", clsProductDetails.ChartOfAccountIDTaxSold.ToString());
writer.WriteAttributeString("IsItemSold", clsProductDetails.IsItemSold.ToString());
writer.WriteAttributeString("WillPrintProductComposition", clsProductDetails.WillPrintProductComposition.ToString());
writer.WriteAttributeString("UpdatedBy", clsProductDetails.UpdatedBy.ToString());
writer.WriteAttributeString("UpdatedOn", clsProductDetails.UpdatedOn.ToString("MM/dd/yyyy HH:mm"));
writer.WriteAttributeString("PercentageCommision", clsProductDetails.PercentageCommision.ToString());
writer.WriteAttributeString("Active", clsProductDetails.Active.ToString());
/*****End Of Product Information*****/
writer.WriteAttributeString("ItemProductGroup", row["ProductGroup"].ToString());
writer.WriteAttributeString("ItemProductSubGroup", row["ProductSubGroup"].ToString());
writer.WriteAttributeString("ItemVariationMatrixID", row["VariationMatrixID"].ToString());
writer.WriteAttributeString("ItemBaseVariationDescription", row["MatrixDescription"].ToString());
writer.WriteAttributeString("ItemProductUnitID", row["ProductUnitID"].ToString());
writer.WriteAttributeString("ItemProductUnitCode", row["ProductUnitCode"].ToString());
writer.WriteAttributeString("ItemQuantity", row["Quantity"].ToString());
writer.WriteAttributeString("ItemUnitCost", row["UnitCost"].ToString());
writer.WriteAttributeString("ItemDiscount", row["Discount"].ToString());
writer.WriteAttributeString("ItemDiscountApplied", row["DiscountApplied"].ToString());
writer.WriteAttributeString("ItemDiscountType", row["DiscountType"].ToString());
writer.WriteAttributeString("ItemAmount", row["Amount"].ToString());
writer.WriteAttributeString("ItemVAT", row["VAT"].ToString());
writer.WriteAttributeString("ItemVatableAmount", row["VatableAmount"].ToString());
writer.WriteAttributeString("ItemEVAT", row["EVAT"].ToString());
writer.WriteAttributeString("ItemEVatableAmount", row["EVatableAmount"].ToString());
writer.WriteAttributeString("ItemLocalTax", row["LocalTax"].ToString());
writer.WriteAttributeString("ItemisVATInclusive", row["isVATInclusive"].ToString());
writer.WriteAttributeString("ItemPOItemStatus", row["POItemStatus"].ToString());
writer.WriteAttributeString("ItemIsVatable", row["IsVatable"].ToString());
writer.WriteAttributeString("ItemSellingPrice", row["SellingPrice"].ToString());
writer.WriteAttributeString("ItemSellingVAT", row["SellingVAT"].ToString());
writer.WriteAttributeString("ItemSellingEVAT", row["SellingEVAT"].ToString());
writer.WriteAttributeString("ItemSellingLocalTax", row["SellingLocalTax"].ToString());
writer.WriteAttributeString("ItemOldSellingPrice", row["OldSellingPrice"].ToString());
writer.WriteAttributeString("ItemRemarks", row["Remarks"].ToString());
dtaProductVariation = clsProductVariation.ListAsDataTable(clsProductDetails.ProductID, null, System.Data.SqlClient.SortOrder.Ascending);
foreach (DataRow rowVariation in dtaProductVariation.Rows)
{
writer.WriteStartElement("Variation", null);
writer.WriteAttributeString("VariationCode", rowVariation["VariationCode"].ToString());
writer.WriteAttributeString("VariationType", rowVariation["VariationType"].ToString());
writer.WriteEndElement();
}
dtaProductVariationsMatrix = clsProductVariationsMatrix.ProductVariationsMatrixListAsDataTable(long.Parse(row["VariationMatrixID"].ToString()), null, System.Data.SqlClient.SortOrder.Ascending);
foreach (DataRow rowVariationsMatrix in dtaProductVariationsMatrix.Rows)
{
writer.WriteStartElement("VariationMatrix", null);
writer.WriteAttributeString("MatriXID", rowVariationsMatrix["MatriXID"].ToString());
writer.WriteAttributeString("VariationID", rowVariationsMatrix["VariationID"].ToString());
writer.WriteAttributeString("Description", rowVariationsMatrix["Description"].ToString());
writer.WriteAttributeString("VariationCode", rowVariationsMatrix["VariationCode"].ToString());
writer.WriteAttributeString("VariationType", rowVariationsMatrix["VariationType"].ToString());
writer.WriteEndElement();
}
writer.WriteEndElement();
}
writer.WriteEndElement();
//Write the XML to file and close the writer
writer.Flush();
writer.Close();
clsPO.CommitAndDispose();
string stScript = "<Script>";
stScript += "window.open('/RetailPlus/temp/" + lblBranchCode.Text.Replace(" ", "").Trim() + "_" + clsPODetails.PONo + "_" + clsPODetails.PODate.ToString("yyyyMMddHHmmssffff") + ".xml')";
stScript += "</Script>";
Response.Write(stScript);
}
//public System.Data.DataTable ListAsDataTable(ProductColumns clsProductColumns, int BranchID, ProductListFilterType clsProductListFilterType,
// long SequenceNoStart, System.Data.SqlClient.SortOrder SequenceSortOrder,
// ProductColumns SearchColumns, string SearchKey, long SupplierID, long ProductGroupID, string ProductGroupName, long ProductSubGroupID, string ProductSubGroupName, Int32 limit, bool isQuantityGreaterThanZERO, bool CheckIItemisSold, string SortField, SortOption SortOrder, string GroupBy)
//{
// try
// {
// clsProductColumns.IncludeAllPackages = true;
// // include branchid in the selection if branchid is not zero
// if (BranchID != 0) clsProductColumns.BranchID = true;
// string SQL = SQLSelect(clsProductColumns) + "WHERE prd.deleted=0 ";
// if (SequenceNoStart != Constants.ZERO)
// {
// if (SequenceSortOrder == System.Data.SqlClient.SortOrder.Descending)
// SQL += "AND prd.SequenceNo < " + SequenceNoStart.ToString() + " ";
// else
// SQL += "AND prd.SequenceNo > " + SequenceNoStart.ToString() + " ";
// }
// if (BranchID != Constants.ZERO) SQL += "AND inv.BranchID = " + BranchID.ToString() + " ";
// if (CheckIItemisSold) SQL += "AND prd.IsItemSold = 1 ";
// if (clsProductListFilterType == ProductListFilterType.ShowActiveOnly) SQL += "AND prd.Active = 1 ";
// if (clsProductListFilterType == ProductListFilterType.ShowInactiveOnly) SQL += "AND prd.Active = 0 ";
// if (SearchKey != string.Empty)
// {
// string SQLSearch = string.Empty;
// if (SearchColumns.BarCode)
// { if (SQLSearch == string.Empty) SQLSearch += "prd.Barcode LIKE @SearchKey "; else SQLSearch += "OR prd.Barcode LIKE @SearchKey "; }
// if (SearchColumns.BarCode2)
// { if (SQLSearch == string.Empty) SQLSearch += "prd.Barcode2 LIKE @SearchKey "; else SQLSearch += "OR prd.Barcode2 LIKE @SearchKey "; }
// if (SearchColumns.BarCode3)
// { if (SQLSearch == string.Empty) SQLSearch += "prd.Barcode3 LIKE @SearchKey "; else SQLSearch += "OR prd.Barcode3 LIKE @SearchKey "; }
// if (SearchColumns.ProductCode)
// { if (SQLSearch == string.Empty) SQLSearch += "prd.ProductCode LIKE @SearchKey "; else SQLSearch += "OR prd.ProductCode LIKE @SearchKey "; }
// if (SearchColumns.ProductDesc)
// { if (SQLSearch == string.Empty) SQLSearch += "prd.ProductDesc LIKE @SearchKey "; else SQLSearch += "OR prd.ProductDesc LIKE @SearchKey "; }
// if (SQLSearch != string.Empty) SQL += "AND (" + SQLSearch + ") ";
// }
// if (SupplierID != Constants.ZERO)
// SQL += "AND (prd.SupplierID = " + SupplierID + " OR ProductID IN (SELECT DISTINCT(ProductID) FROM tblProductBaseVariationsMatrix WHERE SupplierID = " + SupplierID + ")) ";
// if (ProductSubGroupID != Constants.ZERO)
// { SQL += "AND prd.ProductSubGroupID = " + ProductSubGroupID + " "; }
// if (ProductSubGroupName != string.Empty && ProductSubGroupName != null)
// { SQL += "AND tblProductSubGroup.ProductSubGroupName = '" + ProductSubGroupName + "' "; }
// if (ProductGroupID != Constants.ZERO)
// { SQL += "AND tblProductSubGroup.ProductGroupID = " + ProductGroupID + " "; }
// if (ProductGroupName != string.Empty && ProductGroupName != null)
// { SQL += "AND tblProductGroup.ProductGroupName = '" + ProductGroupName + "' "; }
// if (isQuantityGreaterThanZERO)
// { SQL += "AND inv.Quantity > 0 "; }
// if (GroupBy != string.Empty || GroupBy != null)
// SQL += "GROUP BY " + GroupBy + " ";
// if (SortField == string.Empty) SortField = "ProductCode";
// SQL += "ORDER BY " + SortField + " ";
// if (SortOrder == SortOption.Ascending)
// SQL += "ASC ";
// else
// SQL += "DESC ";
// if (limit != 0)
// SQL += "LIMIT " + limit + " ";
// MySqlCommand cmd = new MySqlCommand();
// cmd.CommandType = System.Data.CommandType.Text;
// cmd.CommandText = SQL;
// MySqlParameter prmSearchKey = new MySqlParameter("@SearchKey",MySqlDbType.String);
// prmSearchKey.Value = SearchKey + "%";
// cmd.Parameters.Add(prmSearchKey);
// 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);
// return dt;
// }
// catch (Exception ex)
// {
// {
// }
// throw base.ThrowException(ex);
// }
//}
public System.Data.DataTable ListAsDataTable(ProductColumns clsProductColumns, ProductDetails clsSearchKey,
int BranchID = 0, ProductListFilterType clsProductListFilterType = ProductListFilterType.ShowActiveOnly,
Int64 SequenceNoStart = 0, System.Data.SqlClient.SortOrder SequenceSortOrder = System.Data.SqlClient.SortOrder.Ascending,
Int64 SupplierID = 0, Int64 ProductGroupID = 0, string ProductGroupName = "",
Int64 ProductSubGroupID = 0, string ProductSubGroupName = "",
bool CheckisQuantityGreaterThanZERO = false, bool isQuantityGreaterThanZERO = false,
bool CheckItemisSold = false, bool ItemisSold = true,
string SortField = "", SortOption SortOrder = SortOption.Ascending, Int32 limit = 0)
{
try
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQL = SQLSelect(clsProductColumns) + "WHERE prd.deleted=0 ";
if (SequenceNoStart != Constants.ZERO)
{
if (SequenceSortOrder == System.Data.SqlClient.SortOrder.Descending)
SQL += "AND prd.SequenceNo < " + SequenceNoStart.ToString() + " ";
else
SQL += "AND prd.SequenceNo > " + SequenceNoStart.ToString() + " ";
}
if (BranchID != Constants.ZERO) SQL += "AND tblProductInventory.BranchID = " + BranchID.ToString() + " ";
if (CheckItemisSold) SQL += "AND prd.IsItemSold = 1 ";
if (clsProductListFilterType == ProductListFilterType.ShowActiveOnly) SQL += "AND prd.Active = 1 ";
if (clsProductListFilterType == ProductListFilterType.ShowInactiveOnly) SQL += "AND prd.Active = 0 ";
if (SupplierID != Constants.ZERO)
SQL += "AND (prd.SupplierID = " + SupplierID + " OR ProductID IN (SELECT DISTINCT(ProductID) FROM tblProductBaseVariationsMatrix WHERE SupplierID = " + SupplierID + ")) ";
if (ProductSubGroupID != Constants.ZERO)
{ SQL += "AND prd.ProductSubGroupID = " + ProductSubGroupID + " "; }
if (ProductSubGroupName != string.Empty && ProductSubGroupName != null)
{ SQL += "AND sgrp.ProductSubGroupName = '" + ProductSubGroupName + "' "; }
if (ProductGroupID != Constants.ZERO)
{ SQL += "AND sgrp.ProductGroupID = " + ProductGroupID + " "; }
if (ProductGroupName != string.Empty && ProductGroupName != null)
{ SQL += "AND grp.ProductGroupName = '" + ProductGroupName + "' "; }
if (isQuantityGreaterThanZERO)
{ SQL += "AND tblProductInventory.Quantity > 0 "; }
//if (GroupBy != string.Empty || GroupBy != null)
// SQL += "GROUP BY " + GroupBy + " ";
if (SortField == string.Empty) SortField = "ProductCode";
SQL += "ORDER BY " + SortField + " ";
if (SortOrder == SortOption.Ascending)
SQL += "ASC ";
else
SQL += "DESC ";
if (limit != 0)
SQL += "LIMIT " + limit + " ";
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);
return dt;
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public System.Data.DataTable ListAsDataTable(Int32 BranchID = 0, ProductDetails clsSearchKeys = new ProductDetails(), ProductAddOnFilters ProductAddOnFilters = new ProductAddOnFilters(), ProductListFilterType clsProductListFilterType = ProductListFilterType.ShowActiveAndInactive,
long SequenceNoStart = 0, System.Data.SqlClient.SortOrder SequenceSortOrder = System.Data.SqlClient.SortOrder.Ascending, Int32 limit = 0, bool isQuantityGreaterThanZERO = false, string SortField = "ProductCode", SortOption SortOrder = SortOption.Ascending)
{
try
{
System.Data.DataTable dt = ListAsDataTable(BranchID, clsSearchKeys.BarCode, clsSearchKeys.ProductCode, clsSearchKeys.SupplierID, clsProductListFilterType,
isQuantityGreaterThanZERO, ProductAddOnFilters, limit, SortField, SortOrder);
return dt;
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public ProductDetails[] List(int BranchID = 0)
{
try
{
System.Collections.ArrayList items = new System.Collections.ArrayList();
System.Data.DataTable dtProductIDs = ProductIDAsDataTable();
foreach (System.Data.DataRow drProductID in dtProductIDs.Rows)
{
items.Add(Details1(BranchID, long.Parse(drProductID["ProductID"].ToString())));
}
ProductDetails[] arrProductDetails = new ProductDetails[0];
if (items != null)
{
arrProductDetails = new ProductDetails[items.Count];
items.CopyTo(arrProductDetails);
}
return arrProductDetails;
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
private ProductDetails SetDetails(System.Data.DataTable dt)
{
try
{
ProductDetails Details = new ProductDetails();
Details.ProductID = 0;
foreach(System.Data.DataRow dr in dt.Rows)
{
Details.ProductID = Int64.Parse(dr["ProductID"].ToString());
Details.ProductCode = "" + dr["ProductCode"].ToString();
Details.BarCode = "" + dr["BarCode"].ToString();
Details.BarCode1 = "" + dr["BarCode1"].ToString();
Details.BarCode2 = "" + dr["BarCode2"].ToString();
Details.BarCode3 = "" + dr["BarCode3"].ToString();
Details.ProductDesc = "" + dr["ProductDesc"].ToString();
Details.OrderSlipPrinter1 = bool.Parse(dr["OrderSlipPrinter1"].ToString());
Details.OrderSlipPrinter2 = bool.Parse(dr["OrderSlipPrinter2"].ToString());
Details.OrderSlipPrinter3 = bool.Parse(dr["OrderSlipPrinter3"].ToString());
Details.OrderSlipPrinter4 = bool.Parse(dr["OrderSlipPrinter4"].ToString());
Details.OrderSlipPrinter5 = bool.Parse(dr["OrderSlipPrinter5"].ToString());
Details.ProductGroupID = Int64.Parse(dr["ProductGroupID"].ToString());
Details.ProductGroupCode = "" + dr["ProductGroupCode"].ToString();
Details.ProductGroupName = "" + dr["ProductGroupName"].ToString();
Details.ProductSubGroupID = Int64.Parse(dr["ProductSubGroupID"].ToString());
Details.ProductSubGroupCode = dr["ProductSubGroupCode"].ToString();
Details.ProductSubGroupName = dr["ProductSubGroupName"].ToString();
Details.BaseUnitID = Int32.Parse(dr["BaseUnitID"].ToString());
Details.BaseUnitCode = dr["UnitCode"].ToString();
Details.BaseUnitName = dr["UnitName"].ToString();
Details.DateCreated = DateTime.Parse(dr["DateCreated"].ToString());
Details.Deleted = Boolean.Parse(dr["Deleted"].ToString());
Details.Active = Boolean.Parse(dr["Active"].ToString());
Details.Price = Decimal.Parse(dr["Price"].ToString());
Details.Price1 = Decimal.Parse(dr["Price1"].ToString());
Details.Price2 = Decimal.Parse(dr["Price2"].ToString());
Details.Price3 = Decimal.Parse(dr["Price3"].ToString());
Details.Price4 = Decimal.Parse(dr["Price4"].ToString());
Details.Price5 = Decimal.Parse(dr["Price5"].ToString());
Details.WSPrice = Decimal.Parse(dr["WSPrice"].ToString());
Details.PurchasePrice = Decimal.Parse(dr["PurchasePrice"].ToString());
Details.PercentageCommision = Decimal.Parse(dr["PercentageCommision"].ToString());
Details.IncludeInSubtotalDiscount = Boolean.Parse(dr["IncludeInSubtotalDiscount"].ToString());
Details.IsCreditChargeExcluded = Boolean.Parse(dr["IsCreditChargeExcluded"].ToString());
Details.VAT = Decimal.Parse(dr["VAT"].ToString());
Details.EVAT = Decimal.Parse(dr["EVAT"].ToString());
Details.LocalTax = Decimal.Parse(dr["LocalTax"].ToString());
Details.Quantity = Decimal.Parse(dr["Quantity"].ToString());
Details.ConvertedQuantity = dr["ConvertedQuantity"].ToString();
Details.ReservedQuantity = Decimal.Parse(dr["ReservedQuantity"].ToString());
Details.IsLock = Convert.ToBoolean(int.Parse(dr["IsLock"].ToString()));
Details.MinThreshold = Decimal.Parse(dr["MinThreshold"].ToString());
Details.MaxThreshold = Decimal.Parse(dr["MaxThreshold"].ToString());
Details.RID = Int64.Parse(dr["RID"].ToString());
Details.SequenceNo = Int64.Parse(dr["SequenceNo"].ToString());
Details.SupplierID = Int64.Parse(dr["SupplierID"].ToString());
Details.SupplierCode = dr["SupplierCode"].ToString();
Details.SupplierName = dr["SupplierName"].ToString();
/*** Added for Financial Information ***/
/*** January 12, 2009 ***/
Details.ChartOfAccountIDPurchase = Int32.Parse(dr["ChartOfAccountIDPurchase"].ToString());
Details.ChartOfAccountIDSold = Int32.Parse(dr["ChartOfAccountIDSold"].ToString());
Details.ChartOfAccountIDInventory = Int32.Parse(dr["ChartOfAccountIDInventory"].ToString());
Details.ChartOfAccountIDTaxPurchase = Int32.Parse(dr["ChartOfAccountIDTaxPurchase"].ToString());
Details.ChartOfAccountIDTaxSold = Int32.Parse(dr["ChartOfAccountIDTaxSold"].ToString());
Details.IsItemSold = Boolean.Parse(dr["IsItemSold"].ToString());
Details.WillPrintProductComposition = Boolean.Parse(dr["WillPrintProductComposition"].ToString());
/*** Inventory Tracking ***/
/*** May 10, 2010 ***/
Details.QuantityIN = Decimal.Parse(dr["QuantityIN"].ToString());
Details.QuantityOUT = Decimal.Parse(dr["QuantityOUT"].ToString());
Details.ActualQuantity = Decimal.Parse(dr["ActualQuantity"].ToString());
Details.RewardPoints = Decimal.Parse(dr["RewardPoints"].ToString());
Details.MatrixID = Int64.Parse(dr["MatrixID"].ToString());
Details.MatrixDescription = "" + dr["MatrixDescription"].ToString();
Details.PackageID = Int64.Parse(dr["PackageID"].ToString());
}
return Details;
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public Int32 Save(ProductDetails Details)
{
try
{
string SQL = "CALL procSaveProduct(@ProductID, @ProductCode, @ProductDesc, @ProductSubGroupID," +
"@BaseUnitID, @DateCreated, @Deleted, @IncludeInSubtotalDiscount, @IsCreditChargeExcluded, " +
"@MinThreshold, @MaxThreshold, @SupplierID, @ChartOfAccountIDPurchase," +
"@ChartOfAccountIDTaxPurchase, @ChartOfAccountIDSold, @ChartOfAccountIDTaxSold," +
"@ChartOfAccountIDInventory, @IsItemSold, @WillPrintProductComposition," +
"@VariationCount, @Active, @PercentageCommision, @RID, @RIDMinThreshold," +
"@RIDMaxThreshold, @RewardPoints, @SequenceNo, @ChartOfAccountIDTransferIn," +
"@ChartOfAccountIDTaxTransferIn, @ChartOfAccountIDTransferOut," +
"@ChartOfAccountIDTaxTransferOut, @ChartOfAccountIDInvAdjustment," +
"@ChartOfAccountIDTaxInvAdjustment, @CreatedOn, @LastModified);";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
cmd.Parameters.AddWithValue("ProductID", Details.ProductID);
cmd.Parameters.AddWithValue("ProductCode", Details.ProductCode);
cmd.Parameters.AddWithValue("ProductDesc", Details.ProductDesc);
cmd.Parameters.AddWithValue("ProductSubGroupID", Details.ProductSubGroupID);
cmd.Parameters.AddWithValue("BaseUnitID", Details.BaseUnitID);
cmd.Parameters.AddWithValue("DateCreated", Details.DateCreated.ToString("yyyy-MM-dd HH:mm:ss"));
cmd.Parameters.AddWithValue("Deleted", Details.Deleted);
cmd.Parameters.AddWithValue("IncludeInSubtotalDiscount", Details.IncludeInSubtotalDiscount);
cmd.Parameters.AddWithValue("IsCreditChargeExcluded", Details.IsCreditChargeExcluded);
cmd.Parameters.AddWithValue("MinThreshold", Details.MinThreshold);
cmd.Parameters.AddWithValue("MaxThreshold", Details.MaxThreshold);
cmd.Parameters.AddWithValue("SupplierID", Details.SupplierID);
cmd.Parameters.AddWithValue("ChartOfAccountIDPurchase", Details.ChartOfAccountIDPurchase);
cmd.Parameters.AddWithValue("ChartOfAccountIDTaxPurchase", Details.ChartOfAccountIDTaxPurchase);
cmd.Parameters.AddWithValue("ChartOfAccountIDSold", Details.ChartOfAccountIDSold);
cmd.Parameters.AddWithValue("ChartOfAccountIDTaxSold", Details.ChartOfAccountIDTaxSold);
cmd.Parameters.AddWithValue("ChartOfAccountIDInventory", Details.ChartOfAccountIDInventory);
cmd.Parameters.AddWithValue("IsItemSold", Details.IsItemSold);
cmd.Parameters.AddWithValue("WillPrintProductComposition", Details.WillPrintProductComposition);
cmd.Parameters.AddWithValue("VariationCount", Details.VariationCount);
cmd.Parameters.AddWithValue("Active", Details.Active);
cmd.Parameters.AddWithValue("PercentageCommision", Details.PercentageCommision);
cmd.Parameters.AddWithValue("RID", Details.RID);
cmd.Parameters.AddWithValue("RIDMinThreshold", Details.RIDMinThreshold);
cmd.Parameters.AddWithValue("RIDMaxThreshold", Details.RIDMaxThreshold);
cmd.Parameters.AddWithValue("RewardPoints", Details.RewardPoints);
cmd.Parameters.AddWithValue("SequenceNo", Details.SequenceNo);
cmd.Parameters.AddWithValue("ChartOfAccountIDTransferIn", Details.ProductChartOfAccountDetails.ChartOfAccountIDTransferIn);
cmd.Parameters.AddWithValue("ChartOfAccountIDTaxTransferIn", Details.ProductChartOfAccountDetails.ChartOfAccountIDTaxTransferIn);
cmd.Parameters.AddWithValue("ChartOfAccountIDTransferOut", Details.ProductChartOfAccountDetails.ChartOfAccountIDTransferOut);
cmd.Parameters.AddWithValue("ChartOfAccountIDTaxTransferOut", Details.ProductChartOfAccountDetails.ChartOfAccountIDTaxTransferOut);
cmd.Parameters.AddWithValue("ChartOfAccountIDInvAdjustment", Details.ProductChartOfAccountDetails.ChartOfAccountIDInvAdjustment);
cmd.Parameters.AddWithValue("ChartOfAccountIDTaxInvAdjustment", Details.ProductChartOfAccountDetails.ChartOfAccountIDTaxInvAdjustment);
cmd.Parameters.AddWithValue("CreatedOn", Details.CreatedOn == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.CreatedOn);
cmd.Parameters.AddWithValue("LastModified", Details.LastModified == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.LastModified);
return base.ExecuteNonQuery(cmd);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
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 SetDataSource(ReportDocument Report)
{
ReportDataset rptds = new ReportDataset();
//long lngProductGroupName = long.Parse(cboProductGroup.SelectedItem.Value);
//long lngSubGroupName = long.Parse(cboSubGroup.SelectedItem.Value);
string ProductGroupName = string.Empty;
if (cboProductGroup.SelectedItem.Value != Constants.ZERO_STRING) ProductGroupName = cboProductGroup.SelectedItem.Value;
string SubGroupName = string.Empty;
if (cboSubGroup.SelectedItem.Value != Constants.ZERO_STRING) SubGroupName = cboSubGroup.SelectedItem.Value;
string ReportType = cboReportType.SelectedItem.Text;
ProductColumns clsProductColumns = new ProductColumns();
#region clsProductColumns
clsProductColumns.ProductCode = true;
clsProductColumns.BarCode = true;
clsProductColumns.BarCode2 = true;
clsProductColumns.BarCode3 = true;
clsProductColumns.ProductDesc = true;
clsProductColumns.ProductSubGroupName = true;
clsProductColumns.BaseUnitName = true;
clsProductColumns.UnitName = true;
clsProductColumns.ProductGroupName = true;
clsProductColumns.DateCreated = true;
clsProductColumns.Price = true;
clsProductColumns.Quantity = true;
clsProductColumns.MinThreshold = true;
clsProductColumns.MaxThreshold = true;
clsProductColumns.PurchasePrice = true;
clsProductColumns.SupplierName = true;
clsProductColumns.QuantityIN = true;
clsProductColumns.QuantityOUT = true;
clsProductColumns.RIDMinThreshold = true;
clsProductColumns.RIDMaxThreshold = true;
clsProductColumns.RID = true;
//clsProductColumns.BranchActualQuantity = true;
//clsProductColumns.BranchQuantity = true;
//clsProductColumns.BranchQuantityIN = true;
//clsProductColumns.BranchQuantityOUT = true;
#endregion
ProductDetails clsSearchKey = new ProductDetails();
#region Search Key
clsSearchKey.BranchID = Convert.ToInt32(cboBranch.SelectedItem.Value);
clsSearchKey.SupplierID = Convert.ToInt32(cboContact.SelectedItem.Value);
clsSearchKey.ProductGroupID = Convert.ToInt64(cboProductGroup.SelectedItem.Value);
clsSearchKey.ProductSubGroupID = Convert.ToInt64(cboSubGroup.SelectedItem.Value);
clsSearchKey.ProductCode = txtProductCode.Text;
#endregion
Products clsProduct = new Products();
clsProduct.GetConnection();
ProductInventories clsProductInventories = new ProductInventories(clsProduct.Connection, clsProduct.Transaction);
DataTable dt;
string ProductIDs = null;
switch (cboReportType.SelectedValue)
{
case ReportTypes.ProductList:
#region Products List
dt = clsProductInventories.ListAsDataTable(Int32.Parse(cboBranch.SelectedItem.Value), SupplierID: long.Parse(cboContact.SelectedItem.Value), ProductGroupID: long.Parse(cboProductGroup.SelectedItem.Value), ProductSubGroupID: long.Parse(cboSubGroup.SelectedItem.Value), ProductCode: txtProductCode.Text);
clsProduct.CommitAndDispose();
foreach (System.Data.DataRow dr in dt.Rows)
{
DataRow drNew = rptds.Products.NewRow();
foreach (DataColumn dc in rptds.Products.Columns)
drNew[dc] = dr[dc.ColumnName];
rptds.Products.Rows.Add(drNew);
}
break;
#endregion
case ReportTypes.ProductPriceList:
#region Products Price List
dt = clsProductInventories.ListAsDataTable(int.Parse(cboBranch.SelectedItem.Value), SupplierID: long.Parse(cboContact.SelectedItem.Value), ProductGroupID: long.Parse(cboProductGroup.SelectedItem.Value), ProductSubGroupID: long.Parse(cboSubGroup.SelectedItem.Value), ProductCode: txtProductCode.Text);
clsProduct.CommitAndDispose();
foreach (DataRow dr in dt.Rows)
{
DataRow drNew = rptds.Products.NewRow();
foreach (DataColumn dc in rptds.Products.Columns)
drNew[dc] = dr[dc.ColumnName];
rptds.Products.Rows.Add(drNew);
ProductIDs += dr["ProductID"].ToString() + ",";
}
break;
#endregion
case ReportTypes.ProductListWithInvalidMatrix:
#region Products List With Invalid Unit Matrix
dt = clsProductInventories.ListAsDataTable(int.Parse(cboBranch.SelectedItem.Value), SupplierID: long.Parse(cboContact.SelectedItem.Value), ProductGroupID: long.Parse(cboProductGroup.SelectedItem.Value), ProductSubGroupID: long.Parse(cboSubGroup.SelectedItem.Value), ProductCode: txtProductCode.Text, ShowOnlyWithInvalidUnitMatrix: true);
clsProduct.CommitAndDispose();
foreach (System.Data.DataRow dr in dt.Rows)
{
DataRow drNew = rptds.Products.NewRow();
foreach (DataColumn dc in rptds.Products.Columns)
drNew[dc] = dr[dc.ColumnName];
rptds.Products.Rows.Add(drNew);
}
break;
#endregion
case ReportTypes.WeightedProductsForWeighingScale:
case ReportTypes.CountedProductsForWeighingScale:
#region Weighted and Counted Products For Weighing Scale
dt = clsProductInventories.ListAsDataTable(int.Parse(cboBranch.SelectedItem.Value), SupplierID: long.Parse(cboContact.SelectedItem.Value), ProductGroupID: long.Parse(cboProductGroup.SelectedItem.Value), ProductSubGroupID: long.Parse(cboSubGroup.SelectedItem.Value), ProductCode: txtProductCode.Text);
clsProduct.CommitAndDispose();
foreach (DataRow dr in dt.Rows)
{
if (dr[ProductColumnNames.BarCode].ToString() != null && dr[ProductColumnNames.BarCode].ToString() != string.Empty)
{
DataRow drNew = rptds.Products.NewRow();
foreach (DataColumn dc in rptds.Products.Columns)
drNew[dc] = dr[dc.ColumnName];
rptds.Products.Rows.Add(drNew);
ProductIDs += dr["ProductID"].ToString() + ",";
}
}
break;
#endregion
case ReportTypes.ProductsInDemoReport:
#region Products In Demo
DateTime StartTransactionDate = DateTime.TryParse(txtStartDate.Text + " " + txtStartTime.Text, out StartTransactionDate) ? StartTransactionDate : DateTime.MinValue;
DateTime EndTransactionDate = DateTime.TryParse(txtEndDate.Text + " " + txtEndTime.Text, out EndTransactionDate) ? EndTransactionDate : DateTime.MinValue;
SalesTransactionItems clsSalesTransactionItemsDemo = new SalesTransactionItems();
System.Data.DataTable dtDemo = clsSalesTransactionItemsDemo.ProductsInDemoReport(Int32.Parse(cboBranch.SelectedItem.Value), Int64.Parse(cboContact.SelectedItem.Value), cboProductGroup.SelectedItem.Text, cboSubGroup.SelectedItem.Text, txtProductCode.Text, "", StartTransactionDate, EndTransactionDate);
clsSalesTransactionItemsDemo.CommitAndDispose();
foreach (DataRow dr in dtDemo.Rows)
{
DataRow drNew = rptds.ProductsInDemo.NewRow();
foreach (DataColumn dc in rptds.ProductsInDemo.Columns)
drNew[dc] = dr[dc.ColumnName];
rptds.ProductsInDemo.Rows.Add(drNew);
}
break;
#endregion
default:
return;
}
Report.SetDataSource(rptds);
SetParameters(Report);
}
public void InheritSubGroupVariationsMatrix(Int64 ProductSubGroupID, Int64 ProductID, ProductDetails prodDetails)
{
try
{
ProductBaseVariationsMatrixDetails clsBaseDetails;
ProductSubGroupVariationsMatrix clsProductSubGroupVariationsMatrix = new ProductSubGroupVariationsMatrix(base.Connection, base.Transaction);
ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix(base.Connection, base.Transaction);
ProductVariationsMatrixDetails clsProductVariationsMatrixDetails = new ProductVariationsMatrixDetails();
MySqlDataReader clsProductSubGroupVariationsMatrixList;
MySqlDataReader clsProductSubGroupBaseVariationsMatrixList = clsProductSubGroupVariationsMatrix.BaseList(ProductSubGroupID,"MatrixID",SortOption.Ascending);
Int64 SubGroupBaseMatrixID = 0;
while (clsProductSubGroupBaseVariationsMatrixList.Read())
{
clsBaseDetails = new ProductBaseVariationsMatrixDetails();
clsBaseDetails.ProductID = ProductID;
clsBaseDetails.Description = "" + clsProductSubGroupBaseVariationsMatrixList["Description"].ToString();
clsBaseDetails.UnitID = Convert.ToInt32(clsProductSubGroupBaseVariationsMatrixList["UnitID"]);
clsBaseDetails.Price = Convert.ToDecimal(clsProductSubGroupBaseVariationsMatrixList["Price"]);
clsBaseDetails.WSPrice = Convert.ToDecimal(clsProductSubGroupBaseVariationsMatrixList["WSPrice"]);
clsBaseDetails.PurchasePrice = Convert.ToDecimal(clsProductSubGroupBaseVariationsMatrixList["PurchasePrice"]);
clsBaseDetails.IncludeInSubtotalDiscount = Convert.ToBoolean(clsProductSubGroupBaseVariationsMatrixList["IncludeInSubtotalDiscount"]);
clsBaseDetails.VAT = Convert.ToDecimal(clsProductSubGroupBaseVariationsMatrixList["VAT"]);
clsBaseDetails.EVAT = Convert.ToDecimal(clsProductSubGroupBaseVariationsMatrixList["EVAT"]);
clsBaseDetails.LocalTax = Convert.ToDecimal(clsProductSubGroupBaseVariationsMatrixList["LocalTax"]);
clsBaseDetails.Quantity = 0;
clsBaseDetails.MinThreshold = prodDetails.MinThreshold;
clsBaseDetails.MaxThreshold = prodDetails.MaxThreshold;
clsBaseDetails.MatrixID = clsProductVariationsMatrix.InsertBaseVariation(clsBaseDetails);
SubGroupBaseMatrixID = clsProductSubGroupBaseVariationsMatrixList.GetInt64(0);
clsProductSubGroupVariationsMatrix = new ProductSubGroupVariationsMatrix(base.Connection, base.Transaction);
clsProductSubGroupVariationsMatrixList = clsProductSubGroupVariationsMatrix.List(SubGroupBaseMatrixID);
while (clsProductSubGroupVariationsMatrixList.Read())
{
clsProductVariationsMatrixDetails = new ProductVariationsMatrixDetails();
clsProductVariationsMatrixDetails.MatrixID = clsBaseDetails.MatrixID;
clsProductVariationsMatrixDetails.ProductID = ProductID;
clsProductVariationsMatrixDetails.VariationID = Convert.ToInt64(clsProductSubGroupVariationsMatrixList["VariationID"]);
clsProductVariationsMatrixDetails.Description = "" + clsProductSubGroupVariationsMatrixList["Description"].ToString();
clsProductVariationsMatrix.SaveVariation(clsProductVariationsMatrixDetails);
}
clsProductSubGroupVariationsMatrixList.Close();
}
clsProductSubGroupBaseVariationsMatrixList.Close();
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
protected void cboProductCode_SelectedIndexChanged(object sender, System.EventArgs e)
{
if (cboProductCode.Items.Count == 0)
return;
DataClass clsDataClass = new DataClass();
long ProductID = Convert.ToInt64(cboProductCode.SelectedItem.Value);
if (ProductID == 0) {
cboVariation.Items.Clear();
cboVariation.Items.Add(new ListItem("No Variation", "0"));
return;
}
ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix();
cboVariation.DataTextField = "VariationDesc";
cboVariation.DataValueField = "MatrixID";
cboVariation.DataSource = clsProductVariationsMatrix.BaseListSimpleAsDataTable(ProductID, SortField: "VariationDesc").DefaultView;
cboVariation.DataBind();
if (cboVariation.Items.Count == 0)
{
cboVariation.Items.Add(new ListItem("No Variation", "0"));
}
cboVariation.SelectedIndex = cboVariation.Items.Count - 1;
clsProductVariationsMatrix.CommitAndDispose();
ProductUnitsMatrix clsUnitMatrix = new ProductUnitsMatrix();
cboProductUnit.DataTextField = "BottomUnitCode";
cboProductUnit.DataValueField = "BottomUnitID";
cboProductUnit.DataSource = clsUnitMatrix.ListAsDataTable(ProductID,"a.MatrixID",SortOption.Ascending).DefaultView;
cboProductUnit.DataBind();
clsUnitMatrix.CommitAndDispose();
Products clsProduct = new Products();
ProductDetails clsDetails = new ProductDetails();
clsDetails = clsProduct.Details(ProductID);
clsProduct.CommitAndDispose();
cboProductUnit.Items.Add( new ListItem(clsDetails.BaseUnitCode, clsDetails.BaseUnitID.ToString()));
cboProductUnit.SelectedIndex = cboProductUnit.Items.Count - 1;
cboVariation_SelectedIndexChanged(null, null);
}
private void CreateDefaultProduct(string DefaultProduct)
{
try
{
ProductDetails clsDetails = new ProductDetails();
clsDetails.ProductCode = DefaultProduct;
clsDetails.ProductDesc = DefaultProduct;
clsDetails.BarCode = DefaultProduct;
clsDetails.BarCode2 = "";
clsDetails.BarCode3 = "";
clsDetails.ProductGroupID = ProductGroup.DEFAULT_GROUP_ID;
clsDetails.ProductSubGroupID = ProductSubGroup.DEFAULT_SUB_GROUP_ID;
clsDetails.BaseUnitID = Unit.DEFAULT_UNIT_ID;
clsDetails.Price = 1;
clsDetails.Price1 = 1;
clsDetails.Price2 = 1;
clsDetails.Price3 = 1;
clsDetails.Price4 = 1;
clsDetails.Price5 = 1;
clsDetails.WSPrice = 1;
clsDetails.PurchasePrice = 1;
clsDetails.PercentageCommision = 0;
clsDetails.IncludeInSubtotalDiscount = true;
clsDetails.IsCreditChargeExcluded = false;
clsDetails.Quantity = 9999999999;
clsDetails.VAT = 0;
clsDetails.EVAT = 0;
clsDetails.LocalTax = 0;
clsDetails.MinThreshold = 0;
clsDetails.MaxThreshold = 0;
clsDetails.SupplierID = Contacts.DEFAULT_SUPPLIER_ID;
clsDetails.IsItemSold = false;
clsDetails.WillPrintProductComposition = false;
clsDetails.UpdatedBy = 1;
clsDetails.UpdatedOn = DateTime.Now;
clsDetails.RID = 0;
Insert(clsDetails);
}
catch (Exception ex)
{
throw ex;
}
}
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);
}
}
public Int64 Insert(ProductDetails Details)
{
try
{
if (IsExist(Details.ProductID, Details.BarCode, Details.BarCode2, Details.BarCode3))
{
throw new EntryPointNotFoundException("This product already exist, please check the barcode.");
}
string SQL = "INSERT INTO tblProducts (" +
"ProductCode, " +
"ProductDesc, " +
"ProductSubGroupID, " +
"BaseUnitID, " +
"DateCreated, " +
"PercentageCommision, " +
"IncludeInSubtotalDiscount, " +
"MinThreshold, " +
"MaxThreshold, " +
"SupplierID, " +
"IsItemSold, " +
"WillPrintProductComposition"+
") VALUES (" +
"@ProductCode, " +
"@ProductDesc, " +
"@ProductSubGroupID, " +
"@BaseUnitID, " +
"@DateCreated," +
"@PercentageCommision, " +
"@IncludeInSubtotalDiscount, " +
"@MinThreshold, " +
"@MaxThreshold, " +
"@SupplierID, " +
"@IsItemSold, " +
"@WillPrintProductComposition);";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
MySqlParameter prmProductCode = new MySqlParameter("@ProductCode",MySqlDbType.String);
prmProductCode.Value = Details.ProductCode;
cmd.Parameters.Add(prmProductCode);
MySqlParameter prmProductDesc = new MySqlParameter("@ProductDesc",MySqlDbType.String);
prmProductDesc.Value = Details.ProductDesc;
cmd.Parameters.Add(prmProductDesc);
MySqlParameter prmProductSubGroupID = new MySqlParameter("@ProductSubGroupID",MySqlDbType.Int64);
prmProductSubGroupID.Value = Details.ProductSubGroupID;
cmd.Parameters.Add(prmProductSubGroupID);
MySqlParameter prmBaseUnitID = new MySqlParameter("@BaseUnitID",MySqlDbType.String);
prmBaseUnitID.Value = Details.BaseUnitID;
cmd.Parameters.Add(prmBaseUnitID);
MySqlParameter prmDateCreated = new MySqlParameter("@DateCreated",MySqlDbType.DateTime);
prmDateCreated.Value = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
cmd.Parameters.Add(prmDateCreated);
MySqlParameter prmPercentageCommision = new MySqlParameter("@PercentageCommision",MySqlDbType.Decimal);
prmPercentageCommision.Value = Details.PercentageCommision;
cmd.Parameters.Add(prmPercentageCommision);
MySqlParameter prmIncludeInSubtotalDiscount = new MySqlParameter("@IncludeInSubtotalDiscount",MySqlDbType.Int16);
prmIncludeInSubtotalDiscount.Value = Details.IncludeInSubtotalDiscount;
cmd.Parameters.Add(prmIncludeInSubtotalDiscount);
MySqlParameter prmMinThreshold = new MySqlParameter("@MinThreshold",MySqlDbType.Decimal);
prmMinThreshold.Value = Details.MinThreshold;
cmd.Parameters.Add(prmMinThreshold);
MySqlParameter prmMaxThreshold = new MySqlParameter("@MaxThreshold",MySqlDbType.Decimal);
prmMaxThreshold.Value = Details.MaxThreshold;
cmd.Parameters.Add(prmMaxThreshold);
MySqlParameter prmSupplierID = new MySqlParameter("@SupplierID",MySqlDbType.Int64);
prmSupplierID.Value = Details.SupplierID;
cmd.Parameters.Add(prmSupplierID);
MySqlParameter prmIsItemSold = new MySqlParameter("@IsItemSold",MySqlDbType.Int16);
prmIsItemSold.Value = Convert.ToInt16(Details.IsItemSold);
cmd.Parameters.Add(prmIsItemSold);
MySqlParameter prmWillPrintProductComposition = new MySqlParameter("@WillPrintProductComposition",MySqlDbType.Int16);
prmWillPrintProductComposition.Value = Convert.ToInt16(Details.WillPrintProductComposition);
cmd.Parameters.Add(prmWillPrintProductComposition);
base.ExecuteNonQuery(cmd);
SQL = "SELECT LAST_INSERT_ID();";
cmd.Parameters.Clear();
cmd.CommandText = SQL;
System.Data.DataTable dt = new System.Data.DataTable("LAST_INSERT_ID");
base.MySqlDataAdapterFill(cmd, dt);
Int64 iID = 0;
foreach (System.Data.DataRow dr in dt.Rows)
{
iID = Int64.Parse(dr[0].ToString());
}
ProductPackageDetails clsProductPackageDetails = new ProductPackageDetails();
clsProductPackageDetails.ProductID = iID;
clsProductPackageDetails.BarCode1 = Details.BarCode;
clsProductPackageDetails.BarCode2 = Details.BarCode2;
clsProductPackageDetails.BarCode3 = Details.BarCode3;
clsProductPackageDetails.UnitID = Details.BaseUnitID;
clsProductPackageDetails.Price = Details.Price;
clsProductPackageDetails.Price1 = Details.Price1;
clsProductPackageDetails.Price2 = Details.Price2;
clsProductPackageDetails.Price3 = Details.Price3;
clsProductPackageDetails.Price4 = Details.Price4;
clsProductPackageDetails.Price5 = Details.Price5;
clsProductPackageDetails.WSPrice = Details.WSPrice;
clsProductPackageDetails.PurchasePrice = Details.PurchasePrice;
clsProductPackageDetails.Quantity = 1;
clsProductPackageDetails.VAT = Details.VAT;
clsProductPackageDetails.EVAT = Details.EVAT;
clsProductPackageDetails.LocalTax = Details.LocalTax;
ProductPackage clsProductPackage = new ProductPackage(base.Connection, base.Transaction);
clsProductPackage.Insert(clsProductPackageDetails);
// Oct 28, 2011 : Lemu
// Added to cater branch inventory
//BranchInventory clsBranchInventory = new BranchInventory(base.Connection, base.Transaction);
//clsBranchInventory.CreateToAllBranches(iID);
//base.ExecuteNonQuery(cmd);
return iID;
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
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 void Update(ProductDetails Details)
{
try
{
if (IsExist(Details.ProductID, Details.BarCode, Details.BarCode2, Details.BarCode3))
{
throw new Exception("This product already exist, please check the barcode.");
}
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQL = "UPDATE tblProducts SET " +
"ProductCode = @ProductCode, " +
"ProductDesc = @ProductDesc, " +
"ProductSubGroupID = @ProductSubGroupID, " +
"BaseUnitID = @BaseUnitID, " +
"PercentageCommision = @PercentageCommision, " +
"IncludeInSubtotalDiscount = @IncludeInSubtotalDiscount, " +
"MinThreshold = @MinThreshold, " +
"MaxThreshold = @MaxThreshold, " +
"SupplierID = @SupplierID, " +
"IsItemSold = @IsItemSold, " +
"WillPrintProductComposition = @WillPrintProductComposition, " +
"RID = @RID, " +
"SequenceNo = @SequenceNo " +
"WHERE ProductID = @ProductID;";
cmd.Parameters.AddWithValue("ProductCode", Details.ProductCode);
cmd.Parameters.AddWithValue("ProductDesc", Details.ProductDesc);
cmd.Parameters.AddWithValue("ProductSubGroupID", Details.ProductSubGroupID);
cmd.Parameters.AddWithValue("BaseUnitID", Details.BaseUnitID);
cmd.Parameters.AddWithValue("PercentageCommision", Details.PercentageCommision);
cmd.Parameters.AddWithValue("IncludeInSubtotalDiscount", Details.IncludeInSubtotalDiscount);
cmd.Parameters.AddWithValue("MinThreshold", Details.MinThreshold);
cmd.Parameters.AddWithValue("MaxThreshold", Details.MaxThreshold);
cmd.Parameters.AddWithValue("SupplierID", Details.SupplierID);
cmd.Parameters.AddWithValue("IsItemSold", Details.IsItemSold);
cmd.Parameters.AddWithValue("WillPrintProductComposition", Details.WillPrintProductComposition);
cmd.Parameters.AddWithValue("RID", Details.RID);
cmd.Parameters.AddWithValue("SequenceNo", Details.SequenceNo);
cmd.Parameters.AddWithValue("ProductID", Details.ProductID);
cmd.CommandText = SQL;
base.ExecuteNonQuery(cmd);
if (Details.Quantity > 0)
{
SQL = "UPDATE tblProducts SET Active = 1 WHERE ProductID = @ProductID AND Active = 0;";
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("ProductID", Details.ProductID);
cmd.CommandText = SQL;
base.ExecuteNonQuery(cmd);
}
ProductPackageDetails clsDetails = new ProductPackageDetails();
clsDetails.ProductID = Details.ProductID;
clsDetails.Quantity = 1;
clsDetails.Price = Details.Price;
clsDetails.Price1 = Details.Price1;
clsDetails.Price2 = Details.Price2;
clsDetails.Price3 = Details.Price3;
clsDetails.Price4 = Details.Price4;
clsDetails.Price5 = Details.Price5;
clsDetails.WSPrice = Details.WSPrice;
clsDetails.PurchasePrice = Details.PurchasePrice;
clsDetails.VAT = Details.VAT;
clsDetails.EVAT = Details.EVAT;
clsDetails.LocalTax = Details.LocalTax;
clsDetails.UnitID = Details.BaseUnitID;
clsDetails.UnitCode = Details.BaseUnitCode;
clsDetails.UnitName = Details.BaseUnitName;
clsDetails.BarCode1 = Details.BarCode;
clsDetails.BarCode2 = Details.BarCode2;
clsDetails.BarCode3 = Details.BarCode3;
ProductPackage clsProductPackage = new ProductPackage(base.Connection, base.Transaction);
clsProductPackage.UpdateByProductIDUnitIDAndQuantity(clsDetails, Details.UpdatedBy, Details.UpdatedOn, "Edit product module.");
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
private void LoadOptions()
{
Int64 prodid = Convert.ToInt64(Common.Decrypt(Request.QueryString["prodid"].ToString(),Session.SessionID));
lblProductID.Text = Convert.ToString(prodid);
ProductUnitsMatrix clsUnitMatrix = new ProductUnitsMatrix();
ProductUnitsMatrixDetails clsUnitDetails = clsUnitMatrix.LastDetails(prodid);
if (clsUnitDetails.BottomUnitName == null)
{
Products clsProduct = new Products();
ProductDetails clsDetails = new ProductDetails();
clsDetails = clsProduct.Details(prodid);
clsProduct.CommitAndDispose();
txtBaseUnit.Text = clsDetails.BaseUnitName;
lblBaseUnitID.Text = Convert.ToString(clsDetails.BaseUnitID);
}
else
{
txtBaseUnit.Text = clsUnitDetails.BottomUnitName;
lblBaseUnitID.Text = Convert.ToString(clsUnitDetails.BottomUnitID);
}
cboBottomUnit.DataTextField = "UnitName";
cboBottomUnit.DataValueField = "UnitID";
cboBottomUnit.DataSource = clsUnitMatrix.AvailableUnitsForProduct(prodid).DefaultView;
cboBottomUnit.DataBind();
if (cboBottomUnit.Items.Contains( new ListItem(txtBaseUnit.Text, lblBaseUnitID.Text)))
{
cboBottomUnit.Items.RemoveAt( cboBottomUnit.Items.IndexOf(cboBottomUnit.Items.FindByValue(lblBaseUnitID.Text)));
}
cboBottomUnit.SelectedIndex = cboBottomUnit.Items.Count - 1;
clsUnitMatrix.CommitAndDispose();
}
private void SaveRecord()
{
ProductDetails clsDetails = new ProductDetails();
clsDetails.ProductID = Convert.ToInt64(lblProductID.Text);
clsDetails.ProductCode = txtProductCode.Text;
clsDetails.BarCode = txtBarcode.Text;
clsDetails.ProductDesc = txtProductDesc.Text;
clsDetails.ProductGroupID = Convert.ToInt64(cboProductGroup.SelectedItem.Value);
clsDetails.ProductSubGroupID = Convert.ToInt64(cboProductSubGroup.SelectedItem.Value);
clsDetails.ProductDesc = txtProductDesc.Text;
clsDetails.BaseUnitID = Convert.ToInt32(cboProductUnit.SelectedItem.Value);
clsDetails.Price = Convert.ToDecimal(txtProductPrice.Text);
clsDetails.PurchasePrice = Convert.ToDecimal(txtPurchasePrice.Text);
clsDetails.IncludeInSubtotalDiscount = chkIncludeInSubtotalDiscount.Checked;
clsDetails.Quantity = Convert.ToDecimal(txtQuantity.Text);
clsDetails.VAT = Convert.ToDecimal(txtVAT.Text);
clsDetails.EVAT = Convert.ToDecimal(txtEVAT.Text);
clsDetails.LocalTax = Convert.ToDecimal(txtLocalTax.Text);
clsDetails.MinThreshold = Convert.ToDecimal(txtMinThreshold.Text);
clsDetails.MaxThreshold = Convert.ToDecimal(txtMaxThreshold.Text);
clsDetails.SupplierID = Convert.ToInt64(cboSupplier.SelectedItem.Value);
Products clsProduct = new Products();
clsProduct.Update(clsDetails);
clsProduct.CommitAndDispose();
}
