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>");
}
}
