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 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 void Delete(T t)
{
_context.Set <T>().Remove(t);
_context.SaveChanges();
}
