public IActionResult SaveQuickPickActivities(ActivitiesViewModel model)
{
PositionSetReq positionSetReq = new PositionSetReq();
string UserName = HttpContext.Request.Cookies["UserName"] ?? ckUserName;
IRequestCookieCollection objCookies = HttpContext.Request.Cookies;
SalesProviders salesProviders = new SalesProviders(_configuration);
RoutingDaysGetRes routingDaysRes = salesProviders.GetQRFRoutingDays(new RoutingDaysGetReq {
QRFID = model.QRFID
}, token).Result;
PositionGetReq positionGetReq = new PositionGetReq {
QRFID = model.QRFID
};
positionGetReq.ProductType.Add(new ProductType {
ProdType = "Attractions"
});
positionGetReq.ProductType.Add(new ProductType {
ProdType = "Sightseeing - CityTour"
});
PositionGetRes positionGetRes = positionProviders.GetPosition(positionGetReq, token).Result;
positionMapping.ActivitiesGet(positionGetRes, null, ref model, token);
positionSetReq = positionMapping.QuickPickActivitiesSet(model, routingDaysRes.RoutingDays, ckUserEmailId, positionGetRes);
positionSetReq.QRFID = model.QRFID;
positionSetReq.VoyagerUserID = ckLoginUser_Id;
PositionSetRes positionSetRes = positionProviders.SetPosition(positionSetReq, token).Result;
model.SaveType = "full";
return(RedirectToAction("Activities", new { model.QRFID, model.SaveType, IsClone = model.MenuViewModel.IsClone }));
}
public async Task <IndexViewModel> GetIndexViewModelAsync()
{
var user = await this.GetApplicationUserAsync();
var teams = (from registeredUser in this.Database.RegisteredUsers
where registeredUser.AspNetUserId == user.Id
from rut in registeredUser.Teams
select new IndexViewModel.Team
{
Id = rut.Team.Id,
Name = rut.Team.Name
}).ToArray();
var activities = await this.GetActivitiesAsync(user.Id);
var activitiesViewModel = new ActivitiesViewModel {
Activities = activities
};
var newsFeedContents = await this.GetFeedAsync(user.Id);
var newsFeedViewModel = new NewsFeedViewModel {
NewsFeed = newsFeedContents
};
var calendarViewModel = this.GetCalendarViewModel(nameof(IActivityController.GetCalendarEventsAsync), "User");
return(new IndexViewModel
{
Teams = teams,
Activities = activitiesViewModel,
NewsFeed = newsFeedViewModel,
Calendar = calendarViewModel
});
}
public ActionResult Create(ActivitiesViewModel activities)
{
if (ModelState.IsValid)
{
if (activities.titleList?.Length > 0)
{
foreach (var item in activities.titleList)
{
Employees_Titles titles = new Employees_Titles
{
EmployeeID = activities.Employees.EmployeeID,
TitleID = item
};
db.Employees_Titles.Add(titles);
}
db.Employees.Add(activities.Employees);
}
db.SaveChanges();
return(RedirectToAction("Employees", "AdminManager"));
}
return(View(activities));
}
private bool CheckDuplicateActivity(ActivitiesViewModel model)
{
var dayList = model.ActivityDetails.Select(a => a.ActivityDayNo).ToList();
bool isDuplicate = false; int activityCnt = 0;
foreach (var day in dayList)
{
var timeList = model.ActivityDetails.Where(a => a.ActivityDayNo == day).ToList();
foreach (var time in timeList)
{
activityCnt = model.ActivityDetails.Where(a => a.ActivityDayNo == day && a.StartTime == time.StartTime && a.ProductID == time.ProductID).Count();
if (activityCnt > 1)
{
isDuplicate = true;
break;
}
}
if (isDuplicate)
{
break;
}
}
return(isDuplicate);
}
protected override void OnReady(System.Windows.Navigation.NavigationEventArgs e)
{
if (!_alreadyNavigatedTo)
{
IDictionary <string, string> parameters = this.NavigationContext.QueryString;
string defaultPanoramaItem;
if (!parameters.TryGetValue("defaultPanoramaItem", out defaultPanoramaItem))
{
defaultPanoramaItem = "PanHome";
}
var defaultItem = PanMain.FindName(defaultPanoramaItem) as PanoramaItem;
PanMain.DefaultItem = defaultItem;
UpdateSelectedPanoramaItem(defaultItem);
_alreadyNavigatedTo = true;
}
else
{
//quick hack until i can figure out why the list isn't loading on back button
var oldActivitiesVM = PanActivity.DataContext as ActivitiesViewModel;
var newActivitiesVM = new ActivitiesViewModel();
if (oldActivitiesVM.LoadStarted)
{
newActivitiesVM.Load(oldActivitiesVM.AllLoaded);
}
PanActivity.DataContext = newActivitiesVM;
}
}
public ActionResult Add(int PackageId)
{
ActivitiesViewModel model = new ActivitiesViewModel();
Result <Package> result = new Result <Package>();
result = packageService.GetPackageById(PackageId);
if (result.Status == ResultEnum.Success &&
WebSecurity.CurrentUserId == result.Data.ApplicationUserId &&
result.Data.Activities.Count < MvcApplication.MAX_ACTIVITIES)
{
model.PackageId = result.Data.PackageId;
model.PackageName = result.Data.Name;
model.PackageCity = result.Data.City;
model.PackageState = result.Data.State;
model.ActivityNumber = result.Data.Activities.Count + 1;
}
else
{
return(RedirectToAction("Index", "Home"));
}
return(View(model));
}
public async Task <IActionResult> Activities()
{
ActivitiesViewModel activitiesViewModel = new ActivitiesViewModel();
var activitiesTypes = await _unitOfWork.ActivityTypes.GetAllAsync();
activitiesViewModel.activities = activitiesTypes;
return(View(activitiesViewModel));
}
public IActionResult Activities(ActivitiesViewModel model)
{
string UserName = HttpContext.Request.Cookies["UserName"] ?? ckUserName;
IRequestCookieCollection objCookies = HttpContext.Request.Cookies;
SalesQuoteLibrary salesLibrary = new SalesQuoteLibrary(_configuration);
PositionSetReq positionSetReq = new PositionSetReq();
bool isDuplicate = CheckDuplicateActivity(model);
if (isDuplicate)
{
TempData["error"] = "Can not save same Activity for same day and time!!!";
model.SaveType = "full";
//return PartialView("_Activities", model);
return(RedirectToAction("Activities", new { model.QRFID, model.SaveType, model.MenuViewModel.IsClone }));
}
else
{
positionSetReq = positionMapping.ActivitiesSet(model, ckUserEmailId);
positionSetReq.QRFID = model.QRFID;
positionSetReq.VoyagerUserID = ckLoginUser_Id;
positionSetReq.FOC = model.FOC;
positionSetReq.Price = model.Price;
PositionSetRes positionSetRes = positionProviders.SetPosition(positionSetReq, token).Result;
if (!string.IsNullOrEmpty(model.SaveType) && model.SaveType.ToLower() == "partial")
{
if (positionSetRes.mPosition.Count > 0)
{
return(Json(new { positionSetRes.ResponseStatus.Status, positionSetRes.mPosition[0].PositionId, positionSetRes.mPosition[0].RoomDetailsInfo }));
}
else
{
return(Json(new { positionSetRes.ResponseStatus.Status }));
}
}
else
{
if (positionSetRes.ResponseStatus.Status.ToLower() == "success")
{
TempData["success"] = "Activities saved successfully";
}
else
{
TempData["error"] = positionSetRes.ResponseStatus.Status;
}
model.SaveType = "full";
if (model.ActivityDetails.Count == 1)
{
return(RedirectToAction("Activities", new { model.QRFID, model.SaveType, PositionId = model.ActivityDetails[0].ActivityId, IsClone = model.MenuViewModel.IsClone }));
}
else
{
return(RedirectToAction("Activities", new { model.QRFID, model.SaveType, IsClone = model.MenuViewModel.IsClone }));
}
}
}
}
public ActionResult Create()
{
ActivitiesViewModel ac = new ActivitiesViewModel
{
Title = db.Titles.ToList()
};
return(View(ac));
}
public ActivitiesPage()
{
var activitiesStore = new SQLiteActivitiesStore(DependencyService.Get <ISQLiteDb>());
var pageService = new PageService();
ViewModel = new ActivitiesViewModel(activitiesStore, pageService);
InitializeComponent();
}
public ActivitiesPage()
{
InitializeComponent();
var instance = ActivitiesViewModel.GetInstance();
Appearing += (object sender, EventArgs e) =>
{
instance.RefreshCommand.Execute(this);
};
}
public Activities()
{
InitializeComponent();
NavigationPage.SetHasNavigationBar(this, false);
viewModel = new ActivitiesViewModel()
{
Navigation = this.Navigation
};
BindingContext = viewModel;
}
public ActivitiesPage()
{
InitializeComponent();
_viewModel = new ActivitiesViewModel();
_navManager = new ActivityNavigationManager(this, _viewModel);
BindingContext = _viewModel;
}
public IActionResult Activities()
{
ActivitiesViewModel model = new ActivitiesViewModel();
try
{
string QRFID = Request.Query["QRFId"].ToString();
string SaveType = Request.Query["SaveType"].ToString();
string PositionId = Request.Query["PositionId"];
bool IsClone = Convert.ToBoolean(Request.Query["IsClone"]);
model.QRFID = QRFID;
model.MenuViewModel.QRFID = QRFID;
model.MenuViewModel.PositionId = PositionId;
PositionGetReq positionGetReq = new PositionGetReq {
QRFID = QRFID
};
if (!string.IsNullOrEmpty(PositionId) && PositionId.Substring(0, 8) != "00000000")
{
positionGetReq.PositionId = PositionId;
}
positionGetReq.ProductType.Add(new ProductType {
ProdType = "Attractions"
});
positionGetReq.ProductType.Add(new ProductType {
ProdType = "Sightseeing - CityTour"
});
positionGetReq.IsClone = IsClone;
PositionGetRes positionGetRes = positionProviders.GetPosition(positionGetReq, token).Result;
positionMapping.ActivitiesGet(positionGetRes, null, ref model, token);
if (string.IsNullOrEmpty(PositionId))
{
if (!string.IsNullOrEmpty(SaveType) && SaveType.ToLower() == "full")
{
model.SaveType = "success";
return(PartialView("_Activities", model));
}
else
{
return(View(model));
}
}
else
{
return(PartialView("_Activities", model));
}
}
catch (Exception ex)
{
throw;
Console.WriteLine(ex.Message);
return(View(model));
}
}
public async Task <IActionResult> Create(ActivitiesViewModel vm)
{
if (ModelState.IsValid)
{
var result = await _services.CreateAsync(_mapper.Map <DirectoryDTO>(vm));
return(result.IsValid
? RedirectToAction("Index")
: _oops.OutPutError("Activities", "Index", result.ErrorsList));
}
return(View(vm));
}
public static int Add(ActivitiesViewModel model)
{
using (var db = new ShlekenEntities3())
{
var item = model.Map <ActivitiesViewModel, Activities>();
item.Date = DateTime.Now;
item.ProjectId = 1;
db.Activities.Add(item);
db.SaveChanges();
return(item.Id);
}
}
// GET: ListActivities
public IActionResult ListActivities()
{
var activitiesViewModel = new ActivitiesViewModel()
{
Activities = _context.Activity
.Include(a => a.ActivityStatus)
.Include(a => a.ActivityType)
.ToList()
};
return(View(activitiesViewModel));
}
public IActionResult Index()
{
if (!Authentication.AuthenticateByCookie(HttpContext))
{
return(Redirect("/Receptionists/Authentication/Login?are=Receptionists&ctrl=Activities&act=Index"));
}
BookingDAO.Update();
ActivitiesViewModel model = ActivitiesDAO.GetActivitiesViewModel();
return(View(model));
}
public override void Fill()
{
IsInProgress = true;
Header = "ActivitiesView_Fill_Header_Activities".TranslateInstructor();
viewModel = new ActivitiesViewModel(ParentWindow);
DataContext = viewModel;
var binding = new Binding("IsInProgress");
binding.Mode = BindingMode.OneWay;
SetBinding(IsInProgressProperty, binding);
viewModel.FillActivities();
}
public ActionResult Edit(int?ActivityId, int?PackageId)
{
if (ActivityId == null || PackageId == null)
{
return(RedirectToAction("Index", "Home"));
}
int activityId = ActivityId.GetValueOrDefault();
int packageId = PackageId.GetValueOrDefault();
ActivitiesViewModel model = new ActivitiesViewModel();
// Get name of package
Result <Package> packageResult = new Result <Package>();
packageResult = packageService.GetPackageById(packageId);
if (packageResult.Status == ResultEnum.Success &&
WebSecurity.CurrentUserId == packageResult.Data.ApplicationUserId &&
packageResult.Data.Status == PackageStatusEnum.Available)
{
model.PackageId = packageId;
model.PackageName = packageResult.Data.Name;
model.PackageCity = packageResult.Data.City;
model.PackageState = packageResult.Data.State;
}
else
{
return(RedirectToAction("Index", "Home"));
}
// Get activity details
Result <Activity> activityResult = new Result <Activity>();
activityResult = activityService.GetActivityById(activityId);
if (activityResult.Status == ResultEnum.Success && activityResult.Data.Status == PackageStatusEnum.Available)
{
model.ActivityName = activityResult.Data.Name;
model.Address = activityResult.Data.Address;
model.Description = activityResult.Data.Description;
model.ActivityId = activityResult.Data.ActivityId;
}
else
{
return(RedirectToAction("Index", "Home"));
}
return(View(model));
}
public async Task <IActionResult> UpdateConfirmed(ActivitiesViewModel vm)
{
if (ModelState.IsValid)
{
if (vm.HashId == null)
{
return(NotFound());
}
var result = await _services.UpdateAsync(_mapper.Map <DirectoryDTO>(vm));
return(result.IsValid
? RedirectToAction("Index")
: _oops.OutPutError("Activities", "Index", result.ErrorsList));
}
return(View(vm));
}
public ActionResult Edit(ActivitiesViewModel model)
{
if (ModelState.IsValid)
{
string successMessage = "Activity successfully edited.";
string errorMessage = "Unable to edit the activity.";
try
{
// Get co-ordianates of address
IGeolocationService geolocationService = UtilityFactory.GetGeolocationService();
Location location = geolocationService.GetCoordinates(
String.Format("{0}, {1}, {2}", model.Address, model.PackageCity, model.PackageState.ToString()));
Activity activity = new Activity()
{
ActivityId = model.ActivityId,
Name = model.ActivityName,
Description = model.Description,
Address = model.Address,
Status = PackageStatusEnum.Available,
PackageId = model.PackageId,
Latitude = location.Latitude,
Longitude = location.Longitude
};
ResultEnum result = activityService.UpdateActivity(activity);
if (result == ResultEnum.Success)
{
model.SuccessMessage = successMessage;
}
else
{
model.ErrorMessage = errorMessage;
}
return(View(model));
}
catch
{
model.ErrorMessage = errorMessage;
}
}
return(View(model));
}
public async Task <ActionResult> Activities()
{
var authenticator = CreateAuthenticator();
var model = new ActivitiesViewModel {
IsAuthenticated = authenticator.IsAuthenticated
};
if (!authenticator.IsAuthenticated)
{
return(View(model));
}
var client = new StravaSharp.Client(authenticator);
var activities = await client.Activities.GetAthleteActivities();
model.Activities = activities.Select(activity => new ActivityViewModel(activity)).ToList();
return(View(model));
}
public IActionResult ListActivitiesPO()
{
var activitiesViewModel = new ActivitiesViewModel()
{
Activities = _context.Activity
.Include(a => a.ActivityStatus)
.Include(a => a.Game)
.Include(a => a.Game.GameCategory)
.Include(a => a.Game.Arena)
.Include(a => a.Meeting)
.Include(a => a.Meeting.Location)
.Include(a => a.Person).Where(a => a.PersonId == 2 && a.ActivityStatusId == 1)
.ToList()
};
return(View(activitiesViewModel));
}
public IActionResult Create(ActivitiesViewModel model)
{
List <string> allErrors = new List <string>();
User CurrentUser = _context.Users.SingleOrDefault(person => person.UserId == (int)HttpContext.Session.GetInt32("CurrentUserId"));
System.Console.WriteLine("In Register***********************************************");
System.Console.WriteLine(model);
if (ModelState.IsValid)
{
Activity newActivity = new Activity {
Title = model.Title,
Time = model.Time,
Date = model.Date,
Duration = model.Duration,
Hours = model.Hours,
Description = model.Hours,
CreatedAt = DateTime.Now,
UpdatedAt = DateTime.Now,
UserId = CurrentUser.UserId,
};
if (model.Date < DateTime.Now)
{
return(RedirectToAction("planpage", "Home"));
}
System.Console.WriteLine(newActivity);
_context.Add(newActivity);
_context.SaveChanges();
// HttpContext.Session.SetInt32("CurrentUserId", newWedding.UserId); This is how to set Http Session currid to newwedding.userid...dont need this here
return(RedirectToAction("showpage", new { id = newActivity.ActivitiesId }));
}
System.Console.WriteLine("Not Good***********************************************");
ViewBag.Errors = ModelState.Values;
{
foreach (var error in ViewBag.Errors)
{
if (error.Errors.Count > 0)
{
System.Console.WriteLine(error.Errors[0].ErrorMessage);
}
}
}
System.Console.WriteLine("Hello____________________*********");
return(View("planpage"));
}
public static void Save(ActivitiesViewModel model)
{
using (var db = new ShlekenEntities3())
{
if (model.Id > 0)
{
var item = db.Activities.Single(i => i.Projects.AccountId == Userservice.AccountId && i.Id == model.Id);
item = model.Map <ActivitiesViewModel, Activities>(item);
db.SaveChanges();
}
else
{
var item = model.Map <ActivitiesViewModel, Activities>();
item.Date = DateTime.Now;
db.Activities.Add(item);
db.SaveChanges();
}
}
}
// GET: Activities
public async Task <IActionResult> Index(string searchClient, string searchUserName, string searchString)
{
var clientsQuery = from a in _context.Accounts
orderby a.Name
select a;
var usersQuery = from a in _userContext.Users
orderby a.UserName
select a;
var activitiesResults = _context.Activities.Include(t => t.Ticket).ThenInclude(t => t.Contract).ThenInclude(a => a.Account).OrderBy(d => d.Date).AsQueryable();
if (!string.IsNullOrEmpty(searchString))
{
activitiesResults = activitiesResults.Where(n => n.Details.Contains(searchString));
}
if (!string.IsNullOrEmpty(searchClient))
{
activitiesResults = activitiesResults.Where(c => c.Ticket.Contract.Account.Id.Equals(Convert.ToInt32(searchClient)));
}
if (!string.IsNullOrEmpty(searchUserName))
{
activitiesResults = activitiesResults.Where(u => u.UserId.Equals(searchUserName));
}
var activitiesViewModel = new ActivitiesViewModel
{
Accounts = new SelectList(await clientsQuery.Distinct().ToListAsync(), "Id", "Name"),
Users = new SelectList(await usersQuery.Distinct().ToListAsync(), "Id", "UserName"),
Activities = await activitiesResults.ToListAsync(),
};
return(View(activitiesViewModel));
}
private void MainMenuButtonPressed(MainMenuButton obj)
{
switch (obj)
{
case MainMenuButton.Unknown:
break;
case MainMenuButton.Members:
ContentArea = new MembersViewModel();
break;
case MainMenuButton.Activities:
ContentArea = new ActivitiesViewModel();
break;
case MainMenuButton.Finances:
DialogView dw = new DialogView(new DialogReferentViewModel <MemberCategory>("Šifrarnik: članstvo"));
dw.Owner = Application.Current.MainWindow;
dw.WindowStartupLocation = WindowStartupLocation.CenterOwner;
dw.ShowDialog();
break;
case MainMenuButton.Documents:
DialogView dw2 = new DialogView(new DialogReferentViewModel <MemberFunction>("Šifrarnik: funkcija"));
dw2.Owner = Application.Current.MainWindow;
dw2.WindowStartupLocation = WindowStartupLocation.CenterOwner;
dw2.ShowDialog();
break;
case MainMenuButton.Economat:
break;
case MainMenuButton.Home:
ContentArea = new HomeViewModel();
break;
default:
throw new ArgumentOutOfRangeException(nameof(obj), obj, null);
}
}
public IActionResult GetQuickPickActivities()
{
ActivitiesViewModel model = new ActivitiesViewModel();
try
{
string QRFID = Request.Query["QRFId"].ToString();
PositionGetReq positionGetReq = new PositionGetReq {
QRFID = QRFID
};
positionGetReq.ProductType.Add(new ProductType {
ProdType = "Attractions"
});
positionGetReq.ProductType.Add(new ProductType {
ProdType = "Sightseeing - CityTour"
});
PosQuicePickGetRes QuickPickGetRes = positionProviders.GetQuickPickActivities(positionGetReq, token).Result;
positionMapping.ActivitiesGet(null, QuickPickGetRes, ref model, token);
}
catch (Exception)
{ throw; }
return(PartialView("_ActivitiesQuickPickList", model));
}
public static ActivitiesViewModel GetActivitiesViewModel()
{
ActivitiesViewModel model = new ActivitiesViewModel();
model.ListCheckIn = new List <BookingModel>();
model.ListCheckOut = new List <BookingModel>();
model.ListConfirmCheckIn = new List <BookingModel>();
model.ListConfirmCheckOut = new List <BookingModel>();
//Empty Rooms Count
using (SqlConnection conn = Connection.GetConnection())
{
if (conn != null)
{
string sql = "SELECT COUNT(RoomID) FROM Room WHERE Status = 'Empty'";
SqlCommand cm = new SqlCommand(sql, conn);
var rs = cm.ExecuteReader();
if (rs.Read())
{
model.EmptyRoomsCount = rs[0] as int? ?? 0;
}
conn.Close();
}
}
//Occupied Rooms Count
using (SqlConnection conn = Connection.GetConnection())
{
if (conn != null)
{
string sql = "SELECT COUNT(RoomID) FROM Room WHERE Status = 'Occupited' or Status = 'Stayover' ";
SqlCommand cm = new SqlCommand(sql, conn);
var rs = cm.ExecuteReader();
if (rs.Read())
{
model.OccupiedRoomsCount = rs[0] as int? ?? 0;
}
conn.Close();
}
}
//List check-in bookings
using (SqlConnection conn = Connection.GetConnection())
{
if (conn != null)
{
BookingModel bk = null;
string sql = "SELECT BookingID FROM dbo.Booking WHERE YEAR(CheckInDate) <= YEAR(CURRENT_TIMESTAMP) and MONTH(CheckInDate) <= MONTH(CURRENT_TIMESTAMP) and DAY(CheckInDate) <= DAY(CURRENT_TIMESTAMP) and Status = 'Confirmed'";
SqlCommand cm = new SqlCommand(sql, conn);
var rs = cm.ExecuteReader();
if (rs.HasRows)
{
while (rs.Read())
{
bk = BookingDAO.GetBookingModel(rs[0] as int? ?? 0);
model.ListCheckIn.Add(bk);
}
}
conn.Close();
}
}
//List confirm check-in bookings
using (SqlConnection conn = Connection.GetConnection())
{
if (conn != null)
{
BookingModel bk = null;
string sql = "SELECT BookingID FROM dbo.Booking WHERE YEAR(CheckInDate) <= YEAR(CURRENT_TIMESTAMP) and MONTH(CheckInDate) <= MONTH(CURRENT_TIMESTAMP) and DAY(CheckInDate) <= DAY(CURRENT_TIMESTAMP) and Status = 'Checked-In'";
SqlCommand cm = new SqlCommand(sql, conn);
var rs = cm.ExecuteReader();
if (rs.HasRows)
{
while (rs.Read())
{
bk = BookingDAO.GetBookingModel(rs[0] as int? ?? 0);
model.ListConfirmCheckIn.Add(bk);
}
}
conn.Close();
}
}
//List check-out bookings
using (SqlConnection conn = Connection.GetConnection())
{
if (conn != null)
{
BookingModel bk = null;
string sql = "SELECT BookingID FROM dbo.Booking WHERE YEAR(CheckOutDate) <= YEAR(CURRENT_TIMESTAMP) and MONTH(CheckOutDate) <= MONTH(CURRENT_TIMESTAMP) and DAY(CheckOutDate) <= DAY(CURRENT_TIMESTAMP) and Status IN ('Checked-In','Stayover')";
SqlCommand cm = new SqlCommand(sql, conn);
var rs = cm.ExecuteReader();
if (rs.HasRows)
{
while (rs.Read())
{
bk = BookingDAO.GetBookingModel(rs[0] as int? ?? 0);
model.ListCheckOut.Add(bk);
}
}
conn.Close();
}
}
//List confirm check-out bookings
using (SqlConnection conn = Connection.GetConnection())
{
if (conn != null)
{
BookingModel bk = null;
string sql = "SELECT BookingID FROM dbo.Booking WHERE YEAR(CheckOutDate) >= YEAR(CURRENT_TIMESTAMP) and MONTH(CheckOutDate) >= MONTH(CURRENT_TIMESTAMP) and DAY(CheckOutDate) >= DAY(CURRENT_TIMESTAMP) and Status ='Checked-Out'";
SqlCommand cm = new SqlCommand(sql, conn);
var rs = cm.ExecuteReader();
if (rs.HasRows)
{
while (rs.Read())
{
bk = BookingDAO.GetBookingModel(rs[0] as int? ?? 0);
model.ListConfirmCheckOut.Add(bk);
}
}
conn.Close();
}
}
return(model);
}
//
// GET: /Entry/
public ActionResult Index()
{
ActivitiesViewModel actv = new ActivitiesViewModel();
actv.PositionID = 2;
return View(actv);
}
