コード例 #1
0
        private void matDuplicateCheck()
        {
            string fName = "";

            sqlcon userConnect = new sqlcon();

            userConnect.dbIn();
            SqlCommand    cmd  = new SqlCommand("[CheckMtrlDup_MML] '" + metroTextBox3.Text + "'", sqlcon.con);
            SqlDataReader dr   = cmd.ExecuteReader();
            int           user = 0;

            while (dr.Read())
            {
                user += 1;
                fName = dr["MaterialName"].ToString();
            }
            userConnect.dbOut();
            if (fName.ToUpper() == metroTextBox3.Text.ToUpper())
            {
                metroButton1.Enabled = false;
                DesktopAlert.Show("Material already Exist");
                metroLabel6.Text = "";
            }
            else
            {
                metroButton1.Enabled = true;
            }
        }
コード例 #2
0
        private void uploadwithImage()
        {
            string Con  = Properties.Settings.Default.Database.ToString() + ".[dbo].Final_Sold_Goods ";
            string con3 = Con.Replace(" ", "");

            sqlcon userConnect1 = new sqlcon();

            userConnect1.dbIn();
            SqlCommand soldFinishGood = new SqlCommand("[receivedGoods]", sqlcon.calc);

            soldFinishGood.CommandType = System.Data.CommandType.StoredProcedure;
            soldFinishGood.Parameters.AddWithValue("@userID", globalVar.x.ToString());
            soldFinishGood.Parameters.AddWithValue("@emp2", globalVar.name.ToString());
            soldFinishGood.Parameters.AddWithValue("@emp", metroLabel13.Text);
            soldFinishGood.Parameters.AddWithValue("@fGcode", metroLabel6.Text);
            soldFinishGood.ExecuteNonQuery();
            userConnect1.dbOut();

            sqlcon userConnect = new sqlcon();

            userConnect.dbIn();
            //SqlCommand cmd = new SqlCommand("[userIDdetect] '" + metroTextBox1.Text + "'", sqlcon.con);
            SqlCommand    cmd = new SqlCommand("UPDATE " + con3.ToString() + " SET [image] = (SELECT BulkColumn FROM Openrowset( Bulk '" + imgloc.ToString() + "', Single_Blob) as img) WHERE FGCode = '" + metroLabel6.Text + "'", sqlcon.calc);
            SqlDataReader dr  = cmd.ExecuteReader();

            userConnect.dbOut();
            displayReports();
            slidePanel1.IsOpen = false;
            DesktopAlert.Show("Item has been sold");
            metroTabControl1.Enabled = true;
            pictureBox1.Image        = null;
        }
コード例 #3
0
 private void addNewMaterial()
 {
     try
     {
         sqlcon userConnect = new sqlcon();
         userConnect.dbIn();
         SqlCommand newMat = new SqlCommand("[addItemMMML]", sqlcon.calc);
         newMat.CommandType = System.Data.CommandType.StoredProcedure;
         newMat.Parameters.AddWithValue("@matID", metroLabel6.Text);
         newMat.Parameters.AddWithValue("@matName", metroTextBox3.Text);
         newMat.Parameters.AddWithValue("@matDesc", metroTextBox4.Text);
         newMat.Parameters.AddWithValue("@minStock", metroTextBox5.Text);
         newMat.Parameters.AddWithValue("@employe", globalVar.name.ToString());
         newMat.Parameters.AddWithValue("@price", metroTextBox1.Text);
         newMat.Parameters.AddWithValue("@userID", globalVar.x.ToString());
         newMat.ExecuteNonQuery();
         userConnect.dbOut();
         DesktopAlert.Show("New material has been added.");
         Form1 updateList = new Form1();
         updateList.notifDsply();
         updateList.notifIcon();
         metroTextBox1.Text = "";
         metroTextBox3.Text = "";
         metroTextBox4.Text = "";
         metroTextBox5.Text = "";
         metroLabel6.Text   = "";
         displayMaterialView();
     }
     catch
     {
         DesktopAlert.Show("Please check your Inputs!");
     }
 }
