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; } }
public long CreateNewProduct(ProductsMaster products) { using (var context = new InvoiceGenEntities()) { context.ProductsMasters.Add(products); context.SaveChanges();//this generates the Id for customer return(products.ID); } }
/// <summary> /// Saves List of Products to Database /// </summary> /// <param name="listProduct"></param> public List <ProductsMaster> SaveProductsData(List <ProductsMaster> listProduct) { using (var context = new InvoiceGenEntities()) { try { foreach (var product in listProduct) { ProductsMaster prod = new ProductsMaster(); if (product.HSNCode != null) { prod = context.ProductsMasters.SqlQuery("Select * from ProductsMaster where HSNCode=@HSNCode", new SqlParameter("@HSNCode", product.HSNCode)).FirstOrDefault(); } else if (product.SACCode != null) { prod = context.ProductsMasters.SqlQuery("Select * from ProductsMaster where SACCode=@SACCode", new SqlParameter("@SACCode", product.SACCode)).FirstOrDefault(); } if (prod == null) { context.ProductsMasters.Add(product); context.SaveChanges(); } } } catch (DbEntityValidationException e) { foreach (var eve in e.EntityValidationErrors) { foreach (var ve in eve.ValidationErrors) { throw new Exception(string.Format("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage)); } } } catch (Exception ex) { throw ex; } return(listProduct); } }
public bool CheckIfProductExistBySACode(string sACCode, out long productID) { productID = -1; ProductsMaster productsMaster = new ProductsMaster(); using (var context = new InvoiceGenEntities()) { productsMaster = (from a in context.ProductsMasters where a.SACCode == sACCode select a).FirstOrDefault(); } if (productsMaster != null) { productID = productsMaster.ID; return(true); } else { return(false); } }
/// <summary> /// Saves the products data to DB /// </summary> /// <param name="dt"></param> public List <ProductsMaster> SaveProductsData(DataTable dt, Requester requester) { DAL_Products dAL_Products = new DAL_Products(); DAL_Common dAL_Common = new DAL_Common(); List <ProductsMaster> listProduct = new List <ProductsMaster>(); UserMaster userMaster = new UserMaster(); userMaster = dAL_Common.GetUserdetailsByUsername(requester.Name); if (dt != null & dt.Rows.Count > 0) { foreach (DataRow row in dt.Rows) { ProductsMaster product = new ProductsMaster(); product.Name = Convert.ToString(row["Name"]); product.HSNCode = Convert.ToString(row["HSNCode"] is DBNull ? DBNull.Value : row["HSNCode"]); product.SACCode = Convert.ToString(row["SACCode"] is DBNull ? DBNull.Value : row["SACCode"]); product.Description = Convert.ToString(row["Description"]); product.CessPercentage = Convert.ToString(row["CessPercentage"]); product.GSTPercentage = Convert.ToString(row["GSTPercentage"]).Equals("NIL", StringComparison.InvariantCultureIgnoreCase) ? null : Convert.ToString(row["GSTPercentage"]); product.IsActive = true; product.CreatedOn = DateTime.Now; product.UpdatedOn = DateTime.Now; if (userMaster != null) { product.CreatedBy = userMaster.ID; product.UpdatedBy = userMaster.ID; } else { product.CreatedBy = 1; product.UpdatedBy = 1; } listProduct.Add(product); } return(dAL_Products.SaveProductsData(listProduct)); } return(listProduct); }
public long CreateNewProduct(ProductsMaster products) { DAL_Products dAL_Products = new DAL_Products(); return(dAL_Products.CreateNewProduct(products)); }