public IActionResult Update(ClientRequest req)
{
Response oResponse = new Response();
try
{
using (Sales_DBContext db = new Sales_DBContext())
{
Client oClient = db.Clients.Find(req.Id);
oClient.Name = req.Name;
oClient.Ci = req.Ci;
oClient.Number = req.Number;
oClient.Address = req.Address;
oClient.Email = req.Email;
oClient.City = req.City;
db.Entry(oClient).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
db.SaveChanges();
oResponse.Success = 1;
}
}
catch (Exception ex)
{
oResponse.Message = ex.Message;
}
return(Ok(oResponse));
}
public IActionResult Add(ClientRequest req)
{
Response oResponse = new Response();
try
{
using (Sales_DBContext db = new Sales_DBContext())
{
Client oClient = new Client();
oClient.Name = req.Name;
oClient.Ci = req.Ci;
oClient.Number = req.Number;
oClient.Address = req.Address;
oClient.Email = req.Email;
oClient.City = req.City;
db.Clients.Add(oClient);
db.SaveChanges();
oResponse.Success = 1;
}
}
catch (Exception ex)
{
oResponse.Message = ex.Message;
}
return(Ok(oResponse));
}
public IActionResult Add(SaleRequest req)
{
Response response = new Response();
try
{
using (Sales_DBContext db = new Sales_DBContext())
{
using (var transaction = db.Database.BeginTransaction())
{
try
{
Sale sale = new Sale();
sale.Total = req.Concepts.Sum(d => d.Amount * d.UnitPrice);
sale.Date = DateTime.Now;
sale.IdCliente = req.IdClient;
db.Add(sale);
db.SaveChanges();
foreach (var concept in req.Concepts)
{
Concept concept1 = new Concept
{
Amount = concept.Amount,
IdProduct = concept.IdProduct,
UnitPrice = concept.UnitPrice,
Imports = concept.Imports,
IdSale = sale.Id
};
db.Add(concept1);
db.SaveChanges();
}
transaction.Commit();
response.Success = 1;
}
catch (Exception ex)
{
transaction.Rollback();
}
}
}
}
catch (Exception ex)
{
response.Message = ex.Message;
}
return(Ok(response));
}
public IActionResult Get()
{
Response oResponse = new Response();
try
{
using (Sales_DBContext db = new Sales_DBContext())
{
var list = db.Clients.OrderBy(d => d.Id).ToList();
oResponse.Data = list;
oResponse.Success = 1;
}
}
catch (Exception ex)
{
oResponse.Message = ex.Message;
}
return(Ok(oResponse));
}
public IActionResult Delete(int id)
{
Response oResponse = new Response();
try
{
using (Sales_DBContext db = new Sales_DBContext())
{
Client oClient = db.Clients.Find(id);
db.Remove(oClient);
db.SaveChanges();
oResponse.Success = 1;
}
}
catch (Exception ex)
{
oResponse.Message = ex.Message;
}
return(Ok(oResponse));
}
public UserResponse Auth(AuthRequest req)
{
UserResponse userResponse = new UserResponse();
using (var db = new Sales_DBContext())
{
string spassword = Encrypt.GetSHA256(req.Password);
var user = db.Users.Where(d => d.Email == req.Email &&
d.Password == spassword).FirstOrDefault();
if (user == null)
{
return(null);
}
userResponse.Email = user.Email;
userResponse.Token = GetToken(user);
}
return(userResponse);
}