protected void btnGo_Click(object sender, EventArgs e)
{
try
{
LeaveTemplateBl objLeaveTemplateBl = new LeaveTemplateBl();
ApplicationResult objResultProgram = new ApplicationResult();
objResultProgram = objLeaveTemplateBl.LeaveTemplate_SelectForTemplate(Convert.ToInt32(hfEmployeeID.Value), ddlYear.Text);
if (objResultProgram != null)
{
if (objResultProgram.resultDT.Rows.Count > 0)
{
gvLeave.DataSource = null;
gvLeave.Visible = true;
gvLeave.DataSource = objResultProgram.resultDT;
gvLeave.DataBind();
btnSave.Visible = true;
}
else
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('No Record Found.');</script>");
gvLeave.Visible = false;
}
for (int i = 0; i < objResultProgram.resultDT.Rows.Count; i++)
{
var Id = objResultProgram.resultDT.Rows[i]["LeaveID"].ToString();
var Total = objResultProgram.resultDT.Rows[i]["Total"].ToString();
foreach (GridViewRow row in gvLeave.Rows)
{
if (row.Cells[0].Text == Id)
{
if (Total != "0")
{
((CheckBox)row.FindControl("chkChild")).Checked = true;
Convert.ToDouble(((TextBox)row.FindControl("txtTotalLeaves")).Text = Total);
}
}
}
}
}
}
catch (Exception ex)
{
logger.Error("Error", ex);
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical issue. Please Contact to your administrator.');</script>");
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
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>");
}
}
