protected void btnSave_Click(object sender, EventArgs e)
{
try
{
StudentFeesTemplateTBL objStudentFeesTemplateBL = new StudentFeesTemplateTBL();
StudentFeesTemplateTBO objStudentFeesTemplateBO = new StudentFeesTemplateTBO();
ApplicationResult objResults = new ApplicationResult();
DatabaseTransaction.OpenConnectionTransation();
foreach (GridViewRow row in gvStudentFees.Rows)
{
if (((CheckBox)row.FindControl("chkChild")).Checked)
{
string FeesNameWithAmount = ddlFeesCategoryName.SelectedItem.Text;
char[] delimiterChars = { '/' };
string[] words = FeesNameWithAmount.Split(delimiterChars);
objStudentFeesTemplateBO.SchoolMID = Convert.ToInt32(Session[ApplicationSession.SCHOOLID]);
objStudentFeesTemplateBO.TrustMID = Convert.ToInt32(Session[ApplicationSession.TRUSTID]);
objStudentFeesTemplateBO.ClassMID = Convert.ToInt32(ViewState["ClassMID"].ToString());
objStudentFeesTemplateBO.DivisionTID = Convert.ToInt32(ViewState["DivisionName"].ToString());
objStudentFeesTemplateBO.StudentMID = Convert.ToInt32(row.Cells[0].Text);
objStudentFeesTemplateBO.AcademicYear = ddlAcademicYear.SelectedItem.Text;
objStudentFeesTemplateBO.FeesCategoryMID = Convert.ToInt32(ddlFeesCategoryName.SelectedValue);
objStudentFeesTemplateBO.FeesAmount = Convert.ToDouble(words[1]);
objStudentFeesTemplateBO.IsLate = 0;
objStudentFeesTemplateBO.LastModifiedDate = DateTime.UtcNow.AddHours(5.5).ToString();
objStudentFeesTemplateBO.LastModifiedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]);
DataTable Dt = Select_ClassTemlate_FeeCategory(Convert.ToInt32(ViewState["FeesCategoryMID"].ToString()), Convert.ToInt32(ViewState["ClassMID"].ToString()), Convert.ToInt32(ViewState["DivisionName"].ToString()), ddlAcademicYear.SelectedItem.ToString(), Convert.ToInt32(Session[ApplicationSession.SCHOOLID]), Convert.ToInt32(row.Cells[0].Text));
#region RollBack Transaction Starts
if (((CheckBox)row.FindControl("chkChild")).Checked)
{
if (Dt.Rows.Count > 0)
{
}
else
{
DataTable dt = Select_ClassTemlate_FeeCategory(Convert.ToInt32(ViewState["FeesCategoryMID"].ToString()), Convert.ToInt32(ViewState["ClassMID"].ToString()), Convert.ToInt32(ViewState["DivisionName"].ToString()), ddlAcademicYear.SelectedItem.ToString(), Convert.ToInt32(Session[ApplicationSession.SCHOOLID]), 0);
if (dt.Rows.Count > 0)
{
ViewState["ClassTemplateTID"] = Convert.ToInt32(dt.Rows[0][ClassWiseFeesTemplateTBO.CLASSWISEFEESTEMPLATET_CLASSWISEFEESTEMPLATETID].ToString());
}
objStudentFeesTemplateBO.ClassWiseFeesTemplateTID = Convert.ToInt32(ViewState["ClassTemplateTID"].ToString());
objResults = objStudentFeesTemplateBL.StudentFeesTemplateT_Insert(objStudentFeesTemplateBO);
if (objResults != null)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Fees Amount Successfully Saved.');</script>");
}
}
}
}
else
{
DataTable Dt = Select_ClassTemlate_FeeCategory(Convert.ToInt32(ViewState["FeesCategoryMID"].ToString()), Convert.ToInt32(ViewState["ClassMID"].ToString()), Convert.ToInt32(ViewState["DivisionName"].ToString()), ddlAcademicYear.SelectedItem.ToString(), Convert.ToInt32(Session[ApplicationSession.SCHOOLID]), Convert.ToInt32(row.Cells[0].Text));
if (Dt.Rows.Count > 0)
{
ViewState["ClassTemplateTID"] = Convert.ToInt32(Dt.Rows[0][ClassWiseFeesTemplateTBO.CLASSWISEFEESTEMPLATET_CLASSWISEFEESTEMPLATETID].ToString());
DataTable dtFeeCollection = ValidateFeesbyFeesCollection(Convert.ToInt32(ViewState["ClassTemplateTID"].ToString()), Convert.ToInt32(ViewState["ClassMID"].ToString()), Convert.ToInt32(ViewState["DivisionName"].ToString()), ddlAcademicYear.SelectedItem.ToString(), Convert.ToInt32(Session[ApplicationSession.SCHOOLID]), Convert.ToInt32(row.Cells[0].Text));
if (dtFeeCollection.Rows.Count > 0)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('This Fee Category is Not Update/Delete.');</script>");
}
else
{
objResults = objStudentFeesTemplateBL.StudentFeesTemplateT_Delete(Convert.ToInt32(Convert.ToInt32(Dt.Rows[0][StudentFeesTemplateTBO.STUDENTFEESTEMPLATET_STUDENTFEESTEMPLATETID].ToString())), 0);
if (objResults.status == ApplicationResult.CommonStatusType.SUCCESS)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('This Fee Category is Update/Delete Successfully.');</script>");
}
}
}
}
}
Page.ClientScript.RegisterStartupScript(this.GetType(), "CallMyFunction", "Clear();", true);
DatabaseTransaction.CommitTransation();
#endregion
ViewState["ClassMID"] = 0;
ViewState["DivisionName"] = 0;
ViewState["AcademicYear"] = "";
ViewState["FeesCategoryMID"] = "";
hfAcademicYear.Value = "0";
hfCLassMID.Value = "0";
hfDivisionTID.Value = "0";
gvStudentFees.Visible = false;
//ClearAll();
//Response.Redirect("StudentTemplate.aspx",false);
}
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 StudentFeesTemplateT in tbl_StudentFeesTemplate_T table
/// Created By : NafisaMulla, 02-09-2014
/// Modified By :
/// </summary>
/// <param name="objStudentFeesTemplateTBO"></param>
/// <returns></returns>
public ApplicationResult StudentFeesTemplateT_Update(StudentFeesTemplateTBO objStudentFeesTemplateTBO)
{
try
{
pSqlParameter = new SqlParameter[13];
pSqlParameter[0] = new SqlParameter("@StudentFeesTemplateTID",SqlDbType.Int);
pSqlParameter[0].Direction = ParameterDirection.Input;
pSqlParameter[0].Value = objStudentFeesTemplateTBO.StudentFeesTemplateTID;
pSqlParameter[1] = new SqlParameter("@FeesCategoryMID",SqlDbType.Int);
pSqlParameter[1].Direction = ParameterDirection.Input;
pSqlParameter[1].Value = objStudentFeesTemplateTBO.FeesCategoryMID;
pSqlParameter[2] = new SqlParameter("@TrustMID",SqlDbType.Int);
pSqlParameter[2].Direction = ParameterDirection.Input;
pSqlParameter[2].Value = objStudentFeesTemplateTBO.TrustMID;
pSqlParameter[3] = new SqlParameter("@SchoolMID",SqlDbType.Int);
pSqlParameter[3].Direction = ParameterDirection.Input;
pSqlParameter[3].Value = objStudentFeesTemplateTBO.SchoolMID;
pSqlParameter[4] = new SqlParameter("@ClassMID",SqlDbType.Int);
pSqlParameter[4].Direction = ParameterDirection.Input;
pSqlParameter[4].Value = objStudentFeesTemplateTBO.ClassMID;
pSqlParameter[5] = new SqlParameter("@DivisionTID",SqlDbType.Int);
pSqlParameter[5].Direction = ParameterDirection.Input;
pSqlParameter[5].Value = objStudentFeesTemplateTBO.DivisionTID;
pSqlParameter[6] = new SqlParameter("@StudentMID",SqlDbType.Int);
pSqlParameter[6].Direction = ParameterDirection.Input;
pSqlParameter[6].Value = objStudentFeesTemplateTBO.StudentMID;
pSqlParameter[7] = new SqlParameter("@ClassWiseFeesTemplateTID",SqlDbType.Int);
pSqlParameter[7].Direction = ParameterDirection.Input;
pSqlParameter[7].Value = objStudentFeesTemplateTBO.ClassWiseFeesTemplateTID;
pSqlParameter[8] = new SqlParameter("@FeesAmount",SqlDbType.Float);
pSqlParameter[8].Direction = ParameterDirection.Input;
pSqlParameter[8].Value = objStudentFeesTemplateTBO.FeesAmount;
pSqlParameter[9] = new SqlParameter("@AcademicYear",SqlDbType.VarChar);
pSqlParameter[9].Direction = ParameterDirection.Input;
pSqlParameter[9].Value = objStudentFeesTemplateTBO.AcademicYear;
pSqlParameter[10] = new SqlParameter("@LastModifiedUserID",SqlDbType.Int);
pSqlParameter[10].Direction = ParameterDirection.Input;
pSqlParameter[10].Value = objStudentFeesTemplateTBO.LastModifiedUserID;
pSqlParameter[11] = new SqlParameter("@LastModifiedDate",SqlDbType.VarChar);
pSqlParameter[11].Direction = ParameterDirection.Input;
pSqlParameter[11].Value = objStudentFeesTemplateTBO.LastModifiedDate;
pSqlParameter[12] = new SqlParameter("@Isdeleted",SqlDbType.Int);
pSqlParameter[12].Direction = ParameterDirection.Input;
pSqlParameter[12].Value = objStudentFeesTemplateTBO.Isdeleted;
sSql = "usp_tbl_StudentFeesTemplate_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
{
objStudentFeesTemplateTBO = null;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
// divLoading.Visible = true;
StudentFeesTemplateTBL objStudentFeesTemplateTBL = new StudentFeesTemplateTBL();
StudentFeesTemplateTBO objStudentFeesTemplateTBO = new StudentFeesTemplateTBO();
#region RollBack Transaction Starts
DatabaseTransaction.OpenConnectionTransation();
int k = 0;
int intCount = 0;
var objResult =
objStudentFeesTemplateTBL.StudentFeesTemplateT_Delete_ForInsert(Convert.ToInt32(hfSearchID.Value),
ddlAcademicYear.SelectedValue);
if (objResult.status == ApplicationResult.CommonStatusType.SUCCESS)
{
}
foreach (GridViewRow row in gvFees.Rows)
{
ViewState["FeesCategoryMID"] = Convert.ToInt32(row.Cells[0].Text);
objStudentFeesTemplateTBO.ClassWiseFeesTemplateTID = Convert.ToInt32(row.Cells[1].Text);
objStudentFeesTemplateTBO.SchoolMID = Convert.ToInt32(Session[ApplicationSession.SCHOOLID]);
objStudentFeesTemplateTBO.TrustMID = Convert.ToInt32(Session[ApplicationSession.TRUSTID]);
objStudentFeesTemplateTBO.ClassMID = Convert.ToInt32(ViewState["ClassMID"].ToString());
objStudentFeesTemplateTBO.DivisionTID = Convert.ToInt32(ViewState["DivisionName"].ToString());
objStudentFeesTemplateTBO.FeesAmount =
Convert.ToDouble(((TextBox)row.FindControl("txtFeesAmount")).Text);
objStudentFeesTemplateTBO.FeesCategoryMID = Convert.ToInt32(row.Cells[0].Text);
objStudentFeesTemplateTBO.StudentMID = Convert.ToInt32(hfSearchID.Value);
objStudentFeesTemplateTBO.AcademicYear = ddlAcademicYear.SelectedItem.Text;
objStudentFeesTemplateTBO.LastModifiedDate = DateTime.UtcNow.AddHours(5.5).ToString();
objStudentFeesTemplateTBO.LastModifiedUserID =
Convert.ToInt32(Session[ApplicationSession.USERID]);
objStudentFeesTemplateTBO.IsLate = 1;
//DataTable Dt = Select_ClassTemlate_FeeCategory();
if (((CheckBox)row.FindControl("chkChild")).Checked)
{
intCount += 1;
if (objStudentFeesTemplateTBO.FeesAmount == 0.0)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp",
"<script language='javascript'>alert('Please Fill Fees Amount " + row.Cells[0].Text +
".');</script>");
break;
}
else
{
ApplicationResult objResultsInsert = new ApplicationResult();
objResultsInsert =
objStudentFeesTemplateTBL.StudentFeesTemplateT_Insert(objStudentFeesTemplateTBO);
if (objResultsInsert != null)
{
k += 1;
}
}
}
}
if (k == intCount)
{
DatabaseTransaction.CommitTransation();
}
else
{
DatabaseTransaction.RollbackTransation();
//DatabaseTransaction.connection.Close();
}
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Fees Amount Successfully Saved.');</script>");
#endregion
ViewState["ClassMID"] = 0;
ViewState["DivisionName"] = 0;
ViewState["AcademicYear"] = "";
hfCLassMID.Value = "0";
hfDivisionTID.Value = "0";
gvFees.Visible = false;
ClearAll();
// Page.ClientScript.RegisterStartupScript(this.GetType(), "CallMyFunction", "BindClass();", true);
// divLoading.Visible = false;
// Response.Redirect("Class_Template.aspx");
}
catch (Exception ex)
{
DatabaseTransaction.RollbackTransation();
DatabaseTransaction.connection.Close();
logger.Error("Error", ex);
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical issue. Please Contact to your administrator.');</script>");
}
}
