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); } }