protected void btnSave_Click(object sender, EventArgs e) { ViewState["ClassMID"] = Convert.ToInt32(Request.Form[ddlClass.UniqueID]); ViewState["DivisionName"] = Convert.ToInt32(Request.Form[ddlDivision.UniqueID]); ViewState["AcademicYear"] = ddlAcademicYear.SelectedItem.ToString(); StudentAttendenceBL objStudentAttendenceBL = new StudentAttendenceBL(); StudentAttendenceBO objStudentAttendenceBO = new StudentAttendenceBO(); ApplicationResult objResults = new ApplicationResult(); try { string PresentIds = string.Empty; string AbsentIds = string.Empty; int Count = 0; foreach (GridViewRow row in gvStudent.Rows) { ViewState["StudentMID"] = Convert.ToInt32(row.Cells[0].Text); if (((CheckBox)row.FindControl("chkChild")).Checked) { PresentIds += ViewState["StudentMID"].ToString() + ","; Count = Count + 1; } else { AbsentIds += ViewState["StudentMID"].ToString() + ","; } } objStudentAttendenceBO.PresentStudentIDs = PresentIds.TrimEnd(','); objStudentAttendenceBO.AbsentStudentIds = AbsentIds.TrimEnd(','); objStudentAttendenceBO.TrustMID = Convert.ToInt32(Session[ApplicationSession.TRUSTID]); objStudentAttendenceBO.SchoolMID = Convert.ToInt32(Session[ApplicationSession.SCHOOLID]); objStudentAttendenceBO.EmployeeMID = Convert.ToInt32(Session[ApplicationSession.USERID]); objStudentAttendenceBO.ClassMID = Convert.ToInt32(ViewState["ClassMID"].ToString()); objStudentAttendenceBO.DivisionTID = Convert.ToInt32(ViewState["DivisionName"].ToString()); objStudentAttendenceBO.AcademicYear = ViewState["AcademicYear"].ToString(); objStudentAttendenceBO.Date = txtdate.Text; objStudentAttendenceBO.LastModifiedDate = DateTime.UtcNow.AddHours(5.5).ToString(); objStudentAttendenceBO.Time = System.DateTime.Now.ToShortTimeString(); objStudentAttendenceBO.LastModifiedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]); if (Count > 0) { if (ViewState["Mode"].ToString() == "Save") { objResults = objStudentAttendenceBL.StudentAttendence_Insert(objStudentAttendenceBO); if (objResults.status == ApplicationResult.CommonStatusType.SUCCESS) { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Student Attendence Done Successfully.');</script>"); } } else { objStudentAttendenceBO.StudentAttendenceMID = Convert.ToInt32(ViewState["StudentAttendenceMID"].ToString()); objResults = objStudentAttendenceBL.StudentAttendence_Update(objStudentAttendenceBO); if (objResults.status == ApplicationResult.CommonStatusType.SUCCESS) { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Student Attendence Updated Successfully.');</script>"); ViewState["Mode"] = "Save"; } } } else { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Select Any One Checkbox For Attendence.');</script>"); ViewState["ClassMID"] = Convert.ToInt32(Request.Form[ddlClass.UniqueID]); ViewState["DivisionName"] = Convert.ToInt32(Request.Form[ddlDivision.UniqueID]); ViewState["AcademicYear"] = ddlAcademicYear.SelectedItem.ToString(); hfCLassMID.Value = ViewState["ClassMID"].ToString(); hfDivisionTID.Value = ViewState["DivisionName"].ToString(); Page.ClientScript.RegisterStartupScript(this.GetType(), "CallMyFunction", "BindDorpdownOnButtonClick();", true); } BindStudentGrid(); Page.ClientScript.RegisterStartupScript(this.GetType(), "CallMyFunction", "BindSection();", true); } 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>"); } }
/// <summary> /// To Update details of StudentAttendence in tbl_StudentAttendence_M table /// Created By : Nafisa, 27-10-2014 /// Modified By : /// </summary> /// <param name="objStudentAttendenceBO"></param> /// <returns></returns> public ApplicationResult StudentAttendence_Update(StudentAttendenceBO objStudentAttendenceBO) { try { pSqlParameter = new SqlParameter[14]; pSqlParameter[0] = new SqlParameter("@StudentAttendenceMID", SqlDbType.Int); pSqlParameter[0].Direction = ParameterDirection.Input; pSqlParameter[0].Value = objStudentAttendenceBO.StudentAttendenceMID; pSqlParameter[1] = new SqlParameter("@TrustMID", SqlDbType.Int); pSqlParameter[1].Direction = ParameterDirection.Input; pSqlParameter[1].Value = objStudentAttendenceBO.TrustMID; pSqlParameter[2] = new SqlParameter("@SchoolMID", SqlDbType.Int); pSqlParameter[2].Direction = ParameterDirection.Input; pSqlParameter[2].Value = objStudentAttendenceBO.SchoolMID; pSqlParameter[3] = new SqlParameter("@EmployeeMID", SqlDbType.Int); pSqlParameter[3].Direction = ParameterDirection.Input; pSqlParameter[3].Value = objStudentAttendenceBO.EmployeeMID; pSqlParameter[4] = new SqlParameter("@ClassMID", SqlDbType.Int); pSqlParameter[4].Direction = ParameterDirection.Input; pSqlParameter[4].Value = objStudentAttendenceBO.ClassMID; pSqlParameter[5] = new SqlParameter("@DivisionTID", SqlDbType.Int); pSqlParameter[5].Direction = ParameterDirection.Input; pSqlParameter[5].Value = objStudentAttendenceBO.DivisionTID; pSqlParameter[6] = new SqlParameter("@AcademicYear", SqlDbType.VarChar); pSqlParameter[6].Direction = ParameterDirection.Input; pSqlParameter[6].Value = objStudentAttendenceBO.AcademicYear; pSqlParameter[7] = new SqlParameter("@PresentStudentIDs", SqlDbType.VarChar); pSqlParameter[7].Direction = ParameterDirection.Input; pSqlParameter[7].Value = objStudentAttendenceBO.PresentStudentIDs; pSqlParameter[8] = new SqlParameter("@AbsentStudentIds", SqlDbType.VarChar); pSqlParameter[8].Direction = ParameterDirection.Input; pSqlParameter[8].Value = objStudentAttendenceBO.AbsentStudentIds; pSqlParameter[9] = new SqlParameter("@Date", SqlDbType.VarChar); pSqlParameter[9].Direction = ParameterDirection.Input; pSqlParameter[9].Value = objStudentAttendenceBO.Date; pSqlParameter[10] = new SqlParameter("@Time", SqlDbType.VarChar); pSqlParameter[10].Direction = ParameterDirection.Input; pSqlParameter[10].Value = objStudentAttendenceBO.Time; pSqlParameter[11] = new SqlParameter("@LastModifiedUserID", SqlDbType.Int); pSqlParameter[11].Direction = ParameterDirection.Input; pSqlParameter[11].Value = objStudentAttendenceBO.LastModifiedUserID; pSqlParameter[12] = new SqlParameter("@LastModifiedDate", SqlDbType.VarChar); pSqlParameter[12].Direction = ParameterDirection.Input; pSqlParameter[12].Value = objStudentAttendenceBO.LastModifiedDate; pSqlParameter[13] = new SqlParameter("@IsDeleted", SqlDbType.Int); pSqlParameter[13].Direction = ParameterDirection.Input; pSqlParameter[13].Value = objStudentAttendenceBO.IsDeleted; sSql = "usp_tbl_StudentAttendence_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 { objStudentAttendenceBO = null; } }