public List <ProductModel> GetAllProductModel(ProductModelAdvanceSearch productModelAdvanceSearch)
{
return(_prductModelRepository.GetAllProductModel(productModelAdvanceSearch));
}
public List <ProductModel> GetAllProductModel(ProductModelAdvanceSearch productModelAdvanceSearch)
{
List <ProductModel> productModelList = null;
try
{
using (SqlConnection con = _databaseFactory.GetDBConnection())
{
using (SqlCommand cmd = new SqlCommand())
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
cmd.Connection = con;
cmd.CommandText = "[PSA].[GetAllProductModel]";
cmd.Parameters.Add("@SearchValue", SqlDbType.NVarChar, -1).Value = string.IsNullOrEmpty(productModelAdvanceSearch.SearchTerm) ? "" : productModelAdvanceSearch.SearchTerm;
cmd.Parameters.Add("@RowStart", SqlDbType.Int).Value = productModelAdvanceSearch.DataTablePaging.Start;
if (productModelAdvanceSearch.DataTablePaging.Length == -1)
{
cmd.Parameters.AddWithValue("@Length", DBNull.Value);
}
else
{
cmd.Parameters.Add("@Length", SqlDbType.Int).Value = productModelAdvanceSearch.DataTablePaging.Length;
}
cmd.CommandType = CommandType.StoredProcedure;
using (SqlDataReader sdr = cmd.ExecuteReader())
{
if ((sdr != null) && (sdr.HasRows))
{
productModelList = new List <ProductModel>();
while (sdr.Read())
{
ProductModel productModel = new ProductModel();
{
productModel.ID = (sdr["ID"].ToString() != "" ? Guid.Parse(sdr["ID"].ToString()) : productModel.ID);
productModel.Product = new Product();
productModel.Product.Name = (sdr["ProductName"].ToString() != "" ? sdr["ProductName"].ToString() : productModel.Product.Name);
// productModel.ProductID = (sdr["ProductID"].ToString() != "" ? Guid.Parse(sdr["ProductID"].ToString()) : productModel.ProductID);
productModel.Name = (sdr["Name"].ToString() != "" ? sdr["Name"].ToString() : productModel.Name);
productModel.Unit = new Unit();
productModel.Unit.Description = (sdr["Unit"].ToString() != "" ? sdr["Unit"].ToString() : productModel.Unit.Description);
// productModel.UnitCode = (sdr["UnitCode"].ToString() != "" ? int.Parse(sdr["UnitCode"].ToString()) : productModel.UnitCode);
productModel.Specification = (sdr["Specification"].ToString() != "" ? sdr["Specification"].ToString().Replace("$n$", "\n") : productModel.Specification);
productModel.CostPrice = (sdr["CostPrice"].ToString() != "" ? Decimal.Parse(sdr["CostPrice"].ToString()) : productModel.CostPrice);
productModel.SellingPrice = (sdr["SellingPrice"].ToString() != "" ? Decimal.Parse(sdr["SellingPrice"].ToString()) : productModel.SellingPrice);
productModel.IntroducedDate = (sdr["IntroducedDate"].ToString() != "" ? DateTime.Parse(sdr["IntroducedDate"].ToString()) : productModel.IntroducedDate);
productModel.IntroducedDateFormatted = (sdr["IntroducedDate"].ToString() != "" ? DateTime.Parse(sdr["IntroducedDate"].ToString()).ToString(_settings.DateFormat) : productModel.IntroducedDateFormatted);
productModel.StockQty = (sdr["StockQty"].ToString() != "" ? Decimal.Parse(sdr["StockQty"].ToString()) : productModel.StockQty);
productModel.TotalCount = (sdr["TotalCount"].ToString() != "" ? int.Parse(sdr["TotalCount"].ToString()) : productModel.TotalCount);
productModel.FilteredCount = (sdr["FilteredCount"].ToString() != "" ? int.Parse(sdr["FilteredCount"].ToString()) : productModel.FilteredCount);
}
productModelList.Add(productModel);
}
}
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(productModelList);
}
