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