示例#1
0
        public ActionResult ReportTest()
        {
            using (UOSEntities db = new UOSEntities())
            {
                ReportViewer reportViewer = new ReportViewer();
                reportViewer.ProcessingMode      = ProcessingMode.Local;
                reportViewer.SizeToReportContent = true;
                reportViewer.Width  = Unit.Percentage(900);
                reportViewer.Height = Unit.Percentage(900);

                var DBvlu = db.AJ_Stud_Admin_Return_Reg_C(2);
                // var DBvlu = db.Aj_Aff_Ins_Admin_Fee_slip(2);
                // var DBvlu = db.Stud_Admin_Basic_info(1);
                // reportViewer.LocalReport.ReportPath = Server.MapPath(@"~/Reports/Regirstion_Reports/rdlc_Stud_Admin_Return_Reg_A.rdlc");
                //   reportViewer.LocalReport.ReportPath = Server.MapPath(@"~/Reports/Regirstion_Reports/Rdlc_Affi_reg_return_Anax_C.rdlc"); ;
                reportViewer.LocalReport.ReportPath = Server.MapPath(@"~/Reports/Regirstion_Reports/Rdlc_aff_reg_chak_list.rdlc");;
                //reportViewer.LocalReport.DataSources.Add(new ReportDataSource("AJ_Stud_Admin_Return_Reg_A", DBvlu));

                //reportViewer.LocalReport.ReportPath = Server.MapPath(@"~/Reports/Regirstion_Reports/Rdlc_Student_info_fr_Admin.rdlc");
                //reportViewer.LocalReport.DataSources.Add(new ReportDataSource("Stud_Admin_Basic_info", DBvlu));
                //reportViewer.LocalReport.DataSources.Add(new ReportDataSource("Rdlc_Affi_reg_return_Anax_C", DBvlu));//Rdlc_aff_reg_chak_list
                reportViewer.LocalReport.DataSources.Add(new ReportDataSource("Rdlc_aff_reg_chak_list", DBvlu));//Rdlc_aff_reg_chak_list

                //reportViewer.LocalReport.ReportPath = Server.MapPath(@"~/Reports/Regirstion_Reports/Rdlc_Reg_Admin_Fee_Slip.rdlc");
                //reportViewer.LocalReport.DataSources.Add(new ReportDataSource("Aj_Aff_Ins_Admin_Fee_slip", DBvlu));
                ViewBag.ReportViewer = reportViewer;
                return(View());
            }
        }
示例#2
0
        public ActionResult PDF()
        {
            using (UOSEntities db = new UOSEntities())
            {
                int instID = 1;
                //List<byte[]> obj = new List<byte[]>();
                //obj.Add(Download_Rpt_Insitut_info(instID));
                //obj.Add(Download_Rpt_Room_info(instID));
                //obj.Add(Download_Rpt_Non_Requir_info(instID));
                //obj.Add(Download_Rpt_Requir_info(instID));
                //obj.Add(Download_Rpt_Sport_info(instID));
                //obj.Add(Download_Rpt_Staff_info(instID, 1));
                //obj.Add(Download_Rpt_Staff_info(instID, 0));
                //obj.Add(Download_Rpt_Libaray_info(instID));
                //obj.Add(Laboratory(instID));

                // byte[] bytes = concatAndAddContent(obj);
                //Microsoft.Reporting.WebForms.LocalReport rpt = new Microsoft.Reporting.WebForms.LocalReport();
                //rpt.ReportPath = Server.MapPath(@"~/Aff_Reports/Rep_Affi_Ins_Visting_Member.rdlc");
                //rpt.DataSources.Add(new ReportDataSource("AJ_Aff_Ins_Vist_Rep_Commety", db.AJ_Aff_Ins_Vist_Rep_Commety(Convert.ToInt32(1))));
                //rpt.DataSources.Add(new ReportDataSource("AJ_Aff_Ins_Vist_Rep_MEmBEr_Commety", db.AJ_Aff_Ins_Vist_Rep_MEmBEr_Commety(Convert.ToInt32(1))));

                byte[] bytes = Download_Rpt_Room_info(instID); //rpt.Render("PDF");
                Response.Buffer = true;
                Response.Clear();
                Response.AddHeader("content-disposition", "attachment; filename= Application" + "." + "PDF");
                Response.OutputStream.Write(bytes, 0, bytes.Length); // create the file
                Response.Flush();                                    // send it to the client to download
                Response.End();
                return(View());
            }
        }
