public static string LoadDivision(int intClassMID, int intSchoolMID)
{
try
{
#region Bind Division
DataTable dtDivision = new DataTable();
DivisionTBL objDivisionBL = new DivisionTBL();
DivisionTBO objDivisionBO = new DivisionTBO();
ApplicationResult objResultSection = new ApplicationResult();
objResultSection = objDivisionBL.Division_SelectAll_ClassWise_ForDropDown(intClassMID, intSchoolMID);
if (objResultSection != null)
{
dtDivision = objResultSection.resultDT;
if (dtDivision.Rows.Count > 0)
{
}
}
string res = "";
res = DataSetToJSON(dtDivision);
return(res);
#endregion
}
catch (Exception ex)
{
throw ex;
}
}
public void SaveClass_T()
{
ApplicationResult objResults = new ApplicationResult();
DivisionTBL objDivisionBl = new DivisionTBL();
DivisionTBO objDivisionBo = new DivisionTBO();
objDivisionBo.ClassMID = Convert.ToInt32(ViewState["ClassMID"].ToString());
objDivisionBo.LastModifiedDate = DateTime.UtcNow.AddHours(5.5).ToString();
objDivisionBo.LastModifiedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]);
DataTable dtTask = (DataTable)ViewState["Division"];
for (int i = 0; i < dtTask.Rows.Count; i++)
{
objDivisionBo.DivisionName = dtTask.Rows[i]["DivisionName"].ToString();
objResults = objDivisionBl.DivisionT_Insert(objDivisionBo);
}
//if (objResults.status == ApplicationResult.CommonStatusType.SUCCESS)
//{
//ClearAll();
//ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Class updated successfully.');</script>");
//GridDataBind();
//PanelGrid_VisibilityMode(1);
//}
}
/// <summary>
/// To Update details of DivisionT in tbl_Division_T table
/// Created By : NafisaMulla, 11/7/2014
/// Modified By :
/// </summary>
/// <param name="objDivisionTBO"></param>
/// <returns></returns>
public ApplicationResult DivisionT_Update(DivisionTBO objDivisionTBO)
{
try
{
pSqlParameter = new SqlParameter[6];
pSqlParameter[0] = new SqlParameter("@DivisionTID", SqlDbType.Int);
pSqlParameter[0].Direction = ParameterDirection.Input;
pSqlParameter[0].Value = objDivisionTBO.DivisionTID;
pSqlParameter[1] = new SqlParameter("@ClassMID", SqlDbType.Int);
pSqlParameter[1].Direction = ParameterDirection.Input;
pSqlParameter[1].Value = objDivisionTBO.ClassMID;
pSqlParameter[2] = new SqlParameter("@DivisionName", SqlDbType.VarChar);
pSqlParameter[2].Direction = ParameterDirection.Input;
pSqlParameter[2].Value = objDivisionTBO.DivisionName;
pSqlParameter[3] = new SqlParameter("@LastModifiedUserID", SqlDbType.Int);
pSqlParameter[3].Direction = ParameterDirection.Input;
pSqlParameter[3].Value = objDivisionTBO.LastModifiedUserID;
pSqlParameter[4] = new SqlParameter("@LastModifiedDate", SqlDbType.VarChar);
pSqlParameter[4].Direction = ParameterDirection.Input;
pSqlParameter[4].Value = objDivisionTBO.LastModifiedDate;
pSqlParameter[5] = new SqlParameter("@IsDeleted", SqlDbType.Int);
pSqlParameter[5].Direction = ParameterDirection.Input;
pSqlParameter[5].Value = objDivisionTBO.IsDeleted;
sSql = "usp_tbl_Division_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
{
objDivisionTBO = null;
}
}
private DataTable FetchDivision(int intClassMID, int intSchoolMID)
{
//DataTable dtDivision = new DataTable();
DivisionTBL objDivisionBL = new DivisionTBL();
DivisionTBO objDivisionBO = new DivisionTBO();
ApplicationResult objResults = new ApplicationResult();
objResults = objDivisionBL.Division_SelectAll_ClassWise(intClassMID, intSchoolMID);
if (objResults.status == ApplicationResult.CommonStatusType.SUCCESS && objResults.resultDT.Rows.Count > 0)
{
}
return(objResults.resultDT);
}
protected void btnAdd_OnClick(object sender, EventArgs e)
{
try
{
int intflagsave = 0;
int intflagedit = 0;
DataTable dtTask = new DataTable();
dtTask = (DataTable)ViewState["Division"];
if (ViewState["DivisionMode"].ToString() == "Save")
{
if (dtTask.Rows.Count > 0)
{
string strFilter = "DivisionName = '" + txtDivisionName.Text.Trim() + "'";
DataRow[] results = dtTask.Select(strFilter);
if (results.Length > 0)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Division name already exist.');</script>");
intflagsave = 1;
}
}
if (intflagsave == 0)
{
if (ViewState["Mode"].ToString() == "Save")
{
int i = 0;
if (dtTask.Rows.Count > 0)
{
i = dtTask.Rows.Count;
}
i = i + 1;
dtTask.Rows.Add(i, txtDivisionName.Text);
ViewState["Division"] = dtTask;
gvDivision.DataSource = dtTask;
gvDivision.DataBind();
txtDivisionName.Text = "";
}
else if (ViewState["Mode"].ToString() == "Edit")
{
ApplicationResult objResults = new ApplicationResult();
DivisionTBL objDivisionBl = new DivisionTBL();
DivisionTBO objDivisionBo = new DivisionTBO();
objDivisionBo.ClassMID = Convert.ToInt32(ViewState["ClassMID"].ToString());
objDivisionBo.LastModifiedDate = DateTime.UtcNow.AddHours(5.5).ToString();
objDivisionBo.LastModifiedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]);
objDivisionBo.DivisionName = txtDivisionName.Text;
objResults = objDivisionBl.DivisionT_Insert(objDivisionBo);
objResults = objDivisionBl.DivisionT_Select_DivisionName_By_Class(Convert.ToInt32(ViewState["ClassMID"].ToString()));
if (objResults != null)
{
// ViewState["Division"] = objResults.resultDT;
// gvDivision.DataSource = (DataTable)ViewState["Division"];
gvDivision.DataSource = objResults.resultDT;
gvDivision.DataBind();
}
}
}
}
if (ViewState["DivisionMode"].ToString() == "Edit")
{
if (dtTask.Rows.Count > 0)
{
string strFilter = "DivisionName = '" + txtDivisionName.Text.Trim() + "'";
DataRow[] results = dtTask.Select(strFilter);
if (results.Length > 1)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Division name already exist.');</script>");
intflagedit = 1;
}
}
if (intflagedit == 0)
{
if (ViewState["Mode"].ToString() == "Save")
{
DataTable dtTaskTemp = (DataTable)ViewState["Division"];
foreach (DataRow dr in dtTaskTemp.Rows) // search whole table
{
if (Convert.ToInt32(dr["DivisionTID"].ToString()) == Convert.ToInt32(ViewState["DivisionDatatableTID"].ToString())) // if id==2
{
dr["DivisionName"] = txtDivisionName.Text; //change the name
//break; break or not depending on you
}
ViewState["Division"] = dtTask;
gvDivision.DataSource = dtTask;
gvDivision.DataBind();
}
}
else if (ViewState["Mode"].ToString() == "Edit")
{
ApplicationResult objResults = new ApplicationResult();
DivisionTBL objDivisionBl = new DivisionTBL();
DivisionTBO objDivisionBo = new DivisionTBO();
objDivisionBo.ClassMID = Convert.ToInt32(ViewState["ClassMID"].ToString());
objDivisionBo.DivisionTID = Convert.ToInt32(ViewState["DivisionTID"].ToString());
objDivisionBo.LastModifiedDate = DateTime.UtcNow.AddHours(5.5).ToString();
objDivisionBo.LastModifiedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]);
objDivisionBo.DivisionName = txtDivisionName.Text;
objResults = objDivisionBl.DivisionT_Update(objDivisionBo);
ViewState["Mode"] = "Edit";
objResults = objDivisionBl.DivisionT_Select_DivisionName_By_Class(Convert.ToInt32(ViewState["ClassMID"].ToString()));
if (objResults != null)
{
// ViewState["Division"] = objResults.resultDT;
// gvDivision.DataSource = (DataTable)ViewState["Division"];
gvDivision.DataSource = objResults.resultDT;
gvDivision.DataBind();
}
}
}
}
}
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 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>");
}
}
