using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace Supermarket
{
    public partial class Login : Form
    {
        public static string Sellername = "";
        public Login()
        {
            InitializeComponent();
        }

        SqlConnection Con = new SqlConnection(@"[Your Data Location]");
            
        //Login
        private void LoginButton_Click(object sender, EventArgs e)
        {
            if(UsernameTextbox.Text=="" || PasswordTextbox.Text=="")
            {
                MessageBox.Show("Please enter the Username and Password", "", MessageBoxButtons.OK, MessageBoxIcon.Warning);
            }

            else
            {
                if(ComboboxRole.SelectedItem.ToString()=="Admin")
                {
                    //Login Username: Admin Password: Admin
                    if(UsernameTextbox.Text=="Admin" && PasswordTextbox.Text=="Admin")
                    {
                        this.Hide();
                        ProductForm log = new ProductForm();
                        log.Show();
                    }

                    else
                    {
                        MessageBox.Show("Username or Password is wrong");
                    }
                }

                else if(ComboboxRole.SelectedItem.ToString()=="Seller")
                {
                    Con.Open();
                    SqlDataAdapter sda = new SqlDataAdapter("Select count(8) from SellerData where SellerName='"+UsernameTextbox.Text+ "' and SellerPass='" + PasswordTextbox.Text+"'", Con);
                    DataTable dt = new DataTable();
                    sda.Fill(dt);

                    if(dt.Rows[0][0].ToString() == "1")
                    {
                        Sellername = UsernameTextbox.Text;
                        SellingForm log = new SellingForm();
                        log.Show();
                        this.Hide();
                        Con.Close();
                    }

                    else
                    {
                        MessageBox.Show("Username or Password Wrong");
                    }
                }

                else
                {
                    MessageBox.Show("Please Choose Role First", "", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                }
            }
        }
    }
}