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