Beispiel #1
0
 public bool UpdateBaseInformation(tbl_Visitor_Infor visitor, string nationalIdOld, string employee)
 {
     try
     {
         var visitorUpdate = db.tbl_Visitor_Infor.FirstOrDefault(x => x.Request_Infor_Id == visitor.Request_Infor_Id && x.NationalId == visitor.NationalId);
         if (visitorUpdate == null)
         {
             var visitorOld = db.tbl_Visitor_Infor.FirstOrDefault(x => x.Request_Infor_Id == visitor.Request_Infor_Id && x.NationalId == nationalIdOld);
             db.tbl_Visitor_Infor.Remove(visitorOld);
             db.tbl_Visitor_Infor.Add(visitor);
         }
         else
         {
             visitorUpdate.VisitorName = visitor.VisitorName;
             visitorUpdate.CompanyName = visitor.CompanyName;
             visitorUpdate.NationalId  = visitor.NationalId;
             visitorUpdate.Remark      = visitor.Remark;
             visitorUpdate.UpdateDate  = DateTime.Now;
             visitorUpdate.UpdateBy    = employee;
         }
         db.SaveChanges();
         return(true);
     }
     catch (Exception ex)
     {
         WriteLogError.Write("UpdateBaseInformation", ex.ToString());
         return(false);
     }
 }
Beispiel #2
0
 public bool InsertOrUpdateVisitorInfor(tbl_Visitor_Infor visitor)
 {
     try
     {
         var checkExists = db.tbl_Visitor_Infor.FirstOrDefault(x => x.Request_Infor_Id == visitor.Request_Infor_Id && x.NationalId == visitor.NationalId);
         if (checkExists == null)
         {
             db.tbl_Visitor_Infor.Add(visitor);
         }
         else
         {
             checkExists.Badge    = visitor.Badge;
             checkExists.Access   = visitor.Access;
             checkExists.Tem      = visitor.Tem;
             checkExists.MealCard = visitor.MealCard;
             if (visitor.EntryTime != null) // update when exit
             {
                 checkExists.EntryTime = visitor.EntryTime;
             }
             checkExists.ExitTime   = visitor.ExitTime;
             checkExists.Package    = visitor.Package;
             checkExists.EscorterId = visitor.EscorterId;
             if (visitor.Remark != null && visitor.Remark != "")
             {
                 checkExists.Remark = visitor.Remark;
             }
             checkExists.UpdateDate     = visitor.UpdateDate;
             checkExists.UpdateBy       = visitor.UpdateBy;
             checkExists.BadgeReturn    = visitor.BadgeReturn;
             checkExists.AccessReturn   = visitor.AccessReturn;
             checkExists.MealCardReturn = visitor.MealCardReturn;
             // Update
         }
         db.SaveChanges();
         return(true);
     }
     catch (Exception ex)
     {
         WriteLogError.Write("InsertOrUpdateVisitorInfor", ex.ToString());
         return(false);
     }
 }