private void getPayrollISAPRecord() { conDB = new ConnectionDB(); queryString = "SELECT empID, isap, concat(lastname,', ', firstname) as fullname, tblpayroll.startdate" + " FROM (tblpayroll INNER JOIN tblemployees ON tblpayroll.empID = tblemployees.ID)" + " WHERE tblpayroll.isDeleted = 0 AND empID = ? AND isap > 0"; parameters = new List <string>(); parameters.Add(employeeID); ISAPModel isapMod = new ISAPModel(); MySqlDataReader reader = conDB.getSelectConnection(queryString, parameters); while (reader.Read()) { isapMod.FullName = reader["fullname"].ToString(); DateTime dte = DateTime.Parse(reader["startdate"].ToString()); isapMod.DateAdded = dte.ToShortDateString(); isapMod.CurrentISAP = reader["isap"].ToString(); isapMod.Remarks = "AUTO-PAYSLIP"; lstISAP.Add(isapMod); isapMod = new ISAPModel(); } conDB.closeConnection(); }
private void getISAPRecord() { conDB = new ConnectionDB(); lstISAP = new List <ISAPModel>(); ISAPModel isapMod = new ISAPModel(); queryString = "SELECT tblemployees.ID, concat(lastname,', ', firstname) as fullname, dateadded, " + "existingisap FROM (tblemployees INNER JOIN tblisap ON " + "tblemployees.ID = tblisap.empID) " + "WHERE tblemployees.isDeleted = 0 AND tblisap.isDeleted = 0 AND tblemployees.ID = ?"; parameters = new List <string>(); parameters.Add(employeeID); MySqlDataReader reader = conDB.getSelectConnection(queryString, parameters); while (reader.Read()) { isapMod.FullName = reader["fullname"].ToString(); DateTime dte = DateTime.Parse(reader["dateadded"].ToString()); isapMod.DateAdded = dte.ToShortDateString(); isapMod.CurrentISAP = reader["existingisap"].ToString(); isapMod.Remarks = "MANUAL-ADMIN"; lstISAP.Add(isapMod); isapMod = new ISAPModel(); } conDB.closeConnection(); }
private void btnDetails_Click(object sender, RoutedEventArgs e) { ISAPModel intact = dgvISAP.SelectedItem as ISAPModel; if (intact != null) { ISAPDetails isDetails = new ISAPDetails(intact.empID); isDetails.ShowDialog(); } }
private List <ISAPModel> getISAPToADD() { List <ISAPModel> listISAP = new List <ISAPModel>(); ISAPModel isaps = new ISAPModel(); conDB = new ConnectionDB(); queryString = "SELECT empID, sum(isap) as isap FROM tblpayroll WHERE tblpayroll.isDeleted = 0 GROUP BY empID"; MySqlDataReader reader = conDB.getSelectConnection(queryString, null); while (reader.Read()) { isaps.empID = reader["empID"].ToString(); isaps.ISAPtoAdd = reader["isap"].ToString(); listISAP.Add(isaps); isaps = new ISAPModel(); } conDB.closeConnection(); return(listISAP); }
private List <ISAPModel> getISAPRecord() { List <ISAPModel> lstisap = new List <ISAPModel>(); ISAPModel isap = new ISAPModel(); conDB = new ConnectionDB(); double isapAddedByAdmin = 0; queryString = "SELECT tblisap.empid, sum(existingisap) as existingisap, concat(lastname,' , ', firstname) as fullname, " + "dateadded FROM (tblisap INNER JOIN tblemployees ON " + "tblisap.empID = tblemployees.ID) WHERE tblisap.isDeleted = 0 GROUP BY tblisap.empid"; MySqlDataReader reader = conDB.getSelectConnection(queryString, null); while (reader.Read()) { isap.empID = reader["empID"].ToString(); isap.FullName = reader["fullname"].ToString(); double current = Convert.ToDouble(reader["existingisap"].ToString()); foreach (ISAPModel ism in lstISAPToAdd) { if (isap.empID.Equals(ism.empID)) { current = current + Convert.ToDouble(ism.ISAPtoAdd); } } DateTime dte = DateTime.Parse(reader["dateadded"].ToString()); isap.DateAdded = dte.ToShortDateString(); isap.CurrentISAP = current.ToString(); isapAddedByAdmin = isapAddedByAdmin + current; lstisap.Add(isap); isap = new ISAPModel(); } lblTotalISAP.Content = "Total: " + isapAddedByAdmin.ToString("N0"); conDB.closeConnection(); return(lstisap); }