示例#3
0
        public IEnumerable <AllColleges> Colleges(int id)
        {
            int val = 0;

            if (int.TryParse(id.ToString(), out val))
            {
                using (UOSEntities db = new UOSEntities())
                {
                    var data = db.bi_get_affi_clgs_with_pagination(val);
                    List <AllColleges> listobj = new List <AllColleges>();
                    foreach (var item in data)
                    {
                        AllColleges obj = new AllColleges();
                        obj.id           = item.ID.ToString();
                        obj.collegeName  = item.Ins_Name;
                        obj.isGovCollege = item.Ins_IsGov == true ? true : false;
                        obj.collegeCode  = item.Inst_code.ToString();
                        listobj.Add(obj);
                    }
                    return(listobj);
                }
            }
            else
            {
                List <AllColleges> listobj = new List <AllColleges>();
                return(listobj);
            }
        }
示例#4
0
        public ActionResult PDF()
        {
            using (UOSEntities db = new UOSEntities())
            {
                obj = GetData();
                int           instID = Convert.ToInt32(obj.Institute_Id);
                var           AppID  = db.Aff_ins_Application.Where(a => a.Aff_Year == obj.Id_year_for_affilation && a.Inst_ID == instID).Select(a => a.ID).Single();
                List <byte[]> obj1   = new List <byte[]>();
                obj1.Add(Download_Rpt_Insitut_info(Convert.ToInt32(AppID)));
                obj1.Add(Download_Rpt_Appl_Declaration_info(instID));
                obj1.Add(Download_Rpt_Room_info(instID));
                obj1.Add(Download_Rpt_Non_Requir_info(instID));
                obj1.Add(Download_Rpt_Requir_info(instID));
                obj1.Add(Download_Rpt_Sport_info(instID));
                obj1.Add(Download_Rpt_Staff_info(instID, 1));
                obj1.Add(Download_Rpt_Staff_info(instID, 0));
                obj1.Add(Download_Rpt_Libaray_info(instID));
                obj1.Add(Laboratory(instID));

                byte[] bytes = concatAndAddContent(obj1);
                Response.Buffer = true;
                Response.Clear();
                Response.AddHeader("content-disposition", "attachment; filename= Application" + "." + "PDF");
                Response.OutputStream.Write(bytes, 0, bytes.Length); // create the file
                Response.Flush();                                    // send it to the client to download
                Response.End();
                return(RedirectToAction("/Status"));
            }
        }
示例#5
0
 public static byte[] concatAndAddContent(List <byte[]> pdfByteContent)
 {
     using (UOSEntities db = new UOSEntities())
     {
         using (var ms = new MemoryStream())
         {
             using (var doc = new Document())
             {
                 using (var copy = new PdfSmartCopy(doc, ms))
                 {
                     doc.Open();
                     //Loop through each byte array
                     foreach (var p in pdfByteContent)
                     {
                         //Create a PdfReader bound to that byte array
                         using (var reader = new PdfReader(p))
                         {
                             //Add the entire document instead of page-by-page
                             copy.AddDocument(reader);
                         }
                     }
                     doc.Close();
                 }
             }
             //  ms.Flush();
             //Return just before disposing
             return(ms.ToArray());
         }
     }
 }
