protected void btnImport_Click(object sender, EventArgs e) { string sErr = ""; ImportExport.ImportExportClass ie = new ImportExport.ImportExportClass(); string sPath = Server.MapPath("~/temp/"); //get the file from the browser if ((fupFile.PostedFile != null) && (fupFile.PostedFile.ContentLength > 0)) { string sFileName = System.IO.Path.GetFileName(fupFile.PostedFile.FileName); string sFullPath = sPath + sFileName; try { fupFile.PostedFile.SaveAs(sFullPath); ////Response.Write("The file has been uploaded."); ////confirm the zip file exists in our temp directory if (File.Exists(sFullPath)) { if (!ie.doFileLoad(sPath, sFullPath, sFileName, ui.GetSessionUserID(), ref sErr)) { ui.RaiseError(Page, sErr, true, ""); } else { //all good Response.Redirect("importReconcile.aspx", false); } } } catch (Exception ex) { ui.RaiseError(Page, ex.Message, true, ""); } } else { ui.RaiseError(Page, "Please select a file to upload.", true, ""); } }
protected void btnImport_Click(object sender, EventArgs e) { string sErr = ""; ImportExport.ImportExportClass ie = new ImportExport.ImportExportClass(); string sPath = Server.MapPath("~/temp/"); //get the file from the browser if ((fupFile.PostedFile != null) && (fupFile.PostedFile.ContentLength > 0)) { string sFileName = System.IO.Path.GetFileName(fupFile.PostedFile.FileName); string sFullPath = sPath + sFileName; try { fupFile.PostedFile.SaveAs(sFullPath); ////Response.Write("The file has been uploaded."); ////confirm the zip file exists in our temp directory if (File.Exists(sFullPath)) if (!ie.doFileLoad(sPath, sFullPath, sFileName, ui.GetSessionUserID(), ref sErr)) { ui.RaiseError(Page, sErr, true, ""); } else { //all good Response.Redirect("importReconcile.aspx", false); } } catch (Exception ex) { ui.RaiseError(Page, ex.Message, true, ""); } } else { ui.RaiseError(Page, "Please select a file to upload.", true, ""); } }
public string wmExportTasks(string sTaskArray) { acUI.acUI ui = new acUI.acUI(); ImportExport.ImportExportClass ie = new ImportExport.ImportExportClass(); string sErr = ""; //pretty much just call the ImportExport function try { //what are we gonna call the final file? string sUserID = ui.GetSessionUserID(); string sFileName = sUserID + "_backup"; string sPath = Server.MapPath("~/temp/"); if (sTaskArray.Length < 36) return ""; sTaskArray = ui.QuoteUp(sTaskArray); if (!ie.doBatchTaskExport(sPath, sTaskArray, sFileName, ref sErr)) { throw new Exception("Unable to export Tasks." + sErr); } if (sErr == "") return sFileName + ".zip"; else return sErr; } catch (Exception ex) { throw new Exception(ex.Message); } }
public string wmUpdateImportRow(string sObjectType, string sID, string sNewCode, string sNewName, string sVersion, string sImportMode) { //note not all arguments are used for all types, but are required for all dataAccess dc = new dataAccess(); acUI.acUI ui = new acUI.acUI(); ImportExport.ImportExportClass ie = new ImportExport.ImportExportClass(); try { string sUserID = ui.GetSessionUserID(); if (sID != "") { string sErr = ""; string sSQL = ""; //just to be safe... sObjectType = sObjectType.ToLower(); switch (sObjectType) { case "task": switch (sImportMode) { case "New": sSQL = "update import_task set" + " task_code = '" + sNewCode.Replace("'", "''") + "'," + " task_name = '" + sNewName.Replace("'", "''") + "'," + " version = 1.000," + " conflict = null," + " import_mode = '" + sImportMode + "'" + " where task_id = '" + sID + "'" + " and user_id = '" + sUserID + "'"; break; case "New Version": sSQL = "update import_task set" + " task_code = src_task_code," + " task_name = src_task_name," + " version = '" + sVersion + "'," + " conflict = null," + " import_mode = '" + sImportMode + "'" + " where task_id = '" + sID + "'" + " and user_id = '" + sUserID + "'"; break; //case "Overwrite": // sSQL = "update import_task set" + // " task_code = src_task_code," + // " task_name = src_task_name," + // " version = src_version," + // " conflict = null," + // " import_mode = '" + sImportMode + "'" + // " where task_id = '" + sID + "'" + // " and user_id = '" + sUserID + "'"; // break; default: break; } break; default: break; } if (sSQL != "") { if (!dc.sqlExecuteUpdate(sSQL, ref sErr)) { throw new Exception("Unable to update.<br />" + sErr); } } else throw new Exception("Update SQL not set.<br />" + sErr); //now, rescan for conflicts. switch (sObjectType) { case "task": if (!ie.IdentifyTaskConflicts(sUserID, sID, ref sErr)) throw new Exception("Unable to scan conflicts.<br />" + sErr); break; default: break; } return ""; } else { throw new Exception("Unable to update row. Missing required data. (Fields cannot be blank.)"); } } catch (Exception ex) { throw ex; } }
public string wmImportSelected(string sTaskList) { acUI.acUI ui = new acUI.acUI(); ImportExport.ImportExportClass ie = new ImportExport.ImportExportClass(); string sErr = ""; try { string sUserID = ui.GetSessionUserID(); if (!ie.Import(sUserID, sTaskList, ref sErr)) throw new Exception("Unable to import Items.<br />" + sErr); } catch (Exception ex) { throw new Exception(ex.Message); } return sErr; }