public DataTable GetAll(DateTime?dateFrom, DateTime?dateTo, int?categoryId, int?branchId = null, long?productId = null)
{
DataTable dt = new DataTable();
SqlParameter[] sqlParameters = new SqlParameter[]
{
new SqlParameter()
{
ParameterName = "DateFrom", Value = dateFrom, SqlDbType = SqlDbType.DateTime
},
new SqlParameter()
{
ParameterName = "DateTo", Value = dateTo, SqlDbType = SqlDbType.DateTime
},
new SqlParameter()
{
ParameterName = "BranchID", Value = branchId, SqlDbType = SqlDbType.Int
},
new SqlParameter()
{
ParameterName = "CategoryID", Value = categoryId, SqlDbType = SqlDbType.Int
},
new SqlParameter()
{
ParameterName = "ProductID", Value = productId, SqlDbType = SqlDbType.BigInt
}
};
dt = _reportCombination.ExecuteSPReturnTable("uspStockReport", true, sqlParameters);
return(dt);
}
public string SaveBatchUpload(ProductDto dto)
{
DataTable dt = new DataTable();
if (!dto.IsNull())
{
SqlParameter[] sqlParameters = new SqlParameter[]
{
new SqlParameter()
{
ParameterName = "CategoryCode", Value = dto.CategoryCode, SqlDbType = SqlDbType.DateTime
},
new SqlParameter()
{
ParameterName = "ProductCode", Value = dto.ProductCode, SqlDbType = SqlDbType.DateTime
},
new SqlParameter()
{
ParameterName = "ProductName", Value = dto.ProductName, SqlDbType = SqlDbType.Int
},
new SqlParameter()
{
ParameterName = "Extension", Value = dto.ProductExtension, SqlDbType = SqlDbType.Int
},
new SqlParameter()
{
ParameterName = "Quantity", Value = dto.Quantity, SqlDbType = SqlDbType.BigInt
},
new SqlParameter()
{
ParameterName = "OriginalPrice", Value = dto.OriginalPrice, SqlDbType = SqlDbType.BigInt
},
new SqlParameter()
{
ParameterName = "Price", Value = dto.Price, SqlDbType = SqlDbType.BigInt
},
new SqlParameter()
{
ParameterName = "Size", Value = dto.Size, SqlDbType = SqlDbType.BigInt
},
new SqlParameter()
{
ParameterName = "SupplierCode", Value = dto.SupplierCode, SqlDbType = SqlDbType.BigInt
},
new SqlParameter()
{
ParameterName = "BranchName", Value = dto.BranchName, SqlDbType = SqlDbType.BigInt
},
new SqlParameter()
{
ParameterName = "Description", Value = dto.ProductDesc, SqlDbType = SqlDbType.BigInt
},
new SqlParameter()
{
ParameterName = "Remarks", Value = dto.Remarks, SqlDbType = SqlDbType.BigInt
},
new SqlParameter()
{
ParameterName = "CreatedBy", Value = dto.CreatedBy, SqlDbType = SqlDbType.BigInt
}
};
dt = _reportCombination.ExecuteSPReturnTable("uspSalesReport", true, sqlParameters);
if (dt.Rows.Count > 0)
{
return(dt.Rows[0].ToString());
}
else
{
return(string.Empty);
}
}
else
{
return(Messages.ErrorOccuredDuringProcessing);
}
}
//return results:
//result = 0 -> no error
//result = 1 -> system error
//result = 2 -> batch no error
//result = 3 -> bulk insert batchproductlog error
//result = 4 -> BATCH UPLOAD data message return <= 0
//result = 5 -> Successfully inserted ALL records
//result = 6 -> Successfully inserted but with errors
//result = 7 -> All records error
public int SaveBulkProducts(BatchSummariesDto dto, List <BatchProductLogDto> dtoList)
{
int result = 0;
if (!dto.IsNull())
{
this.batchSummary = dto.DtoToEntity();
var batchNoIdentity = _batchSummary.Insert(this.batchSummary).BatchNo;
if (!batchNoIdentity.IsNull() && batchNoIdentity <= 0)
{
result = 2;
}
else
{
if (!SaveProductBulk(dtoList, batchNoIdentity))
{
result = 3;
}
else
{
DataTable dtResultSet = new DataTable();
SqlParameter[] sqlParameters = new SqlParameter[]
{
new SqlParameter()
{
ParameterName = "BatchNo", SqlValue = batchNoIdentity, SqlDbType = SqlDbType.BigInt
}
};
dtResultSet = _product.ExecuteSPReturnTable("uspBatchProductCreation", true, sqlParameters);
if (dtResultSet.Rows.Count <= 0)
{
result = 4;
}
else
{
if (dtResultSet.Rows[0][Globals.Result].ToString() == "5")
{
result = 0;
}
else if (dtResultSet.Rows[0][Globals.Result].ToString() == "6")
{
result = 6;
}
else if (dtResultSet.Rows[0][Globals.Result].ToString() == "7")
{
result = 7;
}
}
}
}
}
else
{
result = 1;
}
return(result);
}