示例#6
0
        public ActionResult status()
        {
            using (UOSEntities db = new UOSEntities())
            {
                obj = GetData();
                int        instid = Convert.ToInt32(obj.Institute_Id);
                var        list   = db.AJ_Affi_Ins_Pop_Instu_Info(instid);
                UserStatus status = new UserStatus();
                foreach (var item in list)
                {
                    status.Email         = item.Ins_Email;
                    status.InstituteName = item.Ins_Name;
                    status.MobileNumber  = item.Ins_OfficMobile;
                    status.Nature        = item.College_Catg;
                    status.PhoneNumber   = item.Ins_ContactPTCL;
                    status.PostalAddress = item.Ins_PostAddres;
                    status.PrincipalName = item.Ins_PrinciPal_Name;
                    obj.Application_id   = Convert.ToInt32(item.application_id);


                    if (item.Securty_status == 1)
                    {
                        status.Status = "successfully Granted";
                        status.ReturnStatusIdentity = 1;
                    }
                    else if (item.is_grant_Affiliation == true && (item.Securty_status == 0 || item.Securty_status == null))
                    {
                        var dv = db.Aj_affi_Get_application_Prog_scurity_Fee(item.application_id);
                        foreach (var ite in dv)
                        {
                            status.Status               = "Affiliation conditionally granted Submit your Secuirty Fee as soon as possiable  with demand daraf of RS.";
                            status.StatusValueFOrLink   = ite.Value.ToString();
                            status.Status1              = "And Upload Draft.";
                            status.ReturnStatusIdentity = 2;
                        }
                    }
                    else if (item.Is_visit == true && (item.is_grant_Affiliation == false || item.is_grant_Affiliation == null) && (item.Securty_status == 0 || item.Securty_status == null))
                    {
                        status.Status = "Application is in visiting schedule. Affiliation Inspection committee will visit you soon.";
                    }
                    else if (item.Is_visit_assign == true && (item.Is_visit == false || item.Is_visit == null))
                    {
                        status.Status = "Application is in process wait for visit of affiliation insecption committee.";
                    }
                    else if (item.IS_submit == true && (item.Is_visit_assign == false || item.Is_visit_assign == null))
                    {
                        status.Status = "Your Application Is submit from your side please wait for further action from Affiliation Branch of UOS.";
                    }
                    else if ((item.IS_submit == false || item.IS_submit == null) && (item.Is_visit_assign == false || item.Is_visit_assign == null))
                    {
                        status.Status = "You Application Is not complet Or Reject from Admin due to some deficieny.";
                    }
                }
                return(View(status));
            }
        }
示例#7
0
 byte[] Laboratory(int Inst_ID)
 {
     using (UOSEntities db = new UOSEntities())
     {
         Microsoft.Reporting.WebForms.LocalReport rpt = new Microsoft.Reporting.WebForms.LocalReport();
         rpt.ReportPath = Server.MapPath(@"~/Aff_Reports/Aff_inst_AJ_Rep_Laboratory_INFO.rdlc");
         rpt.DataSources.Add(new ReportDataSource("AJ_Rep_Laboratory_INFO", db.AJ_Rep_Laboratory_INFO(Convert.ToInt32(Inst_ID))));
         return(rpt.Render("PDF"));
     }
 }
示例#8
0
        byte[] Download_Rpt_Insitut_info(int Inst_ID)
        {
            using (UOSEntities db = new UOSEntities())
            {
                Microsoft.Reporting.WebForms.LocalReport rpt = new Microsoft.Reporting.WebForms.LocalReport();
                rpt.ReportPath = Server.MapPath(@"~/Aff_Reports/Rpt_Affi_Instu_Info.rdlc");
                rpt.DataSources.Add(new ReportDataSource("AJ_Affi_Ins_Pop_Instu_Info", db.AJ_Affi_Ins_Pop_Instu_Info(Convert.ToInt32(Inst_ID))));

                return(rpt.Render("PDF"));
            }
        }
