public JsonResult UpdateCareer(string careerId, string maindescription, string course, string subdescription, string reading, string videos, string online) { int career = Convert.ToInt32(careerId); int result; ObjectParameter returnId = new ObjectParameter("ERROR", typeof(int)); using (InomiEntities db = new InomiEntities()) { var resultvalue = db.Sp_UpdateCareer(career, maindescription, subdescription, course, reading, videos, online, returnId).FirstOrDefault(); result = (int)resultvalue; }; return(Json(result, JsonRequestBehavior.AllowGet)); }
public JsonResult AdminStatusRecord(selectedcollege customers) { number = int.Parse(Session["UserTypeId"].ToString()); if (customers != null) { using (InomiEntities entities = new InomiEntities()) { selectedcollege updatedCustomer = (from c in entities.selectedcolleges where c.id == customers.id select c).FirstOrDefault(); updatedCustomer.adminid = number; updatedCustomer.adminstatus = customers.Status; //entities.SaveChanges(); int insertedRecords = entities.SaveChanges(); return(Json(insertedRecords)); } } return(Json(0)); }
public static List <StudentDetails> GetStudentList() { List <StudentDetails> list = new List <StudentDetails>(); using (InomiEntities objInomiEntities = new InomiEntities()) { list = (from Stu in objInomiEntities.tblStudents select new Models.StudentDetails { FirstName = Stu.FirstName, Grade = Stu.Grade, School = Stu.School, Phone = Stu.Phone, Email = Stu.Email, Gender = Stu.Gender, Product = Stu.Product, Picture = Stu.Picture, Parent1Name = Stu.Parent1Name, Parent1Occupation = Stu.Parent1Occupation, Parent1Phone = Stu.Parent1Phone, Parent1Email = Stu.Parent1Email, Parent2Name = Stu.Parent2Name, Parent2Occupation = Stu.Parent2Occupation, Parent2Phone = Stu.Parent2Phone, Parent2Email = Stu.Parent2Email, CareerApplying = Stu.CareerApplying, CountryApplying = Stu.CountryApplying, ApplicationYear = Stu.ApplicationYear, FinacialAidNeeded = Stu.FinacialAidNeeded, Counsellor = Stu.Counsellor }).ToList(); } return(list); }