public string DDLGetSelectionID(PrqSelectionReport data)
{
string dd = "";
var storeLocationList = _dalPrqPurchaseChallan.GetSelectionListID(data.StoreId, data.SupllierId, data.DateFrom, data.DateTo);
dd = "<option>-- Select One --</option>";
foreach (var item in storeLocationList)
{
dd += "<option value='" + item.SelectionID + "'> " + item.SelectionID + " (" + Convert.ToDateTime(item.SelectionDate).ToString("dd/MM/yyyy") + ") </option>";
}
return(dd);
}
public string PurchaseDDL(PrqSelectionReport data)
{
string dd = "";
List <Prq_Purchase> storeLocationList = _dalPrqPurchaseChallan.GetPurchaseListID(data.SupllierId, data.DateFrom, data.DateTo);
// var lst= storeLocationList.GroupBy(test => test.PurchaseID).Select(group => group.First());
dd = "<option>-- Select All --</option>";
foreach (var item in storeLocationList)
{
dd += "<option value='" + item.PurchaseID + "'> " + item.PurchaseNo + " (" + item.PurchaseDate.ToString("dd/MM/yyyy") + ") </option>";
}
return(dd);
}
public string PurchaseIDBySupplierID(PrqSelectionReport data)
{
string dd = "";
DateTime DateFrom = DalCommon.SetDate(data.DateFrom);
DateTime DateTo = DalCommon.SetDate(data.DateTo);
var storeLocationList = repository.PrqPurchaseRepository.Get(filter: ob => ob.SupplierID == data.SupllierId && (ob.PurchaseDate >= DateFrom && ob.PurchaseDate <= DateTo)).OrderByDescending(o => o.PurchaseID);
dd = "<option value='all'>All Purchase Summary</option>";
if (storeLocationList.Count() > 0)
{
dd += "<option value='alldetails'>All Purchase Details</option>";
foreach (var item in storeLocationList)
{
dd += "<option value='" + item.PurchaseID + "'> " + item.PurchaseNo + " (" + item.PurchaseDate.ToString("dd/MM/yyyy") + ") </option>";
}
}
return(dd);
}
