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