void bindSalesItem(int id)
{
oblSalesItem = new Store.SalesOrderItem.BusinessLogic.SalesOrderItem();
try
{
objSalesItemList = oblSalesItem.GetAllSalesOrderItemList(id, 0, "");
if (objSalesItemList != null)
{
Gridview1.DataSource = objSalesItemList;
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(SalesRtn).FullName, 1);
}
finally
{
objSalesItemList = null;
}
}
void BindSalesOrderItem()
{
oblSalesOrderItem = new Store.SalesOrderItem.BusinessLogic.SalesOrderItem();
try
{
objSalesOrderItemlist = oblSalesOrderItem.GetAllSalesOrderItemList(0, 0, "");
if (objSalesOrderItemlist != null)
{
dgvSaleOrderItem.DataSource = objSalesOrderItemlist;
dgvSaleOrderItem.DataBind();
}
else
{
dgvSaleOrderItem.DataSource = null;
dgvSaleOrderItem.DataBind();
}
}
catch (Exception ex)
{
}
finally
{
oblSalesOrderItem = null;
objSalesOrderItemlist = null;
}
}
public Store.Common.MessageInfo ManageItemMaster(Store.SalesOrderItem.BusinessObject.SalesOrderItemList objSalesOrderItemList, CommandMode cmdMode)
{
try
{
return(odlSalesOrderItem.ManageSalesOrderItem(objSalesOrderItemList, cmdMode));
}
catch (Exception ex)
{
Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(SalesOrderItem).FullName, 1);
return(null);
}
}
Store.SalesOrderItem.BusinessObject.SalesOrderItemList BindSalesOrderItem(int id)
{
oblSalesOrderItem = new Store.SalesOrderItem.BusinessLogic.SalesOrderItem();
try
{
objSalesOrderItemList = oblSalesOrderItem.GetAllSalesOrderItemList(id, 0, "");
return(objSalesOrderItemList);
}
catch (Exception ex)
{
throw ex;
}
finally
{
oblSalesOrderItem = null;
objSalesOrderItemList = null;
}
}
public Store.Common.MessageInfo ManageSalesOrderItem(Store.SalesOrderItem.BusinessObject.SalesOrderItemList objSalesOrderItemList, CommandMode cmdMode)
{
string SQL = "";
Store.Common.MessageInfo objMessageInfo = null;
try
{
SQL = "USP_ManageSalesItem";
foreach (Store.SalesOrderItem.BusinessObject.SalesOrderItem objSalesOrderItem in objSalesOrderItemList)
{
ParameterList param = new ParameterList();
DataTableReader dr;
param.Add(new SQLParameter("@SaleOrderItemID", objSalesOrderItem.SaleOrderItemID));
param.Add(new SQLParameter("@SalesOrderID", objSalesOrderItem.SalesOrderID));
param.Add(new SQLParameter("@ItemId", objSalesOrderItem.ItemId));
param.Add(new SQLParameter("@ItemPrefix", objSalesOrderItem.ItemPrefix));
param.Add(new SQLParameter("@ItemUnit", objSalesOrderItem.ItemUnit));
param.Add(new SQLParameter("@Description", objSalesOrderItem.Description));
param.Add(new SQLParameter("@ItemCostPrice", objSalesOrderItem.ItemCostPrice));
param.Add(new SQLParameter("@ItemSalePrice", objSalesOrderItem.ItemSalePrice));
param.Add(new SQLParameter("@ItemDiscountPercentage", objSalesOrderItem.ItemDiscountPercentage));
param.Add(new SQLParameter("@ItemDiscount", objSalesOrderItem.ItemDiscount));
param.Add(new SQLParameter("@IsActive", objSalesOrderItem.IsActive));
param.Add(new SQLParameter("@ReferenceID", objSalesOrderItem.ReferenceID));
param.Add(new SQLParameter("@UserId", objSalesOrderItem.CreatedBy));
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(SalesOrderItem).FullName, 1);
}
return(objMessageInfo);
}
protected void btnCheckOut_Click(object sender, EventArgs e)
{
try
{
string transid = "";
transid = insertSalesOrder(txtCPSubTotal.Text, txtSPSubTotal.Text, txtDicPre.Text, txtDic.Text, txtTax.Text, txtSHC.Text, txtMiscCost.Text, txttotal.Text);
objSalesOrderItemList = new Store.SalesOrderItem.BusinessObject.SalesOrderItemList();
for (int i = 0; i < Gridview1.Rows.Count - 1; i++)
{
objsalesOrderItem = new Store.SalesOrderItem.BusinessObject.SalesOrderItem();
TextBox txtItemNames = (TextBox)Gridview1.Rows[i].FindControl("txtItemName");
if (txtItemNames.Text == "")
{
break;
}
TextBox txtDecs = (TextBox)Gridview1.Rows[i].FindControl("txtDec");
TextBox txtCPrices = (TextBox)Gridview1.Rows[i].FindControl("txtCPrice");
TextBox txtSPrices = (TextBox)Gridview1.Rows[i].FindControl("txtSPrice");
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");
objsalesOrderItem.ItemPrefix = txtItemNames.Text;
objsalesOrderItem.Description = txtDecs.Text;
objsalesOrderItem.ItemCostPrice = Convert.ToDecimal(txtCPrices.Text);
objsalesOrderItem.ItemSalePrice = Convert.ToDecimal(txtSPrices.Text);
objsalesOrderItem.ItemDiscountPercentage = Convert.ToDecimal(txtDisPres.Text);
objsalesOrderItem.ItemDiscount = Convert.ToDecimal(txtDiss.Text);
objsalesOrderItem.ItemUnit = txtQuts.Text;
objsalesOrderItem.TotalPrice = Convert.ToDecimal(txtTotals.Text);
objsalesOrderItem.SalesOrderID = Convert.ToInt32(transid);
//objPurchaseOrderItemList.Add(objPurchaseOrderItem);
objSalesOrderItemList.Add(objsalesOrderItem);
}
oblSalesOrderItem = new Store.SalesOrderItem.BusinessLogic.SalesOrderItem();
objMessageInfo = oblSalesOrderItem.ManageItemMaster(objSalesOrderItemList, cmdMode);
reset();
}
catch (Exception ex)
{ Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(SaleOrder).FullName, 1); }
}