public async Task <string> SaveHotelAsync(HotelSaveModel model)
        {
            try
            {
                ConvertListToDT objDT  = new ConvertListToDT();
                DataTable       typeDt = new DataTable();

                var parHotelID      = new SqlParameter("@HotelID", model.HotelID);
                var parDestID       = new SqlParameter("@DestinationID", model.DestinationID);
                var parHotelName    = new SqlParameter("@HotelName", model.HotelName);
                var parHotelAddress = new SqlParameter("@HotelAddress", model.HotelAddress);
                var parHotelContact = new SqlParameter("@HotelContact", model.HotelContact);
                var parHotelEmail   = new SqlParameter("@HotelEmail", model.HotelEmail ?? "");

                List <IDModel> tyepList = model.HotelTypes.Select(x => new IDModel()
                {
                    ID = Convert.ToInt64(x)
                }).ToList();
                typeDt = objDT.ConvertIEnumerableToDataTable(tyepList);

                var parSubDT = new SqlParameter("@HotelTypeTable", typeDt);
                parSubDT.SqlDbType = SqlDbType.Structured;
                parSubDT.TypeName  = "dbo.IDType";

                return(await db.Database.SqlQuery <string>("udspMstHotelSave @HotelID, @DestinationID, @HotelName, @HotelAddress, @HotelContact, @HotelEmail, @HotelTypeTable",
                                                           parHotelID, parDestID, parHotelName, parHotelAddress, parHotelContact, parHotelEmail, parSubDT).FirstOrDefaultAsync());
            }
            catch (Exception ex)
            {
                return("Error: " + ex.Message);
            }
        }
