private void LoadItems()
{
StockItem clsStockItem = new StockItem();
lstItem.DataSource = clsStockItem.ListAsDataTable(Convert.ToInt64(lblStockID.Text)).DefaultView;
lstItem.DataBind();
clsStockItem.CommitAndDispose();
}
private void SetDataSource(ReportDocument Report)
{
ReportDataset rptds = new ReportDataset();
string TransactionNo = txtTransactionNo.Text.Trim();
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 Transfer()
{
Int64 iID = Convert.ToInt64(Common.Decrypt(Request.QueryString["stockid"], Session.SessionID));
Stock clsStock = new Stock();
StockDetails clsStockDetails = clsStock.Details(iID);
StockItem clsStockItem = new StockItem(clsStock.Connection, clsStock.Transaction);
DataTable dtaStockItemList = clsStockItem.ListAsDataTable(Convert.ToInt64(lblStockID.Text));
Contacts clsContact = new Contacts(clsStock.Connection, clsStock.Transaction);
ContactDetails clsContactDetails = clsContact.Details(clsStockDetails.SupplierID);
Products clsProduct = new Products(clsStock.Connection, clsStock.Transaction);
ProductDetails clsProductDetails;
ProductVariations clsProductVariation = new ProductVariations(clsStock.Connection, clsStock.Transaction);
DataTable dtaProductVariation;
ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix(clsStock.Connection, clsStock.Transaction);
DataTable dtaProductVariationsMatrix;
string xmlFileName = Server.MapPath(@"\RetailPlus\temp\" + cboBranch.SelectedItem.Text.Replace(" ", "").Trim() + clsStockDetails.TransactionNo + ".xml");
XmlTextWriter writer = new XmlTextWriter(xmlFileName, System.Text.Encoding.UTF8);
writer.Formatting = Formatting.Indented;
writer.WriteStartDocument();
writer.WriteComment("This file represents a new stock transaction for branch: '" + cboBranch.SelectedItem.Text + "'.");
writer.WriteComment("Save this in your local file. Goto 'File', click 'Save As', select the location in your local directory, click 'Save'.");
writer.WriteStartElement("Stock");
writer.WriteAttributeString("StockID", XmlConvert.ToString(clsStockDetails.StockID));
writer.WriteAttributeString("TransactionNo", clsStockDetails.TransactionNo);
writer.WriteAttributeString("StockTypeID", XmlConvert.ToString(clsStockDetails.StockTypeID));
writer.WriteAttributeString("StockTypeCode", clsStockDetails.StockTypeCode);
writer.WriteAttributeString("StockTypeDescription", clsStockDetails.StockTypeDescription);
writer.WriteAttributeString("StockDirection", clsStockDetails.StockDirection.ToString());
writer.WriteAttributeString("StockDate", clsStockDetails.StockDate.ToString("MM/dd/yyyy HH:mm:ss"));
/******Supplier information******/
writer.WriteAttributeString("ContactID", XmlConvert.ToString(clsContactDetails.ContactID));
writer.WriteAttributeString("ContactCode", clsContactDetails.ContactCode);
writer.WriteAttributeString("ContactName", clsContactDetails.ContactName);
writer.WriteAttributeString("ContactGroupID", clsContactDetails.ContactGroupID.ToString());
writer.WriteAttributeString("ContactGroupName", clsContactDetails.ContactGroupName);
writer.WriteAttributeString("ModeOfTerms", clsContactDetails.ModeOfTerms.ToString());
writer.WriteAttributeString("Terms", clsContactDetails.Terms.ToString());
writer.WriteAttributeString("Address", clsContactDetails.Address);
writer.WriteAttributeString("BusinessName", clsContactDetails.BusinessName);
writer.WriteAttributeString("TelephoneNo", clsContactDetails.TelephoneNo);
writer.WriteAttributeString("Remarks", clsContactDetails.Remarks);
writer.WriteAttributeString("Debit", clsContactDetails.Debit.ToString());
writer.WriteAttributeString("Credit", clsContactDetails.Credit.ToString());
writer.WriteAttributeString("CreditLimit", clsContactDetails.CreditLimit.ToString());
writer.WriteAttributeString("IsCreditAllowed", clsContactDetails.IsCreditAllowed.ToString());
writer.WriteAttributeString("DateCreated", clsContactDetails.DateCreated.ToString("MM/dd/yy HH:mm:ss"));
writer.WriteAttributeString("Deleted", clsContactDetails.Deleted.ToString());
/******End Of Supplier Information******/
writer.WriteAttributeString("StockRemarks", clsStockDetails.Remarks);
foreach (DataRow row in dtaStockItemList.Rows)
{
clsProductDetails = new ProductDetails();
clsProductDetails = clsProduct.Details(Convert.ToInt64(row["ProductID"].ToString()));
writer.WriteStartElement("Item");
writer.WriteAttributeString("ItemStockItemID", row["StockItemID"].ToString());
writer.WriteAttributeString("ItemStockID", row["StockID"].ToString());
writer.WriteAttributeString("ItemProductID", row["ProductID"].ToString());
/*****Product Information*****/
writer.WriteAttributeString("ProductCode", clsProductDetails.ProductCode);
writer.WriteAttributeString("BarCode", clsProductDetails.BarCode);
writer.WriteAttributeString("ProductDesc", clsProductDetails.ProductDesc);
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("ProductUnitCode", clsProductDetails.BaseUnitCode);
writer.WriteAttributeString("ProductUnitName", 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());
/*****End Of Product Information*****/
writer.WriteAttributeString("ItemVariationMatrixID", row["VariationMatrixID"].ToString());
writer.WriteAttributeString("ItemBaseVariationDescription", row["BaseVariationDescription"].ToString());
writer.WriteAttributeString("ItemProductUnitID", row["ProductUnitID"].ToString());
writer.WriteAttributeString("ItemUnitCode", row["UnitCode"].ToString());
writer.WriteAttributeString("ItemUnitName", row["UnitName"].ToString());
writer.WriteAttributeString("ItemStockTypeID", row["StockTypeID"].ToString());
writer.WriteAttributeString("ItemStockTypeDescription", row["StockTypeDescription"].ToString());
writer.WriteAttributeString("ItemStockDate", row["StockDate"].ToString());
writer.WriteAttributeString("ItemQuantity", row["Quantity"].ToString());
writer.WriteAttributeString("ItemRemarks", row["Remarks"].ToString());
dtaProductVariation = clsProductVariation.ListAsDataTable(clsProductDetails.ProductID, "a.VariationID", 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(Convert.ToInt64(row["VariationMatrixID"].ToString()), "MatrixID", 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();
clsStock.CommitAndDispose();
string stScript = "<Script>";
stScript += "window.open('/RetailPlus/temp/" + cboBranch.SelectedItem.Text.Replace(" ", "").Trim() + clsStockDetails.TransactionNo + ".xml')";
stScript += "</Script>";
Response.Write(stScript);
}
