public void update_Valid_Detail() { Teacher teacherndata = new Teacher(db); TeacherController obj = new TeacherController(teacherndata); MarksDetails dummymarks = new MarksDetails() { Id = 1, CurrentYear = 1, Sem1 = 10, Sem2 = 10, Sem3 = 10, Sem4 = 10, Sem5 = 10, Sem6 = 10, Sem7 = 10, Sem8 = 10, TotalMaxMarks = 400, TotalObtainedMarks = 100, Percentage = 25 }; var data = obj.UpdateDetail(dummymarks); var okResult = data as OkObjectResult; Assert.AreEqual(200, okResult.StatusCode); }
public int AddDetail(BasicDetails data) { if (db != null) { db.BasicDetails.Add(data); db.SaveChanges(); MarksDetails marks = new MarksDetails() { Id = data.Id, CurrentYear = null, Sem1 = null, Sem2 = null, Sem3 = null, Sem4 = null, Sem5 = null, Sem6 = null, Sem7 = null, Sem8 = null, TotalMaxMarks = null, TotalObtainedMarks = null, Percentage = null }; LoginCredentials newuser = new LoginCredentials() { UserName = data.Email, Password = data.Phone, Role = "Student" }; db.MarksDetails.Add(marks); db.LoginCredentials.Add(newuser); db.SaveChanges(); return(data.Id); } return(0); }
public IActionResult UpdateDetail([FromBody] MarksDetails model) { _log4net.Info(" Http PUT request Started"); try { int val = adb.UpdateMarks(model); if (val == 1) { _log4net.Info(" Http PUT request Completed"); return(Ok(val)); } else { return(BadRequest()); } } catch (Exception ex) { if (ex.GetType().FullName == "Microsoft.EntityFrameworkCore.DbUpdateConcurrencyException") { return(NotFound()); } return(BadRequest()); } }
public int UpdateMarks([FromBody] MarksDetails model) { if (db != null) { db.MarksDetails.Update(model); db.SaveChanges(); return(1); } return(0); }
public async Task <IActionResult> UpdateMarks(int id) { MarksDetails detail = new MarksDetails(); using (var httpClient = new HttpClient()) { using (var response = await httpClient.GetAsync("https://localhost:44328/api/Teacher/GetMarks/" + id)) { string apiResponse = await response.Content.ReadAsStringAsync(); detail = JsonConvert.DeserializeObject <MarksDetails>(apiResponse); } } return(View(detail)); }
public async Task <IActionResult> Search(int id) { MarksDetails bdetail = new MarksDetails(); using (var httpClient = new HttpClient()) { using (var response = await httpClient.GetAsync("https://localhost:44328/api/Teacher/GetMarks/" + id)) { string apiResponse = await response.Content.ReadAsStringAsync(); bdetail = JsonConvert.DeserializeObject <MarksDetails>(apiResponse); } } _log4net.Info("Teacher:Search Request Completed"); return(View(bdetail)); }
public async Task <IActionResult> ViewMarks(int id) { MarksDetails list = new MarksDetails(); using (var httpClient = new HttpClient()) { using (var response = await httpClient.GetAsync("https://localhost:44307/api/Student/GetMarks/" + id)) { string apiResponse = await response.Content.ReadAsStringAsync(); list = JsonConvert.DeserializeObject <MarksDetails>(apiResponse); } } _log4net.Info("Student:Marks Viewed"); return(View(list)); }
public async System.Threading.Tasks.Task <List <MarksDetails> > GetMarksData(int id) { /* Model1 db = new Model1(); * var query = from s in db.Marks.Where(x=>x.StudentId==id) * select new { SubjectName = s.MASTER.SubjectName, MarkofSubject = s.MarkofSubject }; */ List <MarksDetails> query; using (var context = new Model1()) { SqlParameter param1 = new SqlParameter("@StuId", id); query = await context.Database.SqlQuery <MarksDetails>("StudentMarks @StuId", param1).ToListAsync(); } List <MarksDetails> dataList3 = new List <MarksDetails>(); foreach (var v in query) { MarksDetails marksDetails = new MarksDetails(); marksDetails.SubjectName = v.SubjectName.ToString(); marksDetails.MarkofSubject = v.MarkofSubject; dataList3.Add(marksDetails); } return(dataList3); }
public async Task <IActionResult> UpdateMarks(MarksDetails data) { BasicDetails receivedDetail = new BasicDetails(); using (var httpClient = new HttpClient()) { var newcontent = new StringContent(JsonConvert.SerializeObject(data), Encoding.UTF8, MediaTypeNames.Application.Json); using (var response = await httpClient.PutAsync("https://localhost:44328/api/Teacher/UpdateDetail/", newcontent)) { if (response.IsSuccessStatusCode) { ViewBag.result = "Record Updated Successfully!"; _log4net.Info("Teacher:Marks Updated of ID: " + data.Id); return(View()); } else { ViewBag.result = "Error in Updating Records Try Again!"; return(View()); } } } }