public List <ProductsMaster> GetProductListByHSNSACCode(string prefixText, int count) { List <ProductsMaster> finalList = new List <ProductsMaster>(); BAL_Products bAL_Products = new BAL_Products(); finalList = bAL_Products.GetProducListByHSNSACCode(prefixText); if (finalList != null && finalList.Count > 0) { ProductsMaster prod = new ProductsMaster(); prod.Name = "Tests"; prod.HSNCode = "HSN108"; prod.Description = "Test"; prod.GSTPercentage = "18"; prod.ID = 1; finalList.Add(prod); return(finalList); } else { ProductsMaster prod = new ProductsMaster(); prod.Name = "Tests"; prod.HSNCode = "HSN108"; prod.Description = "Test"; prod.GSTPercentage = "18"; prod.ID = 1; finalList.Add(prod); return(finalList); //return null; } }
private void LoadAllProducts() { BAL_Products bAL_Products = new BAL_Products(); List <ProductsMaster> productLlist = new List <ProductsMaster>(); productLlist = bAL_Products.GetAllProductList(); BindDatatoTable(productLlist); }
public List <ProductsMaster> GetProductListByProductName(string prefixText, int count) { List <ProductsMaster> finalList = new List <ProductsMaster>(); BAL_Products bAL_Products = new BAL_Products(); finalList = bAL_Products.GetProductListByProductName(prefixText); if (finalList != null && finalList.Count > 0) { return(finalList); } else { return(null); } }
public string SubmitAddInvoiceData(Customer Customer, Customer Client, List <ProductsMaster> productList, List <BillProductMapping> productBillMapping, string notesForCustomer, string termsAndCondition) { Int64 customerID = -1, clientId = -1, billMasterID = -1; bool customerExists = false, clientExist = false; AddInvoiceResponse addInvoiceResponse = new AddInvoiceResponse(); BAL_Customers bAL_Customers = new BAL_Customers(); BAL_Products bAL_Products = new BAL_Products(); System.Web.Script.Serialization.JavaScriptSerializer js = new System.Web.Script.Serialization.JavaScriptSerializer(); try { if (Customer.GSTIN != null) { Customer.CustomerType = "Company"; customerExists = bAL_Customers.CheckIfCustomerExistByGSTIN(Customer.GSTIN, out customerID); } else if (Customer.PAN != null) { Customer.CustomerType = "Individual"; customerExists = bAL_Customers.CheckIfCustomerExistByPAN(Customer.PAN, out customerID); } else { customerExists = bAL_Customers.CheckIfCustomerExistByName(Customer.Name, out customerID); } if (!customerExists) { customerID = bAL_Customers.CreateNewCustomer(Customer); } if (Client.GSTIN != null) { Client.CustomerType = "Company"; clientExist = bAL_Customers.CheckIfCustomerExistByGSTIN(Client.GSTIN, out clientId); } else if (Client.PAN != null) { Client.CustomerType = "Individual"; clientExist = bAL_Customers.CheckIfCustomerExistByPAN(Client.PAN, out clientId); } else { clientExist = bAL_Customers.CheckIfCustomerExistByName(Client.Name, out clientId); } if (!clientExist) { clientId = bAL_Customers.CreateNewCustomer(Client); } BAL_Bill bAL_Bill = new BAL_Bill(); BillMaster billMaster = new BillMaster(); billMaster.BillFromCustID = customerID; billMaster.BillToCustID = clientId; billMaster.BillAddL1 = Client.BillAddL1; billMaster.BillAddL2 = Client.BillAddL2; billMaster.BillStateID = Client.BillStateID; billMaster.BillAddCityID = Client.BillAddCityID; billMaster.NotesForCustomer = notesForCustomer; billMaster.TermsConditions = termsAndCondition; billMaster.ShipAddL1 = Client.ShipAddL1; billMaster.ShipAddL2 = Client.ShipAddL2; billMaster.ShipStateID = Client.ShipStateID; billMaster.ShipAddCityID = Client.ShipAddCityID; billMaster.CreatedBy = 1; billMaster.CreatedOn = DateTime.Now; //Create New Bill billMasterID = bAL_Bill.CreateNewBill(billMaster); foreach (ProductsMaster products in productList) { bool productExist = false; var clientproductID = products.ID; products.ID = 0; Int64 productID = -1; if (!string.IsNullOrEmpty(products.HSNCode)) { productExist = bAL_Products.CheckIfProductExistByHSNCode(products.HSNCode, out productID); } else if (!string.IsNullOrEmpty(products.SACCode)) { productExist = bAL_Products.CheckIfProductExistBySACCode(products.SACCode, out productID); } if (productExist) { products.ID = productID; } else { products.ID = bAL_Products.CreateNewProduct(products); } foreach (BillProductMapping productBillMapp in productBillMapping) { if (clientproductID == productBillMapp.ProductID) { productBillMapp.BillID = billMasterID; productBillMapp.ProductID = products.ID; bool created = bAL_Products.CreateNewProductBillMapping(productBillMapp); //Create Customer Product mapping CustomerProductMapping customerProductMapping = new CustomerProductMapping(); customerProductMapping.CustomerID = customerID; customerProductMapping.ProductID = products.ID; customerProductMapping.IsActive = true; customerProductMapping.SalesRate = productBillMapp.SalesRate; Int64 id = bAL_Customers.SaveCustomerProductMapping(customerProductMapping); break; } else { continue; } } } addInvoiceResponse.submited = true; addInvoiceResponse.message = string.Format("Bill generated with BillNO#:{0}", billMasterID); return(js.Serialize(addInvoiceResponse)); } catch (Exception ex) { addInvoiceResponse.submited = false; addInvoiceResponse.message = string.Format("Error occured while generating Bill with message:{0}", ex.Message); return(js.Serialize(addInvoiceResponse)); } }