public PriceQuotationUI()
{
InitializeComponent();
loPriceQuotation = new PriceQuotation();
loPriceQuotationDetail = new PriceQuotationDetail();
loCommon = new Common();
ldtPriceQuotation = new System.Data.DataTable();
loPriceQuotationRpt = new PriceQuotationRpt();
loPriceQuotationDetailRpt = new PriceQuotationDetailRpt();
loReportViewer = new ReportViewerUI();
}
public PriceQuotationDetailUI(string pPriceQuotationId)
{
InitializeComponent();
lOperation = GlobalVariables.Operation.Edit;
loPriceQuotation = new PriceQuotation();
loPriceQuotationDetail = new PriceQuotationDetail();
loCustomer = new Customer();
loSalesPerson = new SalesPerson();
loStock = new Stock();
loCommon = new Common();
//loStockReceivingDetailRpt = new StockReceivingDetailRpt();
loReportViewer = new ReportViewerUI();
lPriceQuotationId = pPriceQuotationId;
}
public SalesOrderDetailUI(string pSalesOrderId)
{
InitializeComponent();
lOperation = GlobalVariables.Operation.Edit;
loSalesOrder = new SalesOrder();
loSalesOrderDetail = new SalesOrderDetail();
loPriceQuotation = new PriceQuotation();
loPriceQuotationDetail = new PriceQuotationDetail();
loCustomer = new Customer();
loSalesPerson = new SalesPerson();
loStock = new Stock();
loCommon = new Common();
loLookUpPriceQuotation = new LookUpPriceQuotationUI();
loReportViewer = new ReportViewerUI();
lSalesOrderId = pSalesOrderId;
}
public ActionResult ReadWoredasWithOutBidOffer([DataSourceRequest] DataSourceRequest request, int bidID, int regionID)
{
var planID = _bidService.FindById(bidID).TransportBidPlanID;
var bidPlanDetail =
_transportBidPlanDetailService.FindBy(t => t.Destination.AdminUnit2.AdminUnit2.AdminUnitID == regionID &&
t.BidPlanID == planID);
var df = (from planDetail in bidPlanDetail
group planDetail by new
{
planDetail.DestinationID,
planDetail.SourceID
}
into gr
select gr
);
var detailPlans = df.Select(d => d.ToList()).Select(er => er.FirstOrDefault()).ToList();
var result = new List <PriceQuotationDetail>();
foreach (var transportBidPlanDetail in detailPlans)
{
var pdetail = transportBidPlanDetail;
var detail = _transportBidQuotationService.FindBy(t => t.BidID == bidID &&
t.SourceID == pdetail.SourceID &&
t.DestinationID == pdetail.DestinationID).FirstOrDefault();
if (detail == null)
{
var n = new PriceQuotationDetail()
{
SourceWarehouse = pdetail.Source.Name,
Zone = pdetail.Destination.AdminUnit2.Name,
Woreda = pdetail.Destination.Name,
Tariff = 0,
Remark = String.Empty,
BidID = bidID,
DestinationID = pdetail.DestinationID,
SourceID = pdetail.SourceID
};
result.Add(n);
}
}
return(Json(result.ToDataSourceResult(request), JsonRequestBehavior.AllowGet));
}
public ActionResult Read_Proposals([DataSourceRequest] DataSourceRequest request, int bidProposalId)
{
var s = _transportBidQuotationHeaderService.FindById(bidProposalId);
int bidID = s.Bid.BidID;
int regionID = s.AdminUnit.AdminUnitID;
int transporterID = s.Transporter.TransporterID;
var bid = _bidService.FindById(bidID) ?? null;
var result = new List <PriceQuotationDetail>();
if (bid != null)
{
var bidPlanDetail =
_transportBidPlanDetailService.FindBy(t => t.Destination.AdminUnit2.AdminUnit2.AdminUnitID == regionID &&
t.BidPlanID == bid.TransportBidPlanID
/*&& t.Quantity > 0*/);
var df = (from planDetail in bidPlanDetail
group planDetail by new
{
planDetail.DestinationID,
planDetail.SourceID
}
into gr
select gr
);
var detailPlans = df.Select(d => d.ToList()).Select(er => er.FirstOrDefault()).ToList();
foreach (var transportBidPlanDetail in detailPlans)
{
var pdetail = transportBidPlanDetail;
var detail = _transportBidQuotationService.FindBy(t => t.BidID == bidID &&
t.SourceID == pdetail.SourceID &&
t.DestinationID == pdetail.DestinationID &&
t.TransporterID == transporterID).FirstOrDefault();
if (detail != null)
{
var t = new PriceQuotationDetail
{
SourceWarehouse = detail.Hub.Name,
Zone = detail.AdminUnit.AdminUnit2.Name,
Woreda = detail.AdminUnit.Name,
Tariff = detail.Tariff,
Remark = detail.Remark,
//
BidID = detail.BidID,
DestinationID = detail.DestinationID,
SourceID = detail.SourceID,
HeaderId = bidProposalId,
TransportBidQuotationID = detail.TransportBidQuotationID * 10 + transporterID,
//
TransporterID = detail.TransporterID
};
result.Add(t);
continue;
}
var n = new PriceQuotationDetail()
{
SourceWarehouse = transportBidPlanDetail.Source.Name,
Zone = transportBidPlanDetail.Destination.AdminUnit2.Name,
Woreda = transportBidPlanDetail.Destination.Name,
Tariff = 0,
Remark = String.Empty,
//
BidID = bidID,
DestinationID = transportBidPlanDetail.DestinationID,
SourceID = transportBidPlanDetail.SourceID,
HeaderId = bidProposalId,
//
TransportBidQuotationID = transportBidPlanDetail.TransportBidPlanDetailID * 10 + transporterID,
TransporterID = transporterID
};
result.Add(n);
}
}
return(Json(result.ToDataSourceResult(request), JsonRequestBehavior.AllowGet));
}