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 DataTable Select_WorkingDays_ByAcademicYear()
{
ApplicationResult objResult = new ApplicationResult();
WorkingDaysBl objWorkDaysBL = new WorkingDaysBl();
objResult = objWorkDaysBL.WorkingDays_SelectAll(ddlAcademicYear.SelectedItem.Text);
if (objResult != null)
{
}
return(objResult.resultDT);
}
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
}
}
