public void create(Booked acc)
{
SqlConnection con = null;
con = Connector.getConnection();
con.Open();
try
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = CREATE;
cmd.Parameters.Add("@cus", SqlDbType.Int).Value = acc.customer;
cmd.Parameters.Add("@staff", SqlDbType.Int).Value = acc.staff;
cmd.Parameters.Add("@course", SqlDbType.Int).Value = acc.course;
cmd.Parameters.Add("@day", SqlDbType.DateTime).Value = acc.startDay;
cmd.Parameters.Add("@paid", SqlDbType.Bit).Value = acc.paid;
int rowCount = cmd.ExecuteNonQuery();
Console.WriteLine("Row Count affected = " + rowCount);
}
catch (Exception e)
{
Console.WriteLine("khong the ket noi");
Console.WriteLine(e.StackTrace);
}
finally
{
con.Close();
con.Dispose();
con = null;
}
}
private void dataGridViewBooked_RowHeaderMouseClick(object sender, DataGridViewCellMouseEventArgs e)
{
int selectedRowCount = dataGridViewBooked.Rows.GetRowCount(DataGridViewElementStates.Selected);
if (selectedRowCount == 1)
{
int bookedId = Convert.ToInt32(dataGridViewBooked.SelectedRows[0].Cells[0].Value.ToString());
Booked booked = _bookedRepository.GetBookedById(bookedId);
User user = _userRepository.GetUserById(booked.UserId);
lstBBookedAllInfo.Items.Clear();
lstBBookedAllInfo.Items.Add(String.Format("Booked Id: {0}", booked.Id));
lstBBookedAllInfo.Items.Add(String.Format("Member Id: {0}", booked.MemberId));
lstBBookedAllInfo.Items.Add(String.Format("Book Id: {0}", booked.BookId));
lstBBookedAllInfo.Items.Add(String.Format("Date Booked Id: {0}", booked.dateBooked));
lstBBookedAllInfo.Items.Add(String.Format("Due Date: {0}", booked.dueBooked));
lstBBookedAllInfo.Items.Add(String.Format("Fine: {0}", booked.fine));
lstBBookedAllInfo.Items.Add(String.Format("Booked Status: {0}", booked.StatusId));
lstBBookedAllInfo.Items.Add("Booked creator:");
lstBBookedAllInfo.Items.Add(String.Format("Name: {0}", user.FirstName));
lstBBookedAllInfo.Items.Add(String.Format("Surname: {0}", user.SecondName));
lstBBookedAllInfo.Items.Add(String.Format("Id: {0}", user.Id));
lstBBookedAllInfo.Items.Add(String.Format("Disabled: {0}", user.IsDisabled));
}
}
public void delete(Booked acc)
{
SqlConnection con = null;
con = Connector.getConnection();
con.Open();
try
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = DELETE;
cmd.Parameters.Add("@id", SqlDbType.Int).Value = acc.id;
int rowCount = cmd.ExecuteNonQuery();
Console.WriteLine("Row Count affected = " + rowCount);
}
catch (Exception e)
{
Console.WriteLine("khong the ket noi");
Console.WriteLine(e.StackTrace);
}
finally
{
con.Close();
con.Dispose();
con = null;
}
}
public void SetBookedFine(Booked booked)
{
using (SqlConnection connection = new SqlConnection(_connectionString))
{
connection.Open();
try
{
using (TransactionScope tran1 = new TransactionScope())
{
using (SqlCommand command = new SqlCommand())
{
command.Connection = connection;
command.CommandType = CommandType.StoredProcedure;
command.CommandText = spSetBookedFine;
command.Parameters.Clear();
command.Parameters.AddWithValue("@BookedId", booked.Id);
command.Parameters.AddWithValue("@StatusId", booked.StatusId); //1 means active booked, 0 means book was returned
command.Parameters.AddWithValue("@Fine", booked.fine);
command.ExecuteNonQuery();
}
tran1.Complete();
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
}
public async Task <IActionResult> Edit(int id, [Bind("ID,MemberID,LabID,EquipmentID,Approved,Date")] Booked booked)
{
if (id != booked.ID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(booked);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!BookedExists(booked.ID))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["EquipmentID"] = new SelectList(_context.Equipment, "EquipmentID", "ImageURL", booked.EquipmentID);
ViewData["LabID"] = new SelectList(_context.Lab, "LabID", "Building", booked.LabID);
return(View(booked));
}
//Checking Out
public async Task <PaymentResult> CheckoutAsync(CheckOutViewModel model)
{
var booked = new Booked()
{
Name = model.Name,
Email = model.Email,
Mobile = model.Mobile,
Address = model.Address,
Persons = model.Persons
};
//To Authorize paymment
var gateway = new PaymentGateway();
var result = gateway.ProcessPayment(model);
if (result.Succeeded)
{
booked.TransactionId = result.TransactionId;
_db.Books.Add(booked);
await _db.SaveChangesAsync();
}
return(result);
}
public List <Booked> getBookingInfo(int c_id)
{
SqlConnection con = new SqlConnection(@"Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=HotelService;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=True;ApplicationIntent=ReadWrite;MultiSubnetFailover=False");
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.Parameters.AddWithValue("@id", c_id);
cmd.CommandText = "Select B_Id,R_No,Checkin_Date,Checkout_Date,Tot_Amount,Tot_Days from Booked where C_Id = @id";
con.Open();
SqlDataReader sr = cmd.ExecuteReader();
List <Booked> l = new List <Booked>();
while (sr.Read())
{
Booked b = new Booked();
b.BID = sr.GetInt32(0);
b.CID = c_id;
b.RoomNos = sr.GetInt32(1);
b.CheckInDate = sr.GetString(2);
b.CheckOutDate = sr.GetString(3);
b.TotalAmount = sr.GetInt32(4);
b.TotalDays = sr.GetInt32(5);
l.Add(b);
}
sr.Close();
con.Close();
return(l);
}
public void should_remove_slot_from_the_list_if_was_booked()
{
var scheduled = new Scheduled(Guid.NewGuid().ToString(), _now, _tenMinutes);
var booked = new Booked(scheduled.SlotId, "patient-123");
Given(scheduled, booked);
Then(new List <AvailableSlot>(), _repository.GetSlotsAvailableOn(_now.Date));
}
public bool UpdateProcess(Booked entity, string userLogin)
{
using (var connection = GetConnection())
{
return(connection.Query(@"
exec sp_UpdateBooked @Id=@Id,@ProcessStatus = @ProcessStatus,@UserName =@UserName,@UserType = @UserType
".AddParametersDefaul(), new { entity, userLogin }).Any());
}
}
public async Task <ActionResult> DeleteConfirmed(Guid id)
{
Booked booked = await _context.Bookeds.FindAsync(id);
_context.Bookeds.Remove(booked);
await _context.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public async Task cant_be_cancelled_after_start_time()
{
var scheduled = new Scheduled(_slotId, _now.Subtract(TimeSpan.FromHours(1)), _tenMinutes);
var booked = new Booked(_slotId, "patient name");
Given(scheduled, booked);
await When(new Cancel(_slotId, "Reason", DateTime.UtcNow));
Then <SlotAlreadyStartedException>();
}
public bool Update(Booked entity, string userLogin)
{
using (var connection = GetConnection())
{
return(connection.Query(@"
exec sp_UpdateBooked @Id=@Id,@OrdererName = @OrdererName,@OrdererPhone = @OrdererPhone,@ReceiverName = @ReceiverName,@ReceiverAddress = @ReceiverAddress
,@ReceiverPhone = @ReceiverPhone,@ReceiverEmail = @ReceiverEmail,@Note = @Note,@ReceiveLocation = @ReceiveLocation,@StartDTS = @StartDTS
,@EndDTS = @EndDTS,@Quantity = @Quantity,@ActiveStatus = @ActiveStatus,@UserName =@UserName,@UserType =@UserType
".AddParametersDefaul(), new { entity, userLogin }).Any());
}
}
public async Task <ActionResult> Edit([Bind(Include = "Id,DateStart,DateStop,GuestHouse_Id")] Booked booked)
{
if (ModelState.IsValid)
{
_context.Entry(booked).State = EntityState.Modified;
await _context.SaveChangesAsync();
return(RedirectToAction("Index"));
}
ViewBag.GuestHouse_Id = new SelectList(_context.GuestHouses, "Id", "Name", booked.GuestHouse_Id);
return(View(booked));
}
public ActionResult <BookedModel> Update(int bookedId, [FromBody] BookedModel updatedBookedModel)
{
Booked updatedBooked = bookedRepository.Update(bookedId, new Booked
{
DateStart = updatedBookedModel.DateStart,
DateEnd = updatedBookedModel.DateEnd,
AdvertId = updatedBookedModel.AdvertId,
UserId = updatedBookedModel.UserId,
});
return(new BookedModel(updatedBooked));
}
private void btnSetFineBooked_Click(object sender, EventArgs e)
{
int selectedRowCount = dataGridViewBooked.Rows.GetRowCount(DataGridViewElementStates.Selected);
if (selectedRowCount == 1)
{
int bookedId = Convert.ToInt32(dataGridViewBooked.SelectedRows[0].Cells[0].Value.ToString());
Booked booked = _bookedRepository.GetBookedById(bookedId);
SetFineForm frmSetFine = new SetFineForm(booked);
frmSetFine.Show();
}
}
public ActionResult <BookedModel> Create([FromBody] BookedModel bookedModel)
{
Booked createdBooked = bookedRepository.Insert(new Booked
{
DateStart = bookedModel.DateStart,
DateEnd = bookedModel.DateEnd,
AdvertId = bookedModel.AdvertId,
UserId = bookedModel.UserId,
});
return(new BookedModel(createdBooked));
}
public async Task <IActionResult> Create([Bind("ID,MemberID,LabID,EquipmentID,Approved,Date")] Booked booked)
{
if (ModelState.IsValid)
{
_context.Add(booked);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["EquipmentID"] = new SelectList(_context.Equipment, "EquipmentID", "ImageURL", booked.EquipmentID);
ViewData["LabID"] = new SelectList(_context.Lab, "LabID", "Building", booked.LabID);
return(View(booked));
}
[Fact] //empty
public void should_return_a_slot_if_was_booked()
{
var scheduled = new Scheduled(Guid.NewGuid().ToString(), _now, _tenMinutes);
var booked = new Booked(scheduled.SlotId, _patientId);
Given(scheduled, booked);
Then(
new List <PatientSlot> {
new PatientSlot(scheduled.SlotId, scheduled.StartTime, scheduled.Duration)
},
_repository.GetPatientSlots(_patientId)
);
}
// GET: Booked/Delete/5
public async Task <ActionResult> Delete(Guid?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Booked booked = await _context.Bookeds.FindAsync(id);
if (booked == null)
{
return(HttpNotFound());
}
return(View(booked));
}
public void should_add_slot_again_if_booking_was_cancelled()
{
var scheduled = new Scheduled(Guid.NewGuid().ToString(), _now, _tenMinutes);
var booked = new Booked(scheduled.SlotId, "patient-123");
var cancelled = new Cancelled(scheduled.SlotId, "No longer needed");
Given(scheduled, booked, cancelled);
Then(
new List <AvailableSlot> {
new AvailableSlot(scheduled.SlotId, scheduled.StartTime, scheduled.Duration)
},
_repository.GetSlotsAvailableOn(_now.Date)
);
}
// GET: Booked/Details/5
public async Task <ActionResult> Details(Guid?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Booked booked = await _context.Bookeds.Include(c => c.GuestHouse).SingleOrDefaultAsync(c => c.Id == id.Value);
if (booked == null)
{
return(HttpNotFound());
}
return(View(booked));
}
public bool RemoveById(int bookedId)
{
Booked booked = GetById(bookedId);
if (booked == null)
{
throw new ArgumentNullException(nameof(booked));
}
Entities.Remove(booked);
SaveChanges();
return(true);
}
private void btnCancelBooked_Click(object sender, EventArgs e)
{
var confirmResult = MessageBox.Show("Are you sure to delete this item ??", "Confirm Delete!!", MessageBoxButtons.YesNo);
if (confirmResult == DialogResult.Yes)
{
int selectedRowCount = dataGridViewBooked.Rows.GetRowCount(DataGridViewElementStates.Selected);
if (selectedRowCount == 1)
{
int bookedId = Convert.ToInt32(dataGridViewBooked.SelectedRows[0].Cells[0].Value.ToString());
Booked booked = _bookedRepository.GetBookedById(bookedId);
_bookedRepository.DeleteBooked(booked);
}
}
}
// GET: Booked/Edit/5
public async Task <ActionResult> Edit(Guid?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Booked booked = await _context.Bookeds.FindAsync(id);
if (booked == null)
{
return(HttpNotFound());
}
ViewBag.GuestHouse_Id = new SelectList(_context.GuestHouses, "Id", "Name", booked.GuestHouse_Id);
return(View(booked));
}
public Booked Insert(Booked newBooked)
{
if (newBooked == null)
{
throw new ArgumentNullException(nameof(newBooked));
}
Entities.Add(newBooked);
SaveChanges();
return(Entities.Include(i => i.User)
.Include(i => i.Advert)
.FirstOrDefault(f => f.Id == newBooked.Id));
}
public ActionResult Create(Guid?id)
{
var c = _context.GuestHouses.SingleOrDefault(p => p.Id == id);
var book = new Booked
{
DateStart = DateTime.Now,
DateStop = DateTime.Now.AddDays(2),
// Content = "Nowa Rezerwacja",
GuestHouse_Id = c.Id,
//CreatedBy = c.CreatedBy,
BookedBy = _context.Users.SingleOrDefault(u => u.UserName == User.Identity.Name)
};
//ViewBag.GuestHouse_Id = new SelectList(_context.GuestHouses, "Id", "Name");
return(View(book));
}
public void AddBooked(Booked bookedToAdd)
{
using (SqlConnection connection = new SqlConnection(_connectionString))
{
connection.Open();
try
{
using (TransactionScope tran1 = new TransactionScope())
{
using (SqlCommand command = new SqlCommand())
{
command.Connection = connection;
command.CommandType = CommandType.StoredProcedure;
command.CommandText = spAddBooked;
command.Parameters.Clear();
command.Parameters.AddWithValue("@MemberId", bookedToAdd.MemberId);
command.Parameters.AddWithValue("@BookId", bookedToAdd.BookId);
command.Parameters.AddWithValue("@DateBooked", bookedToAdd.dateBooked);
command.Parameters.AddWithValue("@DueDate", bookedToAdd.dueBooked);
command.Parameters.AddWithValue("@StatusId", 1); //1 means active booked, 0 means book was returned
command.Parameters.AddWithValue("@FineAmount", 0);
command.Parameters.AddWithValue("@UserId", bookedToAdd.UserId);
SqlParameter BookedIdOut = new SqlParameter();
BookedIdOut.ParameterName = "@BookedIdOut";
BookedIdOut.DbType = DbType.Int32;
BookedIdOut.Direction = ParameterDirection.Output;
command.Parameters.Add(BookedIdOut);
command.ExecuteNonQuery();
}
tran1.Complete();
}
}
catch (Exception ex)
{
// IP: exception is raised when trying to submit "Add book form" with default dates
throw new Exception(ex.Message);
}
}
}
public SetFineForm(Booked booked)
{
// IP: Можливо було б доцільним винести IMemberRepository _memberRepository та IBookRepository _bookRepository з конкретних класів форм у спільний предок
_bookedRepository = new SqlBookedRepository(ConfigurationManager.ConnectionStrings["dbLibrary"].ConnectionString);
_booked = booked;
InitializeComponent();
txtDateBooked.Text = _booked.dateBooked.ToString();
txtDueDateBooked.Text = _booked.dueBooked.ToString();
if (DateTime.Now > _booked.dueBooked)
{
txtDaysOverBooked.Text = (DateTime.Now - _booked.dueBooked).TotalDays.ToString();
}
else
{
txtDaysOverBooked.Text = "0";
}
}
public Booked GetBookedById(int Id)
{
if (Id == 0)
{
throw new Exception("No information about id");
}
else
{
string bookedQuery = String.Format("SELECT [BookedId], [MemberId], [BookId], [DateBooked], [DueDate], [StatusId], [FineAmount], [UserId] FROM [dbo].[tblBooked] WHERE BookedId = {0} AND StatusId = 1", Id);
Booked booked = new Booked();
using (SqlConnection connection = new SqlConnection(_connectionString))
{
connection.Open();
using (SqlCommand command = new SqlCommand())
{
command.Connection = connection;
command.CommandType = CommandType.Text;
command.CommandText = bookedQuery;
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
booked.Id = (int)reader["BookedId"];
booked.MemberId = (int)reader["MemberId"];
booked.BookId = (int)reader["BookId"];
booked.dateBooked = (DateTime)reader["DateBooked"];
booked.dueBooked = (DateTime)reader["DueDate"];
booked.fine = (decimal)reader["FineAmount"];
booked.StatusId = (int)reader["StatusId"];
booked.UserId = (int)reader["UserId"];
}
}
}
return(booked);
}
}
}
public BookedModel(Booked bookedEntity)
{
Id = bookedEntity.Id;
DateStart = bookedEntity.DateStart;
DateEnd = bookedEntity.DateEnd;
UserId = bookedEntity.UserId;
AdvertId = bookedEntity.AdvertId;
if (bookedEntity.User != null)
{
User = new UserModel(bookedEntity.User);
}
if (bookedEntity.Advert != null)
{
Advert = new AdvertModel(bookedEntity.Advert);
}
}
