public SigmaResultType AddImportHistory(TypeImportHistory objImportHistory) { SigmaResultType result = new SigmaResultType(); try { ImportHistoryMgr importHistoryMgr = new ImportHistoryMgr(); result = importHistoryMgr.AddImportHistory(objImportHistory); return result; } catch (Exception ex) { // Log Exception ExceptionHelper.logException(ex); result.IsSuccessful = false; result.ErrorMessage = ex.Message; return result; } }
public SigmaResultType ImportSigmaUserFromExcel(string filePath, string exportfilepath) { TypeUserInfo userinfo = AuthMgr.GetUserInfo(); DataTable dt = new DataTable(); DataTable tmpDt = new DataTable(); SigmaResultType result = new SigmaResultType(); dt = Element.Shared.Common.ImportHelper.ImportWorkSheet(filePath, true); DataTable tmpdt = new DataTable(); tmpdt = dt.Copy(); tmpdt.Rows.Clear(); tmpdt.Columns.Add("Fail reason"); int failCnt = 0; int SuccessCnt = 1; int availableCnt = GetAvailableLicenseCount(); foreach (DataRow r in dt.Rows) { if (SuccessCnt > availableCnt) { tmpdt.Rows.Add(r.ItemArray); tmpdt.Rows[tmpdt.Rows.Count - 1]["Fail reason"] = "Exceeded the number of user licenses"; failCnt++; } else { TypeSigmaUser obj = new TypeSigmaUser(); obj.SigmaUserId = r[0].ToString(); obj.EmployeeId = r[1].ToString(); obj.FirstName = r[2].ToString(); obj.LastName = r[3].ToString(); obj.PhoneNo = r[4].ToString(); obj.Email = r[5].ToString(); obj.Password = RandumPassword(); obj.CompanyName = r[6].ToString(); obj.CreatedBy = userinfo.SigmaUserId; if (string.IsNullOrEmpty(GetFailreasonForRequiredUser(r))) { SigmaResultType rst = AddSigmaUserTemplate(obj); if (rst.ErrorMessage != null) { tmpdt.Rows.Add(r.ItemArray); tmpdt.Rows[tmpdt.Rows.Count - 1]["Fail reason"] = rst.ErrorMessage.ToString(); failCnt++; } else SuccessCnt++; } else { tmpdt.Rows.Add(r.ItemArray); tmpdt.Rows[tmpdt.Rows.Count - 1]["Fail reason"] = GetFailreasonForRequiredUser(r); failCnt++; } } } TypeImportHistory ImportHistory = new TypeImportHistory(); ImportHistory.ImportCategory = "User"; ImportHistory.ImportedFileName = Path.GetFileName(filePath).ToString(); ImportHistory.ImportedDate = DateTime.Now.ToString(); ImportHistory.TotalCount = dt.Rows.Count; ImportHistory.SuccessCount = dt.Rows.Count - failCnt; ImportHistory.FailCount = failCnt; ImportHistory.CreatedBy = userinfo.SigmaUserId; ImportHistoryMgr HistoryMgr = new ImportHistoryMgr(); result = HistoryMgr.AddImportHistory(ImportHistory); //if exists error list if (tmpdt.Rows.Count > 0) { if (!System.IO.Directory.Exists(exportfilepath)) { System.IO.Directory.CreateDirectory(exportfilepath); } //excel file generate for direct call 'export' link Export2Excel.ConvertExcelfromData(tmpdt, result.ScalarValue + Path.GetExtension(filePath), exportfilepath); //csv file generate for import error list view Export2Excel.ConvertCSVFile(tmpdt, result.ScalarValue + ".csv", exportfilepath); } return result; }
/// <summary> /// Set Add ImportHistory Info /// </summary> /// <param name="iTotalCnt"></param> /// <param name="FailCnt"></param> /// <param name="filePath"></param> /// <returns></returns> private SigmaResultType AddImportHistory(int iTotalCnt, int FailCnt, string FileName, string ImportCategory) { SigmaResultType HistoryResult = new SigmaResultType(); TypeImportHistory ImportHistory = new TypeImportHistory(); ImportHistoryMgr HistoryMgr = new ImportHistoryMgr(); //DB Date로 하기 말고. DateTime convertedDate = DateTime.Parse(DateTime.Now.ToString()); DateTime localDate = convertedDate.ToLocalTime(); int Failcnt = FailCnt++; int iSuccessCnt = iTotalCnt - Failcnt; ImportHistory.ImportCategory = ImportCategory; ImportHistory.ImportedFileName = FileName; ImportHistory.ImportedDate = localDate.ToString(); ImportHistory.TotalCount = iTotalCnt; ImportHistory.SuccessCount = iSuccessCnt; ImportHistory.FailCount = Failcnt; ImportHistory.CreatedBy = userinfo.SigmaUserId;//임시 return HistoryResult = HistoryMgr.AddImportHistory(ImportHistory); }
public SigmaResultType ImportProjectCostCodeFromExcel(string filePath, string exportfilepath) { TypeUserInfo userinfo = AuthMgr.GetUserInfo(); DataTable dt = new DataTable(); DataTable tmpDt = new DataTable(); SigmaResultType result = new SigmaResultType(); dt = Element.Shared.Common.ImportHelper.ImportWorkSheet(filePath, true); DataTable tmpdt = new DataTable(); tmpdt = dt.Copy(); tmpdt.Rows.Clear(); tmpdt.Columns.Add("Fail reason"); int failCnt = 0; foreach (DataRow r in dt.Rows) { TypeProjectCostCode obj = new TypeProjectCostCode(); obj.CostCode = r[0].ToString(); obj.UomName = r[2].ToString(); obj.ProjectId = userinfo.CurrentProjectId; obj.CreatedBy = userinfo.SigmaUserId; if (string.IsNullOrEmpty(GetFailreasonForRequiredProjectCostCode(r))) { if (!string.IsNullOrEmpty(r[3].ToString())) obj.EstimatedQty = Convert.ToDecimal(r[3].ToString()); if (!string.IsNullOrEmpty(r[4].ToString())) obj.EstimatedManhour = Convert.ToDecimal(r[4].ToString()); SigmaResultType rst = AddProjectCostCodeByTemplate(obj); if (!rst.IsSuccessful) { tmpdt.Rows.Add(r.ItemArray); tmpdt.Rows[tmpdt.Rows.Count - 1]["Fail reason"] = rst.ErrorMessage.ToString(); failCnt++; } } else { tmpdt.Rows.Add(r.ItemArray); tmpdt.Rows[tmpdt.Rows.Count - 1]["Fail reason"] = GetFailreasonForRequiredProjectCostCode(r); failCnt++; } } TypeImportHistory ImportHistory = new TypeImportHistory(); ImportHistory.ImportCategory = "ProjectCostCode"; ImportHistory.ImportedFileName = Path.GetFileName(filePath).ToString(); ImportHistory.ImportedDate = DateTime.Now.ToString(); ImportHistory.TotalCount = dt.Rows.Count; ImportHistory.SuccessCount = dt.Rows.Count - failCnt; ImportHistory.FailCount = failCnt; ImportHistory.CreatedBy = userinfo.SigmaUserId; ImportHistoryMgr HistoryMgr = new ImportHistoryMgr(); result = HistoryMgr.AddImportHistory(ImportHistory); //if exists error list if (tmpdt.Rows.Count > 0) { if (!System.IO.Directory.Exists(exportfilepath)) { System.IO.Directory.CreateDirectory(exportfilepath); } //excel file generate for direct call 'export' link Export2Excel.ConvertExcelfromData(tmpdt, result.ScalarValue + Path.GetExtension(filePath), exportfilepath); //csv file generate for import error list view Export2Excel.ConvertCSVFile(tmpdt, result.ScalarValue + ".csv", exportfilepath); } return result; }
private SigmaResultType AddImportHistory(int iTotalCnt, int FailCnt, string filePath, string ImportCategory) { SigmaResultType HistoryResult = new SigmaResultType(); TypeImportHistory ImportHistory = new TypeImportHistory(); ImportHistoryMgr HistoryMgr = new ImportHistoryMgr(); int Failcnt = FailCnt++; int iSuccessCnt = iTotalCnt - Failcnt; ImportHistory.ImportCategory = ImportCategory; ImportHistory.ImportedFileName = Path.GetFileName(filePath).ToString(); ImportHistory.ImportedDate = DateTime.Now.ToString(); ImportHistory.TotalCount = iTotalCnt; ImportHistory.SuccessCount = iSuccessCnt; ImportHistory.FailCount = Failcnt; ImportHistory.CreatedBy = "ADMIN"; return HistoryResult = HistoryMgr.AddImportHistory(ImportHistory); }
public SigmaResultType AddDrawing(string fileUrl, string exportfilepath) { TypeUserInfo userinfo = AuthMgr.GetUserInfo(); DataTable dt = new DataTable(); DataTable tmpDt = new DataTable(); SigmaResultType result = new SigmaResultType(); dt = Element.Shared.Common.ImportHelper.ImportWorkSheet(fileUrl, true); DataTable tmpdt = new DataTable(); tmpdt = dt.Copy(); tmpdt.Rows.Clear(); tmpdt.Columns.Add("Fail reason"); int failCnt = 0; foreach (DataRow r in dt.Rows) { TypeDrawing obj = new TypeDrawing(); obj.CWP = r[0].ToString(); obj.Name = r[1].ToString(); obj.Revision = r[2].ToString(); obj.FileName = r[3].ToString(); obj.Title = r[4].ToString(); obj.DrawingType = r[5].ToString(); obj.Description = r[6].ToString(); if (string.IsNullOrEmpty(GetFailreasonForRequired(r))) { SigmaResultType rst = AddDrawing(obj); if (!string.IsNullOrEmpty(rst.ErrorMessage) && rst.ErrorMessage != "Success") { tmpdt.Rows.Add(r.ItemArray); tmpdt.Rows[tmpdt.Rows.Count - 1]["Fail reason"] = rst.ErrorMessage.ToString(); failCnt++; } } else { tmpdt.Rows.Add(r.ItemArray); tmpdt.Rows[tmpdt.Rows.Count - 1]["Fail reason"] = GetFailreasonForRequired(r); failCnt++; } } TypeImportHistory ImportHistory = new TypeImportHistory(); ImportHistory.ImportCategory = "DRAWING"; ImportHistory.ImportedFileName = Path.GetFileName(fileUrl).ToString(); ImportHistory.ImportedDate = DateTime.Now.ToString(); ImportHistory.TotalCount = dt.Rows.Count; ImportHistory.SuccessCount = dt.Rows.Count - failCnt; ImportHistory.FailCount = failCnt; ImportHistory.CreatedBy = userinfo.SigmaUserId; ImportHistoryMgr HistoryMgr = new ImportHistoryMgr(); result = HistoryMgr.AddImportHistory(ImportHistory); //if exists error list if (tmpdt.Rows.Count > 0) { if (!System.IO.Directory.Exists(exportfilepath)) { System.IO.Directory.CreateDirectory(exportfilepath); } //excel file generate for direct call 'export' link Export2Excel.ConvertExcelfromData(tmpdt, result.ScalarValue + Path.GetExtension(fileUrl), exportfilepath); //csv file generate for import error list view Export2Excel.ConvertCSVFile(tmpdt, result.ScalarValue + ".csv", exportfilepath); } return result; }
public SigmaResultType ImportPersonnelFromExcel(string filePath, string exportfilepath) { TypeUserInfo userinfo = AuthMgr.GetUserInfo(); DataTable dt = new DataTable(); DataTable tmpDt = new DataTable(); SigmaResultType result = new SigmaResultType(); dt = Element.Shared.Common.ImportHelper.ImportWorkSheet(filePath, false); DataTable tmpdt = new DataTable(); tmpdt = dt.Copy(); tmpdt.Rows.Clear(); tmpdt.Columns.Add("Fail reason"); int failCnt = 0; foreach (DataRow r in dt.Rows) { TypePersonnel obj = new TypePersonnel(); obj.EmployeeId = r[0].ToString(); obj.FirstName = r[1].ToString(); obj.LastName = r[2].ToString(); obj.PhoneNumber = r[3].ToString(); obj.EmailAddress = r[4].ToString(); obj.RoleName = r[5].ToString(); obj.NfcCardId = r[6].ToString(); obj.PinCode = r[7].ToString(); obj.CompanyName = r[8].ToString(); obj.CreatedBy = userinfo.SigmaUserId; obj.ProjectId = userinfo.CurrentProjectId; if (string.IsNullOrEmpty(GetFailreasonForRequiredPersonnel(r))) { SigmaResultType rst = AddPersonnelByTemplate(obj); if (rst.ErrorMessage != null) { tmpdt.Rows.Add(r.ItemArray); tmpdt.Rows[tmpdt.Rows.Count - 1]["Fail reason"] = rst.ErrorMessage.ToString(); failCnt++; } } else { tmpdt.Rows.Add(r.ItemArray); tmpdt.Rows[tmpdt.Rows.Count - 1]["Fail reason"] = GetFailreasonForRequiredPersonnel(r); failCnt++; } } TypeImportHistory ImportHistory = new TypeImportHistory(); ImportHistory.ImportCategory = "HR"; ImportHistory.ImportedFileName = Path.GetFileName(filePath).ToString(); ImportHistory.ImportedDate = DateTime.Now.ToString(); ImportHistory.TotalCount = dt.Rows.Count; ImportHistory.SuccessCount = dt.Rows.Count - failCnt; ImportHistory.FailCount = failCnt; ImportHistory.CreatedBy = userinfo.SigmaUserId; ImportHistoryMgr HistoryMgr = new ImportHistoryMgr(); result = HistoryMgr.AddImportHistory(ImportHistory); //if exists error list if (tmpdt.Rows.Count > 0) { if (!System.IO.Directory.Exists(exportfilepath)) { System.IO.Directory.CreateDirectory(exportfilepath); } //excel file generate for direct call 'export' link Export2Excel.ConvertExcelfromData(tmpdt, result.ScalarValue + Path.GetExtension(filePath), exportfilepath); //csv file generate for import error list view Export2Excel.ConvertCSVFile(tmpdt, result.ScalarValue + ".csv", exportfilepath); } return result; }