コード例 #1
0
 public override void savebtn_Click(object sender, EventArgs e)
 {
     if (rolesTxt.Text == "")
     {
         rolesErrorLabel.Visible = true;
     }
     else
     {
         rolesErrorLabel.Visible = false;
     }
     if (rolesErrorLabel.Visible)
     {
         MainClass.showMessage("Fields with * are mandatory", "Error");
     }
     else
     {
         if (edit == 0)
         {
             insertion.insertRole(rolesTxt.Text);
             MainClass.resetDisable(leftpanel);
             RetrivalData.getRoles(dataGridView1, RoleIDGV, RoleGV);
         }
         else if (edit == 1)
         {
             Updates.updateRole(rolesTxt.Text, roleID);
             MainClass.resetDisable(leftpanel);
             RetrivalData.getRoles(dataGridView1, RoleIDGV, RoleGV);
         }
     }
 }
コード例 #2
0
 private void ChefOrderWindow_Load(object sender, EventArgs e)
 {
     RetrivalData.getPendingOrders(dataGridView1, orderIDGV, statusGV);
     MainClass.sno(dataGridView1, "snoGV");
     addbtn.Visible    = false;
     deletebtn.Visible = false; searchtxt.Visible = false;
 }
コード例 #3
0
        private void button1_Click(object sender, EventArgs e)
        {
            if (MainClass.checkControls(leftpanel).Count == 0)
            {
                if (RetrivalData.ValidUser(textBox1.Text, passTxt.Text))
                {
                    if (RetrivalData.ROLE == "admin")
                    {
                        adminHomeScreenWindow hs = new adminHomeScreenWindow();
                        MainClass.showWindow(hs, this, MDI.ActiveForm);
                    }
                    else if (RetrivalData.ROLE == "Chef")
                    {
                        HomeScreen2 hs = new HomeScreen2

                                             ();
                        MainClass.showWindow(hs, this, MDI.ActiveForm);
                    }
                }
                else
                {
                }
            }
            else
            {
                MessageBox.Show("Please enter all required fields");
            }
        }
コード例 #4
0
ファイル: ordersWindow.cs プロジェクト: shreya2211/RMS2
 private void itemDD_SelectedIndexChanged(object sender, EventArgs e)
 {
     if (itemDD.SelectedIndex != -1)
     {
         try
         {
             itemEL.Visible = false;
             SqlCommand cmd = new SqlCommand("st_getPriceWRTitem", MainClass.con);
             cmd.CommandType = CommandType.StoredProcedure;
             cmd.Parameters.AddWithValue("@mid", Convert.ToInt32(itemDD.SelectedValue.ToString()));
             MainClass.con.Open();
             priceTxt.Text = Math.Round(Convert.ToDouble(cmd.ExecuteScalar().ToString()), 0).ToString();
             MainClass.con.Close();
             DataRowView drv = itemDD.SelectedItem as DataRowView;
             RetrivalData.loadCategoryWRTItem(drv["Menu Name"].ToString());
         }
         catch (Exception ex)
         {
             MainClass.showMessage(ex.Message, "error");
         }
     }
     else
     {
         itemEL.Visible = true;
         priceTxt.Text  = "";
     }
 }
