public ActionResult AddOwnerBookingRequest()
{
StrataOwnerBookingRequestModel model = new StrataOwnerBookingRequestModel();
model.CommonAreas = new SelectList(strataOwnerHelper.GetAllCommonAreas(), "CommonAreaId", "CommonAreaName");
return(PartialView("AddOwnerBookingRequest", model));
}
/// <summary>
/// Add the common area bookings
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public JsonResult AddCommonAreaBooking(StrataOwnerBookingRequestModel model)
{
string strMsg = "NotOk";
int val = -1;
if (model.CommonAreaId == 0)
{
strMsg = "Common area required.";
}
else
{
StrataOwnerHelper strataOwnerHelper = new StrataOwnerHelper();
model.Status = "1";
int result = strataOwnerHelper.AddStrataOwnerBookingRequest(model);
if (result == 1)
{
val = 0;
strMsg = "Booking request has been created successfully.";
}
else if (result == -1)
{
strMsg = "Booking request already exists to this User for given dates.";
}
else
{
strMsg = "Booking request creation failed.";
}
}
return(Json(new { Msg = strMsg, Result = val }, JsonRequestBehavior.AllowGet));
}
public List <StrataOwnerBookingRequestModel> GetStrataOwnerBookingRequest(int BlockNumber, int BlockSize, bool bIsDashBoard = false)
{
if (ClientSessionData.UserClientId != 0)
{
int startIndex = (BlockNumber - 1) * BlockSize;
List <StrataOwnerBookingRequestModel> strataOwnerBookingRequestModelList = new List <StrataOwnerBookingRequestModel>();
try
{
var userBookingRequests = _context.vw_GetOwnerBookingRequest.Where(x => x.StratasBoardId == ClientSessionData.ClientStrataBoardId).OrderByDescending(x => x.CreatedOn).ToList();
if (bIsDashBoard)
{
userBookingRequests = _context.vw_GetOwnerBookingRequest.Where(x => x.StratasBoardId == ClientSessionData.ClientStrataBoardId && x.AdminStatus != 0).OrderByDescending(x => x.CreatedOn).ToList();
}
//var userBookingRequests = (from t1 in _context.tblUserBookingRequests
// join t2 in _context.tblCommonAreas on t1.CommonAreaId equals t2.CommonAreaId
// where t1.StratasBoardId == ClientSessionData.ClientStrataBoardId && t2.Status == 1 orderby t1.CreatedOn descending
// select new { t1.BookingRequestId, t1.UserClientId, t1.CommonAreaId, t1.Subject, t1.FromDate, t1.ToDate, t1.Reason, t1.Status, t1.CreatedOn, t1.AdminStatus, t2.CommonAreaName }).ToList();
foreach (var item in userBookingRequests)
{
StrataOwnerBookingRequestModel strataOwnerBookingRequestModel = new StrataOwnerBookingRequestModel();
strataOwnerBookingRequestModel.BookingRequestId = item.BookingRequestId;
strataOwnerBookingRequestModel.UserClientId = item.UserClientId;
strataOwnerBookingRequestModel.CommonAreaId = item.CommonAreaId.Value;
strataOwnerBookingRequestModel.AdminStatus = item.AdminStatus == 2 ? "Rejected" : item.AdminStatus == 1 ? "Approved" : "Pending";
string StartTime = item.FromDate.Value.ToString("hh:mm tt");
strataOwnerBookingRequestModel.FromDate = item.FromDate != null?item.FromDate.Value.ToString("dd MMM yyyy") + ", " + StartTime : "";
string ToDate = item.FromDate.Value.ToString("hh:mm tt");
strataOwnerBookingRequestModel.ToDate = item.ToDate != null?item.ToDate.Value.ToString("dd MMM yyyy") + ", " + StartTime : "";
strataOwnerBookingRequestModel.CreatedOn = item.CreatedOn != null?item.CreatedOn.Value.ToString("dd MMM yyyy") : "";
strataOwnerBookingRequestModel.Subject = item.Subject;
strataOwnerBookingRequestModel.Reason = item.Reason;
strataOwnerBookingRequestModel.CommonAreaName = item.CommonAreaName;
if (item.FromDate != null && item.ToDate != null)
{
strataOwnerBookingRequestModel.TotalDays = Convert.ToInt32((item.ToDate.Value - item.FromDate.Value).TotalDays);
}
else
{
strataOwnerBookingRequestModel.TotalDays = 0;
}
strataOwnerBookingRequestModelList.Add(strataOwnerBookingRequestModel);
}
}
catch
{
}
strataOwnerBookingRequestModelList = strataOwnerBookingRequestModelList.Skip(startIndex).Take(BlockSize).ToList();
return(strataOwnerBookingRequestModelList);
}
else
{
return(null);
}
}
public int AddStrataOwnerBookingRequest(StrataOwnerBookingRequestModel strataOwnerBookingRequestModel)
{
int result = 0;
try
{
tblUserBookingRequest tblUserBookingRequestDb = new tblUserBookingRequest();
tblUserBookingRequestDb.UserClientId = ClientSessionData.UserClientId;
tblUserBookingRequestDb.Subject = strataOwnerBookingRequestModel.Subject;
tblUserBookingRequestDb.FromDate = !string.IsNullOrEmpty(strataOwnerBookingRequestModel.FromDate) ? Convert.ToDateTime(strataOwnerBookingRequestModel.FromDate) : (DateTime?)null;
tblUserBookingRequestDb.ToDate = !string.IsNullOrEmpty(strataOwnerBookingRequestModel.ToDate) ? Convert.ToDateTime(strataOwnerBookingRequestModel.ToDate) : (DateTime?)null;
tblUserBookingRequestDb.Reason = strataOwnerBookingRequestModel.Reason;
tblUserBookingRequestDb.Status = int.Parse(strataOwnerBookingRequestModel.Status);
tblUserBookingRequestDb.AdminStatus = 1;
tblUserBookingRequestDb.CommonAreaId = strataOwnerBookingRequestModel.CommonAreaId;
tblUserBookingRequestDb.CreatedOn = DateTime.UtcNow;
tblUserBookingRequestDb.ModifiedOn = DateTime.UtcNow;
tblUserBookingRequestDb.StratasBoardId = ClientSessionData.ClientStrataBoardId;
var UserRequests = _context.tblUserBookingRequests.Where(x => x.UserClientId == ClientSessionData.UserClientId && x.CommonAreaId == strataOwnerBookingRequestModel.CommonAreaId && x.Status != 2).FirstOrDefault();
if (UserRequests != null)
{
if (UserRequests.FromDate > Convert.ToDateTime(strataOwnerBookingRequestModel.ToDate) || UserRequests.ToDate < Convert.ToDateTime(strataOwnerBookingRequestModel.FromDate))
{
_context.tblUserBookingRequests.Add(tblUserBookingRequestDb);
result = _context.SaveChanges();
}
else
{
result = -1;
}
}
else
{
_context.tblUserBookingRequests.Add(tblUserBookingRequestDb);
result = _context.SaveChanges();
}
}
catch
{
}
return(result);
}
public ActionResult AddOwnerBookingRequest(StrataOwnerBookingRequestModel model)
{
int result = 0;
string strMsg = "";
if (ModelState.IsValid)
{
result = strataOwnerHelper.AddStrataOwnerBookingRequest(model);
if (result == -1)
{
strMsg = "Booking Request already exists to this User for given dates";
}
else if (result == 1)
{
strMsg = "Booking Request has been created successfully.";
}
else
{
strMsg = "Booking Request creation failed.";
}
}
return(Json(new { result = result, Msg = strMsg }));
}
