public IHttpActionResult Get(string id) { var item = context.Tbl_PreStudent.Where(p => p.StudentID == id).FirstOrDefault(); if (item == null) { return(StatusCode(HttpStatusCode.NoContent)); } else { Tbl_PreStudent cat = new Tbl_PreStudent(); cat.ConfrimID = item.ConfrimID; cat.StudentID = item.StudentID; cat.FirstName = item.FirstName; cat.LastName = item.LastName; cat.BirthDate = item.BirthDate; cat.DepartmentID = item.DepartmentID; cat.FatherName = item.FatherName; cat.MotherName = item.MotherName; cat.PresentAddress = item.PresentAddress; cat.PermanentAddress = item.PermanentAddress; cat.Phone = item.Phone; cat.Email = item.Email; cat.Sex = item.Sex; cat.Nationality = item.Nationality; cat.Religion = item.Religion; cat.MaritalStatus = item.MaritalStatus; cat.BloodGroup = item.BloodGroup; cat.AdmissionDate = item.AdmissionDate; cat.GraduationDate = item.GraduationDate; cat.PerSemesterRecordID = item.PerSemesterRecordID; cat.DocumentsGiven = item.DocumentsGiven; cat.Password = item.Password; cat.Picture = item.Picture; cat.Type = item.Type; cat.links.Add(new Links() { HRef = "http://localhost:57254/api/Posts", Method = "GET", Rel = "Self" }); cat.links.Add(new Links() { HRef = "http://localhost:57254/api/Posts/" + cat.StudentID, Method = "GET", Rel = "Specific Resource" }); cat.links.Add(new Links() { HRef = "http://localhost:57254/api/Posts/" + cat.StudentID, Method = "PUT", Rel = "Resource Edit" }); cat.links.Add(new Links() { HRef = "http://localhost:57254/api/Posts/" + cat.StudentID, Method = "DELETE", Rel = "Resource Delete" }); cat.links.Add(new Links() { HRef = "http://localhost:57254/api/Posts", Method = "POST", Rel = "Resource Create" }); return(Ok(cat)); } }
public IHttpActionResult Get() { var list = context.Tbl_PreStudent.ToList(); List <Tbl_PreStudent> categories = new List <Tbl_PreStudent>(); foreach (var item in list) { Tbl_PreStudent cat = new Tbl_PreStudent(); cat.ConfrimID = item.ConfrimID; cat.StudentID = item.StudentID; cat.FirstName = item.FirstName; cat.LastName = item.LastName; cat.BirthDate = item.BirthDate; cat.DepartmentID = item.DepartmentID; cat.FatherName = item.FatherName; cat.MotherName = item.MotherName; cat.PresentAddress = item.PresentAddress; cat.PermanentAddress = item.PermanentAddress; cat.Phone = item.Phone; cat.Email = item.Email; cat.Sex = item.Sex; cat.Nationality = item.Nationality; cat.Religion = item.Religion; cat.MaritalStatus = item.MaritalStatus; cat.BloodGroup = item.BloodGroup; cat.AdmissionDate = item.AdmissionDate; cat.GraduationDate = item.GraduationDate; cat.PerSemesterRecordID = item.PerSemesterRecordID; cat.DocumentsGiven = item.DocumentsGiven; cat.Password = item.Password; cat.Picture = item.Picture; cat.Type = item.Type; cat.links.Add(new Links() { HRef = "http://localhost:57254/api/Posts", Method = "GET", Rel = "Self" }); cat.links.Add(new Links() { HRef = "http://localhost:57254/api/Posts/" + cat.StudentID, Method = "GET", Rel = "Specific Resource" }); cat.links.Add(new Links() { HRef = "http://localhost:57254/api/Posts/" + cat.StudentID, Method = "PUT", Rel = "Resource Edit" }); cat.links.Add(new Links() { HRef = "http://localhost:57254/api/Posts/" + cat.StudentID, Method = "DELETE", Rel = "Resource Delete" }); cat.links.Add(new Links() { HRef = "http://localhost:57254/api/Posts", Method = "POST", Rel = "Resource Create" }); categories.Add(cat); } return(Ok(categories)); }
public IHttpActionResult Post([FromBody] Tbl_PreStudent pre) { var item = context.Tbl_PreStudent.Where(x => x.StudentID == pre.StudentID).FirstOrDefault(); Tbl_Student cat = new Tbl_Student(); cat.StudentID = item.StudentID; cat.FirstName = item.FirstName; cat.LastName = item.LastName; cat.BirthDate = item.BirthDate; cat.DepartmentID = item.DepartmentID; cat.FatherName = item.FatherName; cat.MotherName = item.MotherName; cat.PresentAddress = item.PresentAddress; cat.PermanentAddress = item.PermanentAddress; cat.Phone = item.Phone; cat.Email = item.Email; cat.Sex = item.Sex; cat.Nationality = item.Nationality; cat.Religion = item.Religion; cat.MaritalStatus = item.MaritalStatus; cat.BloodGroup = item.BloodGroup; cat.AdmissionDate = item.AdmissionDate; cat.GraduationDate = item.GraduationDate; cat.PerSemesterRecordID = item.PerSemesterRecordID; cat.DocumentsGiven = item.DocumentsGiven; cat.Password = item.Password; cat.Picture = item.Picture; cat.Type = item.Type; Tbl_Accounts1 ac = new Tbl_Accounts1(); ac.UserID = pre.StudentID; ac.Password = item.Password; ac.Type = item.Type; context.Tbl_Student.Add(cat); context.Tbl_Accounts1.Add(ac); context.Tbl_PreStudent.Remove(item); context.SaveChanges(); return(Created(Url.Link("GetStudentById", new { id = cat.StudentID }), cat)); }
public ActionResult StudentRegister(Tbl_PreStudent tbl, Tbl_Accounts1 tbl1, HttpPostedFileBase file) { string pic = null; if (file != null) { pic = System.IO.Path.GetFileName(file.FileName); string path = System.IO.Path.Combine(Server.MapPath("~/StudentImage/"), pic); file.SaveAs(path); } tbl.Picture = pic; _unitOfWork.GetRepositoryInstance <Tbl_PreStudent>().Add(tbl); /* tbl1.Email = tbl1.Email; * tbl1.Password = tbl.Password; * tbl1.Type = tbl.Type; * tbl1.UserID = tbl.StudentID; * _unitOfWork.GetRepositoryInstance<Tbl_Accounts>().Add(tbl1);*/ return(RedirectToAction("Index")); }
public ActionResult ConfirmStudent(int id, Tbl_Student tbl, Tbl_PreStudent tbl1, Tbl_Accounts1 tbl2) { Tbl_PreStudent k = _unitOfWork.GetRepositoryInstance <Tbl_PreStudent>().GetAllRecordsIQueryable().Where(x => x.ConfrimID == id).FirstOrDefault(); tbl.StudentID = k.StudentID; tbl.FatherName = k.FatherName; tbl.FirstName = k.FirstName; tbl.LastName = k.LastName; tbl.MotherName = k.MotherName; tbl.GraduationDate = k.GraduationDate; tbl.MaritalStatus = k.MaritalStatus; tbl.Nationality = k.Nationality; tbl.Password = k.Password; tbl.PresentAddress = k.PresentAddress; tbl.PermanentAddress = k.PermanentAddress; tbl.Phone = k.Phone; tbl.Picture = k.Picture; tbl.Religion = k.Religion; tbl.Sex = k.Sex; tbl.Email = k.Email; tbl.DocumentsGiven = k.DocumentsGiven; tbl.DepartmentID = k.DepartmentID; tbl.BloodGroup = k.BloodGroup; tbl.BirthDate = k.BirthDate; tbl.Type = k.Type; tbl.AdmissionDate = k.AdmissionDate; tbl.PerSemesterRecordID = k.PerSemesterRecordID; _unitOfWork.GetRepositoryInstance <Tbl_Student>().Add(tbl); _unitOfWork.GetRepositoryInstance <Tbl_PreStudent>().Remove(k); tbl2.Status = "Active"; tbl2.Password = tbl.Password; tbl2.Type = tbl.Type; tbl2.UserID = tbl.StudentID; _unitOfWork.GetRepositoryInstance <Tbl_Accounts1>().Add(tbl2); return(RedirectToAction("StudentRegistrationConfirm")); }
public IHttpActionResult Put([FromUri] string id, [FromBody] Tbl_PreStudent item) { var cat = context.Tbl_PreStudent.Where(p => p.StudentID == id).FirstOrDefault(); if (cat == null) { return(StatusCode(HttpStatusCode.NoContent)); } else { cat.ConfrimID = item.ConfrimID; cat.StudentID = item.StudentID; cat.FirstName = item.FirstName; cat.LastName = item.LastName; cat.BirthDate = item.BirthDate; cat.DepartmentID = item.DepartmentID; cat.FatherName = item.FatherName; cat.MotherName = item.MotherName; cat.PresentAddress = item.PresentAddress; cat.PermanentAddress = item.PermanentAddress; cat.Phone = item.Phone; cat.Email = item.Email; cat.Sex = item.Sex; cat.Nationality = item.Nationality; cat.Religion = item.Religion; cat.MaritalStatus = item.MaritalStatus; cat.BloodGroup = item.BloodGroup; cat.AdmissionDate = item.AdmissionDate; cat.GraduationDate = item.GraduationDate; cat.PerSemesterRecordID = item.PerSemesterRecordID; cat.DocumentsGiven = item.DocumentsGiven; cat.Password = item.Password; cat.Picture = item.Picture; cat.Type = item.Type; return(Ok(item)); } }
public ActionResult StudentDetails(int id) { Tbl_PreStudent k = _unitOfWork.GetRepositoryInstance <Tbl_PreStudent>().GetAllRecordsIQueryable().Where(x => x.ConfrimID == id).FirstOrDefault(); return(View(k)); }
public IHttpActionResult Post([FromBody] Tbl_PreStudent preStudent) { context.Tbl_PreStudent.Add(preStudent); context.SaveChanges(); return(Created(Url.Link("GetPreStudentById", new { id = preStudent.StudentID }), preStudent)); }