コード例 #4
0
        private void pinCheck()
        {
            int    user        = 0;
            sqlcon userConnect = new sqlcon();

            userConnect.dbIn();
            SqlCommand    cmd = new SqlCommand("[resetPasswords2] '" + metroLabel2.Text + "'", sqlcon.con);
            SqlDataReader dr  = cmd.ExecuteReader();

            while (dr.Read())
            {
                user += 1;
                globalVar.pinCode = dr["pinCode"].ToString();
            }
            userConnect.dbOut();
            if (globalVar.pinCode == metroTextBox1.Text)
            {
                slidePanel2.IsOpen = true;
                slidePanel1.IsOpen = false;
            }
            else
            {
                DesktopAlert.Show("PIN code does not match");
            }
        }
コード例 #5
0
 public void soldFinishGood()
 {
     try
     {
         foreach (DataGridViewRow item in metroGrid2.Rows)
         {
             if (bool.Parse(item.Cells[0].Value.ToString()))
             {
                 sqlcon userConnect = new sqlcon();
                 userConnect.dbIn();
                 SqlCommand soldFinishGood = new SqlCommand("[materialOut]", sqlcon.calc);
                 soldFinishGood.CommandType = System.Data.CommandType.StoredProcedure;
                 soldFinishGood.Parameters.AddWithValue("@userID", item.Cells[5].Value.ToString());
                 soldFinishGood.Parameters.AddWithValue("@fGcode", item.Cells[1].Value.ToString());
                 soldFinishGood.Parameters.AddWithValue("@addBy", globalVar.name.ToString());
                 soldFinishGood.ExecuteNonQuery();
                 userConnect.dbOut();
                 metroTextBox1.Text = "";
             }
         }
     }
     catch
     {
         return;
     }
     recentSolds();
     reloadChkBox();
 }
コード例 #6
0
        private void productExistCheck() //Check for product existence....
        {
            string pName       = "";
            sqlcon userConnect = new sqlcon();

            userConnect.dbIn();
            SqlCommand    cmd  = new SqlCommand("[chkFGProductsDup] '" + metroTextBox2.Text + "'", sqlcon.calc);
            SqlDataReader dr   = cmd.ExecuteReader();
            int           user = 0;

            while (dr.Read())
            {
                user += 1;
                pName = dr["productName"].ToString();
            }
            userConnect.dbOut();
            if (pName.ToUpper() == metroTextBox2.Text.ToUpper() &&
                metroTextBox2.Text != string.Empty)
            {
                metroButton1.Enabled = false;
                DesktopAlert.Show("Already Exist");
            }
            else
            {
                metroButton1.Enabled = true;
            }
        }
コード例 #7
0
 private void metroButton2_Click(object sender, EventArgs e)
 {
     try
     {
         foreach (DataGridViewRow item in metroGrid2.Rows)
         {
             sqlcon userConnect = new sqlcon();
             userConnect.dbIn();
             SqlCommand material = new SqlCommand("[voidClient]", sqlcon.calc);
             material.CommandType = System.Data.CommandType.StoredProcedure;
             material.Parameters.AddWithValue("@name", item.Cells[1].Value.ToString());
             if (item.Cells[0].Value.Equals("Enable"))
             {
                 material.Parameters.AddWithValue("@void", "N");
             }
             else if (item.Cells[0].Value.Equals("Disable"))
             {
                 material.Parameters.AddWithValue("@void", "Y");
             }
             material.ExecuteNonQuery();
             userConnect.dbOut();
         }
     }
     catch { return; }
     displayClients();
     statusCheck();
 }
コード例 #8
0
        private void listOfProduct()
        {
            try
            {
                sqlcon userConnect = new sqlcon();
                userConnect.dbIn();
                SqlDataAdapter da = new SqlDataAdapter("exec [productList]", sqlcon.con);
                DataTable      dt = new DataTable();
                da.Fill(dt);
                metroComboBox4.DataSource = dt;
                //metroComboBox3.DisplayMember = "ClientName";

                dt.Columns.Add("ID", typeof(int));
                metroComboBox4.DisplayMember = "Products";
                metroComboBox4.ValueMember   = "ID";
                metroComboBox4.DataSource    = dt;

                DataRow dr = dt.NewRow();
                dr["Products"] = "All";


                dt.Rows.InsertAt(dr, 0);
                metroComboBox4.SelectedIndex = 0;

                userConnect.dbOut();
            }
            catch { }
        }
