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());
}
}
}
}
