private void UncheckApproval(DataGridViewCellEventArgs e) { if (e.RowIndex < 0) { return; } string empID = gvRecap.Rows[e.RowIndex].Cells[0].Value.ToString(); string fieldVal = "1"; bool val = (bool)gvRecap.Rows[e.RowIndex].Cells[e.ColumnIndex].Value; if (val) { fieldVal = "0"; } string appField = "SupApprove"; switch (gvRecap.Columns[e.ColumnIndex].Name) { case "OMApproved": appField = "OMApprove"; break; case "HOApproved": appField = "HOApprove"; break; } string sql = "UPDATE Timesheet SET " + appField + "= " + fieldVal; sql += " WHERE EmployeeID = " + empID; using (clsDataGetter dg = new clsDataGetter(CommonProcs.WCompanyConnStr)) { dg.RunCommand(sql); } FillTotalsView(); }
private void LoadEmployeeGrid() { string sql = "SELECT EmployeeID,Lastname,Firstname,Branch,TSApprover,TSSubmitter,isActive FROM Employee "; sql += "WHERE QBFile='" + GetCompany() + "' "; if (GetBranch() != "AA") { sql += "AND Branch = '" + GetBranch() + "' "; } switch (cbShow.SelectedIndex) { case 0: sql += "AND isActive = 1"; break; case 1: sql += "AND isActive = 0"; break; } DataSet ds = null; using (clsDataGetter dg = new clsDataGetter(CommonProcs.WCompanyConnStr)) { ds = dg.GetDataSet(sql); } // List<Employee> empList = new ReaderToModel<Employee>().CreateList(sql, CommonProcs.WCompanyConnStr); gvEmpList.DataSource = ds.Tables[0].DefaultView; }
private bool CheckApproved(TimesheetTotals tot, string type) { int empID = tot.EmployeeID; string sql = "SELECT * FROM Timesheet WHERE EmployeeID = " + empID; using (clsDataGetter dg = new clsDataGetter(CommonProcs.WCompanyConnStr)) { switch (type) { case "SUP": sql += " AND SupApprove = 0"; break; case "OM": sql += " AND OMApprove = 0"; break; case "HO": sql += " AND HOApprove = 0"; break; } if (dg.HasData(sql)) { return(false); } else { return(true); } } }
private void ApproveBySuper(DataGridViewCellEventArgs e) { string empId = gvRecap.Rows[e.RowIndex].Cells[0].Value.ToString(); using (clsDataGetter dg = new clsDataGetter(CommonProcs.WCompanyConnStr)) { string sql = "UPDATE Timesheet SET SupApprove = 1 WHERE EmployeeID = " + empId; dg.RunCommand(sql); } }
private void btnAdd_Click(object sender, EventArgs e) { Login login = new Login(); login.firstName = "New Login"; using (clsDataGetter dg = new clsDataGetter(CommonProcs.WCompanyConnStr)) { new ModelToSQL <Login>().WriteInsertSQL("Login", login, "userID", CommonProcs.WCompanyConnStr); } LoadLoginGrid(); }
public static void MakeMeetingPDF() { dg = new clsDataGetter("Data Source = 184.168.194.75; Initial Catalog = aaphones2; Persist Security Info = True; User ID = billwilson12; Password = keepitsimple62"); SqlDataReader dr = dg.GetDataReader("EXEC sp_GetMeetingsPrint"); MakePDFForm(@"D:\My Documents\Projects\dist23mvc\Dist23MVC\Dist23MVC\upload\district_23_template.pdf", @"D:\My Documents\Projects\dist23mvc\Dist23MVC\Dist23MVC\upload\district_23101.pdf", dr); dg.KillReader(dr); dr = dg.GetDataReader("EXEC sp_GetMeetingsPrint"); FillPDFForm(@"D:\My Documents\Projects\dist23mvc\Dist23MVC\Dist23MVC\upload\district_23101.pdf", @"D:\My Documents\Projects\dist23mvc\Dist23MVC\Dist23MVC\upload\district_23curr.pdf", dr); dg.KillReader(dr); }
private void LoadAccessLevels() { string sql = "SELECT * FROM AccessLevels"; using (clsDataGetter dg = new clsDataGetter(CommonProcs.WCompanyConnStr)) { System.Data.SqlClient.SqlDataReader dr = dg.GetDataReader(sql); while (dr.Read()) { string alStr = dr["accessLevelID"].ToString() + " - " + dr["accDesc"].ToString(); lbAccessLevels.Items.Add(alStr); } } }
private void LoadEmployeeGridFromSearch(string searchStr) { string sql = "SELECT EmployeeID,Lastname,Firstname,Branch,TSApprover,TSSubmitter,isActive FROM Employee "; sql += "WHERE FirstName LIKE '%" + searchStr + "%' "; sql += "OR LastName LIKE '%" + searchStr + "%' "; DataSet ds = null; using (clsDataGetter dg = new clsDataGetter(CommonProcs.WCompanyConnStr)) { ds = dg.GetDataSet(sql); } gvEmpList.DataSource = ds.Tables[0].DefaultView; }
private void ApproveAll(string btnName, string val) { string appField = "SupApprove"; if (btnName == "OM") { appField = "OMApprove"; } string sql = "UPDATE Timesheet SET " + appField + "= " + val; using (clsDataGetter dg = new clsDataGetter(CommonProcs.WCompanyConnStr)) { dg.RunCommand(sql); } }
private void toolStripMenuItem1_Click(object sender, EventArgs e) { if (gvTimesheet.SelectedRows.Count < 1) { MessageBox.Show("Please select the entry before trying to delete"); return; } string TimelineID = gvTimesheet.SelectedRows[0].Cells[0].Value.ToString(); using (clsDataGetter dg = new clsDataGetter(CommonProcs.WCompanyConnStr)) { string sql = "DELETE FROM Timesheet WHERE TimesheetID=" + TimelineID; dg.RunCommand(sql); } FillGridView(true); }
private bool CheckCompleteForRecap() { DateTime weekEnding = this.dtpWeekEnding.Value; string sql = "SELECT * FROM Timesheet "; sql += " WHERE WeekEnding = '" + weekEnding.ToShortDateString() + "' "; sql += "AND Complete = 0"; using (clsDataGetter dg = new clsDataGetter(CommonProcs.WCompanyConnStr)) { if (dg.HasData(sql)) { return(false); } } return(true); }
private string BuildEventFileName(string ext, int id = -1) { int nextKey = 0; if (id < 0) { clsDataGetter dg = new clsDataGetter(db.Database.Connection.ConnectionString); nextKey = dg.GetScalarInteger("SELECT MAX(pKey) FROM Events WHERE DistKey=" + GlobalVariables.DistNumber); nextKey += 1; } else { nextKey = id; } return("event_" + GlobalVariables.DistNumber + "_" + nextKey.ToString() + ext); }
private void btnClose_Click(object sender, EventArgs e) { Button btn = (Button)sender; if (btn.Text == "Close") { Close(); } else { using (clsDataGetter dg = new clsDataGetter(CommonProcs.WCompanyConnStr)) { dg.RunCommand("DELETE FROM Employee WHERE EmployeeID = " + lblEmpID.Text); } Close(); } }
private int GetOTPayrollItem(string RegHoursID) { using (clsDataGetter dg = new clsDataGetter(CommonProcs.WCompanyConnStr)) { string branchStr = GetCurrentBranch(); string nameSQL = "SELECT name FROM PayrollItem "; nameSQL += "WHERE payItemID=" + RegHoursID; string itemName = dg.GetScalarString(nameSQL); string[] nameParts = itemName.Split('-'); itemName = nameParts[0] + "-" + nameParts[1]; string IDSql = "SELECT payItemID FROM PayrollItem "; IDSql += "WHERE Name LIKE '%" + itemName + "-OT' "; IDSql += "AND WageType = 'HourlyOvertime' "; IDSql += "AND QBFile='" + GetCurrentCompany() + "'"; return(dg.GetScalarInteger(IDSql)); } }
private static string LookupEmail(string type, bool isDistrict) { Dist23Data db = new Dist23Data(); clsDataGetter dg = new clsDataGetter(db.Database.Connection.ConnectionString); string sql = "SELECT email FROM contacts c "; sql += "INNER JOIN ContactPosition cp ON cp.contactID = c.pKey "; sql += "INNER JOIN positions p ON p.pKey = cp.PositionID "; sql += "INNER JOIN groups g ON g.pKey = cp.GroupID "; sql += "WHERE positionName = '" + type + "' "; sql += "AND g.DistKey = " + GlobalVariables.DistKey; if (isDistrict) { sql += " AND g.isDistrict = 1"; } string email = dg.GetScalarString(sql); return(email); }
private void gvTimesheet_CellValueChanged(object sender, DataGridViewCellEventArgs e) { if (gvTimesheet.Columns[e.ColumnIndex].Name != "OTHours" && gvTimesheet.Columns[e.ColumnIndex].Name != "RegHours") { return; } string colName = gvTimesheet.Columns[e.ColumnIndex].Name; string newValue = gvTimesheet.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString(); if (newValue == string.Empty) { newValue = "0.0"; } string timeSheetID = gvTimesheet.Rows[e.RowIndex].Cells[0].Value.ToString(); using (clsDataGetter dg = new clsDataGetter(CommonProcs.WCompanyConnStr)) { string sql = "UPDATE Timesheet SET " + colName + " = " + newValue + " WHERE TimesheetID=" + timeSheetID; dg.RunCommand(sql); } FillGridView(true); }