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 List <Employee> FindAll()
{
using (var context = new SMContext())
{
return(context.Employee.OrderByDescending(x => x.Id).ToList());
}
}
public Employee FindById(int _id)
{
using (var context = new SMContext())
{
return(context.Employee.FirstOrDefault(x => (x.Id == _id)));
}
}
private void CreateService()
{
var builder = new DbContextOptionsBuilder <SMContext>().UseSqlServer("Server=.\\SQLEXPRESS;Database=MariaDB;Trusted_Connection=True;");
_SMContext = new SMContext(builder.Options);
_ICampaign = new DeleteCompaign(_SMContext);
}
public List <Department> FindAll()
{
using (var context = new SMContext())
{
return(context.Department.OrderByDescending(x => x.Id).ToList());
}
}
public Department FindById(int _id)
{
using (var context = new SMContext())
{
return(context.Department.FirstOrDefault(x => (x.Id == _id)));
}
}
public static string GetSequence(SMContext db, int _nextVal = 0)
{
var nextVal = "0";
if (_nextVal != 0)
{
nextVal = _nextVal.ToString();
}
else
{
using (var command = db.Database.Connection.CreateCommand())
{
command.CommandText = "SELECT NEXT VALUE FOR numeroPedido";
db.Database.Connection.Open();
using (var result = command.ExecuteReader())
{
while (result.Read())
{
nextVal = result[0].ToString();
}
}
}
}
return(nextVal);
}
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())));
}
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IHostingEnvironment env, SMContext db)
{
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
}
DbInitializer.Initialize(db);
app.Run(async(context) =>
{
await context.Response.WriteAsync("Hello World!");
});
}
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 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 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 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 static DatabaseService.Models.RefreshToken GetRefreshToken(string HashedToken)
{
try{
using (var ctx = new SMContext())
{
var refreshToken = from rft in ctx.RefreshTokens
where rft.token == HashedToken
select new DatabaseService.Models.RefreshToken { Token = rft.token, Username = rft.username, ClientId = rft.client_id, IssuedUtc = rft.issued_on, ExpiresUtc = rft.expires_on, ProtectedTicket = rft.protected_ticket };
return refreshToken.FirstOrDefault();
}
}
catch (Exception ex)
{
BaseClass.logger.Error("Database Query GetRefreshToken: ",ex);
return null;
}
}
public static DatabaseService.Models.Client GetClient(int ClientId)
{
try{
using (var ctx = new SMContext())
{
var client = from c in ctx.Clients
where c.client_id == ClientId && c.active
select new DatabaseService.Models.Client {
Id = c.client_id, Secret = c.client_secret, Name = c.name, Active = c.active, RefreshTokenLifeTime = c.refresh_token_life_time, AllowedOrigin = c.allowed_origin
};
return(client.FirstOrDefault());
}
}
catch (Exception ex)
{
BaseClass.logger.Error("Database Query GetClient: ", ex);
return(null);
}
}
public static DatabaseService.Models.RefreshToken GetRefreshToken(string HashedToken)
{
try{
using (var ctx = new SMContext())
{
var refreshToken = from rft in ctx.RefreshTokens
where rft.token == HashedToken
select new DatabaseService.Models.RefreshToken {
Token = rft.token, Username = rft.username, ClientId = rft.client_id, IssuedUtc = rft.issued_on, ExpiresUtc = rft.expires_on, ProtectedTicket = rft.protected_ticket
};
return(refreshToken.FirstOrDefault());
}
}
catch (Exception ex)
{
BaseClass.logger.Error("Database Query GetRefreshToken: ", ex);
return(null);
}
}
public static DatabaseService.Models.User AuthenticateUser(string username)
{
try
{
using (var ctx = new SMContext())
{
var user = from u in ctx.Users
join r in ctx.Roles on u.role_id equals r.role_id
where u.username == username && u.status == 1
select new DatabaseService.Models.User { Id = u.user_id, Username = u.username, Photo = string.IsNullOrEmpty(u.photo) ? "DefaultPic.jpg" : u.photo, RoleName = r.role, Email = u.email, HashedPassword = u.password, Name = u.name, Active = u.status };
return user.FirstOrDefault();
}
}
catch (Exception ex)
{
BaseClass.logger.Error("Database Query AuthenticateUser: ", ex);
return null;
}
}
public static DatabaseService.Models.User AuthenticateUser(string username)
{
try
{
using (var ctx = new SMContext())
{
var user = from u in ctx.Users
join r in ctx.Roles on u.role_id equals r.role_id
where u.username == username && u.status == 1
select new DatabaseService.Models.User {
Id = u.user_id, Username = u.username, Photo = string.IsNullOrEmpty(u.photo) ? "DefaultPic.jpg" : u.photo, RoleName = r.role, Email = u.email, HashedPassword = u.password, Name = u.name, Active = u.status
};
return(user.FirstOrDefault());
}
}
catch (Exception ex)
{
BaseClass.logger.Error("Database Query AuthenticateUser: ", ex);
return(null);
}
}
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 ProductCategoryRepository(SMContext dbContext) : base(dbContext)
{
_context = dbContext;
}
public shopDeliveriesController(SMContext context)
{
_context = context;
}
public WarehousesController(SMContext context)
{
_context = context;
}
public Repstoriy(SMContext context)
{
_context = context;
}
public HistoryCompaignController(IHistoryCompaign iHistoryCampaign, IExportExcel iExportExcel, SMContext sMContext)
{
_IHistoryCampaign = iHistoryCampaign;
_IExportExcel = iExportExcel;
_SMContext = sMContext;
}
public shopTransfersController(SMContext context)
{
_context = context;
}
public shopReturnsController(SMContext context)
{
_context = context;
}
public UserRegister(SMContext sMContext)
{
_SMContext = sMContext;
}
public DeleteCompaign(SMContext sMContext)
{
_SMContext = sMContext;
}
public WarehouseTransfersController(SMContext context)
{
_context = context;
}
public SemesterRepository(SMContext smContext)
{
_smContext = smContext;
}
public SeasonsController(SMContext context)
{
_context = context;
}
