/// <summary>
/// To Delete details of LeaveTemplate for selected LeaveTemplateID from tbl_LeaveTemplate table
/// Created By : Nirmal, 09-02-2016
/// Modified By :
/// </summary>
public ApplicationResult LeaveTemplate_Delete(LeaveTemplateBo objLeaveTemplateBo)
{
try
{
pSqlParameter = new SqlParameter[3];
pSqlParameter[0] = new SqlParameter("@LeaveID", SqlDbType.Int);
pSqlParameter[0].Direction = ParameterDirection.Input;
pSqlParameter[0].Value = objLeaveTemplateBo.LeaveID;
pSqlParameter[1] = new SqlParameter("@EmployeeMID", SqlDbType.Int);
pSqlParameter[1].Direction = ParameterDirection.Input;
pSqlParameter[1].Value = objLeaveTemplateBo.EmployeeMID;
pSqlParameter[2] = new SqlParameter("@AcademicYear", SqlDbType.VarChar);
pSqlParameter[2].Direction = ParameterDirection.Input;
pSqlParameter[2].Value = objLeaveTemplateBo.AcademicYear;
strStoredProcName = "usp_tbl_LeaveTemplate_Delete";
int iResult = DatabaseTransaction.ExecuteNonQuery(CommandType.StoredProcedure, strStoredProcName, 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;
}
}
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>");
}
}
/// <summary>
/// To Update details of LeaveTemplate in tbl_LeaveTemplate table
/// Created By : Nirmal, 09-02-2016
/// Modified By :
/// </summary>
public ApplicationResult LeaveTemplate_Update(LeaveTemplateBo objLeaveTemplateBo)
{
try
{
pSqlParameter = new SqlParameter[9];
pSqlParameter[0] = new SqlParameter("@LeaveTemplateID", SqlDbType.Int);
pSqlParameter[0].Direction = ParameterDirection.Input;
pSqlParameter[0].Value = objLeaveTemplateBo.LeaveTemplateID;
pSqlParameter[1] = new SqlParameter("@EmployeeMID", SqlDbType.Int);
pSqlParameter[1].Direction = ParameterDirection.Input;
pSqlParameter[1].Value = objLeaveTemplateBo.EmployeeMID;
pSqlParameter[2] = new SqlParameter("@LeaveID", SqlDbType.Int);
pSqlParameter[2].Direction = ParameterDirection.Input;
pSqlParameter[2].Value = objLeaveTemplateBo.LeaveID;
pSqlParameter[3] = new SqlParameter("@Total", SqlDbType.VarChar);
pSqlParameter[3].Direction = ParameterDirection.Input;
pSqlParameter[3].Value = objLeaveTemplateBo.Total;
pSqlParameter[4] = new SqlParameter("@IsDeleted", SqlDbType.Int);
pSqlParameter[4].Direction = ParameterDirection.Input;
pSqlParameter[4].Value = objLeaveTemplateBo.IsDeleted;
pSqlParameter[5] = new SqlParameter("@LastModifiedBy", SqlDbType.Int);
pSqlParameter[5].Direction = ParameterDirection.Input;
pSqlParameter[5].Value = objLeaveTemplateBo.LastModifiedBy;
pSqlParameter[6] = new SqlParameter("@LastModifiedDate", SqlDbType.VarChar);
pSqlParameter[6].Direction = ParameterDirection.Input;
pSqlParameter[6].Value = objLeaveTemplateBo.LastModifiedDate;
sSql = "usp_tbl_LeaveTemplate_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
{
objLeaveTemplateBo = null;
}
}