示例#9
0
        byte[] Download_Rpt_Non_Requir_info(int Inst_ID)
        {
            using (UOSEntities db = new UOSEntities())
            {
                Microsoft.Reporting.WebForms.LocalReport rpt = new Microsoft.Reporting.WebForms.LocalReport();
                rpt.ReportPath = Server.MapPath(@"~/Aff_Reports/Aff_ins_Non_Recuring_INFO.rdlc");
                rpt.DataSources.Add(new ReportDataSource("AJ_Rep_Non_Recuring_INFO", db.AJ_Rep_Non_Recuring_INFO(Convert.ToInt32(Inst_ID))));

                return(rpt.Render("PDF"));
            }
        }
示例#10
0
        byte[] Download_Rpt_Staff_info(int Inst_ID, int cag)
        {
            using (UOSEntities db = new UOSEntities())
            {
                Microsoft.Reporting.WebForms.LocalReport rpt = new Microsoft.Reporting.WebForms.LocalReport();
                rpt.ReportPath = Server.MapPath(@"~/Aff_Reports/Aff_Inst_Staff_Info.rdlc");
                rpt.DataSources.Add(new ReportDataSource("AJ_Rep_Employee_INFO", db.AJ_Rep_Employee_INFO(Convert.ToInt32(Inst_ID), cag)));

                return(rpt.Render("PDF"));
            }
        }
示例#11
0
        byte[] Download_Rpt_Libaray_info(int Inst_ID)
        {
            using (UOSEntities db = new UOSEntities())
            {
                Microsoft.Reporting.WebForms.LocalReport rpt = new Microsoft.Reporting.WebForms.LocalReport();
                rpt.ReportPath = Server.MapPath(@"~/Aff_Reports/Aff_Inst_Library_INFO.rdlc");
                rpt.DataSources.Add(new ReportDataSource("AJ_Rep_Library_INFO", db.AJ_Rep_Library_INFO(Convert.ToInt32(Inst_ID))));
                rpt.DataSources.Add(new ReportDataSource("Affi_ins_Rep_OtherFacilities_INFO", db.AJ_Affi_ins_Rep_OtherFacilities_INFO(Convert.ToInt32(Inst_ID))));

                return(rpt.Render("PDF"));
            }
        }
示例#12
0
        public ActionResult UploadSecurityDeposite(DemandDraft model)
        {
            using (UOSEntities db = new UOSEntities())
            {
                obj = GetData();
                if (!ModelState.IsValid)
                {
                    return(View(model));
                }
                if (model.ImageFile == null || model.ImageFile.ContentLength <= 0)
                {
                    ViewBag.DDImageNull = "Please Choose the Image Of Demand Draft";
                    return(View());
                }
                var allowedExtensions = new[] { ".pdf", ".jpg", ".png", ".jpeg" };
                var extension         = Path.GetExtension(model.ImageFile.FileName);
                if (!allowedExtensions.Contains(extension.ToLower()))
                {
                    ViewBag.DDImageNull = "Image Extension Must Be JPG , JPEG , PNG , PDF";
                    return(View());
                }
                if (model.ImageFile.ContentLength > (1024 * 300))
                {
                    ViewBag.DDImageNull = "Image Size Must BE Less Than 300KB";
                    return(View());
                }
                string FileName = Path.GetFileNameWithoutExtension(model.ImageFile.FileName);

                //Converting into Bytes
                try
                {
                    Stream       fs = model.ImageFile.InputStream;
                    BinaryReader br = new BinaryReader(fs);
                    model.Draft_Scan = br.ReadBytes((Int32)fs.Length);
                    model.FileName   = Path.GetFileName(model.ImageFile.FileName);
                    int instid = Convert.ToInt32(obj.Institute_Id);
                    db.BI_Affi_insert_Draft_detail_program_security(instid, obj.Id_year_for_affilation, Convert.ToString(model.bank_name), Convert.ToString(model.bank_address), Convert.ToString(model.branch_code), Convert.ToString(model.amount), Convert.ToDateTime(Convert.ToDateTime(model.deposite_date).ToString("yyyy-MM-dd")), model.Draft_Scan, model.FileName);
                    TempData["Success"] = "Demand Draft Inserted Successfully";
                }
                catch (Exception e)
                {
                    ViewBag.Exception = "Error In Insertion Please Try Again";
                    return(View());
                }
                return(RedirectToAction("DemandDraft", "UserAccount"));
            }
        }
