private DataSet GetClassRecord(DataSet dsSelect, int SchRegID)
{
obj_SchoolRegistrationBMS = new SchoolBMS();
obj_BAL_SchoolRegistrationBMS = new SchoolBMS_BLogic();
obj_SchoolRegistrationBMS.schregbmsid = SchRegID;
string SearchCondition = string.Empty;
if (ddlStatus.SelectedValue != ((int)EnumFile.AssignValue.Zero).ToString())
{
SearchCondition = SearchCondition + " and SchoolBMS.StatusID=" + ddlStatus.SelectedValue;
}
if (ddlSchoolType.SelectedValue != ((int)EnumFile.AssignValue.Zero).ToString())
{
SearchCondition = SearchCondition + " and SchoolBMS.SchoolTypeID = " + ddlSchoolType.SelectedValue + " ";
}
if (ddlBoardI.SelectedValue != ((int)EnumFile.AssignValue.Zero).ToString())
{
SearchCondition = SearchCondition + " and SYS_Board.BoardID = " + ddlBoardI.SelectedValue + " ";
}
if (ddlMedium.SelectedValue != ((int)EnumFile.AssignValue.Zero).ToString())
{
SearchCondition = SearchCondition + " and SYS_Medium.MediumID = " + ddlMedium.SelectedValue + " ";
}
if (ddlStandard.SelectedValue != ((int)EnumFile.AssignValue.Zero).ToString())
{
SearchCondition = SearchCondition + " and SYS_Standard.StandardID = " + ddlStandard.SelectedValue + " ";
}
obj_SchoolRegistrationBMS.schregid = SchRegID;
dsSelect = obj_BAL_SchoolRegistrationBMS.BAL_SchoolBMS_Select(obj_SchoolRegistrationBMS, "SelectAllBySchRegID", SearchCondition);
return(dsSelect);
}
public DataSet BAL_SchoolBMS_Select(SchoolBMS obj_SchoolBMS, string mode, string SearchCondition)
{
obj_DAL_SchoolBMS = new DataAccess();
obj_arrParameter = new ArrayList();
obj_arrParameter.Add(new parameter("mode", mode));
obj_arrParameter.Add(new parameter("Tmp_SchBMSID", obj_SchoolBMS.schregbmsid));
obj_arrParameter.Add(new parameter("SearchCondition", SearchCondition));
return(obj_DAL_SchoolBMS.DAL_Select("Proc_SchoolBMSSelectDelete", obj_arrParameter));
}
public void BAL_SchoolBMS_UpdateStatus(SchoolBMS obj_SchoolBMS, string mode)
{
obj_DAL_SchoolBMS = new DataAccess();
obj_arrParameter = new ArrayList();
obj_arrParameter.Add(new parameter("mode", mode));
obj_arrParameter.Add(new parameter("Tmp_SchBMSIDStr", obj_SchoolBMS.schregbmsidStr));
obj_arrParameter.Add(new parameter("Tmp_Status", obj_SchoolBMS.StatusID));
obj_DAL_SchoolBMS.DAL_InsertUpdate("UPDATE_SchoolBMSStatus", obj_arrParameter);
}
public void BAL_SchoolBMS_Delete(SchoolBMS obj_SchoolBMS, string mode)
{
obj_DAL_SchoolBMS = new DataAccess();
obj_arrParameter = new ArrayList();
obj_arrParameter.Add(new parameter("mode", mode));
obj_arrParameter.Add(new parameter("Tmp_SchRegBMSID", obj_SchoolBMS.schregbmsid));
obj_arrParameter.Add(new parameter("Tmp_SchoolTypeID", obj_SchoolBMS.schooltypeid));
obj_arrParameter.Add(new parameter("Tmp_BMSID", obj_SchoolBMS.bmsid));
obj_arrParameter.Add(new parameter("Tmp_SchRegID", obj_SchoolBMS.schregid));
obj_arrParameter.Add(new parameter("Tmp_NoOfStudents", obj_SchoolBMS.noofstudents));
obj_arrParameter.Add(new parameter("Tmp_StartTime", obj_SchoolBMS.starttime));
obj_arrParameter.Add(new parameter("Tmp_EndTime", obj_SchoolBMS.endtime));
obj_arrParameter.Add(new parameter("Tmp_IsApprove", obj_SchoolBMS.StatusID));
obj_DAL_SchoolBMS.DAL_Delete("SELECT_DELETE_SchoolBMS", obj_arrParameter);
}
protected void btnAppRejSubmit_Click(object sender, EventArgs e)
{
int CountChecked = Convert.ToInt32(EnumFile.AssignValue.Zero);
string tmp_SchoolBMSIDStr = string.Empty;
foreach (GridViewRow gr in gvSchoolRegistrationBMSdetail.Rows)
{
CheckBox chk = new CheckBox();
chk = (CheckBox)gr.FindControl("chkSelect");
if (chk.Checked == true)
{
int StatusID;
StatusID = Convert.ToInt32(gvSchoolRegistrationBMSdetail.DataKeys[gr.RowIndex]["StatusID"]);
if (StatusID == Convert.ToInt32(EnumFile.Status.Appiled) || StatusID == Convert.ToInt32(EnumFile.Status.Approve) || StatusID == Convert.ToInt32(EnumFile.Status.Reject))
{
if (CountChecked == Convert.ToInt32(EnumFile.AssignValue.Zero))
{
tmp_SchoolBMSIDStr = gvSchoolRegistrationBMSdetail.DataKeys[gr.RowIndex]["SchoolID"].ToString();
}
else
{
tmp_SchoolBMSIDStr = tmp_SchoolBMSIDStr + " , " + gvSchoolRegistrationBMSdetail.DataKeys[gr.RowIndex]["SchoolID"].ToString();
}
CountChecked = CountChecked + 1;
}
else
{
CountChecked = Convert.ToInt32(EnumFile.AssignValue.Zero);
break;
}
}
}
if (CountChecked > Convert.ToInt32(EnumFile.AssignValue.Zero))
{
try
{
obj_SchoolRegistrationBMS = new SchoolBMS();
obj_BAL_SchoolRegistrationBMS = new SchoolBMS_BLogic();
int tmpstatusid = Convert.ToInt32(EnumFile.AssignValue.Zero);
if (rbApprove.Checked == true)
{
tmpstatusid = Convert.ToInt32(EnumFile.Status.Approve);
}
if (rbReject.Checked == true)
{
tmpstatusid = Convert.ToInt32(EnumFile.Status.Reject);
}
obj_SchoolRegistrationBMS.schregbmsidStr = tmp_SchoolBMSIDStr;
obj_SchoolRegistrationBMS.StatusID = tmpstatusid;
obj_BAL_SchoolRegistrationBMS.BAL_SchoolBMS_UpdateStatus(obj_SchoolRegistrationBMS, "UpdateClassStatus");
bindgrvSchoolRegistrationBMSdetail(Convert.ToInt32(ViewState["SchRegID"].ToString()));
}
catch (Exception ex)
{
WebMsg.Show(ex.Message);
}
}
else
{
WebMsg.Show("Please select atleast one record.");
}
}
