public static List<ProductDetailsBLL> GetDetailByUser(int UserID)
{
DataSet ds = SIMSClassLibrary.DAL.ProductDetails.GetAllRecordsByUser(UserID);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
List<ProductDetailsBLL> lstproductdetailsBLL = new List<ProductDetailsBLL>();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
ProductDetailsBLL objproductdetailsBLL = new ProductDetailsBLL();
if (!ds.Tables[0].Rows[i]["ProductID"].Equals(DBNull.Value))
objproductdetailsBLL._ProductID = Convert.ToInt32(ds.Tables[0].Rows[i]["ProductID"]);
//if (!ds.Tables[0].Rows[i]["VendorID"].Equals(DBNull.Value))
// objproductdetailsBLL._VendorID = Convert.ToInt32(ds.Tables[0].Rows[i]["VendorID"]);
//if (!ds.Tables[0].Rows[i]["ProductCompanyID"].Equals(DBNull.Value))
// objproductdetailsBLL._ProductCompanyID = Convert.ToInt32(ds.Tables[0].Rows[i]["ProductCompanyID"]);
//if (!ds.Tables[0].Rows[i]["ProductSizeID"].Equals(DBNull.Value))
// objproductdetailsBLL._ProductSizeID = Convert.ToInt32(ds.Tables[0].Rows[i]["ProductSizeID"]);
//if (!ds.Tables[0].Rows[i]["ProductColorID"].Equals(DBNull.Value))
// objproductdetailsBLL._ProductColorID = Convert.ToInt32(ds.Tables[0].Rows[i]["ProductColorID"]);
//if (!ds.Tables[0].Rows[i]["ProductCategoryID"].Equals(DBNull.Value))
// objproductdetailsBLL._ProductCategoryID = Convert.ToInt32(ds.Tables[0].Rows[i]["ProductCategoryID"]);
//if (!ds.Tables[0].Rows[i]["ProductForID"].Equals(DBNull.Value))
// objproductdetailsBLL._ProductForID = Convert.ToInt32(ds.Tables[0].Rows[i]["ProductForID"]);
if (!ds.Tables[0].Rows[i]["Name"].Equals(DBNull.Value))
objproductdetailsBLL._Name = Convert.ToString(ds.Tables[0].Rows[i]["Name"]);
//if (!ds.Tables[0].Rows[i]["Descryption"].Equals(DBNull.Value))
// objproductdetailsBLL._Descryption = Convert.ToString(ds.Tables[0].Rows[i]["Descryption"]);
//if (!ds.Tables[0].Rows[i]["ShortCode"].Equals(DBNull.Value))
// objproductdetailsBLL._ShortCode = Convert.ToString(ds.Tables[0].Rows[i]["ShortCode"]);
//if (!ds.Tables[0].Rows[i]["Quantity"].Equals(DBNull.Value))
// objproductdetailsBLL._Quantity = Convert.ToInt32(ds.Tables[0].Rows[i]["Quantity"]);
//if (!ds.Tables[0].Rows[i]["TotalPrice"].Equals(DBNull.Value))
// objproductdetailsBLL._TotalPrice = Convert.ToDecimal(ds.Tables[0].Rows[i]["TotalPrice"]);
//if (!ds.Tables[0].Rows[i]["PurchasePrice"].Equals(DBNull.Value))
// objproductdetailsBLL._PurchasePrice = Convert.ToDecimal(ds.Tables[0].Rows[i]["PurchasePrice"]);
if (!ds.Tables[0].Rows[i]["MRP"].Equals(DBNull.Value))
objproductdetailsBLL._MRP = Convert.ToDecimal(ds.Tables[0].Rows[i]["MRP"]);
//if (!ds.Tables[0].Rows[i]["Discount"].Equals(DBNull.Value))
// objproductdetailsBLL._Discount = Convert.ToInt32(ds.Tables[0].Rows[i]["Discount"]);
if (!ds.Tables[0].Rows[i]["CreatedOn"].Equals(DBNull.Value))
objproductdetailsBLL._CreatedOn = Convert.ToDateTime(ds.Tables[0].Rows[i]["CreatedOn"]);
if (!ds.Tables[0].Rows[i]["UpdateOn"].Equals(DBNull.Value))
objproductdetailsBLL._UpdatedOn = Convert.ToDateTime(ds.Tables[0].Rows[i]["UpdateOn"]);
if (!ds.Tables[0].Rows[i]["CreatedBy"].Equals(DBNull.Value))
objproductdetailsBLL._CreatedBy = Convert.ToInt32(ds.Tables[0].Rows[i]["CreatedBy"]);
if (!ds.Tables[0].Rows[i]["UpdatedBy"].Equals(DBNull.Value))
objproductdetailsBLL._UpdatedBy = Convert.ToInt32(ds.Tables[0].Rows[i]["UpdatedBy"]);
if (!ds.Tables[0].Rows[i]["ProductBarCodeDetaiID"].Equals(DBNull.Value))
objproductdetailsBLL._ProductBarCodeDetaiID = Convert.ToInt32(ds.Tables[0].Rows[i]["ProductBarCodeDetaiID"]);
if (!ds.Tables[0].Rows[i]["ProductID"].Equals(DBNull.Value))
objproductdetailsBLL._ProductID = Convert.ToInt32(ds.Tables[0].Rows[i]["ProductID"]);
if (!ds.Tables[0].Rows[i]["BarCodeNumber"].Equals(DBNull.Value))
objproductdetailsBLL._BarCodeNumber = Convert.ToString(ds.Tables[0].Rows[i]["BarCodeNumber"]);
if (!ds.Tables[0].Rows[i]["ExtaDiscount"].Equals(DBNull.Value))
objproductdetailsBLL._ExtaDiscount = Convert.ToInt32(ds.Tables[0].Rows[i]["ExtaDiscount"]);
//if (!ds.Tables[0].Rows[i]["CreatedBy"].Equals(DBNull.Value))
// _CreatedBy = Convert.ToInt32(ds.Tables[0].Rows[i]["CreatedBy"]);
//if (!ds.Tables[0].Rows[i]["CreatedOn"].Equals(DBNull.Value))
// _CreatedOn = Convert.ToDateTime(ds.Tables[0].Rows[i]["CreatedOn"]);
//if (!ds.Tables[0].Rows[i]["UpdatedBy"].Equals(DBNull.Value))
// _UpdatedBy = Convert.ToInt32(ds.Tables[0].Rows[i]["UpdatedBy"]);
//if (!ds.Tables[0].Rows[i]["UpdateOn"].Equals(DBNull.Value))
// _UpdateOn = Convert.ToDateTime(ds.Tables[0].Rows[i]["UpdateOn"]);
if (!ds.Tables[0].Rows[i]["IsDeleted"].Equals(DBNull.Value))
objproductdetailsBLL._IsDeleted = Convert.ToBoolean(ds.Tables[0].Rows[i]["IsDeleted"]);
if (!ds.Tables[0].Rows[i]["DeletedOn"].Equals(DBNull.Value))
objproductdetailsBLL._DeletedOn = Convert.ToDateTime(ds.Tables[0].Rows[i]["DeletedOn"]);
if (!ds.Tables[0].Rows[i]["IsBarcodeGenerated"].Equals(DBNull.Value))
objproductdetailsBLL._IsBarcodeGenerated = Convert.ToBoolean(ds.Tables[0].Rows[i]["IsBarcodeGenerated"]);
if (!ds.Tables[0].Rows[i]["CategoryName"].Equals(DBNull.Value))
objproductdetailsBLL._CategoryName = Convert.ToString(ds.Tables[0].Rows[i]["CategoryName"]);
if (!ds.Tables[0].Rows[i]["SizeName"].Equals(DBNull.Value))
objproductdetailsBLL._SizeName = Convert.ToString(ds.Tables[0].Rows[i]["SizeName"]);
lstproductdetailsBLL.Add(objproductdetailsBLL);
}
return lstproductdetailsBLL;
}
else
return null;
}
public static ProductDetailsBLL GetAllRecordsByUserAndBarcodeNumber(int UserID, string BarcodeNumber)
{
DataSet ds = SIMSClassLibrary.DAL.ProductDetails.GetAllRecordsByUserAndBarcodeNumber(UserID, BarcodeNumber);
ProductDetailsBLL objproductdetailsBLL = new ProductDetailsBLL();
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
if (!ds.Tables[0].Rows[i]["Name"].Equals(DBNull.Value))
objproductdetailsBLL._Name = Convert.ToString(ds.Tables[0].Rows[i]["Name"]);
if (!ds.Tables[0].Rows[i]["MRP"].Equals(DBNull.Value))
objproductdetailsBLL._MRP = Convert.ToDecimal(ds.Tables[0].Rows[i]["MRP"]);
if (!ds.Tables[0].Rows[i]["Discount"].Equals(DBNull.Value))
objproductdetailsBLL._Discount = Convert.ToInt32(ds.Tables[0].Rows[i]["Discount"]);
if (!ds.Tables[0].Rows[i]["ProductBarCodeDetaiID"].Equals(DBNull.Value))
objproductdetailsBLL._ProductBarCodeDetaiID = Convert.ToInt32(ds.Tables[0].Rows[i]["ProductBarCodeDetaiID"]);
if (!ds.Tables[0].Rows[i]["ProductID"].Equals(DBNull.Value))
objproductdetailsBLL._ProductID = Convert.ToInt32(ds.Tables[0].Rows[i]["ProductID"]);
if (!ds.Tables[0].Rows[i]["BarCodeNumber"].Equals(DBNull.Value))
objproductdetailsBLL._BarCodeNumber = Convert.ToString(ds.Tables[0].Rows[i]["BarCodeNumber"]);
}
return objproductdetailsBLL;
}
else
return null;
}