/// <summary> /// This Function is used to write the Missing Targets Vs Missing Business Class Data Passed to corresponding FilePath /// </summary> /// <param name="LoginId"></param> /// <param name="MissingTargetsVsBusinessClass"></param> private void WriteMissingTargetsVsBusinessClassChartCacheFile(string LoginId, List <MissingTargetsVsBusinessClass> MissingTargetsVsBusinessClass) { const string FUNCTION_NAME = "WriteMissingTargetsVsBusinessClassChartCacheFile"; SICTLogger.WriteInfo(CLASS_NAME, FUNCTION_NAME, "Start for LoginId -" + LoginId); try { DepartureFormBusiness ObjDepartureFormBusiness = new DepartureFormBusiness(); BusinessUtil ObjBusinessUtil = new BusinessUtil(); string FilePath = string.Empty; string FolderPath = string.Empty; string MissingTargetsandBusinessClassData = string.Empty; ObjBusinessUtil.GetMissingTargetsVsBusinessClassChartsFilePath(LoginId, ref FilePath, ref FolderPath); Boolean IsFolderExists = System.IO.Directory.Exists(FolderPath); if (!IsFolderExists) { System.IO.Directory.CreateDirectory(FolderPath); } SICTLogger.WriteVerbose(CLASS_NAME, FUNCTION_NAME, "MissingTargetsVsBusinessClass Charts cache file for AirportLoginId- " + LoginId); using (var MemoryStream = new MemoryStream()) { var Serlizer = new System.Runtime.Serialization.Json.DataContractJsonSerializer(typeof(List <MissingTargetsVsBusinessClass>)); Serlizer.WriteObject(MemoryStream, MissingTargetsVsBusinessClass); MissingTargetsandBusinessClassData = System.Text.Encoding.UTF8.GetString(MemoryStream.GetBuffer(), 0, Convert.ToInt32(MemoryStream.Length)); ObjDepartureFormBusiness.WriteToFile(MissingTargetsandBusinessClassData, FilePath); } } catch (Exception Ex) { SICTLogger.WriteException(CLASS_NAME, FUNCTION_NAME, Ex); } SICTLogger.WriteInfo(CLASS_NAME, FUNCTION_NAME, "End for LoginId -" + LoginId); }
private void DownloadDataInBackground(string SessionId, DepartureFormFilterDetails DepartureFormFilterDetails, string FilePath) { DownloadResponse DownloadResponse = new DownloadResponse(); SICTLogger.WriteInfo(DownloadBusiness.CLASS_NAME, "DownloadDataInBackground", "Start "); try { DepartureFormBusiness ObjDepartureFormBusiness = new DepartureFormBusiness(); DataAccessLayer.DataAccessLayer DBLayer = new DataAccessLayer.DataAccessLayer(); System.Collections.Generic.List <DepartureFormDetails> DepartureFormDetails = new System.Collections.Generic.List <DepartureFormDetails>(); string OrderByCondition = string.Empty; string WhereCondition = string.Empty; Workbook Wb = new Workbook(); Worksheet DataSheet = null; this.AddDataSheetToWorkBook(ref Wb, ref DataSheet, "Forms"); this.InsertFormFilterstoWorkBook(ref DataSheet, DepartureFormFilterDetails); ObjDepartureFormBusiness.BuildOrderByandWhereConditions(DepartureFormFilterDetails, ref OrderByCondition, ref WhereCondition); int RecordsPerLoop = System.Convert.ToInt32(ConfigurationManager.AppSettings[BusinessConstants.UPLOAD_ROWS_CNT].ToString()); int StartIndex = 0; int Count = 0; bool IsFirstRecord = true; int DataRow = 1; do { DataSet DSCardDetails = new DataSet(); DSCardDetails = DBLayer.GetGlobalDepartureFormDetailst(SessionId, StartIndex, RecordsPerLoop, OrderByCondition, WhereCondition, DepartureFormFilterDetails.AirportId, DepartureFormFilterDetails.IsDepartureForm, false, 0L, 0L); if (DSCardDetails.Tables.Count == 2) { if (IsFirstRecord) { Count = System.Convert.ToInt32(DSCardDetails.Tables[0].Rows[0][BusinessConstants.FORM_TOTALRECORDS].ToString()); IsFirstRecord = false; } this.InsertFormDataToWorksheet(DSCardDetails.Tables[1], ref DataSheet, ref DataRow); StartIndex += RecordsPerLoop; if (StartIndex < Count && StartIndex + RecordsPerLoop > Count) { RecordsPerLoop = Count - StartIndex; } } }while (StartIndex < Count); Wb.Save(FilePath, new OoxmlSaveOptions(SaveFormat.Xlsx)); } catch (System.Exception Ex) { DownloadResponse.ReturnCode = -1; DownloadResponse.ReturnMessage = "Error in Function "; SICTLogger.WriteException(DownloadBusiness.CLASS_NAME, "DownloadDataInBackground", Ex); } }
public DepartureFormBusiness GetDepartureFormBusiness(string Version) { DepartureFormBusiness result; if (string.IsNullOrEmpty(Version) || Version.Equals("V1", StringComparison.InvariantCultureIgnoreCase)) { result = new DepartureFormBusiness(); } else { result = new DepartureFormBusiness(); } return(result); }