public StockItemDetails[] Details(Int64 StockID)
{
try
{
System.Data.DataTable dt = ListAsDataTable(StockID, "StockItemID", SortOption.Ascending);
ArrayList items = new ArrayList();
foreach (System.Data.DataRow dr in dt.Rows)
{
StockItemDetails itemDetails = new StockItemDetails();
itemDetails.StockItemID = Int64.Parse(dr["StockItemID"].ToString());
itemDetails.StockID = StockID;
itemDetails.ProductID = Int64.Parse(dr["ProductID"].ToString());
itemDetails.VariationMatrixID = Int64.Parse(dr["VariationMatrixID"].ToString());
itemDetails.ProductUnitID = Int32.Parse(dr["ProductUnitID"].ToString());
itemDetails.StockTypeID = Int16.Parse(dr["StockTypeID"].ToString());
itemDetails.StockDate = DateTime.Parse(dr["StockDate"].ToString());
itemDetails.Quantity = decimal.Parse(dr["Quantity"].ToString());
itemDetails.Remarks = "" + dr["Remarks"].ToString();
itemDetails.PurchasePrice = decimal.Parse(dr["PurchasePrice"].ToString());
items.Add(itemDetails);
}
StockItemDetails[] StockItems = new StockItemDetails[0];
if (items != null)
{
StockItems = new StockItemDetails[items.Count];
items.CopyTo(StockItems);
}
return(StockItems);
}
catch (Exception ex)
{
{
}
throw base.ThrowException(ex);
}
}
/// <summary>
/// Jul 28, 2011 : Lemu
// - Remove the adding/subtracting and SynchronizeQuantity in clsProductVariationsMatrix,
// already included in the new AddQuantity and SubtractQuantity.
/// </summary>
/// <param name="Details"></param>
/// <param name="StockDirection"></param>
/// <returns></returns>
public Int64 AddItem(int BranchID, string TransactionNo, string CreatedBy, StockItemDetails Details, StockDirections StockDirection)
{
try
{
StockItem clsStockItem = new StockItem(base.Connection, base.Transaction);
Int64 StockItemID = clsStockItem.Insert(Details);
ProductUnit clsProductUnit = new ProductUnit(base.Connection, base.Transaction);
decimal Quantity = clsProductUnit.GetBaseUnitValue(Details.ProductID, Details.ProductUnitID, Details.Quantity);
string strRemarks = string.Empty;
Products clsProduct = new Products(base.Connection, base.Transaction);
if (StockDirection == StockDirections.Decrement)
{
strRemarks = Products.getPRODUCT_INVENTORY_MOVEMENT_VALUE(PRODUCT_INVENTORY_MOVEMENT.DEDUCT_STOCK_INVENTORY) + " " + Details.Remarks;
clsProduct.SubtractQuantity(BranchID, Details.ProductID, Details.VariationMatrixID, Quantity, strRemarks, Details.StockDate, TransactionNo, CreatedBy);
}
else
{
strRemarks = Products.getPRODUCT_INVENTORY_MOVEMENT_VALUE(PRODUCT_INVENTORY_MOVEMENT.ADD_STOCK_INVENTORY) + " " + Details.Remarks;
clsProduct.AddQuantity(BranchID, Details.ProductID, Details.VariationMatrixID, Quantity, strRemarks, Details.StockDate, TransactionNo, CreatedBy);
}
// Removed
//ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix(base.Connection, base.Transaction);
//if (Details.VariationMatrixID != 0)
//{
// if (StockDirection == StockDirections.Decrement)
// { clsProductVariationsMatrix.SubtractQuantity(Details.VariationMatrixID, Quantity); }
// else
// { clsProductVariationsMatrix.AddQuantity(Details.VariationMatrixID, Quantity); }
// clsProductVariationsMatrix.SynchronizeQuantity(Details.ProductID);
//}
return(StockItemID);
}
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 Int64 Insert(StockItemDetails Details)
{
try
{
string SQL = "INSERT INTO tblStockItems (" +
"StockID, " +
"ProductID, " +
"VariationMatrixID, " +
"ProductUnitID, " +
"StockTypeID, " +
"StockDate, " +
"Quantity, " +
"Remarks, " +
"PurchasePrice" +
") VALUES (" +
"@StockID, " +
"@ProductID, " +
"@VariationMatrixID, " +
"@ProductUnitID, " +
"@StockTypeID, " +
"@StockDate, " +
"@Quantity, " +
"@Remarks, " +
"@PurchasePrice);";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
MySqlParameter prmStockID = new MySqlParameter("@StockID",MySqlDbType.Int64);
prmStockID.Value = Details.StockID;
cmd.Parameters.Add(prmStockID);
MySqlParameter prmProductID = new MySqlParameter("@ProductID",MySqlDbType.Int64);
prmProductID.Value = Details.ProductID;
cmd.Parameters.Add(prmProductID);
MySqlParameter prmVariationMatrixID = new MySqlParameter("@VariationMatrixID",MySqlDbType.Int64);
prmVariationMatrixID.Value = Details.VariationMatrixID;
cmd.Parameters.Add(prmVariationMatrixID);
MySqlParameter prmProductUnitID = new MySqlParameter("@ProductUnitID",MySqlDbType.Int32);
prmProductUnitID.Value = Details.ProductUnitID;
cmd.Parameters.Add(prmProductUnitID);
MySqlParameter prmStockTypeID = new MySqlParameter("@StockTypeID",MySqlDbType.Int16);
prmStockTypeID.Value = Details.StockTypeID;
cmd.Parameters.Add(prmStockTypeID);
MySqlParameter prmStockDate = new MySqlParameter("@StockDate",MySqlDbType.DateTime);
prmStockDate.Value = Details.StockDate.ToString("yyyy-MM-dd HH:mm:ss");
cmd.Parameters.Add(prmStockDate);
MySqlParameter prmQuantity = new MySqlParameter("@Quantity",MySqlDbType.Decimal);
prmQuantity.Value = Details.Quantity;
cmd.Parameters.Add(prmQuantity);
MySqlParameter prmRemarks = new MySqlParameter("@Remarks",MySqlDbType.String);
prmRemarks.Value = Details.Remarks;
cmd.Parameters.Add(prmRemarks);
MySqlParameter prmPurchasePrice = new MySqlParameter("@PurchasePrice",MySqlDbType.Decimal);
prmPurchasePrice.Value = Details.PurchasePrice;
cmd.Parameters.Add(prmPurchasePrice);
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());
}
return iID;
}
catch (Exception ex)
{
{
}
throw base.ThrowException(ex);
}
}
public StockItemDetails[] Details(Int64 StockID)
{
try
{
System.Data.DataTable dt = ListAsDataTable(StockID, "StockItemID", SortOption.Ascending);
ArrayList items = new ArrayList();
foreach(System.Data.DataRow dr in dt.Rows)
{
StockItemDetails itemDetails = new StockItemDetails();
itemDetails.StockItemID = Int64.Parse(dr["StockItemID"].ToString());
itemDetails.StockID = StockID;
itemDetails.ProductID = Int64.Parse(dr["ProductID"].ToString());
itemDetails.VariationMatrixID = Int64.Parse(dr["VariationMatrixID"].ToString());
itemDetails.ProductUnitID = Int32.Parse(dr["ProductUnitID"].ToString());
itemDetails.StockTypeID = Int16.Parse(dr["StockTypeID"].ToString());
itemDetails.StockDate = DateTime.Parse(dr["StockDate"].ToString());
itemDetails.Quantity = decimal.Parse(dr["Quantity"].ToString());
itemDetails.Remarks = "" + dr["Remarks"].ToString();
itemDetails.PurchasePrice = decimal.Parse(dr["PurchasePrice"].ToString());
items.Add(itemDetails);
}
StockItemDetails[] StockItems = new StockItemDetails[0];
if (items != null)
{
StockItems = new StockItemDetails[items.Count];
items.CopyTo(StockItems);
}
return StockItems;
}
catch (Exception ex)
{
{
}
throw base.ThrowException(ex);
}
}
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;
}
public Int64 Insert(StockItemDetails Details)
{
try
{
string SQL = "INSERT INTO tblStockItems (" +
"StockID, " +
"ProductID, " +
"VariationMatrixID, " +
"ProductUnitID, " +
"StockTypeID, " +
"StockDate, " +
"Quantity, " +
"Remarks, " +
"PurchasePrice" +
") VALUES (" +
"@StockID, " +
"@ProductID, " +
"@VariationMatrixID, " +
"@ProductUnitID, " +
"@StockTypeID, " +
"@StockDate, " +
"@Quantity, " +
"@Remarks, " +
"@PurchasePrice);";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = SQL;
MySqlParameter prmStockID = new MySqlParameter("@StockID", MySqlDbType.Int64);
prmStockID.Value = Details.StockID;
cmd.Parameters.Add(prmStockID);
MySqlParameter prmProductID = new MySqlParameter("@ProductID", MySqlDbType.Int64);
prmProductID.Value = Details.ProductID;
cmd.Parameters.Add(prmProductID);
MySqlParameter prmVariationMatrixID = new MySqlParameter("@VariationMatrixID", MySqlDbType.Int64);
prmVariationMatrixID.Value = Details.VariationMatrixID;
cmd.Parameters.Add(prmVariationMatrixID);
MySqlParameter prmProductUnitID = new MySqlParameter("@ProductUnitID", MySqlDbType.Int32);
prmProductUnitID.Value = Details.ProductUnitID;
cmd.Parameters.Add(prmProductUnitID);
MySqlParameter prmStockTypeID = new MySqlParameter("@StockTypeID", MySqlDbType.Int16);
prmStockTypeID.Value = Details.StockTypeID;
cmd.Parameters.Add(prmStockTypeID);
MySqlParameter prmStockDate = new MySqlParameter("@StockDate", MySqlDbType.DateTime);
prmStockDate.Value = Details.StockDate.ToString("yyyy-MM-dd HH:mm:ss");
cmd.Parameters.Add(prmStockDate);
MySqlParameter prmQuantity = new MySqlParameter("@Quantity", MySqlDbType.Decimal);
prmQuantity.Value = Details.Quantity;
cmd.Parameters.Add(prmQuantity);
MySqlParameter prmRemarks = new MySqlParameter("@Remarks", MySqlDbType.String);
prmRemarks.Value = Details.Remarks;
cmd.Parameters.Add(prmRemarks);
MySqlParameter prmPurchasePrice = new MySqlParameter("@PurchasePrice", MySqlDbType.Decimal);
prmPurchasePrice.Value = Details.PurchasePrice;
cmd.Parameters.Add(prmPurchasePrice);
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());
}
return(iID);
}
catch (Exception ex)
{
{
}
throw base.ThrowException(ex);
}
}
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();
}
/// <summary>
/// Jul 28, 2011 : Lemu
// - Remove the adding/subtracting and SynchronizeQuantity in clsProductVariationsMatrix,
// already included in the new AddQuantity and SubtractQuantity.
/// </summary>
/// <param name="Details"></param>
/// <param name="StockDirection"></param>
/// <returns></returns>
public Int64 AddItem(int BranchID, string TransactionNo, string CreatedBy, StockItemDetails Details, StockDirections StockDirection)
{
try
{
StockItem clsStockItem = new StockItem(base.Connection, base.Transaction);
Int64 StockItemID = clsStockItem.Insert(Details);
ProductUnit clsProductUnit = new ProductUnit(base.Connection, base.Transaction);
decimal Quantity = clsProductUnit.GetBaseUnitValue(Details.ProductID, Details.ProductUnitID, Details.Quantity);
string strRemarks = string.Empty;
Products clsProduct = new Products(base.Connection, base.Transaction);
if (StockDirection == StockDirections.Decrement)
{
strRemarks = Products.getPRODUCT_INVENTORY_MOVEMENT_VALUE(PRODUCT_INVENTORY_MOVEMENT.DEDUCT_STOCK_INVENTORY) + " " + Details.Remarks;
clsProduct.SubtractQuantity(BranchID, Details.ProductID, Details.VariationMatrixID, Quantity, strRemarks, Details.StockDate, TransactionNo, CreatedBy);
}
else
{
strRemarks = Products.getPRODUCT_INVENTORY_MOVEMENT_VALUE(PRODUCT_INVENTORY_MOVEMENT.ADD_STOCK_INVENTORY) + " " + Details.Remarks;
clsProduct.AddQuantity(BranchID, Details.ProductID, Details.VariationMatrixID, Quantity, strRemarks, Details.StockDate, TransactionNo, CreatedBy);
}
// Removed
//ProductVariationsMatrix clsProductVariationsMatrix = new ProductVariationsMatrix(base.Connection, base.Transaction);
//if (Details.VariationMatrixID != 0)
//{
// if (StockDirection == StockDirections.Decrement)
// { clsProductVariationsMatrix.SubtractQuantity(Details.VariationMatrixID, Quantity); }
// else
// { clsProductVariationsMatrix.AddQuantity(Details.VariationMatrixID, Quantity); }
// clsProductVariationsMatrix.SynchronizeQuantity(Details.ProductID);
//}
return StockItemID;
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
