private void allPaid() { sqlcon userConnect = new sqlcon(); userConnect.dbIn(); SqlCommand recipe = new SqlCommand("exec [paidGoods]", sqlcon.calc); SqlDataAdapter calculated = new SqlDataAdapter(); calculated.SelectCommand = recipe; DataTable dataSet = new DataTable(); calculated.Fill(dataSet); BindingSource nSource = new BindingSource(); nSource.DataSource = dataSet; metroGrid1.DataSource = nSource; calculated.Update(dataSet); userConnect.dbOut(); //reloadChkBox(); }
private void clientDetails() //Display User details in textboxes..in modifyTab { sqlcon userConnect = new sqlcon(); userConnect.dbIn(); SqlCommand cmd = new SqlCommand("[showClients] '" + metroLabel11.Text + "'", sqlcon.con); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { metroTextBox9.Text = dr["Description"].ToString(); metroTextBox1.Text = dr["Address"].ToString(); metroTextBox8.Text = dr["ContactNoumber"].ToString(); metroTextBox2.Text = dr["emailAdress"].ToString(); metroTextBox16.Text = dr["FirstName"].ToString(); metroTextBox15.Text = dr["MiddleName"].ToString(); metroTextBox14.Text = dr["LastName"].ToString(); } userConnect.dbOut(); }
private void recentSolds() { sqlcon userConnect = new sqlcon(); userConnect.dbIn(); SqlCommand recipe = new SqlCommand("exec materialOutView", sqlcon.calc); SqlDataAdapter calculated = new SqlDataAdapter(); calculated.SelectCommand = recipe; DataTable dataSet = new DataTable(); calculated.Fill(dataSet); BindingSource nSource = new BindingSource(); nSource.DataSource = dataSet; metroGrid2.DataSource = nSource; calculated.Update(dataSet); userConnect.dbOut(); reloadChkBox(); }
private void addClient() { sqlcon userConnect = new sqlcon(); userConnect.dbIn(); SqlCommand addClient = new SqlCommand("[addClient]", sqlcon.con); addClient.CommandType = System.Data.CommandType.StoredProcedure; addClient.Parameters.AddWithValue("@Cname", metroTextBox3.Text); addClient.Parameters.AddWithValue("@FirstName", metroTextBox4.Text); addClient.Parameters.AddWithValue("@MiddleName", metroTextBox11.Text); addClient.Parameters.AddWithValue("@LastName", metroTextBox12.Text); addClient.Parameters.AddWithValue("@Description", metroTextBox13.Text); addClient.Parameters.AddWithValue("@Address", metroTextBox5.Text); addClient.Parameters.AddWithValue("@ContactNo", metroTextBox6.Text); addClient.Parameters.AddWithValue("@EmailAdd", metroTextBox7.Text); addClient.Parameters.AddWithValue("@addBy", globalVar.name.ToString()); addClient.ExecuteNonQuery(); userConnect.dbOut(); displayClients(); }
private void computePrice() //Display price in metrotab11 { try { sqlcon userConnect = new sqlcon(); userConnect.dbIn(); SqlCommand cmd = new SqlCommand("exec [totalPriceFg] '" + metroTextBox1.Text + "','" + metroLabel5.Text + "','" + metroComboBox1.Text + "','" + metroLabel7.Text + "'", sqlcon.calc); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { metroLabel6.Text = dr["Presyo"].ToString(); } userConnect.dbOut(); } catch { DesktopAlert.Show("No Item yet!"); } }
private void changePass() { sqlcon userConnect = new sqlcon(); userConnect.dbIn(); SqlCommand modify = new SqlCommand("[ChangePW]", sqlcon.con); modify.CommandType = System.Data.CommandType.StoredProcedure; modify.Parameters.AddWithValue("@passkey", metroTextBox4.Text); modify.Parameters.AddWithValue("@newpass", metroTextBox5.Text); modify.Parameters.AddWithValue("@userID", globalVar.x.ToString()); modify.Parameters.AddWithValue("@name", globalVar.name.ToString()); modify.ExecuteNonQuery(); userConnect.dbOut(); DesktopAlert.Show("Password has been changed, please Log IN"); this.FormClosing -= new System.Windows.Forms.FormClosingEventHandler(this.Form1_FormClosing); this.Close(); loginForm lF = new loginForm(); lF.ShowDialog(); }
private void tempTableOrderIN() { sqlcon userConnect = new sqlcon(); userConnect.dbIn(); SqlCommand recipe = new SqlCommand("exec [tempTableOrderIN] '" + globalVar.name.ToString() + "'", sqlcon.calc); SqlDataAdapter calculated = new SqlDataAdapter(); calculated.SelectCommand = recipe; DataTable dataSet = new DataTable(); calculated.Fill(dataSet); BindingSource nSource = new BindingSource(); nSource.DataSource = dataSet; metroGrid1.DataSource = nSource; calculated.Update(dataSet); textBoxX1.Text = ""; metroTextBox1.Text = ""; userConnect.dbOut(); }
private void textBoxX1_TextChanged(object sender, EventArgs e) { //presyo(); if ((textBoxX1.Text.Length) == 1) { textBoxX1.Text = textBoxX1.Text[0].ToString().ToUpper(); textBoxX1.Select(2, 1); } int mat = 0; sqlcon userConnect = new sqlcon(); userConnect.dbIn(); SqlCommand cmd = new SqlCommand("[materialIDdetect] '" + textBoxX1.Text + "'", sqlcon.calc); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { mat += 1; } userConnect.dbOut(); if (textBoxX1.Text != "") { if (mat != 1) { metroButton1.Enabled = false; pictureBox2.Visible = true; } else if (mat == 1) { metroButton1.Enabled = true; pictureBox2.Visible = false; } } else { pictureBox2.Visible = false; } checkinput(); }
private void metroTile1_Click(object sender, EventArgs e) { Form1 fm1 = new Form1(); fm1.Hide(); sqlcon userOUT = new sqlcon(); userOUT.dbIn(); SqlCommand logOut = new SqlCommand("[timeLogoUT] '" + globalVar.x + "','" + globalVar.name + "'", sqlcon.con); SqlDataReader lO = logOut.ExecuteReader(); while (lO.Read()) { } this.Hide(); userOUT.dbOut(); fm1.Close(); Application.Exit(); loginForm lF = new loginForm(); lF.Show(); }
private void displayReports() { string eName = metroComboBox2.Text; string CName = metroComboBox3.Text; string Pname = metroComboBox1.Text; sqlcon userConnect = new sqlcon(); userConnect.dbIn(); SqlCommand recipe = new SqlCommand("exec [soldProductsGoods] '" + metroDateTime1.Value + "','" + metroDateTime2.Value + "','" + eName + "','" + CName + "','" + Pname + "'", sqlcon.calc); SqlDataAdapter calculated = new SqlDataAdapter(); calculated.SelectCommand = recipe; DataTable dataSet = new DataTable(); calculated.Fill(dataSet); BindingSource nSource = new BindingSource(); nSource.DataSource = dataSet; metroGrid1.DataSource = nSource; calculated.Update(dataSet); userConnect.dbOut(); }//Heart of the string
private void salesGrandTotal() //Display sales grandTotal { sqlcon userConnect = new sqlcon(); userConnect.dbIn(); SqlCommand cmd2 = new SqlCommand("[salesGrandTotal] '" + metroDateTime1.Value + "','" + metroDateTime2.Value + "'", sqlcon.calc); SqlDataReader dr2 = cmd2.ExecuteReader(); while (dr2.Read()) { metroLabel26.Text = dr2["grandTotal"].ToString(); if (dr2["T1"] == null) { T1 = 0; } else { T1 = Convert.ToDouble(dr2["T1"]); } } userConnect.dbOut(); }
private void purchasesGrandTotal() //Display purchases grandTotal { sqlcon userConnect = new sqlcon(); userConnect.dbIn(); SqlCommand cmd1 = new SqlCommand("[purchasesGrandTotal] '" + metroDateTime1.Value + "','" + metroDateTime2.Value + "'", sqlcon.calc); SqlDataReader dr1 = cmd1.ExecuteReader(); while (dr1.Read()) { metroLabel25.Text = dr1["gTotal"].ToString(); if (dr1["T2"] == null) { T2 = 0; } else { T2 = Convert.ToDouble(dr1["T2"]); } } userConnect.dbOut(); }
private void metroButton3_Click(object sender, EventArgs e) { try { if (metroComboBox1.Text.CompareTo("") == 0) { MetroMessageBox.Show(this, "", "Please Select Database", MessageBoxButtons.OK, MessageBoxIcon.Question); return; } sqlcon userConnect = new sqlcon(); userConnect.dbIn(); sql = "BACKUP DATABASE " + metroComboBox1.Text + " TO DISK = '" + "C:" + "\\" + metroComboBox1.Text + "-" + DateTime.Now.Ticks.ToString() + ".bak'"; command = new SqlCommand(sql, sqlcon.con); command.ExecuteNonQuery(); DesktopAlert.Show("Database Backup Successfully"); userConnect.dbOut(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void metroButton3_Click(object sender, EventArgs e) { checkDetect(); 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("[multiUserDel]", sqlcon.calc); material.CommandType = System.Data.CommandType.StoredProcedure; material.Parameters.AddWithValue("@id", item.Cells[1].Value.ToString()); material.ExecuteNonQuery(); userConnect.dbOut(); } } } catch { return; } displayUsers(); reloadChkBox(); }
private void detectPositionExist() //filter position list.... { sqlcon userConnect = new sqlcon(); userConnect.dbIn(); SqlCommand cmd = new SqlCommand("[positionID] '" + metroTextBox7.Text + "'", sqlcon.con); SqlDataReader dr = cmd.ExecuteReader(); int user = 0; while (dr.Read()) { user += 1; } userConnect.dbOut(); if (user > 0) { pictureBox1.Visible = true; metroTextButton3.Enabled = false; } else { pictureBox1.Visible = false; metroTextButton3.Enabled = true; } }
private void metroButton4_Click(object sender, EventArgs e) { try { foreach (DataGridViewRow item in metroGrid2.Rows) { sqlcon userConnect = new sqlcon(); userConnect.dbIn(); SqlCommand material = new SqlCommand("[voidRawMat]", 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; } if (textBoxX1.Text == "" || textBoxX1.Text == null) { displayMaterialView(); } else { searchBox(); } realoadChkBox(); }
private void calc()//Create a quotation of a particullar Finish Product/Formula { sqlcon userConnect = new sqlcon(); userConnect.dbIn(); SqlCommand recipe = new SqlCommand("recipeCalculator '" + metroComboBox1.Text + "','" + metroTextBox1.Text + "'", sqlcon.calc); SqlDataAdapter calculated = new SqlDataAdapter(); calculated.SelectCommand = recipe; DataTable dataSet = new DataTable(); DataColumn col1 = new DataColumn(); col1.ColumnName = "No."; col1.AutoIncrement = true; col1.AutoIncrementSeed = 1; col1.AutoIncrementStep = 1; dataSet.Columns.Add(col1); col1.SetOrdinal(0); for (int i = 0; i < dataSet.Rows.Count; i++) { dataSet.Rows[i]["No."] = i + 1; } calculated.Fill(dataSet); BindingSource nSource = new BindingSource(); nSource.DataSource = dataSet; metroGrid1.DataSource = nSource; calculated.Update(dataSet); userConnect.dbOut(); this.metroGrid1.Columns["No."].Width = 20; }
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); soldFinishGood.ExecuteNonQuery(); userConnect.dbOut(); metroTextBox1.Text = ""; DesktopAlert.AlertColor = eDesktopAlertColor.Green; DesktopAlert.Show("Item Has been added!"); DesktopAlert.AutoCloseTimeOut = 3; reloadChkBox(); }
private void metroButton6_Click_1(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", "N"); material.ExecuteNonQuery(); } } userConnect.dbOut(); } catch { return; } displayUsers2(); reloadChkBox(); DesktopAlert.Show("Position has been updated!"); }
private void metroButton3_Click(object sender, EventArgs e) { try { foreach (DataGridViewRow item in metroGrid2.Rows) { if (bool.Parse(item.Cells[0].Value.ToString())) { sqlcon userConnect = new sqlcon(); userConnect.dbIn(); SqlCommand material = new SqlCommand("[voidProduction]", sqlcon.calc); material.CommandType = System.Data.CommandType.StoredProcedure; material.Parameters.AddWithValue("@orderID", item.Cells[2].Value.ToString()); //material.Parameters.AddWithValue("@checkUserID", globalVar.x.ToString()); material.ExecuteNonQuery(); userConnect.dbOut(); } } } catch { return; } recentSolds(); //allProduction(); }
private void addMatToRecipe() { try { sqlcon userConnect = new sqlcon(); userConnect.dbIn(); SqlCommand material = new SqlCommand("[addMatToRecipe]", sqlcon.calc); material.CommandType = System.Data.CommandType.StoredProcedure; material.Parameters.AddWithValue("@FG", metroLabel6.Text); material.Parameters.AddWithValue("@matName", textBoxX1.Text); material.Parameters.AddWithValue("@amt", metroTextBox11.Text); material.Parameters.AddWithValue("@Emp", metroLabel4.Text); material.Parameters.AddWithValue("@userID", globalVar.x.ToString()); material.ExecuteNonQuery(); userConnect.dbOut(); displayFormula2(); formulaTotalCheck(); textBoxX1.Text = null; metroTextBox11.Text = null; DesktopAlert.Show("Finish good has been updated!"); } catch { DesktopAlert.Show("Please check your inputs!"); } }
private void metroButton1_Click(object sender, EventArgs e) { try { SaveFileDialog savefiledialog1 = new SaveFileDialog(); savefiledialog1.FileName = (metroComboBox1.Text) + " " + (DateTime.Now.ToLongDateString()); savefiledialog1.Filter = "PDF Files|*.pdf"; if (savefiledialog1.ShowDialog() == DialogResult.OK) { { Document doc = new Document(iTextSharp.text.PageSize.LETTER, 10, 10, 42, 35); PdfWriter wri = PdfWriter.GetInstance(doc, new FileStream(savefiledialog1.FileName, FileMode.Create)); wri.PageEvent = new PdfWriterEvents("T E X I C O N"); doc.Open(); iTextSharp.text.Image PNG = iTextSharp.text.Image.GetInstance("TexiconLogo.png"); PNG.ScaleAbsolute(250, 125); PNG.SetAbsolutePosition(175, 630); PNG.SpacingAfter = 80f; PNG.SpacingBefore = 10f; doc.Add(PNG); //else //{ Paragraph para3 = new Paragraph(metroComboBox1.Text.ToUpper()); para3.Alignment = Element.ALIGN_CENTER; para3.SpacingAfter = .5f; para3.SpacingBefore = 110F; para3.Font.Size = 12; doc.Add(para3); // } if (metroComboBox1.Text == "Puchased Materials Report") { Paragraph para7 = new Paragraph("(Material IN)"); para7.Alignment = Element.ALIGN_CENTER; para7.SpacingAfter = .5f; para7.SpacingBefore = .5F; para7.Font.Size = 10; doc.Add(para7); } Paragraph para1 = new Paragraph("(" + (metroDateTime1.Value.ToLongDateString()) + "-" + (metroDateTime2.Value.ToLongDateString()) + ")"); para1.Alignment = Element.ALIGN_CENTER; para1.SpacingAfter = 5f; para1.SpacingBefore = .5f; para1.Font.Size = 8; doc.Add(para1); PdfPTable table = new PdfPTable(metroGrid1.Columns.Count); table.SpacingBefore = 15f; for (int j = 0; j < metroGrid1.Columns.Count; j++) { PdfPCell cell = new PdfPCell(new Phrase(metroGrid1.Columns[j].HeaderText, FontFactory.GetFont("Times New Roman", 10f, iTextSharp.text.Font.BOLD, BaseColor.BLACK))); cell.BackgroundColor = new iTextSharp.text.BaseColor(System.Drawing.ColorTranslator.FromHtml("#C4C4C4")); cell.HorizontalAlignment = 1; table.AddCell(cell); } table.HeaderRows = 1; for (int i = 0; i < metroGrid1.Rows.Count; i++) { for (int k = 0; k < metroGrid1.Columns.Count; k++) { PdfPCell cell2 = new PdfPCell(new Phrase(metroGrid1[k, i].Value.ToString(), FontFactory.GetFont("Times New Roman", 9f, iTextSharp.text.Font.NORMAL, BaseColor.BLACK))); if (i % 2 != 0) { cell2.BackgroundColor = new iTextSharp.text.BaseColor(System.Drawing.ColorTranslator.FromHtml("#f0f0f5")); } cell2.HorizontalAlignment = 1; table.AddCell(cell2); } } doc.Add(table); Paragraph items = new Paragraph("Total of Items: " + metroGrid1.RowCount.ToString()); items.Alignment = Element.ALIGN_LEFT; items.IndentationLeft = 133f; items.SpacingBefore = .5f; doc.Add(items); Paragraph nothing = new Paragraph("********************************* NOTHING FOLLOWS *********************************"); nothing.Alignment = Element.ALIGN_CENTER; nothing.SpacingBefore = .5f; doc.Add(nothing); doc.Close(); doc.Close(); AddPageNumber(savefiledialog1.FileName, savefiledialog1.FileName); System.Diagnostics.Process.Start(savefiledialog1.FileName); } } sqlcon userConnect = new sqlcon(); userConnect.dbIn(); SqlCommand material = new SqlCommand("[AuditTrailRpt]", sqlcon.calc); material.CommandType = System.Data.CommandType.StoredProcedure; material.Parameters.AddWithValue("@addBy", globalVar.name.ToString()); material.Parameters.AddWithValue("@Report", metroComboBox1.Text); material.ExecuteNonQuery(); userConnect.dbOut(); } catch { DesktopAlert.Show("The file is open!"); //.Show("Files is open"); } }
private void logIN() { int user = 0; try { sqlcon userConnect = new sqlcon(); userConnect.dbIn(); //SqlCommand cmd = new SqlCommand("[userIDdetect] '" + metroTextBox1.Text + "'", sqlcon.con); SqlCommand cmd = new SqlCommand("[userIDdetect] '" + metroTextBox1.Text + "'", sqlcon.con); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { user += 1; globalVar.name = dr["Name"].ToString(); globalVar.x = metroTextBox1.Text; globalVar.pass = dr["passkey"].ToString(); globalVar.position = dr["position"].ToString(); globalVar.empStatus = dr["Employeestatus"].ToString(); globalVar.admin = dr["isAdmin"].ToString(); } userConnect.dbOut(); if (user != 1) { labelX1.Text = "Please enter a valid User ID"; labelX3.Text = ""; metroTextBox2.Text = ""; wrongPassword = 1; } else if (user == 1 && globalVar.empStatus == "Deactivated") { metroTextBox1.Text = ""; lockedUser lUsr = new lockedUser(); lUsr.ShowDialog(); } else { labelX1.Text = "Proceed"; if (metroTextBox2.Text != string.Empty) { if (metroTextBox2.Text.Contains(globalVar.pass) && globalVar.empStatus != "Deactivated") { //globalVar.name = labelX1.Text.ToString(); sqlcon userOUT = new sqlcon(); userOUT.dbIn(); SqlCommand logIN = new SqlCommand("[timeLogIN] '" + globalVar.x.ToString() + "','" + globalVar.name.ToString() + "'", sqlcon.con); SqlDataReader LI = logIN.ExecuteReader(); while (LI.Read()) { } userOUT.dbOut(); wrongPassword = 1; this.Hide(); timer1.Stop(); Form1 nfrm = new Form1(); nfrm.ShowDialog(); globalVar.pass = ""; powerSwitch = 0; } else { pictureBox1.Visible = true; //MessageBox.Show("Sorry" + " " + labelX1.Text); if (wrongPassword == 5 && metroTextBox1.Text != "AGRI0001") { lockUser(); lockedUser lUsr = new lockedUser(); lUsr.ShowDialog(); wrongPassword = 1; } else { wrongPassword += 1; metroTextBox2.Text = ""; globalVar.pass = ""; } } } else { } } } catch { labelX3.ForeColor = Color.Red; labelX3.Text = "Database Unavailable..."; } }
private void tileController() { string T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14 = ""; sqlcon userConnect = new sqlcon(); userConnect.dbIn(); SqlCommand cmd = new SqlCommand("[tileManager] '" + globalVar.position.ToString() + "'", sqlcon.con); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { T1 = dr["Addusertile"].ToString(); T2 = dr["UserRoletile"].ToString(); T3 = dr["ClientTile"].ToString(); T4 = dr["ReportTile"].ToString(); T5 = dr["MMLTile"].ToString(); T6 = dr["SalesTile"].ToString(); T7 = dr["materialStocksTile"].ToString(); T8 = dr["FormulaTile"].ToString(); T9 = dr["QuotationTile"].ToString(); T10 = dr["expensesTile"].ToString(); T11 = dr["GoodSoldsTile"].ToString(); T12 = dr["BNRTile"].ToString(); T13 = dr["PRODUCTION"].ToString(); T14 = dr["FGOODS"].ToString(); if (T1 == "0") { metroTileItem31.Visible = false; tileCount -= 1; } if (T2 == "0") { metroTileItem32.Visible = false; tileCount -= 1; } if (T3 == "0") { metroTileItem37.Visible = false; tileCount -= 1; } if (T4 == "0") { metroTileItem29.Visible = false; tileCount -= 1; } if (T5 == "0") { metroTileItem41.Visible = false; tileCount -= 1; } if (T6 == "0") { metroTileItem44.Visible = false; tileCount -= 1; } if (T7 == "0") { metroTileItem42.Visible = false; tileCount -= 1; } if (T8 == "0") { metroTileItem33.Visible = false; tileCount -= 1; } if (T9 == "0") { metroTileItem49.Visible = false; tileCount -= 1; } if (T10 == "0") { metroTileItem38.Visible = false; tileCount -= 1; } if (T11 == "0") { metroTileItem40.Visible = false; tileCount -= 1; } if (T12 == "0") { metroTileItem43.Visible = false; tileCount -= 1; } if (T13 == "0") { metroTileItem47.Visible = false; tileCount -= 1; } if (T14 == "0") { metroTileItem45.Visible = false; tileCount -= 1; } } userConnect.dbOut(); }
private void modifyPosition() //modify users details.... { string privilage = ""; string T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14 = ""; sqlcon userConnect = new sqlcon(); userConnect.dbIn(); SqlCommand recipe = new SqlCommand("[modifyPosition]", sqlcon.con); recipe.CommandType = System.Data.CommandType.StoredProcedure; recipe.Parameters.AddWithValue("@Position", metroLabel8.Text); recipe.Parameters.AddWithValue("@Description", metroTextBox5.Text); recipe.Parameters.AddWithValue("@user", globalVar.name.ToString()); //recipe.Parameters.AddWithValue("@position2", metroLabel8.Text); if (metroCheckBox2.CheckState == CheckState.Checked) { privilage = "Y"; } else { privilage = "N"; } recipe.Parameters.AddWithValue("@isAdmin", privilage); if (CHK13.CheckState == CheckState.Checked) { T1 = "1"; } else { T1 = "0"; } if (CHK14.CheckState == CheckState.Checked) { T2 = "1"; } else { T2 = "0"; } if (CHK15.CheckState == CheckState.Checked) { T3 = "1"; } else { T3 = "0"; } if (CHK16.CheckState == CheckState.Checked) { T4 = "1"; } else { T4 = "0"; } if (CHK17.CheckState == CheckState.Checked) { T5 = "1"; } else { T5 = "0"; } if (CHK18.CheckState == CheckState.Checked) { T6 = "1"; } else { T6 = "0"; } if (CHK19.CheckState == CheckState.Checked) { T7 = "1"; } else { T7 = "0"; } if (CHK20.CheckState == CheckState.Checked) { T8 = "1"; } else { T8 = "0"; } if (CHK21.CheckState == CheckState.Checked) { T9 = "1"; } else { T9 = "0"; } if (CHK22.CheckState == CheckState.Checked) { T10 = "1"; } else { T10 = "0"; } if (CHK26.CheckState == CheckState.Checked) { T11 = "1"; } else { T11 = "0"; } if (CHK24.CheckState == CheckState.Checked) { T12 = "1"; } else { T12 = "0"; } if (CHK25.CheckState == CheckState.Checked) { T13 = "1"; } else { T13 = "0"; } if (CHK23.CheckState == CheckState.Checked) { T14 = "1"; } else { T14 = "0"; } recipe.Parameters.AddWithValue("@T1", T1); recipe.Parameters.AddWithValue("@T2", T2); recipe.Parameters.AddWithValue("@T3", T3); recipe.Parameters.AddWithValue("@T4", T4); recipe.Parameters.AddWithValue("@T5", T5); recipe.Parameters.AddWithValue("@T6", T6); recipe.Parameters.AddWithValue("@T7", T7); recipe.Parameters.AddWithValue("@T8", T8); recipe.Parameters.AddWithValue("@T9", T9); recipe.Parameters.AddWithValue("@T10", T10); recipe.Parameters.AddWithValue("@T11", T11); recipe.Parameters.AddWithValue("@T12", T12); recipe.Parameters.AddWithValue("@T13", T13); recipe.Parameters.AddWithValue("@T14", T14); recipe.ExecuteNonQuery(); userConnect.dbOut(); displayUsers2(); DesktopAlert.Show("Positon has been modified!"); }
private void searchPosition() //Display User details in textboxes..in slidepanel { sqlcon userConnect = new sqlcon(); userConnect.dbIn(); SqlCommand cmd = new SqlCommand("[findOrg] '" + label1.Text + "'", sqlcon.con); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { metroLabel8.Text = dr["Position"].ToString(); //metroTextBox4.Text = dr["Position"].ToString(); metroTextBox5.Text = dr["Description"].ToString(); if (dr["IsAdmin"].ToString() == "Yes") { metroCheckBox2.CheckState = CheckState.Checked; } else { metroCheckBox2.CheckState = CheckState.Unchecked; } if (dr["Addusertile"].ToString() == "1") { CHK13.CheckState = CheckState.Checked; } else { CHK13.CheckState = CheckState.Unchecked; } if (dr["UserRoletile"].ToString() == "1") { CHK14.CheckState = CheckState.Checked; } else { CHK14.CheckState = CheckState.Unchecked; } if (dr["ClientTile"].ToString() == "1") { CHK15.CheckState = CheckState.Checked; } else { CHK15.CheckState = CheckState.Unchecked; } if (dr["ReportTile"].ToString() == "1") { CHK16.CheckState = CheckState.Checked; } else { CHK16.CheckState = CheckState.Unchecked; } if (dr["MMLTile"].ToString() == "1") { CHK17.CheckState = CheckState.Checked; } else { CHK17.CheckState = CheckState.Unchecked; } if (dr["SalesTile"].ToString() == "1") { CHK18.CheckState = CheckState.Checked; } else { CHK18.CheckState = CheckState.Unchecked; } if (dr["materialStocksTile"].ToString() == "1") { CHK19.CheckState = CheckState.Checked; } else { CHK19.CheckState = CheckState.Unchecked; } if (dr["FormulaTile"].ToString() == "1") { CHK20.CheckState = CheckState.Checked; } else { CHK20.CheckState = CheckState.Unchecked; } if (dr["QuotationTile"].ToString() == "1") { CHK21.CheckState = CheckState.Checked; } else { CHK21.CheckState = CheckState.Unchecked; } if (dr["expensesTile"].ToString() == "1") { CHK22.CheckState = CheckState.Checked; } else { CHK22.CheckState = CheckState.Unchecked; } if (dr["GoodSoldsTile"].ToString() == "1") { CHK26.CheckState = CheckState.Checked; } else { CHK26.CheckState = CheckState.Unchecked; } if (dr["BNRTile"].ToString() == "1") { CHK24.CheckState = CheckState.Checked; } else { CHK24.CheckState = CheckState.Unchecked; } if (dr["PRODUCTION"].ToString() == "1") { CHK25.CheckState = CheckState.Checked; } else { CHK25.CheckState = CheckState.Unchecked; } if (dr["FGOODS"].ToString() == "1") { CHK23.CheckState = CheckState.Checked; } else { CHK23.CheckState = CheckState.Unchecked; } } userConnect.dbOut(); }
private void addNewPositon() { //string privilage = ""; string T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14 = ""; sqlcon userConnect = new sqlcon(); userConnect.dbIn(); SqlCommand recipe = new SqlCommand("[AddNewPostion]", sqlcon.con); recipe.CommandType = System.Data.CommandType.StoredProcedure; recipe.Parameters.AddWithValue("@Position", metroTextBox7.Text); recipe.Parameters.AddWithValue("@Description", metroTextBox6.Text); recipe.Parameters.AddWithValue("@user", globalVar.name.ToString()); //if (metroCheckBox1.CheckState == CheckState.Checked){privilage = "Y";}else{privilage = "N";} //recipe.Parameters.AddWithValue("@isAdmin", privilage); if (CHK1.CheckState == CheckState.Checked) { T1 = "1"; } else { T1 = "0"; } if (CHK2.CheckState == CheckState.Checked) { T2 = "1"; } else { T2 = "0"; } if (CHK3.CheckState == CheckState.Checked) { T3 = "1"; } else { T3 = "0"; } if (CHK4.CheckState == CheckState.Checked) { T4 = "1"; } else { T4 = "0"; } if (CHK5.CheckState == CheckState.Checked) { T5 = "1"; } else { T5 = "0"; } if (CHK6.CheckState == CheckState.Checked) { T6 = "1"; } else { T6 = "0"; } if (CHK7.CheckState == CheckState.Checked) { T7 = "1"; } else { T7 = "0"; } if (CHK8.CheckState == CheckState.Checked) { T8 = "1"; } else { T8 = "0"; } if (CHK9.CheckState == CheckState.Checked) { T9 = "1"; } else { T9 = "0"; } if (CHK10.CheckState == CheckState.Checked) { T10 = "1"; } else { T10 = "0"; } if (CHK27.CheckState == CheckState.Checked) { T11 = "1"; } else { T11 = "0"; } if (CHK12.CheckState == CheckState.Checked) { T12 = "1"; } else { T12 = "0"; } if (CHK28.CheckState == CheckState.Checked) { T13 = "1"; } else { T13 = "0"; } if (CHK11.CheckState == CheckState.Checked) { T14 = "1"; } else { T14 = "0"; } recipe.Parameters.AddWithValue("@T1", T1); recipe.Parameters.AddWithValue("@T2", T2); recipe.Parameters.AddWithValue("@T3", T3); recipe.Parameters.AddWithValue("@T4", T4); recipe.Parameters.AddWithValue("@T5", T5); recipe.Parameters.AddWithValue("@T6", T6); recipe.Parameters.AddWithValue("@T7", T7); recipe.Parameters.AddWithValue("@T8", T8); recipe.Parameters.AddWithValue("@T9", T9); recipe.Parameters.AddWithValue("@T10", T10); recipe.Parameters.AddWithValue("@T11", T11); recipe.Parameters.AddWithValue("@T12", T12); recipe.Parameters.AddWithValue("@T13", T13); recipe.Parameters.AddWithValue("@T14", T14); recipe.ExecuteNonQuery(); userConnect.dbOut(); displayUsers2(); }