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));
}
