/// <summary> /// This Function is used to create TargetVsCompletes Charts for Each active Airport Login and Store it in the Aproapriate path /// </summary> /// <returns></returns> public ReturnValue CreateCacheFileforTargetVsCompletesCharts(string Instance) { const string FUNCTION_NAME = "CreateCacheFileforTargetVsCompletesCharts"; ReturnValue RetValue = new ReturnValue(); SICTLogger.WriteInfo(CLASS_NAME, FUNCTION_NAME, "Start"); try { int Year = 0; int Quarter = 0; GetQuarterAndYearDetails(ref Quarter, ref Year); DataTable DtLogin = new DataTable(); SICTLogger.WriteVerbose(CLASS_NAME, FUNCTION_NAME, "Retrieving all Airport login's from DB"); DtLogin = GetAllAirportLogins(Instance); if (DtLogin.Rows.Count > 1) { for (int LoginCnt = 0; LoginCnt < DtLogin.Rows.Count; LoginCnt++) { int AirportLoginId = Convert.ToInt32(DtLogin.Rows[LoginCnt][BusinessConstants.AIRPORTLOGINID].ToString()); List <TargetsVsCompletes> TargetsandCompletes = new List <TargetsVsCompletes>(); List <MissingTargetsVsBusinessClass> MissingTargetsVsBusinessClass = new List <MissingTargetsVsBusinessClass>(); DataSet DSTargetCompletes = new DataSet(); SICTLogger.WriteVerbose(CLASS_NAME, FUNCTION_NAME, "Retrieving all Targets and Completes for the Airport login -" + AirportLoginId); DSTargetCompletes = GetTargetandCompleteforAirportLogin(Instance, AirportLoginId, Quarter, Year); if (DSTargetCompletes.Tables.Count > 2) { foreach (DataRow DrTarget in DSTargetCompletes.Tables[0].Rows) { //Target Vs Business Class TargetsVsCompletes TempTargetsandCompletes = new TargetsVsCompletes(); int AirlineId = Convert.ToInt32(DrTarget[BusinessConstants.AIRLINEID].ToString()); int Target = Convert.ToInt32(DrTarget[BusinessConstants.TARGET].ToString()); string AirlineName = DrTarget[BusinessConstants.AIRLINENAME].ToString(); string Code = DrTarget[BusinessConstants.CODE].ToString(); int Completes = 0; DataRow[] DrCompletes = DSTargetCompletes.Tables[1].Select(BusinessConstants.AIRLINEID + "=" + AirlineId); if (DrCompletes.Length > 0) { Completes = Convert.ToInt32(DrCompletes[0][BusinessConstants.COMPLETES].ToString()); } TempTargetsandCompletes.AirlineId = AirlineId; TempTargetsandCompletes.AirlineName = AirlineName; TempTargetsandCompletes.Code = Code; TempTargetsandCompletes.Target = Target; TempTargetsandCompletes.Completes = Completes; TargetsandCompletes.Add(TempTargetsandCompletes); //Missing Targets Vs Missing Business Class MissingTargetsVsBusinessClass TempMissingTargetsVsBusinessClass = new MissingTargetsVsBusinessClass(); int BusinessCompletes = 0; DataRow[] DrBusinessCompletes = DSTargetCompletes.Tables[2].Select(BusinessConstants.AIRLINEID + "=" + AirlineId); if (DrBusinessCompletes.Length > 0) { BusinessCompletes = Convert.ToInt32(DrBusinessCompletes[0][BusinessConstants.BUSINESSCOMPLETES].ToString()); } TempMissingTargetsVsBusinessClass.AirlineId = AirlineId; TempMissingTargetsVsBusinessClass.AirlineName = DrTarget[BusinessConstants.AIRLINENAME].ToString(); TempMissingTargetsVsBusinessClass.Code = DrTarget[BusinessConstants.CODE].ToString(); TempMissingTargetsVsBusinessClass.MissingTarget = Target - Completes; double BusinessTarget = (Target * (1 / 3.0)); TempMissingTargetsVsBusinessClass.MissingCompletes = Convert.ToInt32(Math.Round(BusinessTarget - BusinessCompletes, 0, MidpointRounding.AwayFromZero)); MissingTargetsVsBusinessClass.Add(TempMissingTargetsVsBusinessClass); } } WriteTargetVsCompletesChartsCacheFile(Instance, AirportLoginId.ToString(), TargetsandCompletes); WriteMissingTargetsVsBusinessClassChartCacheFile(Instance, AirportLoginId.ToString(), MissingTargetsVsBusinessClass); } } //Admin Cache File Creation List <TargetsVsCompletes> AllTargetsandCompletes = new List <TargetsVsCompletes>(); List <MissingTargetsVsBusinessClass> AllMissingTargetsVsBusinessClass = new List <MissingTargetsVsBusinessClass>(); DataSet DSAll = GetAllTargetandComplete(Instance, Quarter, Year); if (DSAll.Tables.Count > 2) { foreach (DataRow DrTarget in DSAll.Tables[0].Rows) { //Target Vs Business Class TargetsVsCompletes TempTargetsandCompletes = new TargetsVsCompletes(); int AirlineId = Convert.ToInt32(DrTarget[BusinessConstants.AIRLINEID].ToString()); int Target = Convert.ToInt32(DrTarget[BusinessConstants.TARGET].ToString()); string AirlineName = DrTarget[BusinessConstants.AIRLINENAME].ToString(); string Code = DrTarget[BusinessConstants.CODE].ToString(); int Completes = 0; DataRow[] DrCompletes = DSAll.Tables[1].Select(BusinessConstants.AIRLINEID + "=" + AirlineId); if (DrCompletes.Length > 0) { Completes = Convert.ToInt32(DrCompletes[0][BusinessConstants.COMPLETES].ToString()); } TempTargetsandCompletes.AirlineId = AirlineId; TempTargetsandCompletes.AirlineName = DrTarget[BusinessConstants.AIRLINENAME].ToString(); TempTargetsandCompletes.Code = Code; TempTargetsandCompletes.Target = Convert.ToInt32(DrTarget[BusinessConstants.TARGET].ToString()); TempTargetsandCompletes.Completes = Completes; AllTargetsandCompletes.Add(TempTargetsandCompletes); //Missing Targets Vs Missing Business Class MissingTargetsVsBusinessClass TempMissingTargetsVsBusinessClass = new MissingTargetsVsBusinessClass(); int BusinessCompletes = 0; DataRow[] DrBusinessCompletes = DSAll.Tables[2].Select(BusinessConstants.AIRLINEID + "=" + AirlineId); if (DrBusinessCompletes.Length > 0) { BusinessCompletes = Convert.ToInt32(DrBusinessCompletes[0][BusinessConstants.BUSINESSCOMPLETES].ToString()); } TempMissingTargetsVsBusinessClass.AirlineId = AirlineId; TempMissingTargetsVsBusinessClass.AirlineName = DrTarget[BusinessConstants.AIRLINENAME].ToString(); TempMissingTargetsVsBusinessClass.Code = DrTarget[BusinessConstants.CODE].ToString(); TempMissingTargetsVsBusinessClass.MissingTarget = Target - Completes; double BusinessTarget = (Target * (1 / 3.0)); TempMissingTargetsVsBusinessClass.MissingCompletes = Convert.ToInt32(Math.Round(BusinessTarget - BusinessCompletes, 0, MidpointRounding.AwayFromZero)); AllMissingTargetsVsBusinessClass.Add(TempMissingTargetsVsBusinessClass); } } WriteTargetVsCompletesChartsCacheFile(Instance, BusinessConstants.ADMIN_CACHEFILE_NAME, AllTargetsandCompletes); WriteMissingTargetsVsBusinessClassChartCacheFile(Instance, BusinessConstants.ADMIN_CACHEFILE_NAME, AllMissingTargetsVsBusinessClass); } catch (Exception Ex) { RetValue.ReturnCode = -1; RetValue.ReturnMessage = "Cache file creation Failed - error in API "; SICTLogger.WriteException(CLASS_NAME, FUNCTION_NAME, Ex); } SICTLogger.WriteInfo(CLASS_NAME, FUNCTION_NAME, "End"); return(RetValue); }
/// <summary> /// This Function is used to create TargetVsCompletes Charts for Each active Airport Login and Store it in the Aproapriate path /// </summary> /// <returns></returns> public ReturnValue CreateCacheFileforTargetVsCompletesCharts() { const string FUNCTION_NAME = "CreateCacheFileforTargetVsCompletesCharts"; ReturnValue RetValue = new ReturnValue(); SICTLogger.WriteInfo(CLASS_NAME, FUNCTION_NAME, "Start"); try { DataAccessLayer.DataAccessLayer DBLayer = new DataAccessLayer.DataAccessLayer(); DataTable DtLogin = new DataTable(); SICTLogger.WriteVerbose(CLASS_NAME, FUNCTION_NAME, "Retrieving all Airport login's from DB"); DtLogin = DBLayer.GetAllAirportLogins(); if (DtLogin.Rows.Count > 1) { for (int LoginCnt = 0; LoginCnt < DtLogin.Rows.Count; LoginCnt++) { int AirportLoginId = Convert.ToInt32(DtLogin.Rows[LoginCnt][BusinessConstants.AIRPORTLOGINID].ToString()); List <TargetsVsCompletes> TargetsandCompletes = new List <TargetsVsCompletes>(); List <MissingTargetsVsBusinessClass> MissingTargetsVsBusinessClass = new List <MissingTargetsVsBusinessClass>(); DataSet DSTargetCompletes = new DataSet(); SICTLogger.WriteVerbose(CLASS_NAME, FUNCTION_NAME, "Retrieving all Targets and Completes for the Airport login -" + AirportLoginId); DSTargetCompletes = DBLayer.GetTargetandCompleteforAirportLogin(AirportLoginId); if (DSTargetCompletes.Tables.Count > 2) { foreach (DataRow DrTarget in DSTargetCompletes.Tables[0].Rows) { //Target Vs Business Class TargetsVsCompletes TempTargetsandCompletes = new TargetsVsCompletes(); int AirlineId = Convert.ToInt32(DrTarget[BusinessConstants.AIRLINEID].ToString()); int Target = Convert.ToInt32(DrTarget[BusinessConstants.TARGET].ToString()); string AirlineName = DrTarget[BusinessConstants.AIRLINENAME].ToString(); int Completes = 0; DataRow[] DrCompletes = DSTargetCompletes.Tables[1].Select(BusinessConstants.AIRLINEID + "=" + AirlineId); if (DrCompletes.Length > 0) { Completes = Convert.ToInt32(DrCompletes[0][BusinessConstants.COMPLETES].ToString()); } TempTargetsandCompletes.AirlineId = AirlineId; TempTargetsandCompletes.AirlineName = AirlineName; TempTargetsandCompletes.Target = Target; TempTargetsandCompletes.Completes = Completes; TargetsandCompletes.Add(TempTargetsandCompletes); //Missing Targets Vs Missing Business Class MissingTargetsVsBusinessClass TempMissingTargetsVsBusinessClass = new MissingTargetsVsBusinessClass(); int BusinessCompletes = 0; DataRow[] DrBusinessCompletes = DSTargetCompletes.Tables[2].Select(BusinessConstants.AIRLINEID + "=" + AirlineId); if (DrBusinessCompletes.Length > 0) { BusinessCompletes = Convert.ToInt32(DrBusinessCompletes[0][BusinessConstants.BUSINESSCOMPLETES].ToString()); } TempMissingTargetsVsBusinessClass.AirlineId = AirlineId; TempMissingTargetsVsBusinessClass.AirlineName = DrTarget[BusinessConstants.AIRLINENAME].ToString(); TempMissingTargetsVsBusinessClass.MissingTarget = Target - Completes; TempMissingTargetsVsBusinessClass.MissingCompletes = (Target * (1 / 3)) - Convert.ToDouble(BusinessCompletes); MissingTargetsVsBusinessClass.Add(TempMissingTargetsVsBusinessClass); } } WriteTargetVsCompletesChartsCacheFile(AirportLoginId.ToString(), TargetsandCompletes); WriteMissingTargetsVsBusinessClassChartCacheFile(AirportLoginId.ToString(), MissingTargetsVsBusinessClass); } } //Admin Cache File Creation List <TargetsVsCompletes> AllTargetsandCompletes = new List <TargetsVsCompletes>(); List <MissingTargetsVsBusinessClass> AllMissingTargetsVsBusinessClass = new List <MissingTargetsVsBusinessClass>(); DataSet DSAll = DBLayer.GetAllTargetandComplete(); if (DSAll.Tables.Count > 2) { foreach (DataRow DrTarget in DSAll.Tables[0].Rows) { //Target Vs Business Class TargetsVsCompletes TempTargetsandCompletes = new TargetsVsCompletes(); int AirlineId = Convert.ToInt32(DrTarget[BusinessConstants.AIRLINEID].ToString()); int Target = Convert.ToInt32(DrTarget[BusinessConstants.TARGET].ToString()); string AirlineName = DrTarget[BusinessConstants.AIRLINENAME].ToString();; int Completes = 0; DataRow[] DrCompletes = DSAll.Tables[1].Select(BusinessConstants.AIRLINEID + "=" + AirlineId); if (DrCompletes.Length > 0) { Completes = Convert.ToInt32(DrCompletes[0][BusinessConstants.COMPLETES].ToString()); } TempTargetsandCompletes.AirlineId = AirlineId; TempTargetsandCompletes.AirlineName = DrTarget[BusinessConstants.AIRLINENAME].ToString(); TempTargetsandCompletes.Target = Convert.ToInt32(DrTarget[BusinessConstants.TARGET].ToString()); TempTargetsandCompletes.Completes = Completes; AllTargetsandCompletes.Add(TempTargetsandCompletes); //Missing Targets Vs Missing Business Class MissingTargetsVsBusinessClass TempMissingTargetsVsBusinessClass = new MissingTargetsVsBusinessClass(); int BusinessCompletes = 0; DataRow[] DrBusinessCompletes = DSAll.Tables[2].Select(BusinessConstants.AIRLINEID + "=" + AirlineId); if (DrBusinessCompletes.Length > 0) { BusinessCompletes = Convert.ToInt32(DrBusinessCompletes[0][BusinessConstants.BUSINESSCOMPLETES].ToString()); } TempMissingTargetsVsBusinessClass.AirlineId = AirlineId; TempMissingTargetsVsBusinessClass.AirlineName = DrTarget[BusinessConstants.AIRLINENAME].ToString(); TempMissingTargetsVsBusinessClass.MissingTarget = Target - Completes; TempMissingTargetsVsBusinessClass.MissingCompletes = (Target * 0.30) - Convert.ToDouble(BusinessCompletes); AllMissingTargetsVsBusinessClass.Add(TempMissingTargetsVsBusinessClass); } } WriteTargetVsCompletesChartsCacheFile("Admin", AllTargetsandCompletes); WriteMissingTargetsVsBusinessClassChartCacheFile("Admin", AllMissingTargetsVsBusinessClass); } catch (Exception Ex) { RetValue.ReturnCode = 2; RetValue.ReturnMessage = "Cache file creation Failed - error in API "; SICTLogger.WriteException(CLASS_NAME, FUNCTION_NAME, Ex); } SICTLogger.WriteInfo(CLASS_NAME, FUNCTION_NAME, "End"); return(RetValue); }