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