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());
}
}
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());
}
}
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);
}
}
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"));
}
}
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());
}
}
}
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));
}
}
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"));
}
}
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"));
}
}
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"));
}
}
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"));
}
}
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"));
}
}
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"));
}
}
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);
}
}
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);
}
}
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);
}
}
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();
}
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);
}
}
public AffiliationAdminSideController()
{
db = new UOSEntities();
}
public RegistrationAdminSideController(ApplicationUserManager userManager, ApplicationSignInManager signInManager)
{
UserManager = userManager;
SignInManager = signInManager;
db = new UOSEntities();
}
public AffiliationMembersController()
{
db = new UOSEntities();
}
public RegistrationAdminSideController()
{
db = new UOSEntities();
}