// ///////////////////////////////////////////////////////////////////////////////////////////////////// // // STEP2 - SUMMARY // // //////////////////////////////////////////////////////////////////////// // STEP2 - SUMMARY - METHODS // private void StepSummaryIn() { // Set instruction Label instruction = (Label)this.Master.FindControl("lblInstruction"); instruction.Text = "Summary"; // Initialize summary WincanBulkUploadTDS dataSet = new WincanBulkUploadTDS(); dataSet.WincanBulkUpload.Merge(wincanBulkUpload, true); WincanBulkUpload model = new WincanBulkUpload(dataSet); tbxSummary.Text = model.GetSectionsSummary(hdfProjectLocation.Value.ToString()); }
private void Save() { // process sections WincanBulkUploadTDS dataSet = new WincanBulkUploadTDS(); dataSet.WincanBulkUpload.Merge(wincanBulkUpload, true); WincanBulkUpload model = new WincanBulkUpload(dataSet); // get parameters Int64 countryId = int.Parse(hdfCountryId.Value); Int64? provinceId = null; if (hdfProvinceId.Value != "") provinceId = Int64.Parse(hdfProvinceId.Value); Int64? countyId = null; if (hdfCountyId.Value != "") countyId = Int64.Parse(hdfCountyId.Value); Int64? cityId = null; if (hdfCityId.Value != "") cityId = Int64.Parse(hdfCityId.Value); int loginId = Convert.ToInt32(Session["loginID"]); // save to database DB.Open(); DB.BeginTransaction(); try { model.Save(int.Parse(hdfProjectId.Value), countryId, provinceId, countyId, cityId, int.Parse(hdfCompanyId.Value), loginId); DB.CommitTransaction(); } catch (Exception ex) { DB.RollbackTransaction(); string url = string.Format("./../../error_page.aspx?error={0}", ex.Message.Replace('\n', ' ')); Response.Redirect(url); } }
// ///////////////////////////////////////////////////////////////////////////////////////////////////// // // STEP1 - BEGIN // // //////////////////////////////////////////////////////////////////////// // STEP1 - BEGIN - METHODS // private void StepBeginIn() { // Set instruction Label instruction = (Label)this.Master.FindControl("lblInstruction"); instruction.Text = "Please select a Microsoft Access file"; //--- Initialize WincanBulkUploadTDS dataSet = new WincanBulkUploadTDS(); dataSet.WincanBulkUpload.Merge(wincanBulkUpload, true); WincanBulkUpload model = new WincanBulkUpload(dataSet); model.Table.Rows.Clear(); wincanBulkUpload = dataSet.WincanBulkUpload; Session["wincanBulkUpload"] = dataSet.WincanBulkUpload; }
private bool ProcessBulkUpload(string fName, out string wincanBulkUploadResultMessage) { bool wincanBulkUploadProccessed = true; wincanBulkUploadResultMessage = ""; AssetSewerSectionGateway assetSewerSectionGateway = new AssetSewerSectionGateway(); AppSettingsReader appSettingReader = new AppSettingsReader(); //string excelConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties='Excel 8.0;HDR=YES;IMEX=1';Data Source=" + fName + ";"; string accessConnectionString = "Provider=Microsoft.JET.OLEDB.4.0;Data Source=" + fName + ";"; //OleDbConnection connection = new OleDbConnection(excelConnectionString); OleDbConnection connection = new OleDbConnection(accessConnectionString); string sql = "SELECT SI_T.SI_InspName AS SectionID, SO_T.SO_OpCode AS State, SI_T.SI_InspectionDir AS Direction, SI_T.SI_InspectedLengthFeet AS Distance, SO_T.SO_PositionFeet AS VideoDistance, SO_T.SO_ClockPosition1 AS ClockPosition "+ " , SO_T.SO_Dim1 AS DistanceToCentre, SO_T.SO_ToGoFeet AS ReverseSetup, SO_T.SO_Remark AS Comments" + " FROM SI_T INNER JOIN SO_T ON SI_T.SI_ID = SO_T.SO_Inspecs_ID;"; OleDbCommand command = null; OleDbDataReader dataReader = null; try { ArrayList validatedIds = new ArrayList(); connection.Open(); command = new OleDbCommand(sql, connection); dataReader = command.ExecuteReader(); int id = 0; while (dataReader.Read()) { if (!IsEmptyRow(dataReader)) { string sectionId = ""; string state = ""; string distance = ""; string direction = ""; string videoDistance = ""; string clockPosition = ""; string distanceToCentre = ""; string reverseSetup = ""; string comments = ""; string dataCell = null; string dataCellToUpper = null; //--- ... fill section row for (int i = 0; i < dataReader.FieldCount; i++) { dataCell = dataReader.GetValue(i).ToString().Trim(); dataCellToUpper = dataReader.GetValue(i).ToString().Trim().ToUpper(); switch (dataReader.GetName(i).Trim()) { case "SectionID": if (dataCellToUpper != "NULL") { sectionId = dataCell; } else { sectionId = ""; wincanBulkUploadProccessed = false; } break; case "State": if (dataCellToUpper != "NULL" && dataCellToUpper != "") { state = dataCell; } else { state = "Undefined"; } break; case "Direction": if (dataCellToUpper != "NULL" && dataCellToUpper != "") { direction = dataCell; } else { direction = "U"; } break; case "Distance": if (dataCellToUpper != "NULL" && dataCellToUpper != "") { if (Distance.IsValidDistance(dataCell)) { distance = dataCell; } else { wincanBulkUploadResultMessage = "Invalid value in 'Distance' column (" + id + "). Wincan Bulk Upload ABORTED."; wincanBulkUploadProccessed = false; } } else { distance = ""; } break; case "VideoDistance": if (dataCellToUpper != "NULL" && dataCellToUpper != "") { if (Distance.IsValidDistance(dataCell)) { videoDistance = dataCell; } else { wincanBulkUploadResultMessage = "Invalid value in 'VideoDistance' column (" + id + "). Wincan Bulk Upload ABORTED."; wincanBulkUploadProccessed = false; } } else { videoDistance = ""; } break; case "ClockPosition": if (dataCellToUpper != "NULL" && dataCellToUpper != "") { clockPosition = dataCell; } else { clockPosition = ""; } break; case "DistanceToCentre": if (dataCellToUpper != "NULL" && dataCellToUpper != "") { if (Distance.IsValidDistance(dataCell)) { distanceToCentre = dataCell; } else { wincanBulkUploadResultMessage = "Invalid value in 'DistanceToCentre' column (" + id + "). Wincan Bulk Upload ABORTED."; wincanBulkUploadProccessed = false; } } else { distanceToCentre = ""; } break; case "ReverseSetup": if (dataCellToUpper != "NULL" && dataCellToUpper != "") { if (Distance.IsValidDistance(dataCell)) { reverseSetup = dataCell; } else { wincanBulkUploadResultMessage = "Invalid value in 'ReverseSetup' column (" + id + "). Wincan Bulk Upload ABORTED."; wincanBulkUploadProccessed = false; } } else { reverseSetup = ""; } break; case "Comments": if (dataCellToUpper != "NULL" && dataCellToUpper != "") { comments = dataCell; } else { comments = ""; } break; default: wincanBulkUploadResultMessage = "Invalid column name '" + dataReader.GetName(i) + "' in section data range."; wincanBulkUploadProccessed = false; break; } if (!wincanBulkUploadProccessed) { break; } } if (wincanBulkUploadProccessed) { //--- Initialize WincanBulkUploadTDS dataSet = new WincanBulkUploadTDS(); dataSet.WincanBulkUpload.Merge(wincanBulkUpload, true); WincanBulkUpload model = new WincanBulkUpload(dataSet); id = id + 1; model.Insert(id.ToString(), sectionId, state, direction, distance, videoDistance, clockPosition, distanceToCentre, reverseSetup, comments); wincanBulkUpload = dataSet.WincanBulkUpload; Session["wincanBulkUpload"] = dataSet.WincanBulkUpload; } } } dataReader.Close(); connection.Close(); } catch (Exception ex) { if (!dataReader.IsClosed) { dataReader.Close(); } if (connection.State == ConnectionState.Open) { connection.Close(); } throw ex; } return (wincanBulkUploadProccessed) ? true : false; }