protected void btnSave_Click(object sender, EventArgs e)
{
#region Fetch The Data if Present
WorkingDaysBl objWOrkingDaysBL = new WorkingDaysBl();
WorkingDaysBo objWorkingDaysBO = new WorkingDaysBo();
ApplicationResult objResults = new ApplicationResult();
objWorkingDaysBO.SchoolMID = Convert.ToInt32(Session[ApplicationSession.SCHOOLID]);
objWorkingDaysBO.TrustMID = Convert.ToInt32(Session[ApplicationSession.TRUSTID]);
objWorkingDaysBO.AcademicYear = ddlAcademicYear.SelectedItem.ToString();
objWorkingDaysBO.LastModifiedDate = DateTime.UtcNow.AddHours(5.5).ToString();
objWorkingDaysBO.LastModifiedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]);
DataTable Dt = Select_WorkingDays_ByAcademicYear();
if (Dt.Rows.Count > 0)
{
// if Data is Already in table than Update
#region Update Data
for (int i = 0; i < gvWorkingDays.Rows.Count; i++)
{
objWorkingDaysBO.WorkingDayID = Convert.ToInt32(Dt.Rows[i][WorkingDaysBo.WORKINGDAYS_WORKINGDAYID].ToString());
objWorkingDaysBO.MonthID = Convert.ToInt32(gvWorkingDays.Rows[i].Cells[0].Text);
TextBox txtDays = (TextBox)gvWorkingDays.Rows[i].Cells[2].FindControl("txtTotalDays");
objWorkingDaysBO.TotalWorkingDays = Convert.ToInt32(txtDays.Text);
objResults = objWOrkingDaysBL.WorkingDays_Update(objWorkingDaysBO);
if (objResults.status == ApplicationResult.CommonStatusType.SUCCESS)
{
}
}
#endregion
}
else
{
// if No row is found than new entry or insertion entry in table
#region Insert Data
for (int i = 0; i < gvWorkingDays.Rows.Count; i++)
{
objWorkingDaysBO.MonthID = Convert.ToInt32(gvWorkingDays.Rows[i].Cells[0].Text);
TextBox txtDays = (TextBox)gvWorkingDays.Rows[i].Cells[2].FindControl("txtTotalDays");
objWorkingDaysBO.TotalWorkingDays = Convert.ToInt32(txtDays.Text);
objWorkingDaysBO.CreatedDate = DateTime.UtcNow.AddHours(5.5).ToString();
objWorkingDaysBO.CreatedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]);
objResults = objWOrkingDaysBL.WorkingDays_Insert(objWorkingDaysBO);
if (objResults.status == ApplicationResult.CommonStatusType.SUCCESS)
{
}
}
#endregion
}
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Working Days Successfully Added/Updated.');</script>");
divSave.Visible = false;
gvWorkingDays.Visible = false;
BindAcademicYear();
#endregion
}
public void BindGridView()
{
ApplicationResult objResult = new ApplicationResult();
WorkingDaysBl objWorkDaysBL = new WorkingDaysBl();
WorkingDaysBo objWorkingDaysBO = new WorkingDaysBo();
objResult = objWorkDaysBL.WorkingDays_SelectAllMonths();
if (objResult != null)
{
gvWorkingDays.DataSource = objResult.resultDT;
gvWorkingDays.DataBind();
if (objResult.resultDT.Rows.Count > 0)
{
gvWorkingDays.Visible = true;
divSave.Visible = true;
}
else
{
gvWorkingDays.Visible = false;
divSave.Visible = false;
}
}
//Fetch the data in Gridview if Data in Database table
DataTable Dt = Select_WorkingDays_ByAcademicYear();
if (Dt.Rows.Count > 0)
{
#region Updation of WOrk Days
for (int i = 0; i < gvWorkingDays.Rows.Count; i++)
{
TextBox txtDays = (TextBox)gvWorkingDays.Rows[i].Cells[2].FindControl("txtTotalDays");
txtDays.Text = Dt.Rows[i][WorkingDaysBo.WORKINGDAYS_TOTALWORKINGDAYS].ToString();
}
#endregion
}
}
/// <summary>
/// To Update details of WorkingDays in tbl_TotalWorkDays_M table
/// Created By : NafisaMulla, 25-02-2015
/// Modified By :
/// </summary>
/// <param name="objWorkingDaysBO"></param>
/// <returns></returns>
public ApplicationResult WorkingDays_Update(WorkingDaysBo objWorkingDaysBO)
{
try
{
pSqlParameter = new SqlParameter[8];
pSqlParameter[0] = new SqlParameter("@WorkingDayID", SqlDbType.Int);
pSqlParameter[0].Direction = ParameterDirection.Input;
pSqlParameter[0].Value = objWorkingDaysBO.WorkingDayID;
pSqlParameter[1] = new SqlParameter("@TrustMID", SqlDbType.Int);
pSqlParameter[1].Direction = ParameterDirection.Input;
pSqlParameter[1].Value = objWorkingDaysBO.TrustMID;
pSqlParameter[2] = new SqlParameter("@SchoolMID", SqlDbType.Int);
pSqlParameter[2].Direction = ParameterDirection.Input;
pSqlParameter[2].Value = objWorkingDaysBO.SchoolMID;
pSqlParameter[3] = new SqlParameter("@AcademicYear", SqlDbType.VarChar);
pSqlParameter[3].Direction = ParameterDirection.Input;
pSqlParameter[3].Value = objWorkingDaysBO.AcademicYear;
pSqlParameter[4] = new SqlParameter("@MonthID", SqlDbType.Int);
pSqlParameter[4].Direction = ParameterDirection.Input;
pSqlParameter[4].Value = objWorkingDaysBO.MonthID;
pSqlParameter[5] = new SqlParameter("@TotalWorkingDays", SqlDbType.Int);
pSqlParameter[5].Direction = ParameterDirection.Input;
pSqlParameter[5].Value = objWorkingDaysBO.TotalWorkingDays;
pSqlParameter[6] = new SqlParameter("@LastModifiedUserID", SqlDbType.Int);
pSqlParameter[6].Direction = ParameterDirection.Input;
pSqlParameter[6].Value = objWorkingDaysBO.LastModifiedUserID;
pSqlParameter[7] = new SqlParameter("@LastModifiedDate", SqlDbType.VarChar);
pSqlParameter[7].Direction = ParameterDirection.Input;
pSqlParameter[7].Value = objWorkingDaysBO.LastModifiedDate;
sSql = "usp_tbl_TotalWorkDays_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
{
objWorkingDaysBO = null;
}
}