コード例 #9
0
        private void searchUser() //Display User details in textboxes..in slidepanel
        {
            sqlcon userConnect = new sqlcon();

            userConnect.dbIn();
            SqlCommand    cmd = new SqlCommand("[findUser] '" + metroLabel12.Text + "'", sqlcon.con);
            SqlDataReader dr  = cmd.ExecuteReader();

            while (dr.Read())
            {
                metroTextBox11.Text = dr["FirstName"].ToString();
                metroTextBox10.Text = dr["LastName"].ToString();
                metroTextBox9.Text  = dr["passkey"].ToString();
                metroComboBox6.Text = dr["position"].ToString();
                metroComboBox5.Text = dr["Gender"].ToString();
                if (dr["Employeestatus"].ToString() == "Activated")
                {
                    metroCheckBox1.CheckState = CheckState.Checked;
                }
                else
                {
                    metroCheckBox1.CheckState = CheckState.Unchecked;
                }
            }
            userConnect.dbOut();
        }
コード例 #10
0
        private void modifyAcct()
        {
            string stat = "";

            if (metroCheckBox1.CheckState == CheckState.Checked)
            {
                stat = "Activated";
            }
            else
            {
                stat = "Deactivated";
            }
            sqlcon userConnect = new sqlcon();

            userConnect.dbIn();
            SqlCommand modify = new SqlCommand("modifyAcct", sqlcon.con);

            modify.CommandType = System.Data.CommandType.StoredProcedure;
            modify.Parameters.AddWithValue("@FirstName", metroTextBox11.Text);
            modify.Parameters.AddWithValue("@LastName", metroTextBox10.Text);
            modify.Parameters.AddWithValue("@passkey", metroTextBox9.Text);
            modify.Parameters.AddWithValue("@position", metroComboBox6.Text);
            modify.Parameters.AddWithValue("@Gender", metroComboBox5.Text);
            modify.Parameters.AddWithValue("@status", stat);
            modify.Parameters.AddWithValue("@userID", metroLabel12.Text);
            modify.ExecuteNonQuery();
            userConnect.dbOut();
        }
コード例 #11
0
        private void todayEvent()
        {
            sqlcon userConnect = new sqlcon();

            userConnect.dbIn();
            SqlCommand    cmd = new SqlCommand("[todaysEvent]", sqlcon.con);
            SqlDataReader dr  = cmd.ExecuteReader();


            while (dr.Read())
            {
                metroLabel20.Text = "Php. " + dr["sales"].ToString();
                metroLabel19.Text = "Php. " + dr["Purchases"].ToString();
                metroLabel16.Text = "Php. " + dr["equals"].ToString();
            }
            userConnect.dbOut();

            sqlcon userConnect2 = new sqlcon();

            userConnect2.dbIn();
            SqlCommand    cmd2 = new SqlCommand("[weekEvent]", sqlcon.con);
            SqlDataReader dr2  = cmd2.ExecuteReader();


            while (dr2.Read())
            {
                metroLabel6.Text = "Php. " + dr2["sales"].ToString();
                metroLabel3.Text = "Php. " + dr2["Purchases"].ToString();
                metroLabel7.Text = "Php. " + dr2["equals"].ToString();
            }
            userConnect2.dbOut();
        }
コード例 #12
0
        private void userExistCheck() //Check for  user existence....
        {
            string fName       = "";
            string lName       = "";
            sqlcon userConnect = new sqlcon();

            userConnect.dbIn();
            SqlCommand    cmd  = new SqlCommand("[CheckDuplicates] '" + metroTextBox1.Text + "'", sqlcon.con);
            SqlDataReader dr   = cmd.ExecuteReader();
            int           user = 0;

            while (dr.Read())
            {
                user += 1;
                fName = dr["FirstName"].ToString();
                lName = dr["LastName"].ToString();
            }
            userConnect.dbOut();
            if (fName.ToUpper() == metroTextBox1.Text.ToUpper() && lName.ToUpper() == metroTextBox2.Text.ToUpper() &&
                metroTextBox1.Text != string.Empty && metroTextBox2.Text != string.Empty)
            {
                metroButton1.Enabled = false;
                DesktopAlert.Show("Already Exist");
            }
            else
            {
                metroButton1.Enabled = true;
            }
        }
