private void btnDelete_Click(object sender, EventArgs e)
{
sql = "DELETE FROM ay WHERE AY_ID = '" + dtgList.CurrentRow.Cells[0].Value + "'";
config.Execute_Query(sql);
MessageBox.Show("Data has been deleted in the database.");
frmSy_Load(sender, e);
}
private void btnempsave_Click(object sender, EventArgs e)
{
if (txtcode.Text == "" || txtfname.Text == "" || txtlname.Text == "" || txtmname.Text == "" ||
txtaddress.Text == "" || txtcontact.Text == "" || txtstatus.Text == "" || txtbplace.Text == "" ||
txtage.Text == "" || txtemerg.Text == "" || txtdrate.Text == "" || txtposition.Text == "")
{
MessageBox.Show("One of the box is empty. Data is required.", "Info", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
else
{
if (rdomale.Checked)
{
rdo = "Male";
}
else
{
rdo = "Female";
}
sql = "INSERT INTO `employee` (`emp_code`, `emp_fname`, `emp_lname`, `emp_mname`"
+ ", `address`, `contact`, `status`, `birth_date`, `birth_place`, `emp_sex`, `emp_age`"
+ ", `emerg_contct`) VALUES ('" + txtcode.Text + "','" + txtfname.Text + "','" + txtlname.Text
+ "','" + txtmname.Text + "','" + txtaddress.Text + "'," + txtcontact.Text + ",'" + txtstatus.Text
+ "','" + dtpdbirth.Text + "','" + txtbplace.Text + "','" + rdo + "'," + txtage.Text + ",'" + txtcontact.Text + "')";
config.Execute_CUD(sql, "Error to execute.", "Data has been saved in the database.");
sql = "INSERT INTO `employee_workinfo` (`emp_code`, `d_rate`, `p_method`, `position`, `w_status`, `d_hired`)"
+ " VALUES ('" + txtcode.Text + "','" + txtdrate.Text + "','" + txtpmethod.Text + "','" + txtposition.Text
+ "','" + txtworkstatus.Text + "','" + dtpdhired.Text + "')";
config.Execute_Query(sql);
btnempnew_Click(sender, e);
}
}
private void saveStock_Click(object sender, EventArgs e)
{
if (string.IsNullOrWhiteSpace(txtStPrice.Text) || string.IsNullOrWhiteSpace(txtTrnsID.Text))
{
MessageBox.Show("The cart is Empty!", "Invalid", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
else
{
DialogResult res = MessageBox.Show("Are you sure, You want to save this cart?", "Confirm to Save!", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (res == DialogResult.Yes)
{
string itemList = "";
foreach (DataGridViewRow r in dtInventory.Rows)
{
////////////////////Generating the ID////////////////////
string genInvID;
string InvID = r.Cells[0].Value.ToString();
if (r.Cells[0].Value.ToString() == "New Arrival")
{
config.singleResult("SELECT concat(STRT,END) FROM genid WHERE ID = 1");
genInvID = config.dt.Rows[0].Field <string>(0);
config.update_Autonumber("Inventory");
}
else
{
genInvID = InvID;
}
//////////////////////Sql for saving//////////////////////
sql = "SELECT * FROM inventory WHERE inventoryID='" + r.Cells[0].Value + "'";
config.singleResult(sql);
if (config.dt.Rows.Count > 0)
{
sql = "UPDATE inventory SET Qty = '" + r.Cells[2].Value + "' WHERE inventoryID ='" + r.Cells[0].Value + "'";
config.Execute_Query(sql);
}
else
{
sql = "INSERT INTO `inventory` ( `inventoryID`, `itemID`, `Qty`)" +
" VALUES ('" + genInvID + "','" + r.Cells[1].Value + "','" + r.Cells[2].Value + "')";
config.Execute_Query(sql);
}
///////////////////Item List///////////////////////////////
itemList = itemList + r.Cells[1].Value + "(" + r.Cells[3].Value + "), ";
}
itemList = itemList.Substring(0, (itemList.Length - 2));
sql = "INSERT INTO `transactions` (`transID`, `user`, `transType`, `transDate`, `items`, `stockPrice`)" +
" VALUES ('" + txtTrnsID.Text + "','" + Login.user + "','Stock-IN','" + txtDate.Text + "','" + itemList + "','" + txtStPrice.Text + "')";
config.Execute_Query(sql);
config.update_Autonumber("Transaction");
ClearAll();
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
string id = dtgList.CurrentRow.Cells[0].Value.ToString();
string level;
if (txtFullname.Text == "")
{
MessageBox.Show("Fill the name of the students.", "Action is Invalid", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
sql = "SELECT * FROM `tblstudupdatelevel` WHERE `IDNO` ='" + id + "'";
config.singleResult(sql);
if (config.dt.Rows.Count > 0)
{
level = config.dt.Rows[0].Field <string>("LEVEL");
sql = "UPDATE `tblstudupdatelevel` SET "
+ "`LEVEL`='" + cboLevel.Text + "',SECTION = '" + cbosection.Text
+ "' ,`AY`= '" + cbosy.Text + "' WHERE `IDNO`='" + id + "'";
config.Execute_Query(sql);
}
else
{
sql = "INSERT INTO `tblstudupdatelevel` (`IDNO`, `LEVEL`,SECTION, `AY`) "
+ "VALUES ('" + id + "','" + cboLevel.Text + "','"
+ cbosection.Text + "','" + cbosy.Text + "')";
config.Execute_Query(sql);
}
// 'for school year of student
sql = "INSERT INTO `schoolyr` (`AY`, `YR`,SECTION, `IDNO`, `STATUS`) "
+ "VALUES ('" + cbosy.Text + "','" + cboLevel.Text + "','"
+ cbosection.Text + "','" + id + "','')";
config.Execute_CUD(sql, "error to save", "Students has been enrolled.");
sql = "SELECT * FROM `tblstudupdatelevel` l,`schoolyr` sy, `subject` s "
+ "WHERE l.IDNO=sy.IDNO AND l.LEVEL = sy.YR AND sy.`YR` =s.`YR` AND sy.`IDNO` = '" + id + "'";
config.singleResult(sql);
if (config.dt.Rows.Count > 0)
{
foreach (DataRow r in config.dt.Rows)
{
sql = "INSERT INTO `grades` (`IDNO`, `SUBJ_ID`, `SYID` ) "
+ " VALUES ('" + id + "','" + r.Field <int>("SUBJ_ID") + "','" + r.Field <int>("SYID") + "')";
config.Execute_Query(sql);
}
}
btnClear_Click(sender, e);
}
private void btnTypesave_Click(object sender, EventArgs e)
{
sql = "INSERT INTO tblsettings (DESCRIPTION,PARA) VALUES ('" + txtCategory.Text + "','Category')";
config.Execute_CUD(sql, "error en los datos guardados", "La nueva Categorìa se han guardado.");
sql = "INSERT INTO tblautonumber (STRT,END,INCREMENT,DESCRIPTION)" +
" VALUES ('" + txtCategory.Text.Substring(0, 1) + "0000" + "',1,1,'" + txtCategory.Text + "')";
config.Execute_Query(sql);
btntypeLoad_Click(sender, e);
}
private void btnTypeAdd_Click(object sender, EventArgs e)
{
sql = "INSERT INTO settings (DESCRIPTION,PARA) VALUES ('" + Type.Text + "','Category')";
config.Execute_CUD(sql, "error to saved data", "Data has been saved in the database.");
sql = "INSERT INTO autonumber (START,END,INCREMENT,DESCRIPTION)" +
" VALUES ('" + Type.Text.Substring(0, 1) + "0000" + "',1,1,'" + Type.Text + "')";
config.Execute_Query(sql);
btnTypeLoad_Click(sender, e);
}
private void tsDelete_Click(object sender, EventArgs e)
{
sql = "DELETE FROM `tblstudent` WHERE `IDNO`='" + dtgList.CurrentRow.Cells[0].Value + "'";
config.Execute_Query(sql);
sql = "DELETE FROM `schoolyr` WHERE `IDNO`='" + dtgList.CurrentRow.Cells[0].Value + "'";
config.Execute_Query(sql);
sql = "DELETE FROM `studentsubjects` WHERE `IDNO`='" + dtgList.CurrentRow.Cells[0].Value + "'";
config.Execute_Query(sql);
sql = "DELETE FROM `tblrequirements` WHERE `IDNO`='" + dtgList.CurrentRow.Cells[0].Value + "'";
config.Execute_Query(sql);
sql = "DELETE FROM `tblstuddetails` WHERE `IDNO`='" + dtgList.CurrentRow.Cells[0].Value + "'";
config.Execute_Query(sql);
sql = "DELETE FROM `tblstudsiblings` WHERE `IDNO`='" + dtgList.CurrentRow.Cells[0].Value + "'";
config.Execute_Query(sql);
sql = "DELETE FROM `tblstudupdatelevel` WHERE `IDNO`='" + dtgList.CurrentRow.Cells[0].Value + "'";
config.Execute_Query(sql);
sql = "DELETE FROM `grades` WHERE `IDNO`='" + dtgList.CurrentRow.Cells[0].Value + "'";
config.Execute_Query(sql);
tsFind_Click(sender, e);
}
private void tsSave_Click(object sender, EventArgs e)
{
if (txtStudentId.Text == "")
{
MessageBox.Show("One of the box is empty on the student details,You must fill it", "Invalid", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
//foreach(Control txt in GroupBox1.Controls)
//{
// if(txt is TextBox)
// {
// MessageBox.Show("One of the box is empty on the student details,You must fill it", "Invalid", MessageBoxButtons.OK, MessageBoxIcon.Error);
// return;
// }
//}
if (rdoMale.Checked)
{
radioSEX = "MALE";
}
else
{
radioSEX = "FEMALE";
}
Nyesno = func.checkOption(chkBirthCert);
Cyesno = func.checkOption(chkCertification);
Pyesno = func.checkOption(chkPic);
Ryesno = func.checkOption(chkReportCard);
sql = "INSERT INTO `tblrequirements` (`NSO`, `PICID`, `REPORTCARD`, `CERTIFICATE_OF_TRANSFER`, `IDNO`) "
+ "VALUES ('" + Nyesno + "','" + Pyesno + "','" + Ryesno
+ "','" + Cyesno + "','" + txtStudentId.Text + "')";
config.Execute_Query(sql);
sql = "INSERT INTO tblstudent(`IDNO`, `FNAME`, `LNAME`, `MNAME`, `SEX`, `BDAY`, `BPLACE`, `AGE`, `HOME_ADD`, `GUARDIAN`,`GUARDIAN_ADD`,`GUARDIAN_TEL`,`LASTSCHOOLATTEND`,`HEIGTH`,`WEIGTH`) "
+ "VALUES ('" + txtStudentId.Text + "','" + txtFName.Text + "','" + txtLName.Text + "','" + txtMName.Text
+ "','" + radioSEX + "','" + dtpDbirth.Text + "','" + txtPBirth.Text + "','" + txtAge.Text + "','"
+ txtAddress.Text + "','" + txtguardian.Text + "','" + txtguardianadd.Text + "','" + txtguardiantel.Text
+ "','" + txtLastSchoolAttend.Text + "','" + txtHeight.Text + "','"
+ txtWeigth.Text + "')";
config.Execute_CUD(sql, "error to save the data", "Student has been registered.");
sql = "Update tblautonumber set EndValue = EndValue + IncrementValue WHERE Remarks='StudentID'";
config.Execute_Query(sql);
tsNew_Click(sender, e);
}
private void btnSave_Click(object sender, EventArgs e)
{
foreach (Control obj in pnl_productManager.Controls)
{
if (obj is TextBox)
{
if (obj.Text == "")
{
MessageBox.Show("Action connot be perform. All fields are required to be fill up.", "Invalid", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
}
}
sql = "SELECT ITEMID FROM items WHERE ITEMID='" + itemID.Text + "'";
config.singleResult(sql);
if (config.dt.Rows.Count > 0)
{
sql = "UPDATE items SET qty =qty + '" + quantity.Text + "' WHERE ITEMID ='" + itemID.Text + "'";
config.Execute_Query(sql);
}
else
{
sql = "insert into items (ITEMID,`NAME`, `DESCRIPTION`, `TYPE`, `PRICE`, `QTY`,UNIT)" +
"VALUES ('" + itemID.Text + "','" + name.Text + "','" + description.Text + "','" + type.Text
+ "','" + price.Text + "','" + quantity.Text + "','" + units.Text + "' )";
config.Execute_CUD(sql, "No data saved.", "Data has been saved in the database.");
config.update_Autonumber(type.Text);
}
btnNew_Click(sender, e);
}
private void tsSave_Click(object sender, EventArgs e)
{
if (rdoMale.Checked)
{
radioSEX = "MALE";
}
else
{
radioSEX = "FEMALE";
}
Nyesno = func.checkOption(chkBirthCert);
Cyesno = func.checkOption(chkCertification);
Pyesno = func.checkOption(chkPic);
Ryesno = func.checkOption(chkReportCard);
//'student(requirements)
sql = "UPDATE `tblrequirements` SET `NSO`='" + Nyesno + "', `PICID`='" + Pyesno + "', `REPORTCARD`='" + Ryesno
+ "', `CERTIFICATE_OF_TRANSFER`='" + Cyesno + "' WHERE IDNO='" + txtStudentId.Text + "'";
config.Execute_Query(sql);
//'student basic info
sql = "UPDATE tblstudent SET `FNAME`='" + txtFName.Text + "', `LNAME`='" + txtLName.Text + "', `MNAME`='" + txtMName.Text
+ "', `SEX`='" + radioSEX + "', `BDAY`='" + dtpDbirth.Text + "', `BPLACE`='" + txtPBirth.Text + "', `AGE`='" + txtAge.Text
+ "', `HOME_ADD`='" + txtAddress.Text + "',GUARDIAN='" + txtguardian.Text + "',GUARDIAN_ADD ='" + txtguardianadd.Text
+ "',GUARDIAN_TEL ='" + txtguardiantel.Text + "',`LASTSCHOOLATTEND`='" + txtLastSchoolAttend.Text
+ "', WEIGTH='" + txtWeigth.Text + "',HEIGTH='" + txtHeight.Text + "' WHERE IDNO='" + txtStudentId.Text + "'";
config.Execute_CUD(sql, "error to update the data", "Student information has been updated.");
}
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 btnsave_Click(object sender, EventArgs e)
{
foreach (Control obj in pnl_stockmaster.Controls)
{
if (obj is TextBox)
{
if (obj.Text == "")
{
MessageBox.Show("No se puede realizar ninguna acción. Todos los campos deben completarse.", "Invalid", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
}
}
sql = "INSERT INTO `tblstock_in_out` (`ITEMID`, `QTY`,`TRANSACTIONDATE`, `TOTALPRICE`, `REMARKS`)" +
" VALUES ('" + txtitemid.Text + "','" + txtqty.Text + "','" + DateTime.Now.ToString("yyyy-MM-dd") + "','" + txtprice.Text +
"','StockIn')";
config.Execute_Query(sql);
sql = "SELECT ITEMID FROM tblitems WHERE ITEMID='" + txtitemid.Text + "'";
config.singleResult(sql);
if (config.dt.Rows.Count > 0)
{
sql = "UPDATE tblitems SET qty =qty + '" + txtqty.Text + "' WHERE ITEMID ='" + txtitemid.Text + "'";
config.Execute_Query(sql);
}
else
{
sql = "insert into tblitems (ITEMID,`NAME`, `DESCRIPTION`, `TYPE`, `PRICE`, `QTY`,UNIT)" +
"VALUES ('" + txtitemid.Text + "','" + txtname.Text + "','" + txtdescription.Text + "','" + cbotype.Text
+ "','" + txtprice.Text + "','" + txtqty.Text + "','" + cbounit.Text + "' )";
config.Execute_CUD(sql, "No hay datos guardados.", "Los datos se han guardado en la base de datos.");
config.update_Autonumber(cbotype.Text);
}
btnnew_Click(sender, e);
}
private void btnsave_Click(object sender, EventArgs e)
{
foreach (Control obj in pnl_stockmaster.Controls)
{
if (obj is TextBox)
{
if (obj.Text == "")
{
MessageBox.Show("Action connot be perform. All fields are required to be fill up.", "Invalid", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
}
}
sql = "INSERT INTO `tblstock_in_out` (`ITEMID`, `QTY`,`TRANSACTIONDATE`, `TOTALPRICE`, `REMARKS`)" +
" VALUES ('" + txtitemid.Text + "','" + txtqty.Text + "','" + DateTime.Now.ToString("yyyy-MM-dd") + "','" + txtprice.Text +
"','StockIn')";
config.Execute_Query(sql);
sql = "SELECT ITEMID FROM tblitems WHERE ITEMID='" + txtitemid.Text + "'";
config.singleResult(sql);
if (config.dt.Rows.Count > 0)
{
sql = "UPDATE tblitems SET qty =qty + '" + txtqty.Text + "' WHERE ITEMID ='" + txtitemid.Text + "'";
config.Execute_Query(sql);
}
else
{
sql = "insert into tblitems (ITEMID,`NAME`, `DESCRIPTION`, `TYPE`, `PRICE`, `QTY`,UNIT)" +
"VALUES ('" + txtitemid.Text + "','" + txtname.Text + "','" + txtdescription.Text + "','" + cbotype.Text
+ "','" + txtprice.Text + "','" + txtqty.Text + "','" + cbounit.Text + "' )";
config.Execute_CUD(sql, "No data saved.", "Data has been saved in the database.");
config.update_Autonumber(cbotype.Text);
}
btnnew_Click(sender, e);
}
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);
}
private void btnPsave_Click(object sender, EventArgs e)
{
if (txtPNoDays.Text == "" || txtPregOt.Text == "" || txtPholPay.Text == "")
{
MessageBox.Show("One of the box is empty. Data is required.", "Info", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
else
{
sql = "INSERT INTO `other_deduction` "
+ "(`emp_code`, `deduct1`, `ded_amount1`, `deduct2`, `ded_amount2`, `deduct3`, "
+ "`ded_amount3`, `deduct4`, `ded_amount4`, `total_ded`,trans_id)"
+ " VALUES ('" + txtPAssignCode.Text + "','" + txtpdeductname1.Text + "','"
+ txtpdeduct1.Text + "','" + txtpdeductname2.Text + "','" + txtpdeduct2.Text
+ "','" + txtpdeductname3.Text + "','" + txtpdeductname3.Text
+ "','" + txtpdeductname4.Text + "','" + txtpdeductname4.Text
+ "','" + txtpdeducttot.Text + "','" + txttrancode.Text + "')";
config.Execute_Query(sql);
sql = "INSERT INTO `payroll` "
+ "(`emp_code`, `num_days`, `r_wage`, `overtime`, `hol_pay`, `gross_sal`"
+ ", `cash_ad`, `bread_vale`, `philhealth`, `pag-ibig`, `net_income`, `remarks`,`dateissued`,trans_id)"
+ " VALUES ('" + txtPAssignCode.Text + "','" + txtPNoDays.Text + "','"
+ txtPrateWage.Text + "','" + txtPregOt.Text + "','" + txtPholPay.Text
+ "','" + txtpgincome.Text + "','" + txtpcadvance.Text + "','" + txtbvale.Text
+ "','" + txtpphic.Text + "','" + txtppagibig.Text + "','" + txtpnetincome.Text
+ "','" + txtpremarks.Text + "',Now(),'" + txttrancode.Text + "')";
config.Execute_Query(sql);
MessageBox.Show("Data has been saved in the database.");
config.Execute_Query("UPDATE autonumber SET strnum = strnum + increment WHERE id =1");
txtPAssignCode.Text = "";
load_data();
}
}
private void UploadSecond(string txt)
{
sql = "INSERT INTO tblscannedfiles(EmpId, IMGCaption,ImgType,FilesLocation,DateUpload) " +
" VALUES (" + lblEmpId.Text + " ,'" + txt + "','" + ComboBox1.Text + "','" + txt + "','" + DateTime.Now.ToString("yyyy-MM-dd") + "')";
config.Execute_Query(sql);
}
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);
}
private void btnempsave_Click(object sender, EventArgs e)
{
string gender;
if (rdomale.Checked)
{
gender = "Male";
}
else
{
gender = "Female";
}
sql = "SELECT * FROM employees e ,employeesworkinfo w WHERE e.EMPLOYEE_ID=w.EMPLOYEE_ID AND e.EMPLOYEE_ID= " + txtempId.Text;
config.singleResult(sql);
if (txtfname.Text == "" || txtlname.Text == "" || txtaddress.Text == "" ||
txtage.Text == "" || txtcontact.Text == "" || cboJobType.Text == "Select" ||
txtstatus.Text == "" || cboJobStatus.Text == "" || cboJobType.Text == "Select")
{
MessageBox.Show("Empty Fields are required.", "Invalid", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
if (config.dt.Rows.Count > 0)
{
sql = "UPDATE `employees` E,`employeesworkinfo` W SET " +
"`FIRST_NAME`='" + txtfname.Text + "', `LAST_NAME`='" + txtlname.Text + "', `MIDDLE_NAME`='" + txtmname.Text +
"', `ADDRESS`='" + txtaddress.Text + "', `PHONE_NUMBER`='" + txtcontact.Text + "', `STATUS`='" + txtstatus.Text +
"', `BIRTH_DATE`='" + dtpdbirth.Text + "',`BIRTH_PLACE`='" + txtbplace.Text +
"', `GENDER`='" + gender + "', `AGE`='" + txtage.Text +
"',`EmailAdd`='" + txtEmailad.Text + "', `SocialAccnt`='" + txtSocialAdd.Text +
"',EMPIMAGE = '" + Path.GetFileName(PictureBox1.ImageLocation) +
"' WHERE E.`EMPLOYEE_ID`= W.`EMPLOYEE_ID` and E.`EMPLOYEE_ID`= '" + txtempId.Text + "' ";
config.Execute_CUD(sql, "No data update.", "Data has been updated in the database");
//sql = "";
//config.Execute_Query(sql);
}
else
{
sql = "insert into `employees` " +
"(`EMPLOYEE_ID`, `FIRST_NAME`, `LAST_NAME`, `MIDDLE_NAME`, `ADDRESS`, `PHONE_NUMBER`, `STATUS`, `BIRTH_DATE`," +
"`BIRTH_PLACE`, `GENDER`, `AGE`, `EMPIMAGE`,`EmailAdd`, `SocialAccnt`)" +
" VALUES " +
"('" + txtempId.Text + "','" + txtfname.Text + "','" + txtlname.Text + "','" + txtmname.Text +
"','" + txtaddress.Text + "','" + txtcontact.Text + "','" + txtstatus.Text + "','" + dtpdbirth.Text +
"','" + txtbplace.Text + "','" + gender + "','" + txtage.Text + "','" + Path.GetFileName(PictureBox1.ImageLocation) +
"','" + txtEmailad.Text + "','" + txtSocialAdd.Text + "' )";
config.Execute_CUD(sql, "No data save.", "Data has been saved in the database");
sql = "insert into `employeesworkinfo` (`EMPLOYEE_ID`, `JobStatus`, `JobType`, `D_HIRED`,EndDate,`SalaryGrade`, `Salary`, `Position`)" +
" values " +
" ('" + txtempId.Text + "','" + cboJobStatus.Text + "','" + cboJobType.Text +
"','" + dtpdhired.Text + "','" + dtpEndDate.Text +
"','" + txtSalaryGrade.Text + "','" + txtSalary.Text + "','" + txtPosition.Text + "')";
config.Execute_Query(sql);
}
if (txtPhoto.Text != "")
{
File.Copy(txtPhoto.Text, Application.StartupPath + "/Photo/" + Path.GetFileName(PictureBox1.ImageLocation), true);
}
btnNew_Click(sender, e);
}
private void btnCus_save_Click(object sender, EventArgs e)
{
string stockoutID;
config.singleResult("SELECT concat(STRT,END) FROM tblautonumber WHERE ID = 5");
stockoutID = config.dt.Rows[0].Field <string>(0);
if (txt_cusid.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 `tblitems`";
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 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_in_out` ( `TRANSACTIONNUMBER`, `ITEMID`, `TRANSACTIONDATE`, `QTY`, `TOTALPRICE`, `SUPLIERCUSTOMERID`,REMARKS)" +
" VALUES ('" + stockoutID + "','" + r.Cells[0].Value + "','" + DateTime.Now.ToString("yyyy-MM-dd") + "','" + r.Cells[4].Value +
"','" + r.Cells[5].Value + "','" + txt_cusid.Text + "','StockOut')";
config.Execute_Query(sql);
sql = "UPDATE `tblitems` SET `QTY`= QTY - '" + r.Cells[4].Value + "' WHERE ITEMID='" + r.Cells[0].Value + "'";
config.Execute_Query(sql);
}
sql = "INSERT INTO `tbltransaction` (`TRANSACTIONNUMBER`, `TRANSACTIONDATE`, `TYPE`, `SUPLIERCUSTOMERID`)" +
" VALUES ('" + stockoutID + "','" + DateTime.Now.ToString("yyyy-MM-dd") + "','StockOut','" + txt_cusid.Text + "')";
config.Execute_Query(sql);
// '-----------------------------------------------update autonumber
config.Execute_Query("UPDATE tblautonumber SET END= END + INCREMENT WHERE ID = 5");
// '------------------------------------------------------------
MessageBox.Show("Los productos han sido facturados correctamente. 'Clic en Ventas Hechas.'");
// '------------------------------------------------------------clearing
funct.clearTxt(Panel1);
dtCus_addedlist.Rows.Clear();
frmStockOut_Load(sender, e);
}
private void ChangePasswordForm_FormClosed(object sender, FormClosedEventArgs e)
{
config.Execute_Query("drop table temp");
}
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("There are empty fields left that must be fill up!", "Invalid", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
if (dtCus_addedlist.RowCount == 0)
{
MessageBox.Show("Cart is empty!", "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("The returned quantity of the item ( " + dtCus_addedlist.Rows[i].Cells[1].Value.ToString() + " ) is greater than the available quantity of it.", "Invalid", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
}
if (dtCus_addedlist.Rows[i].Cells[4].Value.ToString() == "")
{
MessageBox.Show("Set your purpose.", "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("Item(s) has been returned in the database.");
// '------------------------------------------------------------clearing
funct.clearTxt(GroupBox3);
dtCus_addedlist.Rows.Clear();
frmReturn_Load(sender, e);
}
private void btnCus_save_Click(object sender, EventArgs e)
{
string stockoutID;
config.singleResult("SELECT concat(STRT,END) FROM tblautonumber WHERE ID = 5");
stockoutID = config.dt.Rows[0].Field<string>(0);
if (txt_cusid.Text == "")
{
MessageBox.Show("There are empty fields left that must be fill up!", "Invalid", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
if(dtCus_addedlist.RowCount == 0)
{
MessageBox.Show("Cart is empty!", "Invalid", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
sql = "SELECT ITEMID,`QTY` FROM `tblitems`";
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("The Quantity of the item ( " + dtCus_addedlist.Rows[i].Cells[1].Value.ToString() + " ) is greater than the available quantity of it.", "Invalid", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
}
if (dtCus_addedlist.Rows[i].Cells[4].Value.ToString() == "")
{
MessageBox.Show("Set your purpose.", "Invalid", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
}
}
foreach(DataGridViewRow r in dtCus_addedlist.Rows)
{
sql = "INSERT INTO `tblstock_in_out` ( `TRANSACTIONNUMBER`, `ITEMID`, `TRANSACTIONDATE`, `QTY`, `TOTALPRICE`, `SUPLIERCUSTOMERID`,REMARKS)" +
" VALUES ('" + stockoutID + "','" + r.Cells[0].Value + "','" + DateTime.Now.ToString("yyyy-MM-dd") + "','" + r.Cells[4].Value +
"','" + r.Cells[5].Value + "','" + txt_cusid.Text + "','StockOut')";
config.Execute_Query(sql);
sql = "UPDATE `tblitems` SET `QTY`= QTY - '" + r.Cells[4].Value + "' WHERE ITEMID='" + r.Cells[0].Value + "'";
config.Execute_Query(sql);
}
sql = "INSERT INTO `tbltransaction` (`TRANSACTIONNUMBER`, `TRANSACTIONDATE`, `TYPE`, `SUPLIERCUSTOMERID`)" +
" VALUES ('" + stockoutID + "','" + DateTime.Now.ToString("yyyy-MM-dd") + "','StockOut','" + txt_cusid.Text + "')";
config.Execute_Query(sql);
config.Execute_Query("UPDATE tblautonumber SET END= END + INCREMENT WHERE ID = 5");
MessageBox.Show("Item(s) has been save in the database.");
funct.clearTxt(Panel1);
dtCus_addedlist.Rows.Clear();
frmStockOut_Load(sender, e);
}