public pyf0002(int payoffMasterId)
{
InitializeComponent();
_payoffMasterId = payoffMasterId;
payoffMaster = dbContext.PayoffMaster.Find(_payoffMasterId);
payoffDefaultBindingSource.DataSource = dbContext.PayoffDefault.Where(x => x.PAYOFFDEFAULT_PAYOFFMASTER_ID == _payoffMasterId).ToList();
payoffControlVMBindingSource.DataSource = dbContext.PayoffControl.Where(x => x.PAYOFFCONTROL_PAYOFFMASTER_ID == _payoffMasterId && x.PAYOFFCONTROL_TYPE_ID == 0).OrderBy(x => x.PAYOFFCONTROL_LB).ToList();
payoffBindingSource.DataSource = dbContext.PayoffControl.Where(x => x.PAYOFFCONTROL_PAYOFFMASTER_ID == _payoffMasterId && x.PAYOFFCONTROL_TYPE_ID == 1).OrderBy(x => x.PAYOFFCONTROL_LB).ToList();
PayoffCover rp = new PayoffCover(_payoffMasterId);
rp.CreateDocument();
payoffReportCover.DocumentSource = rp;
PayoffExtractReport rp1 = new PayoffExtractReport(_payoffMasterId);
rp1.CreateDocument();
payoffReportIcmal.DocumentSource = rp1;
PayoffReportTotalEnd rp2 = new PayoffReportTotalEnd(_payoffMasterId);
rp2.CreateDocument();
payoffReportPrintPreview.DocumentSource = rp2;
TestReportDeduc rp3 = new TestReportDeduc(_payoffMasterId);
rp3.CreateDocument();
payoffReportDeduc.DocumentSource = rp3;
}
private void btnSave_Click(object sender, EventArgs e)
{
if (validationResult() == true)
{
var selectedProject = dbContext.Project.Find(lueProject.EditValue);
var payoffMaster = new PayoffMaster
{
PAYOFFMASTER_PROJECT_ID = selectedProject.ID,
PAYOFFMASTER_PARAMETERCODE = Math.Round(((100 - selectedProject.Contract.CONTRACT_PRICECUTRATE) / 100), 3)
};
dbContext.PayoffMaster.Add(payoffMaster);
lueProject.EditValue = null;
dbContext.SaveChanges();
var excelDatas = ExcelHelper.ReadExcel(txtFilePath.Text);
foreach (var row in excelDatas)
{
if (row.PAYOFFDEFAULT_DEF1 != "")
{
var payoffdef = new PayoffDefault();
payoffdef.PAYOFFDEFAULT_DEF1 = row.PAYOFFDEFAULT_DEF1;
payoffdef.PAYOFFDEFAULT_DEF2 = row.PAYOFFDEFAULT_DEF3;
payoffdef.PAYOFFDEFAULT_DEF3 = row.PAYOFFDEFAULT_DEF4;
payoffdef.PAYOFFDEFAULT_DEF4 = row.PAYOFFDEFAULT_DEF5;
payoffdef.PAYOFFDEFAULT_DEF5 = row.PAYOFFDEFAULT_DEF6;
payoffdef.PAYOFFDEFAULT_DEF6 = row.PAYOFFDEFAULT_DEF7;
payoffdef.PAYOFFDEFAULT_DEF7 = row.PAYOFFDEFAULT_DEF8;
payoffdef.PAYOFFDEFAULT_DEF8 = row.PAYOFFDEFAULT_DEF8;
payoffdef.PAYOFFDEFAULT_DEF9 = row.PAYOFFDEFAULT_DEF8;
payoffdef.PAYOFFDEFAULT_DEF10 = row.PAYOFFDEFAULT_DEF8;
payoffdef.PAYOFFDEFAULT_DEF11 = row.PAYOFFDEFAULT_DEF8;
payoffdef.PAYOFFDEFAULT_DEF12 = row.PAYOFFDEFAULT_DEF13;
payoffdef.PAYOFFDEFAULT_DEF13 = row.PAYOFFDEFAULT_DEF8;
payoffdef.PAYOFFDEFAULT_DEF14 = row.PAYOFFDEFAULT_DEF8;
payoffdef.PAYOFFDEFAULT_DEF15 = row.PAYOFFDEFAULT_DEF8;
payoffdef.PAYOFFDEFAULT_DEF16 = row.PAYOFFDEFAULT_DEF8;
payoffdef.PAYOFFDEFAULT_DEF17 = row.PAYOFFDEFAULT_DEF8;
payoffdef.PAYOFFDEFAULT_DEF18 = row.PAYOFFDEFAULT_DEF8;
payoffdef.PAYOFFDEFAULT_DEF19 = row.PAYOFFDEFAULT_DEF8;
payoffdef.PAYOFFDEFAULT_DEF20 = row.PAYOFFDEFAULT_DEF8;
payoffdef.PAYOFFDEFAULT_PAYOFFMASTER_ID = payoffMaster.ID;
dbContext.PayoffDefault.Add(payoffdef);
}
}
dbContext.SaveChanges();
foreach (var item in dbContext.PayoffDefault.Where(x => x.PAYOFFDEFAULT_PAYOFFMASTER_ID == payoffMaster.ID).ToList())
{
PayoffControl payoffControlVM = new PayoffControl();
payoffControlVM.PAYOFFCONTROL_LB = item.PAYOFFDEFAULT_DEF2;
payoffControlVM.PAYOFFCONTROL_ITEMNAME = item.PAYOFFDEFAULT_DEF5;
payoffControlVM.PAYOFFCONTROL_UNIT = item.PAYOFFDEFAULT_DEF6;
payoffControlVM.PAYOFFCONTROL_SAP = item.PAYOFFDEFAULT_DEF4;
payoffControlVM.PAYOFFCONTROL_TENSIZUP = Math.Round((Convert.ToDouble(item.PAYOFFDEFAULT_DEF8) / payoffMaster.PAYOFFMASTER_PARAMETERCODE), 2);
payoffControlVM.PAYOFFCONTROL_TENUP = Convert.ToDouble(item.PAYOFFDEFAULT_DEF8);
payoffControlVM.PAYOFFCONTROL_QUANTITY = Convert.ToDouble(item.PAYOFFDEFAULT_DEF12);
payoffControlVM.PAYOFFCONTROL_TOTALTENUP = payoffControlVM.PAYOFFCONTROL_QUANTITY * payoffControlVM.PAYOFFCONTROL_TENUP;
payoffControlVM.PAYOFFCONTROL_TOTALTENSIZUP = payoffControlVM.PAYOFFCONTROL_QUANTITY * payoffControlVM.PAYOFFCONTROL_TENSIZUP;
payoffControlVM.PAYOFFCONTROL_PAYOFFMASTER_ID = payoffMaster.ID;
payoffControlVM.PAYOFFCONTROL_TYPE_ID = 0;
dbContext.PayoffControl.Add(payoffControlVM);
}
dbContext.SaveChanges();
foreach (var item in dbContext.PayoffDefault.Where(x => x.PAYOFFDEFAULT_PAYOFFMASTER_ID == payoffMaster.ID && (x.PAYOFFDEFAULT_DEF2 == "MON" || x.PAYOFFDEFAULT_DEF2 == "DM")).ToList())
{
PayoffControl payoffControlVM = new PayoffControl();
payoffControlVM.PAYOFFCONTROL_LB = item.PAYOFFDEFAULT_DEF2;
payoffControlVM.PAYOFFCONTROL_ITEMNAME = item.PAYOFFDEFAULT_DEF5;
payoffControlVM.PAYOFFCONTROL_UNIT = item.PAYOFFDEFAULT_DEF6;
payoffControlVM.PAYOFFCONTROL_SAP = item.PAYOFFDEFAULT_DEF4;
payoffControlVM.PAYOFFCONTROL_TENSIZUP = Math.Round((Convert.ToDouble(item.PAYOFFDEFAULT_DEF8) / payoffMaster.PAYOFFMASTER_PARAMETERCODE), 2);
payoffControlVM.PAYOFFCONTROL_TENUP = Convert.ToDouble(item.PAYOFFDEFAULT_DEF8);
payoffControlVM.PAYOFFCONTROL_QUANTITY = Convert.ToDouble(item.PAYOFFDEFAULT_DEF12);
payoffControlVM.PAYOFFCONTROL_TOTALTENUP = payoffControlVM.PAYOFFCONTROL_QUANTITY * payoffControlVM.PAYOFFCONTROL_TENUP;
payoffControlVM.PAYOFFCONTROL_TOTALTENSIZUP = payoffControlVM.PAYOFFCONTROL_QUANTITY * payoffControlVM.PAYOFFCONTROL_TENSIZUP;
payoffControlVM.PAYOFFCONTROL_PAYOFFMASTER_ID = payoffMaster.ID;
payoffControlVM.PAYOFFCONTROL_TYPE_ID = 1;
dbContext.PayoffControl.Add(payoffControlVM);
}
dbContext.SaveChanges();
LoadData();
}
}
