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 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); } }
protected void Button1_Click(object sender, EventArgs e) { string sql = "UPDATE SiteConfig SET BannerTitle='" + tbBannerTitle.Text + "',"; sql += "BannerSubTitle='" + tbBannerSubTitle.Text + "',"; sql += "HotlinePh='" + tbHotlinePh.Text + "',"; sql += "AltHotline='" + tbAltHotline.Text + "',"; sql += "AltHotlineMsg='" + tbAltHotlineMsg.Text + "'"; sql += " WHERE DistKey=" + Session["DistKey"].ToString(); dg.RunCommand(sql); }
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 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 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); }