/// <summary> /// Deprecated Method for adding a new object to the ImportFiles EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddToImportFiles(ImportFile importFile) { base.AddObject("ImportFiles", importFile); }
protected void Button1_Click(object sender, EventArgs e) { try { if (FileUpload1.HasFile) { string fileName = new Random().Next() + FileUpload1.FileName; string filePath = Server.MapPath("ImportFiles/") + fileName; FileUpload1.SaveAs(filePath); ImportFile file = new ImportFile() { Name = Path.GetFileNameWithoutExtension(FileUpload1.FileName), URL = fileName, UploadedAt = DateTime.Now, UploadedBy = Convert.ToInt32(Session["UserID"]), UploadedByUser = Session["UserName"] + "", }; new ImportFileRepository().Add(file); var connectionString = string.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties=Excel 12.0;", filePath); var adapter = new OleDbDataAdapter("SELECT * FROM [OWR Info$]", connectionString); var ds = new DataSet(); adapter.Fill(ds, "OWR Info"); var data = ds.Tables["OWR Info"].AsEnumerable(); var OwrInfoRecords = data.Select(x => new OWRInfo { ImportFileID = file.ID, RequestID = x.Field<string>("REQUEST_ID"), SBC_VIN = x.Field<object>("SBC_VIN") + "", TrackingSheet = x.Field<string>("Tracking Sheet"), UPSTrackingNumber = x.Field<string>("UPS Tracking Number"), IWM_GPS_UNIT = x.Field<string>("IWM/GPS UNIT"), SUPER_ARC_CODE = x.Field<string>("SUPER_ARC_CODE"), VENDOR_CLOSE_DATE = x.Field<string>("VENDOR_CLOSE_DATE"), REQUEST_TYPE = x.Field<string>("REQUEST_TYPE"), COMPANY = x.Field<string>("COMPANY"), GPS_CENTER = x.Field<string>("GPS_CENTER"), CASE_NUMBER = x.Field<string>("CASE_NUMBER"), REPORTED_PROBLEM_CODE = x.Field<string>("REPORTED_PROBLEM_CODE"), PROBLEM_DESCRIPTION = x.Field<string>("PROBLEM_DESCRIPTION"), PROBLEM_TEXT = x.Field<string>("PROBLEM_TEXT"), SPECIAL_ACCESS = x.Field<string>("SPECIAL_ACCESS"), SPECIAL_HANDLING = x.Field<string>("SPECIAL_HANDLING"), CENTER_COMMENTS = x.Field<string>("CENTER_COMMENTS"), ORIGINATION_DATE = x.Field<string>("ORIGINATION_DATE"), SUBMISSION_DATE = x.Field<string>("SUBMISSION_DATE"), SBC_CLOSE_DATE = x.Field<string>("SBC_CLOSE_DATE"), WorkingDays = x.Field<double?>("WORKING DAYS") == null ? 0 : (int)x.Field<double>("WORKING DAYS"), TotalDuration = x.Field<double?>("TOTAL DURATION") == null ? 0 : (int)x.Field<double>("TOTAL DURATION"), MAKE = x.Field<string>("MAKE"), MODEL = x.Field<string>("MODEL"), LICENSE = x.Field<string>("LICENSE"), DATA_MIN = x.Field<string>("DATA_MIN"), GARAGE_ADDRESS = x.Field<string>("GARAGE_ADDRESS"), GARAGE_CITY = x.Field<string>("GARAGE_CITY"), GARAGE_STATE = x.Field<string>("GARAGE_STATE"), SUPER_LAST_NAME = x.Field<string>("SUPER_LAST_NAME"), SUPER_TELEPHONE_NUM = x.Field<string>("SUPER_TELEPHONE_NUM"), SUPER_PAGER_NUM = x.Field<string>("SUPER_PAGER_NUM"), SUPER_PAGER_PIN = x.Field<string>("SUPER_PAGER_PIN"), E_MAIL = x.Field<string>("E_MAIL"), CENTER_LAST_NAME = x.Field<string>("CENTER_LAST_NAME"), CENTER_TELEPHONE_NUM = x.Field<string>("CENTER_TELEPHONE_NUM"), CREW_NAME = x.Field<string>("CREW_NAME"), SCREEN_UUID = x.Field<string>("SCREEN_UUID"), CLOSE_UUID = x.Field<string>("CLOSE_UUID"), GATE_CODE = x.Field<string>("GATE_CODE"), ENTITY_DESCRIPTION = x.Field<string>("ENTITY_DESCRIPTION"), SUPER_CELLULAR_NUM = x.Field<string>("SUPER_CELLULAR_NUM"), ORIGINATOR_UUID = x.Field<string>("ORIGINATOR_UUID"), SUPER_UUID = x.Field<string>("SUPER_UUID"), GARAGE_ZIP = x.Field<string>("GARAGE_ZIP"), SUPER_FIRST_NAME = x.Field<string>("SUPER_FIRST_NAME"), LAST_MODIFIED_UUID = x.Field<string>("LAST_MODIFIED_UUID"), NO_SHOW_FLAG = x.Field<string>("NO_SHOW_FLAG"), MODIFICATION_TYPE = x.Field<string>("MODIFICATION_TYPE"), }).ToList(); new OWRInfoRepository().Add(OwrInfoRecords); ShowMessage(true, Resources.Messages.ImportRecords_FileUploaded); } else ShowMessage(false, Resources.Messages.ImportRecords_SelectFile); } catch (Exception ex) { ShowMessage(false, ex.Message); } }
/// <summary> /// Create a new ImportFile object. /// </summary> /// <param name="id">Initial value of the ID property.</param> /// <param name="uploadedBy">Initial value of the UploadedBy property.</param> /// <param name="uploadedAt">Initial value of the UploadedAt property.</param> /// <param name="recordStatus">Initial value of the RecordStatus property.</param> public static ImportFile CreateImportFile(global::System.Int32 id, global::System.Int32 uploadedBy, global::System.DateTime uploadedAt, global::System.Byte recordStatus) { ImportFile importFile = new ImportFile(); importFile.ID = id; importFile.UploadedBy = uploadedBy; importFile.UploadedAt = uploadedAt; importFile.RecordStatus = recordStatus; return importFile; }