// // private void btnUpdate_Click(object sender, EventArgs e) { try { var db = new QuanLyPhongTroEntities2(); int RoomName = (int)(this.cboRoomName.SelectedValue); DateTime dateStart = dtpStart.Value; DateTime dateEnd = dtpEnd.Value; // int?duration; txtDuration.Text = (dtpEnd.Value - dtpStart.Value).TotalDays.ToString("#"); duration = int.Parse(txtDuration.Text); // int?Bill = int.Parse(txtBill.Text); // var newSession = db.Sessions.Find(this.session.ID); newSession.RoomID = RoomName; newSession.DateStart = dateStart; newSession.DateEnd = dateEnd; newSession.Duration = duration; newSession.TenantName = txtName.Text; newSession.TenantId = txtIDN.Text; newSession.Total = Bill; // db.Entry(newSession).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); this.Close(); } catch (Exception) { MessageBox.Show("Invalid input : please dont let any field empty"); } }
public FormEditSession(int ID) { InitializeComponent(); var db = new QuanLyPhongTroEntities2(); session = db.Sessions.Single(st => st.ID == ID); }
public FormEditRoom(int ID) { var db = new QuanLyPhongTroEntities2(); InitializeComponent(); room = db.Rooms.Single(st => st.ID == ID); }
public FormEditPrice(int ID) { var db = new QuanLyPhongTroEntities2(); InitializeComponent(); price = db.Prices.Single(st => st.ID == ID); }
private void FormEditPrice_Load(object sender, EventArgs e) { var db = new QuanLyPhongTroEntities2(); this.txtValue.Text = price.Value.ToString(); this.txtVName.Text = price.ValueName.ToString(); }
private void FormAddSession_Load(object sender, EventArgs e) { var db = new QuanLyPhongTroEntities2(); this.cboRoomName.DataSource = db.Rooms.ToList(); this.cboRoomName.ValueMember = "ID"; this.cboRoomName.DisplayMember = "RoomName"; }
//event for loading data to the main form private void FormMain_Load(object sender, EventArgs e) { QuanLyPhongTroEntities2 db = new QuanLyPhongTroEntities2(); this.frmRoom.DataSource = db.Rooms.ToList().Select(r => new model.RoomView(r)).ToList(); this.frmSession.DataSource = db.Sessions.ToList().Select(s => new model.SessionView(s)).ToList(); this.frmPrice.DataSource = db.Prices.ToList().Select(p => new model.PriceView(p)).ToList(); }
private void btnUpdate_Click(object sender, EventArgs e) { var db = new QuanLyPhongTroEntities2(); var newPrice = db.Prices.Find(this.price.ID); int tempValue = int.Parse(txtValue.Text); newPrice.Value = tempValue; newPrice.ValueName = txtVName.Text; db.Entry(newPrice).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); this.Close(); }
private void FormAddRoom_Load(object sender, EventArgs e) { QuanLyPhongTroEntities2 db = new QuanLyPhongTroEntities2(); //loading data for combo box Room status this.cboRoomStatus.DataSource = db.RoomStatus.ToList(); //display the status name into the combo box this.cboRoomStatus.ValueMember = "ID"; this.cboRoomStatus.DisplayMember = "StatusName"; //loading data for combo box Room Type this.cboRoomType.DataSource = db.Prices.ToList(); this.cboRoomType.ValueMember = "ID"; this.cboRoomType.DisplayMember = "ValueName"; }
private void btnUpdate_Click(object sender, EventArgs e) { int Type = (int)(this.cboRoomType.SelectedValue); int Status = (int)(this.cboRoomStatus.SelectedValue); var db = new QuanLyPhongTroEntities2(); var newRoom = db.Rooms.Find(this.room.ID); newRoom.RoomName = txtRoomName.Text; newRoom.TypeID = Type; newRoom.StatusID = Status; db.Entry(newRoom).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); this.Close(); }
//Price private void btnDeleteP_Click(object sender, EventArgs e) { var db = new QuanLyPhongTroEntities2(); if (frmPrice.SelectedRows.Count == 1) { var row = frmPrice.SelectedRows[0]; var cell = row.Cells["ID"]; int id = (int)cell.Value; Price price = db.Prices.Single(st => st.ID == id); db.Prices.Remove(price); db.SaveChanges(); this.LoadFrmPrice(); } }
//Session private void btnDeleteS_Click(object sender, EventArgs e) { var db = new QuanLyPhongTroEntities2(); if (frmSession.SelectedRows.Count == 1) { var row = frmSession.SelectedRows[0]; var cell = row.Cells["id"]; int id = (int)cell.Value; Session session = db.Sessions.Single(st => st.ID == id); db.Sessions.Remove(session); db.SaveChanges(); this.LoadFrmSession(); } }
// private void FormEditSession_Load(object sender, EventArgs e) { var db = new QuanLyPhongTroEntities2(); this.cboRoomName.DataSource = db.Rooms.ToList(); this.cboRoomName.ValueMember = "id"; this.cboRoomName.DisplayMember = "RoomName"; this.cboRoomName.SelectedValue = session.Room.ID; this.dtpStart.Value = session.DateStart; this.dtpEnd.Value = session.DateEnd.Value; this.txtDuration.Text = session.Duration.ToString(); this.txtBill.Text = session.Total.ToString(); this.txtName.Text = session.TenantName; this.txtIDN.Text = session.TenantId; }
private void btnSave_Click(object sender, EventArgs e) { string RoomName = this.txtRoomName.Text; int RoomType = (int)this.cboRoomType.SelectedValue; int RoomStatus = (int)this.cboRoomStatus.SelectedValue; var db = new QuanLyPhongTroEntities2(); Room room = new Room(); room.StatusID = RoomStatus; room.RoomName = RoomName; room.TypeID = RoomType; db.Rooms.Add(room); db.SaveChanges(); this.Close(); }
//Delete funciton for price , room and session //Room private void btnDELETE_Click(object sender, EventArgs e) { var db = new QuanLyPhongTroEntities2(); if (frmRoom.SelectedRows.Count == 1) { var row = frmRoom.SelectedRows[0]; var cell = row.Cells["id"]; int id = (int)cell.Value; Room room = db.Rooms.Single(st => st.ID == id); db.Rooms.Remove(room); db.SaveChanges(); this.LoadFrmRoom(); } }
private void btnSave_Click(object sender, EventArgs e) { try { string VName = txtVName.Text; int Value = int.Parse(txtValue.Text); Price p = new Price(); p.ValueName = VName; p.Value = Value; var db = new QuanLyPhongTroEntities2(); db.Prices.Add(p); db.SaveChanges(); this.Close(); } catch (Exception) { MessageBox.Show("please input field :VALUE "); } }
//function for loading data to the Edit Form private void FormEditRoom_Load(object sender, EventArgs e) { QuanLyPhongTroEntities2 db = new QuanLyPhongTroEntities2(); //loading the DataSource this.cboRoomStatus.DataSource = db.RoomStatus.ToList(); this.cboRoomType.DataSource = db.Prices.ToList(); //display the status name into the combobox this.cboRoomStatus.ValueMember = "ID"; this.cboRoomStatus.DisplayMember = "StatusName"; //loading current data to combobox /Room Type this.cboRoomType.ValueMember = "ID"; this.cboRoomType.DisplayMember = "ValueName"; // this.txtRoomName.Text = room.RoomName; //loading current data to combobox /Room status this.cboRoomStatus.SelectedValue = room.StatusID; this.cboRoomType.SelectedValue = room.TypeID; }
//Save function event private void btnSave_Click(object sender, EventArgs e) { //create var to store the inputed information try { string Name = txtName.Text; string ID = txtIDN.Text; string duration; txtDuration.Text = (dtpEnd.Value - dtpStart.Value).TotalDays.ToString("#"); duration = txtDuration.Text; int? totalday = int.Parse(duration); DateTime dateStart = dtpStart.Value; DateTime dateEnd = dtpEnd.Value; //string Bill = txtBill.Text; int BillTotal = int.Parse(txtBill.Text); int RoomName = (int)(this.cboRoomName.SelectedValue); //create the connect to database var db = new QuanLyPhongTroEntities2(); Session s = new Session(); //storing the data with the new session s.DateStart = dateStart; s.DateEnd = dateEnd; s.Duration = totalday; s.TenantId = ID; s.TenantName = Name; s.RoomID = RoomName; s.Total = BillTotal; // //add the new session into database db.Sessions.Add(s); db.SaveChanges(); this.Close(); } catch (Exception) { MessageBox.Show("Invalid input : please dont let the field empty"); } }
private void LoadFrmSession()//Session { QuanLyPhongTroEntities2 db = new QuanLyPhongTroEntities2(); this.frmSession.DataSource = db.Sessions.ToList().Select(s => new model.SessionView(s)).ToList(); }
private void LoadFrmPrice()//Price { QuanLyPhongTroEntities2 db = new QuanLyPhongTroEntities2(); this.frmPrice.DataSource = db.Prices.ToList().Select(p => new model.PriceView(p)).ToList(); }
//function to refresh the data after add,edit or delete room after changes private void LoadFrmRoom()//Room { QuanLyPhongTroEntities2 db = new QuanLyPhongTroEntities2(); this.frmRoom.DataSource = db.Rooms.ToList().Select(r => new model.RoomView(r)).ToList(); }