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