public void getDepartmentName()
{
ApplicationResult objResult = new ApplicationResult();
Controls objControls = new Controls();
DepartmentBL objDepartmentBl = new DepartmentBL();
if (ddlOrganisation.SelectedItem.Text == "Trust")
{
objResult = objDepartmentBl.Department_Select_By_Trust_School_ForDropDown((Convert.ToInt32(ddlOrgName.SelectedValue)), 0);
if (objResult != null)
{
objControls.BindDropDown_ListBox(objResult.resultDT, ddlDepartment, "DepartmentNameEng", "DepartmentID");
if (objResult.resultDT.Rows.Count > 0)
{
}
}
}
else
{
objResult = objDepartmentBl.Department_Select_By_Trust_School_ForDropDown((Convert.ToInt32(Session[ApplicationSession.TRUSTID])), (Convert.ToInt32(ddlOrgName.SelectedValue)));
if (objResult != null)
{
objControls.BindDropDown_ListBox(objResult.resultDT, ddlDepartment, "DepartmentNameEng", "DepartmentID");
if (objResult.resultDT.Rows.Count > 0)
{
}
}
}
ddlDepartment.Items.Insert(0, new ListItem("--Select--", ""));
}
public void bindSchool()
{
try
{
#region Bind School
SchoolBL objSchoolBL = new SchoolBL();
SchoolBO objSchoolBO = new SchoolBO();
DocumentBL objDocumentBl = new DocumentBL();
Controls objControls = new Controls();
ApplicationResult objResults = new ApplicationResult();
objResults = objSchoolBL.School_SelectAll_ForDropDOwn(Convert.ToInt32(Session[ApplicationSession.TRUSTID]));
if (objResults != null)
{
if (objResults.resultDT.Rows.Count > 0)
{
objControls.BindDropDown_ListBox(objResults.resultDT, ddlSchool, "SchoolNameEng", "SchoolMID");
}
ddlSchool.Items.Insert(0, new ListItem("-Select-", "-1"));
}
BindScreen();
#endregion
}
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 ddlSubject_OnSelectedIndexChanged(object sender, EventArgs e)
{
try
{
DropDownList ddl1 = (sender as DropDownList);
string strname = ddl1.ID;
string i = strname.Substring(strname.Length - 1, 1);
if (i == "0")
{
i = "10";
}
DropDownList ddl2 = Page.Master.FindControl("ContentPlaceHolder1").FindControl("ddlTeacher" + i.ToString()) as DropDownList;
ddl2.Items.Clear();
ApplicationResult objResult = new ApplicationResult();
SubjectTBL objSubjectTbl = new SubjectTBL();
Controls objControls = new Controls();
objResult = objSubjectTbl.SubjectT_Select_Teacher(Convert.ToInt32(ddlClass.SelectedValue),
Convert.ToInt32(ddlDivision.SelectedValue), Convert.ToInt32(ddl1.SelectedValue));
if (objResult != null)
{
if (objResult.resultDT.Rows.Count > 0)
{
objControls.BindDropDown_ListBox(objResult.resultDT, ddl2, "EmployeeFNameENG", "EmployeeMID");
}
}
ddl2.Items.Insert(0, new ListItem("None", "-1"));
}
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>");
}
}
private void BindLeaveType()
{
try
{
LeaveBl objLeaveBl = new LeaveBl();
ApplicationResult objResults = new ApplicationResult();
Controls objControls = new Controls();
for (int i = 0; i < gvLeave.Rows.Count; i++)
{
DropDownList ddlLeaveType = (DropDownList)gvLeave.Rows[i].Cells[3].FindControl("ddlLeaveType");
objResults = objLeaveBl.Leave_SelectAll_ForApply();
if (objResults != null)
{
if (objResults.resultDT.Rows.Count > 0)
{
objControls.BindDropDown_ListBox(objResults.resultDT, ddlLeaveType, "LeaveName", "LeaveID");
}
ddlLeaveType.Items.Insert(0, new ListItem("-Select-", ""));
}
}
}
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>");
}
}
public void bindTrust()
{
try
{
#region Bind Trust
TrustBL objTrustBL = new TrustBL();
TrustBO objTrustBO = new TrustBO();
Controls objControls = new Controls();
ApplicationResult objResultTrust = new ApplicationResult();
objResultTrust = objTrustBL.Trust_SelectAll();
if (objResultTrust != null)
{
if (objResultTrust.resultDT.Rows.Count > 0)
{
objControls.BindDropDown_ListBox(objResultTrust.resultDT, ddlTrustID, "TrustNameEng", "TrustMID");
}
ddlTrustID.Items.Insert(0, new ListItem("-Select-", "-1"));
}
#endregion
}
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>");
}
}
public void BindClass()
{
try
{
ApplicationResult objResult = new ApplicationResult();
ClassBL objClassBl = new ClassBL();
Controls objControl = new Controls();
objResult = objClassBl.Class_SelectAll(Convert.ToInt32(Session[ApplicationSession.SCHOOLID]));
if (objResult != null)
{
objControl.BindDropDown_ListBox(objResult.resultDT, ddlClass, "ClassName", "ClassMID");
//PanelVisibility(1);
ddlClass.Items.Insert(0, new ListItem("--Select--", ""));
}
else
{
//PanelVisibility(2);
}
}
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 ddlClass_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
ApplicationResult objResult = new ApplicationResult();
Controls objControls = new Controls();
DivisionTBL objDivisionTbl = new DivisionTBL();
objResult = objDivisionTbl.DivisionT_SelectAll_For_Exam(Convert.ToInt32(ddlClass.SelectedValue));
if (objResult != null)
{
objControls.BindDropDown_ListBox(objResult.resultDT, ddlDivision, "DivisionName", "DivisionTID");
if (objResult.resultDT.Rows.Count > 0)
{
//DivisionTID = Convert.ToInt32(objResult.resultDT.Rows[0]["DivisionTID"].ToString());
//ViewState["DivisionTID"] = DivisionTID;
}
}
}
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>");
}
}
public void BindPayItem()
{
try
{
PayItemBl ObjPayItemBl = new PayItemBl();
ApplicationResult objResult = new ApplicationResult();
Controls objControls = new Controls();
objResult = ObjPayItemBl.PayItem_Select_PayItemName(Convert.ToInt32(Session[ApplicationSession.TRUSTID]));
if (objResult != null)
{
if (objResult.resultDT.Rows.Count > 0)
{
objControls.BindDropDown_ListBox(objResult.resultDT, ddlPayItemName, "Name", "PayItemMID");
ddlPayItemName.Items.Insert(0, new ListItem("-Select-", ""));
}
else
{
// Page.ClientScript.RegisterStartupScript(this.GetType(), "CallMyFunction", "divShow();", true);
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Please insert TrustPayItem First.');</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>");
}
}
public void BindTrust()
{
var objTrustBl = new TrustBL();
var objResult = objTrustBl.Trust_SelectAll();
if (objResult == null)
{
return;
}
if (objResult.resultDT.Rows.Count <= 0)
{
return;
}
_objControl.BindDropDown_ListBox(objResult.resultDT, ddlTrust, "TrustNameEng", "TrustMID");
ddlTrust.Items.Insert(0, new ListItem("--Select--", ""));
}
protected void gvStudent_RowDataBound(object sender, GridViewRowEventArgs e)
{
try
{
DivisionTBL objDivisionBL = new DivisionTBL();
ApplicationResult objResults = new ApplicationResult();
Controls objControls = new Controls();
if (e.Row.RowType == DataControlRowType.DataRow)
{
DropDownList ddlgridDivision = (DropDownList)e.Row.FindControl("ddlGridDivision");
objResults = objDivisionBL.Division_SelectAll_ClassWise(Convert.ToInt32(ViewState["ClassMID"].ToString()), Convert.ToInt32(Session[ApplicationSession.SCHOOLID]));
if (objResults != null)
{
if (objResults.resultDT.Rows.Count > 0)
{
objControls.BindDropDown_ListBox(objResults.resultDT, ddlgridDivision, "DivisionName", "DivisionTID");
}
ddlgridDivision.Items.Insert(0, new ListItem("-Select-", ""));
}
}
if (e.Row.RowType == DataControlRowType.Header)
{
DropDownList ddlDivisionHeader = (DropDownList)e.Row.FindControl("ddlDivisionHeader");
objResults = objDivisionBL.Division_SelectAll_ClassWise(Convert.ToInt32(ViewState["ClassMID"].ToString()), Convert.ToInt32(Session[ApplicationSession.SCHOOLID]));
if (objResults != null)
{
if (objResults.resultDT.Rows.Count > 0)
{
objControls.BindDropDown_ListBox(objResults.resultDT, ddlDivisionHeader, "DivisionName", "DivisionTID");
}
ddlDivisionHeader.Items.Insert(0, new ListItem("-Select-", ""));
}
}
}
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>");
}
}
public void BindProduct()
{
ApplicationResult objrResult = new ApplicationResult();
ProductBl objProductBl = new ProductBl();
objrResult = objProductBl.Product_SelectAll_LAB();
if (objrResult != null)
{
objControls.BindDropDown_ListBox(objrResult.ResultDt, ddlProduct, "ProductName", "ProductId");
}
ddlProduct.Items.Insert(0, new ListItem("-Select-", "-1"));
}
public void BindSilo()
{
TransferDispatchBl objTransferBl = new TransferDispatchBl();
ApplicationResult objResult = new ApplicationResult();
objResult = objTransferBl.TransferSilo();
if (objResult.Status == ApplicationResult.CommonStatusType.Success)
{
if (objResult.ResultDt.Rows.Count > 0)
{
Controls objControls = new Controls();
if (objResult.ResultDt.Rows.Count > 0)
{
objControls.BindDropDown_ListBox(objResult.ResultDt, ddlSource, "TankName", "Id");
objControls.BindDropDown_ListBox(objResult.ResultDt, ddlDestination, "TankName", "Id");
}
ddlSource.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select All--", "-1"));
ddlDestination.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select All--", "-1"));
}
}
}
public void BindSubject(int intMode)
{
ApplicationResult objResult = new ApplicationResult();
SubjectTBL objSubjectTbl = new SubjectTBL();
Controls objControl = new Controls();
objResult = objSubjectTbl.Subject_Select_By_Class_Division(Convert.ToInt32(ddlClass.SelectedValue), Convert.ToInt32(ddlDivision.SelectedValue), intMode, Convert.ToInt32(Session[ApplicationSession.SCHOOLID].ToString()));
if (objResult != null)
{
objControl.BindDropDown_ListBox(objResult.resultDT, ddlSubject, "NameEng", "SubjectMID");
}
ddlSubject.Items.Insert(0, new ListItem("--Select--", ""));
}
public void BindDays(int intClassMID, int intMode)
{
ApplicationResult objResult = new ApplicationResult();
PeriodBL objPeriodBl = new PeriodBL();
Controls objControl = new Controls();
objResult = objPeriodBl.Period_SelectAll_Days(intClassMID, intMode);
if (objResult != null)
{
objControl.BindDropDown_ListBox(objResult.resultDT, ddlDay, "DayName", "DayNo");
}
ddlDay.Items.Insert(0, new ListItem("--Select--", ""));
}
public void BindUOM()
{
ApplicationResult objResult = new ApplicationResult();
UOMBL objUOMBL = new UOMBL();
Controls objControl = new Controls();
objResult = objUOMBL.UOM_SelectAll();
if (objResult != null)
{
objControl.BindDropDown_ListBox(objResult.resultDT, ddlUOM, "UOMName", "UOMID");
}
ddlUOM.Items.Insert(0, new ListItem("--Select--", ""));
}
protected void BindClass()
{
ApplicationResult objResult = new ApplicationResult();
ClassBL objClassBl = new ClassBL();
Controls objControl = new Controls();
objResult = objClassBl.Class_SelectAll(Convert.ToInt32(Session[ApplicationSession.SCHOOLID]));
if (objResult != null)
{
objControl.BindDropDown_ListBox(objResult.resultDT, ddlClass, "ClassName", "ClassMID");
}
ddlClass.Items.Insert(0, new ListItem("--Select--", ""));
}
public void BindDivision(int intClassMID)
{
ApplicationResult objResult = new ApplicationResult();
DivisionTBL objDivisionTbl = new DivisionTBL();
Controls objControl = new Controls();
objResult = objDivisionTbl.DivisionT_Select_By_Class(intClassMID);
if (objResult != null)
{
objControl.BindDropDown_ListBox(objResult.resultDT, ddlDivision, "DivisionName", "DivisionTID");
}
ddlDivision.Items.Insert(0, new ListItem("--Select--", ""));
}
private void Set_ButtonDropDown()
{
try
{
// btnCancel.Visible = true;
btnSave.Visible = true;
Controls objControls = new Controls();
ViewState["ClassMID"] = Convert.ToInt32(Request.Form[ddlClass.UniqueID]);
ViewState["DivisionName"] = Convert.ToInt32(Request.Form[ddlDivision.UniqueID]);
ViewState["AcademicYear"] = ddlAcademicYear.SelectedItem.ToString();
ViewState["FeesCategoryMID"] = Request.Form[ddlFeesCategoryName.UniqueID].ToString();
hfCLassMID.Value = ViewState["ClassMID"].ToString();
hfDivisionTID.Value = ViewState["DivisionName"].ToString();
hfFees.Value = Request.Form[ddlFeesCategoryName.UniqueID];
hfAcademicYear.Value = ddlAcademicYear.SelectedItem.ToString();
DataTable dtFeesNameWithAmount = new DataTable();
//ddlFeesCategoryName.SelectedValue = ViewState["FeesName"].ToString();
dtFeesNameWithAmount = FetchFeesNameWithAmount(Convert.ToInt32(ViewState["ClassMID"].ToString()), Convert.ToInt32(ViewState["DivisionName"].ToString()), ViewState["AcademicYear"].ToString(), Convert.ToInt32(Session[ApplicationSession.SCHOOLID]));
if (dtFeesNameWithAmount.Rows.Count > 0)
{
objControls.BindDropDown_ListBox(dtFeesNameWithAmount, ddlFeesCategoryName, "FeesNameWithAmount", "FeesCategoryMID");
ViewState["FeesName"] = dtFeesNameWithAmount.Rows[0]["FeesNameWithAmount"].ToString();
}
Page.ClientScript.RegisterStartupScript(this.GetType(), "CallMyFunction", "BindDorpdownOnButtonClick();", true);
//DataTable dtClass = new DataTable();
//dtClass = FetchClass(Convert.ToInt32(Session[ApplicationSession.SCHOOLID]));
//if (dtClass.Rows.Count > 0)
//{
// objControls.BindDropDown_ListBox(dtClass, ddlClass, "ClassName", "SectionTID");
//}
//DataTable dtDivision = new DataTable();
//ddlClass.SelectedValue = ViewState["ClassMID"].ToString();
//dtDivision = FetchDivision(Convert.ToInt32(ViewState["ClassMID"].ToString()), Convert.ToInt32(Session[ApplicationSession.SCHOOLID]));
//if (dtDivision.Rows.Count > 0)
//{
// objControls.BindDropDown_ListBox(dtDivision, ddlDivision, "DivisionName", "DivisionTID");
//}
//ddlDivision.SelectedValue = ViewState["DivisionName"].ToString();
//ddlAcademicYear.SelectedItem.Text = ViewState["AcademicYear"].ToString();
//ddlFeesCategoryName.Text = ViewState["FeesCategoryMID"].ToString();
}
catch (Exception ex)
{
}
}
protected void BindSILO()
{
Controls objControls = new Controls();
SiloBl objSiloBl = new SiloBl();
var objResult = objSiloBl.Silo_SelectAll();
if (objResult != null)
{
if (objResult.ResultDt.Rows.Count > 0)
{
objControls.BindDropDown_ListBox(objResult.ResultDt, ddlSILONo, "Name", "PLCValue");
}
ddlSILONo.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select All--", "-1"));
}
}
protected void BindShiftNo()
{
Controls objControls = new Controls();
ShiftBl objShiftBl = new ShiftBl();
var objResult = objShiftBl.Shift_SelectAll();
if (objResult != null)
{
if (objResult.ResultDt.Rows.Count > 0)
{
objControls.BindDropDown_ListBox(objResult.ResultDt, ddlShiftNo, "Name", "ShiftId");
}
ddlShiftNo.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select All--", "-1"));
}
}
public void GetMaterialGroupName()
{
ApplicationResult objResult = new ApplicationResult();
Controls objControls = new Controls();
MaterialGroupBL objMaterialGroupBl = new MaterialGroupBL();
objResult = objMaterialGroupBl.MaterialGroup_SelectAll();
if (objResult != null)
{
if (objResult.resultDT.Rows.Count > 0)
{
objControls.BindDropDown_ListBox(objResult.resultDT, ddlMaterialGroupName, "MaterialGroupName", "MaterialGroupID");
}
ddlMaterialGroupName.Items.Insert(0, new ListItem("--Select--", ""));
}
}
public void getTrustName()
{
ApplicationResult objResult = new ApplicationResult();
Controls objControls = new Controls();
TrustBL objTrustBl = new TrustBL();
objResult = objTrustBl.Trust_SelectAll_ForDropDown();
if (objResult != null)
{
if (objResult.resultDT.Rows.Count > 0)
{
objControls.BindDropDown_ListBox(objResult.resultDT, ddlOrgName, "TrustNameEng", "TrustMID");
}
ddlOrgName.Items.Insert(0, new ListItem("--Select--", ""));
}
}
public void getVendorName()
{
ApplicationResult objResult = new ApplicationResult();
Controls objControls = new Controls();
VendorBL objVendorBL = new VendorBL();
objResult = objVendorBL.Vendor_SelectAll();
if (objResult != null)
{
objControls.BindDropDown_ListBox(objResult.resultDT, ddlVendor, "VendorName", "VendorID");
if (objResult.resultDT.Rows.Count > 0)
{
}
ddlVendor.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select--", "-1"));
}
}
private void BindListbox()
{
TrustPayItemTemplateTBl objTrustPayItemTemplateBl = new TrustPayItemTemplateTBl();
ApplicationResult objResults = new ApplicationResult();
Controls objControls = new Controls();
objResults = objTrustPayItemTemplateBl.TrustPayItemTemplate_Select_PayItemWise(Convert.ToInt32(ddlSelectTemplateName.SelectedValue));
if (objResults != null)
{
if (objResults.resultDT.Rows.Count > 0)
{
objControls.BindDropDown_ListBox(objResults.resultDT, lbDependsOn, "Name", "PayItemMID");
//lbDependsOn.Items.Insert(0, new ListItem("-Select-", "-1"));
}
}
}
public void getEmployeeRoleName()
{
ApplicationResult objResult = new ApplicationResult();
Controls objControls = new Controls();
RoleBL objRoleBL = new RoleBL();
objResult = objRoleBL.Role_SelectAll_ForDropDown();
if (objResult != null)
{
objControls.BindDropDown_ListBox(objResult.resultDT, ddlEmployeeRole, "RoleName", "RoleID");
if (objResult.resultDT.Rows.Count > 0)
{
}
ddlEmployeeRole.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select All--", "-1"));
}
}
public void getDepartmentName()
{
ApplicationResult objResult = new ApplicationResult();
Controls objControls = new Controls();
DepartmentBL objDepartmentBL = new DepartmentBL();
objResult = objDepartmentBL.Department_Select_By_Trust_School_ForDropDown(Convert.ToInt32(Session[ApplicationSession.TRUSTID]), Convert.ToInt32(Session[ApplicationSession.SCHOOLID]));
if (objResult != null)
{
objControls.BindDropDown_ListBox(objResult.resultDT, ddlDepartment, "DepartmentNameENG", "DepartmentID");
if (objResult.resultDT.Rows.Count > 0)
{
}
ddlDepartment.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select All--", "-1"));
}
}
public void getDesignationName()
{
ApplicationResult objResult = new ApplicationResult();
Controls objControls = new Controls();
DesignationBL objDesignationBL = new DesignationBL();
objResult = objDesignationBL.Designation_SelectAll_ForDropDown();
if (objResult != null)
{
objControls.BindDropDown_ListBox(objResult.resultDT, ddlDesignation, "DesignationNameENG", "DesignationID");
if (objResult.resultDT.Rows.Count > 0)
{
}
ddlDesignation.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select All--", "-1"));
}
}
private void BindSchool()
{
SchoolBL objSchoolBL = new SchoolBL();
Controls objControls = new Controls();
ApplicationResult objResults = new ApplicationResult();
objResults = objSchoolBL.School_SelectAll(Convert.ToInt32(Session[ApplicationSession.TRUSTID]));
if (objResults != null)
{
if (objResults.resultDT.Rows.Count > 0)
{
objControls.BindDropDown_ListBox(objResults.resultDT, ddlSchool, "SchoolNameEng", "SchoolMID");
}
ddlSchool.Items.Insert(0, new ListItem("-Select-", ""));
}
}
public void BindYear()
{
ApplicationResult objResult = new ApplicationResult();
Controls objControls = new Controls();
MaterialGroupBL objMaterialGroupBl = new MaterialGroupBL();
objResult = objMaterialGroupBl.GetYear();
if (objResult != null)
{
if (objResult.resultDT.Rows.Count > 0)
{
objControls.BindDropDown_ListBox(objResult.resultDT, ddlYear, "Year", "Year");
ddlYear.SelectedIndex = 1;
}
}
}
public void getSchoolName()
{
ApplicationResult objResult = new ApplicationResult();
Controls objControls = new Controls();
SchoolBL objSchoolBl = new SchoolBL();
objResult = objSchoolBl.School_SelectAll_ForDropDOwn(Convert.ToInt32(Session[ApplicationSession.TRUSTID]));
if (objResult != null)
{
if (objResult.resultDT.Rows.Count > 0)
{
objControls.BindDropDown_ListBox(objResult.resultDT, ddlSchool, "SchoolNameEng", "SchoolMID");
}
ddlSchool.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select--", ""));
}
}