示例#13
0
 public IEnumerable <AllColleges> Colleges()
 {
     using (UOSEntities db = new UOSEntities())
     {
         var data = (from t1 in db.Affil_Ins_Info select new { t1.ID, t1.Ins_Name, t1.Ins_IsGov, t1.Inst_code }).ToList();
         List <AllColleges> listobj = new List <AllColleges>();
         foreach (var item in data)
         {
             AllColleges obj = new AllColleges();
             obj.id           = item.ID.ToString();
             obj.collegeName  = item.Ins_Name;
             obj.isGovCollege = item.Ins_IsGov == true ? true : false;
             obj.collegeCode  = item.Inst_code.ToString();
             listobj.Add(obj);
         }
         return(listobj);
     }
 }
示例#14
0
        public IEnumerable <studentInterInfo> inter(string cnic)
        {
            if (cnic.Length == 13)
            {
                string part1 = cnic.Substring(0, 5);
                string part2 = cnic.Substring(5, 7);
                string part3 = cnic.Substring(12, 1);

                string FinalCnic = part1 + "-" + part2 + "-" + part3;


                using (UOSEntities db_obj = new UOSEntities())
                {
                    var data = (from BInfo in db_obj.stu_basic_info
                                join Iinfo in db_obj.stu_inter_info
                                on BInfo.st_id equals Iinfo.st_id
                                join IDN in db_obj.Intermediate_Programs
                                on Iinfo.i_degree_name equals IDN.ID.ToString()
                                join IB in db_obj.boards
                                on Iinfo.i_board_id equals IB.ID
                                where (BInfo.st_cinc == FinalCnic)
                                select new
                    {
                        BInfo.st_id,
                        BInfo.st_cinc,
                        Iinfo.i_degree_name,
                        IDN.Inter_Program,
                        Iinfo.i_board_id,
                        IB.Board_Name,
                        Iinfo.i_passing_year,
                        Iinfo.i_examination_type,
                        Iinfo.i_rollnumber,
                        Iinfo.i_total_marks,
                        Iinfo.i_obtained_marks,
                        Iinfo.i_division,
                        Iinfo.i_percentage,
                        Iinfo.i_result_scan
                    }).ToList();
                    List <studentInterInfo> objList = new List <studentInterInfo>();
                    foreach (var item in data)
                    {
                        studentInterInfo obj = new studentInterInfo();

                        obj.stid = item.st_id.ToString();
                        obj.cnic = item.st_cinc.ToString();

                        obj.degreeId   = item.i_degree_name.ToString();
                        obj.degreeName = item.Inter_Program.ToString();

                        obj.boardId   = item.i_board_id.ToString();
                        obj.boardName = item.Board_Name.ToString();

                        obj.passingYear     = item.i_passing_year.ToString();
                        obj.examinationType = item.i_examination_type.ToString();
                        obj.boardRollNumber = item.i_rollnumber.ToString();
                        obj.totalMarks      = item.i_total_marks.ToString();
                        obj.obtainedMarks   = item.i_obtained_marks.ToString();
                        obj.division        = item.i_division.ToString();
                        obj.percentage      = item.i_percentage.ToString();

                        Byte[] bytes        = item.i_result_scan;
                        string base64String = Convert.ToBase64String(bytes, 0, bytes.Length);
                        obj.interImage = base64String;
                        objList.Add(obj);
                    }
                    return(objList);
                }
            }
            else
            {
                List <studentInterInfo> objList = new List <studentInterInfo>();
                return(objList);
            }
        }
