private void btnImport_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Do you want save change?", "Cortek", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
IWorkbook workbook = spreadSheet.Document;
try
{
using (FileStream stream = new FileStream(txtPath.Text, FileMode.Create, FileAccess.ReadWrite))
{
if (extension == ".xls")
{
workbook.SaveDocument(stream, DocumentFormat.Xls);
}
else
{
workbook.SaveDocument(stream, DocumentFormat.Xlsx);
}
}
Bus_INSPECTION_HISTORY_Excel excelBus = new Bus_INSPECTION_HISTORY_Excel();
RW_INSPECTION_HISTORY_BUS busHistory = new RW_INSPECTION_HISTORY_BUS();
List <RW_INSPECTION_HISTORY> list = excelBus.getListInsp(txtPath.Text);
for (int i = 0; i < list.Count; i++)
{
busHistory.add(list[i]);
}
this.Close();
}
catch
{
MessageBox.Show("This file is opened in another program!", "Cortek RBI", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
}
}
private List <RW_INSPECTION_DETAIL> getDataInspectionHistory()
{
RW_INSPECTION_HISTORY_BUS busInspHis = new RW_INSPECTION_HISTORY_BUS();
List <RW_INSPECTION_DETAIL> listInspHis = busInspHis.getDataSource();
List <RW_INSPECTION_DETAIL> listData = new List <RW_INSPECTION_DETAIL>();
EQUIPMENT_MASTER_BUS busEqMaster = new EQUIPMENT_MASTER_BUS();
SITES_BUS busSite = new SITES_BUS();
FACILITY_BUS busFacility = new FACILITY_BUS();
foreach (RW_INSPECTION_DETAIL inspHis in listInspHis)
{
int eqID = inspHis.EquipmentID;
RW_INSPECTION_DETAIL rwInspHis = inspHis;
rwInspHis.SiteName = busSite.getSiteName(busEqMaster.getSiteID(eqID));
rwInspHis.FacilityName = busFacility.getFacilityName(busEqMaster.getFacilityID(eqID));
listData.Add(rwInspHis);
}
return(listData);
}
private List <RW_INSPECTION_HISTORY> getData()
{
RW_INSPECTION_HISTORY_BUS busInspHis = new RW_INSPECTION_HISTORY_BUS();
List <RW_INSPECTION_HISTORY> listInspHis = busInspHis.getDataSource();
List <RW_INSPECTION_HISTORY> listData = new List <RW_INSPECTION_HISTORY>();
EQUIPMENT_MASTER_BUS busEqMaster = new EQUIPMENT_MASTER_BUS();
SITES_BUS busSite = new SITES_BUS();
FACILITY_BUS busFacility = new FACILITY_BUS();
foreach (RW_INSPECTION_HISTORY inspHis in listInspHis)
{
String eqNumber = inspHis.EquipmentNumber;
int eqID = busEqMaster.getIDbyNumber(inspHis.EquipmentNumber);
RW_INSPECTION_HISTORY rwInspHis = inspHis;
rwInspHis.SiteName = busSite.getSiteName(busEqMaster.getSiteID(eqID));
rwInspHis.FacilityName = busFacility.getFacilityName(busEqMaster.getFacilityID(eqID));
listData.Add(rwInspHis);
}
return(listData);
}
private void btnAddInspectionPlan_Click(object sender, EventArgs e)
{
RW_INSPECTION_HISTORY_BUS rwInsHisBus = new RW_INSPECTION_HISTORY_BUS();
RW_ASSESSMENT_BUS rwAssBus = new RW_ASSESSMENT_BUS();
int n = rwInsHisBus.getDataComp(rwAssBus.getComponentID(IDAss)).Count;
if (n > 0)
{
dtgvInsHis.Rows.Add("-", DateTime.Now.ToShortDateString(), "Corrosion Under Insulation", "", "", "E", 0, DateTime.Now.ToShortDateString());
}
else
{
if (dtgvInsHis.RowCount > 0)
{
dtgvInsHis.Rows.Add("-", DateTime.Now.ToShortDateString(), "Corrosion Under Insulation", "", "", "E", 0, DateTime.Now.ToShortDateString());
}
else
{
MessageBox.Show("This proposal does not have mitigation plan, please add mitigation planning.", "Inspection / Mitigation", MessageBoxButtons.OK, MessageBoxIcon.Hand);
return;
}
}
}
private void UCInspectionHistorySubform_Load(object sender, EventArgs e)
{
DataGridViewTextBoxColumn dtvcInsPlan = new DataGridViewTextBoxColumn();
dtvcInsPlan.HeaderText = "Inspection Plan";
DataGridViewTextBoxColumn dtvcInsDate = new DataGridViewTextBoxColumn();
dtvcInsDate.HeaderText = "Inspection Date";
DataGridViewComboBoxColumn dtvcDamaMechan = new DataGridViewComboBoxColumn();
dtvcDamaMechan.HeaderText = "Damage Mechanism";
//add items cho dtvcDamaMechan
DM_ITEMS_BUS dmItemsBus = new DM_ITEMS_BUS();
List <string> listDMItems = dmItemsBus.getDMDescription();
foreach (String dm in listDMItems)
{
dtvcDamaMechan.Items.Add(dm);
}
dtvcDamaMechan.MaxDropDownItems = 4;
DataGridViewTextBoxColumn dtvcInsSum = new DataGridViewTextBoxColumn();
dtvcInsSum.HeaderText = "Inspection Summary";
DataGridViewButtonColumn dtvcSumDetail = new DataGridViewButtonColumn();
dtvcSumDetail.HeaderText = "Summary Detail";
dtvcSumDetail.Name = "dtvcSumDetail";
DataGridViewComboBoxColumn dtvcEffective = new DataGridViewComboBoxColumn();
dtvcEffective.Items.Add("A");
dtvcEffective.Items.Add("B");
dtvcEffective.Items.Add("C");
dtvcEffective.Items.Add("D");
dtvcEffective.Items.Add("E");
dtvcEffective.HeaderText = "Effectiveness";
DataGridViewCheckBoxColumn dtvcCarriedOut = new DataGridViewCheckBoxColumn();
dtvcCarriedOut.HeaderText = "Carried Out";
DataGridViewTextBoxColumn dtvcICarriedOutDate = new DataGridViewTextBoxColumn();
dtvcICarriedOutDate.HeaderText = "Carried Out Date";
DataGridViewButtonColumn dtvcDelete = new DataGridViewButtonColumn();
dtvcDelete.HeaderText = "";
dtvcDelete.Name = "dtvcDelete";
dtgvInsHis.Columns.Add(dtvcInsPlan);
dtvcInsPlan.Width = 100;
dtgvInsHis.Columns.Add(dtvcInsDate);
dtvcInsDate.Width = 80;
dtgvInsHis.Columns.Add(dtvcDamaMechan);
dtvcDamaMechan.Width = 150;
dtgvInsHis.Columns.Add(dtvcInsSum);
dtvcInsSum.Width = 200;
dtgvInsHis.Columns.Add(dtvcSumDetail);
dtvcSumDetail.Width = 50;
dtgvInsHis.Columns.Add(dtvcEffective);
dtvcEffective.Width = 70;
dtgvInsHis.Columns.Add(dtvcCarriedOut);
dtvcCarriedOut.Width = 60;
dtgvInsHis.Columns.Add(dtvcICarriedOutDate);
dtvcICarriedOutDate.Width = 80;
dtgvInsHis.Columns.Add(dtvcDelete);
dtvcDelete.Width = 50;
RW_INSPECTION_HISTORY_BUS rwInspHisBus = new RW_INSPECTION_HISTORY_BUS();
List <RW_INSPECTION_DETAIL> lstRwInsDe = rwInspHisBus.getDataSourcebyDetailID(IDAss);
foreach (RW_INSPECTION_DETAIL de in lstRwInsDe)
{
dtgvInsHis.Rows.Add(de.InspPlanName, de.InspectionDate.ToShortDateString(), dmItemsBus.getDMDescriptionbyDMItemID(de.DMItemID), de.InspectionSummary, "...", de.EffectivenessCode, de.IsCarriedOut, de.CarriedOutDate, "Delete");
}
dtgvInsHis.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.None;
dtgvInsHis.AllowUserToAddRows = false;
}
