public OPEN_FOOD()
{
InitializeComponent();
Rectangle rcScreen = Screen.PrimaryScreen.WorkingArea;
this.Location = new System.Drawing.Point((rcScreen.Left + rcScreen.Right) / 2 - (this.Width / 2), 0);
reg_tax_amount = CLS_TAX.GetTotalTaxPercentage();
}
public KOT_ITEMS_EDIT(string KOT_NO, string GUEST_NAME, string RESERVATION_NO, string ROOM_NO, string TABLE_NO)
{
InitializeComponent();
LBL_ORDER_NO.Text = KOT_NO;
LBL_GUEST_NAME.Text = GUEST_NAME;
LBL_RESERVATION_NO.Text = RESERVATION_NO;
LBL_ROOM_NO.Text = ROOM_NO;
LBL_TABLE_NO.Text = TABLE_NO;
reg_tax_amount = CLS_TAX.GetTotalTaxPercentage();
LOAD_ORDER_DETAILS(KOT_NO);
}
private void AddSelectedRoom(object sender, EventArgs e, string room_id, string room_name, string description, double PRICE)
{
bool ADD = false;
double totalPrice = 0;
double TAX = CLS_TAX.GetTotalTaxPercentage();
foreach (ListViewItem F in LST_SELECTED_ROOM.Items)
{
if (F.Text == room_id)
{
F.Remove();
ADD = true;
break;
}
}
if (ADD == false)
{
ListViewItem LST = new ListViewItem(room_id);
{
LST.SubItems.Add(room_name);
LST.SubItems.Add(description);
LST.SubItems.Add(PRICE.ToString("F2"));
LST.BackColor = Color.Green;
LST.ForeColor = Color.White;
}
LST_SELECTED_ROOM.Items.Add(LST);
}
foreach (ListViewItem F in LST_SELECTED_ROOM.Items)
{
totalPrice = totalPrice + Convert.ToDouble(F.SubItems[3].Text);
}
TXT_NO_OF_ROOMS.Text = LST_SELECTED_ROOM.Items.Count.ToString();
LBL_TOT_CHARGE_LKR.Text = (totalPrice * HYFLEX_HMS.Properties.Settings.Default.exchange_rate_lrk).ToString("F2");
LBL_TOT_CHARGE_USD.Text = (totalPrice * Convert.ToDouble(TXT_NO_OF_NIGHTS.Text)).ToString("F2");
}
//private void LOAD_AVAILABLE_ROOMS()
//{
// try
// {
// CONNECTION.open_connection();
// using (MySqlDataAdapter da = new MySqlDataAdapter("SELECT id, room_name, room_condition FROM room WHERE current_status = 'AVAILABLE'", CONNECTION.CON))
// {
// DataTable DT = new DataTable();
// da.Fill(DT);
// if (DT.Rows.Count > 0)
// {
// foreach(DataRow DR in DT.Rows)
// {
// ShapedButton BTN = new ShapedButton();
// BTN.Name = DR[0].ToString();
// BTN.ButtonText= DR[1].ToString();
// BTN.Text = DR[1].ToString();
// BTN.TextLocation_X = 25;
// BTN.TextLocation_Y = 20;
// BTN.borderWidth = 1;
// BTN.ShowButtontext = true;
// BTN.Click += BTN_Click;
// BTN.Size = new Size(75,60);
// flowLayoutPanel1.Controls.Add(BTN);
// }
// }
// }
// }
// catch (Exception EX)
// {
// MSGBOX mdg = new MSGBOX(MessageAlertHeder.Error(), EX.Message, MessageAlertImage.Error());
// mdg.ShowDialog();
// }
//}
private void LOAD_AVAILABLE_ROOMS()
{
double TAX = CLS_TAX.GetTotalTaxPercentage();
try
{
CONNECTION.open_connection();
using (MySqlDataAdapter da = new MySqlDataAdapter("SELECT room_id, room_name, room_packages.package_name, room_packages.description, room_packages.condition, room_packages.room_package_price, room_packages.package_color FROM room INNER JOIN room_packages ON ( room.room_package_id = room_packages.room_package_id ) WHERE room_id NOT IN (SELECT room.room_id FROM room INNER JOIN room_packages ON ( room.room_package_id = room_packages.room_package_id ) INNER JOIN recerved_rooms ON ( recerved_rooms.room_id = room.room_id ) INNER JOIN reservation ON ( reservation.reservation_id = recerved_rooms.reservation_no ) WHERE ( reservation.arrival_date BETWEEN @frmdate AND @todate ) OR ( reservation.depature_Date > @frmdate AND reservation.depature_Date <= @todate ) OR( reservation.arrival_date < @frmdate AND reservation.`depature_Date` >= @todate ) )", CONNECTION.CON))
{
da.SelectCommand.Parameters.Clear();
da.SelectCommand.Parameters.AddWithValue("@frmdate", DTP_ARRIVAL_DATE.Value.ToShortDateString());
da.SelectCommand.Parameters.AddWithValue("@todate", DTP_DEPATURE_DATE.Value.ToShortDateString());
DataTable DT = new DataTable();
da.Fill(DT);
if (DT.Rows.Count > 0)
{
flowLayoutPanel1.Controls.Clear();
flowLayoutPanel1.Visible = false;
foreach (DataRow DR in DT.Rows)
{
Font = new Font("Consolas", 8, FontStyle.Bold);
Panel BTN = new Panel();
BTN.Name = DR[0].ToString();
double ROOM_CHRGES_WITH = Convert.ToDouble(DR[5].ToString());
double TOTAL = 0;
if (CMB_TAX.SelectedIndex == 0)
{
TOTAL = ROOM_CHRGES_WITH + (ROOM_CHRGES_WITH * TAX / 100);
}
else
{
TOTAL = ROOM_CHRGES_WITH;
}
BTN.Click += (sender2, e2) => AddSelectedRoom(sender2, e2, DR[0].ToString(), DR[1].ToString(), DR[2].ToString(), TOTAL);
BTN.Size = new Size(100, 100);
Color back = ColorTranslator.FromHtml(DR[6].ToString());
BTN.BackColor = back;
//DESCRIPTION
Label LBL_TYPE = new Label();
LBL_TYPE.Height = 30;
LBL_TYPE.BackColor = Color.DodgerBlue;
LBL_TYPE.Text = DR[2].ToString();
LBL_TYPE.AutoSize = false;
LBL_TYPE.Width = 96;
LBL_TYPE.Location = new Point(2, 2);
LBL_TYPE.MouseClick += (sender2, e2) => AddSelectedRoom(sender2, e2, DR[0].ToString(), DR[1].ToString(), DR[2].ToString(), TOTAL);
LBL_TYPE.TextAlign = ContentAlignment.BottomCenter;
//CONDITION
Label LBL_CONDITION = new Label();
LBL_CONDITION.Height = 15;
LBL_CONDITION.BackColor = Color.DeepSkyBlue;
LBL_CONDITION.Text = DR[4].ToString();
LBL_CONDITION.AutoSize = false;
LBL_CONDITION.Width = 96;
LBL_CONDITION.MouseClick += (sender2, e2) => AddSelectedRoom(sender2, e2, DR[0].ToString(), DR[1].ToString(), DR[2].ToString(), TOTAL);
LBL_CONDITION.Location = new Point(2, 30);
LBL_CONDITION.TextAlign = ContentAlignment.BottomCenter;
//PRICE
Label LBL_PRICE = new Label();
LBL_PRICE.Height = 15;
LBL_PRICE.BackColor = Color.DodgerBlue;
LBL_PRICE.AutoSize = false;
LBL_PRICE.Width = 96;
LBL_PRICE.Location = new Point(2, 50);
LBL_PRICE.MouseClick += (sender2, e2) => AddSelectedRoom(sender2, e2, DR[0].ToString(), DR[1].ToString(), DR[2].ToString(), TOTAL);
LBL_PRICE.Text = "LKR: " + TOTAL.ToString("F2");
LBL_PRICE.TextAlign = ContentAlignment.BottomCenter;
//ROOM NAME
Label LBL_ID = new Label();
LBL_ID.Height = 15;
LBL_ID.Text = DR[1].ToString();
LBL_ID.AutoSize = false;
LBL_ID.Width = 96;
LBL_ID.Location = new Point(2, 70);
LBL_ID.MouseClick += (sender2, e2) => AddSelectedRoom(sender2, e2, DR[0].ToString(), DR[1].ToString(), DR[2].ToString(), TOTAL);
LBL_ID.TextAlign = ContentAlignment.BottomCenter;
LBL_ID.BackColor = Color.DeepSkyBlue;
BTN.Controls.Add(LBL_ID);
BTN.Controls.Add(LBL_TYPE);
BTN.Controls.Add(LBL_CONDITION);
BTN.Controls.Add(LBL_PRICE);
BTN.MouseEnter += (sender2, e2) => BTN_MouseEnter1(sender2, e2);
BTN.MouseLeave += (sender2, e2) => BTN_MouseLeave2(sender2, e2, back);
flowLayoutPanel1.Controls.Add(BTN);
}
flowLayoutPanel1.Visible = true;
}
}
}
catch (Exception EX)
{
MSGBOX mdg = new MSGBOX(MessageAlertHeder.Error(), EX.Message, MessageAlertImage.Error());
mdg.ShowDialog();
}
}
public ROOM_PACKAGE()
{
InitializeComponent();
tax_percentage = CLS_TAX.GetTotalTaxPercentage();
LOAD_PACKAGE_LIST();
}
private void CMB_SERVICES_SelectedIndexChanged(object sender, EventArgs e)
{
CONNECTION.open_connection();
try
{
using (MySqlDataAdapter da = new MySqlDataAdapter("SELECT * FROM additional_service_list WHERE id=@id", CONNECTION.CON))
{
da.SelectCommand.Parameters.AddWithValue("@id", CMB_SERVICES.SelectedValue);
DataTable getservices = new DataTable();
da.Fill(getservices);
if (getservices.Rows.Count > 0)
{
double price = ((Convert.ToDouble(getservices.Rows[0]["service_price"].ToString()) * CLS_TAX.GetTotalTaxPercentage()) / 100.0) + Convert.ToDouble(getservices.Rows[0]["service_price"].ToString());
double subtotal = Convert.ToDouble(TXT_QTY.Text) * price;
TXT_SERVICE_CHARGE.Text = string.Format("{0:#,##0.00}", price);
TXT_SUBTOTAL.Text = string.Format("{0:#,##0.00}", subtotal);
}
}
}
catch (Exception ex)
{
MSGBOX mdg = new MSGBOX(MessageAlertHeder.Error(), ex.Message, MessageAlertImage.Error());
mdg.ShowDialog();
}
finally
{
CONNECTION.close_connection();
}
}
