public JsonResult Save(Tbl_AttandanceMid record)
{
Tbl_AttandanceMid entity;
using (DIUBDatabaseEntities8 context = new DIUBDatabaseEntities8())
{
if (record.AttandanceID > 0)
{
entity = context.Tbl_AttandanceMid.First(p => p.AttandanceID == record.AttandanceID);
entity.StudentID = record.StudentID;
entity.StudentName = record.StudentName;
entity.Day1 = record.Day1;
entity.Day2 = record.Day2;
entity.Day3 = record.Day3;
entity.Day4 = record.Day4;
entity.Day5 = record.Day5;
entity.Day6 = record.Day6;
entity.Day7 = record.Day7;
entity.Day8 = record.Day8;
entity.Day9 = record.Day9;
entity.Day10 = record.Day10;
entity.Day11 = record.Day11;
entity.Day12 = record.Day12;
entity.TotalAttandanceMid = record.TotalAttandanceMid;
}
context.SaveChanges();
}
return(Json(new { result = true }));
}
public JsonResult Get(int?page, int?limit, string sortBy, string direction, string name, string nationality, string placeOfBirth)
{
List <Tbl_AttandanceMid> records;
int total;
using (DIUBDatabaseEntities8 context = new DIUBDatabaseEntities8())
{
var query = context.Tbl_AttandanceMid.Select(p => new Tbl_AttandanceMid
{
StudentID = p.StudentID,
StudentName = p.StudentName,
Day1 = p.Day1,
Day2 = p.Day2,
Day3 = p.Day3,
Day4 = p.Day4,
Day5 = p.Day5,
Day6 = p.Day6,
Day7 = p.Day7,
Day8 = p.Day8,
Day9 = p.Day9,
Day10 = p.Day10,
Day11 = p.Day11,
Day12 = p.Day12,
TotalAttandanceMid = p.TotalAttandanceMid
});
total = query.Count();
if (page.HasValue && limit.HasValue)
{
int start = (page.Value - 1) * limit.Value;
records = query.Skip(start).Take(limit.Value).ToList();
}
else
{
records = query.ToList();
}
}
return(this.Json(new { records, total }, JsonRequestBehavior.AllowGet));
}
public GenericRepository(DIUBDatabaseEntities8 DBEntity)
{
_DBEntity = DBEntity;
_dbSet = _DBEntity.Set <Tbl_Entity>();
}
