void BindPurchaseOrderItem(int id)
{
oblPurchaseOrderItem = new Store.PurchaseOrderItem.BusinessLogic.PurchaseOrderItem();
try
{
objPurchaseOrderItemList = oblPurchaseOrderItem.GetAllPurchaseOrderItemList(id, 0, "");
if (objPurchaseOrderItemList != null)
{
Gridview1.DataSource = objPurchaseOrderItemList;
Gridview1.DataBind();
}
else
{
Gridview1.DataSource = null;
Gridview1.DataBind();
}
}
catch (Exception ex)
{
Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(PReceived).FullName, 1);
}
finally
{
oblPurchaseOrderItem = null;
objPurchaseOrderItemList = null;
}
}
void BindPurchaseOrderItem()
{
oblPurchaseOrderItem = new Store.PurchaseOrderItem.BusinessLogic.PurchaseOrderItem();
try
{
objPurchaseOrderItemList = oblPurchaseOrderItem.GetAllPurchaseOrderItemList(0, 0, "");
if (objPurchaseOrderItemList != null)
{
dgvPurchaseItemOrder.DataSource = objPurchaseOrderItemList;
dgvPurchaseItemOrder.DataBind();
}
else
{
dgvPurchaseItemOrder.DataSource = null;
dgvPurchaseItemOrder.DataBind();
}
}
catch (Exception ex)
{
}
finally
{
oblPurchaseOrderItem = null;
objPurchaseOrderItemList = null;
}
}
public Store.PurchaseOrderItem.BusinessObject.PurchaseOrderItemList GetAllPurchaseOrderItemList(int PurchaseOrderItemID, int Flag, string FlagValue)
{
Store.PurchaseOrderItem.BusinessObject.PurchaseOrderItem objPurchaseOrderItem = null;
Store.PurchaseOrderItem.BusinessObject.PurchaseOrderItemList objPurchaseOrderItemList = null;
string SQL = string.Empty;
ParameterList paramList = new ParameterList();
DataTableReader dr;
try
{
objPurchaseOrderItemList = new BusinessObject.PurchaseOrderItemList();
SQL = "proc_PurchaseOrderItem";
paramList.Add(new SQLParameter("@PurchaseOrderItemID", PurchaseOrderItemID));
paramList.Add(new SQLParameter("@Flag", Flag));
paramList.Add(new SQLParameter("@FlagValue", FlagValue));
dr = ExecuteQuery.ExecuteReader(SQL, paramList);
while (dr.Read())
{
objPurchaseOrderItem = new BusinessObject.PurchaseOrderItem();
if (dr.IsDBNull(dr.GetOrdinal("ItemID")) == false)
{
objPurchaseOrderItem.ItemID = dr.GetInt32(dr.GetOrdinal("ItemID"));
}
if (dr.IsDBNull(dr.GetOrdinal("ItemPrefix")) == false)
{
objPurchaseOrderItem.ItemPrefix = dr.GetString(dr.GetOrdinal("ItemPrefix"));
}
if (dr.IsDBNull(dr.GetOrdinal("ItemUnit")) == false)
{
objPurchaseOrderItem.ItemUnit = dr.GetString(dr.GetOrdinal("ItemUnit"));
}
if (dr.IsDBNull(dr.GetOrdinal("Description")) == false)
{
objPurchaseOrderItem.Description = dr.GetString(dr.GetOrdinal("Description"));
}
if (dr.IsDBNull(dr.GetOrdinal("ItemPrice")) == false)
{
objPurchaseOrderItem.ItemPrice = dr.GetDecimal(dr.GetOrdinal("ItemPrice"));
}
if (dr.IsDBNull(dr.GetOrdinal("TotalPrice")) == false)
{
objPurchaseOrderItem.TotalPrice = dr.GetDecimal(dr.GetOrdinal("TotalPrice"));
}
objPurchaseOrderItemList.Add(objPurchaseOrderItem);
}
dr.Close();
}
catch (Exception ex)
{
Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(PurchaseOrderItem).FullName, 1);
}
return(objPurchaseOrderItemList);
}
public Store.Common.MessageInfo ManageItemMaster(Store.PurchaseOrderItem.BusinessObject.PurchaseOrderItemList objPurchaseOrderItemList, CommandMode cmdMode)
{
try
{
return(odlPurchaseOrderItem.ManagePurchaseOrder(objPurchaseOrderItemList, cmdMode));
}
catch (Exception ex)
{
Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(PurchaseOrderItem).FullName, 1);
return(null);
}
}
public Store.Common.MessageInfo ManagePurchaseOrder(Store.PurchaseOrderItem.BusinessObject.PurchaseOrderItemList objPurchaseOrderItemlist, CommandMode cmdMode)
{
string SQL = "";
ParameterList param = null;
Store.Common.MessageInfo objMessageInfo = null;
try
{
SQL = "USP_ManagePurchaseOrderItem";
foreach (Store.PurchaseOrderItem.BusinessObject.PurchaseOrderItem objPurchaseOrderItem in objPurchaseOrderItemlist)
{
param = new ParameterList();
DataTableReader dr;
param.Add(new SQLParameter("@PurchaseOrderID", objPurchaseOrderItem.PurchaseOrderID));
param.Add(new SQLParameter("@PurchaseOrderItemID", objPurchaseOrderItem.PurchaseOrderItemID));
param.Add(new SQLParameter("@ItemID", objPurchaseOrderItem.ItemID));
param.Add(new SQLParameter("@ItemPrefix", objPurchaseOrderItem.ItemPrefix));
param.Add(new SQLParameter("@Description", objPurchaseOrderItem.Description));
param.Add(new SQLParameter("@ItemUnit", objPurchaseOrderItem.ItemUnit));
param.Add(new SQLParameter("@ItemPrice", objPurchaseOrderItem.ItemPrice));
param.Add(new SQLParameter("@TotalPrice", objPurchaseOrderItem.TotalPrice));
param.Add(new SQLParameter("@Discount", objPurchaseOrderItem.Discount));
param.Add(new SQLParameter("@DiscountPre", objPurchaseOrderItem.DiscountPre));
param.Add(new SQLParameter("@UserId", objPurchaseOrderItem.CreatedBy));
param.Add(new SQLParameter("@ReferenceID", objPurchaseOrderItem.ReferenceID));
param.Add(new SQLParameter("@IsActive", objPurchaseOrderItem.IsActive));
param.Add(new SQLParameter("@CMDMode", cmdMode));
dr = ExecuteQuery.ExecuteReader(SQL, param);
if (dr.Read())
{
objMessageInfo = new Store.Common.MessageInfo();
objMessageInfo.ErrorCode = Convert.ToInt32(dr["ErrorCode"]);
objMessageInfo.ErrorMessage = Convert.ToString(dr["ErrorMessage"]);
objMessageInfo.TranID = Convert.ToInt32(dr["TranID"]);
objMessageInfo.TranCode = Convert.ToString(dr["TranCode"]);
objMessageInfo.TranMessage = Convert.ToString(dr["TranMessage"]);
}
}
}
catch (Exception ex)
{
Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(PurchaseOrderItem).FullName, 1);
}
return(objMessageInfo);
}
Store.PurchaseOrderItem.BusinessObject.PurchaseOrderItemList BindPurchaseOrderItem(int id)
{
oblPurchaseOrderItem = new Store.PurchaseOrderItem.BusinessLogic.PurchaseOrderItem();
try
{
objPurchaseOrderItemList = oblPurchaseOrderItem.GetAllPurchaseOrderItemList(id, 0, "");
return(objPurchaseOrderItemList);
}
catch (Exception ex)
{
return(null);
}
finally
{
oblPurchaseOrderItem = null;
objPurchaseOrderItemList = null;
}
}
protected void btnCheckOut_Click(object sender, EventArgs e)
{
try
{
string transid = "";
transid = insertOrder(txtSubTotal.Text, txtDicPre.Text, txtDic.Text, txtTax.Text, txtSHC.Text, txtMiscCost.Text, txttotal.Text);
objPurchaseOrderItemList = new Store.PurchaseOrderItem.BusinessObject.PurchaseOrderItemList();
for (int i = 0; i < Gridview1.Rows.Count - 1; i++)
{
objPurchaseOrderItem = new Store.PurchaseOrderItem.BusinessObject.PurchaseOrderItem();
TextBox txtItemNames = (TextBox)Gridview1.Rows[i].FindControl("txtItemName");
if (txtItemNames.Text == "")
break;
TextBox txtDecs = (TextBox)Gridview1.Rows[i].FindControl("txtDec");
TextBox txtPrices = (TextBox)Gridview1.Rows[i].FindControl("txtPrice");
TextBox txtDisPres = (TextBox)Gridview1.Rows[i].FindControl("txtDisPre");
TextBox txtDiss = (TextBox)Gridview1.Rows[i].FindControl("txtDis");
TextBox txtQuts = (TextBox)Gridview1.Rows[i].FindControl("txtQut");
TextBox txtTotals = (TextBox)Gridview1.Rows[i].FindControl("txtTotal");
objPurchaseOrderItem.ItemPrefix = txtItemNames.Text;
objPurchaseOrderItem.Description = txtDecs.Text;
objPurchaseOrderItem.ItemPrice = Convert.ToDecimal(txtPrices.Text);
objPurchaseOrderItem.DiscountPre = Convert.ToDecimal(txtDisPres.Text);
objPurchaseOrderItem.Discount = Convert.ToDecimal(txtDiss.Text);
objPurchaseOrderItem.ItemUnit = txtQuts.Text;
objPurchaseOrderItem.TotalPrice = Convert.ToDecimal(txtTotals.Text);
objPurchaseOrderItem.PurchaseOrderID = Convert.ToInt32(transid);
objPurchaseOrderItemList.Add(objPurchaseOrderItem);
}
oblPurchaseOrderItem = new Store.PurchaseOrderItem.BusinessLogic.PurchaseOrderItem();
objMessageInfo = oblPurchaseOrderItem.ManageItemMaster(objPurchaseOrderItemList, cmdMode);
reset();
}
catch (Exception ex)
{ Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(POrder).FullName, 1); }
}