コード例 #5
0
 private void billButton_Click(object sender, EventArgs e)
 {
     if (orderTypeDD.SelectedIndex == 0)
     {
         if (retrunedTXt.Text != "" && floorDD.SelectedIndex != -1 && tableDD.SelectedIndex != -1)
         {
             int ch = Updates.updateOrder(Convert.ToInt64(orderidTxt.Text), Convert.ToSingle(paidTxt.Text), Convert.ToSingle(retrunedTXt.Text), 2);
             if (ch > 0)
             {
                 DialogResult dr = MessageBox.Show("Order completed successfully", "Success..", MessageBoxButtons.OK, MessageBoxIcon.Information);
                 if (dr == DialogResult.OK)
                 {
                     rd = new ReportDocument();
                     RetrivalData.loadReport(rd, crystalReportViewer1, 2, null, Convert.ToInt32(tableDD.SelectedValue.ToString()));
                 }
             }
         }
     }
     else
     {
         if (retrunedTXt.Text != "" && phoneTxt.Text != "")
         {
             int ch = Updates.updateOrder(Convert.ToInt64(orderidTxt.Text), Convert.ToSingle(paidTxt.Text), Convert.ToSingle(retrunedTXt.Text), 2);
             if (ch > 0)
             {
                 DialogResult dr = MessageBox.Show("Order completed successfully", "Success..", MessageBoxButtons.OK, MessageBoxIcon.Information);
                 if (dr == DialogResult.OK)
                 {
                     rd = new ReportDocument();
                     RetrivalData.loadReport(rd, crystalReportViewer1, 2, phoneTxt.Text);
                 }
             }
         }
     }
 }
コード例 #6
0
ファイル: ordersWindow.cs プロジェクト: shreya2211/RMS2
 private void floorDD_SelectedIndexChanged(object sender, EventArgs e)
 {
     if (floorDD.SelectedIndex != -1)
     {
         RetrivalData.loadItems("st_getTablesWRTfloor", tableDD, "Table Number", "Table ID", "@floorID", Convert.ToInt32(floorDD.SelectedValue.ToString()));
         tableDD.SelectedIndex = -1;
     }
 }
コード例 #7
0
ファイル: ordersWindow.cs プロジェクト: shreya2211/RMS2
 private void ordersWindow_Load(object sender, EventArgs e)
 {
     RetrivalData.loadItems("st_getMenu", itemListBox, "Menu Name", "Menu ID");
     RetrivalData.loadItems("st_getMenu", itemDD, "Menu Name", "Menu ID");
     itemDD.SelectedIndex = -1;
     RetrivalData.loadItems("st_getFloors", floorDD, "Floor", "ID");
     floorDD.SelectedIndex = -1;
 }
コード例 #8
0
 private void phoneTxt_Leave(object sender, EventArgs e)
 {
     if (phoneTxt.Text != "")
     {
         RetrivalData.getOrderBill(phoneTxt.Text, dataGridView1, ItemGV, QuantGV, amountGV, orderIDGV, totalAmountGV);
         BillLabel.Text  = Math.Round(Convert.ToDouble(dataGridView1.Rows[0].Cells["totalAmountGV"].Value.ToString()), 0).ToString();
         orderidTxt.Text = dataGridView1.Rows[0].Cells["orderIDGV"].Value.ToString();
     }
 }
コード例 #9
0
 private void orderCompletionWindow_Load(object sender, EventArgs e)
 {
     dataGridView1.AutoGenerateColumns = false;
     RetrivalData.loadItems("st_getFloors", floorDD, "Floor", "ID");
     floorDD.SelectedIndex    = -1;
     dataGridView1.DataSource = null;
     BillLabel.Text           = "";
     orderidTxt.Text          = "";
 }
コード例 #10
0
 private void tableDD_SelectedIndexChanged(object sender, EventArgs e)
 {
     if (tableDD.SelectedIndex != -1)
     {
         RetrivalData.getOrderBill(Convert.ToInt32(tableDD.SelectedValue.ToString()), dataGridView1, ItemGV, QuantGV, amountGV, orderIDGV, totalAmountGV);
         BillLabel.Text  = Math.Round(Convert.ToDouble(dataGridView1.Rows[0].Cells["totalAmountGV"].Value.ToString()), 0).ToString();
         orderidTxt.Text = dataGridView1.Rows[0].Cells["orderIDGV"].Value.ToString();
     }
 }
コード例 #11
0
ファイル: ordersWindow.cs プロジェクト: shreya2211/RMS2
 private void tableDD_SelectedIndexChanged(object sender, EventArgs e)
 {
     if (tableDD.SelectedIndex != -1)
     {
         if (RetrivalData.CheckTableStatus(Convert.ToInt32(tableDD.SelectedValue.ToString()), Convert.ToInt16(floorDD.SelectedValue.ToString())))
         {
             tableDD.SelectedIndex = -1;
         }
     }
 }
