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