示例#15
0
        public IEnumerable <studentMatricInfo> matric(string cnic)
        {
            if (cnic.Length == 13)
            {
                string part1 = cnic.Substring(0, 5);
                string part2 = cnic.Substring(5, 7);
                string part3 = cnic.Substring(12, 1);

                string FinalCnic = part1 + "-" + part2 + "-" + part3;


                using (UOSEntities db_obj = new UOSEntities())
                {
                    var data = (from BInfo in db_obj.stu_basic_info
                                join Minfo in db_obj.stu_ssc_info
                                on BInfo.st_id equals Minfo.st_id
                                join Brds in db_obj.boards
                                on Minfo.m_board_id equals Brds.ID
                                where (BInfo.st_cinc == FinalCnic)
                                select new
                    {
                        BInfo.st_id,
                        BInfo.st_cinc,
                        Minfo.m_degree_name,
                        Minfo.m_subject,
                        Minfo.m_board_id,
                        Brds.Board_Name,
                        Minfo.m_passing_year,
                        Minfo.m_examination_type,
                        Minfo.m_rollnumber,
                        Minfo.m_total_marks,
                        Minfo.m_obtained_marks,
                        Minfo.m_division,
                        Minfo.m_percentage,
                        Minfo.m_result_scan
                    }).ToList();

                    List <studentMatricInfo> objList = new List <studentMatricInfo>();
                    foreach (var item in data)
                    {
                        studentMatricInfo obj = new studentMatricInfo();

                        obj.stid            = item.st_id.ToString();
                        obj.cnic            = item.st_cinc.ToString();
                        obj.degree          = item.m_degree_name.ToString();
                        obj.subject         = item.m_subject.ToString();
                        obj.boardId         = item.m_board_id.ToString();
                        obj.boardName       = item.Board_Name.ToString();
                        obj.passingYear     = item.m_passing_year.ToString();
                        obj.examinationType = item.m_examination_type.ToString();
                        obj.boardRollNumber = item.m_rollnumber.ToString();
                        obj.totalMarks      = item.m_total_marks.ToString();
                        obj.obtainedMarks   = item.m_obtained_marks.ToString();
                        obj.division        = item.m_division.ToString();
                        obj.percentage      = item.m_percentage.ToString();
                        Byte[] bytes        = item.m_result_scan;
                        string base64String = Convert.ToBase64String(bytes, 0, bytes.Length);
                        obj.matricImage = base64String;
                        objList.Add(obj);
                    }
                    return(objList);
                }
            }
            else
            {
                List <studentMatricInfo> objList = new List <studentMatricInfo>();
                return(objList);
            }
        }
