public bool Post([FromBody] CommonDeleteModel CommonModel)
{
try
{
var UserID = (from user in _DatabaseContext.UserMasterTB
where user.Username == CommonModel.Username
select user.U_Id).SingleOrDefault();
var itemToRemove = (from booking in _DatabaseContext.BookingTB
where booking.UserID == UserID && booking.BookingID == CommonModel.id
select booking).SingleOrDefault();
var BookingTB = new BookingTB {
BookingID = CommonModel.id, PaymentStatus = "C"
};
if (itemToRemove != null)
{
_DatabaseContext.BookingTB.Remove(itemToRemove);
_DatabaseContext.SaveChanges();
return(true);
}
return(false);
}
catch (Exception)
{
throw;
}
}
public bool Post([FromBody]PaymentTB paymenttb)
{
try
{
if (paymenttb == null)
{
return false;
}
var UserID = (from user in _DatabaseContext.UserMasterTB
where user.Username == paymenttb.Username
select user.U_Id).SingleOrDefault();
var output = (from pay in _DatabaseContext.PaymentTB
where pay.C_ID == pay.C_ID && pay.UserID == UserID && pay.BookingID == paymenttb.BookingID
select pay.P_Id).Count();
if (output > 0)
{
return false;
}
else
{
try
{
var payAmount = (from booking in _DatabaseContext.BookingTB
where booking.UserID == UserID && booking.BookingID == paymenttb.BookingID
select booking.Amount).SingleOrDefault();
paymenttb.P_Id = 0;
paymenttb.UserID = UserID;
paymenttb.Amount = payAmount;
paymenttb.BookingID = paymenttb.BookingID;
paymenttb.CreatedOn = DateTime.Now;
paymenttb.PaymentDate = DateTime.Now;
_DatabaseContext.Add(paymenttb);
_DatabaseContext.SaveChanges();
var bookingtb = new BookingTB { BookingID = paymenttb.BookingID, PaymentStatus = "D" };
var db = _DatabaseContext;
db.BookingTB.Attach(bookingtb);
db.Entry(bookingtb).Property(x => x.PaymentStatus).IsModified = true;
db.SaveChanges();
return true;
}
catch (Exception)
{
throw;
}
}
}
catch (Exception)
{
throw;
}
}
public bool Post([FromBody] CommonDeleteModel CommonModel)
{
try
{
var itemToRemove = _DatabaseContext.BookingTB.SingleOrDefault(x => x.BookingID == CommonModel.id);
var BookingTB = new BookingTB {
BookingID = CommonModel.id, PaymentStatus = "C"
};
if (itemToRemove != null)
{
_DatabaseContext.BookingTB.Remove(itemToRemove);
_DatabaseContext.SaveChanges();
return(true);
}
return(false);
}
catch (Exception)
{
throw;
}
}
public BookingResponse Post([FromBody] BookingTB bookingtb)
{
try
{
var days = Math.Round((bookingtb.ToDate - bookingtb.FromDate).TotalDays);
var hours = (bookingtb.ToDate - bookingtb.FromDate).Hours;
var currenttime = DateTime.Now;
var booktime = Convert.ToDateTime(bookingtb.FromDate);
var bookingAmount = 0;
if (booktime > currenttime)
{
}
else
{
return(new BookingResponse {
data = "Invalidbooktime"
});
}
if (days < 0 && hours < 1)
{
return(new BookingResponse {
data = "InvalidTime"
});
}
else
{
var IsalreadyBooked = (from book in _DatabaseContext.BookingTB
where Convert.ToDateTime(book.ToDate) >= Convert.ToDateTime(bookingtb.FromDate) &&
Convert.ToDateTime(book.ToDate) <= Convert.ToDateTime(bookingtb.ToDate) &&
book.C_Id == bookingtb.C_Id
select book.BookingID).Count();
if (IsalreadyBooked > 0)
{
return(new BookingResponse {
data = "AlreadyBooked"
});
}
else
{
if (days < 0)
{
bookingAmount = CalculateCost(bookingtb.C_Id, days, hours);
}
else
{
bookingAmount = CalculateCost(bookingtb.C_Id, days, hours);
}
var UserID = (from user in _DatabaseContext.UserMasterTB
where user.Username == bookingtb.Username
select user.U_Id).SingleOrDefault();
bookingtb.BookingID = 0;
bookingtb.Amount = bookingAmount;
bookingtb.UserID = UserID;
bookingtb.PaymentStatus = "P";
bookingtb.CreatedOn = DateTime.Now;
_DatabaseContext.Add(bookingtb);
_DatabaseContext.SaveChanges();
return(new BookingResponse {
data = Convert.ToString(bookingtb.BookingID)
});
}
}
}
catch (Exception)
{
throw;
}
}
