public void AddPackageImages(PackageImages objPackageImages) { try { _logger.addMessage.Add("AddPackageImages", "AddPackageImages Method is going to Execute"); Dictionary <string, object> objparamlist = new Dictionary <string, object>(); _logger.addMessage.Add("CompanyID", objPackageImages.CompanyID); objparamlist.Add("CompanyID", objPackageImages.CompanyID); _logger.addMessage.Add("PackageCode", objPackageImages.PackageCode); objparamlist.Add("PackageCode", objPackageImages.PackageCode); _logger.addMessage.Add("PackageImageName", objPackageImages.PackageImageName); objparamlist.Add("PackageImageName", objPackageImages.PackageImageName); _logger.addMessage.Add("PackageImageTitle", objPackageImages.PackageImageTitle); objparamlist.Add("PackageImageTitle", objPackageImages.PackageImageTitle); IConnector objConnector = new Connector(); bool status = objConnector.ExecuteNonQuery("PackageModule", "InsertPackageImages", objparamlist); _logger.addMessage.Add("AddPackageImages", "Package Images Saved Successfully"); } catch (Exception ex) { AsyncLogger.LogEventVwr("UpdatePackageHotelCosting", ex.ToString(), ex.StackTrace); _logger.addMessage.Add("AddPackageImages", "Error during Add Package Images Method Execution:" + ex.ToString()); } finally { AsyncLogger.LogMessage(_logger); } }
public void InsertPackageCancellationPolicy(PackageDetails objPackageCancellationPolicy) { try { _logger.addMessage.Add("InsertPackageCancellationPolicy", "InsertPackageCancellationPolicy Method is going to Execute"); Dictionary <string, object> objparamlist = new Dictionary <string, object>(); _logger.addMessage.Add("CompanyID", objPackageCancellationPolicy.CompanyID); objparamlist.Add("CompanyID", objPackageCancellationPolicy.CompanyID); _logger.addMessage.Add("PackageCode", objPackageCancellationPolicy.BasicPackageDetails.PackageCode.ToString()); objparamlist.Add("PackageCode", objPackageCancellationPolicy.BasicPackageDetails.PackageCode); _logger.addMessage.Add("PackageViewFormat", objPackageCancellationPolicy.PackageCancellationPolicy.ViewFormat.ToString()); objparamlist.Add("ViewFormat", objPackageCancellationPolicy.PackageCancellationPolicy.ViewFormat); _logger.addMessage.Add("CancellationPolicyText", objPackageCancellationPolicy.PackageCancellationPolicy.CancellationPolicyText.ToString()); objparamlist.Add("CancellationPolicyText", objPackageCancellationPolicy.PackageCancellationPolicy.CancellationPolicyText); IConnector objConnector = new Connector(); bool status = objConnector.ExecuteNonQuery("PackageModule", "FSP_InsertCancellationPolicy", objparamlist); _logger.addMessage.Add("InsertPackageCancellationPolicy", "Cancellation policy inserted or updated successfully"); } catch (Exception ex) { _logger.addMessage.Add("InsertPackageCancellationPolicy", "Error during Insert Package Cancellation Policy Method Execution:" + ex.ToString()); } finally { AsyncLogger.LogMessage(_logger); } }
/// <summary> /// Get Hotel Saved Costing info for package pecific /// </summary> /// <param name="objHotelCosting"></param> /// <returns></returns> public List <HotelCosting> GetPackageHotelCosting(HotelCostingRequest objHotelCostingRequest) { List <HotelCosting> objlstHotelCosting = null; try { _logger.addMessage.Add("UpdatePackageHotelCosting", "Package Hotel costing updated successfully"); Dictionary <string, object> objparamlist = new Dictionary <string, object>(); _logger.addMessage.Add("CompanyID", objHotelCostingRequest.CompanyID); objparamlist.Add("CompanyID", objHotelCostingRequest.CompanyID); _logger.addMessage.Add("PackageCode", objHotelCostingRequest.PackageCode); objparamlist.Add("PackageCode", objHotelCostingRequest.PackageCode); _logger.addMessage.Add("PackageLanguage", objHotelCostingRequest.PackageLanguage); objparamlist.Add("PackageLanguage", objHotelCostingRequest.PackageLanguage); IConnector objConnector = new Connector(); DataTable dtPackageHotelCosting = objConnector.ExecuteDataTable("PackageModule", "FSP_GetPkgHotelCosting", objparamlist); _logger.addMessage.Add("GetHotelCosting", "Package costing fetch Successfully"); if (dtPackageHotelCosting.Rows.Count > 0) { objlstHotelCosting = new List <HotelCosting>(); for (int i = 0; i < dtPackageHotelCosting.Rows.Count; i++) { HotelCosting objHotelCosting = new HotelCosting(); objHotelCosting.CompanyID = objHotelCostingRequest.CompanyID; objHotelCosting.PackageCode = objHotelCostingRequest.PackageCode; objHotelCosting.Currency = dtPackageHotelCosting.Rows[i]["Currency"].ToString(); objHotelCosting.AdultCost = Convert.ToDouble(dtPackageHotelCosting.Rows[i]["AdultCost"]); objHotelCosting.ChildCost = Convert.ToDouble(dtPackageHotelCosting.Rows[i]["ChildCost"]); objHotelCosting.HotelCityName = dtPackageHotelCosting.Rows[i]["HotelCityName"].ToString(); objHotelCosting.HotelName = dtPackageHotelCosting.Rows[i]["HotelName"].ToString(); objHotelCosting.RoomType = dtPackageHotelCosting.Rows[i]["RoomType"].ToString(); objHotelCosting.PackageLanguage = dtPackageHotelCosting.Rows[i]["PackageLanguage"].ToString(); objHotelCosting.id = Convert.ToInt16(dtPackageHotelCosting.Rows[i]["id"]); objlstHotelCosting.Add(item: objHotelCosting); } _logger.addMessage.Add("GetHotelCosting", "GetHotelCosting Method result" + JsonConvert.SerializeObject(objlstHotelCosting)); } else { _logger.addMessage.Add("GetHotelCosting", "No Package Hotel Costing find for Package Code=" + objHotelCostingRequest.PackageCode); } } catch (Exception ex) { AsyncLogger.LogEventVwr("UpdatePackageHotelCosting", ex.ToString(), ex.StackTrace); _logger.ExceptionError = true; _logger.addMessage.Add("GetHotelCosting", "Error during get Package hotel costing Method Execution:" + ex.ToString()); } finally { AsyncLogger.LogMessage(_logger); } return(objlstHotelCosting); }
public List <PackageImages> GetPackageImages(string PackageCode, string CompanyID) { List <PackageImages> objlstPackageImages = null; try { _logger.addMessage.Add("GetPackageImages", "GetPackageImages Method is going to Execute"); Dictionary <string, object> objparamlist = new Dictionary <string, object>(); _logger.addMessage.Add("CompanyID", CompanyID); objparamlist.Add("CompanyID", CompanyID); _logger.addMessage.Add("PackageCode", PackageCode); objparamlist.Add("PackageCode", PackageCode); IConnector objConnector = new Connector(); DataTable dtPackageImageList = objConnector.ExecuteDataTable("PackageModule", "GetPackageImages", objparamlist); _logger.addMessage.Add("GetPackageImages", "Package Images find Successfully"); if (dtPackageImageList.Rows.Count > 0) { objlstPackageImages = new List <PackageImages>(); for (int i = 0; i < dtPackageImageList.Rows.Count; i++) { PackageImages objPackageImages = new PackageImages(); objPackageImages.CompanyID = CompanyID; objPackageImages.PackageCode = PackageCode; objPackageImages.PackageImageName = dtPackageImageList.Rows[i]["Name"].ToString(); objPackageImages.PackageImageTitle = dtPackageImageList.Rows[i]["Title"].ToString(); objPackageImages.PackageVirtualImage = Convert.ToBoolean(dtPackageImageList.Rows[i]["PackageVirtualImage"]); objlstPackageImages.Add(objPackageImages); } } else { _logger.addMessage.Add("GetPackageImages", "No Package Images find for Package Code=" + PackageCode); } } catch (Exception ex) { AsyncLogger.LogEventVwr("UpdatePackageHotelCosting", ex.ToString(), ex.StackTrace); _logger.addMessage.Add("GetPackageImages", "Error during Get Package Images Method Execution:" + ex.ToString()); } finally { AsyncLogger.LogMessage(_logger); } return(objlstPackageImages); }
public string GetPackageCode() { string PackageCode = ""; try { _logger.addMessage.Add("AddPackage", "AddPackage Method is going to Execute"); IConnector objConnector = new Connector(); PackageCode = Convert.ToString(objConnector.ExecuteScalar("PackageModule", "GetPackageCode")); _logger.addMessage.Add("Registeruser", "Agent User sign up successfully"); } catch (Exception ex) { _logger.addMessage.Add("Registeruser", "Error during Register user Method Execution:" + ex.ToString()); } finally { AsyncLogger.LogMessage(_logger); } return(PackageCode); }
public string GetPackageDetails(PackageList objPackageList) { try { _logger.addMessage.Add("GetPackageDetails", "GetPackageDetails Method is going to Execute"); Dictionary <string, object> objparamlist = new Dictionary <string, object>(); _logger.addMessage.Add("CompanyID", objPackageList.CompanyID); objparamlist.Add("CompanyID", objPackageList.CompanyID); _logger.addMessage.Add("PackageLanguage", objPackageList.PackageLanguage); objparamlist.Add("PackageLanguage", objPackageList.PackageLanguage); _logger.addMessage.Add("PackageCode", objPackageList.PackageCode); objparamlist.Add("PackageCode", objPackageList.PackageCode); _logger.addMessage.Add("GetPackageDetails", "FSP_GetPackageDetails is going to call"); IConnector objConnector = new Connector(); DataSet dtPackageList = objConnector.ExecuteDataSet("PackageModule", "FSP_GetPackageDetails", objparamlist); _logger.addMessage.Add("GetPackageDetails", "Get Package Details Get successfully"); dtPackageList.Tables[0].TableName = "BasicPackageDetails"; dtPackageList.Tables[1].TableName = "BasicPackageCreteria"; dtPackageList.Tables[2].TableName = "PackageCancellationPolicy"; string JSONResult = CommonUtility.DataSettoJSON(dtPackageList); _logger.addMessage.Add("GetPackageDetails", "Converted JSON Result" + JSONResult); return(JSONResult); } catch (Exception ex) { _logger.addMessage.Add("GetPackageDetails", "Error during GetPackageDetails Method Execution:" + ex.ToString()); } finally { AsyncLogger.LogMessage(_logger); } return(null); }
public string GetAirportList(AirportList objAirportList) { try { _logger.addMessage.Add("GetAirportList", "GetAirportList Method is going to Execute"); Dictionary <string, object> objparamlist = new Dictionary <string, object>(); _logger.addMessage.Add("CompanyID", objAirportList.CompanyID); objparamlist.Add("CompanyID", objAirportList.CompanyID); //_logger.addMessage.Add("LanguageCode", objPackageList.PackageLanguage); //objparamlist.Add("LanguageCode", objPackageList.PackageLanguage); _logger.addMessage.Add("Query", objAirportList.query); objparamlist.Add("Query", objAirportList.query); _logger.addMessage.Add("GetAirportList", "FSP_GetAirportList is going to call"); IConnector objConnector = new Connector(); DataTable dtPackageList = objConnector.ExecuteDataTable("CompanyAdmin", "FSP_GetAirportList", objparamlist); _logger.addMessage.Add("GetAirportList", "Get Airport List successfully"); string JSONResult = CommonUtility.GetDataTableToJSON(dtPackageList); _logger.addMessage.Add("GetAirportList", "Converted JSON Result" + JSONResult); return(JSONResult); } catch (Exception ex) { _logger.addMessage.Add("GetAirportList", "Error during GetAirportList Method Execution:" + ex.ToString()); } finally { AsyncLogger.LogMessage(_logger); } return(null); }
public bool UpdatePackageHotelCosting(List <HotelCosting> objHotelCosting) { bool status = false; try { _logger.addMessage.Add("UpdatePackageHotelCosting", "UpdatePackageHotelCosting Method is going to Execute"); string CurrencyCode = System.Configuration.ConfigurationManager.AppSettings["CompanyCurrency"].ToString(); //Before updating hotel costing remove existing costing for that package if (objHotelCosting != null && objHotelCosting.Count > 0) { _logger.addMessage.Add("UpdatePackageHotelCosting", "Before updating hotel costing remove existing costing for that package is going to Execute"); Dictionary <string, object> objparamlist = new Dictionary <string, object>(); _logger.addMessage.Add("CompanyID", objHotelCosting[0].CompanyID); objparamlist.Add("CompanyID", objHotelCosting[0].CompanyID); _logger.addMessage.Add("PackageCode", objHotelCosting[0].PackageCode); objparamlist.Add("PackageCode", objHotelCosting[0].PackageCode); _logger.addMessage.Add("PackageLanguage", objHotelCosting[0].PackageLanguage.ToString()); objparamlist.Add("PackageLanguage", objHotelCosting[0].PackageLanguage.ToString()); _logger.addMessage.Add("UpdatePackageHotelCosting", "FSP_deletePkgHotelCosting procedure is going to execute to remove existing hotel costing for the same package."); IConnector objConnector = new Connector(); status = objConnector.ExecuteNonQuery("PackageModule", "FSP_deletePkgHotelCosting", objparamlist); if (status) { _logger.addMessage.Add("UpdatePackageHotelCosting", "FSP_deletePkgHotelCosting procedure executed successfully."); foreach (var item in objHotelCosting) { objparamlist = new Dictionary <string, object>(); _logger.addMessage.Add("CompanyID", item.CompanyID); objparamlist.Add("CompanyID", item.CompanyID); _logger.addMessage.Add("PackageCode", item.PackageCode); objparamlist.Add("PackageCode", item.PackageCode); _logger.addMessage.Add("HID", item.id.ToString()); objparamlist.Add("HID", item.id.ToString()); _logger.addMessage.Add("RoomType", item.RoomType); objparamlist.Add("RoomType", item.RoomType); _logger.addMessage.Add("HotelName", item.HotelName); objparamlist.Add("HotelName", item.HotelName); _logger.addMessage.Add("HotelCityName", item.HotelCityName); objparamlist.Add("HotelCityName", item.HotelCityName); _logger.addMessage.Add("AdultCost", item.AdultCost.ToString()); objparamlist.Add("AdultCost", item.AdultCost); _logger.addMessage.Add("ChildCost", item.ChildCost.ToString()); objparamlist.Add("ChildCost", item.ChildCost); _logger.addMessage.Add("CurrencyCode", CurrencyCode); objparamlist.Add("CurrencyCode", CurrencyCode); _logger.addMessage.Add("PackageLanguage", item.PackageLanguage.ToString()); objparamlist.Add("PackageLanguage", item.PackageLanguage); //IConnector objConnector = new Connector(); status = objConnector.ExecuteNonQuery("PackageModule", "FSP_InsertPkgHotelCosting", objparamlist); } } } else { _logger.addMessage.Add("UpdatePackageHotelCosting", "No costing available for update"); } _logger.addMessage.Add("UpdatePackageHotelCosting", "Package Hotel costing updated successfully"); } catch (Exception ex) { AsyncLogger.LogEventVwr("UpdatePackageHotelCosting", ex.ToString(), ex.StackTrace); _logger.ExceptionError = true; _logger.addMessage.Add("UpdatePackageHotelCosting", "Error during Update Package hotel costing Method Execution:" + ex.ToString()); } finally { AsyncLogger.LogMessage(_logger); } return(status); }
public string GetRoeRate(string BaseCurrency, string SupplierCurrency) { string path; try { if (System.Configuration.ConfigurationManager.AppSettings.AllKeys.Contains("CurrencyManagementType") && System.Configuration.ConfigurationManager.AppSettings["CurrencyManagementType"].ToString().ToUpper() == "FILE") { _logger.addMessage.Add("CurrencyManagementType", "File"); if (System.Configuration.ConfigurationManager.AppSettings.AllKeys.Contains("CurrencyROEPath")) { path = System.Configuration.ConfigurationManager.AppSettings["CurrencyROEPath"].ToString(); _logger.addMessage.Add("CurrencyROEPath", path); _logger.addMessage.Add("Base Currency", BaseCurrency); _logger.addMessage.Add("Supplier Currency", SupplierCurrency); string LangConversion = ""; string mapPath = System.Web.HttpContext.Current.Server.MapPath(@"~/App_Data/" + BaseCurrency + ".json"); if (!File.Exists(mapPath)) { _logger.addMessage.Add("CurrencyROEPath", "No Currency File Available For this Base Currency."); _logger.ExceptionError = true; return(null); } using (StreamReader r = new StreamReader(mapPath)) { LangConversion = r.ReadToEnd(); } List <CurrencyManagement> objAllList = JsonConvert.DeserializeObject <List <CurrencyManagement> >(LangConversion); IEnumerable <string> objCurrencyManagement = objAllList.Where(m => m.CurrencyCode == SupplierCurrency).Select(m => m.ROE); foreach (var item in objCurrencyManagement) { return(item); } } else { _logger.addMessage.Add("CurrencyROEPath", "Kindly configure CurrencyROEPath in Web.Config..If it is not there!!!!"); _logger.ExceptionError = true; throw new Exception("Kindly configure CurrencyROEPath in Web.Config..If it is not there!!!!"); // Key doesn't exist } } else { _logger.addMessage.Add("CurrencyROEPath", "Kindly configure CurrencyROEPath in Web.Config..If it is not there!!!!"); _logger.ExceptionError = true; throw new Exception("Kindly configure CurrencyROEPath in Web.Config..If it is not there!!!!"); // Key doesn't e } } catch (Exception ex) { _logger.addMessage.Add("GetRoeRate", "Error during Get Roe Method Execution :" + ex.ToString()); _logger.ExceptionError = true; } finally { AsyncLogger.LogMessage(_logger, "", "CurrencyManager"); } return(null); }
public void AddPackage(PackageDetails objPackageDetails) { try { _logger.addMessage.Add("AddPackage", "AddPackage Method is going to Execute"); Dictionary <string, object> objparamlist = new Dictionary <string, object>(); _logger.addMessage.Add("CompanyID", objPackageDetails.CompanyID); objparamlist.Add("CompanyID", objPackageDetails.CompanyID); _logger.addMessage.Add("PackageCode", objPackageDetails.BasicPackageDetails.PackageCode.ToString()); objparamlist.Add("PackageCode", objPackageDetails.BasicPackageDetails.PackageCode); _logger.addMessage.Add("PackageName", objPackageDetails.BasicPackageDetails.PackageName.ToString()); objparamlist.Add("PackageName", objPackageDetails.BasicPackageDetails.PackageName); _logger.addMessage.Add("PackageLanguage", objPackageDetails.BasicPackageDetails.PackageLanguage.ToString()); objparamlist.Add("PackageLanguage", objPackageDetails.BasicPackageDetails.PackageLanguage); _logger.addMessage.Add("PackageTitle", objPackageDetails.BasicPackageDetails.PackageTitle.ToString()); objparamlist.Add("PackageTitle", objPackageDetails.BasicPackageDetails.PackageTitle); _logger.addMessage.Add("PackageMarket", objPackageDetails.BasicPackageCreteria.PackageMarket.ToString()); objparamlist.Add("PackageMarket", objPackageDetails.BasicPackageCreteria.PackageMarket); _logger.addMessage.Add("PackageSaleMarket", objPackageDetails.BasicPackageCreteria.PackageSaleMarket.ToString()); objparamlist.Add("PackageSaleMarket", objPackageDetails.BasicPackageCreteria.PackageSaleMarket); _logger.addMessage.Add("PackageValidityStartDate", objPackageDetails.BasicPackageCreteria.PackageValidityStartDate.ToString()); objparamlist.Add("PackageValidityStartDate", objPackageDetails.BasicPackageCreteria.PackageValidityStartDate); _logger.addMessage.Add("PackageValidityEndDate", objPackageDetails.BasicPackageCreteria.PackageValidityEndDate.ToString()); objparamlist.Add("PackageValidityEndDate", objPackageDetails.BasicPackageCreteria.PackageValidityEndDate); _logger.addMessage.Add("PackageBookingStartDate", objPackageDetails.BasicPackageCreteria.PackageBookingStartDate.ToString()); objparamlist.Add("PackageBookingStartDate", objPackageDetails.BasicPackageCreteria.PackageBookingStartDate); _logger.addMessage.Add("PackageBookingEndDate", objPackageDetails.BasicPackageCreteria.PackageBookingEndDate.ToString()); objparamlist.Add("PackageBookingEndDate", objPackageDetails.BasicPackageCreteria.PackageBookingEndDate); _logger.addMessage.Add("PackageDuration", objPackageDetails.BasicPackageCreteria.PackageDuration.ToString()); objparamlist.Add("PackageDuration", objPackageDetails.BasicPackageCreteria.PackageDuration); _logger.addMessage.Add("ChildMinAge", objPackageDetails.BasicPackageCreteria.ChildMinAge.ToString()); objparamlist.Add("ChildMinAge", objPackageDetails.BasicPackageCreteria.ChildMinAge); _logger.addMessage.Add("ChildMaxAge", objPackageDetails.BasicPackageCreteria.ChildMaxAge.ToString()); objparamlist.Add("ChildMaxAge", objPackageDetails.BasicPackageCreteria.ChildMaxAge); _logger.addMessage.Add("PackageLastPaymentDue", objPackageDetails.BasicPackageCreteria.PackageLastPaymentDue.ToString()); objparamlist.Add("PackageLastPaymentDue", objPackageDetails.BasicPackageCreteria.PackageLastPaymentDue); _logger.addMessage.Add("PackagePaymentCutOffDay", objPackageDetails.BasicPackageCreteria.PackagePaymentCutOffDay.ToString()); objparamlist.Add("PackagePaymentCutOffDay", objPackageDetails.BasicPackageCreteria.PackagePaymentCutOffDay); _logger.addMessage.Add("DiscountonFullPayment", objPackageDetails.BasicPackageCreteria.DiscountonFullPayment.ToString()); objparamlist.Add("DiscountonFullPayment", objPackageDetails.BasicPackageCreteria.DiscountonFullPayment); IConnector objConnector = new Connector(); bool status = objConnector.ExecuteNonQuery("PackageModule", "FSP_InsertPackageDetails", objparamlist); _logger.addMessage.Add("AddPackage", "Package Detail Inserted or updated succesfully."); } catch (Exception ex) { _logger.ExceptionError = true; _logger.addMessage.Add("AddPackage", "Error during AddPackage Method Execution:" + ex.ToString()); } finally { AsyncLogger.LogMessage(_logger); } }