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 SetDataSource(ReportDocument Report)
{
string TransactionNo = Session["tranno"].ToString();
ReportDataset rptds = new ReportDataset();
Stock clsStock = new Stock();
DataTable dt = clsStock.Search(TransactionNo);
clsStock.CommitAndDispose();
long StockID = Convert.ToInt64(dt.Rows[0]["StockID"].ToString());
StockItem clsStockItem = new StockItem();
DataTable dtItems = clsStockItem.ListAsDataTable(StockID);
clsStockItem.CommitAndDispose();
foreach(DataRow dr in dt.Rows)
{
DataRow drNew = rptds.Stocks.NewRow();
foreach (DataColumn dc in rptds.Stocks.Columns)
drNew[dc] = dr[dc.ColumnName];
rptds.Stocks.Rows.Add(drNew);
}
foreach(DataRow dr in dtItems.Rows)
{
DataRow drNew = rptds.StockItems.NewRow();
foreach (DataColumn dc in rptds.StockItems.Columns)
drNew[dc] = dr[dc.ColumnName];
rptds.StockItems.Rows.Add(drNew);
}
Report.SetDataSource(rptds);
SetParameters(Report);
}
private void CloseTransaction()
{
Stock clsStock = new Stock();
clsStock.TagInactive(long.Parse(lblStockID.Text));
clsStock.CommitAndDispose();
}
private Int64 SaveRecord()
{
StockDetails clsDetails = new StockDetails();
clsDetails.TransactionNo = lblTransactionNo.Text;
clsDetails.BranchID = Convert.ToInt32(cboBranch.SelectedItem.Value);
clsDetails.StockTypeID = Convert.ToInt16(cboStockTypes.SelectedItem.Value);
clsDetails.StockDate = Convert.ToDateTime(lblStockDate.Text);
clsDetails.SupplierID = Convert.ToInt64(cboSupplier.SelectedItem.Value);
clsDetails.Remarks = txtRemarks.Text;
StockItemDetails[] itemDetails = new StockItemDetails[0];
clsDetails.StockItems = itemDetails;
Stock clsStock = new Stock();
Int64 id = clsStock.Insert(clsDetails);
clsStock.CommitAndDispose();
NewTransaction();
return id;
}
private void LoadRecord()
{
Int64 iID = Convert.ToInt64(Common.Decrypt(Request.QueryString["stockid"],Session.SessionID));
Stock clsStock = new Stock();
StockDetails clsDetails = clsStock.Details(iID);
Branch clsBranch = new Branch(clsStock.Connection, clsStock.Transaction);
cboBranch.DataTextField = "BranchCode";
cboBranch.DataValueField = "BranchID";
cboBranch.DataSource = clsBranch.ListAsDataTable().DefaultView;
cboBranch.DataBind();
clsStock.CommitAndDispose();
lblStockID.Text = clsDetails.StockID.ToString();
cboBranch.SelectedIndex = cboBranch.Items.IndexOf(cboBranch.Items.FindByValue(clsDetails.BranchID.ToString()));
lblTransactionNo.Text = clsDetails.TransactionNo;
lblStockDate.Text = clsDetails.StockDate.ToString("MMM. dd, yyy HH:mm:ss");
txtSupplier.Text = clsDetails.SupplierName;
lblSupplierID.Text = clsDetails.SupplierID.ToString();
txtStockTypeCode.Text = clsDetails.StockTypeCode;
txtStockTypeCode.ToolTip = clsDetails.StockTypeID.ToString();
txtStockDescription.Text = clsDetails.StockTypeDescription;
txtStockDirection.Text = clsDetails.StockDirection.ToString("G");
txtStockRemarks.Text = clsDetails.Remarks;
LoadItems();
}
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 Transfer()
{
if (isChkListSingle() == true)
{
string stID = GetFirstID();
if (stID!=null)
{
Int64 iID = Convert.ToInt64(stID);
Stock clsStock = new Stock();
StockDetails clsDetails = clsStock.Details(iID);
clsStock.CommitAndDispose();
if (clsDetails.StockTypeID.ToString() == Constants.STOCK_TYPE_TRANSFER_TO_BRANCH_ID)
{
string stParam = "?task=" + Common.Encrypt("transfer",Session.SessionID) + "&stockid=" + Common.Encrypt(stID,Session.SessionID);
Response.Redirect("Default.aspx" + stParam);
}
else
{
string stScript = "<Script>";
stScript += "window.alert('Sorry you cannot transfer this transaction. Please select a TRANSFER TO BRANCH transaction.')";
stScript += "</Script>";
Response.Write(stScript);
}
}
}
else
{
string stScript = "<Script>";
stScript += "window.alert('Cannot transfer more than one record. Please select at least one record to transfer.')";
stScript += "</Script>";
Response.Write(stScript);
}
}
private void LoadList()
{
Stock clsStock = new Stock();
DataClass clsDataClass = new DataClass();
string SortField = "StockID";
if (Request.QueryString["sortfield"]!=null)
{ SortField = Common.Decrypt(Request.QueryString["sortfield"].ToString(), Session.SessionID); }
SortOption sortoption = SortOption.Desscending;
if (Request.QueryString["sortoption"]!=null)
{ sortoption = (SortOption) Enum.Parse(typeof(SortOption), Common.Decrypt(Request.QueryString["sortoption"], Session.SessionID), true); }
TransactionListFilterType clsTransactionListFilterType = TransactionListFilterType.ShowActiveAndInactive;
if (rdoShowActiveOnly.Checked == true) clsTransactionListFilterType = TransactionListFilterType.ShowActiveOnly;
if (rdoShowInactiveOnly.Checked == true) clsTransactionListFilterType = TransactionListFilterType.ShowInactiveOnly;
string SearchKey = "";
if (Request.QueryString["Search"]!=null)
{
SearchKey = Common.Decrypt((string)Request.QueryString["search"],Session.SessionID);
}
PageData.DataSource = clsStock.ListAsDataTableActiveInactive(clsTransactionListFilterType, SearchKey, SortField, sortoption).DefaultView;
clsStock.CommitAndDispose();
int iPageSize = Convert.ToInt16(Session["PageSize"]) ;
PageData.AllowPaging = true;
PageData.PageSize = iPageSize;
try
{
PageData.CurrentPageIndex = Convert.ToInt16(cboCurrentPage.SelectedItem.Value) - 1;
lstItem.DataSource = PageData;
lstItem.DataBind();
}
catch
{
PageData.CurrentPageIndex = 1;
lstItem.DataSource = PageData;
lstItem.DataBind();
}
cboCurrentPage.Items.Clear();
for (int i=0; i < PageData.PageCount;i++)
{
int iValue = i + 1;
cboCurrentPage.Items.Add(new ListItem(iValue.ToString(),iValue.ToString()));
if (PageData.CurrentPageIndex == i)
{ cboCurrentPage.Items[i].Selected = true;}
else
{ cboCurrentPage.Items[i].Selected = false;}
}
lblDataCount.Text = " of " + " " + PageData.PageCount;
}
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)
{
Stock clsStock = new Stock();
clsStock.Delete( stIDs.Substring(0,stIDs.Length-1));
clsStock.CommitAndDispose();
}
return boRetValue;
}
protected void lstItem_ItemCommand(object sender, DataListCommandEventArgs e)
{
HtmlInputCheckBox chkList = (HtmlInputCheckBox)e.Item.FindControl("chkList");
string stParam = string.Empty;
switch (e.CommandName)
{
case "imgItemDelete":
Stock clsStock = new Stock();
clsStock.Delete(chkList.Value);
clsStock.CommitAndDispose();
LoadList();
break;
case "imgItemEdit":
stParam = "?task=" + Common.Encrypt("additem", Session.SessionID) + "&stockid=" + Common.Encrypt(chkList.Value, Session.SessionID);
Response.Redirect("Default.aspx" + stParam);
break;
case "imgItemTransfer":
stParam = "?task=" + Common.Encrypt("transfer", Session.SessionID) + "&stockid=" + Common.Encrypt(chkList.Value, Session.SessionID);
Response.Redirect("Default.aspx" + stParam);
break;
case "imgTransactionTag":
{
Stock clsStock1 = new Stock();
clsStock1.TagInactive(long.Parse(chkList.Value));
clsStock1.CommitAndDispose();
LoadList();
}
break;
}
}
private void LoadRecord()
{
Int64 iID = Convert.ToInt64(Common.Decrypt(Request.QueryString["stockid"],Session.SessionID));
Stock clsStock = new Stock();
StockDetails clsDetails = clsStock.Details(iID);
clsStock.CommitAndDispose();
lblStockID.Text = clsDetails.StockID.ToString();
lblTransactionNo.Text = clsDetails.TransactionNo;
lblStockDate.Text = clsDetails.StockDate.ToString("MMM. dd, yyy HH:mm:ss");
lblSupplier.Text = clsDetails.SupplierName;
lblSupplierID.Text = clsDetails.SupplierID.ToString();
lblStockTypeCode.Text = clsDetails.StockTypeCode;
lblStockTypeCode.ToolTip = clsDetails.StockTypeID.ToString();
lblStockDirection.Text = clsDetails.StockDirection.ToString("G");
LoadItems();
}