/// <summary> /// To Insert details of Employeeattendance in tbl_EmployeeAttendance_M table /// Created By : Nafisa, 01-06-2015 /// Modified By : /// </summary> /// <param name="objEmployeeattendanceBO"></param> /// <returns></returns> public ApplicationResult Employeeattendance_Insert_ForBioMatric(EmployeeattendanceBo objEmployeeattendanceBO, string strAttendanceList, string strFilename) { try { pSqlParameter = new SqlParameter[7]; pSqlParameter[0] = new SqlParameter("@TrustMID", SqlDbType.Int); pSqlParameter[0].Direction = ParameterDirection.Input; pSqlParameter[0].Value = objEmployeeattendanceBO.TrustMID; pSqlParameter[1] = new SqlParameter("@SchoolMID", SqlDbType.Int); pSqlParameter[1].Direction = ParameterDirection.Input; pSqlParameter[1].Value = objEmployeeattendanceBO.SchoolMID; pSqlParameter[2] = new SqlParameter("@IsManual", SqlDbType.Int); pSqlParameter[2].Direction = ParameterDirection.Input; pSqlParameter[2].Value = objEmployeeattendanceBO.IsManual; pSqlParameter[3] = new SqlParameter("@CreateModifiedUserID", SqlDbType.Int); pSqlParameter[3].Direction = ParameterDirection.Input; pSqlParameter[3].Value = objEmployeeattendanceBO.CreateModifiedUserID; pSqlParameter[4] = new SqlParameter("@CreatedModifiedDate", SqlDbType.VarChar); pSqlParameter[4].Direction = ParameterDirection.Input; pSqlParameter[4].Value = objEmployeeattendanceBO.CreatedModifiedDate; pSqlParameter[5] = new SqlParameter("@AttendanceList", SqlDbType.VarChar); pSqlParameter[5].Direction = ParameterDirection.Input; pSqlParameter[5].Value = strAttendanceList; pSqlParameter[6] = new SqlParameter("@Filename", SqlDbType.VarChar); pSqlParameter[6].Direction = ParameterDirection.Input; pSqlParameter[6].Value = strFilename; sSql = "usp_tbl_EmployeeAttendance_M_Insert_ForBiomatric"; int iResult = Database.ExecuteNonQuery(CommandType.StoredProcedure, sSql, pSqlParameter); if (iResult > 0) { ApplicationResult objResults = new ApplicationResult(); objResults.status = ApplicationResult.CommonStatusType.SUCCESS; return(objResults); } else { ApplicationResult objResults = new ApplicationResult(); objResults.status = ApplicationResult.CommonStatusType.FAILURE; return(objResults); } } catch (Exception ex) { throw ex; } finally { objEmployeeattendanceBO = null; } }
protected void btnUpload_OnClick(object sender, EventArgs e) { try { if (FileUpload1.HasFile) { EmployeeattendanceBl objEmployeeAttendenceBL = new EmployeeattendanceBl(); EmployeeattendanceBo objEmployeeAttendenceBO = new EmployeeattendanceBo(); ApplicationResult objResults = new ApplicationResult(); ApplicationResult objBiomatric = new ApplicationResult(); string filename = Path.GetFileName(FileUpload1.FileName); FileUpload1.SaveAs(Server.MapPath("../Attendance/") + filename); StreamReader objInput = new StreamReader(Server.MapPath("../Attendance/" + filename), System.Text.Encoding.Default); string contents = objInput.ReadToEnd().Trim(); string[] split = System.Text.RegularExpressions.Regex.Split(contents, "\\s+", RegexOptions.None); var Attendance = string.Empty; foreach (string row in split) { if (Attendance == "") { Attendance = row.Replace("X", ""); } else { Attendance = Attendance + "," + row.Replace("X", ""); } } if (Attendance != "") { objEmployeeAttendenceBO.TrustMID = Convert.ToInt32(Session[ApplicationSession.TRUSTID].ToString()); objEmployeeAttendenceBO.SchoolMID = Convert.ToInt32(Session[ApplicationSession.SCHOOLID].ToString()); objEmployeeAttendenceBO.IsManual = 0; // 0 for Biomatric and 1 for Manual attendance. objEmployeeAttendenceBO.CreateModifiedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]); objEmployeeAttendenceBO.CreatedModifiedDate = DateTime.UtcNow.AddHours(5.5).ToString(); //objBiomatric = objEmployeeAttendenceBL.Employeeattendance_Select_ForBiomatric(Attendance, // filename); //if (objBiomatric != null) //{ // if (objBiomatric.resultDT.Rows.Count > 0) // { // ScriptManager.RegisterStartupScript(this, this.GetType(), "CallConfirmBox", "CallConfirmBox();", true); // } //} //else //{ //} objResults = objEmployeeAttendenceBL.Employeeattendance_Insert_ForBioMatric( objEmployeeAttendenceBO, Attendance, filename); } objInput.Close(); System.IO.File.Delete(Server.MapPath("../Attendance/" + filename)); ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Employee Attendance Updated Successfully.');</script>"); } else { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Select the File.');</script>"); } } catch (Exception ex) { logger.Error("Error", ex); ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical issue. Please Contact to your administrator.');</script>"); } }
protected void btnSave_Click(object sender, EventArgs e) { EmployeeattendanceBl objEmployeeAttendenceBL = new EmployeeattendanceBl(); EmployeeattendanceBo objEmployeeAttendenceBO = new EmployeeattendanceBo(); ApplicationResult objResults = new ApplicationResult(); try { int intCount = 0; int k = 0; DatabaseTransaction.OpenConnectionTransation(); foreach (GridViewRow row in gvEmployee.Rows) { ViewState["EmployeeMID"] = Convert.ToInt32(row.Cells[0].Text); objEmployeeAttendenceBO.EmployeeMID = Convert.ToInt32(row.Cells[0].Text); objEmployeeAttendenceBO.TrustMID = Convert.ToInt32(Session[ApplicationSession.TRUSTID]); objEmployeeAttendenceBO.SchoolMID = Convert.ToInt32(Session[ApplicationSession.SCHOOLID]); objEmployeeAttendenceBO.Date = txtdate.Text; objEmployeeAttendenceBO.InTime = (((TextBox)row.FindControl("txtIntime")).Text); objEmployeeAttendenceBO.OutTime = (((TextBox)row.FindControl("txtOuttime")).Text); objEmployeeAttendenceBO.Time = (((Label)row.FindControl("lblTime")).Text); objEmployeeAttendenceBO.TotalTime = (((TextBox)row.FindControl("txtTotalTime")).Text); if (((CheckBox)row.FindControl("chkChild")).Checked) { intCount += 1; if (objEmployeeAttendenceBO.InTime == "0" || objEmployeeAttendenceBO.OutTime == "0" || objEmployeeAttendenceBO.InTime == "" || objEmployeeAttendenceBO.OutTime == "") { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Please Fill Time " + row.Cells[0].Text + ".');</script>"); break; } DateTime dtIntime = Convert.ToDateTime((((TextBox)row.FindControl("txtIntime")).Text)); DateTime dtOutTime = Convert.ToDateTime((((TextBox)row.FindControl("txtOuttime")).Text)); if (dtIntime >= dtOutTime) { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Time Format Should be 24Hours Or OutTime Must be greater then InTime.');</script>"); break; } else { ApplicationResult objResultsInsert = new ApplicationResult(); if (ViewState["Mode"].ToString() == "Save") { objEmployeeAttendenceBO.CreatedModifiedDate = DateTime.UtcNow.AddHours(5.5).ToString(); objEmployeeAttendenceBO.CreateModifiedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]); objResultsInsert = objEmployeeAttendenceBL.Employeeattendance_Insert(objEmployeeAttendenceBO); divGrid.Visible = false; btnSave.Enabled = false; k += 1; } else { objEmployeeAttendenceBO.LastModifiedDate = DateTime.UtcNow.AddHours(5.5).ToString(); objEmployeeAttendenceBO.LastModifiedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]); objEmployeeAttendenceBO.EmployeeMID = Convert.ToInt32(ViewState["EmployeeMID"].ToString()); objResults = objEmployeeAttendenceBL.Employeeattendance_Update(objEmployeeAttendenceBO); if (objResults.status == ApplicationResult.CommonStatusType.SUCCESS) { k += 1; divGrid.Visible = false; btnSave.Enabled = false; } } } } } if (k == intCount) { DatabaseTransaction.CommitTransation(); ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Employee Attendence saved Successfully.');</script>"); divNote.Visible = false; } else { DatabaseTransaction.RollbackTransation(); } } catch (Exception ex) { DatabaseTransaction.RollbackTransation(); DatabaseTransaction.connection.Close(); logger.Error("Error", ex); ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical issue. Please Contact to your administrator.');</script>"); } }
/// <summary> /// To Update details of Employeeattendance in tbl_EmployeeAttendance_M table /// Created By : Nafisa, 01-06-2015 /// Modified By : /// </summary> /// <param name="objEmployeeattendanceBO"></param> /// <returns></returns> public ApplicationResult Employeeattendance_Update(EmployeeattendanceBo objEmployeeattendanceBO) { try { pSqlParameter = new SqlParameter[10]; pSqlParameter[0] = new SqlParameter("@EmployeeMID", SqlDbType.Int); pSqlParameter[0].Direction = ParameterDirection.Input; pSqlParameter[0].Value = objEmployeeattendanceBO.EmployeeMID; pSqlParameter[1] = new SqlParameter("@TrustMID", SqlDbType.Int); pSqlParameter[1].Direction = ParameterDirection.Input; pSqlParameter[1].Value = objEmployeeattendanceBO.TrustMID; pSqlParameter[2] = new SqlParameter("@SchoolMID", SqlDbType.Int); pSqlParameter[2].Direction = ParameterDirection.Input; pSqlParameter[2].Value = objEmployeeattendanceBO.SchoolMID; pSqlParameter[3] = new SqlParameter("@InTime", SqlDbType.VarChar); pSqlParameter[3].Direction = ParameterDirection.Input; pSqlParameter[3].Value = objEmployeeattendanceBO.InTime; pSqlParameter[4] = new SqlParameter("@OutTime", SqlDbType.VarChar); pSqlParameter[4].Direction = ParameterDirection.Input; pSqlParameter[4].Value = objEmployeeattendanceBO.OutTime; pSqlParameter[5] = new SqlParameter("@Date", SqlDbType.VarChar); pSqlParameter[5].Direction = ParameterDirection.Input; pSqlParameter[5].Value = objEmployeeattendanceBO.Date; pSqlParameter[6] = new SqlParameter("@LastModifiedUserID", SqlDbType.Int); pSqlParameter[6].Direction = ParameterDirection.Input; pSqlParameter[6].Value = objEmployeeattendanceBO.LastModifiedUserID; pSqlParameter[7] = new SqlParameter("@LastModifiedDate", SqlDbType.VarChar); pSqlParameter[7].Direction = ParameterDirection.Input; pSqlParameter[7].Value = objEmployeeattendanceBO.LastModifiedDate; pSqlParameter[8] = new SqlParameter("@Time", SqlDbType.VarChar); pSqlParameter[8].Direction = ParameterDirection.Input; pSqlParameter[8].Value = objEmployeeattendanceBO.Time; pSqlParameter[9] = new SqlParameter("@TotalTime", SqlDbType.VarChar); pSqlParameter[9].Direction = ParameterDirection.Input; pSqlParameter[9].Value = objEmployeeattendanceBO.TotalTime; sSql = "usp_tbl_EmployeeAttendance_M_Update"; int iResult = Database.ExecuteNonQuery(CommandType.StoredProcedure, sSql, pSqlParameter); if (iResult > 0) { ApplicationResult objResults = new ApplicationResult(); objResults.status = ApplicationResult.CommonStatusType.SUCCESS; return(objResults); } else { ApplicationResult objResults = new ApplicationResult(); objResults.status = ApplicationResult.CommonStatusType.FAILURE; return(objResults); } } catch (Exception ex) { throw ex; } finally { objEmployeeattendanceBO = null; } }