public IEnumerable <StockLedgerViewModel> GetStockLederBalance(int id, string UserName)
{
var Settings = new StockInHandSettingService(_unitOfWork).GetTrailBalanceSetting(UserName);
string SiteId = Settings.SiteIds;
string DivisionId = Settings.DivisionIds;
string FromDate = Settings.FromDate.HasValue ? Settings.FromDate.Value.ToString("dd/MMM/yyyy") : "";
string ToDate = Settings.ToDate.HasValue ? Settings.ToDate.Value.ToString("dd/MMM/yyyy") : "";
SqlParameter SqlParameterSiteId = new SqlParameter("@Site", !string.IsNullOrEmpty(SiteId) ? SiteId : (object)DBNull.Value);
SqlParameter SqlParameterDivisionId = new SqlParameter("@Division", !string.IsNullOrEmpty(DivisionId) ? DivisionId : (object)DBNull.Value);
SqlParameter SqlParameterFromDate = new SqlParameter("@FromDate", FromDate);
SqlParameter SqlParameterToDate = new SqlParameter("@ToDate", ToDate);
SqlParameter SqlParameterStockLederAccountId = new SqlParameter("@StockLederAccountId", id);
IEnumerable <StockLedgerViewModel> StockInHandList = db.Database.SqlQuery <StockLedgerViewModel>("" + ConfigurationManager.AppSettings["DataBaseSchema"] + ".spStockLeder @Site, @Division, @FromDate, @ToDate, @StockLederAccountId", SqlParameterSiteId, SqlParameterDivisionId, SqlParameterFromDate, SqlParameterToDate, SqlParameterStockLederAccountId).ToList();
return(StockInHandList);
}
public IEnumerable <StockInHandViewModel> GetStockProcessDisplay(int id, string UserName)
{
var Settings = new StockInHandSettingService(_unitOfWork).GetTrailBalanceSetting(UserName);
SqlParameter SqlParameterGroupOn;
SqlParameter SqlParameterSiteId;
SqlParameter SqlParameterToDate;
SqlParameter SqlParameterFromDate;
SqlParameter SqlParameterShowBalance;
if (string.IsNullOrEmpty(Settings.GroupOn))
{
SqlParameterGroupOn = new SqlParameter("@GroupOn", DBNull.Value);
}
else
{
SqlParameterGroupOn = new SqlParameter("@GroupOn", Settings.GroupOn);
}
if (string.IsNullOrEmpty(Settings.SiteIds))
{
SqlParameterSiteId = new SqlParameter("@Site", DBNull.Value);
}
else
{
SqlParameterSiteId = new SqlParameter("@Site", Settings.SiteIds);
}
//if (string.IsNullOrEmpty(Settings.DivisionIds))
// SqlParameterDivisionId = new SqlParameter("@Division", DBNull.Value);
//else
// SqlParameterDivisionId = new SqlParameter("@Division", Settings.DivisionIds);
if (!Settings.ToDate.HasValue)
{
SqlParameterToDate = new SqlParameter("@ToDate", DBNull.Value);
}
else
{
SqlParameterToDate = new SqlParameter("@ToDate", Settings.ToDate.Value.ToString("dd/MMM/yyyy"));
}
if (!Settings.FromDate.HasValue)
{
SqlParameterFromDate = new SqlParameter("@FromDate", DBNull.Value);
}
else
{
SqlParameterFromDate = new SqlParameter("@FromDate", Settings.FromDate.Value.ToString("dd/MMM/yyyy"));
}
SqlParameter SqlParameterProdType = new SqlParameter("@ProductType", id);
if (string.IsNullOrEmpty(Settings.ShowBalance) || Settings.ShowBalance == StockInHandShowBalanceConstants.All)
{
SqlParameterShowBalance = new SqlParameter("@ShowBalance", DBNull.Value);
}
else
{
SqlParameterShowBalance = new SqlParameter("@ShowBalance", Settings.ShowBalance);
}
SqlParameter SqlParameterProduct = new SqlParameter("@Product", DBNull.Value);
SqlParameter SqlParameterGodown = new SqlParameter("@Godown", DBNull.Value);
SqlParameter SqlParameterProcess = new SqlParameter("@Process", DBNull.Value);
SqlParameter SqlParameterDimension1 = new SqlParameter("@Dimension1", DBNull.Value);
SqlParameter SqlParameterDimension2 = new SqlParameter("@Dimension2", DBNull.Value);
SqlParameter SqlParameterDimension3 = new SqlParameter("@Dimension3", DBNull.Value);
SqlParameter SqlParameterDimension4 = new SqlParameter("@Dimension4", DBNull.Value);
SqlParameter SqlParameterProdNature = new SqlParameter("@ProductNature", DBNull.Value);
SqlParameter SqlParameterProdGroup = new SqlParameter("@ProductGroup", DBNull.Value);
SqlParameter SqlParameterProdCustomGroup = new SqlParameter("@ProductCustomGroup", DBNull.Value);
IEnumerable <StockInHandViewModel> StockInHandList = db.Database.SqlQuery <StockInHandViewModel>("Web.spStockProcess_ForMultipleProductDisplay @ProductType, @Site, @FromDate, @ToDate, @GroupOn, @ShowBalance, @Product, @Godown, @Process, @Dimension1, @Dimension2,@Dimension3, @Dimension4, @ProductNature, @ProductGroup, @ProductCustomGroup", SqlParameterProdType, SqlParameterSiteId, SqlParameterFromDate, SqlParameterToDate, SqlParameterGroupOn, SqlParameterShowBalance, SqlParameterProduct, SqlParameterGodown, SqlParameterProcess, SqlParameterDimension1, SqlParameterDimension2, SqlParameterDimension3, SqlParameterDimension4, SqlParameterProdNature, SqlParameterProdGroup, SqlParameterProdCustomGroup).ToList();
return(StockInHandList);
}
public IEnumerable <StockLedgerViewModel> GetStockProcessLedger(int?ProductId, int?Dim1, int?Dim2, int?Dim3, int?Dim4, int?Process, string LotNo, int?Godown, string UserName)
{
var Settings = new StockInHandSettingService(_unitOfWork).GetTrailBalanceSetting(UserName);
SqlParameter SqlParameterGroupOn;
SqlParameter SqlParameterSiteId;
SqlParameter SqlParameterDivisionId;
SqlParameter SqlParameterToDate;
SqlParameter SqlParameterFromDate;
//SqlParameter SqlParameterShowBalance;
SqlParameter SqlParameterProduct;
SqlParameter SqlParameterGodown;
SqlParameter SqlParameterProcess;
SqlParameter SqlParameterDimension1;
SqlParameter SqlParameterDimension2;
SqlParameter SqlParameterDimension3;
SqlParameter SqlParameterDimension4;
if (string.IsNullOrEmpty(Settings.GroupOn))
{
SqlParameterGroupOn = new SqlParameter("@GroupOn", DBNull.Value);
}
else
{
SqlParameterGroupOn = new SqlParameter("@GroupOn", Settings.GroupOn);
}
if (string.IsNullOrEmpty(Settings.SiteIds))
{
SqlParameterSiteId = new SqlParameter("@Site", DBNull.Value);
}
else
{
SqlParameterSiteId = new SqlParameter("@Site", Settings.SiteIds);
}
if (string.IsNullOrEmpty(Settings.DivisionIds))
{
SqlParameterDivisionId = new SqlParameter("@Division", DBNull.Value);
}
else
{
SqlParameterDivisionId = new SqlParameter("@Division", Settings.DivisionIds);
}
if (!Settings.ToDate.HasValue)
{
SqlParameterToDate = new SqlParameter("@ToDate", DBNull.Value);
}
else
{
SqlParameterToDate = new SqlParameter("@ToDate", Settings.ToDate.Value.ToString("dd/MMM/yyyy"));
}
if (!Settings.FromDate.HasValue)
{
SqlParameterFromDate = new SqlParameter("@FromDate", DBNull.Value);
}
else
{
SqlParameterFromDate = new SqlParameter("@FromDate", Settings.FromDate.Value.ToString("dd/MMM/yyyy"));
}
//if (string.IsNullOrEmpty(Settings.ShowBalance))
// SqlParameterShowBalance = new SqlParameter("@ShowBalance", DBNull.Value);
//else
// SqlParameterShowBalance = new SqlParameter("@ShowBalance", Settings.ShowBalance);
if (!ProductId.HasValue)
{
SqlParameterProduct = new SqlParameter("@Product", DBNull.Value);
}
else
{
SqlParameterProduct = new SqlParameter("@Product", ProductId);
}
if ((!Godown.HasValue))
{
SqlParameterGodown = new SqlParameter("@Godown", DBNull.Value);
}
else
{
SqlParameterGodown = new SqlParameter("@Godown", Godown);
}
if ((!Process.HasValue))
{
SqlParameterProcess = new SqlParameter("@Process", DBNull.Value);
}
else
{
SqlParameterProcess = new SqlParameter("@Process", Process);
}
if ((!Dim1.HasValue))
{
SqlParameterDimension1 = new SqlParameter("@Dimension1", DBNull.Value);
}
else
{
SqlParameterDimension1 = new SqlParameter("@Dimension1", Dim1);
}
if ((!Dim2.HasValue))
{
SqlParameterDimension2 = new SqlParameter("@Dimension2", DBNull.Value);
}
else
{
SqlParameterDimension2 = new SqlParameter("@Dimension2", Dim2);
}
if ((!Dim3.HasValue))
{
SqlParameterDimension3 = new SqlParameter("@Dimension3", DBNull.Value);
}
else
{
SqlParameterDimension3 = new SqlParameter("@Dimension3", Dim3);
}
if ((!Dim4.HasValue))
{
SqlParameterDimension4 = new SqlParameter("@Dimension4", DBNull.Value);
}
else
{
SqlParameterDimension4 = new SqlParameter("@Dimension4", Dim4);
}
SqlParameter SqlParameterProdNature = new SqlParameter("@ProductNature", DBNull.Value);
SqlParameter SqlParameterProdGroup = new SqlParameter("@ProductGroup", DBNull.Value);
SqlParameter SqlParameterProdCustomGroup = new SqlParameter("@ProductCustomGroup", DBNull.Value);
IEnumerable <StockLedgerViewModel> StockInHandList = db.Database.SqlQuery <StockLedgerViewModel>("Web.spStockProcessLedger @Site, @Division, @FromDate, @ToDate, @GroupOn, @Product, @Godown, @Process, @Dimension1, @Dimension2, @Dimension3, @Dimension4", SqlParameterSiteId, SqlParameterDivisionId, SqlParameterFromDate, SqlParameterToDate, SqlParameterGroupOn, SqlParameterProduct, SqlParameterGodown, SqlParameterProcess, SqlParameterDimension1, SqlParameterDimension2, SqlParameterDimension3, SqlParameterDimension4).ToList();
return(StockInHandList);
}
