public static IEnumerable <ShowableUser> GetAllUsers()
{
using (var db = new BarProjectEntities())
{
return(db.Users.Select(x => x).ToAnotherType <User, ShowableUser>().ToList());//.ToShowableUsers().ToList();
}
}
public static void AddUser(string password, string username, string name, string surname, byte permission)
{
using (var db = new BarProjectEntities())
{
db.addUser(password, username, name, surname, permission);
}
}
public static IEnumerable <ShowableSimpleProduct> GetProductView()
{
using (var db = new BarProjectEntities())
{
return(db.productSimples.ToAnotherType <productSimple, ShowableSimpleProduct>().ToList());
}
}
public static string AddCategory(ShowableCategory cat)
{
try
{
using (var db = new BarProjectEntities())
{
int?overriding = null;
if (cat.Overriding != "")
{
var q = db.Categories.Where(x => x.category_name == cat.Overriding).Select(x => x).FirstOrDefault();
if (q != null)
{
overriding = q.id;
}
}
db.addCategory(cat.Name, cat.Slug, overriding);
}
}
catch (Exception ex)
{
var message = ex.Message;
if (ex.InnerException != null)
{
message += "\nInner:" + ex.InnerException.Message;
}
return(message);
}
return("");
}
public static string AddUnit(ShowableUnit unit)
{
try
{
using (var db = new BarProjectEntities())
{
var q = db.UnitTypes.FirstOrDefault(x => x.type_name == unit.Type);
if (q != null)
{
db.addUnit(unit.Name, unit.Factor, q.id);
}
else
{
throw new ArgumentException("Problem with type name!");
}
}
}
catch (Exception ex)
{
var message = ex.Message;
if (ex.InnerException != null)
{
message += "\nInner:" + ex.InnerException.Message;
}
return(message);
}
return("");
}
public static List <string> GetTypes()
{
using (var db = new BarProjectEntities())
{
return(db.UnitTypes.Select(x => x.type_name).ToList());
}
}
public static List <ShowableUnit> GetAllUnits()
{
using (var db = new BarProjectEntities())
{
return(db.Units.Select(x => x).ToAnotherType <Unit, ShowableUnit>().ToList());
}
}
public static IEnumerable <ShowableTax> GetAllTaxes()
{
using (var db = new BarProjectEntities())
{
return(db.Taxes.Select(x => x).ToAnotherType <Tax, ShowableTax>().ToList());
}
}
public static IEnumerable <ShowableSoldProduct> GetSoldProductsView(int id)
{
using (var db = new BarProjectEntities())
{
return
(db.soldProductDetails(id).ToAnotherType <soldProductDetails_Result, ShowableSoldProduct>().ToList());
}
}
public static List <ShowableCategory> GetAllCategories()
{
using (var db = new BarProjectEntities())
{
return((from data in db.Categories
orderby data.id
select data).ToAnotherType <Category, ShowableCategory>().ToList());
}
}
public static UserPrivileges GetPrivileges(string username, string password)
{
var toReturn = UserPrivileges.NoUser;
using (var db = new BarProjectEntities())
{
db.Database.Log = s => System.Diagnostics.Debug.WriteLine(s);
var parameter = new ObjectParameter("tmp_credentials", typeof(short));
db.checkCredentials(username, password, parameter);
var tmp = parameter.Value as short?;
if (tmp.HasValue)
{
return(tmp.Value.ToUserPrivledges());
}
}
return(toReturn);
}
public static string RemoveCategory(int?id)
{
try
{
using (var db = new BarProjectEntities())
{
db.removeCategory(id);
}
}
catch (Exception ex)
{
var message = ex.Message;
if (ex.InnerException != null)
{
message += "\nInner:" + ex.InnerException.Message;
}
return(message);
}
return("");
}
public static string AddTax(ShowableTax tax)
{
try
{
using (var db = new BarProjectEntities())
{
db.addTax(tax.TaxName, tax.TaxValue);
}
}
catch (Exception ex)
{
var message = ex.Message;
if (ex.InnerException != null)
{
message += "\nInner:" + ex.InnerException.Message;
}
return(message);
}
return("");
}