コード例 #13
0
        private void metroGrid1_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            var rowsCount = metroGrid1.SelectedRows.Count;

            if (rowsCount == 0 || rowsCount > 1)
            {
                return;
            }
            metroLabel1.Text = metroGrid1.SelectedCells[0].Value.ToString();

            sqlcon userConnect = new sqlcon();

            userConnect.dbIn();
            SqlCommand    cmd = new SqlCommand("[imageReceipt] '" + metroLabel1.Text + "'", sqlcon.con);
            SqlDataReader dr  = cmd.ExecuteReader();

            while (dr.Read())
            {
                byte[]       img = (byte[])(dr[0]);
                MemoryStream ms  = new MemoryStream(img);
                pictureBox1.Image = Image.FromStream(ms);
            }

            userConnect.dbOut();
        }
コード例 #14
0
        private void metroTextButton1_Click(object sender, EventArgs e)
        {
            sqlcon userConnect = new sqlcon();

            userConnect.dbIn();
            SqlCommand addClient = new SqlCommand("[modifyClient]", sqlcon.con);

            addClient.CommandType = System.Data.CommandType.StoredProcedure;
            addClient.Parameters.AddWithValue("@clientName", metroLabel11.Text);
            addClient.Parameters.AddWithValue("@newClientName", metroTextBox10.Text);
            addClient.Parameters.AddWithValue("@description", metroTextBox9.Text);
            addClient.Parameters.AddWithValue("@Fname", metroTextBox16.Text);
            addClient.Parameters.AddWithValue("@Mname", metroTextBox15.Text);
            addClient.Parameters.AddWithValue("@Lname", metroTextBox14.Text);
            addClient.Parameters.AddWithValue("@address", metroTextBox1.Text);
            addClient.Parameters.AddWithValue("@contactNumber", metroTextBox8.Text);
            addClient.Parameters.AddWithValue("@emailAddress", metroTextBox2.Text);
            addClient.Parameters.AddWithValue("@user", globalVar.name.ToString());
            addClient.ExecuteNonQuery();
            userConnect.dbOut();
            displayClients();
            slidePanel2.SlideSide = eSlideSide.Right;
            slidePanel2.IsOpen    = false;
            metroGrid2.Enabled    = true;
        }