Example #2
0
        public async Task <GenTourPackageVM> SearchGenTourPackageListAsync(GenSearchModel search)
        {
            GenTourPackageVM model   = new GenTourPackageVM();
            ConvertListToDT  objList = new ConvertListToDT();
            DataTable        subdt   = new DataTable();

            try
            {
                //Converting subject list to datatable if record is present else send empty datatable
                if (search.TourType != null)
                {
                    List <IDModel> villList = search.TourType.Select(x => new IDModel()
                    {
                        ID = Convert.ToInt64(x)
                    }).ToList();
                    subdt = objList.ConvertIEnumerableToDataTable(villList);
                }
                else
                {
                    if (subdt.Columns.Count == 0)
                    {
                        DataColumn col = new DataColumn();
                        col.ColumnName = "ID";
                        subdt.Columns.Add(col);
                    }
                }
                var parSubDT = new SqlParameter("@TourTypeTable", subdt);
                parSubDT.SqlDbType = SqlDbType.Structured;
                parSubDT.TypeName  = "dbo.IDType";

                var parStart = new SqlParameter("@Start", (search.PageNo - 1) * search.PageSize);
                var parEnd   = new SqlParameter("@PageSize", search.PageSize);

                var parWhere = new SqlParameter("@Where", DBNull.Value);
                if (!(search.Where == null || search.Where == ""))
                {
                    parWhere.Value = search.Where;
                }
                // setting stored procedure OUTPUT value
                // This return total number of rows, and avoid two database call for data and total number of rows
                var spOutput = new SqlParameter
                {
                    ParameterName = "@TotalCount",
                    SqlDbType     = System.Data.SqlDbType.BigInt,
                    Direction     = System.Data.ParameterDirection.Output
                };

                model.PackageList = await db.Database.SqlQuery <GenTourPackageView>("udspGenTourPackageSearch @Start, @PageSize,@Where, @TourTypeTable, @TotalCount out",
                                                                                    parStart, parEnd, parWhere, parSubDT, spOutput).ToListAsync();

                model.TotalRecords = int.Parse(spOutput.Value.ToString());
                return(model);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        public async Task <string> SaveClientEnqActAsync(IEnumerable <utblClientEnquiryActivitie> model)
        {
            try
            {
                var             parEnquiryCode = new SqlParameter("@enquirycode", model.ElementAt(0).EnquiryCode);
                ConvertListToDT objList        = new ConvertListToDT();
                DataTable       actdt          = new DataTable();

                //Converting subject list to datatable if record is present else send empty datatable
                if (model != null)
                {
                    actdt = objList.ConvertIEnumerableToDataTable(model);
                }
                else
                {
                    if (actdt.Columns.Count == 0)
                    {
                        DataColumn col = new DataColumn();
                        col.ColumnName = "ClientActivityID";
                        actdt.Columns.Add(col);
                        DataColumn col1 = new DataColumn();
                        col1.ColumnName = "EnquiryCode";
                        actdt.Columns.Add(col1);
                        DataColumn col2 = new DataColumn();
                        col2.ColumnName = "RefPackageID";
                        actdt.Columns.Add(col2);
                        DataColumn col3 = new DataColumn();
                        col3.ColumnName = "ActivityID";
                        actdt.Columns.Add(col3);
                    }
                }

                var parActDT = new SqlParameter("@ClientActivityTable", actdt);
                parActDT.SqlDbType = SqlDbType.Structured;
                parActDT.TypeName  = "dbo.ClientActivityType";


                return(await objDB.Database.SqlQuery <string>("udspClientEnquiryActivitySave  @enquirycode, @CLientActivityTable",
                                                              parEnquiryCode, parActDT).FirstOrDefaultAsync());
            }
            catch (Exception ex)
            {
                return("Error: " + ex.Message);
            }
        }
Example #4
0
        public async Task <string> SaveItinerariesAsync(IEnumerable <utblTourPackageItinerary> model)
        {
            try
            {
                var parPackID = new SqlParameter("@PackageID", model.ElementAt(0).PackageID);

                ConvertListToDT objDT = new ConvertListToDT();
                DataTable       dt    = objDT.ConvertIEnumerableToDataTable(model);

                var parSubDT = new SqlParameter("@ItineraryTable", dt);
                parSubDT.SqlDbType = SqlDbType.Structured;
                parSubDT.TypeName  = "dbo.PackageItineraryType";

                return(await db.Database.SqlQuery <string>("udspTourPackageItinerarySave @PackageID, @ItineraryTable", parPackID, parSubDT).FirstOrDefaultAsync());
            }
            catch (Exception ex)
            {
                return("Error: " + ex.Message);
            }
        }
        public async Task <string> SaveItinerariesAsync(IEnumerable <utblClientEnquiryItinerarie> model)
        {
            try
            {
                var parEnquiryCode = new SqlParameter("@enqirycode", model.ElementAt(0).EnquiryCode);

                ConvertListToDT objDT = new ConvertListToDT();
                DataTable       dt    = objDT.ConvertIEnumerableToDataTable(model);

                var parSubDT = new SqlParameter("@ClientItineraryTable", dt);
                parSubDT.SqlDbType = SqlDbType.Structured;
                parSubDT.TypeName  = "dbo.ClientItineraryType";

                return(await objDB.Database.SqlQuery <string>("udspClientEnquiryItinerarySave @enqirycode, @ClientItineraryTable", parEnquiryCode, parSubDT).FirstOrDefaultAsync());
            }
            catch (Exception ex)
            {
                return("Error: " + ex.Message);
            }
        }
Example #6
0
        public async Task <string> SavePackageOfferAsync(SavePackageOffer model)
        {
            try
            {
                ConvertListToDT objDT  = new ConvertListToDT();
                DataTable       typeDt = new DataTable();

                var parPOffID = new SqlParameter("@PackageOfferID", model.PackageOffer.PackageOfferID);
                //var parPacID = new SqlParameter("@PackageID", DBNull.Value);
                //if (model.PackageID != null)
                //    parPacID = new SqlParameter("@PackageID", model.PackageID);
                var parOfferDiscount = new SqlParameter("@OfferDiscount", model.PackageOffer.OfferDiscount);
                var parOfferDesc     = new SqlParameter("@OfferDesc", model.PackageOffer.OfferDesc);
                //var parPOffer = new SqlParameter("@OfferPercent", model.PackageOffer.OfferPercent);
                var parOfferImgPath = new SqlParameter("@OfferImagePath", model.PackageOffer.OfferImagePath);
                var parStart        = new SqlParameter("@StartDate", model.PackageOffer.StartDate);
                var parEnd          = new SqlParameter("@EndDate", model.PackageOffer.EndDate);

                List <IDModel> tyepList = model.PackageID.Select(x => new IDModel()
                {
                    ID = Convert.ToInt64(x)
                }).ToList();
                typeDt = objDT.ConvertIEnumerableToDataTable(tyepList);

                var parSubDT = new SqlParameter("@PackageOfferTable", typeDt);
                parSubDT.SqlDbType = SqlDbType.Structured;
                parSubDT.TypeName  = "dbo.IDType";

                return(await db.Database.SqlQuery <string>("udspPackageOfferSave @PackageOfferID,@OfferDiscount, @OfferDesc, @OfferImagePath, @StartDate, @EndDate,@PackageOfferTable",
                                                           parPOffID, parOfferDiscount, parOfferDesc, parOfferImgPath, parStart, parEnd, parSubDT).FirstOrDefaultAsync());
            }
            catch (Exception ex)
            {
                return("Error: " + ex.Message);
            }
        }
Example #7
0
        public async Task <string> SavePackageExcTermsAsync(PackageExcTermSaveModel model)
        {
            try
            {
                var             parPackID = new SqlParameter("@PackageID", model.PackageID);
                ConvertListToDT objList   = new ConvertListToDT();
                DataTable       excdt     = new DataTable();
                DataTable       termdt    = new DataTable();
                DataTable       candt     = new DataTable();

                //Converting subject list to datatable if record is present else send empty datatable
                if (model.Exclusions != null)
                {
                    excdt = objList.ConvertIEnumerableToDataTable(model.Exclusions);
                }
                else
                {
                    if (excdt.Columns.Count == 0)
                    {
                        DataColumn col = new DataColumn();
                        col.ColumnName = "PackageExclusionID";
                        excdt.Columns.Add(col);
                        DataColumn col1 = new DataColumn();
                        col1.ColumnName = "PackageID";
                        excdt.Columns.Add(col1);
                        DataColumn col2 = new DataColumn();
                        col2.ColumnName = "ExclusionID";
                        excdt.Columns.Add(col2);
                    }
                }

                var parExDT = new SqlParameter("@ExclusionTable", excdt);
                parExDT.SqlDbType = SqlDbType.Structured;
                parExDT.TypeName  = "dbo.ExclusionType";

                if (model.Terms != null)
                {
                    termdt = objList.ConvertIEnumerableToDataTable(model.Terms);
                }
                else
                {
                    if (termdt.Columns.Count == 0)
                    {
                        DataColumn col = new DataColumn();
                        col.ColumnName = "PackageTermsID";
                        termdt.Columns.Add(col);
                        DataColumn col1 = new DataColumn();
                        col1.ColumnName = "PackageID";
                        termdt.Columns.Add(col1);
                        DataColumn col2 = new DataColumn();
                        col2.ColumnName = "TermID";
                        termdt.Columns.Add(col2);
                    }
                }

                var parTermDT = new SqlParameter("@TermTable", termdt);
                parTermDT.SqlDbType = SqlDbType.Structured;
                parTermDT.TypeName  = "dbo.TermType";


                if (model.Cancellations != null)
                {
                    candt = objList.ConvertIEnumerableToDataTable(model.Cancellations);
                }
                else
                {
                    if (candt.Columns.Count == 0)
                    {
                        DataColumn col = new DataColumn();
                        col.ColumnName = "PackageCancID";
                        candt.Columns.Add(col);
                        DataColumn col1 = new DataColumn();
                        col1.ColumnName = "PackageID";
                        candt.Columns.Add(col1);
                        DataColumn col2 = new DataColumn();
                        col2.ColumnName = "CancellationID";
                        candt.Columns.Add(col2);
                    }
                }

                var parCanDT = new SqlParameter("@CancellationTable", candt);
                parCanDT.SqlDbType = SqlDbType.Structured;
                parCanDT.TypeName  = "dbo.CancellationType";

                return(await db.Database.SqlQuery <string>("udspTourPackageExclusionTermSave @PackageID, @ExclusionTable, @TermTable, @CancellationTable",
                                                           parPackID, parExDT, parTermDT, parCanDT).FirstOrDefaultAsync());
            }
            catch (Exception ex)
            {
                return("Error: " + ex.Message);
            }
        }
Example #8
0
        public async Task <string> SavePackageActIncAsync(PackageActIncSaveModel model)
        {
            try
            {
                var             parPackID = new SqlParameter("@PackageID", model.PackageID);
                ConvertListToDT objList   = new ConvertListToDT();
                DataTable       actdt     = new DataTable();
                DataTable       incdt     = new DataTable();

                //Converting subject list to datatable if record is present else send empty datatable
                if (model.Activities != null)
                {
                    actdt = objList.ConvertIEnumerableToDataTable(model.Activities);
                }
                else
                {
                    if (actdt.Columns.Count == 0)
                    {
                        DataColumn col = new DataColumn();
                        col.ColumnName = "PackageActivityID";
                        actdt.Columns.Add(col);
                        DataColumn col1 = new DataColumn();
                        col1.ColumnName = "PackageID";
                        actdt.Columns.Add(col1);
                        DataColumn col2 = new DataColumn();
                        col2.ColumnName = "ActivityID";
                        actdt.Columns.Add(col2);
                        DataColumn col3 = new DataColumn();
                        col3.ColumnName = "ActivityFare";
                        actdt.Columns.Add(col3);
                    }
                }

                var parActDT = new SqlParameter("@ActivityTable", actdt);
                parActDT.SqlDbType = SqlDbType.Structured;
                parActDT.TypeName  = "dbo.ActivityType";

                if (model.Inclusions != null)
                {
                    incdt = objList.ConvertIEnumerableToDataTable(model.Inclusions);
                }
                else
                {
                    if (incdt.Columns.Count == 0)
                    {
                        DataColumn col = new DataColumn();
                        col.ColumnName = "PackageInclusionID";
                        incdt.Columns.Add(col);
                        DataColumn col1 = new DataColumn();
                        col1.ColumnName = "PackageID";
                        incdt.Columns.Add(col1);
                        DataColumn col2 = new DataColumn();
                        col2.ColumnName = "InclusionID";
                        incdt.Columns.Add(col2);
                        DataColumn col3 = new DataColumn();
                        col3.ColumnName = "InclusionFare";
                        incdt.Columns.Add(col3);
                    }
                }

                var parIncDT = new SqlParameter("@InclusionTable", incdt);
                parIncDT.SqlDbType = SqlDbType.Structured;
                parIncDT.TypeName  = "dbo.InclusionType";

                return(await db.Database.SqlQuery <string>("udspTourPackageActivityInclusionSave @PackageID, @ActivityTable, @InclusionTable",
                                                           parPackID, parActDT, parIncDT).FirstOrDefaultAsync());
            }
            catch (Exception ex)
            {
                return("Error: " + ex.Message);
            }
        }