public List <ProductDetail> GetProductByDate(string fromDate, string toDate, int ProductId, int StockTransactionId)
{
DBSite site = new DBSite();
List <ProductDetail> product_detail_list = new List <ProductDetail>();
if (fromDate == null)
{
fromDate = "2013/09/01";
}
if (toDate == null)
{
toDate = "2014/09/01";
}
DateTime fDt = DateTime.Parse(fromDate);
DateTime tDt = DateTime.Parse(toDate);
DataTable dt = site.Execute_sp_productLedger(ProductId, StockTransactionId, -1, fDt, tDt, Util_BLL.User.UserId, 2012);
DataRow row = null;
ProductDetail product;
for (int i = 0; i < dt.Rows.Count; i++)
{
product = new ProductDetail();
row = dt.Rows[i];
product.ProductLedgerId = util.CheckNullInt(row["ProductLedgerNumber"]);
product.ProductId = util.CheckNullInt(row["ProductId"]);
product.ProductName = row["ProductName"].ToString();
product.LocationName = util.CheckNull(row["Location"]);
product.AccountName = util.CheckNull(row["AccountName"]);
product.sold_qty = util.CheckNullDouble(row["credit"]);
product.bought_qty = util.CheckNullDouble(row["debit"]);
product.openingBalance = util.CheckNullDouble(row["openingBalance"]);
product.closingBalance = util.CheckNullDouble(row["runningBalance"]);
//666
DateTime date = Convert.ToDateTime(row["BillDate"]);
product.MovementDate = date.ToShortDateString();
product.TransactionTypeId = util.CheckNullInt(row["SourceId"]);
product.TransactionName = util.CheckNull(row["TransactionName"]);
product.Narration = util.CheckNull(row["Particulars"]);
product_detail_list.Add(product);
}
return(product_detail_list);
}