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;
}
