void BindPurchaseReceivedItem() { oblPurchaseReceivedItem = new Store.PurchaseReceivedItem.BusinessLogic.PurchaseReceivedItem(); try { objPurchaseReceivedItemList = oblPurchaseReceivedItem.GetAllPurchaseReceivedItemList(0, 0, ""); if (objPurchaseReceivedItemList != null) { dgvPurchaseItemReceived.DataSource = objPurchaseReceivedItemList; dgvPurchaseItemReceived.DataBind(); } else { dgvPurchaseItemReceived.DataSource = null; dgvPurchaseItemReceived.DataBind(); } } catch (Exception ex) { } finally { oblPurchaseReceivedItem = null; objPurchaseReceivedItemList = null; } }
protected void btnCheckOut_Click(object sender, EventArgs e) { try { string transid = ""; transid = insertReceived(txtSubTotal.Text, txtTax.Text, txtSHC.Text, txtMiscCost.Text, txttotal.Text); objPurchaseReceivedItemList = new Store.PurchaseReceivedItem.BusinessObject.PurchaseReceivedItemList(); for (int i = 0; i < Gridview1.Rows.Count; i++) { objPurchaseReceivedItem = new Store.PurchaseReceivedItem.BusinessObject.PurchaseReceivedItem(); 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 txtQuts = (TextBox)Gridview1.Rows[i].FindControl("txtQut"); TextBox txtTotals = (TextBox)Gridview1.Rows[i].FindControl("txtTotal"); objPurchaseReceivedItem.ItemPrefix = txtItemNames.Text; objPurchaseReceivedItem.Description = txtDecs.Text; objPurchaseReceivedItem.ItemPrice = Convert.ToDecimal(txtPrices.Text); objPurchaseReceivedItem.ItemUnit = txtQuts.Text; objPurchaseReceivedItem.TotalPrice = Convert.ToDecimal(txtTotals.Text); objPurchaseReceivedItem.PurchaseReceivedID = Convert.ToInt32(transid); objPurchaseReceivedItem.PurchaseOrderID = Convert.ToInt32(hfPOrder.Value); objPurchaseReceivedItemList.Add(objPurchaseReceivedItem); } oblPurchaseReceivedItem = new Store.PurchaseReceivedItem.BusinessLogic.PurchaseReceivedItem(); objMessageInfo = oblPurchaseReceivedItem.ManageItemMaster(objPurchaseReceivedItemList, cmdMode); reset(); } catch (Exception ex) { Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(PReceived).FullName, 1); } }
public Store.Common.MessageInfo ManageItemMaster(Store.PurchaseReceivedItem.BusinessObject.PurchaseReceivedItemList objPurchaseReceivedItemList, CommandMode cmdMode) { try { return(odlPurchaseReceivedItem.ManagePurchaseReceived(objPurchaseReceivedItemList, cmdMode)); } catch (Exception ex) { Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(PurchaseReceivedItem).FullName, 1); return(null); } }
public Store.Common.MessageInfo ManagePurchaseReceived(Store.PurchaseReceivedItem.BusinessObject.PurchaseReceivedItemList objPurchaseReceivedItemList, CommandMode cmdMode) { string SQL = ""; DataTableReader dr; Store.Common.MessageInfo objMessageInfo = null; try { // 'USP_PurchaseReceivedItem'. SQL = "USP_ManagePurchaseReceivedItem"; foreach (Store.PurchaseReceivedItem.BusinessObject.PurchaseReceivedItem objPurchaseReceivedItem in objPurchaseReceivedItemList) { ParameterList param = new ParameterList(); param.Add(new SQLParameter("@PurchaseItemReceivedID", objPurchaseReceivedItem.PurchaseItemReceivedID)); param.Add(new SQLParameter("@PurchaseReceivedID", objPurchaseReceivedItem.PurchaseReceivedID)); param.Add(new SQLParameter("@PurchaseOrderID", objPurchaseReceivedItem.PurchaseOrderID)); param.Add(new SQLParameter("@ItemPrefix", objPurchaseReceivedItem.ItemPrefix)); //param.Add(new SQLParameter("@ItemID", objPurchaseReceivedItem.ItemID)); //param.Add(new SQLParameter("@TotalPrice", objPurchaseReceivedItem.TotalPrice)); param.Add(new SQLParameter("@ItemUnit", objPurchaseReceivedItem.ItemUnit)); param.Add(new SQLParameter("@Description", objPurchaseReceivedItem.Description)); param.Add(new SQLParameter("@ItemPrice", objPurchaseReceivedItem.ItemPrice)); param.Add(new SQLParameter("@UserId", objPurchaseReceivedItem.CreatedBy)); param.Add(new SQLParameter("@ReferenceID", objPurchaseReceivedItem.ReferenceID)); param.Add(new SQLParameter("@IsActive", objPurchaseReceivedItem.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(PurchaseReceivedItem).FullName, 1); } return(objMessageInfo); }
Store.PurchaseReceivedItem.BusinessObject.PurchaseReceivedItemList BindPurchaseReceivedItem(int id) { try { oblPurchaseReceivedItem = new Store.PurchaseReceivedItem.BusinessLogic.PurchaseReceivedItem(); objPurchaseReceivedItemList = new Store.PurchaseReceivedItem.BusinessObject.PurchaseReceivedItemList(); objPurchaseReceivedItemList = oblPurchaseReceivedItem.GetAllPurchaseReceivedItemList(id, 0, ""); return(objPurchaseReceivedItemList); } catch (Exception ex) { //return null; throw ex; } finally { oblPurchaseReceivedItem = null; objPurchaseReceivedItemList = null; } }
public Store.PurchaseReceivedItem.BusinessObject.PurchaseReceivedItemList GetAllPurchaseReceivedItemList(int PurchaseItemReceivedID, int Flag, string FlagValue) { Store.PurchaseReceivedItem.BusinessObject.PurchaseReceivedItem objPurchaseReceivedItem = null; Store.PurchaseReceivedItem.BusinessObject.PurchaseReceivedItemList objPurchaseReceivedItemList = null; string SQL = string.Empty; ParameterList paramList = new ParameterList(); DataTableReader dr; try { SQL = "proc_PurchaseReceivedItem"; objPurchaseReceivedItemList = new BusinessObject.PurchaseReceivedItemList(); paramList.Add(new SQLParameter("@PurchaseItemReceivedID", PurchaseItemReceivedID)); paramList.Add(new SQLParameter("@Flag", Flag)); paramList.Add(new SQLParameter("@FlagValue", FlagValue)); dr = ExecuteQuery.ExecuteReader(SQL, paramList); while (dr.Read()) { objPurchaseReceivedItem = new BusinessObject.PurchaseReceivedItem(); if (dr.IsDBNull(dr.GetOrdinal("PurchaseItemReceivedID")) == false) { objPurchaseReceivedItem.PurchaseItemReceivedID = dr.GetInt32(dr.GetOrdinal("PurchaseItemReceivedID")); } if (dr.IsDBNull(dr.GetOrdinal("PurchaseOrderID")) == false) { objPurchaseReceivedItem.PurchaseOrderID = dr.GetInt32(dr.GetOrdinal("PurchaseOrderID")); } if (dr.IsDBNull(dr.GetOrdinal("PurchaseReceivedID")) == false) { objPurchaseReceivedItem.PurchaseReceivedID = dr.GetInt32(dr.GetOrdinal("PurchaseReceivedID")); } if (dr.IsDBNull(dr.GetOrdinal("ItemID")) == false) { objPurchaseReceivedItem.ItemID = dr.GetInt32(dr.GetOrdinal("ItemID")); } if (dr.IsDBNull(dr.GetOrdinal("ItemPrefix")) == false) { objPurchaseReceivedItem.ItemPrefix = dr.GetString(dr.GetOrdinal("ItemPrefix")); } if (dr.IsDBNull(dr.GetOrdinal("ItemUnit")) == false) { objPurchaseReceivedItem.ItemUnit = dr.GetString(dr.GetOrdinal("ItemUnit")); } if (dr.IsDBNull(dr.GetOrdinal("Description")) == false) { objPurchaseReceivedItem.Description = dr.GetString(dr.GetOrdinal("Description")); } if (dr.IsDBNull(dr.GetOrdinal("ItemPrice")) == false) { objPurchaseReceivedItem.ItemPrice = dr.GetDecimal(dr.GetOrdinal("ItemPrice")); } if (dr.IsDBNull(dr.GetOrdinal("ClientID")) == false) { objPurchaseReceivedItem.ClientID = dr.GetInt32(dr.GetOrdinal("ClientID")); } if (dr.IsDBNull(dr.GetOrdinal("CreatedBy")) == false) { objPurchaseReceivedItem.CreatedBy = dr.GetInt32(dr.GetOrdinal("CreatedBy")); } if (dr.IsDBNull(dr.GetOrdinal("CreatedOn")) == false) { objPurchaseReceivedItem.CreatedOn = dr.GetDateTime(dr.GetOrdinal("CreatedOn")); } if (dr.IsDBNull(dr.GetOrdinal("ModifiedBy")) == false) { objPurchaseReceivedItem.ModifiedBy = dr.GetInt32(dr.GetOrdinal("ModifiedBy")); } if (dr.IsDBNull(dr.GetOrdinal("ModifiedOn")) == false) { objPurchaseReceivedItem.ModifiedOn = dr.GetDateTime(dr.GetOrdinal("ModifiedOn")); } if (dr.IsDBNull(dr.GetOrdinal("ReferenceID")) == false) { objPurchaseReceivedItem.ReferenceID = dr.GetInt32(dr.GetOrdinal("ReferenceID")); } if (dr.IsDBNull(dr.GetOrdinal("IsActive")) == false) { objPurchaseReceivedItem.IsActive = dr.GetInt32(dr.GetOrdinal("IsActive")); } objPurchaseReceivedItemList.Add(objPurchaseReceivedItem); } dr.Close(); } catch (Exception ex) { Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(PurchaseReceivedItem).FullName, 1); } return(objPurchaseReceivedItemList); }