public static void SaveRefreshToken(dynamic inputs) { try { RefreshToken rft = new RefreshToken(); rft.token = inputs.HashedToken; rft.username = inputs.Username; rft.client_id = inputs.ClientId; rft.expires_on = inputs.ExpiresUtc; rft.issued_on = inputs.IssuedUtc; rft.protected_ticket = inputs.ProtectedTicket; using (var ctx = new SMContext()) { ctx.RefreshTokens.Add(rft); ctx.SaveChanges(); } } catch (Exception ex) { BaseClass.logger.Error("Database Query SaveRefreshToken: ", ex); } }
public int Register(Compaign campaign) { campaign.DateCreated = DateTime.Now; _SMContext.Compaigns.Add(campaign); var data = _SMContext.SaveChanges(); return(data); }
public Department AddDepartment(Department _dep) { using (var context = new SMContext()) { context.Department.Add(_dep); context.SaveChanges(); return(context.Department.FirstOrDefault( x => (x.Name.ToLower() == _dep.Name.ToLower()))); } }
public void RemoveDepartment(int _id) { using (var context = new SMContext()) { Department dpt = context.Department.FirstOrDefault(x => (x.Id == _id)); if (dpt != null) { context.Department.Remove(dpt); context.SaveChanges(); } } }
public void RemoveEmployee(int _id) { using (var context = new SMContext()) { Employee tEmp = context.Employee.FirstOrDefault(x => (x.Id == _id)); if (tEmp != null) { context.Employee.Remove(tEmp); context.SaveChanges(); } } }
public Department UpdateDepartment(int _id, Department _dep) { using (var context = new SMContext()) { var tDep = context.Department.FirstOrDefault(x => (x.Id == _id)); tDep = _dep; tDep.Id = _id; context.Department.Add(tDep); context.SaveChanges(); return(context.Department.FirstOrDefault(x => (x.Name.ToLower() == _dep.Name.ToLower()))); } }
public Employee AddEmployee(Employee _emp) { using (var context = new SMContext()) { context.Employee.Add(_emp); context.SaveChanges(); return(context.Employee.FirstOrDefault( x => (x.Firstname.ToLower() == _emp.Firstname.ToLower() && x.LastName.ToLower() == _emp.LastName.ToLower() ))); } }
public int Delete(Compaign campaign) { var item = _SMContext.Compaigns.Where(x => x.IdCompaign == campaign.IdCompaign).FirstOrDefault(); if (item != null) { item.Status = false; _SMContext.Compaigns.Update(item); var data = _SMContext.SaveChanges(); return(data); } else { return(0); } }
public Employee UpdateEmployee(int _id, Employee _emp) { using (var context = new SMContext()) { var tEmp = context.Employee.FirstOrDefault(x => (x.Id == _id)); tEmp = _emp; tEmp.Id = _id; context.Employee.Add(tEmp); context.SaveChanges(); return(context.Employee.FirstOrDefault( x => (x.Firstname.ToLower() == _emp.Firstname.ToLower() && x.LastName.ToLower() == _emp.LastName.ToLower() ))); } }
public static void DeleteRefreshToken(string HashedToken) { RefreshToken tokenToDelete; using (var ctx = new SMContext()) { tokenToDelete = ctx.RefreshTokens.Where(s => s.token == HashedToken).FirstOrDefault <RefreshToken>(); } //Create new context for disconnected scenario using (var newContext = new SMContext()) { newContext.Entry(tokenToDelete).State = System.Data.Entity.EntityState.Deleted; newContext.SaveChanges(); } }
public static void DeleteRefreshToken(string HashedToken) { RefreshToken tokenToDelete; using (var ctx = new SMContext()) { tokenToDelete = ctx.RefreshTokens.Where(s => s.token == HashedToken).FirstOrDefault<RefreshToken>(); } //Create new context for disconnected scenario using (var newContext = new SMContext()) { newContext.Entry(tokenToDelete).State = System.Data.Entity.EntityState.Deleted; newContext.SaveChanges(); } }
public int Register(User user) { var keyHash = "keyTest"; string IdUserEncrypt = SecurityMD5.Encrypt(user.Email, keyHash, true); user.IdUser = IdUserEncrypt; var userExist = _SMContext.Users.Where(x => x.IdUser == IdUserEncrypt).FirstOrDefault(); if (userExist == null) { user.Password = SecurityMD5.Encrypt(user.Password, keyHash, true); user.DateCreated = DateTime.Now; _SMContext.Users.Add(user); var data = _SMContext.SaveChanges(); return(data); } else { throw new Exception("Usuario ya existe"); } }
public void Delete(T t) { _context.Set <T>().Remove(t); _context.SaveChanges(); }