public PayoffExtractReport(int payoffMasterId)
{
InitializeComponent();
using (var dbContext = new WiodySMContext())
{
PayoffIcmalVM vm = new PayoffIcmalVM();
vm.Tarih = DateTime.Now.ToShortDateString();
var payoffMaster = dbContext.PayoffMaster.Find(payoffMasterId);
vm.Yıl = DateTime.Now.Year.ToString();
vm.GrupNo = payoffMaster.Project.PROJECT_GROUP;
vm.PypNo = payoffMaster.Project.PROJECT_PYP_NO;
vm.IsAdi = payoffMaster.Project.PROJECT_NAME;
var mlz = dbContext.PayoffControl.Where(x => x.PAYOFFCONTROL_TYPE_ID == 1 && x.PAYOFFCONTROL_PAYOFFMASTER_ID == payoffMasterId && x.PAYOFFCONTROL_LB == "MLZ").ToList();
vm.Malzeme = mlz == null ? "0 TL" : mlz.Sum(x => x.PAYOFFCONTROL_TOTALTENSIZUP).ToString() + " TL";
var mon = dbContext.PayoffControl.Where(x => x.PAYOFFCONTROL_TYPE_ID == 1 && x.PAYOFFCONTROL_PAYOFFMASTER_ID == payoffMasterId && x.PAYOFFCONTROL_LB == "MON").ToList();
vm.Montaj = mon == null ? "0 TL" : mon.Sum(x => x.PAYOFFCONTROL_TOTALTENSIZUP).ToString() + " TL";
var deMon = dbContext.PayoffControl.Where(x => x.PAYOFFCONTROL_TYPE_ID == 1 && x.PAYOFFCONTROL_PAYOFFMASTER_ID == payoffMasterId && x.PAYOFFCONTROL_LB == "DM").ToList();
vm.DeMontaj = deMon == null ? "0 TL" : deMon.Sum(x => x.PAYOFFCONTROL_TOTALTENSIZUP).ToString() + " TL";
var dmm = dbContext.PayoffControl.Where(x => x.PAYOFFCONTROL_TYPE_ID == 1 && x.PAYOFFCONTROL_PAYOFFMASTER_ID == payoffMasterId && x.PAYOFFCONTROL_LB == "DMM").ToList();
vm.DMM = dmm == null ? "0 TL" : dmm.Sum(x => x.PAYOFFCONTROL_TOTALTENSIZUP).ToString() + " TL";
var ins = dbContext.PayoffControl.Where(x => x.PAYOFFCONTROL_TYPE_ID == 1 && x.PAYOFFCONTROL_PAYOFFMASTER_ID == payoffMasterId && x.PAYOFFCONTROL_LB == "İNS").ToList();
vm.Insaat = ins == null ? "0 TL" : ins.Sum(x => x.PAYOFFCONTROL_TOTALTENSIZUP).ToString() + " TL";
vm.Total = dbContext.PayoffControl.Where(x => x.PAYOFFCONTROL_TYPE_ID == 1 && x.PAYOFFCONTROL_PAYOFFMASTER_ID == payoffMasterId).Sum(x => x.PAYOFFCONTROL_TOTALTENSIZUP).ToString() + " TL";
objectDataSource1.DataSource = vm;
}
}
public PayoffCover(int payoffMasterId)
{
InitializeComponent();
using (var dbContext = new WiodySMContext())
{
PayoffIcmalVM vm = new PayoffIcmalVM();
vm.Tarih = DateTime.Now.ToShortDateString();
var payoffMaster = dbContext.PayoffMaster.Find(payoffMasterId);
var payoffList = dbContext.PayoffMaster.Where(x => x.PAYOFFMASTER_PROJECT_ID == payoffMaster.PAYOFFMASTER_PROJECT_ID).OrderBy(x => x.ID).ToList();
int index = payoffList.FindIndex(a => a.ID == payoffMasterId);
index = index + 1;
vm.HakNo = index + " Nolu Hakediş";
vm.Yıl = DateTime.Now.Year.ToString();
vm.GrupNo = payoffMaster.Project.PROJECT_GROUP;
vm.PypNo = payoffMaster.Project.PROJECT_PYP_NO;
vm.IsAdi = payoffMaster.Project.PROJECT_NAME;
vm.FirmaAdi = payoffMaster.Project.Company.COMPANY_COMPANY_NAME;
vm.Tenzilat = payoffMaster.Project.Contract.MasterContract.CONTRACT_PRICECUTRATE.ToString() + "%";
//vm.Toplam = dbContext.PayoffControl.Where(x => x.PAYOFFCONTROL_TYPE_ID == 1 && x.PAYOFFCONTROL_PAYOFFMASTER_ID == payoffMasterId).Sum(x => x.PAYOFFCONTROL_TOTALTENSIZUP);
objectDataSource1.DataSource = vm;
}
}
