private void LoadData(int vintPurchaseID)
{
try
{
ProductPurchase objProductPurchase = new ProductPurchase();
objProductPurchase.ProductPurchaseID = vintPurchaseID;
new ProductPurchaseBLL().GetByID(ref objProductPurchase);
if (0 != objProductPurchase.ProductID)
{
ddlProduct.SelectedValue = objProductPurchase.ProductID.ToString();
ddlManufacturer.SelectedValue = objProductPurchase.ManufacturerID.ToString();
//ddlSize.SelectedValue = objProductPurchase.SizeID.ToString();
txtQuantity.Text = objProductPurchase.Quantity.ToString();
//txtPrice.Text = objProductPurchase.Price.ToString("#.##");
txtDateOfPurchase.Value = objProductPurchase.PurchaseDate;
ScriptManager.RegisterStartupScript(this, this.GetType(), "AddEditProductPurchase", "ChangeDatePicker();ShowModalDiv('ModalWindow1','dvInnerWindow',0);", true);
}
}
catch (Exception ex)
{
SendMail.MailMessage("CSWeb > Error > " + (new StackTrace()).GetFrame(0).GetMethod().Name, ex.ToString());
}
}
public void UpdateProductPrice(ref ProductPurchase vobjProductPurchase)
{
new ProductPurchaseDB().UpdateProductPrice(ref vobjProductPurchase);
}
protected void gvGrid_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
if (e.CommandName == "Print")
{
int intPurchaseID = Convert.ToInt32(e.CommandArgument.ToString());
vstrLink = "BarcodePrint.aspx?q=" + intPurchaseID.ToString();
Response.Redirect(vstrLink, false);
}
if (e.CommandName == "Edit")
{
int intPurchaseID = Convert.ToInt32(e.CommandArgument.ToString());
param = Constants.MODE + "=" + Constants.MODE_EDIT + "&" + Constants.ID + "=" + intPurchaseID;
param = Common.GenerateBASE64WithObfuscateApp(param);
vstrLink = "AddEditProductPurchase.aspx?q=" + param;
Response.Redirect(vstrLink, false);
//ViewState["intPurchaseID"] = intPurchaseID;
//LoadData(intPurchaseID);
}
if (e.CommandName == "Delete")
{
ProductPurchase objProductPurchase = new ProductPurchase();
int intPurchaseID = Convert.ToInt32(e.CommandArgument.ToString());
objProductPurchase.ProductPurchaseID = intPurchaseID;
new ProductPurchaseBLL().Delete(ref objProductPurchase);
if (objProductPurchase.ReturnStatus > 0)
{
divMess.Visible = true;
lblMsg.Text = Constants.Deleted;
divMess.Attributes.Add("class", "Deleted");
lblMsg.Style.Add("color", "Black");
}
else
{
divMess.Visible = true;
lblMsg.Style.Add("color", "Red");
divMess.Attributes.Add("class", "error");
lblMsg.Text = objProductPurchase.ReturnMessage;
}
}
}
catch (Exception ex)
{
SendMail.MailMessage("CSWeb > Error > " + (new StackTrace()).GetFrame(0).GetMethod().Name, ex.ToString());
}
}
public void AddEditPurchase(ref ProductPurchase vobjProductPurchase)
{
new ProductPurchaseDB().AddEditPurchase(ref vobjProductPurchase);
}
/*public void Add(ref ProductPurchase vobjProductPurchase)
{
new ProductPurchaseDB().Add(ref vobjProductPurchase);
}
public void Update(ref ProductPurchase vobjProductPurchase)
{
new ProductPurchaseDB().Update(ref vobjProductPurchase);
}*/
public void Delete(ref ProductPurchase vobjProductPurchase)
{
new ProductPurchaseDB().Delete(ref vobjProductPurchase);
}
/*
public void Add(ref ProductPurchase vobjProductPurchase)
{
try
{
DbCommand objCmd = dBase.GetStoredProcCommand("sprocCS_InsertProductPurchase");
dBase.AddInParameter(objCmd, "@ManufacturerID", DbType.Int32, vobjProductPurchase.ManufacturerID);
dBase.AddInParameter(objCmd, "@PurchaseDate", DbType.DateTime, vobjProductPurchase.PurchaseDate);
dBase.AddInParameter(objCmd, "@ProductID", DbType.Int32, vobjProductPurchase.ProductID);
dBase.AddInParameter(objCmd, "@SizeID", DbType.Int32, vobjProductPurchase.SizeID);
dBase.AddInParameter(objCmd, "@Quantity", DbType.Int32, vobjProductPurchase.Quantity);
dBase.AddInParameter(objCmd, "@Price", DbType.Decimal, vobjProductPurchase.Price);
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());
}
}
public void Update(ref ProductPurchase vobjProductPurchase)
{
try
{
DbCommand objCmd = dBase.GetStoredProcCommand("sprocCS_UpdateProductPurchase");
dBase.AddInParameter(objCmd, "@PurchaseID", DbType.Int32, vobjProductPurchase.ManufacturerID);
dBase.AddInParameter(objCmd, "@ManufacturerID", DbType.Int32, vobjProductPurchase.ManufacturerID);
dBase.AddInParameter(objCmd, "@PurchaseDate", DbType.DateTime, vobjProductPurchase.PurchaseDate);
dBase.AddInParameter(objCmd, "@ProductID", DbType.Int32, vobjProductPurchase.ProductID);
dBase.AddInParameter(objCmd, "@SizeID", DbType.Int32, vobjProductPurchase.SizeID);
dBase.AddInParameter(objCmd, "@Quantity", DbType.Int32, vobjProductPurchase.Quantity);
dBase.AddInParameter(objCmd, "@Price", DbType.Decimal, vobjProductPurchase.Price);
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());
}
}
*/
public void Delete(ref ProductPurchase vobjProductPurchase)
{
try
{
DbCommand objCmd = dBase.GetStoredProcCommand("sprocCS_DeleteProductPurchase");
dBase.AddInParameter(objCmd, "@PurchaseID", DbType.Int32, vobjProductPurchase.ProductPurchaseID);
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());
}
}
public void GetByID(ref ProductPurchase vobjProductPurchase)
{
new ProductPurchaseDB().GetByID(ref vobjProductPurchase);
}
public void AddEditPurchase(ref ProductPurchase vobjProductPurchase)
{
try
{
DbCommand objCmd = dBase.GetStoredProcCommand("sprocCS_InsertUpdateProductPurchase");
dBase.AddInParameter(objCmd, "@ProductPurchaseID", DbType.Int32, vobjProductPurchase.ProductPurchaseID);
dBase.AddInParameter(objCmd, "@ProductID", DbType.Int32, vobjProductPurchase.ProductID);
dBase.AddInParameter(objCmd, "@ManufacturerID", DbType.Int32, vobjProductPurchase.ManufacturerID);
dBase.AddInParameter(objCmd, "@BrandID", DbType.Int32, vobjProductPurchase.BrandID);
dBase.AddInParameter(objCmd, "@CategoryID", DbType.Int32, vobjProductPurchase.CategoryID);
dBase.AddInParameter(objCmd, "@SeasonID", DbType.Int32, vobjProductPurchase.SeasonID);
dBase.AddInParameter(objCmd, "@PurchaseDate", DbType.String, vobjProductPurchase.PurchaseDate);
dBase.AddInParameter(objCmd, "@Quantity", DbType.Int32, vobjProductPurchase.Quantity);
dBase.AddInParameter(objCmd, "@BuyingPrice", DbType.Decimal, vobjProductPurchase.BuyingPrice);
dBase.AddInParameter(objCmd, "@Tax", DbType.Decimal, vobjProductPurchase.Tax);
dBase.AddInParameter(objCmd, "@Margin", DbType.Decimal, vobjProductPurchase.Margin);
dBase.AddInParameter(objCmd, "@SellingPrice", DbType.Decimal, vobjProductPurchase.SellingPrice);
dBase.AddInParameter(objCmd, "@BarCode", DbType.String, vobjProductPurchase.BarCode);
dBase.AddInParameter(objCmd, "@SizeIDs", DbType.Xml, vobjProductPurchase.SizeIDs);
dBase.AddInParameter(objCmd, "@UpdatedBy", DbType.Int32, vobjProductPurchase.UpdatedBy);
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());
}
}
public List<ProductPurchase> GetAll(String purchaseStartDate, String purchaseEndDate, String ManufacturerName, PageInfo vobjPageInfo)
{
List<ProductPurchase> lstProductPurshase = new List<ProductPurchase>();
try
{
object[] mParams = {
new SqlParameter("@PurchaseStartDate", SqlDbType.VarChar),
new SqlParameter("@PurchaseEndDate", SqlDbType.VarChar),
new SqlParameter("@CompanyName", SqlDbType.NVarChar),
new SqlParameter("@SortColumnName", SqlDbType.NVarChar),
new SqlParameter("@SortDirection", SqlDbType.NVarChar),
new SqlParameter("@SearchText", SqlDbType.NVarChar)
};
mParams[0] = purchaseStartDate;
mParams[1] = purchaseEndDate;
mParams[2] = ManufacturerName;
mParams[3] = vobjPageInfo.SortColumnName;
mParams[4] = vobjPageInfo.SortDirection;
mParams[5] = vobjPageInfo.SearchText;
using (IDataReader reader = dBase.ExecuteReader("sprocCS_GetAllProductPurchase", mParams))
{
while (reader.Read())
{
ProductPurchase objProductPurchase = new ProductPurchase();
if (reader["PurchaseID"] != DBNull.Value)
objProductPurchase.ProductPurchaseID = Convert.ToInt32(reader["PurchaseID"]);
if (reader["ProductPurchaseID"] != DBNull.Value)
objProductPurchase.ProductPurchaseDetailID = Convert.ToInt32(reader["ProductPurchaseID"]);
if (reader["PurchaseDate"] != DBNull.Value)
objProductPurchase.PurchaseDate = Convert.ToDateTime(reader["PurchaseDate"]).ToShortDateString();
if (reader["PurchaseDate"] != DBNull.Value)
objProductPurchase.ProductPurchaseDate = Convert.ToDateTime(reader["PurchaseDate"]);
if (reader["CompanyName"] != DBNull.Value)
objProductPurchase.ManufacturerName = Convert.ToString(reader["CompanyName"]);
if (reader["ProductName"] != DBNull.Value)
objProductPurchase.ProductName = Convert.ToString(reader["ProductName"]);
if (reader["Sizes"] != DBNull.Value)
objProductPurchase.Sizes = Convert.ToString(reader["Sizes"]);
if (reader["Quantity"] != DBNull.Value)
objProductPurchase.Quantity = Convert.ToInt32(reader["Quantity"]);
if (reader["BuyingPrice"] != DBNull.Value)
objProductPurchase.BuyingPrice = Convert.ToDecimal(reader["BuyingPrice"]);
if (reader["Margin"] != DBNull.Value)
objProductPurchase.Margin = Convert.ToDecimal(reader["Margin"]);
if (reader["Tax"] != DBNull.Value)
objProductPurchase.Tax = Convert.ToDecimal(reader["Tax"]);
if (reader["Price"] != DBNull.Value)
objProductPurchase.SellingPrice = Convert.ToDecimal(reader["Price"]);
lstProductPurshase.Add(objProductPurchase);
}
}
}
catch (Exception ex)
{
Common.LogError("CSWeb > Error > " + (new StackTrace()).GetFrame(0).GetMethod().Name, ex.ToString());
}
return lstProductPurshase;
}
public void GetByID(ref ProductPurchase vobjProductPurchase)
{
try
{
object[] mParams = {
new SqlParameter("@ProductPurchaseID", SqlDbType.Int)
};
mParams[0] = vobjProductPurchase.ProductPurchaseID;
using (IDataReader reader = dBase.ExecuteReader("sprocCS_GetProductPurchaseByID", mParams))
{
while (reader.Read())
{
if (reader["ProductPurchaseID"] != DBNull.Value)
vobjProductPurchase.ProductPurchaseID = Convert.ToInt32(reader["ProductPurchaseID"]);
if (reader["ProductID"] != DBNull.Value)
vobjProductPurchase.ProductID = Convert.ToInt32(reader["ProductID"]);
if (reader["ManufacturerID"] != DBNull.Value)
vobjProductPurchase.ManufacturerID = Convert.ToInt32(reader["ManufacturerID"]);
if (reader["BrandID"] != DBNull.Value)
vobjProductPurchase.BrandID = Convert.ToInt32(reader["BrandID"]);
if (reader["CategoryID"] != DBNull.Value)
vobjProductPurchase.CategoryID = Convert.ToInt32(reader["CategoryID"]);
if (reader["SeasonID"] != DBNull.Value)
vobjProductPurchase.SeasonID = Convert.ToInt32(reader["SeasonID"]);
if (reader["PurchaseDate"] != DBNull.Value)
vobjProductPurchase.PurchaseDate = Convert.ToDateTime(reader["PurchaseDate"]).ToString("dd/MM/yyyy");
if (reader["Quantity"] != DBNull.Value)
vobjProductPurchase.Quantity = Convert.ToInt32(reader["Quantity"]);
if (reader["BuyingPrice"] != DBNull.Value)
vobjProductPurchase.BuyingPrice = Convert.ToDecimal(reader["BuyingPrice"]);
if (reader["Tax"] != DBNull.Value)
vobjProductPurchase.Tax = Convert.ToDecimal(reader["Tax"]);
if (reader["Margin"] != DBNull.Value)
vobjProductPurchase.Margin = Convert.ToDecimal(reader["Margin"]);
if (reader["SellingPrice"] != DBNull.Value)
vobjProductPurchase.SellingPrice = Convert.ToDecimal(reader["SellingPrice"]);
if (reader["BarCode"] != DBNull.Value)
vobjProductPurchase.BarCode = Convert.ToString(reader["BarCode"]);
if (reader["SizeIDs"] != DBNull.Value)
vobjProductPurchase.SizeIDs = Convert.ToString(reader["SizeIDs"]);
}
}
}
catch (Exception ex)
{
Common.LogError("CSWeb > Error > " + (new StackTrace()).GetFrame(0).GetMethod().Name, ex.ToString());
}
}
private void PopulateData(int vintProductPurchaseID)
{
ProductPurchase objProductPurshase = new ProductPurchase();
objProductPurshase.ProductPurchaseID = vintProductPurchaseID;
new ProductPurchaseBLL().GetByID(ref objProductPurshase);
txtProductPurchaseID.Value = objProductPurshase.ProductPurchaseID.ToString();
txtDateOfPurchase.Value = objProductPurshase.PurchaseDate;
cmbManufacturer.SelectedValue = objProductPurshase.ManufacturerID.ToString();
cmbProduct.SelectedValue = objProductPurshase.ProductID.ToString();
txtBarcode.Text = objProductPurshase.BarCode;
cmbBrand.SelectedValue = objProductPurshase.BrandID.ToString();
cmbCategory.SelectedValue = objProductPurshase.CategoryID.ToString();
cmbSeason.SelectedValue = objProductPurshase.SeasonID.ToString();
txtBuyingPrice.Text = objProductPurshase.BuyingPrice.ToString("F2");
txtTax.Text = objProductPurshase.Tax.ToString("F2");
txtMargin.Text = objProductPurshase.Margin.ToString("F2");
txtSellingPrice.Text = objProductPurshase.SellingPrice.ToString("F2");
txtQuantity.Text = objProductPurshase.Quantity.ToString();
if (! String.IsNullOrEmpty(objProductPurshase.SizeIDs))
{
string[] arrSizeIDs = objProductPurshase.SizeIDs.Split(',');
for (int i = 0; i < arrSizeIDs.Length; i++)
{
cmbSizes.SelectedValue = arrSizeIDs[i];
//for (int j =0; j< chkSize.Items.Count; j++)
//{
// if (chkSize.Items[j].Value.Equals(arrSizeIDs[i]))
// {
// chkSize.Items[j].Selected = true;
// }
//}
}
}
}
protected void lnkBtnSaveDS_Click(object sender, EventArgs e)
{
ProductPurchase objProductPurchase = new ProductPurchase();
objProductPurchase.ProductPurchaseID = Convert.ToInt32(txtProductPurchaseID.Value);
objProductPurchase.ProductID = Convert.ToInt32(cmbProduct.SelectedValue);
objProductPurchase.ManufacturerID = Convert.ToInt32(cmbManufacturer.SelectedValue);
objProductPurchase.BrandID = Convert.ToInt32(cmbBrand.SelectedValue);
objProductPurchase.CategoryID = Convert.ToInt32(cmbCategory.SelectedValue);
objProductPurchase.SeasonID = Convert.ToInt32(cmbSeason.SelectedValue);
objProductPurchase.PurchaseDate =txtDateOfPurchase.Value;
objProductPurchase.Quantity = Convert.ToInt32(txtQuantity.Text);
objProductPurchase.BuyingPrice = Convert.ToDecimal(txtBuyingPrice.Text);
objProductPurchase.Tax = Convert.ToDecimal(txtTax.Text);
objProductPurchase.Margin = Convert.ToDecimal(txtMargin.Text);
objProductPurchase.SellingPrice = Convert.ToDecimal(txtSellingPrice.Text);
objProductPurchase.BarCode = txtBarcode.Text.Trim();
objProductPurchase.Quantity = Convert.ToInt32(txtQuantity.Text);
string strSizeIDs = "<data>";
//foreach (ListItem lstSizeIDs in chkSize.Items)
//{
// if (lstSizeIDs.Selected == true)
// {
// strSizeIDs += "<sizes><SizeID>" + lstSizeIDs.Value + "</SizeID></sizes>";
// }
//}
strSizeIDs += "<sizes><SizeID>" + cmbSizes.SelectedValue + "</SizeID></sizes>";
strSizeIDs += "</data>";
objProductPurchase.SizeIDs = strSizeIDs;
new ProductPurchaseBLL().AddEditPurchase(ref objProductPurchase);
if (objProductPurchase.ReturnValue > 0)
{
Response.Redirect("BuyingInterface.aspx", false);
}
else
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('" + objProductPurchase.ReturnMessage + "');", true);
}
}
