/// <summary>
/// To Insert details of Class in tbl_Class_M table
/// Created By : NafisaMulla, 2/7/2014
/// Modified By :
/// </summary>
/// <param name="objClassBO"></param>
/// <returns></returns>
public ApplicationResult Class_Insert(ClassBO objClassBO)
{
try
{
pSqlParameter = new SqlParameter[9];
pSqlParameter[0] = new SqlParameter("@SectionTID", SqlDbType.Int);
pSqlParameter[0].Direction = ParameterDirection.Input;
pSqlParameter[0].Value = objClassBO.SectionTID;
pSqlParameter[1] = new SqlParameter("@SchoolMID", SqlDbType.Int);
pSqlParameter[1].Direction = ParameterDirection.Input;
pSqlParameter[1].Value = objClassBO.SchoolMID;
pSqlParameter[2] = new SqlParameter("@ClassName", SqlDbType.VarChar);
pSqlParameter[2].Direction = ParameterDirection.Input;
pSqlParameter[2].Value = objClassBO.ClassName;
pSqlParameter[3] = new SqlParameter("@ApprovalDate", SqlDbType.VarChar);
pSqlParameter[3].Direction = ParameterDirection.Input;
pSqlParameter[3].Value = objClassBO.ApprovalDate;
pSqlParameter[4] = new SqlParameter("@ApprovalNo", SqlDbType.VarChar);
pSqlParameter[4].Direction = ParameterDirection.Input;
pSqlParameter[4].Value = objClassBO.ApprovalNo;
pSqlParameter[5] = new SqlParameter("@LastModifiedUserID", SqlDbType.Int);
pSqlParameter[5].Direction = ParameterDirection.Input;
pSqlParameter[5].Value = objClassBO.LastModifiedUserID;
pSqlParameter[6] = new SqlParameter("@LastModifiedDate", SqlDbType.VarChar);
pSqlParameter[6].Direction = ParameterDirection.Input;
pSqlParameter[6].Value = objClassBO.LastModifiedDate;
pSqlParameter[7] = new SqlParameter("@IsDeleted", SqlDbType.Int);
pSqlParameter[7].Direction = ParameterDirection.Input;
pSqlParameter[7].Value = objClassBO.IsDeleted;
pSqlParameter[8] = new SqlParameter("@NoOfPeriod", SqlDbType.Int);
pSqlParameter[8].Direction = ParameterDirection.Input;
pSqlParameter[8].Value = objClassBO.NoOfPeriod;
sSql = "usp_tbl_Class_M_Insert";
DataTable dtResult = new DataTable();
dtResult = Database.ExecuteDataTable(CommandType.StoredProcedure, sSql, pSqlParameter);
ApplicationResult objResults = new ApplicationResult(dtResult);
objResults.status = ApplicationResult.CommonStatusType.SUCCESS;
return(objResults);
}
catch (Exception ex)
{
throw ex;
}
finally
{
objClassBO = null;
}
}
public static string LoadClass(int intEmployeeMID)
{
try
{
#region Bind Class
ClassBL objClassBL = new ClassBL();
ClassBO objClassBO = new ClassBO();
ApplicationResult objResultSection = new ApplicationResult();
objResultSection = objClassBL.Class_SelectAll_EmployeeWise(intEmployeeMID);
if (objResultSection != null)
{
if (objResultSection.resultDT.Rows.Count > 0)
{
}
}
string res = "";
res = DataSetToJSON(objResultSection.resultDT);
return(res);
#endregion
}
catch (Exception ex)
{
throw ex;
}
}
public static string LoadClass(int intSchoolMID)
{
try
{
#region Bind Class
DataTable dtClass = new DataTable();
ClassBL objClassBL = new ClassBL();
ClassBO objClassBO = new ClassBO();
ApplicationResult objResultSection = new ApplicationResult();
objResultSection = objClassBL.Class_SelectAll_ForDropDownNotSectionWise(intSchoolMID);
if (objResultSection != null)
{
dtClass = objResultSection.resultDT;
if (dtClass.Rows.Count > 0)
{
}
}
string res = "";
res = DataSetToJSON(dtClass);
return(res);
#endregion
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// To Update details of Class in tbl_Class_M table
/// Created By : NafisaMulla, 2/7/2014
/// Modified By :
/// </summary>
/// <param name="objClassBO"></param>
/// <returns></returns>
public ApplicationResult Class_Update_For_Priority(ClassBO objClassBO)
{
try
{
pSqlParameter = new SqlParameter[7];
pSqlParameter[0] = new SqlParameter("@ClassMID", SqlDbType.Int);
pSqlParameter[0].Direction = ParameterDirection.Input;
pSqlParameter[0].Value = objClassBO.ClassMID;
pSqlParameter[1] = new SqlParameter("@ClassName", SqlDbType.VarChar);
pSqlParameter[1].Direction = ParameterDirection.Input;
pSqlParameter[1].Value = objClassBO.ClassName;
pSqlParameter[2] = new SqlParameter("@LastModifiedUserID", SqlDbType.Int);
pSqlParameter[2].Direction = ParameterDirection.Input;
pSqlParameter[2].Value = objClassBO.LastModifiedUserID;
pSqlParameter[3] = new SqlParameter("@LastModifiedDate", SqlDbType.VarChar);
pSqlParameter[3].Direction = ParameterDirection.Input;
pSqlParameter[3].Value = objClassBO.LastModifiedDate;
pSqlParameter[4] = new SqlParameter("@IsDeleted", SqlDbType.Int);
pSqlParameter[4].Direction = ParameterDirection.Input;
pSqlParameter[4].Value = objClassBO.IsDeleted;
pSqlParameter[5] = new SqlParameter("@SchoolMID", SqlDbType.Int);
pSqlParameter[5].Direction = ParameterDirection.Input;
pSqlParameter[5].Value = objClassBO.SchoolMID;
pSqlParameter[6] = new SqlParameter("@Priority", SqlDbType.Int);
pSqlParameter[6].Direction = ParameterDirection.Input;
pSqlParameter[6].Value = objClassBO.Priority;
sSql = "usp_tbl_Class_M_Update_For_Priority";
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
{
objClassBO = null;
}
}
private DataTable FetchClass(int intSchoolMID)
{
// DataTable dtClass = new DataTable();
ClassBL objClassBL = new ClassBL();
ClassBO objClassBO = new ClassBO();
ApplicationResult objResults = new ApplicationResult();
objResults = objClassBL.Class_SelectAll(intSchoolMID);
if (objResults.status == ApplicationResult.CommonStatusType.SUCCESS && objResults.resultDT.Rows.Count > 0)
{
}
return(objResults.resultDT);
}
protected void btnSaveClass_Click(object sender, EventArgs e)
{
try
{
ClassBL objClasstBl = new ClassBL();
ClassBO objClassBo = new ClassBO();
DivisionTBO objDivisionBo = new DivisionTBO();
DivisionTBL objDivisionBl = new DivisionTBL();
Controls objControls = new Controls();
ApplicationResult objResults = new ApplicationResult();
if (ValidateName() == true)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Class Name " + txtClassName.Text + " And Divsion " + txtDivisionName.Text + " already Exists.');</script>");
goto Exit;
}
objClassBo.SchoolMID = Convert.ToInt32(Session[ApplicationSession.SCHOOLID].ToString());
objClassBo.SectionTID = Convert.ToInt32(ddlSection.SelectedValue);
objClassBo.SchoolMID = Convert.ToInt32(Session[ApplicationSession.SCHOOLID]);
objClassBo.ClassName = txtClassName.Text;
objClassBo.NoOfPeriod = Convert.ToInt32(txtNoOfPeriod.Text);
objClassBo.ApprovalNo = txtApprovalNo.Text;
objClassBo.ApprovalDate = txtApprovalDate.Text;
objClassBo.LastModifiedDate = DateTime.UtcNow.AddHours(5.5).ToString();
objClassBo.LastModifiedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]);
objDivisionBo.LastModifiedDate = DateTime.UtcNow.AddHours(5.5).ToString();
objDivisionBo.LastModifiedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]);
#region RollBack Transaction Starts
DatabaseTransaction.OpenConnectionTransation();
if (ViewState["Mode"].ToString() == "Save")
{
//objResults = objClasstBl.Class_ValidateName(txtClassName.Text, Convert.ToInt32(Session[ApplicationSession.SCHOOLID]));
//if (objResults != null)
//{
// if (objResults.resultDT.Rows.Count > 0)
// {
// ViewState["ClassMID"] = Convert.ToInt32(objResults.resultDT.Rows[0][0].ToString());
// SaveClass_T();
// }
// else
// {
objResults = objClasstBl.Class_Insert(objClassBo);
if (objResults != null)
{
if (objResults.resultDT.Rows.Count > 0)
{
ViewState["ClassMID"] = Convert.ToInt32(objResults.resultDT.Rows[0][0].ToString());
SaveClass_T();
ClearAll();
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Record saved successfully.');</script>");
GridDataBind();
PanelGrid_VisibilityMode(1);
}
else
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Class Name " + txtClassName.Text + " Already Exists.');</script>");
}
}
// }
//}
}
else
{
objClassBo.ClassMID = Convert.ToInt32(ViewState["ClassMID"].ToString());
objDivisionBo.ClassMID = Convert.ToInt32(ViewState["ClassMID"].ToString());
objResults = objClasstBl.Class_Update(objClassBo);
if (objResults.status == ApplicationResult.CommonStatusType.SUCCESS)
{
//ApplicationResult objResultsDivisionUpdate = new ApplicationResult();
//objResultsDivisionUpdate =
// objDivisionBl.DivisionT_Delete_By_Class(Convert.ToInt32(ViewState["ClassMID"].ToString()));
//DataTable dtTask = (DataTable)ViewState["Division"];
//for (int i = 0; i < dtTask.Rows.Count; i++)
//{
// objDivisionBo.DivisionName = dtTask.Rows[i]["DivisionName"].ToString();
// objResultsDivisionUpdate = objDivisionBl.DivisionT_Insert(objDivisionBo);
//}
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Record updated successfully.');</script>");
ClearAll();
GridDataBind();
objControls.ClearForm(Master.FindControl("ContentPlaceHolder1"));
ViewState["Mode"] = "Save";
}
else
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Class Name " + txtClassName.Text + " Already Exists.');</script>");
}
}
DatabaseTransaction.CommitTransation();
#endregion
Exit :;
}
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 btnGo_Click(object sender, EventArgs e)
{
if (rblToggleView.SelectedItem.Text == "Class")
{
try
{
ApplicationResult objResult = new ApplicationResult();
ClassBL objClassBL = new ClassBL();
ClassBO objClassBO = new ClassBO();
#region RollBack Transaction Starts
DatabaseTransaction.OpenConnectionTransation();
for (int i = 0; i < gvClass.Rows.Count; i++)
{
TextBox txtSequence = (TextBox)gvClass.Rows[i].FindControl("txtSequence");
if (txtSequence.Text != "")
{
objClassBO.Priority = Convert.ToInt32(txtSequence.Text);
objClassBO.ClassMID = Convert.ToInt32(gvClass.Rows[i].Cells[0].Text);
objClassBO.ClassName = gvClass.Rows[i].Cells[1].Text;
objClassBO.SchoolMID = Convert.ToInt32(Session[ApplicationSession.SCHOOLID]);
objResult = objClassBL.Class_Update_For_Priority(objClassBO);
if (objResult != null)
{
}
else
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp",
"<script>alert('Oops! There is some technical issue. Please Contact to your administrator...');</script>");
}
}
else
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp",
"<script>alert('Enter the priority.');</script>");
break;
}
}
DatabaseTransaction.CommitTransation();
#endregion
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp",
"<script>alert('Record Saved Successfully.');</script>");
}
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>");
}
}
else if (rblToggleView.SelectedItem.Text == "Fees Category")
{
try
{
ApplicationResult objResult = new ApplicationResult();
FeesCategoryBL objFeesCategoryBL = new FeesCategoryBL();
FeesCategoryBO objFeesCategoryBO = new FeesCategoryBO();
#region RollBack Transaction Starts
DatabaseTransaction.OpenConnectionTransation();
for (int i = 0; i < gvFees.Rows.Count; i++)
{
TextBox txtSequence = (TextBox)gvFees.Rows[i].FindControl("txtSequence1");
if (txtSequence.Text != "")
{
objFeesCategoryBO.Priority = Convert.ToInt32(txtSequence.Text);
objFeesCategoryBO.FeesCategoryMID = Convert.ToInt32(gvFees.Rows[i].Cells[0].Text);
objFeesCategoryBO.FeesName = gvFees.Rows[i].Cells[1].Text;
objResult = objFeesCategoryBL.FeesCategory_Update_For_Priority(objFeesCategoryBO);
if (objResult != null)
{
}
else
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp",
"<script>alert('Oops! There is some technical issue. Please Contact to your administrator...');</script>");
}
}
else
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp",
"<script>alert('Enter the priority.');</script>");
break;
}
}
DatabaseTransaction.CommitTransation();
#endregion
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp",
"<script>alert('Record Saved Successfully.');</script>");
}
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>");
}
}
else
{
}
}
