public IHttpActionResult GetBillDetail(int id)
{
IEnumerable <string> HeaderValue;
var QTID = "";
if (GlobalVeriables.WebApiClient.DefaultRequestHeaders.TryGetValues("QTID", out HeaderValue))
{
QTID = HeaderValue.FirstOrDefault();
}
int QTIDs = (QTID != "" ? Convert.ToInt32(QTID) : 0);
if (QTIDs != 0)
{
var query = db.BillDetailTables.ToList().Where(c => c.BillDetailId == QTIDs).Select(pd => new
{
BillID = pd.BillID,
BillDetailId = pd.BillDetailId,
ItemId = pd.ItemId,
Rate = pd.Rate,
Description = pd.Description,
Quantity = pd.Quantity,
Vat = pd.Vat,
Total = pd.Total,
Type = pd.Type,
RowSubTotal = pd.RowSubTotal,
}).ToList();
return(Ok(query));
}
else
{
var query = (from pd in db.BillDetailTables
join p in db.ProductTables on pd.ItemId equals p.ProductId
where pd.BillID == id
select new BillDetailViewModel
{
ServiceDate = pd.ServiceDate,
BilID = pd.BillID,
BillDetailId = pd.BillDetailId,
ItemId = pd.ItemId,
Rate = pd.Rate,
Description = pd.Description,
Quantity = pd.Quantity,
Vat = pd.Vat,
Total = pd.Total,
Type = pd.Type,
ItemName = p.ProductName,
RowSubTotal = pd.RowSubTotal,
}).ToList();
if (query == null)
{
return(NotFound());
}
return(Ok(query));
}
}
public IHttpActionResult GetQutationDetailsTable(int id)
{
IEnumerable <string> HeaderValue;
var QTID = "";
if (GlobalVeriables.WebApiClient.DefaultRequestHeaders.TryGetValues("QTID", out HeaderValue))
{
QTID = HeaderValue.FirstOrDefault();
}
int QTIDs = (QTID != "" ? Convert.ToInt32(QTID) : 0);
if (QTIDs != 0)
{
var query = db.QutationDetailsTables.ToList().Where(c => c.QutationID == QTIDs).ToList();
return(Ok(query));
}
else
{
// List<MVCQutationViewModel> qutationDetailsTable = new List<MVCQutationViewModel>();
// var obj = db.QutationDetailsTables.ToList().Where(c => c.QutationID == QviewModel.QutationID).ToList();
var query = (from pd in db.QutationDetailsTables
join p in db.ProductTables on pd.ItemId equals p.ProductId
where pd.QutationID == id
select new MVCQutationViewModel
{
ItemId = pd.ItemId,
QutationID = pd.QutationID,
Rate = pd.Rate,
Quantity = pd.Quantity,
Vat = pd.Vat,
ItemName = p.ProductName,
Total = pd.Total,
QutationDetailId = pd.QutationDetailId
}).ToList();
if (query == null)
{
return(NotFound());
}
return(Ok(query));
}
}
public IHttpActionResult GetPurchaseDetailsTable(int id)
{
IEnumerable <string> HeaderValue;
var PDID = "";
if (GlobalVeriables.WebApiClient.DefaultRequestHeaders.TryGetValues("PDID", out HeaderValue))
{
PDID = HeaderValue.FirstOrDefault();
}
int PDIDs = (PDID != "" ? Convert.ToInt32(PDID) : 0);
if (PDIDs != 0)
{
var query = db.PurchaseOrderDetailsTables.ToList().Where(c => c.PurchaseId == PDIDs).Select(pd => new MvcPurchaseViewModel
{
PurchaseOrderDetailsId = (int)pd.PurchaseOrderDetailsId,
PurchaseItemId = pd.PurchaseOrderDetailsId,
PurchaseDescription = pd.PurchaseDescription,
PurchaseQuantity = pd.PurchaseQuantity,
PurchaseItemRate = pd.PurchaseItemRate,
PurchaseTotal = pd.PurchaseTotal,
PurchaseVatPercentage = pd.PurchaseVatPercentage,
PurchaseId = pd.PurchaseId,
Type = pd.Type,
RowSubTotal = pd.RowSubTotal,
ServiceDate = pd.ServiceDate,
Purchase_ID = pd.PurchaseOrderTable.PurchaseID
}).ToList();
return(Ok(query));
}
else
{
// List<MVCQutationViewModel> qutationDetailsTable = new List<MVCQutationViewModel>();
// var obj = db.QutationDetailsTables.ToList().Where(c => c.QutationID == QviewModel.QutationID).ToList();
var query = (from pd in db.PurchaseOrderDetailsTables
join p in db.ProductTables on pd.PurchaseItemId equals p.ProductId
where pd.PurchaseId == id
select new MvcPurchaseViewModel
{
Type = pd.Type,
ServiceDate = pd.ServiceDate,
PurchaseItemId = pd.PurchaseItemId,
PurchaseId = pd.PurchaseId,
PurchaseItemRate = pd.PurchaseItemRate,
PurchaseQuantity = pd.PurchaseQuantity,
PurchaseVatPercentage = pd.PurchaseVatPercentage,
PurchaseItemName = p.ProductName,
PurchaseTotal = pd.PurchaseTotal,
PurchaseOrderID = (int)pd.PurchaseId,
PurchaseDescription = pd.PurchaseDescription,
RowSubTotal = pd.RowSubTotal,
PurchaseOrderDetailsId = (int)pd.PurchaseOrderDetailsId
}).ToList();
if (query == null)
{
return(NotFound());
}
return(Ok(query));
}
}