static void Main(string[] args)
{
var(name, _, address) = Discard("Vadim", 24, "Viena");
HistoryBook h1 = new HistoryBook();
Book b1 = h1;
Book b2 = new HistoryBook();
h1 = (HistoryBook)b2;
Book b3 = new Book();
HistoryBook h2 = b3 as HistoryBook;
var b = name ?? "Default";
Console.WriteLine(b);
dynamic dynamicVariable = 100;
Console.WriteLine("Dynamic variable value: {0}, Type: {1}", dynamicVariable, dynamicVariable.GetType().ToString());
dynamicVariable = "Hello World!!";
Console.WriteLine("Dynamic variable value: {0}, Type: {1}", dynamicVariable, dynamicVariable.GetType().ToString());
dynamicVariable = true;
Console.WriteLine("Dynamic variable value: {0}, Type: {1}", dynamicVariable, dynamicVariable.GetType().ToString());
dynamicVariable = DateTime.Now;
Console.WriteLine("Dynamic variable value: {0}, Type: {1}", dynamicVariable, dynamicVariable.GetType().ToString());
Console.ReadKey();
}
//them
public static List <HistoryBook> GetHistoryBooksByRoomNameStatus(string roomName, int bedNo)
{
List <HistoryBook> historyBooks = new List <HistoryBook>();
SqlConnection conn = DAO.getConnections();
string sql = "select * from HistoryBook where status=1 AND roomName = '" + roomName + "' AND bedNo = " + bedNo;
SqlCommand cmd = new SqlCommand(sql);
cmd.Connection = conn;
conn.Open();
SqlDataReader da = cmd.ExecuteReader();
while (da.Read())
{
string stuID1 = da.GetValue(0).ToString();
DateTime dateBook = DateTime.Parse(da.GetValue(1).ToString());
string roomName1 = da.GetValue(2).ToString();
int bedNo1 = int.Parse(da.GetValue(3).ToString());
int bookID = int.Parse(da.GetValue(4).ToString());
int status = int.Parse(da.GetValue(5).ToString());
DateTime dateExpiry = DateTime.Parse(da.GetValue(6).ToString());
HistoryBook historyBook = new HistoryBook(stuID1, dateBook, roomName1, bedNo1, bookID, status, dateExpiry);
historyBooks.Add(historyBook);
}
conn.Close();
return(historyBooks);
}
//them
public static HistoryBook GetHistoryBooksByBookID(int bookID)
{
List <HistoryBook> historyBooks = new List <HistoryBook>();
SqlConnection conn = DAO.getConnections();
string sql = "select * from HistoryBook where bookID = " + bookID;
SqlCommand cmd = new SqlCommand(sql);
cmd.Connection = conn;
conn.Open();
SqlDataReader da = cmd.ExecuteReader();
while (da.Read())
{
string stuID1 = da.GetValue(0).ToString();
DateTime dateBook = DateTime.Parse(da.GetValue(1).ToString());
string roomName = da.GetValue(2).ToString();
int bedNo = int.Parse(da.GetValue(3).ToString());
int bookID1 = int.Parse(da.GetValue(4).ToString());
int status = int.Parse(da.GetValue(5).ToString());
DateTime dateExpiry = DateTime.Parse(da.GetValue(6).ToString());
HistoryBook historyBook = new HistoryBook(stuID1, dateBook, roomName, bedNo, bookID1, status, dateExpiry);
return(historyBook);
}
conn.Close();
return(null);
}
public static bool Delete(HistoryBook hb)
{
string sql = "delete HistoryBook where bookID = @bookID";
SqlCommand cmd = new SqlCommand(sql);
cmd.Parameters.AddWithValue("@bookID", hb.BookID);
return(DAO.UpdateTable(cmd));
}
public ActionResult DeleteConfirmed(int id)
{
HistoryBook historyBook = db.HistoryBook.Find(id);
db.HistoryBook.Remove(historyBook);
db.SaveChanges();
return(RedirectToAction("Index"));
}
private void btpAddPatient_Click(object sender, EventArgs e)
{
Patient patient = new Patient();
patient.FirstName = tbpName.Text;
patient.SecondName = tbpPoB.Text;
patient.LastName = tbpSurName.Text;
patient.Email = tbpEmail.Text;
patient.Login = tbpLogin.Text;
//patient.Hash = "hash";
patient.Role = "User";
Phone phone = new Phone();
phone.home = tbpHomePhone.Text;
phone.mobile = tbpMobilePhone.Text;
phone.work = tbpWorkPhone.Text;
patient.Phone = phone;
Passport passport = new Passport();
passport.BDay = int.Parse(tbpBday.Text);
passport.BMonth = int.Parse(tbpBmonth.Text);
passport.BYear = int.Parse(tbpByear.Text);
passport.DayIoP = int.Parse(tbpDayIoP.Text);
passport.SeriesA = tbpPassSereise.Text;
passport.SeriesN = int.Parse(tbpSereiseNumber.Text);
passport.YearIoP = int.Parse(tbpYearIoP.Text);
patient.Passport = passport;
Address address = new Address();
address.ApartamentNumber = int.Parse(tbpAn.Text);
address.StreetName = tbpStreet.Text;
patient.Address = address;
HistoryBook historyBook = new HistoryBook();
historyBook.BookNumber = int.Parse(tbpHisBookNum.Text);
patient.HistoryBook = historyBook;
using (var client = new HaServiceClient())
{
patient.Hash = client.CreateHashOnServer("111111");
client.AddPatient(patient);
CrealPatentTbFields();
}
FillPatientListView();
}
public ActionResult Edit([Bind(Include = "Book_id,Book_route,Upload_time,Section_id,Book_img,Author,Keyword,PublishTime,BookClassify_id,AuthorCountry,BookName")] HistoryBook historyBook)
{
if (ModelState.IsValid)
{
db.Entry(historyBook).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Section_id = new SelectList(db.HistorySection, "HistorySection_id", "HistorySectionName", historyBook.Section_id);
return(View(historyBook));
}
public static HistoryBookViewModel ToHistoryModel(this HistoryBook x)
{
return(new HistoryBookViewModel
{
Id = x.Id,
Title = x.Title,
Author = x.Author,
Amount = x.Amount,
NumberOfPages = x.NumberOfPages,
Price = x.Price,
Year = x.Year
});
}
public static bool Insert(HistoryBook hb)
{
string sql = "insert into HistoryBook (stuID, dateBook, roomName, bedNo, [status], dateExpiry) values (@stuID, @dateBook, @roomName, @bedNo, @status, @dateExpiry)";
SqlCommand cmd = new SqlCommand(sql);
cmd.Parameters.AddWithValue("@stuID", hb.StuID);
cmd.Parameters.AddWithValue("@dateBook", hb.DateBook);
cmd.Parameters.AddWithValue("@roomName", hb.RoomName);
cmd.Parameters.AddWithValue("@bedNo", hb.BedNo);
cmd.Parameters.AddWithValue("@status", hb.Status);
cmd.Parameters.AddWithValue("@dateExpiry", hb.DateExpiry);
return(DAO.UpdateTable(cmd));
}
// GET: HistoryBooksAdd/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
HistoryBook historyBook = db.HistoryBook.Find(id);
if (historyBook == null)
{
return(HttpNotFound());
}
return(View(historyBook));
}
public static bool Update(HistoryBook hb)
{
string sql = "update HistoryBook set stuID = @stuID, dateBook = @dateBook, roomName = @roomName, bedNo = @bedNo, [status] = @status, dateExpiry = @dateExpiry where bookID = @bookID";
SqlCommand cmd = new SqlCommand(sql);
cmd.Parameters.AddWithValue("@stuID", hb.StuID);
cmd.Parameters.AddWithValue("@dateBook", hb.DateBook);
cmd.Parameters.AddWithValue("@roomName", hb.RoomName);
cmd.Parameters.AddWithValue("@bedNo", hb.BedNo);
cmd.Parameters.AddWithValue("@status", hb.Status);
cmd.Parameters.AddWithValue("@dateExpiry", hb.DateExpiry);
cmd.Parameters.AddWithValue("@bookID", hb.BookID);
return(DAO.UpdateTable(cmd));
}
private void btnDecline_Click(object sender, EventArgs e)
{
if (dataGridView1.SelectedRows.Count == 0)
{
MessageBox.Show("please select one row");
}
else
{
int bookID = int.Parse(dataGridView1.SelectedRows[0].Cells["bookID"].Value.ToString());
HistoryBook his = HistoryBookDAO.GetHistoryBooksByBookID(bookID);
his.Status = 0;
HistoryBookDAO.Update(his);
view();
}
}
// GET: HistoryBooksAdd/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
HistoryBook historyBook = db.HistoryBook.Find(id);
if (historyBook == null)
{
return(HttpNotFound());
}
ViewBag.Section_id = new SelectList(db.HistorySection, "HistorySection_id", "HistorySectionName", historyBook.Section_id);
return(View(historyBook));
}
private void button1_Click(object sender, EventArgs e)
{
string room = comboBoxRoom.SelectedValue.ToString();
int bedNo = int.Parse(comboBoxBedNo.SelectedValue.ToString());
if (RoomDAO.getRoomPrice(room) > s.MoneyAccount)
{
MessageBox.Show("MoneyAccount is not enough to book room");
}
else
{
HistoryBook h = new HistoryBook(s.StuID, DateTime.Now, room, bedNo, 1, 1, a.To.AddDays(30));
HistoryBookDAO.Insert(h);
this.Dispose();
StudentMainGUI stu = new StudentMainGUI(s.Username);
stu.ShowDialog();
}
}
public void Create(CreateBookViewModel model)
{
if (!string.IsNullOrEmpty(model.Planet))
{
var newBook = new FantasyBook()
{
Title = model.Title,
Author = model.Author,
Amount = model.Amount,
NumberOfPages = model.NumberOfPages,
Price = model.Price,
Planet = model.Planet
};
bookRepo.AddFantasy(newBook);
}
else if (!string.IsNullOrEmpty(model.Town))
{
var newBook = new ClassicBook()
{
Title = model.Title,
Author = model.Author,
Amount = model.Amount,
NumberOfPages = model.NumberOfPages,
Price = model.Price,
Town = model.Town
};
bookRepo.AddClassic(newBook);
}
else
{
var newBook = new HistoryBook()
{
Title = model.Title,
Author = model.Author,
Amount = model.Amount,
NumberOfPages = model.NumberOfPages,
Price = model.Price,
//Year = model.Year
};
bookRepo.AddHistory(newBook);
}
}
private void btnAccept_Click(object sender, EventArgs e)
{
if (dataGridView1.SelectedRows.Count == 0)
{
MessageBox.Show("please select one row");
}
else
{
int bookID = int.Parse(dataGridView1.SelectedRows[0].Cells["bookID"].Value.ToString());
HistoryBook his = HistoryBookDAO.GetHistoryBooksByBookID(bookID);
his.Status = 2;
HistoryBookDAO.Update(his);
string roomName = dataGridView1.SelectedRows[0].Cells["roomName"].Value.ToString();
int bedNo = int.Parse(dataGridView1.SelectedRows[0].Cells["bedNo"].Value.ToString());
Room r = RoomDAO.getRoomBedByRoomNameBedNoPrice(roomName, bedNo);
r.BedStatus = 1;
RoomDAO.Update(r);
Student stu = StudentDAO.getStudentByStuID(dataGridView1.SelectedRows[0].Cells["stuID"].Value.ToString());
stu.RoomName = roomName;
stu.BedNo = bedNo;
stu.BookingDate = DateTime.Now;
stu.MoneyAccount = stu.MoneyAccount - r.Price;
StudentDAO.Update(stu);
HistoryPayment hp = new HistoryPayment(1, stu.StuID, DateTime.Now, "tiền phòng", r.Price, roomName);
HistoryPaymentDAO.Insert(hp);
List <HistoryBook> list = HistoryBookDAO.GetHistoryBooksByRoomNameStatus(dataGridView1.SelectedRows[0].Cells["roomName"].Value.ToString(), int.Parse(dataGridView1.SelectedRows[0].Cells["bedNo"].Value.ToString()));
for (int i = 0; i < list.Count; i++)
{
HistoryBook h = list[i];
h.Status = 0;
HistoryBookDAO.Update(h);
}
view();
}
}
public override void DeleteById(Guid id)
{
Patient entity = GetAll().FirstOrDefault(i => i.PatientId.Equals(id));
Passport passport = Context.Passports.FirstOrDefault(i => i.PassportId.Equals(entity.Passport.PassportId));//&&&????
Context.Passports.Remove(passport);
//entity.Passport = passport;
Address address = Context.Addresses.FirstOrDefault(i => i.AddressId.Equals(entity.Address.AddressId));
Context.Addresses.Remove(address);
Phone phone = Context.Phones.FirstOrDefault(i => i.PhoneId.Equals(entity.Phone.PhoneId));
Context.Phones.Remove(phone);
HistoryBook historyBook = Context.HistoryBooks.FirstOrDefault(i => i.HistoryBookId.Equals(entity.HistoryBook.HistoryBookId));
Context.HistoryBooks.Remove(historyBook);
/*entity.Address = address;
* entity.Phone = phone;
* entity.HistoryBook = historyBook;*/
Context.Patients.Remove(entity);
Context.SaveChanges();
}
public void AddHistory(HistoryBook newBook)
{
context.HistoryBooks.Add(newBook);
context.SaveChanges();
}
public void UpdateHistoryBook(HistoryBook dbBook)
{
context.HistoryBooks.Update(dbBook);
context.SaveChanges();
}
