public DeleteRoom(vari v)
{
vdbl = v;
InitializeComponent();
List <Roomviewvar> roomlist = new List <Roomviewvar>();
//List<Department> departments = new List<Department>();
SqlDataReader reader = dbl.drmlist(vdbl);
while (reader.Read())
{
Roomviewvar ser = new Roomviewvar();
ser.Id = reader.GetInt32(0);
ser.Type = reader.GetString(1);
ser.Price = reader.GetString(2);
ser.NOB = reader.GetString(3);
ser.Floor = reader.GetString(4);
ser.Extabed = reader.GetString(5);
ser.Booking = reader.GetString(6);
roomlist.Add(ser);
}
RoomGrid.DataSource = roomlist;
}
private void metroButton1_Click(object sender, EventArgs e)
{
vari vadmin = new vari();
vadmin.uname = Ausername.Text;
vadmin.password = Apassword.Text;
BLL b = new BLL();
DataTable data = b.adminlogin(vadmin);
if (data.Rows.Count > 0)
{
AdminPanel ap = new AdminPanel();
this.Hide();
ap.Show();
}
/* foreach(var usr in ef.Admindbs)
* {
* if(usr.Username==Ausername.Text && usr.Password == Apassword.Text)
* {
*
* Guest g = new Guest();
* g.Show();
* }
*
* }*/
}
private void metroButton1_Click(object sender, EventArgs e)
{
vari bookingid = new vari();
bookingid.id = Convert.ToInt32(Room_no.Text);
bookingid.gid = g_id.gid;
bookingid.Booking = "Yes";
bl.BookRoom(bookingid);
SqlDataReader reader = bl.ReturnRoomInfo(bookingid);
while (reader.Read())
{
//HotelRoom rooms = new HotelRoom();
//.Id = reader.GetInt32(0);
//rooms.Room_Type = reader.GetString(1);
bookingid.Price = reader.GetString(2);
//rooms.No_bed = reader.GetString(3);
//rooms.Room_Floor = reader.GetString(4);
//rooms.Extrabed = reader.GetString(5);
//rooms.booking = reader.GetString(6);
//hotelrooms.Add(rooms);
bookingid.Service = "Room";
bookingid.Payment = "Not Paid";
bookingid.Status = "Pending";
}
bl.placeorder(bookingid);
}
public Guest_Booking(vari gvar)
{
g_id = gvar;
InitializeComponent();
// MessageBox.Show(this,g_id.id);
List <HotelRoom> hotelrooms = new List <HotelRoom>();
//List<Department> departments = new List<Department>();
SqlDataReader reader = bl.Showroomlist();
while (reader.Read())
{
HotelRoom rooms = new HotelRoom();
rooms.Id = reader.GetInt32(0);
rooms.Room_Type = reader.GetString(1);
rooms.Room_Price = reader.GetString(2);
rooms.No_bed = reader.GetString(3);
rooms.Room_Floor = reader.GetString(4);
rooms.Extrabed = reader.GetString(5);
rooms.booking = reader.GetString(6);
hotelrooms.Add(rooms);
}
dataGridView1.DataSource = hotelrooms;
//dataGridView1.Columns[6].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
}
private void metroButton1_Click(object sender, EventArgs e)
{
vari vguest = new vari();
vguest.uname = guser.Text;
vguest.password = gpass.Text;
BLL b = new BLL();
DataTable data = b.guestlogin(vguest);
if (data.Rows.Count > 0)
{
// MessageBox.Show("Login Success!");
foreach (DataRow dr in data.Rows)
{
vguest.gid = dr["Id"].ToString();
//string col2 = dr["col2"].ToString();
}
Guest_Panel gp = new Guest_Panel(vguest);
this.Hide();
gp.Show();
}
}
public Book_A_Service(vari gid)
{
InitializeComponent();
v.gid = gid.gid;
List <ComboService> servicelist = new List <ComboService>();
//List<Department> departments = new List<Department>();
SqlDataReader reader = n.Servicelist();
while (reader.Read())
{
ComboService ser = new ComboService();
// ser.Id = reader.GetInt32(0);
ser.Service_Name = reader.GetString(1);
// ser.Price = reader.GetString(2);
// ser.Description = reader.GetString(3);
//ser.Available = reader.GetString(4);
servicelist.Add(ser);
}
metroComboBox1.DataSource = servicelist;
metroComboBox1.ValueMember = "Service_Name";
metroComboBox1.DisplayMember = "Service_Name";
}
public ConfirmOrder(vari v)
{
var = v;
InitializeComponent();
// var.gid = g.gid;
List <Orderlist> Order = new List <Orderlist>();
//List<Department> departments = new List<Department>();
SqlDataReader reader = bl.OrderlistBYid(var);
while (reader.Read())
{
Orderlist order = new Orderlist();
order.Id = reader.GetInt32(0);
order.G_id = reader.GetString(1);
order.Price = reader.GetString(2);
order.Payment = reader.GetString(3);
order.Service = reader.GetString(4);
order.Status = reader.GetString(5);
order.S_id = reader.GetString(6);
Order.Add(order);
}
dataGridView1.DataSource = Order;
//dataGridView1.Columns[6].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
}
public DataTable DService(vari d)
{
SqlCommand com = new SqlCommand();
com.CommandType = CommandType.Text;
com.CommandText = "Delete from [Service] where Id = '" + d.id + "'";
return(db.ExeReader(com));
}
public DataTable Demp(vari d)
{
SqlCommand com = new SqlCommand();
com.CommandType = CommandType.Text;
com.CommandText = "Delete from [Employee] where E_Id = '" + d.id + "'";
return(db.ExeReader(com));
}
public DataTable newemp(vari v)
{
SqlCommand com = new SqlCommand();
com.CommandType = CommandType.Text;
com.CommandText = "insert into Employee(E_Name,Department,Salary,Available,Address) values ('" + v.name + "','" + v.Department + "','" + v.salary + "','" + v.available + "','" + v.address + "')";
return(db.ExeReader(com));
}
/* public DataTable ManagerLogin(info ninfo)
* {
* SqlCommand com = new SqlCommand();
* com.CommandType = CommandType.Text;
* com.CommandText = "select * from manager where id = '" + ninfo.id + "' and password = '******'";
* return ndbc.ExeReader(com);
* }
*
* public DataTable OwnerLogin(info ninfo)
* {
* SqlCommand com = new SqlCommand();
* com.CommandType = CommandType.Text;
* com.CommandText = "select * from owner where id = '" + ninfo.id + "' and password = '******'";
* return ndbc.ExeReader(com);
* }
*/
public DataTable newguest(vari v)
{
SqlCommand com = new SqlCommand();
com.CommandType = CommandType.Text;
com.CommandText = "insert into Guestdb(Username,Password,fname,lname,Address,Gender) values ('" + v.uname + "','" + v.password + "','" + v.fname + "','" + v.lname + "','" + v.address + "','" + v.gender + "')";
return(db.ExeReader(com));
}
public SqlDataReader OrderlistBYid(vari v)
{
SqlCommand com = new SqlCommand();
com.CommandType = CommandType.Text;
com.CommandText = "select * from [Order] where Id = '" + v.id + "'";
return(db.sExeReader(com));
}
public DataTable UpdateService(vari v)
{
SqlCommand com = new SqlCommand();
com.CommandType = CommandType.Text;
com.CommandText = "Update [Service] set Service_Name = '" + v.name + "', Price = '" + v.Price + "',Description = '" + v.Description + "', Available = '" + v.available + "' where Id = '" + v.id + "'";
return(db.ExeReader(com));
}
public SqlDataReader ReturnRoomInfo(vari v)
{
SqlCommand com = new SqlCommand();
com.CommandType = CommandType.Text;
com.CommandText = "select * from Roomdb where Id = '" + v.id + "'";
return(db.sExeReader(com));
}
public DataTable BookRoom(vari v)
{
SqlCommand com = new SqlCommand();
com.CommandType = CommandType.Text;
com.CommandText = "Update [Roomdb] set Booking = '" + v.Booking + "', G_id = '" + v.gid + "' where id = '" + v.id + "' ";
return(db.ExeReader(com));
}
public DataTable UpdateRoom(vari v)
{
SqlCommand com = new SqlCommand();
com.CommandType = CommandType.Text;
com.CommandText = "Update [Employee] set Room_Type = '" + v.Type + "', Room_Price = '" + v.Price + "',No_bed = '" + v.No_of_bed + "', Room_Floor = '" + v.Level + "',Booking = '" + v.Booking + "' where E_Id = '" + v.id + "'";
return(db.ExeReader(com));
}
public DataTable placeorder(vari v)
{
SqlCommand com = new SqlCommand();
com.CommandType = CommandType.Text;
com.CommandText = "insert into [Order](G_id,Price,Payment,Status,Service,S_id) values ('" + v.gid + "','" + v.Price + "','" + v.Payment + "','" + v.Status + "','" + v.Service + "','" + v.id + "')";
return(db.ExeReader(com));
}
public DataTable guestlogin(vari v)
{
SqlCommand com = new SqlCommand();
com.CommandType = CommandType.Text;
com.CommandText = "select * from Guestdb where Username = '******' and Password = '******'";
return(db.ExeReader(com));
}
public DataTable insertservice(vari v)
{
SqlCommand com = new SqlCommand();
com.CommandType = CommandType.Text;
com.CommandText = "insert into [Service] (Service_Name,Price,Description,Available) values ('" + v.name + "','" + v.Price + "','" + v.Description + "','" + v.available + "')";
return(db.ExeReader(com));
}
public DataTable PayOrder(vari v)
{
SqlCommand com = new SqlCommand();
com.CommandType = CommandType.Text;
com.CommandText = "update [Order] set Payment='" + v.Payment + "' where Id = '" + v.id + "'";
return(db.ExeReader(com));
}
public DataTable ConfirmBooking(vari v)
{
SqlCommand com = new SqlCommand();
com.CommandType = CommandType.Text;
com.CommandText = "update [Order] set Status='" + v.Status + "'";
return(db.ExeReader(com));
}
public DataTable newroom(vari v)
{
SqlCommand com = new SqlCommand();
com.CommandType = CommandType.Text;
com.CommandText = "insert into Roomdb(Room_Type,Room_Price,No_bed,Room_Floor,Extra_bed) values ('" + v.Type + "','" + v.Price + "','" + v.No_of_bed + "','" + v.Level + "','" + v.Extrabed + "')";
return(db.ExeReader(com));
}
public SqlDataReader DShowemplist(vari v)
{
SqlCommand com = new SqlCommand();
com.CommandType = CommandType.Text;
com.CommandText = "select * from Employee where E_Id='" + v.id + "'";
return(db.sExeReader(com));
}
public SqlDataReader DServicelist(vari d)
{
SqlCommand com = new SqlCommand();
com.CommandType = CommandType.Text;
com.CommandText = "select * from [Service] where Id = '" + d.id + "'";
return(db.sExeReader(com));
}
public DataTable UpdateEmp(vari v)
{
SqlCommand com = new SqlCommand();
com.CommandType = CommandType.Text;
com.CommandText = "Update [Employee] set E_Name = '" + v.name + "', Department = '" + v.Department + "',Salary = '" + v.salary + "', Available = '" + v.available + "',Address = '" + v.address + "' where E_Id = '" + v.id + "'";
return(db.ExeReader(com));
}
private void metroButton3_Click(object sender, EventArgs e)
{
vari v = new vari();
v.id = Convert.ToInt32(Empid.Text);
UpdateEmp uemp = new UpdateEmp(v);
this.Hide();
uemp.Show();
}
private void metroButton2_Click(object sender, EventArgs e)
{
vari vdmp = new vari();
vdmp.id = Convert.ToInt32(Empid.Text);
DeleteEmp demmp = new DeleteEmp(vdmp);
this.Hide();
demmp.Show();
}
private void metroButton3_Click(object sender, EventArgs e)
{
BLL servicequery = new BLL();
vari servicevariable = new vari();
servicevariable.Room_id = Confirm_id.Text;
servicevariable.Status = "Confirmed";
servicequery.ConfirmBooking(servicevariable);
}
private void metroButton1_Click(object sender, EventArgs e)
{
BLL servicequery = new BLL();
vari servicevariable = new vari();
servicevariable.name = Sname.Text;
servicevariable.Price = Price.Text;
servicevariable.Description = Description.Text;
servicevariable.available = Available.Text;
servicequery.insertservice(servicevariable);
}
private void metroButton1_Click(object sender, EventArgs e)
{
vari abooking = new vari();
abooking.gid = Guestid.Text;
abooking.id = Convert.ToInt32(Room_no.Text);
abooking.Booking = "Yes";
bl.BookRoom(abooking);
// Confirm_Booking cb = new Confirm_Booking(abooking);
BLL abookingbl = new BLL();
}
