protected void btnSave_Click(object sender, EventArgs e) { try { LeaveTemplateBo objLeaveTemplateBo = new LeaveTemplateBo(); LeaveTemplateBl objLeaveTemplateBl = new LeaveTemplateBl(); ApplicationResult objResult = new ApplicationResult(); int k = 0; int intCount = 0; DatabaseTransaction.OpenConnectionTransation(); foreach (GridViewRow row in gvLeave.Rows) { objLeaveTemplateBo.EmployeeMID = Convert.ToInt32(hfEmployeeID.Value); objLeaveTemplateBo.LeaveID = Convert.ToInt32(row.Cells[0].Text); objLeaveTemplateBo.Total = (((TextBox)row.FindControl("txtTotalLeaves")).Text); objLeaveTemplateBo.AcademicYear = ddlYear.Text; objLeaveTemplateBo.CreatedBy = Convert.ToInt32(Session[ApplicationSession.USERID]); objLeaveTemplateBo.CreatedDate = DateTime.UtcNow.AddHours(5.5).ToString(); objLeaveTemplateBo.LastModifiedBy = Convert.ToInt32(Session[ApplicationSession.USERID]); objLeaveTemplateBo.LastModifiedDate = DateTime.UtcNow.AddHours(5.5).ToString(); if (((CheckBox)row.FindControl("chkChild")).Checked) { intCount += 1; if (objLeaveTemplateBo.Total == "0") { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Please Fill Total Leaves " + row.Cells[0].Text + ".');</script>"); break; } else { objResult = objLeaveTemplateBl.LeaveTemplate_Insert(objLeaveTemplateBo); if (objResult != null) { k += 1; } } } else { objResult = objLeaveTemplateBl.LeaveTemplate_Delete(objLeaveTemplateBo); } } if (k == intCount) { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Leave Template Updated Successfully.');</script>"); DatabaseTransaction.CommitTransation(); ClearAll(); gvLeave.Visible = false; } else { DatabaseTransaction.RollbackTransation(); //DatabaseTransaction.connection.Close(); } } catch (Exception ex) { DatabaseTransaction.RollbackTransation(); logger.Error("Error", ex); ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical issue. Please Contact to your administrator.');</script>"); } }
public async Task AssertCreatedCategory(ApplicationUserDbContext inMemoryContext, ApplicationResult <CategoryDto> resultCreate, CreateCategoryInput fakeCategory) { Assert.True(resultCreate.Succeeded); Assert.NotNull(resultCreate.Result); Assert.Equal(1, await inMemoryContext.Categories.CountAsync()); var item = await inMemoryContext.Categories.FirstOrDefaultAsync(); Assert.Equal(fakeCategory.CreatedBy, item.CreatedBy); Assert.Equal(fakeCategory.Name, item.Name); Assert.Equal(fakeCategory.UrlName, item.UrlName); Assert.Equal(resultCreate.Result.CreatedById, item.CreatedById); }
protected void gvRole_OnRowCommand(object sender, GridViewCommandEventArgs e) { try { ApplicationResult objResult = new ApplicationResult(); LeaveApplyBl objLeaveApplyBl = new LeaveApplyBl(); if (e.CommandName.ToString() == "Edit1") { if (ddlStatus.SelectedValue != "0") { ViewState["LeaveApplyID"] = e.CommandArgument.ToString(); objResult = objLeaveApplyBl.LeaveApply_Select_ForApprove(Convert.ToInt32(e.CommandArgument.ToString())); if (objResult != null) { if (objResult.resultDT.Rows.Count > 0) { DataTable dt = new DataTable(); dt.Rows.Clear(); dt.Columns.Add("NO"); for (var i = 1; i <= objResult.resultDT.Rows.Count; i++) { dt.Rows.Add(this.ToString()); } gvLeave.DataSource = dt; gvLeave.DataBind(); BindLeaveType(); for (var i = 0; i < gvLeave.Rows.Count; i++) { if ( objResult.resultDT.Rows[i][LeaveApprovalBo.LEAVEAPPROVAL_ISAPPROVED].ToString() == "1") { ((CheckBox)(gvLeave.Rows[i].Cells[1].FindControl("cbApprove"))).Checked = true; } else if (objResult.resultDT.Rows[i][LeaveApprovalBo.LEAVEAPPROVAL_ISAPPROVED].ToString() == "2") { ((CheckBox)(gvLeave.Rows[i].Cells[1].FindControl("cbApprove"))).Checked = false; } ((Label)(gvLeave.Rows[i].Cells[0].FindControl("lblLeaveApprovalID"))).Text = objResult.resultDT.Rows[i][LeaveApprovalBo.LEAVEAPPROVAL_LEAVEAPPROVALID] .ToString(); ((TextBox)(gvLeave.Rows[i].Cells[2].FindControl("txtGridDates"))).Text = objResult.resultDT.Rows[i][LeaveApprovalBo.LEAVEAPPROVAL_APPLYDATE].ToString(); ((DropDownList)(gvLeave.Rows[i].Cells[4].FindControl("ddlLeaveType"))) .SelectedValue = objResult.resultDT.Rows[i][LeaveApprovalBo.LEAVEAPPROVAL_LEAVEID].ToString(); if ( objResult.resultDT.Rows[i][LeaveApprovalBo.LEAVEAPPROVAL_ISHALFDAY].ToString() == "1") { ((CheckBox)(gvLeave.Rows[i].Cells[3].FindControl("cbHalfDay"))).Checked = true; } else { ((CheckBox)(gvLeave.Rows[i].Cells[3].FindControl("cbHalfDay"))).Checked = false; } ((TextBox)(gvLeave.Rows[i].Cells[2].FindControl("txtGridDates"))).Enabled = false; ((DropDownList)(gvLeave.Rows[i].Cells[4].FindControl("ddlLeaveType"))).Enabled = false; ((CheckBox)(gvLeave.Rows[i].Cells[3].FindControl("cbHalfDay"))).Enabled = false; } ViewState["Mode"] = "Edit"; PanelVisibility(4); } } } else { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('This leave has not approved yet,You can not edit.');</script>"); } } else if (e.CommandName.ToString() == "Approve1") { if (ddlStatus.SelectedValue.ToString() != "1") { #region Bind Leave Balance GridViewRow gvr = (GridViewRow)((Control)e.CommandSource).NamingContainer; int rowIndex = gvr.RowIndex; int empid = Convert.ToInt32(gvLeaveApprove.Rows[rowIndex].Cells[1].Text); LeaveBl objLeaveBl = new LeaveBl(); objResult = objLeaveBl.Leave_Select_ForBalance(empid);//Convert.ToInt32(Session[ApplicationSession.USERID].ToString()) + <%# Eval("EmployeeMID") %> if (objResult != null) { if (objResult.resultDT.Rows.Count > 0) { gvLeaveBalance.DataSource = objResult.resultDT; gvLeaveBalance.DataBind(); } } #endregion //objLeaveApprovalBo.EmployeeMID = Convert.ToInt32(e.CommandArgument.ToString()); ViewState["LeaveApplyID"] = e.CommandArgument.ToString(); objResult = objLeaveApplyBl.LeaveApply_Select_ForApprove(Convert.ToInt32(e.CommandArgument.ToString())); if (objResult != null) { if (objResult.resultDT.Rows.Count > 0) { DataTable dt = new DataTable(); dt.Rows.Clear(); dt.Columns.Add("NO"); for (var i = 1; i <= objResult.resultDT.Rows.Count; i++) { dt.Rows.Add(this.ToString()); } gvLeave.DataSource = dt; gvLeave.DataBind(); BindLeaveType(); for (var i = 0; i < gvLeave.Rows.Count; i++) { ((Label)(gvLeave.Rows[i].Cells[0].FindControl("lblLeaveApprovalID"))).Text = objResult.resultDT.Rows[i][LeaveApprovalBo.LEAVEAPPROVAL_LEAVEAPPROVALID] .ToString(); ((TextBox)(gvLeave.Rows[i].Cells[2].FindControl("txtGridDates"))).Text = objResult.resultDT.Rows[i][LeaveApprovalBo.LEAVEAPPROVAL_APPLYDATE].ToString(); ((DropDownList)(gvLeave.Rows[i].Cells[4].FindControl("ddlLeaveType"))) .SelectedValue = objResult.resultDT.Rows[i][LeaveApprovalBo.LEAVEAPPROVAL_LEAVEID].ToString(); if ( objResult.resultDT.Rows[i][LeaveApprovalBo.LEAVEAPPROVAL_ISHALFDAY].ToString() == "1") { ((CheckBox)(gvLeave.Rows[i].Cells[3].FindControl("cbHalfDay"))).Checked = true; } else { ((CheckBox)(gvLeave.Rows[i].Cells[3].FindControl("cbHalfDay"))).Checked = false; } ((TextBox)(gvLeave.Rows[i].Cells[2].FindControl("txtGridDates"))).Enabled = false; ((DropDownList)(gvLeave.Rows[i].Cells[4].FindControl("ddlLeaveType"))).Enabled = false; ((CheckBox)(gvLeave.Rows[i].Cells[3].FindControl("cbHalfDay"))).Enabled = false; } ViewState["Mode"] = "Approve"; PanelVisibility(4); } } } else { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('This Leave has already approved.');</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>"); } }
public async Task <ApplicationResult <TestCaseDetailResonseModel> > GetTestCaseDetail(int testCaseSeq) { var response = await _testCaseBusiness.GetTestCaseDetailAsync(testCaseSeq); return(ApplicationResult <TestCaseDetailResonseModel> .Ok(response)); }
public async Task GetAllCategory() { var options = new DbContextOptionsBuilder <ApplicationUserDbContext>().UseInMemoryDatabase(databaseName: "Test_GetAllCategory").Options; MapperConfiguration mappingConfig = new MapperConfiguration(mc => { mc.AddProfile(new AutoMapperProfile()); }); IMapper mapper = mappingConfig.CreateMapper(); List <ApplicationResult <CategoryDto> > resultCreates = new List <ApplicationResult <CategoryDto> >(); // Iki kategori olustur using (var inMemoryContext = new ApplicationUserDbContext(options)) { var fakeCategory1 = new CreateCategoryInput { CreatedById = Guid.NewGuid().ToString(), // sahte kullanici CreatedBy = "Tester1", Name = "Lorem Ipsum 1", UrlName = "lorem-ipsum-1" }; var fakeCategory2 = new CreateCategoryInput { CreatedById = Guid.NewGuid().ToString(), // sahte kullanici CreatedBy = "Tester2", Name = "Lorem Ipsum 2", UrlName = "lorem-ipsum-2" }; resultCreates.Add(await CreateCategory(inMemoryContext, mapper, fakeCategory1)); resultCreates.Add(await CreateCategory(inMemoryContext, mapper, fakeCategory2)); } ApplicationResult <List <CategoryDto> > resultGetAll = new ApplicationResult <List <CategoryDto> >(); // create servis dogru calistimi kontrol et ve get servisi calistir using (var inMemoryContext = new ApplicationUserDbContext(options)) { // create servis duzgun calisti mi? foreach (var resultCreate in resultCreates) { Assert.True(resultCreate.Succeeded); Assert.NotNull(resultCreate.Result); } // get islemini calistir var service = new CategoryService(inMemoryContext, mapper); resultGetAll = await service.GetAll(); } // get servis dogru calistimi kontrol et using (var inMemoryContext = new ApplicationUserDbContext(options)) { // get servis dogru calisti mi kontrolu Assert.True(resultGetAll.Succeeded); Assert.NotNull(resultGetAll.Result); Assert.Equal(2, await inMemoryContext.Categories.CountAsync()); var items = await inMemoryContext.Categories.ToListAsync(); Assert.Equal("Lorem Ipsum 1", items[0].Name); Assert.Equal("lorem-ipsum-1", items[0].UrlName); Assert.Equal("Lorem Ipsum 2", items[1].Name); Assert.Equal("lorem-ipsum-2", items[1].UrlName); } }
protected IActionResult ApplicationResult(string view, ApplicationResult result) { SetApplicationResult(result); return(View(view)); }
protected void btnLogin_Click(object sender, EventArgs e) { try { if (Session[ApplicationSession.USERID] == null) { lblMsg.Visible = false; EmployeeMBL objEmployeeMBL = new EmployeeMBL(); ApplicationResult objResult = new ApplicationResult(); objResult = objEmployeeMBL.Employee_CheckForLogin(txtUsername.Text.Trim(), txtPassword.Text.Trim()); if (objResult != null) { DataTable dtEmployee = new DataTable(); dtEmployee = objResult.resultDT; if (dtEmployee.Rows.Count > 0) { Session[ApplicationSession.USERID] = dtEmployee.Rows[0][EmployeeMBO.EMPLOYEEM_EMPLOYEEMID].ToString(); Session[ApplicationSession.USERNAME] = dtEmployee.Rows[0][EmployeeMBO.EMPLOYEEM_USERNAME].ToString(); Session[ApplicationSession.ROLEID] = dtEmployee.Rows[0][EmployeeMBO.EMPLOYEEM_ROLEID].ToString(); Session[ApplicationSession.SCHOOLID] = dtEmployee.Rows[0][EmployeeMBO.EMPLOYEEM_SCHOOLMID].ToString(); //if (dtEmployee.Rows[0][EmployeeMBO.EMPLOYEEM_SCHOOLMID].ToString() == "0") //{ // Session[ApplicationSession.TRUSTID] = dtEmployee.Rows[0][EmployeeMBO.EMPLOYEEM_TRUSTMID].ToString(); //} //else if (dtEmployee.Rows[0][EmployeeMBO.EMPLOYEEM_SCHOOLMID].ToString() != "0") //{ // Session[ApplicationSession.TRUSTID] = dtEmployee.Rows[0]["SchTrustMID"].ToString(); // //Session[ApplicationSession.TRUSTID] = "0"; //} //if (dtEmployee.Rows[0][EmployeeMBO.EMPLOYEEM_SCHOOLMID].ToString() != "0") //{ // Session[ApplicationSession.SCHOOLID] = dtEmployee.Rows[0][EmployeeMBO.EMPLOYEEM_SCHOOLMID].ToString(); //} //log4net.LogicalThreadContext.Properties["UserID"] = Convert.ToInt32(Session[ApplicationSession.USERID]); //logger.Info("User Login"); if (dtEmployee.Rows[0]["TrustMID"].ToString() != "0" && dtEmployee.Rows[0]["SchoolMID"].ToString() == "0") { Session[ApplicationSession.TRUSTID] = dtEmployee.Rows[0][EmployeeMBO.EMPLOYEEM_TRUSTMID].ToString(); Session[ApplicationSession.TRUSTNAME] = dtEmployee.Rows[0]["TrustNameEng"].ToString(); Session[ApplicationSession.SCHOOLID] = dtEmployee.Rows[0][EmployeeMBO.EMPLOYEEM_SCHOOLMID].ToString(); Session[ApplicationSession.ISPANEL] = dtEmployee.Rows[0][EmployeeMBO.EMPLOYEEM_SCHOOLMID].ToString(); Response.Redirect("Client.UI/TrustHome.aspx", false); } else if (dtEmployee.Rows[0]["SchoolMID"].ToString() != "0") { Session[ApplicationSession.TRUSTID] = dtEmployee.Rows[0][EmployeeMBO.EMPLOYEEM_TRUSTMID].ToString(); Session[ApplicationSession.TRUSTNAME] = dtEmployee.Rows[0]["TrustNameEng"].ToString(); Session[ApplicationSession.SCHOOLID] = dtEmployee.Rows[0][EmployeeMBO.EMPLOYEEM_SCHOOLMID].ToString(); Session[ApplicationSession.SCHOOLNAME] = dtEmployee.Rows[0]["SchoolNameEng"].ToString(); Session[ApplicationSession.ISPANEL] = dtEmployee.Rows[0][EmployeeMBO.EMPLOYEEM_SCHOOLMID].ToString(); Response.Redirect("Client.UI/SchoolHome.aspx", false); } else { Response.Redirect("../UserLogin.aspx", false); } } else { lblMsg.Visible = true; lblMsg.Text = "UserName or Password Incorrect."; txtPassword.Text = ""; txtUsername.Text = ""; } } else { lblMsg.Visible = true; lblMsg.Text = "UserName or Password Incorrect."; txtPassword.Text = ""; txtUsername.Text = ""; } } else { int UserId = 0; UserId = Convert.ToInt32(ApplicationSession.USERID); Session.Abandon(); Response.Redirect("UserLogin.aspx", false); //if (UserId != null || UserId != 0) //{ // Response.Redirect("Client.UI/TrustHome.aspx", false); //} //lblMsg.Visible = true; //lblMsg.Text = "User Already Logged In."; } } catch (Exception ex) { throw ex; } }
protected void btnSaveClass_OnClick(object sender, EventArgs e) { try { DesignationBO objDesignationBO = new DesignationBO(); DesignationBL objDesignationBL = new DesignationBL(); ApplicationResult objResult = new ApplicationResult(); DataTable dtResult = new DataTable(); int intDesignationID = 0; objDesignationBO.DesignationNameENG = txtDesignationNameENG.Text.Trim(); objDesignationBO.DesignationNameGUJ = txtDesignationNameGUJ.Text.Trim(); objDesignationBO.Description = txtDescription.Text.Trim(); objDesignationBO.LastModifiedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]); objDesignationBO.LastModifiedDate = DateTime.UtcNow.AddHours(5.5).ToString(); //Code For Validate Designation Name if (ViewState["Mode"].ToString() == "Save") { intDesignationID = -1; } else if (ViewState["Mode"].ToString() == "Edit") { intDesignationID = Convert.ToInt32(ViewState["DesignationID"].ToString()); } objResult = objDesignationBL.Designation_ValidateName(intDesignationID, objDesignationBO.DesignationNameENG); if (objResult != null) { dtResult = objResult.resultDT; if (dtResult.Rows.Count > 0) { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Designation name already exist.');</script>"); } else { if (ViewState["Mode"].ToString() == "Save") { objDesignationBO.CreatedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]); objDesignationBO.CreatedDate = DateTime.UtcNow.AddHours(5.5).ToString(); objResult = objDesignationBL.Designation_Insert(objDesignationBO); if (objResult.status == ApplicationResult.CommonStatusType.SUCCESS) { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record saved successfully.');</script>"); } } else if (ViewState["Mode"].ToString() == "Edit") { objDesignationBO.DesignationID = Convert.ToInt32(ViewState["DesignationID"].ToString()); objResult = objDesignationBL.Designation_Update(objDesignationBO); if (objResult.status == ApplicationResult.CommonStatusType.SUCCESS) { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record updated successfully.');</script>"); } } ClearAll(); BindDesignation(); PanelVisibility(1); } } } 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 FeesGroup in tbl_FeesGroup_M table /// Created By : Nafisa, 19-03-2015 /// Modified By : /// </summary> /// <param name="objFeesGroupBO"></param> /// <returns></returns> public ApplicationResult FeesGroup_Update(FeesGroupBo objFeesGroupBO) { try { pSqlParameter = new SqlParameter[7]; pSqlParameter[0] = new SqlParameter("@FeesGroupID", SqlDbType.Int); pSqlParameter[0].Direction = ParameterDirection.Input; pSqlParameter[0].Value = objFeesGroupBO.FeesGroupID; pSqlParameter[1] = new SqlParameter("@FeeGroupName", SqlDbType.VarChar); pSqlParameter[1].Direction = ParameterDirection.Input; pSqlParameter[1].Value = objFeesGroupBO.FeeGroupName; pSqlParameter[2] = new SqlParameter("@TrustMID", SqlDbType.Int); pSqlParameter[2].Direction = ParameterDirection.Input; pSqlParameter[2].Value = objFeesGroupBO.TrustMID; pSqlParameter[3] = new SqlParameter("@SchoolMID", SqlDbType.Int); pSqlParameter[3].Direction = ParameterDirection.Input; pSqlParameter[3].Value = objFeesGroupBO.SchoolMID; pSqlParameter[4] = new SqlParameter("@LastModifiedUserID", SqlDbType.Int); pSqlParameter[4].Direction = ParameterDirection.Input; pSqlParameter[4].Value = objFeesGroupBO.LastModifiedUserID; pSqlParameter[5] = new SqlParameter("@LastModifiedDate", SqlDbType.VarChar); pSqlParameter[5].Direction = ParameterDirection.Input; pSqlParameter[5].Value = objFeesGroupBO.LastModifiedDate; pSqlParameter[6] = new SqlParameter("@Description", SqlDbType.VarChar); pSqlParameter[6].Direction = ParameterDirection.Input; pSqlParameter[6].Value = objFeesGroupBO.Description; sSql = "usp_tbl_FeesGroup_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 { objFeesGroupBO = null; } }
public async Task <IActionResult> Handle(ResponderSolitacaoPactoTrabalhoAtividadeCommand request, CancellationToken cancellationToken) { var result = new ApplicationResult <PactoTrabalhoViewModel>(request); try { if (!await validarPermissoes(request)) { result.SetHttpStatusToForbidden("O usuário logado não possui permissão suficientes para executar a ação."); return(result); } //Monta os dados do pacto de trabalho var pacto = await PactoTrabalhoRepository.ObterAsync(request.PactoTrabalhoId); //Obtém os dados da solicitação var solicitacao = pacto.Solicitacoes.Where(s => s.PactoTrabalhoSolicitacaoId == request.PactoTrabalhoSolicitacaoId).FirstOrDefault(); var dataFim = pacto.DataFim; Susep.SISRH.Domain.AggregatesModel.CatalogoAggregate.ItemCatalogo itemCatalogo = null; if (request.AjustarPrazo) { //Obtém os dias não úteis da pessoa var dias = diasAumentoPrazo(pacto, solicitacao); if (dias == null) { result.SetHttpStatusToBadRequest("Não foi possível recuperar os dias de aumento de prazo."); return(result); } dataFim = pacto.DataFim.AddDays(Convert.ToDouble(Decimal.Round(dias.Value))); } dynamic dadosSolicitacao = JsonConvert.DeserializeObject(solicitacao.DadosSolicitacao); switch (solicitacao.TipoSolicitacaoId) { case (int)SISRH.Domain.Enums.TipoSolicitacaoPactoTrabalhoEnum.AlterarPrazo: dataFim = (DateTime)dadosSolicitacao.dataFim; break; case (int)SISRH.Domain.Enums.TipoSolicitacaoPactoTrabalhoEnum.NovaAtividade: Guid itemCatalogoId = dadosSolicitacao.itemCatalogoId; itemCatalogo = await ItemCatalogoRepository.ObterAsync(itemCatalogoId); break; } var diasNaoUteis = await PessoaQuery.ObterDiasNaoUteisAsync(pacto.PessoaId, pacto.DataInicio, dataFim); pacto.DiasNaoUteis = diasNaoUteis.Result.ToList(); //Responde a solicitação pacto.ResponderSolicitacao(request.PactoTrabalhoSolicitacaoId, request.UsuarioLogadoId.ToString(), request.Aprovado, request.AjustarPrazo, request.Descricao, itemCatalogo); //Altera o pacto de trabalho no banco de dados PactoTrabalhoRepository.Atualizar(pacto); UnitOfWork.Commit(false); //Envia os emails aos envolvidos await EnviarEmail(request.PactoTrabalhoId, pacto.PessoaId, pacto.UnidadeId); var dadosPacto = await PactoTrabalhoQuery.ObterPorChaveAsync(request.PactoTrabalhoId); result.Result = dadosPacto.Result; result.SetHttpStatusToOk("Pacto de trabalho alterado com sucesso."); } catch (SISRH.Domain.Exceptions.SISRHDomainException ex) { result.Validations = new List <string>() { ex.Message }; result.Result = null; result.SetHttpStatusToBadRequest(); } return(result); }
/// <summary> /// To Update details of Holiday in tbl_Holiday_M table /// Created By : Nirmal, 04-01-2016 /// Modified By : /// </summary> public ApplicationResult Holiday_Update(HolidayBo objHolidayBo) { try { pSqlParameter = new SqlParameter[8]; pSqlParameter[0] = new SqlParameter("@HolidayId", SqlDbType.Int); pSqlParameter[0].Direction = ParameterDirection.Input; pSqlParameter[0].Value = objHolidayBo.HolidayId; pSqlParameter[1] = new SqlParameter("@Name", SqlDbType.VarChar); pSqlParameter[1].Direction = ParameterDirection.Input; pSqlParameter[1].Value = objHolidayBo.Name; pSqlParameter[2] = new SqlParameter("@AcademicYear", SqlDbType.VarChar); pSqlParameter[2].Direction = ParameterDirection.Input; pSqlParameter[2].Value = objHolidayBo.AcademicYear; pSqlParameter[3] = new SqlParameter("@StartDate", SqlDbType.VarChar); pSqlParameter[3].Direction = ParameterDirection.Input; pSqlParameter[3].Value = objHolidayBo.StartDate; pSqlParameter[4] = new SqlParameter("@EndDate", SqlDbType.VarChar); pSqlParameter[4].Direction = ParameterDirection.Input; pSqlParameter[4].Value = objHolidayBo.EndDate; pSqlParameter[5] = new SqlParameter("@Description", SqlDbType.VarChar); pSqlParameter[5].Direction = ParameterDirection.Input; pSqlParameter[5].Value = objHolidayBo.Description; pSqlParameter[6] = new SqlParameter("@LastModifiedBy", SqlDbType.Int); pSqlParameter[6].Direction = ParameterDirection.Input; pSqlParameter[6].Value = objHolidayBo.LastModifiedBy; pSqlParameter[7] = new SqlParameter("@LastModifiedDate", SqlDbType.VarChar); pSqlParameter[7].Direction = ParameterDirection.Input; pSqlParameter[7].Value = objHolidayBo.LastModifiedDate; sSql = "usp_tbl_Holiday_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 { objHolidayBo = null; } }
void IOutputPort.Invalid(ApplicationResult result) { var validationProblemDetails = new ValidationProblemDetails(result.ModelState); _viewModel = BadRequest(validationProblemDetails); }
/// <summary> /// To Update details of ExamConfigurationBL in ExamConfiguration table /// Created By : Vishal, 1/7/2016 /// Modified By : /// </summary> public ApplicationResult ExamConfigurationBL_Update(ExamConfigurationBO objExamConfigurationBLBo) { try { pSqlParameter = new SqlParameter[9]; pSqlParameter[0] = new SqlParameter("@ExamConfigId", SqlDbType.Int); pSqlParameter[0].Direction = ParameterDirection.Input; pSqlParameter[0].Value = objExamConfigurationBLBo.ExamConfigId; pSqlParameter[1] = new SqlParameter("@ClassId", SqlDbType.Int); pSqlParameter[1].Direction = ParameterDirection.Input; pSqlParameter[1].Value = objExamConfigurationBLBo.ClassId; pSqlParameter[2] = new SqlParameter("@DivisionId", SqlDbType.Int); pSqlParameter[2].Direction = ParameterDirection.Input; pSqlParameter[2].Value = objExamConfigurationBLBo.DivisionId; pSqlParameter[3] = new SqlParameter("@AcademicYear", SqlDbType.VarChar); pSqlParameter[3].Direction = ParameterDirection.Input; pSqlParameter[3].Value = objExamConfigurationBLBo.AcademicYear; pSqlParameter[4] = new SqlParameter("@Exam", SqlDbType.VarChar); pSqlParameter[4].Direction = ParameterDirection.Input; pSqlParameter[4].Value = objExamConfigurationBLBo.Exam; pSqlParameter[5] = new SqlParameter("@SubjectId", SqlDbType.VarChar); pSqlParameter[5].Direction = ParameterDirection.Input; pSqlParameter[5].Value = objExamConfigurationBLBo.SubjectId; pSqlParameter[6] = new SqlParameter("@LastModifiedBy", SqlDbType.Int); pSqlParameter[6].Direction = ParameterDirection.Input; pSqlParameter[6].Value = objExamConfigurationBLBo.LastModifiedBy; pSqlParameter[7] = new SqlParameter("@LastModifiedDate", SqlDbType.NVarChar); pSqlParameter[7].Direction = ParameterDirection.Input; pSqlParameter[7].Value = objExamConfigurationBLBo.LastModifiedDate; pSqlParameter[8] = new SqlParameter("@IsDeleted", SqlDbType.Int); pSqlParameter[8].Direction = ParameterDirection.Input; pSqlParameter[8].Value = objExamConfigurationBLBo.IsDeleted; sSql = "usp_tbl_ExamConfiguration_Update"; DataTable ResultDT = Database.ExecuteDataTable(CommandType.StoredProcedure, sSql, pSqlParameter); if (ResultDT.Rows[0][0].ToString() == "333") { ApplicationResult objResults = new ApplicationResult(ResultDT); objResults.status = ApplicationResult.CommonStatusType.SUCCESS; return(objResults); } else if (ResultDT.Rows[0][0].ToString() == "222") { ApplicationResult objResults = new ApplicationResult(ResultDT); objResults.status = ApplicationResult.CommonStatusType.RECORD_FK_VIOLATION; return(objResults); } else { ApplicationResult objResults = new ApplicationResult(ResultDT); objResults.status = ApplicationResult.CommonStatusType.FAILURE; return(objResults); } } catch (Exception ex) { throw ex; } finally { objExamConfigurationBLBo = null; } }
/// <summary> /// To Insert details of ExamConfigurationBL in ExamConfiguration table /// Created By : Vishal, 1/7/2016 /// Modified By : /// </summary> public ApplicationResult ExamConfigurationBL_Insert(ExamConfigurationBO objExamConfigurationBLBo) { try { pSqlParameter = new SqlParameter[11]; pSqlParameter[0] = new SqlParameter("@ClassId", SqlDbType.Int); pSqlParameter[0].Direction = ParameterDirection.Input; pSqlParameter[0].Value = objExamConfigurationBLBo.ClassId; pSqlParameter[1] = new SqlParameter("@DivisionId", SqlDbType.Int); pSqlParameter[1].Direction = ParameterDirection.Input; pSqlParameter[1].Value = objExamConfigurationBLBo.DivisionId; pSqlParameter[2] = new SqlParameter("@AcademicYear", SqlDbType.VarChar); pSqlParameter[2].Direction = ParameterDirection.Input; pSqlParameter[2].Value = objExamConfigurationBLBo.AcademicYear; pSqlParameter[3] = new SqlParameter("@Exam", SqlDbType.VarChar); pSqlParameter[3].Direction = ParameterDirection.Input; pSqlParameter[3].Value = objExamConfigurationBLBo.Exam; pSqlParameter[4] = new SqlParameter("@SubjectId", SqlDbType.VarChar); pSqlParameter[4].Direction = ParameterDirection.Input; pSqlParameter[4].Value = objExamConfigurationBLBo.SubjectId; pSqlParameter[5] = new SqlParameter("@CreatedByUserId", SqlDbType.Int); pSqlParameter[5].Direction = ParameterDirection.Input; pSqlParameter[5].Value = objExamConfigurationBLBo.CreatedByUserId; pSqlParameter[6] = new SqlParameter("@CreatedDate", SqlDbType.NVarChar); pSqlParameter[6].Direction = ParameterDirection.Input; pSqlParameter[6].Value = objExamConfigurationBLBo.CreatedDate; pSqlParameter[7] = new SqlParameter("@LastModifiedBy", SqlDbType.Int); pSqlParameter[7].Direction = ParameterDirection.Input; pSqlParameter[7].Value = objExamConfigurationBLBo.LastModifiedBy; pSqlParameter[8] = new SqlParameter("@LastModifiedDate", SqlDbType.NVarChar); pSqlParameter[8].Direction = ParameterDirection.Input; pSqlParameter[8].Value = objExamConfigurationBLBo.LastModifiedDate; pSqlParameter[9] = new SqlParameter("@IsDeleted", SqlDbType.Int); pSqlParameter[9].Direction = ParameterDirection.Input; pSqlParameter[9].Value = objExamConfigurationBLBo.IsDeleted; pSqlParameter[10] = new SqlParameter("@SchoolMID", SqlDbType.Int); pSqlParameter[10].Direction = ParameterDirection.Input; pSqlParameter[10].Value = objExamConfigurationBLBo.SchoolMID; sSql = "usp_tbl_ExamConfiguration_Insert"; 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 { objExamConfigurationBLBo = null; } }
/// <summary> /// To Insert details of TrustTemplate in tbl_TrustTemplate_M table /// Created By : NafisaMulla, 09-04-2015 /// Modified By : /// </summary> /// <param name="objTrustTemplateBO"></param> /// <returns></returns> public ApplicationResult TrustTemplate_Insert(TrustTemplateBo objTrustTemplateBO) { try { pSqlParameter = new SqlParameter[7]; pSqlParameter[0] = new SqlParameter("@TrustTemplateName", SqlDbType.NVarChar); pSqlParameter[0].Direction = ParameterDirection.Input; pSqlParameter[0].Value = objTrustTemplateBO.TrustTemplateName; pSqlParameter[1] = new SqlParameter("@TrustMID", SqlDbType.Int); pSqlParameter[1].Direction = ParameterDirection.Input; pSqlParameter[1].Value = objTrustTemplateBO.TrustMID; pSqlParameter[2] = new SqlParameter("@IsDeleted", SqlDbType.Int); pSqlParameter[2].Direction = ParameterDirection.Input; pSqlParameter[2].Value = objTrustTemplateBO.IsDeleted; pSqlParameter[3] = new SqlParameter("@CreatedUserID", SqlDbType.Int); pSqlParameter[3].Direction = ParameterDirection.Input; pSqlParameter[3].Value = objTrustTemplateBO.CreatedUserID; pSqlParameter[4] = new SqlParameter("@CreatedDate", SqlDbType.VarChar); pSqlParameter[4].Direction = ParameterDirection.Input; pSqlParameter[4].Value = objTrustTemplateBO.CreatedDate; pSqlParameter[5] = new SqlParameter("@LastModifiedUserID", SqlDbType.Int); pSqlParameter[5].Direction = ParameterDirection.Input; pSqlParameter[5].Value = objTrustTemplateBO.LastModifiedUserID; pSqlParameter[6] = new SqlParameter("@LastModifiedDate", SqlDbType.VarChar); pSqlParameter[6].Direction = ParameterDirection.Input; pSqlParameter[6].Value = objTrustTemplateBO.LastModifiedDate; sSql = "usp_tbl_TrustTemplate_M_Insert"; 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 { objTrustTemplateBO = null; } }
/// <summary> /// To Update details of LabReportSMP in LabReportSMP table /// Created By : Pavan, 08/07/2017 /// Modified By : /// </summary> public ApplicationResult LabReportSMP_Update(LabReportSMPBo objLabReportSMPBO) { try { pSqlParameter = new SqlParameter[25]; pSqlParameter[0] = new SqlParameter("@Id", SqlDbType.Int); pSqlParameter[0].Direction = ParameterDirection.Input; pSqlParameter[0].Value = objLabReportSMPBO.Id; pSqlParameter[1] = new SqlParameter("@TypeOfPowder", SqlDbType.VarChar); pSqlParameter[1].Direction = ParameterDirection.Input; pSqlParameter[1].Value = objLabReportSMPBO.TypeOfPowder; pSqlParameter[2] = new SqlParameter("@Time", SqlDbType.DateTime); pSqlParameter[2].Direction = ParameterDirection.Input; pSqlParameter[2].Value = objLabReportSMPBO.Time; pSqlParameter[3] = new SqlParameter("@BatchNo", SqlDbType.VarChar); pSqlParameter[3].Direction = ParameterDirection.Input; pSqlParameter[3].Value = objLabReportSMPBO.BatchNo; pSqlParameter[4] = new SqlParameter("@BagNo", SqlDbType.Int); pSqlParameter[4].Direction = ParameterDirection.Input; pSqlParameter[4].Value = objLabReportSMPBO.BagNos; pSqlParameter[5] = new SqlParameter("@Weight", SqlDbType.Float); pSqlParameter[5].Direction = ParameterDirection.Input; pSqlParameter[5].Value = objLabReportSMPBO.Weight; pSqlParameter[6] = new SqlParameter("@Appearance", SqlDbType.VarChar); pSqlParameter[6].Direction = ParameterDirection.Input; pSqlParameter[6].Value = objLabReportSMPBO.Appearance; pSqlParameter[7] = new SqlParameter("@Moisture", SqlDbType.Float); pSqlParameter[7].Direction = ParameterDirection.Input; pSqlParameter[7].Value = objLabReportSMPBO.Moisture; pSqlParameter[8] = new SqlParameter("@TotalSolid", SqlDbType.Float); pSqlParameter[8].Direction = ParameterDirection.Input; pSqlParameter[8].Value = objLabReportSMPBO.TotalSolid; pSqlParameter[9] = new SqlParameter("@BulkDensity", SqlDbType.Float); pSqlParameter[9].Direction = ParameterDirection.Input; pSqlParameter[9].Value = objLabReportSMPBO.BulkDensity; pSqlParameter[10] = new SqlParameter("@MilkFat", SqlDbType.Float); pSqlParameter[10].Direction = ParameterDirection.Input; pSqlParameter[10].Value = objLabReportSMPBO.MilkFat; pSqlParameter[11] = new SqlParameter("@Acidity", SqlDbType.VarChar); pSqlParameter[11].Direction = ParameterDirection.Input; pSqlParameter[11].Value = objLabReportSMPBO.Acidity; pSqlParameter[12] = new SqlParameter("@Wettability", SqlDbType.VarChar); pSqlParameter[12].Direction = ParameterDirection.Input; pSqlParameter[12].Value = objLabReportSMPBO.Wettability; pSqlParameter[13] = new SqlParameter("@ScorchedParticle", SqlDbType.VarChar); pSqlParameter[13].Direction = ParameterDirection.Input; pSqlParameter[13].Value = objLabReportSMPBO.ScorchedParticle; pSqlParameter[14] = new SqlParameter("@SolIndex", SqlDbType.VarChar); pSqlParameter[14].Direction = ParameterDirection.Input; pSqlParameter[14].Value = objLabReportSMPBO.SolIndex; pSqlParameter[15] = new SqlParameter("@CoffeTest", SqlDbType.VarChar); pSqlParameter[15].Direction = ParameterDirection.Input; pSqlParameter[15].Value = objLabReportSMPBO.CoffeTest; pSqlParameter[16] = new SqlParameter("@Flavour", SqlDbType.VarChar); pSqlParameter[16].Direction = ParameterDirection.Input; pSqlParameter[16].Value = objLabReportSMPBO.Flavour; pSqlParameter[17] = new SqlParameter("@Protein", SqlDbType.Float); pSqlParameter[17].Direction = ParameterDirection.Input; pSqlParameter[17].Value = objLabReportSMPBO.Protein; pSqlParameter[18] = new SqlParameter("@ASH", SqlDbType.Float); pSqlParameter[18].Direction = ParameterDirection.Input; pSqlParameter[18].Value = objLabReportSMPBO.ASH; pSqlParameter[19] = new SqlParameter("@Lumpiness", SqlDbType.VarChar); pSqlParameter[19].Direction = ParameterDirection.Input; pSqlParameter[19].Value = objLabReportSMPBO.Lumpiness; pSqlParameter[20] = new SqlParameter("@Adultration", SqlDbType.VarChar); pSqlParameter[20].Direction = ParameterDirection.Input; pSqlParameter[20].Value = objLabReportSMPBO.Adultration; pSqlParameter[21] = new SqlParameter("@UserId", SqlDbType.Int); pSqlParameter[21].Direction = ParameterDirection.Input; pSqlParameter[21].Value = objLabReportSMPBO.UserId; pSqlParameter[22] = new SqlParameter("@Date", SqlDbType.DateTime); pSqlParameter[22].Direction = ParameterDirection.Input; pSqlParameter[22].Value = objLabReportSMPBO.Date; pSqlParameter[23] = new SqlParameter("@LastModifiedDate", SqlDbType.DateTime); pSqlParameter[23].Direction = ParameterDirection.Input; pSqlParameter[23].Value = objLabReportSMPBO.LastModifiedDate; pSqlParameter[24] = new SqlParameter("@LastModifiedBy", SqlDbType.Int); pSqlParameter[24].Direction = ParameterDirection.Input; pSqlParameter[24].Value = objLabReportSMPBO.LastModifiedBy; sSql = "usp_tbl_LabReportSMP_Update"; DataTable dtResult = new DataTable(); dtResult = Database.ExecuteDataTable(CommandType.StoredProcedure, sSql, pSqlParameter); ApplicationResult objResults = new ApplicationResult(dtResult); objResults.Status = ApplicationResult.CommonStatusType.Success; return(objResults); } catch (Exception ex) { throw ex; } finally { objLabReportSMPBO = null; } }
protected void SetApplicationResult(ApplicationResult result) { TempData.Put(ViewDataKeys.ApplicationResult, result); }
/// <summary> /// To Update details of LeaveM in tbl_Leave_M table /// Created By : Nafisal, 16-04-2015 /// Modified By : /// </summary> /// <param name="objLeaveMBO"></param> /// <returns></returns> public ApplicationResult LeaveM_Update(LeaveMBo objLeaveMBO) { try { pSqlParameter = new SqlParameter[10]; pSqlParameter[0] = new SqlParameter("@LeaveID", SqlDbType.Int); pSqlParameter[0].Direction = ParameterDirection.Input; pSqlParameter[0].Value = objLeaveMBO.LeaveID; pSqlParameter[1] = new SqlParameter("@TrustMID", SqlDbType.Int); pSqlParameter[1].Direction = ParameterDirection.Input; pSqlParameter[1].Value = objLeaveMBO.TrustMID; pSqlParameter[2] = new SqlParameter("@LeaveCode", SqlDbType.VarChar); pSqlParameter[2].Direction = ParameterDirection.Input; pSqlParameter[2].Value = objLeaveMBO.LeaveCode; pSqlParameter[3] = new SqlParameter("@LeaveName", SqlDbType.VarChar); pSqlParameter[3].Direction = ParameterDirection.Input; pSqlParameter[3].Value = objLeaveMBO.LeaveName; pSqlParameter[4] = new SqlParameter("@LeaveDescription", SqlDbType.VarChar); pSqlParameter[4].Direction = ParameterDirection.Input; pSqlParameter[4].Value = objLeaveMBO.LeaveDescription; pSqlParameter[5] = new SqlParameter("@LeaveOpening", SqlDbType.Int); pSqlParameter[5].Direction = ParameterDirection.Input; pSqlParameter[5].Value = objLeaveMBO.LeaveOpening; pSqlParameter[6] = new SqlParameter("@LeaveCarryForwardLimit", SqlDbType.Int); pSqlParameter[6].Direction = ParameterDirection.Input; pSqlParameter[6].Value = objLeaveMBO.LeaveCarryForwardLimit; pSqlParameter[7] = new SqlParameter("@Year", SqlDbType.Int); pSqlParameter[7].Direction = ParameterDirection.Input; pSqlParameter[7].Value = objLeaveMBO.Year; pSqlParameter[8] = new SqlParameter("@LastModifiedUserID", SqlDbType.Int); pSqlParameter[8].Direction = ParameterDirection.Input; pSqlParameter[8].Value = objLeaveMBO.LastModifiedUserID; pSqlParameter[9] = new SqlParameter("@LastModifiedDate", SqlDbType.VarChar); pSqlParameter[9].Direction = ParameterDirection.Input; pSqlParameter[9].Value = objLeaveMBO.LastModifiedDate; sSql = "usp_tbl_Leave_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 { objLeaveMBO = null; } }
/// <summary> /// To Update details of Consumption in tbl_Consumption_M table /// Created By : Chintan, 10/31/2014 /// Modified By : /// </summary> /// <param name="objConsumptionBO"></param> /// <returns></returns> public ApplicationResult Consumption_Update(ConsumptionBO objConsumptionBO) { try { pSqlParameter = new SqlParameter[10]; pSqlParameter[0] = new SqlParameter("@ConsumptionID", SqlDbType.Int); pSqlParameter[0].Direction = ParameterDirection.Input; pSqlParameter[0].Value = objConsumptionBO.ConsumptionID; pSqlParameter[1] = new SqlParameter("@TrustMID", SqlDbType.Int); pSqlParameter[1].Direction = ParameterDirection.Input; pSqlParameter[1].Value = objConsumptionBO.TrustMID; pSqlParameter[2] = new SqlParameter("@SchoolMID", SqlDbType.Int); pSqlParameter[2].Direction = ParameterDirection.Input; pSqlParameter[2].Value = objConsumptionBO.SchoolMID; pSqlParameter[3] = new SqlParameter("@MaterialID", SqlDbType.Int); pSqlParameter[3].Direction = ParameterDirection.Input; pSqlParameter[3].Value = objConsumptionBO.MaterialID; pSqlParameter[4] = new SqlParameter("@Quantity", SqlDbType.Int); pSqlParameter[4].Direction = ParameterDirection.Input; pSqlParameter[4].Value = objConsumptionBO.Quantity; pSqlParameter[5] = new SqlParameter("@UOMID", SqlDbType.Int); pSqlParameter[5].Direction = ParameterDirection.Input; pSqlParameter[5].Value = objConsumptionBO.UOMID; pSqlParameter[6] = new SqlParameter("@ConsumptionDate", SqlDbType.VarChar); pSqlParameter[6].Direction = ParameterDirection.Input; pSqlParameter[6].Value = objConsumptionBO.ConsumptionDate; pSqlParameter[7] = new SqlParameter("@IsConsumption", SqlDbType.Int); pSqlParameter[7].Direction = ParameterDirection.Input; pSqlParameter[7].Value = objConsumptionBO.IsConsumption; pSqlParameter[8] = new SqlParameter("@LastModifiedUserID", SqlDbType.Int); pSqlParameter[8].Direction = ParameterDirection.Input; pSqlParameter[8].Value = objConsumptionBO.LastModifiedUserID; pSqlParameter[9] = new SqlParameter("@LastModifiedDate", SqlDbType.VarChar); pSqlParameter[9].Direction = ParameterDirection.Input; pSqlParameter[9].Value = objConsumptionBO.LastModifiedDate; sSql = "usp_tbl_Consumption_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 { objConsumptionBO = null; } }
/// <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; } }
public async Task <ApplicationResult <TestCaseResponseModel> > GetFirstFailForFailer(int submissionId, string userId) { var response = await _testCaseBusiness.GetFirstFailForFailerAsync(submissionId, userId); return(ApplicationResult <TestCaseResponseModel> .Ok(response)); }
public void BindAcademicYear() { try { #region Fetch Academic Month from School SchoolBL objSchoolBl = new SchoolBL(); ApplicationResult objResults = new ApplicationResult(); int intMonth = 0; objResults = objSchoolBl.School_Select(Convert.ToInt32(Session[ApplicationSession.SCHOOLID])); if (objResults != null) { if (objResults.resultDT.Rows.Count > 0) { intMonth = Convert.ToInt32(objResults.resultDT.Rows[0][SchoolBO.SCHOOL_ACADEMICMONTH].ToString()); } } #endregion Controls objControls = new Controls(); int month = System.DateTime.Now.Month; int Year = System.DateTime.Now.Year; int lastTwoDigit = Year % 100; string yr = string.Empty; if (month >= intMonth) { yr = (lastTwoDigit.ToString() + (lastTwoDigit + 1).ToString()).ToString(); } else { yr = ((lastTwoDigit - 1).ToString() + lastTwoDigit.ToString()).ToString(); } int f = (Convert.ToInt32(yr.Substring(0, 2))); int l = (Convert.ToInt32(yr.Substring(2, 2))); DataTable dt = new DataTable(); DataRow dr = null; dt.Columns.Add(new DataColumn("AcademicYear", typeof(string))); for (int i = 0; i < 5; i++) { dr = dt.NewRow(); if (i == 0) { dr["AcademicYear"] = Convert.ToString(f.ToString() + "-" + l.ToString()); dt.Rows.Add(dr); } else { if ((f - 1).ToString().Length < 2) { if (f.ToString().Length == 2) { dr["AcademicYear"] = Convert.ToString("0" + (f - 1).ToString() + "-" + (f).ToString()); } else { dr["AcademicYear"] = Convert.ToString("0" + (f - 1).ToString() + "-" + "0" + (f).ToString()); } dt.Rows.Add(dr); } else { dr["AcademicYear"] = Convert.ToString((f - 1).ToString() + "-" + (f).ToString()); dt.Rows.Add(dr); } f = f - 1; l = f; } } objControls.BindDropDown_ListBox(dt, ddlAcademicYear, "AcademicYear", "AcademicYear"); } 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 SectionT in SectionT table /// Created By : NafisaMulla, 12/6/2014 /// Modified By : /// </summary> /// <param name="objSectionTBO"></param> /// <returns></returns> public ApplicationResult SectionT_Update(SectionTBO objSectionTBO) { try { pSqlParameter = new SqlParameter[7]; pSqlParameter[0] = new SqlParameter("@SectionTID", SqlDbType.Int); pSqlParameter[0].Direction = ParameterDirection.Input; pSqlParameter[0].Value = objSectionTBO.SectionTID; pSqlParameter[1] = new SqlParameter("@SectionMID", SqlDbType.Int); pSqlParameter[1].Direction = ParameterDirection.Input; pSqlParameter[1].Value = objSectionTBO.SectionMID; pSqlParameter[2] = new SqlParameter("@SchoolMID", SqlDbType.Int); pSqlParameter[2].Direction = ParameterDirection.Input; pSqlParameter[2].Value = objSectionTBO.SchoolMID; pSqlParameter[3] = new SqlParameter("@MediumMID", SqlDbType.Int); pSqlParameter[3].Direction = ParameterDirection.Input; pSqlParameter[3].Value = objSectionTBO.MediumMID; pSqlParameter[4] = new SqlParameter("@LastModifiedUserID", SqlDbType.Int); pSqlParameter[4].Direction = ParameterDirection.Input; pSqlParameter[4].Value = objSectionTBO.LastModifiedUserID; pSqlParameter[5] = new SqlParameter("@LastModifiedDate", SqlDbType.VarChar); pSqlParameter[5].Direction = ParameterDirection.Input; pSqlParameter[5].Value = objSectionTBO.LastModifiedDate; pSqlParameter[6] = new SqlParameter("@IsDeleted", SqlDbType.Int); pSqlParameter[6].Direction = ParameterDirection.Input; pSqlParameter[6].Value = objSectionTBO.IsDeleted; sSql = "usp_tbl_Section_T_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 { objSectionTBO = null; } }
protected void btnSave_Click(object sender, EventArgs e) { try { ApplicationResult objResult = new ApplicationResult(); ExamConfigurationBO objExamConfigurationBO = new ExamConfigurationBO(); ExamConfigurationBL objExamConfigurationBL = new ExamConfigurationBL(); int intExamConfigID = 0; objExamConfigurationBO.ClassId = Convert.ToInt32(ddlClass.SelectedValue); objExamConfigurationBO.DivisionId = Convert.ToInt32(ViewState["DivisionTID"]); objExamConfigurationBO.AcademicYear = ddlAcademicYear.SelectedItem.ToString(); objExamConfigurationBO.Exam = ddlExam.SelectedItem.ToString(); objExamConfigurationBO.SchoolMID = Convert.ToInt32(Session[ApplicationSession.SCHOOLID]); objExamConfigurationBO.IsDeleted = 0; foreach (ListItem i in lbDestSubject.Items) { SubjectIDs += i.Value + ","; } SubjectIDs = SubjectIDs.Substring(0, SubjectIDs.Length - 1); objExamConfigurationBO.SubjectId = SubjectIDs; if (ViewState["Mode"].ToString() == "Save") { intExamConfigID = -1; } else if (ViewState["Mode"].ToString() == "Edit") { intExamConfigID = Convert.ToInt32(ViewState["ExamConfigID"]); } objResult = objExamConfigurationBL.ExamConfigurationBL_ValidateName(Convert.ToInt32(ddlClass.SelectedValue), Convert.ToInt32(ViewState["DivisionTID"]), ddlExam.SelectedItem.ToString(), ddlAcademicYear.SelectedItem.ToString(), intExamConfigID, Convert.ToInt32(Session[ApplicationSession.SCHOOLID])); if (objResult != null) { if (objResult.resultDT.Rows.Count > 0) { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Exam already Saved.');</script>"); } else { if (ViewState["Mode"].ToString() == "Save") { objExamConfigurationBO.CreatedByUserId = Convert.ToInt32(Session[ApplicationSession.USERID]); objExamConfigurationBO.CreatedDate = DateTime.UtcNow.AddHours(5.5).ToString(); objResult = objExamConfigurationBL.ExamConfigurationBL_Insert(objExamConfigurationBO); if (objResult != null) { Controls objControls = new Controls(); objControls.ClearForm(Master.FindControl("ContentPlaceHolder1")); ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Exam Details Saved Successfully.');</script>"); } } else if (ViewState["Mode"].ToString() == "Edit") { objExamConfigurationBO.ExamConfigId = Convert.ToInt32(ViewState["ExamConfigID"]); //objExamConfigurationBO.ClassId = Convert.ToInt32(ddlClass.SelectedValue); //objExamConfigurationBO.DivisionId = Convert.ToInt32(ViewState["DivisionTID"]); //objExamConfigurationBO.AcademicYear = ddlAcademicYear.SelectedItem.ToString(); //objExamConfigurationBO.Exam = ddlExam.SelectedItem.ToString(); //objExamConfigurationBO.IsDeleted = 0; //foreach (ListItem i in lbDestSubject.Items) //{ // SubjectIDs += i.Value + ","; //} //SubjectIDs = SubjectIDs.Substring(0, SubjectIDs.Length - 1); //objExamConfigurationBO.SubjectId = SubjectIDs; objExamConfigurationBO.LastModifiedBy = Convert.ToInt32(Session[ApplicationSession.USERID]); objExamConfigurationBO.LastModifiedDate = DateTime.UtcNow.AddHours(5.5).ToString(); objResult = objExamConfigurationBL.ExamConfigurationBL_Update(objExamConfigurationBO); if (objResult.resultDT.Rows[0][0].ToString() == "333") { Controls objControls = new Controls(); objControls.ClearForm(Master.FindControl("ContentPlaceHolder1")); ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Exam Details Updated Successfully.');</script>"); } else if (objResult.resultDT.Rows[0][0].ToString() == "222") { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Exam Details Can not be Updated.');</script>"); } else { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical issue. Please Contact to your administrator.');</script>"); } } ClearAll(); BindExamConfig(); PanelVisibility(1); } } } 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>"); } }
public async Task AssertCreatedCategory(ApplicationUserDbContext inMemoryContext, ApplicationResult <CategoryDto> resultCreate) { Assert.True(resultCreate.Succeeded); Assert.NotNull(resultCreate.Result); Assert.Equal(1, await inMemoryContext.Categories.CountAsync()); var item = await inMemoryContext.Categories.FirstOrDefaultAsync(); Assert.Equal("Tester1", item.CreatedBy); Assert.Equal("Lorem Ipsum", item.Name); Assert.Equal("lorem-ipsum", item.UrlName); Assert.Equal(resultCreate.Result.CreatedById, item.CreatedById); }
public override TableDefinition Content(ReportData reportData, Dictionary <string, string> options) { List <string> rowData = new List <string>(); int nbLimitTop; List <int> bcId = new List <int>(); int idx; if (null == options || !options.ContainsKey("IDX") || !int.TryParse(options["IDX"], out idx)) { idx = -1; } if (null == options || !options.ContainsKey("COUNT") || !int.TryParse(options["COUNT"], out nbLimitTop)) { nbLimitTop = 10; if (idx >= 0 && nbLimitTop <= idx) { nbLimitTop = idx + 1; } } if (options != null && options.ContainsKey("PAR")) { foreach (var par in options["PAR"].Split('|')) { int id; if (int.TryParse(par, out id)) { bcId.Add(id); } } } if (bcId.Count == 0) { bcId.Add(Constants.BusinessCriteria.TechnicalQualityIndex.GetHashCode()); } ApplicationResult bc = reportData.CurrentSnapshot.BusinessCriteriaResults.FirstOrDefault(_ => bcId.Contains(_.Reference.Key)); rowData.AddRange(new[] { "Rules Descriptions for Top Critical Violation Rules For Business Criterion " + bc?.Reference.Name, null }); var criticalRuleViolations = bc?.CriticalRulesViolation.Where(_ => _.DetailResult?.ViolationRatio != null).OrderByDescending(_ => _.DetailResult.ViolationRatio.FailedChecks).Take(nbLimitTop); if (idx >= 0) { criticalRuleViolations = criticalRuleViolations?.Skip(idx).Take(1); } if (criticalRuleViolations != null) { foreach (var violation in criticalRuleViolations) { var ruleDescription = reportData.RuleExplorer.GetSpecificRule(reportData.Application.DomainId, violation.Reference.Key.ToString()); rowData.AddRange(new[] { Labels.RuleName, violation.Reference.Name, Labels.Rationale, ruleDescription.Rationale, Labels.Description, ruleDescription.Description, Labels.Remediation, string.IsNullOrWhiteSpace(ruleDescription.Remediation) ? Constants.No_Value : ruleDescription.Remediation, Labels.ViolationsCount, violation.DetailResult.ViolationRatio.FailedChecks.ToString(), " ", " " }); } } var back = new TableDefinition { HasRowHeaders = false, HasColumnHeaders = true, NbRows = rowData.Count + 1, NbColumns = 2, Data = rowData }; return(back); }
public async Task <IActionResult> Details(Guid id) { ApplicationResult <PostDto> data = await _postService.Get(id); return(View(data.Result)); }
public void ProcessRequest(HttpContext context) { DataTable dtResult = new DataTable(); SchoolBL objSchoolBL = new SchoolBL(); StudentBL objStudentBL = new StudentBL(); EmployeeMBL objEmployeeBL = new EmployeeMBL(); TrustBL objTrustBL = new TrustBL(); ApplicationResult objResult = new ApplicationResult(); Controls objControl = new Controls(); byte[] imgByte = { }; if (context.Request.QueryString["StudentMID"] != null) { objResult = objStudentBL.Student_Select(Convert.ToInt32(context.Request.QueryString["StudentMID"].ToString()), 0); if (objResult != null) { if (objResult.resultDT.Rows.Count > 0) { imgByte = (byte[])objResult.resultDT.Rows[0]["StudentPhoto"]; } } } else if (context.Request.QueryString["SchoolMID"] != null) { objResult = objSchoolBL.School_Select(Convert.ToInt32(context.Request.QueryString["SchoolMID"].ToString())); if (objResult != null) { if (objResult.resultDT.Rows.Count > 0) { imgByte = (byte[])objResult.resultDT.Rows[0]["SchoolLogo"]; } } } else if (context.Request.QueryString["EmployeeMID"] != null) { objResult = objEmployeeBL.EmployeeM_Select(Convert.ToInt32(context.Request.QueryString["EmployeeMID"].ToString())); if (objResult != null) { if (objResult.resultDT.Rows.Count > 0) { imgByte = (byte[])objResult.resultDT.Rows[0]["Photo"]; } } } else { objResult = objTrustBL.Trust_Select(Convert.ToInt32(context.Request.QueryString["TrustMID"].ToString())); if (objResult != null) { if (objResult.resultDT.Rows.Count > 0) { imgByte = (byte[])objResult.resultDT.Rows[0]["TrustLogo"]; } } } // objResult = objVisitorBL.Visitor_Select(1); context.Response.BinaryWrite(imgByte); context.Response.End(); context.Response.Clear(); context.Response.ClearHeaders(); context.Response.ClearContent(); }
protected void btnSave_OnClick(object sender, EventArgs e) { try { LeaveApprovalBo objLeaveApprovalBo = new LeaveApprovalBo(); LeaveApprovalBl objLeaveApprovalBl = new LeaveApprovalBl(); LeaveApplyBl objLeaveApplyBl = new LeaveApplyBl(); LeaveApplyBo objLeaveApplyBo = new LeaveApplyBo(); ApplicationResult objResult = new ApplicationResult(); int a = 0; int b = 0; if (ViewState["Mode"].ToString() == "Approve") { objLeaveApplyBo.LeaveApplylID = Convert.ToInt32(ViewState["LeaveApplyID"].ToString()); objLeaveApplyBo.LastModifiedBy = Convert.ToInt32(Session[ApplicationSession.USERID].ToString()); objLeaveApplyBo.LastModifiedDate = DateTime.UtcNow.AddHours(5.5).ToString(); DatabaseTransaction.OpenConnectionTransation(); objResult = objLeaveApplyBl.LeaveApply_Update_ForApproval(objLeaveApplyBo); if (objResult.status == ApplicationResult.CommonStatusType.SUCCESS) { } foreach (GridViewRow row in gvLeave.Rows) { a += 1; objLeaveApprovalBo.LeaveApprovalID = Convert.ToInt32(((Label)row.FindControl("lblLeaveApprovalID")).Text); objLeaveApprovalBo.NAReason = txtReason.Text; objLeaveApprovalBo.LastModifiedBy = Convert.ToInt32(Session[ApplicationSession.USERID].ToString()); objLeaveApprovalBo.LastModifiedDate = DateTime.UtcNow.AddHours(5.5).ToString(); if (((CheckBox)row.FindControl("cbApprove")).Checked) { objResult = objLeaveApprovalBl.LeaveApproval_Update_ForApproval(objLeaveApprovalBo); if (objResult.status == ApplicationResult.CommonStatusType.SUCCESS) { b += 1; } } else { objResult = objLeaveApprovalBl.LeaveApproval_Update_ForReject(objLeaveApprovalBo); if (objResult.status == ApplicationResult.CommonStatusType.SUCCESS) { b += 1; } } } if (a == b) { DatabaseTransaction.transaction.Commit(); ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Leave application has been successfully approved or rejected.');</script>"); ClearAll(); PanelVisibility(1); } else { DatabaseTransaction.RollbackTransation(); } } else if (ViewState["Mode"].ToString() == "Edit") { objLeaveApplyBo.LeaveApplylID = Convert.ToInt32(ViewState["LeaveApplyID"].ToString()); objLeaveApplyBo.LastModifiedBy = Convert.ToInt32(Session[ApplicationSession.USERID].ToString()); objLeaveApplyBo.LastModifiedDate = DateTime.UtcNow.AddHours(5.5).ToString(); DatabaseTransaction.OpenConnectionTransation(); objResult = objLeaveApplyBl.LeaveApply_Update_ForApproval(objLeaveApplyBo); if (objResult.status == ApplicationResult.CommonStatusType.SUCCESS) { } foreach (GridViewRow row in gvLeave.Rows) { a += 1; objLeaveApprovalBo.LeaveApprovalID = Convert.ToInt32(((Label)row.FindControl("lblLeaveApprovalID")).Text); objLeaveApprovalBo.NAReason = txtReason.Text; objLeaveApprovalBo.LastModifiedBy = Convert.ToInt32(Session[ApplicationSession.USERID].ToString()); objLeaveApprovalBo.LastModifiedDate = DateTime.UtcNow.AddHours(5.5).ToString(); if (((CheckBox)row.FindControl("cbApprove")).Checked) { objResult = objLeaveApprovalBl.LeaveApproval_Update_ForApproval(objLeaveApprovalBo); if (objResult.status == ApplicationResult.CommonStatusType.SUCCESS) { b += 1; } } else { objResult = objLeaveApprovalBl.LeaveApproval_Update_ForReject(objLeaveApprovalBo); if (objResult.status == ApplicationResult.CommonStatusType.SUCCESS) { b += 1; } } } if (a == b) { DatabaseTransaction.transaction.Commit(); ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Leave application has been successfully Updated.');</script>"); ClearAll(); PanelVisibility(1); } else { DatabaseTransaction.RollbackTransation(); } } } catch (Exception ex) { DatabaseTransaction.RollbackTransation(); logger.Error("Error", ex); ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical issue. Please Contact to your administrator.');</script>"); } finally { DatabaseTransaction.connection.Close(); } }
protected void gvStudent_RowCommand(object sender, GridViewCommandEventArgs e) { try { btnSave.Enabled = true; btnSave.Attributes.Add("bgcolor", "#848484"); Controls objControls = new Controls(); StudentBL objStudentBL = new StudentBL(); ApplicationResult objResults = new ApplicationResult(); if (e.CommandName.ToString() == "Edit1") { ViewState["StudentMID"] = Convert.ToInt32(e.CommandArgument.ToString()); objResults = objStudentBL.Student_Select(Convert.ToInt32(ViewState["StudentMID"].ToString()), 0); if (objResults != null) { if (objResults.resultDT.Rows.Count > 0) { ViewState["DivisionName"] = objResults.resultDT.Rows[0][StudentBO.STUDENT_CURRENTDIVISIONTID].ToString(); #region Find DivisionName DivisionTBL objDivision = new DivisionTBL(); ApplicationResult objResultsDivision = new ApplicationResult(); objResultsDivision = objDivision.DivisionT_Select_By_DivisionTID(Convert.ToInt32(objResults.resultDT.Rows[0][StudentBO.STUDENT_CURRENTDIVISIONTID].ToString())); if (objResultsDivision != null) { if (objResultsDivision.resultDT.Rows.Count > 0) { ViewState["Division"] = objResultsDivision.resultDT.Rows[0][DivisionTBO.DIVISIONT_DIVISIONNAME].ToString(); } } #endregion #region Find SectionName SectionBL objSection = new SectionBL(); ApplicationResult objResultsSection = new ApplicationResult(); objResultsSection = objSection.Section_Select(Convert.ToInt32(objResults.resultDT.Rows[0][StudentBO.STUDENT_CURRENTSECTIONID].ToString())); if (objResultsSection != null) { if (objResultsSection.resultDT.Rows.Count > 0) { ViewState["SectionName"] = objResultsSection.resultDT.Rows[0][SectionBO.SECTION_SECTIONNAME].ToString(); } } #endregion #region Find Class ClassBL objClass = new ClassBL(); ApplicationResult objResultsClass = new ApplicationResult(); objResultsClass = objClass.Class_Select(Convert.ToInt32(objResults.resultDT.Rows[0][StudentBO.STUDENT_CURRENTCLASSID].ToString())); if (objResultsClass != null) { if (objResultsClass.resultDT.Rows.Count > 0) { ViewState["ClassMID"] = objResultsClass.resultDT.Rows[0][ClassBO.CLASS_CLASSMID].ToString(); ViewState["ClassName"] = objResultsClass.resultDT.Rows[0][ClassBO.CLASS_CLASSNAME].ToString(); } } #endregion ViewState["AcademicYear"] = objResults.resultDT.Rows[0][StudentBO.STUDENT_CURRENTYEAR].ToString(); } } } } 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>"); } }