private void btnSave_Click(object sender, EventArgs e) { if (txtPassword.Text == "" || txtUsername.Text == "") { MessageBox.Show("Fields are required", "Invalid", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } sql = "SELECT * FROM useraccounts WHERE USER_ID = '" + txtUserId.Text + "'"; config.singleResult(sql); if (config.dt.Rows.Count > 0) { sql = "UPDATE `useraccounts` SET `UNAME`='" + txtName.Text + "', `USERNAME`='" + txtUsername.Text + "', `PASS`=sha1('" + txtPassword.Text + "'), `USERTYPE`='" + cboType.Text + "' WHERE USER_ID='" + txtUserId.Text + "'"; config.Execute_CUD(sql, "no data update.", "Data has been updated."); } else { sql = "insert into `useraccounts` (`USER_ID`, `UNAME`, `USERNAME`, `PASS`, `USERTYPE`)" + "values ('" + txtUserId.Text + "','" + txtName.Text + "','" + txtUsername.Text + "',sha1('" + txtPassword.Text + "'),'" + cboType.Text + "')"; config.Execute_CUD(sql, "no save data", "Data has been saved in the database."); sql = "UPDATE `tblauto` SET `AutoEnd`=`AutoEnd`+1 WHERE `autoID`=1"; config.Execute_Query(sql); } btnNew_Click(sender, e); }
private void load_data() { sql = "SELECT DISTINCT (" + "p.`trans_id`" + "),e.emp_code as 'Assign Code', CONCAT( `emp_fname` , ' ', `emp_lname` , ' ', `emp_mname` ) AS 'Employee'" + ", `d_rate` AS 'DailyRate' , `num_days` AS 'NumberOfDays' , `r_wage` AS 'RateWage', " + " `gross_sal` AS 'GrossIncome', `total_ded` AS 'TotalDeduction', `net_income` AS 'NetIncome' , " + " `position` AS 'Postion',`remarks` AS 'Remarks' ,`dateissued` AS 'DateIssued' " + "FROM `employee` e, `payroll` p, `employee_workinfo` ew, `other_deduction` od " + "WHERE e.`emp_code` = p.`emp_code` " + "AND p.`emp_code` = ew.`emp_code` " + "AND p.`trans_id` = od.`trans_id` " + "AND (emp_fname LIKE '%" + txtpsearch.Text + "%'" + "OR emp_lname LIKE '%" + txtpsearch.Text + "%'" + "OR e.emp_code LIKE '%" + txtpsearch.Text + "%')"; config.Load_DTG(sql, dtgParollList); dtgParollList.Columns[0].Visible = false; funct.ResponsiveDtg(dtgParollList); sql = "SELECT concat(autoname,strnum) as auto FROM autonumber WHERE id = 1"; config.singleResult(sql); if (config.dt.Rows.Count > 0) { txttrancode.Text = config.dt.Rows[0].Field <string>("auto"); } }
private void txt_cusid_TextChanged(object sender, EventArgs e) { sql = "SELECT * FROM `tblperson` WHERE `SUPLIERCUSTOMERID`='" + txt_cusid.Text + "'"; config.singleResult(sql); if(config.dt.Rows.Count > 0) { txtCus_fname.Text = config.dt.Rows[0].Field<string>("FIRSTNAME"); txtCus_lname.Text = config.dt.Rows[0].Field<string>("LASTNAME"); }else { txtCus_fname.Clear(); txtCus_lname.Clear(); } }
private void btnLogin_Click(object sender, EventArgs e) { if (this.txtusername.Text == "" || this.txtpassword.Text == "") { MessageBox.Show("Please write Username and Password for Login", "Information !!", MessageBoxButtons.OK, MessageBoxIcon.Exclamation, MessageBoxDefaultButton.Button1); txtusername.Focus(); } else { sql = " SELECT* FROM Users WHERE Username = '******' and Password = '******'"; config.singleResult(sql); if (config.dt.Rows.Count > 0) { MenuForma.ts_loginas.Visible = true; MenuForma.MenuEnabled(); MenuForma.ts_loginas.BackColor = HighlightColor; // MenuForma.ts_loginas.ForeColor = HighlightColor; MenuForma.ts_loginas.Text = "" + txtusername.Text + ""; this.Close(); } else { MessageBox.Show("This account " + txtusername.Text + " doesn`t match or your Password is wrong!!", "", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
private void btnsave_Click(object sender, EventArgs e) { if (id == "0") { sql = "SELECT * FROM tblsection WHERE SECTION = '" + txtSection.Text + "' AND LEVEL='" + cboLevel.Text + "'"; config.singleResult(sql); maxrow = config.dt.Rows.Count; if (maxrow > 0) { MessageBox.Show("Data is already exist!", "Inavlid Action", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else { sql = "INSERT INTO `tblsection` (`SECTION`,LEVEL) VALUES ('" + txtSection.Text + "','" + cboLevel.Text + "')"; config.Execute_Query(sql); MessageBox.Show("New Data has been saved in the database."); } } else { sql = "SELECT * FROM tblsection WHERE SECTION = '" + txtSection.Text + "' AND LEVEL='" + cboLevel.Text + "'"; config.singleResult(sql); maxrow = config.dt.Rows.Count; if (maxrow > 0) { MessageBox.Show("Data is already exist!", "Inavlid Action", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else { sql = "UPDATE tblsection SET SECTION ='" + txtSection.Text + "',LEVEL ='" + cboLevel.Text + "' WHERE SECTIONID='" + id + "'"; config.Execute_Query(sql); MessageBox.Show("Data has been updated in the database."); } } frmSection_Load(sender, e); }
public void genTrnsID() { string trnsID; config.singleResult("SELECT concat(STRT,END) FROM genid WHERE ID = 2"); trnsID = config.dt.Rows[0].Field <string>(0); txtTrnsID.Text = trnsID; }
private void txtSubjectID_TextChanged(object sender, EventArgs e) { sql = "SELECT ACADYR FROM ay"; config.fiil_CBO(sql, cbosy); sql = "SELECT LEVEL FROM level"; config.fiil_CBO(sql, cboYear); sql = "SELECT * FROM `subject` WHERE `SUBJ_ID`='" + txtSubjectID.Text + "'"; config.singleResult(sql); txtsujCode.Text = config.dt.Rows[0].Field <string>("SUBJ_CODE"); txtsubjDesc.Text = config.dt.Rows[0].Field <string>("SUBJ_DESCRIPTION"); cboYear.Text = config.dt.Rows[0].Field <string>("YR"); }
private void OK_Click(object sender, EventArgs e) { sql = "SELECT * FROM useraccounts" + " WHERE `ACCOUNT_USERNAME` = '" + UsernameTextBox.Text + "' AND `ACCOUNT_PASSWORD` = sha('" + PasswordTextBox.Text + "')"; config.singleResult(sql); if (config.dt.Rows.Count > 0) { frm.enabled_menu(); MessageBox.Show("Welcome " + config.dt.Rows[0].Field <string>("ACCOUNT_TYPE")); this.Close(); } else { MessageBox.Show("", "Login", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void txtStudentId_TextChanged(object sender, EventArgs e) { sql = "SELECT ACADYR FROM ay"; config.fiil_CBO(sql, cboAddSy); sql = "SELECT * FROM tblstudent WHERE IDNO = '" + txtStudentId.Text + "'"; config.singleResult(sql); if (config.dt.Rows.Count > 0) { txtFName.Text = config.dt.Rows[0].Field <string>("FNAME"); txtLName.Text = config.dt.Rows[0].Field <string>("LNAME"); txtMName.Text = config.dt.Rows[0].Field <string>("MNAME"); txtAddress.Text = config.dt.Rows[0].Field <string>("HOME_ADD"); txtguardian.Text = config.dt.Rows[0].Field <string>("GUARDIAN"); txtguardianadd.Text = config.dt.Rows[0].Field <string>("GUARDIAN_ADD"); txtguardiantel.Text = config.dt.Rows[0].Field <int>("GUARDIAN_TEL").ToString(); txtPBirth.Text = config.dt.Rows[0].Field <string>("BPLACE"); dtpDbirth.Text = config.dt.Rows[0].Field <DateTime>("BDAY").ToString(); txtAge.Text = config.dt.Rows[0].Field <int>("AGE").ToString(); txtWeigth.Text = config.dt.Rows[0].Field <int>("WEIGTH").ToString(); txtHeight.Text = config.dt.Rows[0].Field <int>("HEIGTH").ToString(); txtLastSchoolAttend.Text = config.dt.Rows[0].Field <string>("LASTSCHOOLATTEND"); if (config.dt.Rows[0].Field <string>("SEX") == "FEMALE") { rdoFemale.Checked = true; } else { rdoMale.Checked = true; } // 'students requirements sql = "SELECT * FROM `tblrequirements` WHERE IDNO = '" + txtStudentId.Text + "'"; config.singleResult(sql); if (config.dt.Rows.Count > 0) { if (config.dt.Rows[0].Field <string>("NSO") == "Yes") { chkBirthCert.Checked = true; } else { chkBirthCert.Checked = false; } if (config.dt.Rows[0].Field <string>("PICID") == "Yes") { chkPic.Checked = true; } else { chkPic.Checked = false; } if (config.dt.Rows[0].Field <string>("REPORTCARD") == "Yes") { chkReportCard.Checked = true; } else { chkReportCard.Checked = false; } if (config.dt.Rows[0].Field <string>("CERTIFICATE_OF_TRANSFER") == "Yes") { chkCertification.Checked = true; } else { chkCertification.Checked = false; } } } }
private void btnreturn_save_Click(object sender, EventArgs e) { string tranid; config.singleResult("SELECT concat(STRT,END) FROM tblautonumber WHERE ID = 6"); tranid = config.dt.Rows[0].Field <string>(0); if (txttransactionid.Text == "") { MessageBox.Show("Quedan campos vacíos que deben llenarse!", "Invalid", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } if (dtCus_addedlist.RowCount == 0) { MessageBox.Show("El carrito esta vacío!", "Invalid", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } sql = "SELECT `ITEMID`, `QTY` FROM `tblstock_in_out` WHERE `TRANSACTIONNUMBER` ='" + txttransactionid.Text + "'"; config.singleResult(sql); foreach (DataRow row in config.dt.Rows) { for (int i = 0; i < dtCus_addedlist.Rows.Count; i++) { if (dtCus_addedlist.Rows[i].Cells[0].Value.ToString() == row.Field <string>(0)) { if (int.Parse(dtCus_addedlist.Rows[i].Cells[4].Value.ToString()) > row.Field <int>(1)) { MessageBox.Show("La cantidad devuelta del artículo ( " + dtCus_addedlist.Rows[i].Cells[1].Value.ToString() + " ) es mayor que la cantidad disponible.", "Invalid", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } } if (dtCus_addedlist.Rows[i].Cells[4].Value.ToString() == "") { MessageBox.Show("Establece tu propósito.", "Invalid", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } } } foreach (DataGridViewRow r in dtCus_addedlist.Rows) { sql = "INSERT INTO `tblstock_return` ( `STOCKRETURNNUMBER`, `ITEMID`, `RETURNDATE`, `QTY`, `TOTALPRICE`, `OWNER_CUS_ID`)" + " VALUES ('" + tranid + "','" + r.Cells[0].Value + "','" + DateTime.Now.ToString("yyyy-MM-dd") + "','" + r.Cells[4].Value + "','" + r.Cells[5].Value + "','" + custormerid + "')"; config.Execute_Query(sql); // '-----------------------------------------------update item sql = "UPDATE `tblitems` SET `QTY`=`QTY` + '" + r.Cells[4].Value + "' WHERE ITEMID='" + r.Cells[0].Value + "'"; config.Execute_Query(sql); sql = "UPDATE `tblstock_in_out` SET `QTY`=`QTY`-'" + r.Cells[4].Value + "', `TOTALPRICE`=`TOTALPRICE`-'" + r.Cells[5].Value + "' WHERE `STOCKOUTID` ='" + r.Cells[6].Value + "'"; config.Execute_Query(sql); } sql = "INSERT INTO `tbltransaction` (`TRANSACTIONNUMBER`, `TRANSACTIONDATE`, `TYPE`, `SUPLIERCUSTOMERID`)" + " VALUES ('" + txttransactionid.Text + "','" + DateTime.Now.ToString("yyyy-MM-dd") + "','Returned','" + custormerid + "')"; config.Execute_Query(sql); // '-----------------------------------------------update autonumber config.Execute_Query("UPDATE tblautonumber SET END= END + INCREMENT WHERE ID = 6"); // '------------------------------------------------------------ MessageBox.Show("Los productos han sido devueltos, la facturacion se ha cancelado."); // '------------------------------------------------------------clearing funct.clearTxt(GroupBox3); dtCus_addedlist.Rows.Clear(); frmReturn_Load(sender, e); }