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();
}