public void GetPurchaseByID(ref PurchaseRecord vobjPurchaseRecord)
{
new ProductPurchaseDB().GetPurchaseByID(ref vobjPurchaseRecord);
}
public void AddEditProductPurchase(ref PurchaseRecord vobjPurchaseRecord)
{
new ProductPurchaseDB().AddEditProductPurchase(ref vobjPurchaseRecord);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
serversideEvent = Page.ClientScript.GetPostBackEventReference(lnkAddMore, string.Empty);
PopulateAutoCompleteDataTable();
PopulateManufacturer();
txtDateOfPurchase.Value = string.Format("{0:dd/MM/yyyy}", DateTime.Today);
gobjProduct = new List<PurchasedProduct>();
Session["PurchasedProduct"] = gobjProduct;
string strQuery = Request.QueryString["q"];
if (!string.IsNullOrEmpty(strQuery))
{
Dictionary<String, String> objQuery = Common.PopulateDictionaryFromQueryString(strQuery);
SelectedMode = objQuery["MODE"].ToString();
//PurchaseID = Convert.ToInt32(objQuery["ID"].ToString());
if (SelectedMode == Constants.MODE_EDIT)
{
Session["dtProductDetail"] = null;
lblHeader.Text = "EDIT | Product Purchase";
PurchaseID = Convert.ToInt32(objQuery["ID"].ToString());
PurchaseRecord objPurchaseRecord = new PurchaseRecord();
objPurchaseRecord.PurchaseID = PurchaseID;
new ProductPurchaseBLL().GetPurchaseByID(ref objPurchaseRecord);
gobjProduct = objPurchaseRecord.ProductsPurchased;
Session["PurchasedProduct"] = gobjProduct;
cmbManufacturer.SelectedValue = objPurchaseRecord.ManufacturerID.ToString();
txtDateOfPurchase.Value = objPurchaseRecord.PurchaseDate;
lblTotalAmount.Text = Math.Round(objPurchaseRecord.TotalBuyingPrice, 2).ToString();
lblTotalQuantity.Text = objPurchaseRecord.TotalQty.ToString();
txtPurchaseID.Value = PurchaseID.ToString();
PopulateGrid();
}
else
{
lblHeader.Text = "ADD | Product Purchase";
txtPurchaseID.Value = "0";
}
}
else
{
Response.Redirect("BuyingInterface.aspx", false);
}
//if (null == Session["PurchasedProduct"])
//{
// gobjProduct = new List<PurchasedProduct>();
//}
//else
//{
// gobjProduct = (List<PurchasedProduct>)Session["PurchasedProduct"];
//}
}
}
protected void lnkSave_Click(object sender, EventArgs e)
{
if (Session["PurchasedProduct"] != null)
{
if (cmbManufacturer.SelectedIndex > 0)
{
gobjProduct = (List<PurchasedProduct>)Session["PurchasedProduct"];
PurchaseRecord objPurchaseRecord = new PurchaseRecord();
objPurchaseRecord.ManufacturerID = Convert.ToInt32(cmbManufacturer.SelectedValue);
objPurchaseRecord.PurchaseDate = txtDateOfPurchase.Value;
objPurchaseRecord.PurchaseID = Convert.ToInt32(txtPurchaseID.Value);
objPurchaseRecord.ProductsPurchased = gobjProduct;
new ProductPurchaseBLL().AddEditProductPurchase(ref objPurchaseRecord);
if (objPurchaseRecord.ReturnValue > 0)
{
Response.Redirect("BuyingInterface.aspx", true);
}
else
{
txtProductBarCode.Text = "";
Productid.Value = "0";
ScriptManager.RegisterStartupScript(this, this.GetType(), "alertMsg", "alert('Error in saving record!')", true);
ScriptManager.RegisterStartupScript(this, this.GetType(), "PopulateType", "Populate('2')", true);
}
}
else
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "alertMsg", "alert('Please select manufacturer!')", true);
}
}
}
public void GetPurchaseByID(ref PurchaseRecord vobjPurchaseRecord)
{
try
{
object[] mParams = {
new SqlParameter("@PurchaseID", SqlDbType.Int)
};
mParams[0] = vobjPurchaseRecord.PurchaseID;
PurchasedProduct objPurchasedProduct;
ProductSize objProductSize = new ProductSize();
List<PurchasedProduct> lstPurchasedProduct = new List<PurchasedProduct>();
List<ProductSize> lstProductSize = new List<ProductSize>();
int intTotalQty = 0;
decimal dcmTotalBuyingPrice = 0;
using (IDataReader reader = dBase.ExecuteReader("sprocCS_GetProductPurchaseByID", mParams))
{
while (reader.Read())
{
objPurchasedProduct = new PurchasedProduct();
if (reader["ManufacturerID"] != DBNull.Value)
vobjPurchaseRecord.ManufacturerID = Convert.ToInt32(reader["ManufacturerID"]);
if (reader["PurchaseDate"] != DBNull.Value)
vobjPurchaseRecord.PurchaseDate = Convert.ToDateTime(reader["PurchaseDate"]).ToString("dd/MM/yyyy");
if (reader["ProductID"] != DBNull.Value)
objPurchasedProduct.ProductID = Convert.ToInt32(reader["ProductID"]);
if (reader["ProductName"] != DBNull.Value)
objPurchasedProduct.ProductName = Convert.ToString(reader["ProductName"]);
if (reader["BuyingPrice"] != DBNull.Value)
objPurchasedProduct.BuyingPrice = Convert.ToDecimal(reader["BuyingPrice"]);
if (reader["Tax"] != DBNull.Value)
objPurchasedProduct.Tax = Convert.ToDecimal(reader["Tax"]);
if (reader["Margin"] != DBNull.Value)
objPurchasedProduct.Margin = Convert.ToDecimal(reader["Margin"]);
if (reader["SellingPrice"] != DBNull.Value)
objPurchasedProduct.SellingPrice = Convert.ToDecimal(reader["SellingPrice"]);
if (reader["BarCode"] != DBNull.Value)
objPurchasedProduct.BarCode = Convert.ToString(reader["BarCode"]);
string[] sizes = Convert.ToString(reader["Sizes"]).Split(',');
lstProductSize = new List<ProductSize>();
intTotalQty = 0;
for (int i = 0; i < sizes.Length; i++)
{
objProductSize = new ProductSize();
string[] sizeqty = sizes[i].Split('~');
objProductSize.SizeID = Convert.ToInt32(sizeqty[0]);
objProductSize.Quantity = Convert.ToInt32(sizeqty[2]);
objProductSize.ProductID = objPurchasedProduct.ProductID;
lstProductSize.Add(objProductSize);
if (i > 0)
objPurchasedProduct.SizeQty += "<br/>";
objPurchasedProduct.SizeQty += sizeqty[1] + ": " + objProductSize.Quantity;
intTotalQty += objProductSize.Quantity;
}
objPurchasedProduct.PurchasedQty = lstProductSize;
vobjPurchaseRecord.TotalQty += intTotalQty;
vobjPurchaseRecord.TotalBuyingPrice += objPurchasedProduct.BuyingPrice * intTotalQty;
lstPurchasedProduct.Add(objPurchasedProduct);
}
vobjPurchaseRecord.ProductsPurchased = lstPurchasedProduct;
}
}
catch (Exception ex)
{
Common.LogError("CSWeb > Error > " + (new StackTrace()).GetFrame(0).GetMethod().Name, ex.ToString());
}
}
public void AddEditProductPurchase(ref PurchaseRecord vobjProductPurchase)
{
try
{
StringBuilder strProducts = new StringBuilder();
StringBuilder strSizes = new StringBuilder();
strProducts.Append("<data>");
strSizes.Append("<data>");
for (int i = 0; i < vobjProductPurchase.ProductsPurchased.Count; i++)
{
strProducts.Append("<products>");
strProducts.Append("<productId>" + vobjProductPurchase.ProductsPurchased[i].ProductID + "</productId>");
strProducts.Append("<buyingPrice>" + vobjProductPurchase.ProductsPurchased[i].BuyingPrice + "</buyingPrice>");
strProducts.Append("<tax>" + vobjProductPurchase.ProductsPurchased[i].Tax + "</tax>");
strProducts.Append("<margin>" + vobjProductPurchase.ProductsPurchased[i].Margin + "</margin>");
strProducts.Append("<sellingPrice>" + vobjProductPurchase.ProductsPurchased[i].SellingPrice + "</sellingPrice>");
strProducts.Append("</products>");
for (int j = 0; j < vobjProductPurchase.ProductsPurchased[i].PurchasedQty.Count; j++)
{
if (vobjProductPurchase.ProductsPurchased[i].PurchasedQty[j].Quantity > 0)
{
strSizes.Append("<sizes>");
strSizes.Append("<productId>" + vobjProductPurchase.ProductsPurchased[i].PurchasedQty[j].ProductID + "</productId>");
strSizes.Append("<sizeId>" + vobjProductPurchase.ProductsPurchased[i].PurchasedQty[j].SizeID + "</sizeId>");
strSizes.Append("<quantity>" + vobjProductPurchase.ProductsPurchased[i].PurchasedQty[j].Quantity + "</quantity>");
strSizes.Append("</sizes>");
}
}
}
strProducts.Append("</data>");
strSizes.Append("</data>");
DbCommand objCmd = dBase.GetStoredProcCommand("sprocCS_InsertUpdatePurchase");
dBase.AddInParameter(objCmd, "@PurchaseID", DbType.Int32, vobjProductPurchase.PurchaseID);
dBase.AddInParameter(objCmd, "@ManufacturerID", DbType.Int32, vobjProductPurchase.ManufacturerID);
dBase.AddInParameter(objCmd, "@PurchaseDate", DbType.String, vobjProductPurchase.PurchaseDate.Trim());
dBase.AddInParameter(objCmd, "@ProductsPurchased", DbType.Xml, strProducts.ToString());
dBase.AddInParameter(objCmd, "@PurchasedQty", DbType.Xml, strSizes.ToString());
dBase.AddInParameter(objCmd, "@UpdatedBy", DbType.Int32, 1);
dBase.AddOutParameter(objCmd, "@MessageID", DbType.Int32, 4);
dBase.AddOutParameter(objCmd, "@Message", DbType.String, 255);
dBase.ExecuteNonQuery(objCmd);
vobjProductPurchase.ReturnValue = (int)dBase.GetParameterValue(objCmd, "@MessageID");
vobjProductPurchase.ReturnMessage = (string)dBase.GetParameterValue(objCmd, "@Message");
}
catch (Exception ex)
{
Common.LogError("CSWeb > Error > " + (new StackTrace()).GetFrame(0).GetMethod().Name, ex.ToString());
}
}