private void getPayrollISRecord()
{
conDB = new ConnectionDB();
queryString = "SELECT empID, isavings, concat(lastname,', ', firstname) as fullname, tblpayroll.startdate" +
" FROM (tblpayroll INNER JOIN tblemployees ON tblpayroll.empID = tblemployees.ID)" +
" WHERE tblpayroll.isDeleted = 0 AND empID = ? AND isavings > 0";
parameters = new List <string>();
parameters.Add(employeeID);
IntactSavingsModel isMod = new IntactSavingsModel();
MySqlDataReader reader = conDB.getSelectConnection(queryString, parameters);
while (reader.Read())
{
isMod.FullName = reader["fullname"].ToString();
DateTime dte = DateTime.Parse(reader["startdate"].ToString());
isMod.DateAdded = dte.ToShortDateString();
isMod.CurrentIS = reader["isavings"].ToString();
isMod.Remarks = "AUTO-PAYSLIP";
lstIS.Add(isMod);
isMod = new IntactSavingsModel();
}
conDB.closeConnection();
}
private void getIntactSavingsRecord()
{
conDB = new ConnectionDB();
lstIS = new List <IntactSavingsModel>();
IntactSavingsModel isMod = new IntactSavingsModel();
queryString = "SELECT tblemployees.ID, concat(lastname,', ', firstname) as fullname, dateadded, " +
"existingIS FROM (tblemployees INNER JOIN tblintactsavings ON " +
"tblemployees.ID = tblintactsavings.empID) " +
"WHERE tblemployees.isDeleted = 0 AND tblintactsavings.isDeleted = 0 AND tblemployees.ID = ?";
parameters = new List <string>();
parameters.Add(employeeID);
MySqlDataReader reader = conDB.getSelectConnection(queryString, parameters);
while (reader.Read())
{
isMod.FullName = reader["fullname"].ToString();
DateTime dte = DateTime.Parse(reader["dateadded"].ToString());
isMod.DateAdded = dte.ToShortDateString();
isMod.CurrentIS = reader["existingIS"].ToString();
isMod.Remarks = "MANUAL-ADMIN";
lstIS.Add(isMod);
isMod = new IntactSavingsModel();
}
conDB.closeConnection();
}
private void btnDetails_Click(object sender, RoutedEventArgs e)
{
IntactSavingsModel intact = dgvIS.SelectedItem as IntactSavingsModel;
if (intact != null)
{
IntactSavingsDetails isDetails = new IntactSavingsDetails(intact.empID);
isDetails.ShowDialog();
}
}
private List <IntactSavingsModel> getSavingsToAdd()
{
List <IntactSavingsModel> lstIntactSavings = new List <IntactSavingsModel>();
IntactSavingsModel intactsavings = new IntactSavingsModel();
conDB = new ConnectionDB();
queryString = "SELECT empID, sum(isavings) as isavings FROM tblpayroll WHERE tblpayroll.isDeleted = 0 GROUP BY empID";
MySqlDataReader reader = conDB.getSelectConnection(queryString, null);
while (reader.Read())
{
intactsavings.empID = reader["empID"].ToString();
intactsavings.SavingsToAdd = reader["isavings"].ToString();
lstIntactSavings.Add(intactsavings);
intactsavings = new IntactSavingsModel();
}
conDB.closeConnection();
return(lstIntactSavings);
}
private List <IntactSavingsModel> getIntactSavingsRecord()
{
List <IntactSavingsModel> lstIntactSavings = new List <IntactSavingsModel>();
IntactSavingsModel intactsavings = new IntactSavingsModel();
double isAddedByAdmin = 0;
conDB = new ConnectionDB();
queryString = "SELECT tblintactsavings.empid, sum(existingis) as existingis, concat(lastname,' , ', firstname) as fullname," +
" dateadded FROM (tblintactsavings INNER JOIN tblemployees ON " +
"tblintactsavings.empID = tblemployees.ID) WHERE tblintactsavings.isDeleted = 0 GROUP BY tblintactsavings.empid";
MySqlDataReader reader = conDB.getSelectConnection(queryString, null);
while (reader.Read())
{
intactsavings.empID = reader["empID"].ToString();
intactsavings.FullName = reader["fullname"].ToString();
double current = Convert.ToDouble(reader["existingIS"].ToString());
foreach (IntactSavingsModel ism in lstSavingsToAdd)
{
if (intactsavings.empID.Equals(ism.empID))
{
current = current + Convert.ToDouble(ism.SavingsToAdd);
}
}
DateTime dte = DateTime.Parse(reader["dateadded"].ToString());
intactsavings.DateAdded = dte.ToShortDateString();
intactsavings.CurrentIS = current.ToString();
isAddedByAdmin = isAddedByAdmin + current;
lstIntactSavings.Add(intactsavings);
intactsavings = new IntactSavingsModel();
}
lblTotalIS.Content = "Total: " + isAddedByAdmin.ToString("N0");
conDB.closeConnection();
return(lstIntactSavings);
}
