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

namespace Supermarket
{
    public partial class SellingForm : Form
    {
        public SellingForm()
        {
            InitializeComponent();
        }

        SqlConnection Con = new SqlConnection(@"[Your Data Location]");
        
        private void populate()
        {
            Con.Open();
            string query = "SELECT ProductName, ProductQuantity FROM ProductData";
            SqlDataAdapter sda = new SqlDataAdapter(query, Con);
            SqlCommandBuilder builder = new SqlCommandBuilder(sda);
            var ds = new DataSet();
            sda.Fill(ds);

            SellinglistproductDatagrid.DataSource = ds.Tables[0];
            Con.Close();
        }

        private void SellingForm_Load(object sender, EventArgs e)
        {
            populate();
            SellingDate.Text = DateTime.Today.Day.ToString() + "/" + DateTime.Today.Month.ToString() + "/" + DateTime.Today.Year.ToString();
            populatebill();
            SellingSellername.Text = Login.Sellername;
        }

        private void Logout1_Click(object sender, EventArgs e)
        {
            this.Hide();
            Login log = new Login();
            log.Show();
        }

        private void SellinglistproductDatagrid_CellContentClick_1(object sender, DataGridViewCellEventArgs e)
        {
            SellingProductname.Text = SellinglistproductDatagrid.SelectedRows[0].Cells[0].Value.ToString();
            SellingPrice.Text = "12000";
        }

        int Grdtotal = 0;
        int n = 0;
        private void SellingAddproduct_Click_1(object sender, EventArgs e)
        {
                int total = Convert.ToInt32(SellingPrice.Text) * Convert.ToInt32(SellingQuantity.Text);

                DataGridViewRow data = new DataGridViewRow();
                data.CreateCells(SellingproductDatagrid);
                data.Cells[0].Value = n + 1;
                data.Cells[1].Value = SellingProductname.Text;
                data.Cells[2].Value = SellingQuantity.Text;
                data.Cells[3].Value = Convert.ToInt32(SellingPrice.Text) * Convert.ToInt32(SellingQuantity.Text);
                SellingproductDatagrid.Rows.Add(data);
                Grdtotal = Grdtotal + total;
                SellingAmount.Text = " "+ Grdtotal;
                label6.Text = "Total Amount : " + "Rp ";
                n++;
       }

        private void populatebill()
        {
            Con.Open();
            string query = "SELECT * FROM BillData";
            SqlDataAdapter sda = new SqlDataAdapter(query, Con);
            SqlCommandBuilder builder = new SqlCommandBuilder(sda);
            var ds = new DataSet();
            sda.Fill(ds);

            SellingselllistDatagrid.DataSource = ds.Tables[0];
            Con.Close();
        }

        private void ListaddButton_Click(object sender, EventArgs e)
        {
            try
            {
                Con.Open();
                string query = "INSERT INTO BillData VALUES("+SellingBillId.Text+",'"+SellingSellername.Text+"','"+SellingDate.Text+"','"+SellingAmount.Text+"')";
                SqlCommand cmd = new SqlCommand(query, Con);
                cmd.ExecuteNonQuery();
                MessageBox.Show("Bill Data Added Successfully");
                Con.Close();
                populatebill();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

        private void ListdeleteButton_Click(object sender, EventArgs e)
        {
            try
            {
                Con.Open();
                string query = "DELETE FROM BillData WHERE BillId = " + SellingselllistDatagrid.SelectedRows[0].Cells[0].Value+"";
                SqlCommand cmd = new SqlCommand(query, Con);
                cmd.ExecuteNonQuery();
                MessageBox.Show("Bill Deleted Successfully");
                Con.Close();
                populatebill();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

        private void outbutton4_Click(object sender, EventArgs e)
        {
            Application.Exit();
        }
    }
}