private void SaveRecord()
{
Int64 iGuarantorID = Int64.Parse(cboContact.SelectedItem.Value);
Int16 iCreditCardTypeID = Int16.Parse(cboCardType.SelectedItem.Value);
string javaScript;
if (iGuarantorID == 0)
{
javaScript = "window.alert('Please select a guarantor to change the card type.')";
System.Web.UI.ScriptManager.RegisterClientScriptBlock(this.updSave, this.updSave.GetType(), "openwindow", javaScript, true);
return;
}
if (iCreditCardTypeID == 0)
{
javaScript = "window.alert('Please select a valid credit card type.')";
System.Web.UI.ScriptManager.RegisterClientScriptBlock(this.updSave, this.updSave.GetType(), "openwindow", javaScript, true);
return;
}
Security.AccessUserDetails clsAccessUserDetails = (Security.AccessUserDetails)Session["AccessUserDetails"];
Contacts clsContacts = new Contacts();
clsContacts.UpdateCreditCardType(iGuarantorID, iCreditCardTypeID, clsAccessUserDetails.Name);
clsContacts.CommitAndDispose();
cboContact_SelectedIndexChanged(null, null);
javaScript = "window.alert('Card Type for " + cboContact.SelectedItem.Text + " has been updated.')";
System.Web.UI.ScriptManager.RegisterClientScriptBlock(this.updSave, this.updSave.GetType(), "openwindow", javaScript, true);
}
private void SaveRecord()
{
Security.AccessUserDetails clsAccessUserDetails = (Security.AccessUserDetails)Session["AccessUserDetails"];
Contacts clsContact = new Contacts();
ContactDetails clsDetails = new ContactDetails();
clsDetails.ContactID = Convert.ToInt32(lblContactID.Text);
clsDetails.ContactCode = txtContactCode.Text;
clsDetails.ContactName = txtLastName.Text + ", " + txtFirstName.Text + " " + txtMiddleName.Text;
clsDetails.ContactGroupID = Convert.ToInt32(cboGroup.SelectedItem.Value);
clsDetails.ModeOfTerms = (ModeOfTerms)Enum.Parse(typeof(ModeOfTerms), cboModeOfTerms.SelectedItem.Value);
clsDetails.Terms = Convert.ToInt32(txtTerms.Text);
clsDetails.Address = txtAddress.Text;
clsDetails.BusinessName = txtBusinessName.Text;
clsDetails.TelephoneNo = txtTelephoneNo.Text;
clsDetails.Remarks = txtRemarks.Text;
clsDetails.Debit = Convert.ToDecimal(txtDebit.Text);
clsDetails.Credit = Convert.ToDecimal(txtCredit.Text);
clsDetails.IsCreditAllowed = chkIsCreditAllowed.Checked;
clsDetails.CreditLimit = Convert.ToDecimal(txtCreditLimit.Text);
clsDetails.DepartmentID = Convert.ToInt16(cboDepartment.SelectedItem.Value);
clsDetails.PositionID = Convert.ToInt16(cboPosition.SelectedItem.Value);
ContactAddOnDetails clsAddOnDetails = new ContactAddOnDetails();
clsAddOnDetails.ContactID = clsDetails.ContactID;
clsAddOnDetails.Salutation = cboSalutation.SelectedItem.Value;
clsAddOnDetails.FirstName = txtFirstName.Text;
clsAddOnDetails.MiddleName = txtMiddleName.Text;
clsAddOnDetails.LastName = txtLastName.Text;
clsAddOnDetails.SpouseName = "";
DateTime dteBirthDate = Constants.C_DATE_MIN_VALUE;
dteBirthDate = DateTime.TryParse(txtBirthDate.Text, out dteBirthDate) ? dteBirthDate : Constants.C_DATE_MIN_VALUE;
clsAddOnDetails.BirthDate = dteBirthDate;
clsAddOnDetails.SpouseBirthDate = Constants.C_DATE_MIN_VALUE;
clsAddOnDetails.AnniversaryDate = Constants.C_DATE_MIN_VALUE;
clsAddOnDetails.Address1 = txtAddress.Text;
clsAddOnDetails.Address2 = string.Empty;
clsAddOnDetails.City = string.Empty;
clsAddOnDetails.State = string.Empty;
clsAddOnDetails.ZipCode = string.Empty;
clsAddOnDetails.CountryID = Constants.C_DEF_COUNTRY_ID;
clsAddOnDetails.CountryCode = Constants.C_DEF_COUNTRY_CODE;
clsAddOnDetails.BusinessPhoneNo = txtTelephoneNo.Text;
clsAddOnDetails.HomePhoneNo = string.Empty;
clsAddOnDetails.MobileNo = txtMobileNo.Text;
clsAddOnDetails.FaxNo = string.Empty;
clsAddOnDetails.EmailAddress = string.Empty;
clsDetails.AdditionalDetails = clsAddOnDetails;
clsContact.Update(clsDetails);
clsContact.CommitAndDispose();
}
protected void imgVariationQuickAdd_Click(object sender, System.Web.UI.ImageClickEventArgs e)
{
try
{
long.Parse(cboProductCode.SelectedItem.Value);
if (txtVariation.Text != null || txtVariation.Text.Trim() != string.Empty || txtVariation.Text.Trim() != "")
{
Security.AccessUserDetails clsAccessUserDetails = (Security.AccessUserDetails)Session["AccessUserDetails"];
ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix();
clsProductVariationsMatrix.InsertBaseVariationEasy(long.Parse(cboProductCode.SelectedItem.Value), txtVariation.Text, clsAccessUserDetails.Name);
clsProductVariationsMatrix.CommitAndDispose();
cmdVariationSearch_Click(null, null);
}
}
catch { }
}
private void SaveRecord()
{
StockItemDetails clsDetails = new StockItemDetails();
clsDetails.StockID = Convert.ToInt64(lblStockID.Text);
clsDetails.ProductID = Convert.ToInt64(cboProductCode.SelectedItem.Value);
clsDetails.VariationMatrixID = Convert.ToInt64(cboVariation.SelectedItem.Value);
clsDetails.ProductUnitID = Convert.ToInt32(cboProductUnit.SelectedItem.Value);
clsDetails.StockTypeID = Convert.ToInt16(txtStockTypeCode.ToolTip);
clsDetails.StockDate = DateTime.Now;
clsDetails.Quantity = Convert.ToDecimal(txtQuantity.Text);
clsDetails.Remarks = txtRemarks.Text;
clsDetails.PurchasePrice = Convert.ToDecimal(txtPurchasePrice.Text);
StockDirections StockDirection = (StockDirections)Enum.Parse(typeof(StockDirections), txtStockDirection.Text);
Security.AccessUserDetails clsAccessUserDetails = (Security.AccessUserDetails)Session["AccessUserDetails"];
Stock clsStock = new Stock();
clsStock.AddItem(int.Parse(cboBranch.SelectedItem.Value), lblTransactionNo.Text, clsAccessUserDetails.Name, clsDetails, StockDirection);
clsStock.CommitAndDispose();
}
private void SaveRecord()
{
Security.AccessUserDetails clsDetails = (Security.AccessUserDetails)Session["AccessUserDetails"];
DateTime dteChangeDate = DateTime.Now;
Products clsProduct = new Products();
clsProduct.GetConnection();
InvAdjustment clsInvAdjustment = new InvAdjustment(clsProduct.Connection, clsProduct.Transaction);
InvAdjustmentDetails clsInvAdjustmentDetails;
long lngProductID = long.Parse(cboProductCode.SelectedValue);
if (lstVariationMatrix.Items.Count > 0)
{
ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix(clsProduct.Connection, clsProduct.Transaction);
foreach (DataListItem e in lstVariationMatrix.Items)
{
HtmlInputCheckBox chkMatrixID = (HtmlInputCheckBox)e.FindControl("chkMatrixID");
Label lblVariationDesc = (Label)e.FindControl("lblVariationDesc");
Label lblUnitNameMatrix = (Label)e.FindControl("lblUnitCode");
TextBox txtQuantityBeforeMatrix = (TextBox)e.FindControl("txtQuantityBefore");
//TextBox txtDifferenceMatrix = (TextBox)e.FindControl("txtDifference");
TextBox txtQuantityNowMatrix = (TextBox)e.FindControl("txtQuantityNow");
TextBox txtMinThresholdMatrix = (TextBox)e.FindControl("txtMinThreshold");
TextBox txtMaxThresholdMatrix = (TextBox)e.FindControl("txtMaxThreshold");
decimal decQuantityBeforeMatrix = decimal.Parse(txtQuantityBeforeMatrix.Text);
//decimal decDifferenceMatrix = decimal.Parse(txtDifference.Text);
decimal decQuantityNowMatrix = decimal.Parse(txtQuantityNowMatrix.Text);
decimal decMinThresholdMatrixBefore = decimal.Parse(txtMinThresholdMatrix.ToolTip);
decimal decMinThresholdMatrixNow = decimal.Parse(txtMinThresholdMatrix.Text);
decimal decMaxThresholdMatrixBefore = decimal.Parse(txtMaxThresholdMatrix.ToolTip);
decimal decMaxThresholdMatrixNow = decimal.Parse(txtMaxThresholdMatrix.Text);
if (decQuantityBeforeMatrix != decQuantityNowMatrix || decMinThresholdMatrixBefore != decMinThresholdMatrixNow || decMaxThresholdMatrixBefore != decMaxThresholdMatrixNow)
{
clsInvAdjustmentDetails = new InvAdjustmentDetails();
clsInvAdjustmentDetails.UID = clsDetails.UID;
clsInvAdjustmentDetails.InvAdjustmentDate = dteChangeDate;
clsInvAdjustmentDetails.ProductID = long.Parse(cboProductCode.SelectedValue);
clsInvAdjustmentDetails.ProductCode = cboProductCode.SelectedItem.Text;
clsInvAdjustmentDetails.Description = cboProductCode.SelectedItem.Text;
clsInvAdjustmentDetails.VariationMatrixID = long.Parse(chkMatrixID.Value);
clsInvAdjustmentDetails.MatrixDescription = lblVariationDesc.Text;
clsInvAdjustmentDetails.UnitID = int.Parse(lblUnitNameMatrix.ToolTip);
clsInvAdjustmentDetails.UnitCode = lblUnitNameMatrix.Text;
clsInvAdjustmentDetails.QuantityBefore = decQuantityBeforeMatrix;
clsInvAdjustmentDetails.QuantityNow = decQuantityNowMatrix;
clsInvAdjustmentDetails.MinThresholdBefore = decMinThresholdMatrixBefore;
clsInvAdjustmentDetails.MinThresholdNow = decMinThresholdMatrixNow;
clsInvAdjustmentDetails.MaxThresholdBefore = decMaxThresholdMatrixBefore;
clsInvAdjustmentDetails.MaxThresholdNow = decMaxThresholdMatrixNow;
clsInvAdjustmentDetails.Remarks = txtRemarks.Text;
clsInvAdjustment.Insert(clsInvAdjustmentDetails);
if (decQuantityBeforeMatrix > decQuantityNowMatrix)
{
clsProduct.UpdateInvDetails(int.Parse(cboBranch.SelectedItem.Value), lngProductID, long.Parse(chkMatrixID.Value), decQuantityNowMatrix, decMinThresholdMatrixNow, decMaxThresholdMatrixNow, Products.getPRODUCT_INVENTORY_MOVEMENT_VALUE(PRODUCT_INVENTORY_MOVEMENT.DEDUCT_INVENTORY_ADJUSTMENT), dteChangeDate, "SYS-ADJ" + dteChangeDate.ToString("yyyyMMddHHmmss"), clsDetails.Name);
}
else if (decQuantityBeforeMatrix < decQuantityNowMatrix)
{
clsProduct.UpdateInvDetails(int.Parse(cboBranch.SelectedItem.Value), lngProductID, long.Parse(chkMatrixID.Value), decQuantityNowMatrix, decMinThresholdMatrixNow, decMaxThresholdMatrixNow, Products.getPRODUCT_INVENTORY_MOVEMENT_VALUE(PRODUCT_INVENTORY_MOVEMENT.ADD_INVENTORY_ADJUSTMENT), dteChangeDate, "SYS-ADJ" + dteChangeDate.ToString("yyyyMMddHHmmss"), clsDetails.Name);
}
}
}
}
clsProduct.CommitAndDispose();
}
private bool Delete()
{
bool boRetValue = false;
string stIDs = "";
foreach (DataListItem item in lstItem.Items)
{
HtmlInputCheckBox chkList = (HtmlInputCheckBox)item.FindControl("chkList");
if (chkList != null)
{
if (chkList.Checked == true)
{
stIDs += chkList.Value + ",";
boRetValue = true;
}
}
}
if (boRetValue)
{
Security.AccessUserDetails clsAccessUserDetails = (Security.AccessUserDetails)Session["AccessUserDetails"];
ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix();
clsProductVariationsMatrix.GetConnection();
Products clsProducts = new Products(clsProductVariationsMatrix.Connection, clsProductVariationsMatrix.Transaction);
long ProductID = Int64.Parse(lblProductID.Text);
string[] strIDs = stIDs.Substring(0, stIDs.Length - 1).Split(',');
foreach (string ID in strIDs)
{
long MatrixID = long.Parse(ID);
ProductDetails clsDetails = clsProducts.Details(ProductID: ProductID, MatrixID: MatrixID);
InvAdjustmentDetails clsInvAdjustmentDetails = new InvAdjustmentDetails();
clsInvAdjustmentDetails.UID = clsAccessUserDetails.UID;
clsInvAdjustmentDetails.InvAdjustmentDate = DateTime.Now;
clsInvAdjustmentDetails.ProductID = clsDetails.ProductID;
clsInvAdjustmentDetails.ProductCode = clsDetails.ProductCode;
clsInvAdjustmentDetails.Description = clsDetails.ProductDesc;
clsInvAdjustmentDetails.VariationMatrixID = clsDetails.MatrixID;
clsInvAdjustmentDetails.MatrixDescription = clsDetails.MatrixDescription;
clsInvAdjustmentDetails.UnitID = clsDetails.BaseUnitID;
clsInvAdjustmentDetails.UnitCode = clsDetails.BaseUnitCode;
clsInvAdjustmentDetails.QuantityBefore = clsDetails.Quantity;
clsInvAdjustmentDetails.QuantityNow = 0;
clsInvAdjustmentDetails.MinThresholdBefore = clsDetails.MinThreshold;
clsInvAdjustmentDetails.MinThresholdNow = 0;
clsInvAdjustmentDetails.MaxThresholdBefore = clsDetails.MaxThreshold;
clsInvAdjustmentDetails.MaxThresholdNow = 0;
clsInvAdjustmentDetails.Remarks = "deleted item.";
InvAdjustment clsInvAdjustment = new InvAdjustment(clsProducts.Connection, clsProducts.Transaction);
clsInvAdjustment.Insert(clsInvAdjustmentDetails);
// Aug 1, 2011 : Lemu
// Replaced clsProductVariationsMatrix.SynchronizeQuantity(Convert.ToInt64(lblProductID.Text));
clsProductVariationsMatrix.Delete(long.Parse(ID));
}
// Aug 1, 2011 : Lemu
// Deleted and replaced by subtracting each matrix in the product to include in the ProductMovement report
// clsProduct.SubtractQuantity(clsProductDetails.ProductID, 0, clsBaseDetails.Quantity, Product.getPRODUCT_INVENTORY_MOVEMENT_VALUE(PRODUCT_INVENTORY_MOVEMENT.DEDUCT_PRODUCT_VARIATION_DELETE) + " : " + clsBaseDetails.Description, clsInvAdjustmentDetails.InvAdjustmentDate, "SYS-VARDEL" + clsInvAdjustmentDetails.InvAdjustmentDate.ToString(""), clsAccessUserDetails.Name);
// clsProductVariationsMatrix.SynchronizeQuantity(Convert.ToInt64(lblProductID.Text));
clsProductVariationsMatrix.CommitAndDispose();
}
return(boRetValue);
}
private bool SaveRecord()
{
foreach (DataListItem item in lstItem.Items)
{
HyperLink lnkVariationType = (HyperLink)item.FindControl("lnkVariationType");
if (lnkVariationType.Text.ToUpper() == CONSTANT_VARIATIONS.EXPIRATION.ToString("G"))
{
TextBox txtDescription = (TextBox)item.FindControl("txtDescription");
try
{
DateTime Expiry = DateTime.Parse(txtDescription.Text);
}
catch
{
string javaScript = "window.alert('Please enter a valid expiration date in YYYY-MM-DD format.');";
System.Web.UI.ScriptManager.RegisterClientScriptBlock(this.updSave, this.updSave.GetType(), "openwindow", javaScript, true);
return(false);
}
}
}
string stringVariationDesc = null;
foreach (DataListItem item in lstItem.Items)
{
HtmlInputCheckBox chkList = (HtmlInputCheckBox)item.FindControl("chkList");
TextBox txtDescription = (TextBox)item.FindControl("txtDescription");
stringVariationDesc += txtDescription.Text + "; ";
}
Security.AccessUserDetails clsAccessUserDetails = (Security.AccessUserDetails)Session["AccessUserDetails"];
ProductBaseVariationsMatrixDetails clsBaseDetails = new ProductBaseVariationsMatrixDetails();
ProductVariationsMatrixDetails clsDetails;
ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix();
ProductDetails clsProductDetails = new Products(clsProductVariationsMatrix.Connection, clsProductVariationsMatrix.Transaction).Details(Int64.Parse(lblProductID.Text));
clsBaseDetails.ProductID = Convert.ToInt64(lblProductID.Text);
clsBaseDetails.BarCode1 = txtBarcode.Text;
clsBaseDetails.BarCode2 = txtBarcode2.Text;
clsBaseDetails.BarCode3 = txtBarcode3.Text;
clsBaseDetails.Description = stringVariationDesc;
clsBaseDetails.UnitID = Convert.ToInt32(cboUnit.SelectedItem.Value);
clsBaseDetails.Price = Convert.ToDecimal(txtProductPrice.Text);
clsBaseDetails.Price1 = Convert.ToDecimal(txtPrice1.Text);
clsBaseDetails.Price2 = Convert.ToDecimal(txtPrice2.Text);
clsBaseDetails.Price3 = Convert.ToDecimal(txtPrice3.Text);
clsBaseDetails.Price4 = Convert.ToDecimal(txtPrice4.Text);
clsBaseDetails.Price5 = Convert.ToDecimal(txtPrice5.Text);
clsBaseDetails.WSPrice = Convert.ToDecimal(txtWSPrice.Text);
clsBaseDetails.WSPrice = Convert.ToDecimal(txtWSPrice.Text);
clsBaseDetails.PurchasePrice = Convert.ToDecimal(txtPurchasePrice.Text);
clsBaseDetails.IncludeInSubtotalDiscount = chkIncludeInSubtotalDiscount.Checked;
clsBaseDetails.Quantity = Convert.ToDecimal(txtQuantity.Text);
clsBaseDetails.VAT = Convert.ToDecimal(txtVAT.Text);
clsBaseDetails.EVAT = Convert.ToDecimal(txtEVAT.Text);
clsBaseDetails.LocalTax = Convert.ToDecimal(txtLocalTax.Text);
clsBaseDetails.MinThreshold = Convert.ToDecimal(txtMinThreshold.Text);
clsBaseDetails.MaxThreshold = Convert.ToDecimal(txtMaxThreshold.Text);
clsBaseDetails.SupplierID = clsProductDetails.SupplierID;
clsBaseDetails.CreatedBy = clsAccessUserDetails.Name;
clsBaseDetails.MatrixID = clsProductVariationsMatrix.InsertBaseVariation(clsBaseDetails);
foreach (DataListItem item in lstItem.Items)
{
HtmlInputCheckBox chkList = (HtmlInputCheckBox)item.FindControl("chkList");
TextBox txtDescription = (TextBox)item.FindControl("txtDescription");
clsDetails = new ProductVariationsMatrixDetails();
clsDetails.MatrixID = clsBaseDetails.MatrixID;
clsDetails.ProductID = Convert.ToInt64(lblProductID.Text);
clsDetails.VariationID = Convert.ToInt32(chkList.Value);
clsDetails.Description = txtDescription.Text;
clsProductVariationsMatrix.SaveVariation(clsDetails);
}
clsProductVariationsMatrix.CommitAndDispose();
return(true);
}
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.");
}
}
private void ManageSecurity()
{
Security.AccessUserDetails clsAccessUserDetails = (Security.AccessUserDetails)Session["AccessUserDetails"];
AccessRights clsAccessRights = new AccessRights();
AccessRightsDetails clsDetails = new AccessRightsDetails();
bool boShowMyFavorites = false;
bool boShowActionBar = false;
clsDetails = clsAccessRights.Details(clsAccessUserDetails.UID, (Int16)AccessTypes.Products);
lnkProducts.Visible = clsDetails.Read;
if (!clsDetails.Read)
{
divlnkProducts.Style.Add("display", "none");
}
lnkProductAdd.Visible = clsDetails.Write;
if (!clsDetails.Write)
{
divlnkProductAdd.Style.Add("display", "none");
}
// show label for reporting
if (clsDetails.Read && !boShowMyFavorites)
{
boShowMyFavorites = true;
}
clsDetails = clsAccessRights.Details(clsAccessUserDetails.UID, (int)AccessTypes.SynchronizeBranchProducts);
lnkSynchronize.Visible = clsDetails.Read;
if (!clsDetails.Read)
{
divlnkSynchronize.Style.Add("display", "none");
}
// show label for reporting
if (clsDetails.Read && !boShowActionBar)
{
boShowActionBar = true;
}
clsDetails = clsAccessRights.Details(clsAccessUserDetails.UID, (Int16)AccessTypes.Contacts);
lnkContact.Visible = clsDetails.Read;
if (!clsDetails.Read)
{
divlnkContact.Style.Add("display", "none");
}
// show label for reporting
if (clsDetails.Read && !boShowMyFavorites)
{
boShowMyFavorites = true;
}
clsDetails = clsAccessRights.Details(clsAccessUserDetails.UID, (Int16)AccessTypes.RewardItemsSetup);
lnkRewards.Visible = clsDetails.Read;
if (!clsDetails.Read)
{
divlnkRewards.Style.Add("display", "none");
}
// show label for reporting
if (clsDetails.Read && !boShowMyFavorites)
{
boShowMyFavorites = true;
}
clsDetails = clsAccessRights.Details(clsAccessUserDetails.UID, (Int16)AccessTypes.InventoryList);
lnkInventoryList.Visible = clsDetails.Read;
if (!clsDetails.Read)
{
divlnkInventoryList.Style.Add("display", "none");
}
// show label for reporting
if (clsDetails.Read && !boShowMyFavorites)
{
boShowMyFavorites = true;
}
clsDetails = clsAccessRights.Details(clsAccessUserDetails.UID, (Int16)AccessTypes.StockTransactions);
lnkStock.Visible = clsDetails.Read;
if (!clsDetails.Read)
{
divlnkStock.Style.Add("display", "none");
}
// show label for reporting
if (clsDetails.Read && !boShowMyFavorites)
{
boShowMyFavorites = true;
}
lnkUpload.Visible = clsDetails.Read;
//if (!clsDetails.Read) divactlnkUpload.Style.Add("display", "none");
if (!clsDetails.Read)
{
divlnkUpload.Style.Add("display", "none");
}
// show label for reporting
if (clsDetails.Read && !boShowActionBar)
{
boShowActionBar = true;
}
clsDetails = clsAccessRights.Details(clsAccessUserDetails.UID, (Int16)AccessTypes.AccessUsers);
lnkAccessUserAdd.Visible = clsDetails.Write;
if (!clsDetails.Read)
{
divlnkAccessUserAdd.Style.Add("display", "none");
}
// show label for reporting
if (clsDetails.Read && !boShowActionBar)
{
boShowActionBar = true;
}
clsDetails = clsAccessRights.Details(clsAccessUserDetails.UID, (Int16)AccessTypes.ReportFormat);
lnkReceiptFormatEdit.Visible = clsDetails.Write;
if (!clsDetails.Read)
{
divlnkReceiptFormatEdit.Style.Add("display", "none");
}
// show label for reporting
if (clsDetails.Read && !boShowActionBar)
{
boShowActionBar = true;
}
//divactlnkGLAUploadSales.Style.Add("display", "none");
divlnkGLAUploadSales.Style.Add("display", "none");
lnkGLAUploadSales.Visible = false;
clsAccessRights.CommitAndDispose();
if (!boShowMyFavorites)
{
divlblMyFavorites.Style.Add("display", "none");
divtblMyFavorites.Style.Add("display", "none");
}
if (!boShowActionBar)
{
divlblActionBar.Style.Add("display", "none");
}
}