コード例 #15
0
 private void metroButton2_Click(object sender, EventArgs e)
 {
     try
     {
         DialogResult dialogResult = MetroMessageBox.Show(this, "Materials Received?", "Purchased Material", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
         if (dialogResult == DialogResult.Yes)
         {
             foreach (DataGridViewRow item2 in metroGrid1.Rows)
             {
                 if (bool.Parse(item2.Cells[0].Value.ToString()))
                 {
                     sqlcon userConnect = new sqlcon();
                     userConnect.dbIn();
                     SqlCommand material = new SqlCommand("[materialINChckBox]", sqlcon.calc);
                     material.CommandType = System.Data.CommandType.StoredProcedure;
                     material.Parameters.AddWithValue("@employee", globalVar.name.ToString());
                     material.Parameters.AddWithValue("@id", item2.Cells[1].Value.ToString());
                     material.ExecuteNonQuery();
                     userConnect.dbOut();
                 }
             }
         }
     }
     catch
     {
         return;
     }
     tempTableOrderIN();
     reloadChkBox();
 }
コード例 #16
0
 private void metroTextButton1_Click(object sender, EventArgs e)
 {
     try
     {
         sqlcon userConnect = new sqlcon();
         userConnect.dbIn();
         SqlCommand material = new SqlCommand("[modifyFormulaDetails]", sqlcon.calc);
         material.CommandType = System.Data.CommandType.StoredProcedure;
         material.Parameters.AddWithValue("@matName", metroTextBox5.Text);
         material.Parameters.AddWithValue("@DESC", metroTextBox6.Text);
         material.Parameters.AddWithValue("@amt", metroTextBox7.Text);
         material.Parameters.AddWithValue("@PKG", metroTextBox8.Text);
         material.Parameters.AddWithValue("@user", globalVar.name.ToString());
         material.Parameters.AddWithValue("@fglook", metroLabel6.Text);
         material.ExecuteNonQuery();
         userConnect.dbOut();
         displayFormula();
         DesktopAlert.AutoCloseTimeOut = 3;
         textBoxX1.Text = null; metroTextBox11.Text = null; DesktopAlert.Show("Details has been updated!");
     }
     catch
     {
         DesktopAlert.Show("Please check your inputs!");
     }
 }
コード例 #17
0
 private void metroButton3_Click(object sender, EventArgs e)
 {
     try
     {
         foreach (DataGridViewRow item in metroGrid1.Rows)
         {
             sqlcon userConnect = new sqlcon();
             userConnect.dbIn();
             SqlCommand material = new SqlCommand("[voidFormula]", sqlcon.calc);
             material.CommandType = System.Data.CommandType.StoredProcedure;
             material.Parameters.AddWithValue("@name", item.Cells[1].Value.ToString());
             if (bool.Parse(item.Cells[0].Value.ToString()))
             {
                 material.Parameters.AddWithValue("@void", "Y");
             }
             else
             {
                 material.Parameters.AddWithValue("@void", "N");
             }
             material.ExecuteNonQuery();
             userConnect.dbOut();
         }
     }
     catch
     {
         return;
     }
     displayFormula();
     reloadChkBox();
 }
コード例 #18
0
        private void matExistCheck() //Check for material existence....
        {
            string matMame = "";
            string formula = "";

            sqlcon userConnect = new sqlcon();

            userConnect.dbIn();
            SqlCommand    cmd  = new SqlCommand("[CheckMtrlDup_formula] '" + textBoxX1.Text + "','" + metroLabel6.Text + "'", sqlcon.con);
            SqlDataReader dr   = cmd.ExecuteReader();
            int           user = 0;

            while (dr.Read())
            {
                user   += 1;
                matMame = dr["Material"].ToString();
                formula = dr["formulaName"].ToString();
            }
            userConnect.dbOut();
            if (user >= 1)
            {
                metroTextButton2.Enabled = false;
                DesktopAlert.Show("Already Exist");
            }
            else
            {
                metroTextButton2.Enabled = true;
            }
        }
コード例 #19
0
        private void metroButton5_Click(object sender, EventArgs e)
        {
            try
            {
                sqlcon userConnect = new sqlcon();
                userConnect.dbIn();
                foreach (DataGridViewRow item in metroGrid3.Rows)
                {
                    if (bool.Parse(item.Cells[0].Value.ToString()))
                    {
                        SqlCommand material = new SqlCommand("[deletePosition]", sqlcon.calc);
                        material.CommandType = System.Data.CommandType.StoredProcedure;
                        material.Parameters.AddWithValue("@position", item.Cells[1].Value.ToString());
                        material.Parameters.AddWithValue("@stat", "Y");
                        material.Parameters.AddWithValue("@addBy", globalVar.name.ToString());
                        material.ExecuteNonQuery();
                    }
                    //else
                    //{

                    //    SqlCommand material = new SqlCommand("[deletePosition]", sqlcon.calc);
                    //    material.CommandType = System.Data.CommandType.StoredProcedure;
                    //    material.Parameters.AddWithValue("@position", item.Cells[1].Value.ToString());
                    //    material.Parameters.AddWithValue("@stat", "N");
                    //    material.ExecuteNonQuery();

                    //}
                }
                userConnect.dbOut();
            }
            catch { return; }
            displayUsers2();
            reloadChkBox();
            DesktopAlert.Show("Position has been updated!");
        }
コード例 #20
0
        private void BAndR()
        {
            try
            {
                sqlcon userConnect = new sqlcon();
                userConnect.dbIn();
                SqlDataAdapter da = new SqlDataAdapter("exec [DBBASE]", sqlcon.con);
                DataTable      dt = new DataTable();
                da.Fill(dt);
                metroComboBox1.DataSource    = dt;
                metroComboBox1.DisplayMember = "name";
                DataTable mod = new DataTable();

                userConnect.dbOut();


                metroButton3.Enabled = true;

                metroComboBox1.Enabled = true;
            }
            catch (Exception ex)
            {
                //MessageBox.Show(ex.Message);
                DesktopAlert.Show(ex.Message);
            }
        }
コード例 #21
0
        private void listOfUser()   //provide the client list for combobox
        {
            try
            {
                metroComboBox2.Items.Insert(0, "all");
                metroComboBox2.Items.Add("All");
                sqlcon userConnect = new sqlcon();
                userConnect.dbIn();
                SqlDataAdapter da = new SqlDataAdapter("exec [userList]", sqlcon.con);
                DataTable      dt = new DataTable();
                da.Fill(dt);

                dt.Columns.Add("ID", typeof(int));
                metroComboBox2.DisplayMember = "NAMES";
                metroComboBox2.ValueMember   = "ID";
                metroComboBox2.DataSource    = dt;

                DataRow dr = dt.NewRow();
                dr["NAMES"] = "All";
                dr["ID"]    = 0;

                dt.Rows.InsertAt(dr, 0);
                metroComboBox2.SelectedIndex = 0;
                userConnect.dbOut();
            }
            catch { }
        }
コード例 #22
0
        public void listOfClients()   //provide the client list for combobox
        {
            try
            {
                sqlcon userConnect = new sqlcon();
                userConnect.dbIn();
                SqlDataAdapter da = new SqlDataAdapter("exec [clientList]", sqlcon.con);
                DataTable      dt = new DataTable();
                da.Fill(dt);
                metroComboBox3.DataSource = dt;
                //metroComboBox3.DisplayMember = "ClientName";

                dt.Columns.Add("ID", typeof(int));
                metroComboBox3.DisplayMember = "ClientName";
                metroComboBox3.ValueMember   = "ID";
                metroComboBox3.DataSource    = dt;

                DataRow dr = dt.NewRow();
                dr["ClientName"] = "All";
                dr["ID"]         = 0;

                dt.Rows.InsertAt(dr, 0);
                metroComboBox3.SelectedIndex = 0;

                userConnect.dbOut();
            }
            catch { }
        }
コード例 #23
0
        private void autoSuggest()
        {
            AutoCompleteStringCollection namesCollection = new AutoCompleteStringCollection();
            SqlDataReader dReader;
            sqlcon        userConnect = new sqlcon();

            userConnect.dbIn();
            SqlCommand cmd = new SqlCommand("[materialsListCombo]", sqlcon.calc);

            cmd.CommandType = CommandType.Text;
            userConnect.dbIn();
            dReader = cmd.ExecuteReader();
            if (dReader.HasRows == true)
            {
                while (dReader.Read())
                {
                    namesCollection.Add(dReader["MaterialName"].ToString());
                }
            }
            else
            {
                DesktopAlert.Show("Data not found");
            }

            dReader.Close();
            userConnect.dbOut();
            textBoxX1.AutoCompleteMode         = AutoCompleteMode.SuggestAppend;
            textBoxX1.AutoCompleteSource       = AutoCompleteSource.CustomSource;
            textBoxX1.AutoCompleteCustomSource = namesCollection;
        }
コード例 #24
0
        private void metroButton3_Click_1(object sender, EventArgs e)
        {
            //bool.Parse(item.Cells[0].Value.ToString()) == true

            try
            {
                foreach (DataGridViewRow item in metroGrid1.Rows)
                {
                    if (bool.Parse(item.Cells[0].Value.ToString()))
                    {
                        sqlcon userConnect = new sqlcon();
                        userConnect.dbIn();
                        SqlCommand material = new SqlCommand("[delTempMaterials]", sqlcon.calc);
                        material.CommandType = System.Data.CommandType.StoredProcedure;
                        material.Parameters.AddWithValue("@id", item.Cells[2].Value.ToString());
                        material.ExecuteNonQuery();
                        userConnect.dbOut();
                    }
                }
            }
            catch
            {
                return;
            }
            tempTableOrderIN();
            reloadChkBox();
        }
コード例 #25
0
        private void tempsoldFinishGood()
        {
            sqlcon userConnect = new sqlcon();

            userConnect.dbIn();
            SqlCommand soldFinishGood = new SqlCommand("[TEMPmaterialOut]", sqlcon.calc);

            soldFinishGood.CommandType = System.Data.CommandType.StoredProcedure;
            soldFinishGood.Parameters.AddWithValue("@recipe", metroComboBox2.Text);
            soldFinishGood.Parameters.AddWithValue("@client", metroComboBox1.Text);
            soldFinishGood.Parameters.AddWithValue("@amount", metroTextBox1.Text);
            soldFinishGood.Parameters.AddWithValue("@employe", globalVar.name.ToString());
            soldFinishGood.Parameters.AddWithValue("@pricePerBag", metroLabel3.Text);
            soldFinishGood.Parameters.AddWithValue("@bagging", metroLabel12.Text);
            soldFinishGood.Parameters.AddWithValue("@userID", globalVar.x.ToString());
            soldFinishGood.Parameters.AddWithValue("@fGcode", metroLabel18.Text);
            //string result = "";

            //if (stat == "N") { result = "Pending"; }
            //else {result = "Proceed"; }
            //soldFinishGood.Parameters.AddWithValue("@stat", result.ToString());
            soldFinishGood.ExecuteNonQuery();
            userConnect.dbOut();
            metroTextBox1.Text      = "";
            DesktopAlert.AlertColor = eDesktopAlertColor.Green;
            DesktopAlert.Show("Item Has been added!");
            DesktopAlert.AutoCloseTimeOut = 3;
            reloadChkBox();
        }
コード例 #26
0
        private void modifyFormula()
        {
            sqlcon userConnect = new sqlcon();

            userConnect.dbIn();
            SqlCommand    material = new SqlCommand("[modifyFormula] '" + metroLabel19.Text + "','" + metroLabel6.Text + "','" + metroTextBox12.Text + "','" + globalVar.name + "'", sqlcon.calc);
            SqlDataReader dr       = material.ExecuteReader();

            userConnect.dbOut();
            displayFormula2();
            formulaTotalCheck();
        }
コード例 #27
0
        private void uploadToDB()
        {
            sqlcon userConnect = new sqlcon();

            userConnect.dbIn();
            SqlCommand material = new SqlCommand("[materialIN]", sqlcon.calc);

            material.CommandType = System.Data.CommandType.StoredProcedure;
            material.Parameters.AddWithValue("@employee", globalVar.name.ToString());;
            material.ExecuteNonQuery();
            userConnect.dbOut();
        }
コード例 #28
0
        public void listOfClients() //provide the client list for combobox
        {
            sqlcon userConnect = new sqlcon();

            userConnect.dbIn();
            SqlDataAdapter da = new SqlDataAdapter("exec [clientList]", sqlcon.con);
            DataTable      dt = new DataTable();

            da.Fill(dt);
            metroComboBox1.DataSource    = dt;
            metroComboBox1.DisplayMember = "ClientName";
            userConnect.dbOut();
        }
コード例 #29
0
        private void listOfFormulas() //provide the material list for combobox
        {
            sqlcon userConnect = new sqlcon();

            userConnect.dbIn();
            SqlDataAdapter da = new SqlDataAdapter("exec [listOfFormulas]", sqlcon.calc);
            DataTable      dt = new DataTable();

            da.Fill(dt);
            metroComboBox2.DataSource    = dt;
            metroComboBox2.DisplayMember = "FormulaName";
            userConnect.dbOut();
        }
コード例 #30
0
        private void clientNAme()
        {
            sqlcon userConnect = new sqlcon();

            userConnect.dbIn();
            SqlDataAdapter da = new SqlDataAdapter("exec [clientList]", sqlcon.calc);
            DataTable      dt = new DataTable();

            da.Fill(dt);
            metroComboBox2.DataSource    = dt;
            metroComboBox2.DisplayMember = "ClientName";
            userConnect.dbOut();
        }