void BindSalesOrder() { oblSalesOrder = new Store.SalesOrder.BusinessLogic.SalesOrder(); try { objSalesList = oblSalesOrder.GetAllSalesOrderList(0, 0, ""); if (objSalesList != null) { gvSOrder.DataSource = objSalesList; gvSOrder.DataBind(); } else { gvSOrder.DataSource = null; gvSOrder.DataBind(); } } catch (Exception ex) { throw ex; } finally { oblSalesOrder = null; objSalesOrderList = null; } }
public string insertSalesOrder(string cpsubtotal, string spsubtotal, string dicpre, string dic, string tax, string shc, string misccost, string ttotal) { oblSalesOrder = new Store.SalesOrder.BusinessLogic.SalesOrder(); //oblPurchaseOrder = new Store.PurchaseOrder.BusinessLogic.PurchaseOrder(); objMessageInfo = new MessageInfo(); objSalesOrder = new Store.SalesOrder.BusinessObject.SalesOrder(); //objPurchaseOrder = new Store.PurchaseOrder.BusinessObject.PurchaseOrder(); if (cmdMode == Store.Common.CommandMode.M) { objSalesOrder.SalesOrderID = Convert.ToInt32(hfPId.Value); // objPurchaseOrder.PurchaseOrderID = Convert.ToInt32(hfPId.Value);//PurchaseOrderID which edit from data grid } else { objSalesOrder.SalesOrderID = 0; //objPurchaseOrder.PurchaseOrderID = 0; } objSalesOrder.SalesOrderID = 0; objSalesOrder.VendorID = Convert.ToInt32(hfVendor.Value); objSalesOrder.TotalCostAmount = Convert.ToDecimal(cpsubtotal); objSalesOrder.TotalSaleAmount = Convert.ToDecimal(spsubtotal); objSalesOrder.TotalTaxValue = Convert.ToDecimal(tax); objSalesOrder.ShipingAndHandlingCost = Convert.ToDecimal(shc); objSalesOrder.MiscSaleAmount = Convert.ToDecimal(misccost); objSalesOrder.DiscountPer = Convert.ToDecimal(dicpre); objSalesOrder.Discount = Convert.ToDecimal(dic); objSalesOrder.IsActive = 1; objMessageInfo = oblSalesOrder.ManageSaleOrder(objSalesOrder, cmdMode); return(objMessageInfo.TranID.ToString()); }
void bindSales(int id) { oblSales = new Store.SalesOrder.BusinessLogic.SalesOrder(); try { objSales = oblSales.GetAllSalesOrder(id, 0, ""); if (objSales != null) { txtSubTotal.Text = objSales.TotalSaleAmount.ToString(); txtTax.Text = objSales.TotalTaxValue.ToString(); txtSHC.Text = objSales.ShipingAndHandlingCost.ToString(); txtMiscCost.Text = objSales.MiscSaleAmount.ToString(); } else { txtSubTotal.Text = ""; txtTax.Text = ""; txtSHC.Text = ""; } txtMiscCost.Text = ""; } catch (Exception ex) { Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(SalesRtn).FullName, 1); } finally { oblSales = null; objSales = null; } }
public Store.Common.MessageInfo ManageSaleOrder(Store.SalesOrder.BusinessObject.SalesOrder objSalesOrder, CommandMode cmdMode) { try { return(odlSalesOrder.ManageSalesOrder(objSalesOrder, cmdMode)); } catch (Exception ex) { Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(SalesOrder).FullName, 1); return(null); } }
void ManageSalesOrder() { objSalesOrder = new Store.SalesOrder.BusinessObject.SalesOrder(); odlSalesOrder = new Store.SalesOrder.BusinessLogic.SalesOrder(); try { if (cmdMode == Store.Common.CommandMode.M) { objSalesOrder.SalesOrderID = Convert.ToInt32(txtSalesOrderID.Text); } else { objSalesOrder.SalesOrderID = 0; } objSalesOrder.VendorID = Convert.ToInt16(ddlVendor.SelectedItem.Value); DateTime date = DateTime.Parse(txtSDate.Text); objSalesOrder.SaleDate = date; objSalesOrder.TotalCostAmount = Convert.ToDecimal(txtTotalCostAmount.Text); objSalesOrder.TotalSaleAmount = Convert.ToDecimal(txtTotalSaleAmount.Text); objSalesOrder.TotalDiscountAmount = Convert.ToDecimal(txtTotalDiscountAmount.Text); objSalesOrder.TotalTaxValue = Convert.ToDecimal(txtTaxValue.Text); objSalesOrder.ShipingAndHandlingCost = Convert.ToDecimal(txtSHCost.Text); objSalesOrder.MiscSaleAmount = Convert.ToDecimal(txtMiscCost.Text); if (cbIsActive.Checked) { objSalesOrder.IsActive = 1; } else { objSalesOrder.IsActive = 0; } objSalesOrder.CreatedBy = 1; objMessageInfo = odlSalesOrder.ManageItemMaster(objSalesOrder, cmdMode); } catch (Exception ex) { } finally { objSalesOrder = null; //objMessageInfo = null; odlSalesOrder = null; } }
public string insertOrder(string totalc, string totals, string totald, string tax, string shc, string misccost) { Store.SalesOrder.BusinessLogic.SalesOrder oblSalesOrder = new Store.SalesOrder.BusinessLogic.SalesOrder(); Store.Common.MessageInfo objMessageInfo = new MessageInfo(); Store.SalesOrder.BusinessObject.SalesOrder objSalesOrder = new Store.SalesOrder.BusinessObject.SalesOrder(); objSalesOrder.SalesOrderID = 0; objSalesOrder.VendorID = 0; //objSalesOrder.SaleDate= objSalesOrder.TotalCostAmount = Convert.ToDecimal(totalc); objSalesOrder.TotalSaleAmount = Convert.ToDecimal(totals); objSalesOrder.TotalDiscountAmount = Convert.ToDecimal(totald); objSalesOrder.TotalTaxValue = Convert.ToDecimal(tax); objSalesOrder.ShipingAndHandlingCost = Convert.ToDecimal(shc); objSalesOrder.MiscSaleAmount = Convert.ToDecimal(misccost); // objMessageInfo = oblSalesOrder.ManageSaleOrder(objSalesOrder,cmdMode); return(objMessageInfo.TranID.ToString()); }
public Store.Common.MessageInfo ManageSalesOrder(Store.SalesOrder.BusinessObject.SalesOrder objSalesOrder, CommandMode cmdMode) { string SQL = "USP_ManageSales"; ParameterList param = new ParameterList(); DataTableReader dr; Store.Common.MessageInfo objMessageInfo = null; try { SQL = "USP_ManageSales"; param.Add(new SQLParameter("@SalesOrderID", objSalesOrder.SalesOrderID)); param.Add(new SQLParameter("@VendorID", objSalesOrder.VendorID)); //param.Add(new SQLParameter("@SaleDate", objSalesOrder.SaleDate)); param.Add(new SQLParameter("@TotalCostAmount", objSalesOrder.TotalCostAmount)); param.Add(new SQLParameter("@TotalSaleAmount", objSalesOrder.TotalSaleAmount)); param.Add(new SQLParameter("@TotalDiscountAmount", objSalesOrder.TotalDiscountAmount)); param.Add(new SQLParameter("@TotalTaxValue", objSalesOrder.TotalTaxValue)); param.Add(new SQLParameter("@ShipingAndHandlingCost", objSalesOrder.ShipingAndHandlingCost)); param.Add(new SQLParameter("@MiscSaleAmount", objSalesOrder.MiscSaleAmount)); param.Add(new SQLParameter("@IsActive", objSalesOrder.IsActive)); param.Add(new SQLParameter("@ReferenceID", objSalesOrder.ReferenceID)); param.Add(new SQLParameter("@UserId", objSalesOrder.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(SalesOrder).FullName, 1); } return(objMessageInfo); }
protected void imgbtnfrDelete_Click(object sender, ImageClickEventArgs e) { cmdMode = CommandMode.D; objSalesOrder = new Store.SalesOrder.BusinessObject.SalesOrder(); odlSalesOrder = new Store.SalesOrder.BusinessLogic.SalesOrder(); try { ImageButton btndetails = sender as ImageButton; GridViewRow gvrow = (GridViewRow)btndetails.NamingContainer; objSalesOrder.SalesOrderID = Convert.ToInt32(dgvSalesOrder.DataKeys[gvrow.RowIndex].Value.ToString()); objSalesOrder.VendorID = 0; objSalesOrder.SaleDate = DateTime.Now; objSalesOrder.TotalCostAmount = 0; objSalesOrder.TotalSaleAmount = 0; objSalesOrder.TotalTaxValue = 0; objSalesOrder.TotalDiscountAmount = 0; objSalesOrder.ShipingAndHandlingCost = 0; objSalesOrder.MiscSaleAmount = 0; objSalesOrder.IsActive = 1; objSalesOrder.ClientID = 0; objSalesOrder.CreatedBy = 1; objMessageInfo = odlSalesOrder.ManageItemMaster(objSalesOrder, cmdMode); BindSalesOrder(); updateSalesOrderBdInfo.Update(); } catch (Exception ex) { throw; } finally { objSalesOrder = null; objMessageInfo = null; odlSalesOrder = null; } }
public Store.SalesOrder.BusinessObject.SalesOrder GetAllSalesOrder(int SalesOrderID, int Flag, string FlagValue) { Store.SalesOrder.BusinessObject.SalesOrder objSalesOrder = null; string SQL = string.Empty; ParameterList paramList = new ParameterList(); DataTableReader dr; try { SQL = "proc_SalesOrder"; paramList.Add(new SQLParameter("@SalesOrderID", SalesOrderID)); paramList.Add(new SQLParameter("@Flag", Flag)); paramList.Add(new SQLParameter("@FlagValue", FlagValue)); dr = ExecuteQuery.ExecuteReader(SQL, paramList); while (dr.Read()) { objSalesOrder = new BusinessObject.SalesOrder(); if (dr.IsDBNull(dr.GetOrdinal("SalesOrderID")) == false) { objSalesOrder.SalesOrderID = dr.GetInt32(dr.GetOrdinal("SalesOrderID")); } if (dr.IsDBNull(dr.GetOrdinal("VendorID")) == false) { objSalesOrder.VendorID = dr.GetInt32(dr.GetOrdinal("VendorID")); } //if (dr.IsDBNull(dr.GetOrdinal("VendorName")) == false) //{ // objSalesOrder.VendorName = dr.GetString(dr.GetOrdinal("VendorName")); //} if (dr.IsDBNull(dr.GetOrdinal("SaleDate")) == false) { objSalesOrder.SaleDate = dr.GetDateTime(dr.GetOrdinal("SaleDate")); } if (dr.IsDBNull(dr.GetOrdinal("TotalCostAmount")) == false) { objSalesOrder.TotalCostAmount = dr.GetDecimal(dr.GetOrdinal("TotalCostAmount")); } if (dr.IsDBNull(dr.GetOrdinal("TotalSaleAmount")) == false) { objSalesOrder.TotalSaleAmount = dr.GetDecimal(dr.GetOrdinal("TotalSaleAmount")); } if (dr.IsDBNull(dr.GetOrdinal("TotalDiscountAmount")) == false) { objSalesOrder.TotalDiscountAmount = dr.GetDecimal(dr.GetOrdinal("TotalDiscountAmount")); } if (dr.IsDBNull(dr.GetOrdinal("TotalTaxValue")) == false) { objSalesOrder.TotalTaxValue = dr.GetDecimal(dr.GetOrdinal("TotalTaxValue")); } if (dr.IsDBNull(dr.GetOrdinal("ShipingAndHandlingCost")) == false) { objSalesOrder.ShipingAndHandlingCost = dr.GetDecimal(dr.GetOrdinal("ShipingAndHandlingCost")); } if (dr.IsDBNull(dr.GetOrdinal("MiscSaleAmount")) == false) { objSalesOrder.MiscSaleAmount = dr.GetDecimal(dr.GetOrdinal("MiscSaleAmount")); } if (dr.IsDBNull(dr.GetOrdinal("ClientID")) == false) { objSalesOrder.ClientID = dr.GetInt32(dr.GetOrdinal("ClientID")); } if (dr.IsDBNull(dr.GetOrdinal("ClientID")) == false) { objSalesOrder.ClientID = dr.GetInt32(dr.GetOrdinal("ClientID")); } if (dr.IsDBNull(dr.GetOrdinal("CreatedBy")) == false) { objSalesOrder.CreatedBy = dr.GetInt32(dr.GetOrdinal("CreatedBy")); } if (dr.IsDBNull(dr.GetOrdinal("CreatedOn")) == false) { objSalesOrder.CreatedOn = dr.GetDateTime(dr.GetOrdinal("CreatedOn")); } if (dr.IsDBNull(dr.GetOrdinal("ModifiedBy")) == false) { objSalesOrder.ModifiedBy = dr.GetInt32(dr.GetOrdinal("ModifiedBy")); } if (dr.IsDBNull(dr.GetOrdinal("ModifiedOn")) == false) { objSalesOrder.ModifiedOn = dr.GetDateTime(dr.GetOrdinal("ModifiedOn")); } if (dr.IsDBNull(dr.GetOrdinal("ReferenceID")) == false) { objSalesOrder.ReferenceID = dr.GetInt32(dr.GetOrdinal("ReferenceID")); } if (dr.IsDBNull(dr.GetOrdinal("IsActive")) == false) { objSalesOrder.IsActive = dr.GetInt32(dr.GetOrdinal("IsActive")); } } dr.Close(); } catch (Exception ex) { Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(SalesOrder).FullName, 1); } return(objSalesOrder); }