void BindGridAttendanceByEID() { try { string OCODE = ((SessionUser)Session["SessionUser"]).OCode; using (ERPSSLHBEntities context = new ERPSSLHBEntities()) { if (context.HRM_ATTENDANCE.Count() > 0) { var row = objAtt_BLL.GetAttendanceByEID(OCODE, txtEID.Text).ToList(); if (row.Count > 0) { GridViewEMP_AT.DataSource = row.ToList(); GridViewEMP_AT.DataBind(); } } else { var obj = new List <HRM_ATTENDANCE>(); obj.Add(new HRM_ATTENDANCE()); // Bind the DataTable which contain a blank row to the GridView GridViewEMP_AT.DataSource = obj; GridViewEMP_AT.DataBind(); int columnsCount = GridViewEMP_AT.Columns.Count; GridViewEMP_AT.Rows[0].Cells.Clear(); // clear all the cells in the row GridViewEMP_AT.Rows[0].Cells.Add(new TableCell()); //add a new blank cell GridViewEMP_AT.Rows[0].Cells[0].ColumnSpan = columnsCount; //set the column span to the new added cell GridViewEMP_AT.Rows[0].Cells[0].HorizontalAlign = HorizontalAlign.Center; GridViewEMP_AT.Rows[0].Cells[0].ForeColor = System.Drawing.Color.Red; GridViewEMP_AT.Rows[0].Cells[0].Font.Bold = true; //set No Results found to the new added cell GridViewEMP_AT.Rows[0].Cells[0].Text = "NO RECORDS FOUND!"; } } } catch (Exception ex) { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true); } }
protected void btnAttSubmit_Click(object sender, EventArgs e) { try { Attendance_BLL _attendancebll = new Attendance_BLL(); List <HRM_ATTENDANCE> attendances = new List <HRM_ATTENDANCE>(); foreach (GridViewRow gvRow in GridViewEMP_AT.Rows) { CheckBox rowChkBox = ((CheckBox)gvRow.FindControl("rowLevelCheckBox")); HRM_ATTENDANCE obj = new HRM_ATTENDANCE(); if (rowChkBox.Checked == true) { Label lblId = ((Label)gvRow.FindControl("lblId")); TextBox txtbxExtraOtAdd = ((TextBox)gvRow.FindControl("OTExtraAdd")); Label lblAttnDate = ((Label)gvRow.FindControl("lblAttnDate")); //Label lbltotalot = ((Label)gvRow.FindControl("lbltotalot")); //double totalOT = Convert.ToDouble(lbltotalot.Text); DateTime otDate = Convert.ToDateTime(lblAttnDate.Text); obj.ATTE_ID = Convert.ToInt32(lblId.Text); int AttId = Convert.ToInt32(obj.ATTE_ID); if (rdExtraOT.Checked) { obj.OT_ExtraAdd = Convert.ToInt32(txtbxExtraOtAdd.Text); // obj.OT_Total = totalOT + Convert.ToDouble(txtbxExtraOtAdd.Text); } else if (rdExtraOTDeduct.Checked) { obj.OT_Deduction = Convert.ToInt32(txtbxExtraOtAdd.Text); // obj.OT_Total = totalOT - Convert.ToDouble(txtbxExtraOtAdd.Text); } obj.OCode = ((SessionUser)Session["SessionUser"]).OCode; obj.Edit_Date = DateTime.Now; obj.Edit_User = ((SessionUser)Session["SessionUser"]).UserId; var result = objAtt_BLL.UpdateAttendanceOT(obj, AttId); if (result == 1) { //ot process string OCODE = Convert.ToString(((SessionUser)Session["SessionUser"]).OCode); string userId = Convert.ToString(((SessionUser)Session["SessionUser"]).UserId); objAtt_BLL.UpdateOT_ByShift_EID(otDate, otDate, hdnEmployeeShiftCode.Value, txtEid_AT.Text); //ot process log var ParamempID1 = new SqlParameter("@DateFrom", Convert.ToDateTime(otDate)); var ParamempID2 = new SqlParameter("@DateTo", Convert.ToDateTime(otDate)); var ParamempID3 = new SqlParameter("@Edit_User", userId); var ParamempID4 = new SqlParameter("@Edit_Date", DateTime.Now); var ParamempID5 = new SqlParameter("@OCODE", OCODE); string SP_SQL = "HRM_Insert_OTProcessLog @DateFrom, @DateTo, @Edit_User, @Edit_Date, @OCODE"; context.ExecuteStoreCommand(SP_SQL, ParamempID1, ParamempID2, ParamempID3, ParamempID4, ParamempID5); ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Update Successfully.')", true); // load grid DateTime fromdate = Convert.ToDateTime(txtfromDate.Text); DateTime toDate = Convert.ToDateTime(txtToDate.Text); var row = objAtt_BLL.GetAttendanceByEID(txtEid_AT.Text).Where(x => x.Attendance_Date >= fromdate && x.Attendance_Date <= toDate).ToList(); if (row.Count > 0) { GridViewEMP_AT.DataSource = row.ToList(); GridViewEMP_AT.DataBind(); } else { GridViewEMP_AT.DataSource = null; GridViewEMP_AT.DataBind(); } /// } } } ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('No Employee selected in the list!')", true); } catch (Exception ex) { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true); } }