public void addFace(User user)
{
try
{
using (var entities = new FaceDBEntities())
{
var entity = new EMUser().saveToDB(user);
entities.Users.Add(entity);
var count = entities.SaveChanges();
if (count > 0)
{
var userID = lastID();
foreach (var image in user.ImageList)
{
image.UserID = userID;
entities.UserImages.Add(new EMUser().saveToDB(image));
}
entities.SaveChanges();
}
}
}
catch (Exception e)
{
throw e;
}
}
public int lastID()
{
int count = 0;
using (var entities = new FaceDBEntities())
{
count = entities.Users.OrderByDescending(o => o.UserID).First().UserID;
}
return(count);
}
public List <User> getAllUsers()
{
using (var entities = new FaceDBEntities())
{
var query = from user in entities.Users
select new { user };
var result =
(from o in query select new User()
{
UserID = o.user.UserID, FullName = o.user.FullName
})
.ToList <User>();
return(result);
}
}
public async Task <TaxResponse> GetTax(TaxJarRequest taxJarRequest)
{
try
{
taxResponse = new TaxResponse();
using (FaceDBEntities db = new FaceDBEntities())
{
var client = new TaxjarApi(ApplicationConfiguration.TAX_JAR_ACCESS_KEY);
if (!string.IsNullOrEmpty(taxJarRequest.UserEmail))
{
var systemUser = await db.system_user.Where(x => x.email == taxJarRequest.UserEmail && x.Blocked == "N").FirstOrDefaultAsync();
if (systemUser.id > 0)
{
//var rates = client.RatesForLocation(systemUser.ZipCode.ToString(), new { });
var tax = client.TaxForOrder(new
{
from_zip = systemUser.ZipCode.ToString()
});
taxResponse.combined_rate = tax.Rate;
}
else
{
taxResponse.Success = false;
taxResponse.Message = CustomErrorMessages.INVALID_EMAIL;
}
}
else
{
taxResponse.Success = false;
taxResponse.Message = CustomErrorMessages.INVALID_INPUTS;
}
taxResponse.Success = true;
taxResponse.Message = null;
}
}
catch (Exception ex)
{
Elmah.ErrorSignal.FromCurrentContext().Raise(ex);
taxResponse.Success = false;
taxResponse.Message = CustomErrorMessages.INTERNAL_ERROR;
}
return(taxResponse);
}
public List <User> fetechImage()
{
using (var entities = new FaceDBEntities())
{
var query = from user in entities.Users
join img in entities.UserImages on user.UserID equals img.UserID
select new { user, img };
var result = (from o in query
select new User()
{
UserID = o.user.UserID,
FullName = o.user.FullName,
Image = o.img.Images
}).ToList <User>();
return(result);
}
}
