Exemple #1
0
 public DataTable GetSchoolClassMasterDetails(BCSchoolAdmin objSchoolAdmin)
 {
     try
     {
         _dt = DataAccessLayer.ReturnDataTable("select SM.School,SM.SchoolId, CM.CityName,SCM.Class,SCM.ClassYear, SCM.ClassId from SchoolClassMaster SCM inner join SchoolMaster SM on SCM.SchoolId = SM.SchoolId left join CityMaster CM on SM.CityId=CM.CityId where sCm.IsActive = 1 and SM.CityId=(case '" + (objSchoolAdmin.CityName == 0 ? 0 : objSchoolAdmin.CityName) + "' when 0 then SM.CityId else '" + objSchoolAdmin.CityName + "' end) and SM.School like (CASE '" + (objSchoolAdmin.SchoolName == "" ? "0" : objSchoolAdmin.SchoolName) + "' WHEN ' ' THEN SM.School ELSE '" + objSchoolAdmin.SchoolName + "' END)+'%' order by School Asc ");
     }
     catch { }
     return(_dt);
 }
 private int _SaveUpdate()
 {
     BCSchoolAdmin objSchoolAdmnin = new BCSchoolAdmin();
     objUser.UserId = Convert.ToInt32(hdn_ClassAdminId.Value);
     objUser.FirstName = txt_FirstName.Text;
     objUser.LastName = txt_LastName.Text;
     objUser.Address = txtAddress.Text;
     objUser.Email = txtEmail.Text;
     objUser.Password = txtPassword.Text;
     return objSchoolAdmnin.InsertUpdateClassAdmin(objUser);
     //objUser.ClassId = Convert.ToInt16(ddl_Class.SelectedValue);
     //objAppAdmin.InsertUpdateCityAdmin(objUser);
 }
    private int _SaveUpdate()
    {
        BCSchoolAdmin objSchoolAdmnin = new BCSchoolAdmin();

        objUser.UserId    = Convert.ToInt32(hdn_ClassAdminId.Value);
        objUser.FirstName = txt_FirstName.Text;
        objUser.LastName  = txt_LastName.Text;
        objUser.Address   = txtAddress.Text;
        objUser.Email     = txtEmail.Text;
        objUser.Password  = txtPassword.Text;
        return(objSchoolAdmnin.InsertUpdateClassAdmin(objUser));
        //objUser.ClassId = Convert.ToInt16(ddl_Class.SelectedValue);
        //objAppAdmin.InsertUpdateCityAdmin(objUser);
    }
Exemple #4
0
    public DataTable GetClassAdminList(BCSchoolAdmin objSchoolAdmin)
    {
        try
        {
            _dt = DataAccessLayer.ExecuteStoredProcedureToRetDataTable(new SqlParameter[] {
                new SqlParameter("@ClassAdminId", (objSchoolAdmin.ClassAdminId == 0 ? 0 : objSchoolAdmin.ClassAdminId)),
                new SqlParameter("@AdminName", (objSchoolAdmin.AdminName == "" ? " " : objSchoolAdmin.AdminName)),
                new SqlParameter("@SchoolId", (objSchoolAdmin.SchoolId == 0 ? 0 : objSchoolAdmin.SchoolId)),
                new SqlParameter("@CityAdminId", (objSchoolAdmin.CityAdminId == 0 ? 0 : objSchoolAdmin.CityAdminId)),
            }, "SP_GETCLASSADMINS");
        }
        catch (Exception ex)
        {
            throw ex;
        }

        return(_dt);
    }
 public DataTable GetSchoolClassMasterDetails(BCSchoolAdmin objSchoolAdmin)
 {
     try
     {
         _dt = DataAccessLayer.ReturnDataTable("select SM.School,SM.SchoolId, CM.CityName,SCM.Class,SCM.ClassYear, SCM.ClassId from SchoolClassMaster SCM inner join SchoolMaster SM on SCM.SchoolId = SM.SchoolId left join CityMaster CM on SM.CityId=CM.CityId where sCm.IsActive = 1 and SM.CityId=(case '" + (objSchoolAdmin.CityName == 0 ? 0 : objSchoolAdmin.CityName) + "' when 0 then SM.CityId else '" + objSchoolAdmin.CityName + "' end) and SM.School like (CASE '" + (objSchoolAdmin.SchoolName == "" ? "0" : objSchoolAdmin.SchoolName) + "' WHEN ' ' THEN SM.School ELSE '" + objSchoolAdmin.SchoolName + "' END)+'%' order by School Asc ");
     }
     catch { }
     return _dt;
 }
    public DataTable GetClassAdminList(BCSchoolAdmin objSchoolAdmin)
    {
        try
        {
            _dt = DataAccessLayer.ExecuteStoredProcedureToRetDataTable(new SqlParameter[] {
                new SqlParameter("@ClassAdminId", (objSchoolAdmin.ClassAdminId == 0 ? 0 : objSchoolAdmin.ClassAdminId)),
                new SqlParameter("@AdminName", (objSchoolAdmin.AdminName == "" ? " " : objSchoolAdmin.AdminName)),
                new SqlParameter("@SchoolId", (objSchoolAdmin.SchoolId == 0 ? 0 : objSchoolAdmin.SchoolId)),
                new SqlParameter("@CityAdminId", (objSchoolAdmin.CityAdminId == 0 ? 0 : objSchoolAdmin.CityAdminId)),
            }, "SP_GETCLASSADMINS");
        }
        catch (Exception ex)
        {
            throw ex;
        }

        return _dt;
    }