コード例 #12
0
 private void floorDD_SelectedIndexChanged(object sender, EventArgs e)
 {
     if (floorDD.SelectedIndex != -1)
     {
         RetrivalData.loadItems("st_getTablesWRTfloor", tableDD, "Table Number", "Table ID", "@floorID", Convert.ToInt32(floorDD.SelectedValue.ToString()));
         tableDD.SelectedIndex    = -1;
         dataGridView1.DataSource = null;
         BillLabel.Text           = "";
         orderidTxt.Text          = "";
         paidTxt.Text             = "";
         retrunedTXt.Text         = "";
     }
 }
コード例 #13
0
 public override void deletebtn_Click(object sender, EventArgs e)
 {
     if (delStatus == 1)
     {
         DialogResult dr = MessageBox.Show("Want to delete this record?", "Question.", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
         if (dr == DialogResult.Yes)
         {
             Deletion.deleteData("st_deleteUsers", "@userID", userID);
             MainClass.resetDisable(leftpanel);
             RetrivalData.getUsers(dataGridView1, userIDGV, NameGV, usernameGV, passGV, phoneGV, addressGV, RoleIDGV, RoleGV);
         }
     }
 }
コード例 #14
0
ファイル: FloorsWindow.cs プロジェクト: shreya2211/RMS2
 public override void deletebtn_Click(object sender, EventArgs e)
 {
     if (delStatus == 1)
     {
         DialogResult dr = MessageBox.Show("Want to delete this record?", "Question.", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
         if (dr == DialogResult.Yes)
         {
             Deletion.deleteData("st_deleteFloor", "@floorID", floorID);
             MainClass.resetDisable(leftpanel);
             RetrivalData.getFloors(dataGridView1, floorIDGV, floorNameGV, floorNumberGV);
         }
     }
 }
コード例 #15
0
 public override void deletebtn_Click(object sender, EventArgs e)
 {
     if (delStatus == 1)
     {
         DialogResult dr = MessageBox.Show("Want to delete this record?", "Question.", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
         if (dr == DialogResult.Yes)
         {
             Deletion.deleteData("st_deleteMenuItem", "@menuID", menuID);
             MainClass.resetDisable(leftpanel);
             RetrivalData.getMenu(dataGridView1, catIDGV, catGV, MenuItemGV, menuIDGV, priceGV, StatusGV);
         }
     }
 }
コード例 #16
0
 private void phoneTxt_Leave(object sender, EventArgs e)
 {
     try
     {
         if (phoneTxt.Text != "")
         {
             RetrivalData.getOrderBill(phoneTxt.Text, dataGridView1, ItemGV, QuantGV, amountGV, orderIDGV, totalAmountGV);
             BillLabel.Text  = Math.Round(Convert.ToDouble(dataGridView1.Rows[0].Cells["totalAmountGV"].Value.ToString()), 0).ToString();
             orderidTxt.Text = dataGridView1.Rows[0].Cells["orderIDGV"].Value.ToString();
         }
     }
     catch (Exception)
     {
         MainClass.showMessage("No order found", "error");
     }
 }
コード例 #17
0
ファイル: ordersWindow.cs プロジェクト: shreya2211/RMS2
        private void insertOrderDetails()
        {
            Int64 orderID = RetrivalData.lastOrderID();
            int   count   = 0;

            foreach (DataGridViewRow row in dataGridView1.Rows)
            {
                count += insertion.insertOrderDetails(orderID, Convert.ToInt32(row.Cells["itemIDGV"].Value.ToString()), Convert.ToInt16(row.Cells["QuantityGV"].Value.ToString()));
            }
            if (count > 0)
            {
            }
            else
            {
                MainClass.showMessage("An Error Occured", "error");
            }
        }
コード例 #18
0
ファイル: ordersWindow.cs プロジェクト: shreya2211/RMS2
 private void phonetxt_Leave(object sender, EventArgs e)
 {
     if (phonetxt.Text != "")
     {
         PhoneEL.Visible = false;
         custID          = RetrivalData.getCustIDwrtPhone(phonetxt.Text);
         if (custID == 0)
         {
             customersWindow cw = new customersWindow();
             MainClass.showWindow(cw, this, MDI.ActiveForm);
         }
         else
         {
             MainClass.showMessage(RetrivalData.CUSTOMER + "\n" + RetrivalData.ADDRESS + "\n", "success");
         }
     }
 }
コード例 #19
0
 private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
 {
     if (e.RowIndex != -1 && e.ColumnIndex != -1)
     {
         DataGridViewRow row = dataGridView1.Rows[e.RowIndex];
         orderID = Convert.ToInt64(row.Cells["orderIDGV"].Value.ToString());
         RetrivalData.getPendingOrderdetails(orderID, dataGridView2, productGV, quantityGV);
         MainClass.sno(dataGridView1, "snoGV");
         if (e.ColumnIndex == 3)
         {
             DialogResult dr = MessageBox.Show("Are you sure?", "Question..", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
             if (dr == DialogResult.Yes)
             {
                 Updates.updateOrderStatus(orderID, 1);
                 RetrivalData.getPendingOrders(dataGridView1, orderIDGV, statusGV);
                 MainClass.sno(dataGridView1, "snoGV");
             }
         }
     }
 }
コード例 #20
0
 public override void savebtn_Click(object sender, EventArgs e)
 {
     if (MainClass.checkControls(leftpanel).Count == 0)
     {
         if (edit == 0)//save
         {
             insertion.insertCategory(categoryTxt.Text);
             MainClass.resetDisable(leftpanel);
             RetrivalData.getCategory(dataGridView1, catIDGV, catGV);
         }
         else if (edit == 1)//update
         {
             Updates.updateCategory(categoryTxt.Text, catID);
             MainClass.resetDisable(leftpanel);
             RetrivalData.getCategory(dataGridView1, catIDGV, catGV);
         }
     }
     else
     {
         MessageBox.Show("Please enter all required fields");
     }
 }
コード例 #21
0
 public override void savebtn_Click(object sender, EventArgs e)
 {
     if (MainClass.checkControls(leftpanel).Count == 0)
     {
         if (edit == 0)//save
         {
             insertion.insertUsers(userTxt.Text, usernameTxt.Text, passwordTxt.Text, addressTxt.Text, phoneTxt.Text, Convert.ToInt16(rolesDD.SelectedValue.ToString()));
             MainClass.resetDisable(leftpanel);
             RetrivalData.getUsers(dataGridView1, userIDGV, NameGV, usernameGV, passGV, phoneGV, addressGV, RoleIDGV, RoleGV);
         }
         else if (edit == 1)//update
         {
             Updates.updateUsers(userID, userTxt.Text, usernameTxt.Text, passwordTxt.Text, addressTxt.Text, phoneTxt.Text, Convert.ToInt16(rolesDD.SelectedValue.ToString()));
             MainClass.resetDisable(leftpanel);
             RetrivalData.getUsers(dataGridView1, userIDGV, NameGV, usernameGV, passGV, phoneGV, addressGV, RoleIDGV, RoleGV);
         }
     }
     else
     {
         MessageBox.Show("Please enter all required fiels");
     }
 }
コード例 #22
0
 public override void savebtn_Click(object sender, EventArgs e)
 {
     if (MainClass.checkControls(leftpanel).Count == 0)
     {
         if (edit == 0)//save
         {
             insertion.insertCustomer(nameTxt.Text, phoneTxt.Text, addressTxt.Text);
             MainClass.resetDisable(leftpanel);
             RetrivalData.getCustomer(dataGridView1, custIDGV, NameGV, phoneGV, addressGV);
         }
         else if (edit == 1)//update
         {
             Updates.updateCustomer(custID, nameTxt.Text, phoneTxt.Text, addressTxt.Text);
             MainClass.resetDisable(leftpanel);
             RetrivalData.getCustomer(dataGridView1, custIDGV, NameGV, phoneGV, addressGV);
         }
     }
     else
     {
         MessageBox.Show("Please enter all required fiels");
     }
 }
コード例 #23
0
ファイル: FloorsWindow.cs プロジェクト: shreya2211/RMS2
 public override void savebtn_Click(object sender, EventArgs e)
 {
     if (MainClass.checkControls(leftpanel).Count == 0)
     {
         if (edit == 0)//save
         {
             insertion.insertFloors(floorTxt.Text, Convert.ToInt16(floorNumberDD.SelectedItem.ToString()));
             MainClass.resetDisable(leftpanel);
             RetrivalData.getFloors(dataGridView1, floorIDGV, floorNameGV, floorNumberGV);
         }
         else if (edit == 1)//update
         {
             Updates.updateFloors(floorID, floorTxt.Text, Convert.ToInt16(floorNumberDD.SelectedItem.ToString()));
             MainClass.resetDisable(leftpanel);
             RetrivalData.getFloors(dataGridView1, floorIDGV, floorNameGV, floorNumberGV);
         }
     }
     else
     {
         MessageBox.Show("Please enter all required fields");
     }
 }
コード例 #24
0
        public override void savebtn_Click(object sender, EventArgs e)
        {
            if (MainClass.checkControls(leftpanel).Count == 0)
            {
                short status = statusDD.SelectedItem == "Available" ? Convert.ToInt16(1) : Convert.ToInt16(0);

                if (edit == 0)//save
                {
                    insertion.insertMenuItem(itemTxt.Text, Convert.ToSingle(priceTxt.Text), Convert.ToInt32(categoryDD.SelectedValue.ToString()), status);
                    MainClass.resetDisable(leftpanel);
                    RetrivalData.getMenu(dataGridView1, catIDGV, catGV, MenuItemGV, menuIDGV, priceGV, StatusGV);
                }
                else if (edit == 1)//update
                {
                    Updates.updateMenuItem(menuID, itemTxt.Text, Convert.ToSingle(priceTxt.Text), Convert.ToInt32(categoryDD.SelectedValue.ToString()), status);
                    MainClass.resetDisable(leftpanel);
                    RetrivalData.getMenu(dataGridView1, catIDGV, catGV, MenuItemGV, menuIDGV, priceGV, StatusGV);
                }
            }
            else
            {
                MessageBox.Show("Please enter all required fields");
            }
        }
コード例 #25
0
 private void TablesWindow_Load(object sender, EventArgs e)
 {
     RetrivalData.loadItems("st_getFloors", floorNumberDD, "Floor", "ID");
     floorNumberDD.SelectedIndex = -1;
 }
コード例 #26
0
 private void usersWindow_Load(object sender, EventArgs e)
 {
     RetrivalData.loadItems("st_getRoles", rolesDD, "Role", "RoleID");
     rolesDD.SelectedIndex  = -1;
     roleErrorLabel.Visible = false;
 }
コード例 #27
0
 public override void viewbtn_Click(object sender, EventArgs e)
 {
     RetrivalData.getUsers(dataGridView1, userIDGV, NameGV, usernameGV, passGV, phoneGV, addressGV, RoleIDGV, RoleGV);
 }
コード例 #28
0
 public override void viewbtn_Click(object sender, EventArgs e)
 {
     RetrivalData.getCategory(dataGridView1, catIDGV, catGV);
 }
コード例 #29
0
ファイル: FloorsWindow.cs プロジェクト: shreya2211/RMS2
 public override void viewbtn_Click(object sender, EventArgs e)
 {
     RetrivalData.getFloors(dataGridView1, floorIDGV, floorNameGV, floorNumberGV);
 }
コード例 #30
0
 public override void viewbtn_Click(object sender, EventArgs e)
 {
     RetrivalData.getTables(dataGridView1, floorIDGV, floorNameGV, TableNumberGV, tableIDGV, ChairsGV);
 }