private void ShowDTGrid() { Stream Stream = (System.IO.Stream)OpenFileDialog.File.OpenRead(); byte[] Buffer = new byte[Stream.Length]; Stream.Read(Buffer, 0, (int)Stream.Length); Stream.Dispose(); Stream.Close(); SMT.Saas.Tools.AttendanceWS.UploadFileModel UploadFile = new Saas.Tools.AttendanceWS.UploadFileModel(); UploadFile.FileName = OpenFileDialog.File.Name; UploadFile.File = Buffer; clientAtt.ImportAttendMonthlyBalanceForShowAsync(UploadFile); }
private void ImportBalance() { string strMsg = string.Empty; try { string strUnitType = string.Empty, strUnitObjectId = string.Empty; int dYear = 0, dMonth = 0; DateTime dtImportDate = new DateTime(), dtCurDate = new DateTime(); int.TryParse(nuYear.Value.ToString(), out dYear); int.TryParse(nuMonth.Value.ToString(), out dMonth); DateTime.TryParse(dYear.ToString() + "-" + dMonth.ToString() + "-1", out dtImportDate); DateTime.TryParse(DateTime.Now.ToString("yyyy-MM") + "-1", out dtCurDate); if (dtImportDate > dtCurDate) { Utility.ShowCustomMessage(MessageTypes.Error, Utility.GetResourceStr("IMPORTBALANCEDATE"), Utility.GetResourceStr("DATECOMPARECURENTTIME", "BALANCEYEAR")); return; } if (cbxkBalanceUnitType.SelectedItem == null) { Utility.ShowCustomMessage(MessageTypes.Error, Utility.GetResourceStr("CLOCKINRDUNITTYPE"), Utility.GetResourceStr("REQUIRED", "CLOCKINRDUNITTYPE")); return; } if (lkBalanceUnit.DataContext == null) { Utility.ShowCustomMessage(MessageTypes.Error, Utility.GetResourceStr("CLOCKINRDUNIT"), Utility.GetResourceStr("REQUIRED", "CLOCKINRDUNIT")); return; } T_SYS_DICTIONARY entUnitType = cbxkBalanceUnitType.SelectedItem as T_SYS_DICTIONARY; if (string.IsNullOrEmpty(entUnitType.DICTIONARYID) || string.IsNullOrEmpty(entUnitType.DICTIONCATEGORY) || string.IsNullOrEmpty(entUnitType.DICTIONARYVALUE.ToString())) { Utility.ShowCustomMessage(MessageTypes.Error, Utility.GetResourceStr("CLOCKINRDUNITTYPE"), Utility.GetResourceStr("REQUIRED", "CLOCKINRDUNITTYPE")); return; } strUnitType = entUnitType.DICTIONARYVALUE.ToString(); if (strUnitType == (Convert.ToInt32(AssignedObjectType.Company) + 1).ToString()) { T_HR_COMPANY entCompany = lkBalanceUnit.DataContext as T_HR_COMPANY; strUnitObjectId = entCompany.COMPANYID; } else if (strUnitType == (Convert.ToInt32(AssignedObjectType.Department) + 1).ToString()) { T_HR_DEPARTMENT entDepartment = lkBalanceUnit.DataContext as T_HR_DEPARTMENT; strUnitObjectId = entDepartment.DEPARTMENTID; } else if (strUnitType == (Convert.ToInt32(AssignedObjectType.Post) + 1).ToString()) { T_HR_POST entPost = lkBalanceUnit.DataContext as T_HR_POST; strUnitObjectId = entPost.POSTID; } if (OpenFileDialog == null) { Utility.ShowCustomMessage(MessageTypes.Error, Utility.GetResourceStr("ERROR"), Utility.GetResourceStr("REQUIREDIMPORTFILE")); return; } if (OpenFileDialog.File == null) { Utility.ShowCustomMessage(MessageTypes.Error, Utility.GetResourceStr("ERROR"), Utility.GetResourceStr("REQUIREDIMPORTFILE")); return; } RefreshUI(RefreshedTypes.ProgressBar); Stream Stream = (System.IO.Stream)OpenFileDialog.File.OpenRead(); byte[] Buffer = new byte[Stream.Length]; Stream.Read(Buffer, 0, (int)Stream.Length); Stream.Dispose(); Stream.Close(); SMT.Saas.Tools.AttendanceWS.UploadFileModel UploadFile = new Saas.Tools.AttendanceWS.UploadFileModel(); UploadFile.FileName = OpenFileDialog.File.Name; UploadFile.File = Buffer; clientAtt.ImportAttendMonthlyBalanceFromCSVAsync(UploadFile, SMT.SAAS.Main.CurrentContext.Common.CurrentLoginUserInfo.EmployeeID, strUnitType, strUnitObjectId, dYear, dMonth, strMsg); strMsg = string.Empty; } catch (Exception ex) { Utility.ShowCustomMessage(MessageTypes.Error, Utility.GetResourceStr("ERROR"), Utility.GetResourceStr(ex.Message.ToString())); } }