public FinalDepartureFormDetails GetDepartureFormDetails(string Instance, string SessionId, string Version, DepartureFormFilterDetails DepartureFormFilterDetails) { FinalDepartureFormDetails finalDepartureFormDetails = new FinalDepartureFormDetails(); SICTLogger.WriteInfo(DepartureFormServices.CLASS_NAME, "GetDepartureFormDetails", "Start"); try { UserDetailsBusiness userDetailsBusiness = new FactoryBusiness().GetUserDetailsBusiness(BusinessConstants.VERSION_BASE); if (userDetailsBusiness.IsSessionIdValid(SessionId, false)) { DepartureFormBusiness departureFormBusiness = new FactoryBusiness().GetDepartureFormBusiness(Version); finalDepartureFormDetails = departureFormBusiness.GetDepartureFormDetails(Instance, SessionId, DepartureFormFilterDetails); } else { finalDepartureFormDetails.ReturnCode = 0; finalDepartureFormDetails.ReturnMessage = "Invalid session"; SICTLogger.WriteWarning(DepartureFormServices.CLASS_NAME, "GetDepartureFormDetails", "Invalid session "); } } catch (Exception ex) { finalDepartureFormDetails.ReturnCode = -1; finalDepartureFormDetails.ReturnMessage = "Error in API Execution"; SICTLogger.WriteException(DepartureFormServices.CLASS_NAME, "GetDepartureFormDetails", ex); } SICTLogger.WriteInfo(DepartureFormServices.CLASS_NAME, "GetDepartureFormDetails", "End"); return(finalDepartureFormDetails); }
private void InsertFormDataToWorksheet(DataTable DtForm, ref Worksheet DataSheet, ref int DataRow) { FinalDepartureFormDetails FinalDepartureFormDetails = new FinalDepartureFormDetails(); SICTLogger.WriteInfo(DownloadBusiness.CLASS_NAME, "InsertFormDataToWorksheet", "Start "); try { foreach (DataRow Dr in DtForm.Rows) { this.SetExcelCellStyle(ref DataSheet, DataRow, 0, 12, System.Drawing.Color.White, false, false, 0, false); DataSheet.Cells[DataRow, 0].PutValue(System.Convert.ToInt32(Dr[BusinessConstants.FORM_FORMID].ToString())); this.SetExcelCellStyle(ref DataSheet, DataRow, 1, 12, System.Drawing.Color.White, false, false, 0, false); string AirportName = string.Empty; string AirportCode = string.Empty; if (!string.IsNullOrEmpty(Dr[BusinessConstants.FORM_AIRPORTNAME].ToString())) { AirportName = Dr[BusinessConstants.FORM_AIRPORTNAME].ToString(); } if (!string.IsNullOrEmpty(Dr[BusinessConstants.AIRPORTCODE].ToString())) { AirportCode = Dr[BusinessConstants.AIRPORTCODE].ToString(); } DataSheet.Cells[DataRow, 1].PutValue(string.Format("{0} ({1})", AirportName, AirportCode)); this.SetExcelCellStyle(ref DataSheet, DataRow, 2, 12, System.Drawing.Color.White, false, false, 14, false); if (!string.IsNullOrEmpty(Dr[BusinessConstants.FORM_DISTRIBUTIONDATE].ToString())) { System.DateTime Date = System.Convert.ToDateTime(Dr[BusinessConstants.FORM_DISTRIBUTIONDATE].ToString()).Date; DataSheet.Cells[DataRow, 2].PutValue(Date); } this.SetExcelCellStyle(ref DataSheet, DataRow, 3, 12, System.Drawing.Color.White, false, false, 0, false); if (!string.IsNullOrEmpty(Dr[BusinessConstants.FORM_INTERVIEWERNAME].ToString())) { DataSheet.Cells[DataRow, 3].PutValue(Dr[BusinessConstants.FORM_INTERVIEWERNAME].ToString()); } this.SetExcelCellStyle(ref DataSheet, DataRow, 4, 12, System.Drawing.Color.White, false, false, 0, false); if (!string.IsNullOrEmpty(Dr[BusinessConstants.FORM_AIRLINENAME].ToString())) { DataSheet.Cells[DataRow, 4].PutValue(Dr[BusinessConstants.FORM_AIRLINENAME].ToString()); } this.SetExcelCellStyle(ref DataSheet, DataRow, 5, 12, System.Drawing.Color.White, false, false, 0, false); if (!string.IsNullOrEmpty(Dr[BusinessConstants.FORM_TYPE].ToString())) { string Type = Dr[BusinessConstants.FORM_TYPE].ToString(); if (Type == BusinessConstants.FORM_TYPE_DEPARTURE) { DataSheet.Cells[DataRow, 5].PutValue("Departure"); } else { DataSheet.Cells[DataRow, 5].PutValue("Arrival"); } } this.SetExcelCellStyle(ref DataSheet, DataRow, 6, 12, System.Drawing.Color.White, false, false, 0, false); if (!string.IsNullOrEmpty(Dr[BusinessConstants.FORM_DESTINATIONNAME].ToString())) { DataSheet.Cells[DataRow, 6].PutValue(Dr[BusinessConstants.FORM_DESTINATIONNAME].ToString()); } this.SetExcelCellStyle(ref DataSheet, DataRow, 7, 12, System.Drawing.Color.White, false, false, 0, false); if (!string.IsNullOrEmpty(Dr[BusinessConstants.FORM_FLIGHTNUMBER].ToString())) { DataSheet.Cells[DataRow, 7].PutValue(Dr[BusinessConstants.FORM_FLIGHTNUMBER].ToString()); } this.SetExcelCellStyle(ref DataSheet, DataRow, 8, 12, System.Drawing.Color.White, false, false, 0, false); if (!string.IsNullOrEmpty(Dr["Language1"].ToString())) { DataSheet.Cells[DataRow, 8].PutValue(Dr["Language1"].ToString()); } this.SetExcelCellStyle(ref DataSheet, DataRow, 9, 12, System.Drawing.Color.White, false, false, 0, false); if (!string.IsNullOrEmpty(Dr["StartCode1"].ToString())) { DataSheet.Cells[DataRow, 9].PutValue((double)System.Convert.ToInt64(Dr["StartCode1"].ToString())); } this.SetExcelCellStyle(ref DataSheet, DataRow, 10, 12, System.Drawing.Color.White, false, false, 0, false); if (!string.IsNullOrEmpty(Dr["EndCode1"].ToString())) { DataSheet.Cells[DataRow, 10].PutValue((double)System.Convert.ToInt64(Dr["EndCode1"].ToString())); } this.SetExcelCellStyle(ref DataSheet, DataRow, 11, 12, System.Drawing.Color.White, false, false, 0, false); if (!string.IsNullOrEmpty(Dr["Language2"].ToString())) { DataSheet.Cells[DataRow, 11].PutValue(Dr["Language2"].ToString()); } this.SetExcelCellStyle(ref DataSheet, DataRow, 12, 12, System.Drawing.Color.White, false, false, 0, false); if (!string.IsNullOrEmpty(Dr["StartCode2"].ToString())) { DataSheet.Cells[DataRow, 12].PutValue((double)System.Convert.ToInt64(Dr["StartCode2"].ToString())); } this.SetExcelCellStyle(ref DataSheet, DataRow, 13, 12, System.Drawing.Color.White, false, false, 0, false); if (!string.IsNullOrEmpty(Dr["EndCode2"].ToString())) { DataSheet.Cells[DataRow, 13].PutValue((double)System.Convert.ToInt64(Dr["EndCode2"].ToString())); } this.SetExcelCellStyle(ref DataSheet, DataRow, 14, 12, System.Drawing.Color.White, false, false, 0, false); if (!string.IsNullOrEmpty(Dr["Language3"].ToString())) { DataSheet.Cells[DataRow, 14].PutValue(Dr["Language3"].ToString()); } this.SetExcelCellStyle(ref DataSheet, DataRow, 15, 12, System.Drawing.Color.White, false, false, 0, false); if (!string.IsNullOrEmpty(Dr["StartCode3"].ToString())) { DataSheet.Cells[DataRow, 15].PutValue((double)System.Convert.ToInt64(Dr["StartCode3"].ToString())); } this.SetExcelCellStyle(ref DataSheet, DataRow, 16, 12, System.Drawing.Color.White, false, false, 0, false); if (!string.IsNullOrEmpty(Dr["EndCode3"].ToString())) { DataSheet.Cells[DataRow, 16].PutValue((double)System.Convert.ToInt64(Dr["EndCode3"].ToString())); } this.SetExcelCellStyle(ref DataSheet, DataRow, 17, 12, System.Drawing.Color.White, false, false, 0, false); if (!string.IsNullOrEmpty(Dr["Language4"].ToString())) { DataSheet.Cells[DataRow, 17].PutValue(Dr["Language4"].ToString()); } this.SetExcelCellStyle(ref DataSheet, DataRow, 18, 12, System.Drawing.Color.White, false, false, 0, false); if (!string.IsNullOrEmpty(Dr["StartCode4"].ToString())) { DataSheet.Cells[DataRow, 18].PutValue((double)System.Convert.ToInt64(Dr["StartCode4"].ToString())); } this.SetExcelCellStyle(ref DataSheet, DataRow, 19, 12, System.Drawing.Color.White, false, false, 0, false); if (!string.IsNullOrEmpty(Dr["EndCode4"].ToString())) { DataSheet.Cells[DataRow, 19].PutValue((double)System.Convert.ToInt64(Dr["EndCode4"].ToString())); } this.SetExcelCellStyle(ref DataSheet, DataRow, 20, 12, System.Drawing.Color.White, false, false, 0, false); if (!string.IsNullOrEmpty(Dr["Language5"].ToString())) { DataSheet.Cells[DataRow, 20].PutValue(Dr["Language5"].ToString()); } this.SetExcelCellStyle(ref DataSheet, DataRow, 21, 12, System.Drawing.Color.White, false, false, 0, false); if (!string.IsNullOrEmpty(Dr["StartCode5"].ToString())) { DataSheet.Cells[DataRow, 21].PutValue((double)System.Convert.ToInt64(Dr["StartCode5"].ToString())); } this.SetExcelCellStyle(ref DataSheet, DataRow, 22, 12, System.Drawing.Color.White, false, false, 0, false); if (!string.IsNullOrEmpty(Dr["EndCode5"].ToString())) { DataSheet.Cells[DataRow, 22].PutValue((double)System.Convert.ToInt64(Dr["EndCode5"].ToString())); } this.SetExcelCellStyle(ref DataSheet, DataRow, 23, 12, System.Drawing.Color.White, false, false, 0, false); if (!string.IsNullOrEmpty(Dr["BusinessCards"].ToString())) { DataSheet.Cells[DataRow, 23].PutValue((double)System.Convert.ToInt64(Dr["BusinessCards"].ToString())); } string DateFormat = ConfigurationManager.AppSettings[BusinessConstants.CONFIG_FORM_DATE_FORMAT].ToString(); System.IFormatProvider enUsDateFormat = new System.Globalization.CultureInfo(DateFormat).DateTimeFormat; this.SetExcelCellStyle(ref DataSheet, DataRow, 24, 12, System.Drawing.Color.White, false, false, 22, false); if (!string.IsNullOrEmpty(Dr[BusinessConstants.FORM_LASTUPDATEDTIME].ToString())) { System.DateTime Date = System.Convert.ToDateTime(Dr[BusinessConstants.FORM_LASTUPDATEDTIME].ToString()); DataSheet.Cells[DataRow, 24].PutValue(Date); } DataRow++; } } catch (System.Exception Ex) { SICTLogger.WriteException(DownloadBusiness.CLASS_NAME, "InsertFormDataToWorksheet", Ex); } SICTLogger.WriteInfo(DownloadBusiness.CLASS_NAME, "InsertFormDataToWorksheet", "End"); }