protected void imgbtnfrDelete_Click(object sender, ImageClickEventArgs e) { cmdMode = CommandMode.D; oblPurchaseOrder = new Store.PurchaseOrder.BusinessLogic.PurchaseOrder(); objPurchaseOrder = new Store.PurchaseOrder.BusinessObject.PurchaseOrder(); objMessageInfo = new MessageInfo(); try { ImageButton btndetails = sender as ImageButton; GridViewRow gvrow = (GridViewRow)btndetails.NamingContainer; objPurchaseOrder.PurchaseOrderID = Convert.ToInt32(gvPOrder.DataKeys[gvrow.RowIndex].Value.ToString()); objMessageInfo = oblPurchaseOrder.ManagePurchaseOrder(objPurchaseOrder, cmdMode); BindPurchaseOrder(); if (objMessageInfo.TranID != 0) { ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "alert", "alert('" + objMessageInfo.TranMessage + "')", true); } else if (objMessageInfo.ErrorCode == -101) { ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "alert", "alert('" + objMessageInfo.ErrorMessage + "')", true); } } catch (Exception ex) { throw ex; } finally { objMessageInfo = null; oblPurchaseOrder = null; objPurchaseOrder = null; } }
//void BindCategory() //{ // oblCategory = new Store.Category.BusinessLogic.Category(); // try // { // obCategoryList = oblCategory.GetAllCategoryList(0, 0, ""); // if (obCategoryList != null) // { // ddlCategory.DataSource = obCategoryList; // ddlCategory.DataTextField = "CategoryName"; // ddlCategory.DataValueField = "CategoryID"; // ddlCategory.DataBind(); // ddlCategory.Items.Insert(0, "<--Select Category-->"); // } // else // { // ddlCategory.DataSource = null; // ddlCategory.DataBind(); // } // } // catch (Exception ex) // { // Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(ItemUnit).FullName, 1); // } // finally // { // oblCategory = null; // obCategoryList = null; // } //} void ManageItemUnit() { objItemUnit = new Store.ItemUnit.BusinessObject.ItemUnit(); oblItemUnit = new Store.ItemUnit.BusinessLogic.ItemUnit(); try { if (cmdMode == Store.Common.CommandMode.M) { objItemUnit.UnitID = Convert.ToInt32(txtUnitId.Text); //objItemUnit.ModifiedBy = Convert.ToInt32(Session["UserId"]); } else { objItemUnit.UnitID = 0; //objItemUnit.CreatedBy = Convert.ToInt32(Session["UserId"]); } objItemUnit.UnitName = Convert.ToString(txtUnitName.Text); //objItemUnit.CategoryID = Convert.ToInt32(ddlCategory.SelectedItem.Value); objMessageInfo = oblItemUnit.ManageItemMaster(objItemUnit, cmdMode); } catch (Exception ex) { Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(ItemUnit).FullName, 1); } finally { objItemUnit = null; //objMessageInfo = null; oblItemUnit = null; } }
public string insertSalesReturn(string subtotal, string tax, string shc, string misccost, string ttotal) { oblSalesRtn = new Store.SalesReturned.BusinessLogic.SalesReturned(); // oblPurchaseReceived = new Store.PurchaseReceived.BusinessLogic.PurchaseReceived(); objMessageInfo = new MessageInfo(); objSalesRtn = new Store.SalesReturned.BusinessObject.SalesReturned(); if (cmdMode == Store.Common.CommandMode.M) { objSalesRtn.SalesReturnedID = Convert.ToInt32(hfPId.Value); // objPurchaseReceived.PurchaseReceivedID = Convert.ToInt32(hfPId.Value);//PurchaseReceivedID which edit from data grid } else { // objPurchaseReceived.PurchaseReceivedID = 0; } objSalesRtn.SalesReturnedID = Convert.ToInt32(hfSaleOrder.Value); objSalesRtn.VendorID = Convert.ToInt32(hfVendor.Value); objSalesRtn.TotalSalesReturnAmount = Convert.ToDecimal(ttotal); objSalesRtn.TaxValue = Convert.ToDecimal(tax); objSalesRtn.ShippingAndHandlingCost = Convert.ToDecimal(shc); objSalesRtn.MiscCost = Convert.ToDecimal(misccost); objSalesRtn.IsActive = 1; objMessageInfo = oblSalesRtn.ManageSalesRetuned(objSalesRtn, cmdMode); return(objMessageInfo.TranID.ToString()); }
public Store.Common.MessageInfo ManageStock(Store.Stock.BusinessObject.Stock objstock, CommandMode cmdMode) { string SQL = ""; ParameterList paramList = new ParameterList(); DataTableReader dr; Store.Common.MessageInfo objMessageInfo = null; try { SQL = "USP_ManageStock"; paramList.Add(new SQLParameter("@StockID", objstock.StockID)); paramList.Add(new SQLParameter("@ItemID", objstock.ItemID)); paramList.Add(new SQLParameter("@StockQuantity", objstock.StockQuantity)); paramList.Add(new SQLParameter("@CMDMode", cmdMode)); dr = ExecuteQuery.ExecuteReader(SQL, paramList); 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(Stock).FullName, 1); } return(objMessageInfo); }
public string insertOrder(string subtotal, string dicpre, string dic, string tax, string shc, string misccost, string ttotal) { oblPurchaseOrder = new Store.PurchaseOrder.BusinessLogic.PurchaseOrder(); objMessageInfo = new MessageInfo(); objPurchaseOrder = new Store.PurchaseOrder.BusinessObject.PurchaseOrder(); if (cmdMode == Store.Common.CommandMode.M) { objPurchaseOrder.PurchaseOrderID = Convert.ToInt32(hfPId.Value);//PurchaseOrderID which edit from data grid } else { objPurchaseOrder.PurchaseOrderID = 0; } objPurchaseOrder.PurchaseOrderID = 0; objPurchaseOrder.VendorID = Convert.ToInt32(hfVendor.Value); objPurchaseOrder.PurchaseAmount = Convert.ToDecimal(ttotal); objPurchaseOrder.TaxValue = Convert.ToDecimal(tax); objPurchaseOrder.ShipingAndHandlingCost = Convert.ToDecimal(shc); objPurchaseOrder.MiscCost = Convert.ToDecimal(misccost); objPurchaseOrder.PDiscountPre = Convert.ToDecimal(dicpre); objPurchaseOrder.PDiscount = Convert.ToDecimal(dic); objPurchaseOrder.IsActive = 1; objMessageInfo = oblPurchaseOrder.ManagePurchaseOrder(objPurchaseOrder, cmdMode); return objMessageInfo.TranID.ToString(); }
void ManageState() { objState = new Store.State.BusinessObject.State(); oblState = new Store.State.BusinessLogic.State(); try { if (cmdMode == Store.Common.CommandMode.M) { objState.StateID = Convert.ToInt32(txtStateId.Text); //objState.ModifiedBy = Convert.ToInt32(Session["UserId"].ToString()); } else { objState.StateID = 0; //objState.CreatedBy = Convert.ToInt32(Session["UserId"].ToString()); } objState.StateName = Convert.ToString(txtState.Text); objState.CountryID = Convert.ToInt32(ddlCountry.SelectedItem.Value); //objState.CreatedBy = Convert.ToInt32(Session["UserId"].ToString()); objMessageInfo = oblState.ManageItemMaster(objState, cmdMode); } catch (Exception ex) { Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(State).FullName, 1); } finally { objState = null; //objMessageInfo = null; oblState = null; } }
void ManageTax() { objTax = new Store.Tax.BusinessObject.Tax(); oblTax = new Store.Tax.BusinessLogic.Tax(); try { if (cmdMode == Store.Common.CommandMode.M) { objTax.TaxID = Convert.ToInt32(txtTaxId.Text); //objTax.ModifiedBy = Convert.ToInt32(Session["UserId"]); } else { objTax.TaxID = 0; //objTax.CreatedBy = Convert.ToInt32(Session["UserId"]); } objTax.TaxName = Convert.ToString(txtTaxName.Text); objTax.TaxDisplayName = Convert.ToString(txtTaxDisplayName.Text); objTax.TaxValue = Convert.ToDecimal(txtTaxValue.Text); objMessageInfo = oblTax.ManageItemMaster(objTax, cmdMode); } catch (Exception ex) { Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(Tax).FullName, 1); } finally { objTax = null; //objMessageInfo = null; oblTax = null; } }
protected void imgbtnfrDelete_Click(object sender, ImageClickEventArgs e) { cmdMode = CommandMode.D; objPurchaseReceivedItem = new Store.PurchaseReceivedItem.BusinessObject.PurchaseReceivedItem(); oblPurchaseReceivedItem = new Store.PurchaseReceivedItem.BusinessLogic.PurchaseReceivedItem(); try { ImageButton btndetails = sender as ImageButton; GridViewRow gvrow = (GridViewRow)btndetails.NamingContainer; objPurchaseReceivedItem.PurchaseItemReceivedID = Convert.ToInt32(dgvPurchaseItemReceived.DataKeys[gvrow.RowIndex].Value.ToString()); objPurchaseReceivedItem.PurchaseReceivedID = 0; objPurchaseReceivedItem.PurchaseOrderID = 0; objPurchaseReceivedItem.ItemID = 0; objPurchaseReceivedItem.ItemUnit = ""; objPurchaseReceivedItem.Description = ""; objPurchaseReceivedItem.ItemPrice = 0; objPurchaseReceivedItem.ClientID = 0; objPurchaseReceivedItem.CreatedBy = 1; objMessageInfo = oblPurchaseReceivedItem.ManageItemMaster(objPurchaseReceivedItem, cmdMode); BindPurchaseReceivedItem(); updatePurchasedItemReceivedBdInfo.Update(); } catch (Exception ex) { throw; } finally { objPurchaseReceivedItem = null; objMessageInfo = null; oblPurchaseReceivedItem = null; } }
public Store.Common.MessageInfo ManageItemPrice(Store.ItemPrice.BusinessObject.ItemPrice objItemPrice, CommandMode cmdMode) { string SQL = ""; ParameterList param = new ParameterList(); DataTableReader dr; Store.Common.MessageInfo objMessageInfo = null; try { SQL = "USP_ManageItemPrice"; param.Add(new SQLParameter("@ItemPriceID", objItemPrice.ItemPriceID)); param.Add(new SQLParameter("@ItemSalePricePerUnit", objItemPrice.ItemSalePricePerUnit)); param.Add(new SQLParameter("@ItemDiscountPercentagePerUnit", objItemPrice.ItemDiscountPercentagePerUnit)); param.Add(new SQLParameter("@ApplicableFrom", objItemPrice.ApplicableFrom)); param.Add(new SQLParameter("@ApplicableTo", objItemPrice.ApplicableTo)); 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(ItemPrice).FullName, 1); } return(objMessageInfo); }
public string insertOrder(string tax, string shc, string misccost, string ttotal) { try { objPurchaseReceived = new Store.PurchaseReceived.BusinessObject.PurchaseReceived(); objMessageInfo = new MessageInfo(); oblPurchaseReceived = new Store.PurchaseReceived.BusinessLogic.PurchaseReceived(); objPurchaseReceived.PurchaseOrderID = Convert.ToInt32(txtPoId.Text); objPurchaseReceived.PurchaseReceivedID = 0; objPurchaseReceived.VendorID = 0; objPurchaseReceived.PurchaseAmount = Convert.ToDecimal(ttotal); objPurchaseReceived.TaxValue = Convert.ToDecimal(tax); objPurchaseReceived.ShipingAndHandlingCost = Convert.ToDecimal(shc); objPurchaseReceived.MiscCost = Convert.ToDecimal(misccost); objPurchaseReceived.IsActive = 1; //objMessageInfo = oblPurchaseReceived.ManagePurchaseReceived(objPurchaseReceived,1);by depk objMessageInfo = oblPurchaseReceived.ManagePurchaseReceived(objPurchaseReceived, cmdMode); return(objMessageInfo.TranID.ToString()); } catch (Exception ex) { //Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(WebForm1).FullName, 1); } finally { objMessageInfo = null; objPurchaseReceived = null; oblPurchaseReceived = null; } }
void UpdateItemPrice() { objItemPrice = new Store.ItemPrice.BusinessObject.ItemPrice(); oblItemPrice = new Store.ItemPrice.BusinessLogic.ItemPrice(); try { objItemPrice.ItemPriceID = Convert.ToInt32(hfItemPriceId.Value); objItemPrice.ItemSalePricePerUnit = Convert.ToDecimal(txtSP.Text); objItemPrice.ItemDiscountPercentagePerUnit = Convert.ToDecimal(txtDisPerUnit.Text); objItemPrice.ApplicableFrom = Convert.ToDateTime(txtApplicableFrom.Text); objItemPrice.ApplicableTo = Convert.ToDateTime(txtApplicableTo.Text); objMessageInfo = oblItemPrice.ManageItemMaster(objItemPrice, cmdMode); } catch (Exception ex) { Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(ItemPrice).FullName, 1); } finally { objItemPrice = null; oblItemPrice = null; } }
protected void imgbtnfrDelete_Click(object sender, ImageClickEventArgs e) { cmdMode = CommandMode.D; objStock = new Store.Stock.BusinessObject.Stock(); oblStock = new Store.Stock.BusinessLogic.Stock(); try { ImageButton btndetails = sender as ImageButton; GridViewRow gvrow = (GridViewRow)btndetails.NamingContainer; objStock.StockID = Convert.ToInt32(dgvStock.DataKeys[gvrow.RowIndex].Value.ToString()); objMessageInfo = oblStock.ManageStockMaster(objStock, cmdMode); BindStock(); updateStockBdInfo.Update(); } catch (Exception ex) { Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(Stock).FullName, 1); } finally { objStock = null; objMessageInfo = null; oblStock = null; } }
public string insertItem(string name, string description, string unitprice, string quantity, string transId) { try { objPurchaseReceivedItem = new Store.PurchaseReceivedItem.BusinessObject.PurchaseReceivedItem(); objMessageInfo = new MessageInfo(); oblPurchaseReceived = new Store.PurchaseReceived.BusinessLogic.PurchaseReceived(); objPurchaseReceivedItem.PurchaseItemReceivedID = 0; objPurchaseReceivedItem.PurchaseOrderID = Convert.ToInt32(txtPoId.Text); objPurchaseReceivedItem.PurchaseReceivedID = Convert.ToInt32(transId); objPurchaseReceivedItem.ItemID = 0; objPurchaseReceivedItem.ItemPrefix = name; objPurchaseReceivedItem.ItemUnit = quantity; objPurchaseReceivedItem.Description = description; objPurchaseReceivedItem.ItemPrice = Convert.ToDecimal(unitprice); objPurchaseReceivedItem.IsActive = 1; objMessageInfo = oblPurchaseReceived.ManagePurchaseReceivedItem(objPurchaseReceivedItem, cmdMode); //objPurchaseOrder = new Store.PurchaseOrder.BusinessObject.PurchaseOrder(); return(""); } catch (Exception ex) {// Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(WebForm1).FullName, 1); } finally { objPurchaseReceivedItem = null; oblPurchaseReceived = null; objMessageInfo = null; } }
void ManageStock() { objStock = new Store.Stock.BusinessObject.Stock(); oblStock = new Store.Stock.BusinessLogic.Stock(); try { if (cmdMode == Store.Common.CommandMode.M) { objStock.StockID = Convert.ToInt32(txtStockId.Text); } else { objStock.StockID = 0; } objStock.ItemID = Convert.ToInt32(ddlItemId.SelectedItem.Value); objStock.StockQuantity = Convert.ToInt32(txtQuantity.Text); objMessageInfo = oblStock.ManageStockMaster(objStock, cmdMode); } catch (Exception ex) { Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(Stock).FullName, 1); } finally { objStock = null; // objMessageInfo = null; oblStock = null; } }
protected void imgbtnfrDelete_Click(object sender, ImageClickEventArgs e) { cmdMode = CommandMode.D; objPurchaseReceived = new Store.PurchaseReceived.BusinessObject.PurchaseReceived(); oblPurchaseReceived = new Store.PurchaseReceived.BusinessLogic.PurchaseReceived(); try { ImageButton btndetails = sender as ImageButton; GridViewRow gvrow = (GridViewRow)btndetails.NamingContainer; objPurchaseReceived.PurchaseReceivedID = Convert.ToInt32(dgvPurchaseReceived.DataKeys[gvrow.RowIndex].Value.ToString()); objPurchaseReceived.VendorID = 1; objPurchaseReceived.PurchaseRecivedDate = DateTime.Now; objPurchaseReceived.PurchaseAmount = 2; objPurchaseReceived.TaxValue = 3; objPurchaseReceived.ShipingAndHandlingCost = 4; objPurchaseReceived.PurchaseOrderID = 5; objPurchaseReceived.CreatedBy = 1; //objMessageInfo =oblPurchaseReceived.ManagePurchaseOrderMaster(objPurchaseReceived, cmdMode); BindPurchaseReceived(); updatePurchasedReceivedBdInfo.Update(); } catch (Exception ex) { throw; } finally { objPurchaseReceived = null; objMessageInfo = null; oblPurchaseReceived = null; } }
protected void imgbtnfrDelete_Click(object sender, ImageClickEventArgs e) { cmdMode = CommandMode.D; objClient = new Store.Client.BusinessObject.Client(); oblClient = new Store.Client.BusinessLogic.Client(); try { ImageButton btndetails = sender as ImageButton; GridViewRow gvrow = (GridViewRow)btndetails.NamingContainer; objClient.ClientID = Convert.ToInt32(dgvClient.DataKeys[gvrow.RowIndex].Value.ToString()); objClient.ClientName = ""; objClient.ClientDisplayName = ""; objClient.Address = ""; objClient.CityID = 0; objClient.StateID = 1; objClient.CountryID = 2; objClient.PinID = 3; objClient.CreatedBy = 1; objMessageInfo = oblClient.ManageClientMaster(objClient, cmdMode); BindClient(); updateClientBdInfo.Update(); ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "alert", "alert('" + objMessageInfo.TranMessage + "')", true); } catch (Exception ex) { Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(Client).FullName, 1); } finally { objClient = null; objMessageInfo = null; oblClient = 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); } }
protected void imgbtnfrDelete_Click(object sender, ImageClickEventArgs e) { cmdMode = CommandMode.D; objState = new Store.State.BusinessObject.State(); oblState = new Store.State.BusinessLogic.State(); try { ImageButton btndetails = sender as ImageButton; GridViewRow gvrow = (GridViewRow)btndetails.NamingContainer; objState.StateID = Convert.ToInt32(dgvState.DataKeys[gvrow.RowIndex].Value.ToString()); objState.StateName = ""; //objState.CreatedBy = Convert.ToInt32(Session["UserId"].ToString()); objMessageInfo = oblState.ManageItemMaster(objState, cmdMode); BindState(); updateStateBdInfo.Update(); ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "alert", "alert('" + objMessageInfo.TranMessage + "')", true); } catch (Exception ex) { Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(State).FullName, 1); } finally { objState = null; objMessageInfo = null; oblState = null; } }
void ManageTypeOfUser() { objTypeOfUser = new Store.TypeOfUser.BusinessObject.TypeOfUser(); oblTypeOfUser = new Store.TypeOfUser.BusinessLogic.TypeOfUser(); try { if (cmdMode == Store.Common.CommandMode.M) { objTypeOfUser.TypeofUserID = Convert.ToInt32(txtTypeofUserId.Text); //objTypeOfUser.ModifiedBy = Convert.ToInt32(Session["UserId"]); } else { objTypeOfUser.TypeofUserID = 0; //objTypeOfUser.CreatedBy = Convert.ToInt32(Session["UserId"]); } objTypeOfUser.TypeofUserName = Convert.ToString(txtTypeofUserName.Text); objMessageInfo = oblTypeOfUser.ManageItemMaster(objTypeOfUser, cmdMode); } catch (Exception ex) { Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(TypeOfUser).FullName, 1); } finally { objTypeOfUser = null; //objMessageInfo = null; oblTypeOfUser = null; } }
void ManageCountry() { objCountry = new Store.Country.BusinessObject.Country(); oblCountry = new Store.Country.BusinessLogic.Country(); try { if (cmdMode == Store.Common.CommandMode.M) { objCountry.CountryID = Convert.ToInt32(txtCountryId.Text); //objCountry.ModifiedBy = Convert.ToInt32(Session["UserId"].ToString()); } else { objCountry.CountryID = 0; //objCountry.CreatedBy = Convert.ToInt32(Session["UserId"].ToString()); } objCountry.CountryName = Convert.ToString(txtCountry.Text); objMessageInfo = oblCountry.ManageItemMaster(objCountry, cmdMode); } catch (Exception ex) { Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(Country).FullName, 1); } finally { objCountry = null; oblCountry = null; } }
void ManageVendorInfo() { objVendorInfo = new Store.VendorInfo.BusinessObject.VendorInfo(); oblVendorInfo = new Store.VendorInfo.BusinessLogic.VendorInfo(); try { if (cmdMode == Store.Common.CommandMode.M) { objVendorInfo.VendorID = Convert.ToInt32(txtVendorID.Text); //objVendorInfo.ModifiedBy = Convert.ToInt32(Session["VendorId"]); } else { objVendorInfo.VendorID = 0; //objVendorInfo.CreatedBy = Convert.ToInt32(Session["VendorId"]); } objVendorInfo.VendorName = Convert.ToString(txtVendorName.Text); objVendorInfo.VendorDisplayName = Convert.ToString(txtVendorDisplayName.Text); objVendorInfo.TypeofVendorID = Convert.ToInt32(ddlTypeofVendorID.SelectedItem.Value); objVendorInfo.Address = Convert.ToString(txtAddress.Text); objVendorInfo.CityID = Convert.ToInt32(ddlCityID.SelectedItem.Value); objVendorInfo.StateID = Convert.ToInt32(ddlStateID.SelectedItem.Value); objVendorInfo.CountryID = Convert.ToInt32(ddlCountryID.SelectedItem.Value); objVendorInfo.PinID = Convert.ToInt32(txtPinID.Text); objVendorInfo.ConcernPerson = Convert.ToInt32(txtConcernPerson.Text); objVendorInfo.PhoneNo = Convert.ToInt32(txtPhoneNo.Text); objVendorInfo.MobileNo = Convert.ToInt32(txtMobileNo.Text); objVendorInfo.EmailID = Convert.ToString(txtEmailID.Text); objVendorInfo.WebsiteAddress = Convert.ToString(txtWebsiteAddress.Text); objVendorInfo.PanNo = Convert.ToString(txtPanNo.Text); objVendorInfo.GstNo = Convert.ToString(txtGstNo.Text); objVendorInfo.ServiceTaxNo = Convert.ToString(txtServiceTaxNo.Text); if (cbIsActive.Checked) { objVendorInfo.IsActive = 1; } else { objVendorInfo.IsActive = 0; } objMessageInfo = oblVendorInfo.ManageItemMaster(objVendorInfo, cmdMode); } catch (Exception ex) { Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(VendorInfo).FullName, 1); } finally { objVendorInfo = null; //objMessageInfo = null; oblVendorInfo = null; } }
public Store.Common.MessageInfo ManageItem(Store.Item.BusinessObject.Item objItem, CommandMode cmdMode) { string SQL = ""; ParameterList param = new ParameterList(); DataTableReader dr; Store.Common.MessageInfo objMessageInfo = null; try { SQL = "USP_ManageItem"; param.Add(new SQLParameter("@ItemID", objItem.ItemID)); //param.Add(new SQLParameter("@ItemPriceID", objItem.ItemPriceID)); param.Add(new SQLParameter("@ItemPrefix", objItem.ItemPrefix)); param.Add(new SQLParameter("@ItemCode", objItem.ItemCode)); param.Add(new SQLParameter("@Barcode", objItem.Barcode)); param.Add(new SQLParameter("@ItemDescription", objItem.ItemDescription)); param.Add(new SQLParameter("@ItemUnitId", objItem.ItemUnitId)); //param.Add(new SQLParameter("@ItemCostPricePerUnit", objItem.ItemCostPricePerUnit)); //param.Add(new SQLParameter("@ItemSalePricePerUnit", objItem.ItemSalePricePerUnit)); //param.Add(new SQLParameter("@ItemDiscountPercentagePerUnit", objItem.ItemDiscountPercentagePerUnit)); //param.Add(new SQLParameter("@WindowFrom", objItem.WindowFrom)); //param.Add(new SQLParameter("@WindowTo", objItem.WindowTo)); //param.Add(new SQLParameter("@BatchNo", objItem.BatchNo)); param.Add(new SQLParameter("@CategoryID", objItem.CategoryID)); param.Add(new SQLParameter("@IsActive", objItem.IsActive)); param.Add(new SQLParameter("@ReferenceID", objItem.ReferenceID)); if (cmdMode == CommandMode.N) { param.Add(new SQLParameter("@UserId", objItem.CreatedBy)); } else { param.Add(new SQLParameter("@UserId", objItem.ModifiedBy)); } 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(Item).FullName, 1); } return(objMessageInfo); }
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 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); }
public Store.Common.MessageInfo ManageVendorInfo(Store.VendorInfo.BusinessObject.VendorInfo objVendorInfo, CommandMode cmdMode) { string SQL = ""; ParameterList param = new ParameterList(); DataTableReader dr; Store.Common.MessageInfo objMessageInfo = null; try { SQL = "USP_ManageVendorInfo"; param.Add(new SQLParameter("@VendorID", objVendorInfo.VendorID)); param.Add(new SQLParameter("@VendorName", objVendorInfo.VendorName)); param.Add(new SQLParameter("@VendorDisplayName", objVendorInfo.VendorDisplayName)); param.Add(new SQLParameter("@TypeofVendorID", objVendorInfo.TypeofVendorID)); param.Add(new SQLParameter("@Address", objVendorInfo.Address)); param.Add(new SQLParameter("@CityID", objVendorInfo.CityID)); param.Add(new SQLParameter("@StateID", objVendorInfo.StateID)); param.Add(new SQLParameter("@CountryID", objVendorInfo.CountryID)); param.Add(new SQLParameter("@PinID", objVendorInfo.PinID)); param.Add(new SQLParameter("@ConcernPerson", objVendorInfo.ConcernPerson)); param.Add(new SQLParameter("@PhoneNo", objVendorInfo.PhoneNo)); param.Add(new SQLParameter("@MobileNo", objVendorInfo.MobileNo)); param.Add(new SQLParameter("@EmailID", objVendorInfo.EmailID)); param.Add(new SQLParameter("@WebsiteAddress", objVendorInfo.WebsiteAddress)); param.Add(new SQLParameter("@PanNo", objVendorInfo.PanNo)); param.Add(new SQLParameter("@GstNo", objVendorInfo.GstNo)); param.Add(new SQLParameter("@ServiceTaxNo", objVendorInfo.ServiceTaxNo)); param.Add(new SQLParameter("@IsActive", objVendorInfo.IsActive)); param.Add(new SQLParameter("@ReferenceID", objVendorInfo.ReferenceID)); 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(VendorInfo).FullName, 1); } return(objMessageInfo); }
public Store.Common.MessageInfo ManageClient(Store.Client.BusinessObject.Client objClient, CommandMode cmdMode) { string SQL = ""; ParameterList paramList = new ParameterList(); DataTableReader dr; Store.Common.MessageInfo objMessageInfo = null; try { SQL = "USP_ManageClient"; paramList.Add(new SQLParameter("@ClientID", objClient.ClientID)); paramList.Add(new SQLParameter("@ClientName", objClient.ClientName)); paramList.Add(new SQLParameter("@ClientDisplayName", objClient.ClientDisplayName)); paramList.Add(new SQLParameter("@Address", objClient.Address)); paramList.Add(new SQLParameter("@CityID", objClient.CityID)); paramList.Add(new SQLParameter("@StateID", objClient.StateID)); paramList.Add(new SQLParameter("@CountryID", objClient.CountryID)); paramList.Add(new SQLParameter("@PinID", objClient.PinID)); if (cmdMode == CommandMode.N) { paramList.Add(new SQLParameter("@UserId", objClient.CreatedBy)); } else { paramList.Add(new SQLParameter("@UserId", objClient.ModifiedBy)); } paramList.Add(new SQLParameter("@ReferenceID", objClient.ReferenceID)); paramList.Add(new SQLParameter("@IsActive", objClient.IsActive)); paramList.Add(new SQLParameter("@CMDMode", cmdMode)); dr = ExecuteQuery.ExecuteReader(SQL, paramList); if (dr.Read()) { objMessageInfo = new Store.Common.MessageInfo(); //objMessageInfo = new Pareeksha.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(Client).FullName, 1); } return(objMessageInfo); }
void ManageClientCategory() { objClient = new Store.Client.BusinessObject.Client(); oblClient = new Store.Client.BusinessLogic.Client(); try { if (cmdMode == Store.Common.CommandMode.M) { objClient.ClientID = Convert.ToInt32(txtClientId.Text); //objClient.ModifiedBy = Convert.ToInt32(Session["UserId"].ToString()); } else { objClient.ClientID = 0; //objClient.CreatedBy = Convert.ToInt32(Session["UserId"].ToString()); } objClient.ClientName = Convert.ToString(txtClientName.Text); objClient.ClientDisplayName = Convert.ToString(txtClientDisplayName.Text); objClient.Address = Convert.ToString(txtAddress.Text); objClient.CityID = Convert.ToInt32(ddlCity.SelectedItem.Value); objClient.StateID = Convert.ToInt32(ddlState.SelectedItem.Value); objClient.CountryID = Convert.ToInt32(ddlCountry.SelectedItem.Value); objClient.PinID = Convert.ToInt32(txtPinId.Text); if (cbIsActive.Checked) { objClient.IsActive = 1; } else { objClient.IsActive = 0; } objMessageInfo = oblClient.ManageClientMaster(objClient, cmdMode); } catch (Exception ex) { Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(Client).FullName, 1); } finally { objClient = null; //objMessageInfo = null; oblClient = null; } }
void ManageItem() { objItem = new Store.Item.BusinessObject.Item(); oblItem = new Store.Item.BusinessLogic.Item(); try { if (cmdMode == Store.Common.CommandMode.M) { objItem.ItemID = Convert.ToInt32(txtItemId.Text); //objItem.ModifiedBy = Convert.ToInt32(Session["UserId"]); //objItem.ItemPriceID = Convert.ToInt32(txtItemPriceId.Text); } else { objItem.ItemID = 0; //objItem.CreatedBy = Convert.ToInt32(Session["UserId"]); //objItem.ItemPriceID = 0; } objItem.ItemPrefix = Convert.ToString(txtItemPrefix.Text); objItem.ItemCode = Convert.ToString(txtItemCode.Text); objItem.Barcode = Convert.ToString(txtBarcode.Text); objItem.ItemDescription = Convert.ToString(txtItemDecription.Text); objItem.ItemUnitId = Convert.ToInt32(ddlItemUnitId.SelectedItem.Value); objItem.CategoryID = Convert.ToInt32(ddlCategoryId.SelectedItem.Value); //objItem.ItemCostPricePerUnit = Convert.ToDecimal(txtCostPrice.Text); //objItem.ItemSalePricePerUnit = Convert.ToDecimal(txtSalePrice.Text); //objItem.ItemDiscountPercentagePerUnit = Convert.ToDecimal(txtItemDiscountPerUnit.Text); //objItem.WindowFrom = Convert.ToDateTime(txtFrom.Text); //objItem.WindowTo = Convert.ToDateTime(txtTo.Text); //objItem.BatchNo = Convert.ToString(txtBatchNo.Text); objMessageInfo = oblItem.ManageItemMaster(objItem, cmdMode); } catch (Exception ex) { Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(Item).FullName, 1); } finally { objItem = null; //objMessageInfo = null; oblItem = null; } }
void ManageSalesReturned() { objSalesReturned = new Store.SalesReturned.BusinessObject.SalesReturned(); oblSalesReturned = new Store.SalesReturned.BusinessLogic.SalesReturned(); try { if (cmdMode == Store.Common.CommandMode.M) { objSalesReturned.SalesReturnedID = Convert.ToInt32(txtSalesReturnedID.Text); } else { objSalesReturned.SalesReturnedID = 0; } objSalesReturned.VendorID = Convert.ToInt32(ddlVendor.SelectedItem.Value); objSalesReturned.SalesReturnDate = Convert.ToDateTime(txtSalesReturnDate.Text); objSalesReturned.TotalSalesReturnAmount = Convert.ToDecimal(txtTotalSalesReturnAmount.Text); objSalesReturned.TaxValue = Convert.ToDecimal(txtTaxValue.Text); objSalesReturned.ShippingAndHandlingCost = Convert.ToDecimal(txtShippingHandlingCost.Text); objSalesReturned.MiscCost = Convert.ToDecimal(txtMiscCost.Text); objSalesReturned.SalesOrderID = Convert.ToInt32(ddlSalesOrderID.SelectedItem.Value); if (cbIsActive.Checked) { objSalesReturned.IsActive = 1; } else { objSalesReturned.IsActive = 0; } objSalesReturned.CreatedBy = 1; objMessageInfo = oblSalesReturned.ManageItemMaster(objSalesReturned, cmdMode); } catch (Exception ex) { } finally { objSalesReturned = null; //objMessageInfo = null; oblSalesReturned = null; } }
void ManagePurchaseItemRecived() { objPurchaseReceivedItem = new Store.PurchaseReceivedItem.BusinessObject.PurchaseReceivedItem(); oblPurchaseReceivedItem = new Store.PurchaseReceivedItem.BusinessLogic.PurchaseReceivedItem(); try { if (cmdMode == Store.Common.CommandMode.M) { objPurchaseReceivedItem.PurchaseItemReceivedID = Convert.ToInt32(txtPurchaseItemReceivedID.Text); } else { objPurchaseReceivedItem.PurchaseItemReceivedID = 0; } objPurchaseReceivedItem.PurchaseReceivedID = Convert.ToInt16(ddlPurchaseReceivedId.SelectedItem.Value); objPurchaseReceivedItem.PurchaseOrderID = Convert.ToInt16(ddlPurchaseOrderId.SelectedItem.Value); objPurchaseReceivedItem.ItemID = Convert.ToInt16(ddlItemId.SelectedItem.Value); objPurchaseReceivedItem.ItemUnit = Convert.ToString(txtItemUnit.Text); objPurchaseReceivedItem.Description = Convert.ToString(txtDescription.Text); objPurchaseReceivedItem.ItemPrice = Convert.ToDecimal(txtItemPrice.Text); if (chkBoxIsActive.Checked) { objPurchaseReceivedItem.IsActive = 1; } else { objPurchaseReceivedItem.IsActive = 0; } objPurchaseReceivedItem.CreatedBy = 1; objMessageInfo = oblPurchaseReceivedItem.ManageItemMaster(objPurchaseReceivedItem, cmdMode); } catch (Exception ex) { } finally { objPurchaseReceivedItem = null; //objMessageInfo = null; oblPurchaseReceivedItem = null; } }