示例#16
0
        public async Task <ActionResult> Login(Login login)
        {
            using (UOSEntities db = new UOSEntities())
            {
                if (Request.IsAuthenticated)
                {
                    return(RedirectToAction("Index", "Home"));
                }

                if (!ModelState.IsValid)
                {
                    return(View(login));
                }
                try
                {
                    var result = await SignInManager.PasswordSignInAsync(login.Email, login.Password, false, shouldLockout : true);

                    switch (result)
                    {
                    case SignInStatus.Success:
                    {
                        var dbUser    = db.AspNetUsers.SingleOrDefault(u => u.UserName == login.Email);
                        var isDisable = dbUser.isDisable;
                        if (isDisable == false)
                        {
                            var claims = UserManager.GetClaims(dbUser.Id);
                            if (claims != null)
                            {
                                foreach (var claim in claims)
                                {
                                    UserManager.RemoveClaim(dbUser.Id, claim);
                                }
                            }
                            var           dbyear = db.BI_Affi_pop_year_for_the_affilation();
                            SessionObject obj    = new SessionObject();
                            foreach (var year in dbyear)
                            {
                                obj.Affiliation_Year       = Convert.ToInt32(year.Year);
                                obj.Id_year_for_affilation = Convert.ToInt32(year.ID);
                                obj.Affiliation_Year       = Convert.ToInt32(year.Year);
                                obj.Id_year_for_affilation = Convert.ToInt32(year.ID);
                            }

                            obj.Institute_Id = dbUser.Institute_ID.ToString();
                            UserManager.AddClaim(dbUser.Id, new Claim("InstituteId", obj.Institute_Id.ToString()));
                            UserManager.AddClaim(dbUser.Id, new Claim("AffiliationYear", obj.Affiliation_Year.ToString()));
                            UserManager.AddClaim(dbUser.Id, new Claim("YearId", obj.Id_year_for_affilation.ToString()));
                            return(RedirectToAction("Login", "Accounts"));
                        }
                        return(View(login));
                    }

                    case SignInStatus.LockedOut:
                    {
                        ViewBag.Account = "Account Is Locked";
                        return(View(login));
                    }

                    case SignInStatus.RequiresVerification:
                    {
                        return(RedirectToAction("SendCode", "Accounts", new { login = login }));
                    }

                    case SignInStatus.Failure:
                    {
                        ViewBag.UserError = "UserName And Password Does Not Match";
                        return(View(login));
                    }

                    default:
                        return(View(login));
                    }
                }
                catch (Exception e)
                {
                    ViewBag.RegisterError = "Error While Logging Your Account Contact Admin Person" + e.Message;
                    return(View(login));
                }
            }
        }
 public AffiliationMembersController(ApplicationUserManager userManager, ApplicationSignInManager signInManager)
 {
     UserManager   = userManager;
     SignInManager = signInManager;
     db            = new UOSEntities();
 }
