private List <SqlParameter> Set_Values_In_Enquiry(EnquiryInfo enquiry) { List <SqlParameter> sqlParams = new List <SqlParameter>(); if (enquiry.Enquiry_Id != 0) { sqlParams.Add(new SqlParameter("@Enquiry_Id", enquiry.Enquiry_Id)); } sqlParams.Add(new SqlParameter("@Enquiry_No", enquiry.Enquiry_No)); sqlParams.Add(new SqlParameter("@Enquiry_Type_Id", enquiry.Enquiry_Type_Id)); sqlParams.Add(new SqlParameter("@Enquiry_Status_Id", enquiry.Enquiry_Status_Id)); sqlParams.Add(new SqlParameter("@Customer_Id", enquiry.Customer_Id)); sqlParams.Add(new SqlParameter("@Quality_Id", enquiry.Quality_Id)); sqlParams.Add(new SqlParameter("@PPC_Article_Type_Id", enquiry.PPC_Article_Type_Id)); sqlParams.Add(new SqlParameter("@Quality_Set_Id", enquiry.Quality_Set_Id)); sqlParams.Add(new SqlParameter("@Is_Active", enquiry.Is_Active)); if (enquiry.Enquiry_Id == 0) { sqlParams.Add(new SqlParameter("@CreatedBy", enquiry.CreatedBy)); sqlParams.Add(new SqlParameter("@CreatedOn", enquiry.CreatedOn)); } sqlParams.Add(new SqlParameter("@UpdatedBy", enquiry.UpdatedBy)); sqlParams.Add(new SqlParameter("@UpdatedOn", enquiry.UpdatedOn)); return(sqlParams); }
public PackageViewModel() { FriendlyMessage = new List <FriendlyMessage>(); Pager = new PaginationInfo(); Package = new PackageInfo(); PackageFilter = new PackageFilter(); Packages = new List <PackageInfo>(); PackageItinerary = new PackageItineraryInfo(); PackageItineraries = new List <PackageItineraryInfo>(); PackageDate = new PackageDatesInfo(); PackageDates = new List <PackageDatesInfo>(); PackageTypes = new List <PackageTypeInfo>(); City = new CityInfo(); Cities = new List <CityInfo>(); Location = new CityInfo(); Locations = new List <CityInfo>(); Hotel = new HotelInfo(); Hotels = new List <HotelInfo>(); Meal = new MealInfo(); Meals = new List <MealInfo>(); Images = new List <AccessoriesInfo>(); PackageSearchList = new List <PackageInfo>(); Enquiry = new EnquiryInfo(); EnquiryGitDetails = new List <EnquiryInfo>(); DayItemTriff = new List <PackageDaysTriffInfo>(); packagedaytriff = new PackageDaysTriffInfo(); packageDayItems = new PackageDayitemTriffinfo(); Packageduration = new PackageDuration(); PackageDurationNetrate = new List <PackageDuration>(); PackageCustomerCategory = new List <PackageCustomerCategoryInfo>(); PriceList = new List <PackageDuration>(); }
public JsonResult Insert(EnquiryViewModel eViewModel) { EnquiryInfo enquiry = new EnquiryInfo(); try { eViewModel.Enquiry.CreatedBy = ((UserInfo)Session["User"]).UserId; eViewModel.Enquiry.UpdatedBy = ((UserInfo)Session["User"]).UserId; eViewModel.Enquiry.CreatedOn = DateTime.Now; eViewModel.Enquiry.UpdatedOn = DateTime.Now; enquiry = eViewModel.Enquiry; _enquiryMan.Insert_Enquiry(ref enquiry); eViewModel.Enquiry = enquiry; eViewModel.Friendly_Message.Add(MessageStore.Get("EQ001")); } catch (Exception ex) { eViewModel.Friendly_Message.Add(MessageStore.Get("SYS01")); Logger.Error("Enquiry Controller - Insert " + ex.ToString()); } finally { enquiry = null; } return(Json(eViewModel)); }
public async Task <IActionResult> Edit(int id, [Bind("EnquiryID,Name,Email,Mobile,Subject,Message,EnquiryDate")] EnquiryInfo enquiryInfo) { if (id != enquiryInfo.EnquiryID) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(enquiryInfo); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!EnquiryInfoExists(enquiryInfo.EnquiryID)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(enquiryInfo)); }
public EnquiryViewModel() { FriendlyMessage = new List <FriendlyMessage>(); Pager = new PaginationInfo(); Enquiry = new EnquiryInfo(); EnquiryFilter = new EnquiryFilter(); Enquiries = new List <EnquiryInfo>(); EnquiryItemRoomDetail = new EnquiryItemRoomDetailsInfo(); EnquiryItemRoomDetails = new List <EnquiryItemRoomDetailsInfo>(); EnquiryItemPassDetail = new EnquiryItemPassDetailsInfo(); EnquiryItemPassDetails = new List <EnquiryItemPassDetailsInfo>(); EnquiryItemTypeDetail = new EnquiryItemTypeDetailsInfo(); EnquiryItemTypeDetails = new List <EnquiryItemTypeDetailsInfo>(); EnquiryItemTransferDetail = new EnquiryItemTransferDetailsInfo(); EnquiryItemTransferDetails = new List <EnquiryItemTransferDetailsInfo>(); PackageTypes = new List <PackageTypeInfo>(); HotelTypes = new List <HotelTypeInfo>(); RoomTypes = new List <RoomTypeInfo>(); Cities = new List <CityInfo>(); Customers = new List <CustomerInfo>(); Vendors = new List <VendorInfo>(); Users = new List <UserInfo>(); PackageTypeMappings = new List <PackageTypeMappingInfo>(); Specialization = new List <SpecializationInfo>(); Countries = new List <CountryInfo>(); States = new List <StateInfo>(); cityes = new List <CityInfo>(); Occupancies = new List <OccupancyInfo>(); }
public async Task <IActionResult> Create([Bind("EnquiryID,Name,Email,Mobile,Subject,Message")] EnquiryInfo enquiryInfo) { if (ModelState.IsValid) { enquiryInfo.EnquiryDate = DateTime.Now; _context.Add(enquiryInfo); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Create))); } return(View(enquiryInfo)); }
public void Insert_Enquiry(ref EnquiryInfo enquiry) { DataTable dt = _sqlRepo.ExecuteDataTable(Set_Values_In_Enquiry(enquiry), StoredProcedures.Insert_Enquiry_Sp.ToString(), CommandType.StoredProcedure); List <DataRow> drList = new List <DataRow>(); drList = dt.AsEnumerable().ToList(); foreach (DataRow dr in drList) { enquiry.Enquiry_Id = Convert.ToInt32(dr["Enquiry_Id"]); enquiry.Enquiry_No = Convert.ToString(dr["Enquiry_No"]); } }
protected void repEnquiry_ItemCommand(object source, RepeaterCommandEventArgs e) { if (e.CommandName.Equals("del")) //delete enquiry { int id = int.Parse(e.CommandArgument.ToString()); BakersLoungeEntities data = new BakersLoungeEntities(); EnquiryInfo cid = new EnquiryInfo(); cid = data.EnquiryInfoes.Single(v => v.EnquiryId == id); // get "enquiry id" to delete! data.EnquiryInfoes.Attach(cid); data.EnquiryInfoes.Remove(cid); data.SaveChanges(); BindRepEnquiry(); lblMsg.Text = "*Enquiry Deleted!!"; } }
public EnquiryViewModel() { Friendly_Message = new List<FriendlyMessageInfo>(); Pager = new PaginationInfo(); Enquiry = new EnquiryInfo(); Enquiries = new List<EnquiryInfo>(); Filter = new Enquiry_Filter(); Attribute_Codes = new List<AttributeCodeInfo>(); Packing = new List<PackingInfo>(); }
public void Update_Enquiry_PPC_Checkpoint(EnquiryInfo enquiry) { List <SqlParameter> sqlParams = new List <SqlParameter>(); sqlParams.Add(new SqlParameter("@Enquiry_Id", enquiry.Enquiry_Id)); sqlParams.Add(new SqlParameter("@PPC_Article_Type_Id", enquiry.PPC_Article_Type_Id)); sqlParams.Add(new SqlParameter("@Enquiry_Status_Id", enquiry.Enquiry_Status_Id)); sqlParams.Add(new SqlParameter("@Quality_Id", enquiry.Quality_Id)); sqlParams.Add(new SqlParameter("@UpdatedBy", enquiry.UpdatedBy)); sqlParams.Add(new SqlParameter("@UpdatedOn", enquiry.UpdatedOn)); _sqlRepo.ExecuteNonQuery(sqlParams, StoredProcedures.Update_Enquiry_PPC_Checkpoint_Sp.ToString(), CommandType.StoredProcedure); }
public EnquiryInfo Get_Enquiry_By_Id(int enquiry_Id) { EnquiryInfo enquiry = new EnquiryInfo(); List <SqlParameter> sqlParams = new List <SqlParameter>(); sqlParams.Add(new SqlParameter("@Enquiry_Id", enquiry_Id)); DataTable dt = _sqlRepo.ExecuteDataTable(sqlParams, StoredProcedures.Get_Enquiry_By_Id_Sp.ToString(), CommandType.StoredProcedure); List <DataRow> drList = new List <DataRow>(); drList = dt.AsEnumerable().ToList(); foreach (DataRow dr in drList) { enquiry = Get_Enquiry_Values(dr); } return(enquiry); }
private EnquiryInfo Get_Enquiry_Values(DataRow dr) { EnquiryInfo enquiry = new EnquiryInfo(); enquiry.Enquiry_Id = Convert.ToInt32(dr["Enquiry_Id"]); enquiry.Enquiry_No = Convert.ToString(dr["Enquiry_No"]); enquiry.Enquiry_Type_Id = Convert.ToInt32(dr["Enquiry_Type_Id"]); enquiry.Enquiry_Status_Id = Convert.ToInt32(dr["Enquiry_Status_Id"]); enquiry.Customer_Id = Convert.ToInt32(dr["Customer_Id"]); enquiry.Quality_Id = Convert.ToInt32(dr["Quality_Id"]); enquiry.PPC_Article_Type_Id = Convert.ToInt32(dr["PPC_Article_Type_Id"]); enquiry.Quality_Set_Id = Convert.ToInt32(dr["Quality_Set_Id"]); enquiry.Is_Active = Convert.ToBoolean(dr["Is_Active"]); enquiry.CreatedBy = Convert.ToInt32(dr["CreatedBy"]); enquiry.CreatedOn = Convert.ToDateTime(dr["CreatedOn"]); enquiry.UpdatedBy = Convert.ToInt32(dr["UpdatedBy"]); enquiry.UpdatedOn = Convert.ToDateTime(dr["UpdatedOn"]); enquiry.Customer_Name = Convert.ToString(dr["Customer_Name"]); enquiry.Quality_No = Convert.ToString(dr["Quality_No"]); return(enquiry); }
public QuotationViewModel() { FriendlyMessage = new List <FriendlyMessage>(); Pager = new PaginationInfo(); Quotation = new QuotationInfo(); QuotaionItems = new List <QuotationInfo>(); FlightQuotations = new List <QuotationInfo>(); TrainQuotations = new List <QuotationInfo>(); QuotationFilter = new QuotationFilter(); Enquiry = new EnquiryInfo(); Enquiries = new List <EnquiryInfo>(); EnquiryItemRoomDetail = new EnquiryItemRoomDetailsInfo(); EnquiryItemRoomDetails = new List <EnquiryItemRoomDetailsInfo>(); EnquiryItemPassDetail = new EnquiryItemPassDetailsInfo(); EnquiryItemPassDetails = new List <EnquiryItemPassDetailsInfo>(); EnquiryItemTypeDetail = new EnquiryItemTypeDetailsInfo(); EnquiryItemTypeDetails = new List <EnquiryItemTypeDetailsInfo>(); EnquiryItemTransferDetail = new EnquiryItemTransferDetailsInfo(); EnquiryItemTransferDetails = new List <EnquiryItemTransferDetailsInfo>(); QuotationItemRoomDetail = new QuotationItemRoomDetailsInfo(); QuotationItemRoomDetails = new List <QuotationItemRoomDetailsInfo>(); QuotationItemPassDetail = new QuotationItemPassDetailsInfo(); TrainQuotationItemPassDetails = new List <QuotationItemPassDetailsInfo>(); QuotationItemTypeDetail = new QuotationItemTypeDetailsInfo(); FlightQuotationItemTypeDetails = new List <QuotationItemTypeDetailsInfo>(); QuotationItemTransferDetail = new QuotationItemTransferDetailsInfo(); QuotationItemTransferDetails = new List <QuotationItemTransferDetailsInfo>(); HotelSearch = new HotelSearchInfo(); PackageSearchList = new List <PackageInfo>(); Package = new PackageInfo(); HotelSearchList = new List <HotelSearchInfo>(); HotelSearchExtraList = new List <HotelSearchInfo>(); HotelSearchRoomList = new List <HotelSearchInfo>(); HotelSearchRoomMealOccupancyPrice = new HotelSearchRoomMealOccupancyPrice(); HotelSearchRoomMealOccupancyPriceList = new List <HotelSearchRoomMealOccupancyPrice>(); Cities = new List <CityInfo>(); Users = new List <UserInfo>(); GitQuotation = new List <QuotationInfo>(); SightSeeingQuatation = new List <QuotationInfo>(); HotelQuotation = new List <QuotationInfo>(); }
public void Update_Enquiry(EnquiryInfo enquiry) { _enquiryRepo.Update_Enquiry(enquiry); }
public void Update_Enquiry(EnquiryInfo enquiry) { _sqlRepo.ExecuteNonQuery(Set_Values_In_Enquiry(enquiry), StoredProcedures.Update_Enquiry_Sp.ToString(), CommandType.StoredProcedure); }
public LohanaPackageTariffSearchViewModel() { FriendlyMessage = new List <FriendlyMessage>(); LohanaPackageTariffSearch = new LohanaPackageTariffSearchInfo(); LohanaPackageTariffSearchList = new List <LohanaPackageTariffSearchInfo>(); LohanaPackageTariffRoot = new LohanaPackageTariffRootInfo(); LohanaPackageTariffRootList = new List <LohanaPackageTariffRootInfo>(); LohanaPackageTariff = new LohanaPackageTariffInfo(); LohanaPackageTariffList = new List <LohanaPackageTariffInfo>(); HotelTariff = new HotelTariffInfo(); HotelTariffs = new List <HotelTariffInfo>(); PackageType = new PackageTypeInfo(); PackageTypes = new List <PackageTypeInfo>(); Hotel = new HotelInfo(); Hotels = new List <HotelInfo>(); RoomType = new RoomTypeInfo(); Cities = new List <CityInfo>(); City = new CityInfo(); Pager = new PaginationInfo(); HotelTariffDate = new HotelTariffDateDetailsInfo(); HotelTariffDates = new List <HotelTariffDateDetailsInfo>(); HotelTariffDuration = new HotelTariffDurationDetailsInfo(); HotelTariffDurations = new List <HotelTariffDurationDetailsInfo>(); HotelTariffPrice = new HotelTariffPriceDetailsInfo(); HotelTariffPrices = new List <HotelTariffPriceDetailsInfo>(); HotelTariffRoom = new HotelTariffRoomDetailsInfo(); HotelTariffRooms = new List <HotelTariffRoomDetailsInfo>(); LohanaPackageTariffSearchRoomList = new List <LohanaPackageTariffSearchInfo>(); LohanaPackageTariffSearchExtraChildList = new List <LohanaPackageTariffSearchInfo>(); LohanaPackageTariffSearchExtraList = new List <LohanaPackageTariffSearchInfo>(); LohanaPackageTariffSearchFilter = new LohanaPackageTariffSearchInfo(); LohanaPackageTariffSearchFilterList = new List <LohanaPackageTariffSearchInfo>(); LohanaPackageItienaryList = new List <LohanaPackageTariffSearchInfo>(); Enquiry = new EnquiryInfo(); }
public void Insert_Enquiry(ref EnquiryInfo enquiry) { _enquiryRepo.Insert_Enquiry(ref enquiry); }
//submiting customer query protected void btnSubmit_Click(object sender, EventArgs e) { try { string email, name, mobile, msg = "", subject; email = txtemail.Text.Trim(); mobile = txtMobile.Text.Trim(); name = txtName.Text.Trim(); subject = ddlSubject.SelectedItem.Text; msg += txtUrcomments.Text.Trim(); if (Checks.Empty(name) || Checks.Empty(email) || Checks.Empty(mobile)) { lblMsg.Text = "Please fill all the fields"; txtName.Focus(); } else if (Checks.Empty(name)) { lblMsg.Text = "Please enter your name"; } else if (Checks.Empty(email)) { lblMsg.Text = "Please enter your email address"; } else if (Checks.Empty(mobile)) { lblMsg.Text = "Please enter your mobile number"; } else if (!Checks.checkNumber(mobile)) { lblMsg.Text = "Please enter numbers only"; } else if (subject.Contains("-1")) { lblMsg.Text = "Please select an item from the list"; } else { EnquiryInfo data = new EnquiryInfo(); data.Email = email; data.Mobile = long.Parse(mobile); data.Message = msg; data.Name = name; data.Subject = subject; BakersLoungeEntities real = new BakersLoungeEntities(); real.EnquiryInfoes.Add(data); real.SaveChanges(); txtUrcomments.Text = ""; txtemail.Text = ""; txtMobile.Text = ""; txtName.Text = ""; ddlSubject.SelectedIndex = int.Parse("-1"); BindDdlSubjectCategory(); lblMsg.Text = "Your response has been received!"; } } catch (Exception ex) { lblMsg.Text = ex.Message; } }
public void Update_Enquiry_PPC_Checkpoint(EnquiryInfo enquiry) { _enquiryRepo.Update_Enquiry_PPC_Checkpoint(enquiry); }