public void CreateGoLeave(int ID, string text, string pathAvatar, string pathPlate, string pathFull) { try { using (var context = new admin_dangkythitoeicEntities()) { var old = context.GoLeaves .OrderByDescending(p => p.GoDT) .First(); if (DateTime.Now.Subtract(old.GoDT.Value).Seconds > 4) { GoLeave goLeave = new GoLeave { GoAvatar = pathAvatar, GoDT = DateTime.Now, GoFull = pathFull, GoPlate = pathPlate, GoOCR = text, OwnerID = ID }; context.GoLeaves.Add(goLeave); context.SaveChanges(); } } } catch { } }
public string Getname(int ID) { using (var context = new admin_dangkythitoeicEntities()) { return(""); } }
public void CreateMember(string text, string pathAvatar, string pathPlate, string pathFull) { using (var context = new admin_dangkythitoeicEntities()) { Member member = new Member { CreateDT = DateTime.Now, UpdateDT = DateTime.Now, Address = "", UniversityID = 0, IsDeleted = false, }; context.Members.Add(member); GoLeave goLeave = new GoLeave { GoAvatar = pathAvatar, GoDT = DateTime.Now, GoFull = pathFull, GoPlate = pathPlate, GoOCR = text, OwnerID = member.ID }; context.GoLeaves.Add(goLeave); context.SaveChanges(); } }
public LeaveError CheckGoLeave(int ID, string text, string pathAvatar, string pathPlate, string pathFull) { try { using (var context = new admin_dangkythitoeicEntities()) { var single = context.GoLeaves.Where(p => p.OwnerID == ID && !p.IsFinish).OrderByDescending(p => p.GoDT).FirstOrDefault(); if (single != null) { if (single.GoOCR == text) { single.leaveAvatar = pathAvatar; single.LeaveDT = DateTime.Now; single.LeaveFull = pathFull; single.LeavePlate = pathPlate; single.OutOCR = text; single.IsFinish = true; context.Entry(single).State = EntityState.Modified; context.SaveChanges(); return(LeaveError.SUCCESSS); } else { return(LeaveError.WRONGOCG); } } else { return(LeaveError.NOTFOUND); } } } catch { } return(LeaveError.UNKNWON); }
public void CreateReason(string goText, string leaveText, string goPathAvatar, string leavePathAvatar, string goPathPlate, string leavePathPlate, string goPathFull, string leavePathFull) { using (var context = new admin_dangkythitoeicEntities()) { Member member = new Member { CreateDT = DateTime.Now, UpdateDT = DateTime.Now, Address = "", UniversityID = 0, IsDeleted = false, }; context.Members.Add(member); GoLeave goLeave = new GoLeave { GoAvatar = goPathAvatar, GoDT = DateTime.Now, GoFull = goPathFull, GoPlate = goPathPlate, GoOCR = goPathPlate, LeavePlate = leavePathPlate, leaveAvatar = leavePathAvatar, LeaveDT = DateTime.Now, LeaveFull = leavePathFull, IsFinish = true, OutOCR = leaveText, OwnerID = member.ID, }; context.GoLeaves.Add(goLeave); context.SaveChanges(); } }
public int GetCountGoOut() { using (var context = new admin_dangkythitoeicEntities()) { var count = context.GoLeaves.Where(p => p.GoDT.Value.Day == DateTime.Now.Day) .Where(p => p.GoDT.Value.Month == DateTime.Now.Month) .Where(p => p.GoDT.Value.Year == DateTime.Now.Year) .Count(); count = count != null ? count:0; return(count); } }
public void LoadTraningFace(out List <string> listString, out List <int> listInt) { listString = new List <string>(); listInt = new List <int>(); using (var context = new admin_dangkythitoeicEntities()) { try { var db = context.GoLeaves.ToList(); foreach (var item in db) { listString.Add(item.GoAvatar); listInt.Add(Convert.ToInt32(item.OwnerID)); } } catch { } } }
public bool CheckOCR(int ID, string text, string pathAvatar, string pathPlate, string pathFull) { using (var context = new admin_dangkythitoeicEntities()) { var single = context.GoLeaves.Where(p => p.OwnerID == ID).OrderByDescending(p => p.GoDT).Single(); if (single != null) { if (single.GoOCR == text) { single.LeaveDT = DateTime.Now; single.LeaveFull = pathFull; single.LeavePlate = pathPlate; single.leaveAvatar = pathAvatar; single.OutOCR = text; context.SaveChangesAsync(); return(true); } } return(false); } }