示例#18
0
        public IEnumerable <studentPersonalInfo> personal(string cnic)
        {
            if (cnic.Length == 13)
            {
                string part1 = cnic.Substring(0, 5);
                string part2 = cnic.Substring(5, 7);
                string part3 = cnic.Substring(12, 1);

                string FinalCnic = part1 + "-" + part2 + "-" + part3;


                using (UOSEntities db_obj = new UOSEntities())
                {
                    var data = (from st in db_obj.stu_basic_info
                                join C in db_obj.countries on st.st_counter_id equals C.ID
                                join PRC in db_obj.countries on st.st_pr_country_id equals PRC.ID

                                join P in db_obj.Provinces on st.st_provience_id equals P.ID
                                join PRP in db_obj.Provinces on st.st_pr_provience_id equals PRP.ID

                                join D in db_obj.districts on st.st_dist_id equals D.ID
                                join PRD in db_obj.districts on st.st_pr_dist_id equals PRD.ID

                                join T in db_obj.District_tehsils on st.st_tehsil_id equals T.ID
                                join PRT in db_obj.District_tehsils on st.st_pr_tehsil_id equals PRT.ID

                                where (st.st_cinc == FinalCnic.ToString())
                                select new
                    {
                        st.st_id,
                        st.reg_number,
                        st.st_name,
                        st.Father_name,
                        st.st_dob,
                        st.st_birth_place,
                        st.st_contact,
                        st.st_bloodgroup,
                        st.st_email,
                        st.st_gender,
                        st.st_martial_status,
                        st.st_religion,
                        st.st_cinc,
                        st.st_nationality,
                        st.st_pr_country_id,
                        PRCountry_Name = PRC.Country_Name,
                        st.st_pr_provience_id,
                        PRProvince_name = PRP.Province_name,
                        st.st_pr_dist_id,
                        PRDist_Name = PRD.Dist_Name,
                        st.st_pr_tehsil_id,
                        PRTehsils = PRT.Tehsils,
                        st.st_pr_address,
                        st.st_counter_id,
                        C.Country_Name,
                        st.st_provience_id,
                        P.Province_name,
                        st.st_dist_id,
                        D.Dist_Name,
                        st.st_tehsil_id,
                        T.Tehsils,
                        st.st_address,
                        st.st_gr_name,
                        st.st_gr_cnic,
                        st.st_gr_cell,
                        st.st_relation_id,
                        st.st_gr_eaducation,
                        st.st_gr_occupation,
                        st.st_gr_job_sector,
                        st.st_gr_anual_income,
                        st.st_image
                    }
                                ).ToList();
                    List <studentPersonalInfo> objList = new List <studentPersonalInfo>();
                    foreach (var item in data)
                    {
                        studentPersonalInfo obj = new studentPersonalInfo();

                        obj.stid          = item.st_id.ToString();
                        obj.regNumber     = item.reg_number.ToString();
                        obj.cnic          = item.st_cinc.ToString();
                        obj.name          = item.st_name.ToString();
                        obj.fName         = item.st_gr_name.ToString();
                        obj.gender        = item.st_gender.ToString();
                        obj.bloodGroup    = item.st_bloodgroup.ToString();
                        obj.dob           = item.st_dob.ToString();
                        obj.religion      = item.st_religion.ToString();
                        obj.martialStatus = item.st_martial_status.ToString();
                        obj.cellNo        = item.st_contact.ToString();
                        obj.email         = item.st_email.ToString();
                        obj.nationality   = item.st_nationality.ToString();
                        obj.pob           = item.st_birth_place.ToString();

                        obj.countryId   = item.st_counter_id.ToString();
                        obj.countryName = item.Country_Name.ToString();

                        obj.provienceId   = item.st_provience_id.ToString();
                        obj.provienceName = item.Province_name.ToString();

                        obj.disttId   = item.st_dist_id.ToString();
                        obj.disttName = item.Province_name.ToString();

                        obj.tehsilId   = item.st_tehsil_id.ToString();
                        obj.tehsilName = item.Tehsils.ToString();

                        obj.Address = item.st_address.ToString();

                        obj.PRcountryId   = item.st_pr_country_id.ToString();
                        obj.PRcountryName = item.PRCountry_Name.ToString();

                        obj.PRprovienceId   = item.st_pr_provience_id.ToString();
                        obj.PRprovienceName = item.PRProvince_name.ToString();

                        obj.PRdisttId   = item.st_pr_dist_id.ToString();
                        obj.PRdisttName = item.PRDist_Name.ToString();

                        obj.PRtehsilId   = item.st_pr_tehsil_id.ToString();
                        obj.PRtehsilName = item.PRTehsils.ToString();

                        obj.PRparpermanentAddress = item.st_pr_address.ToString();

                        obj.grName         = item.st_gr_name.ToString();
                        obj.grCnic         = item.st_gr_cnic.ToString();
                        obj.grCell         = item.st_gr_cell.ToString();
                        obj.grRelation     = item.st_relation_id.ToString();
                        obj.grEaducation   = item.st_gr_eaducation.ToString();
                        obj.grOccupation   = item.st_gr_occupation.ToString();
                        obj.grJobSector    = item.st_gr_job_sector.ToString();
                        obj.grAnnualIncome = item.st_gr_anual_income.ToString();
                        Byte[] bytes        = item.st_image;
                        string base64String = Convert.ToBase64String(bytes, 0, bytes.Length);

                        obj.studentImage = base64String;
                        objList.Add(obj);
                    }
                    return(objList);
                }
            }
            else
            {
                List <studentPersonalInfo> objList = new List <studentPersonalInfo>();
                return(objList);
            }
        }
示例#19
0
 public AffiliationAdminSideController()
 {
     db = new UOSEntities();
     
 }
示例#20
0
 public RegistrationAdminSideController(ApplicationUserManager userManager, ApplicationSignInManager signInManager)
 {
     UserManager   = userManager;
     SignInManager = signInManager;
     db            = new UOSEntities();
 }
 public AffiliationMembersController()
 {
     db = new UOSEntities();
 }
示例#22
0
 public RegistrationAdminSideController()
 {
     db = new UOSEntities();
 }