public bool RegisterNewUser(string login, string password, string email, DateTime birthDate, bool statsEnabled)
{
using (var context = new CheaperEntities())
{
var nowyUser = new Users();
nowyUser.UserName = login;
nowyUser.Passwd = GetMD5Hash(password);
nowyUser.Email = email;
nowyUser.BirthDate = birthDate;
nowyUser.RegisterDate = DateTime.Now;
var nowyUserAddInfo = new AdditionalUserInfo();
nowyUserAddInfo.UserID = login;
nowyUserAddInfo.ShowEmail = false;
nowyUserAddInfo.ShowBirthDate = false;
nowyUserAddInfo.ShowPhone = false;
nowyUserAddInfo.StatsEnabled = statsEnabled;
context.AdditionalUserInfo.AddObject(nowyUserAddInfo);
context.Users.AddObject(nowyUser);
if (context.SaveChanges() == 2)
{
return(true);
}
else
{
return(false);
}
}
}
public bool DodajPozycjeBudzetu(int idBudzetu, int idProduktu, int idKategorii, int?idSklepu, decimal cena, DateTime dataZakupu, decimal ilosc, string dodatkoweInfo, string userName)
{
using (var context = new CheaperEntities())
{
var select = from c in context.Budgets where c.UserID == userName && c.BudgetID == idBudzetu select c.BudgetID;
if (select.Count() != 1)
{
return(false);
}
var nowaPozycja = new BudgetPositions();
nowaPozycja.BudgetID = idBudzetu;
nowaPozycja.ProdID = idProduktu;
nowaPozycja.ExpenseCatID = idKategorii;
nowaPozycja.ShopID = idSklepu;
nowaPozycja.UserID = userName;
nowaPozycja.Price = cena;
nowaPozycja.PurchaseDate = dataZakupu;
nowaPozycja.CreationDate = DateTime.Now;
nowaPozycja.Quantity = ilosc;
nowaPozycja.AdditionalInfo = dodatkoweInfo;
context.BudgetPositions.AddObject(nowaPozycja);
if (context.SaveChanges() == 1)
{
return(true);
}
else
{
return(false);
}
}
}
public bool ChangeKwotaKatWyd(decimal kwota, int idKatWyd, string userName)
{
using (var context = new CheaperEntities())
{
try
{
ExpenseCategories katWyd = (from c in context.ExpenseCategories where c.UserID == userName && c.Id == idKatWyd select c).First();
//if (katWyd == null)
// throw new NullReferenceException("Próba zmiany kwoty kategorii wydatku nie należącej do użytkownika");
katWyd.Amount = kwota;
if (context.SaveChanges() == 1)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
throw new Exception("Próba zmiany kwoty kategorii wydatku nie należącej do użytkownika", ex);
}
}
}
public List <BudgetPositionModel> GetBudgetDetailsData(int budgetId, string userName)
{
using (var context = new CheaperEntities())
{
var select = from budPos in context.BudgetPositionsWithStats
from shops in context.Shops.Where(x => budPos.ShopID == x.Id).DefaultIfEmpty()
join buds in context.Budgets on budPos.BudgetID equals buds.BudgetID
join products in context.Products on budPos.ProdID equals products.ProductID
join expCats in context.ExpenseCategories on budPos.ExpenseCatID equals expCats.Id
where budPos.BudgetID == budgetId && buds.UserID == userName
orderby budPos.PurchaseDate descending
select new BudgetPositionModel()
{
PositionID = budPos.PositionID,
Price = budPos.Price,
PurchaseDate = budPos.PurchaseDate,
Quantity = budPos.Quantity,
RoznicaCeny = budPos.PriceDifference,
SredniaCena = budPos.AveragePrice,
AddInfo = budPos.AdditionalInfo,
ProductName = products.Name,
ExpenseCatName = expCats.Name,
ShopFriendlyName = shops.FriendlyName,
ShopStreet = shops.Street,
ShopCity = shops.City,
ShopPostCode = shops.PostCode
};
var asdf = select.ToList();
return(select.ToList());
}
}
public bool LogEvent(string methodName, Exception exception, string userName)
{
using (var context = new CheaperEntities())
{
var nowyEvent = new Events();
nowyEvent.MethodName = methodName;
nowyEvent.ExMessage = exception.Message;
if (exception.InnerException != null)
{
nowyEvent.InnerExMessage = exception.InnerException.Message;
}
nowyEvent.OccurenceDate = DateTime.Now;
if (!string.IsNullOrEmpty(userName))
{
nowyEvent.UserName = userName;
}
else
{
nowyEvent.UserName = "******";
}
context.Events.AddObject(nowyEvent);
if (context.SaveChanges() == 1)
{
return(true);
}
else
{
return(false);
}
}
}
public List <ExpenseModel> GetKategorieWydatku(string userName)
{
using (var context = new CheaperEntities())
{
var select = from c in context.ExpenseCatLastMthBalance where c.UserID == userName select new ExpenseModel()
{
Id = c.Id, Name = c.Name, Amount = c.Amount, Balance = c.Balance
};
return(select.ToList());
}
}
public Dictionary <int, string> GetKategorie()
{
using (var context = new CheaperEntities())
{
var select = from c in context.Categories select new { c.Id, c.Name };
var resultKategorie = new Dictionary <int, string>();
foreach (var item in select)
{
resultKategorie.Add(item.Id, item.Name);
}
return(resultKategorie);
}
}
public bool IsUsernameAvailable(string userName)
{
using (var context = new CheaperEntities())
{
var select = from c in context.Users where c.UserName == userName select c.UserName;
if (select.Count() == 0)
{
return(true);
}
else
{
return(false);
}
}
}
public List <ShopModel> GetShops(string userName)
{
using (var context = new CheaperEntities())
{
var select = from c in context.Shops
where c.UserID == userName
select new ShopModel()
{
FriendlyName = c.FriendlyName,
City = c.City,
Street = c.Street,
PostCode = c.PostCode
};
return(select.ToList());
}
}
public string[] GetShopsAutocomplete(string startsWith, string userName)
{
using (var context = new CheaperEntities())
{
var select = from c in context.Shops
where c.UserID == userName &&
c.FriendlyName.StartsWith(startsWith)
select new { c.Id, c.FriendlyName };
List <string> resultList = new List <string>();
foreach (var item in select)
{
resultList.Add(string.Format("{0}~{1}", item.Id, item.FriendlyName));
}
return(resultList.ToArray());
}
}
public bool CheckUserAuthentication(string login, string password)
{
if (login.Length < 4)
{
return(false);
}
using (var context = new CheaperEntities())
{
string hashedPw = GetMD5Hash(password);
var selectedUsers = from c in context.Users where (c.UserName == login && c.Passwd == hashedPw) select c.UserName;
if (selectedUsers.Count() == 1)
{
return(true);
}
return(false);
}
}
public BudgetModel GetBudgetData(int budgetId, string userName)
{
using (var context = new CheaperEntities())
{
var select = from c in context.BudgetsWithExpenses where c.UserID == userName && c.BudgetID == budgetId orderby c.CreationDate select new BudgetModel()
{
BudgetID = c.BudgetID, BudgetName = c.BudgetName, CreationDate = c.CreationDate, LastMonthExpenses = c.ThisMonthExpenses, LastYearExpenses = c.ThisYearExpenses
};
var resultArray = select.ToArray();
if (resultArray.Count() > 0)
{
return(resultArray[0]);
}
else
{
return(null);
}
}
}
public bool DodajKatWyd(string nazwaKat, decimal kwotaKat, string userName)
{
using (var context = new CheaperEntities())
{
var nowaKatWyd = new ExpenseCategories();
nowaKatWyd.Name = nazwaKat;
nowaKatWyd.Amount = kwotaKat;
nowaKatWyd.UserID = userName;
context.ExpenseCategories.AddObject(nowaKatWyd);
if (context.SaveChanges() == 1)
{
return(true);
}
else
{
return(false);
}
}
}
public bool DodajBudzet(string nazwaBudzetu, string login, DateTime dataUtworzenia)
{
using (var context = new CheaperEntities())
{
var nowyBudzet = new Budgets();
nowyBudzet.BudgetName = nazwaBudzetu;
nowyBudzet.CreationDate = dataUtworzenia;
nowyBudzet.UserID = login;
context.Budgets.AddObject(nowyBudzet);
if (context.SaveChanges() == 1)
{
return(true);
}
else
{
return(false);
}
}
}
public string[] GetProductsAutocomplete(string firstLetters, string userName, bool getDictValues)
{
using (var context = new CheaperEntities())
{
var selectUserValues = from c in context.Products
where c.Name.StartsWith(firstLetters) && c.UserID == userName
select new { c.ProductID, c.Name };
var selectDictValues = from c in context.Products
where c.Name.StartsWith(firstLetters) && c.UserID == "dft"
select new { c.ProductID, c.Name };
List <string> resultList = new List <string>();
foreach (var item in (getDictValues ? selectDictValues : selectUserValues))
{
resultList.Add(string.Format("{0}~{1}", item.ProductID, item.Name));
}
return(resultList.ToArray());
}
}
public bool DodajProdukt(string nazwaProduktu, short idKategorii, string userName)
{
using (var context = new CheaperEntities())
{
var nowyProdukt = new Products();
nowyProdukt.Name = nazwaProduktu;
nowyProdukt.UserID = userName;
nowyProdukt.CategoryID = idKategorii;
context.Products.AddObject(nowyProdukt);
if (context.SaveChanges() == 1)
{
return(true);
}
else
{
return(false);
}
}
}
public Dictionary <int, string> GetKategorieWydatkuComboList(string userName)
{
using (var context = new CheaperEntities())
{
var select = from c in context.ExpenseCategories where c.UserID == userName select new { c.Id, c.Name };
var resultKategorieWyd = new Dictionary <int, string>();
foreach (var item in select)
{
resultKategorieWyd.Add(item.Id, item.Name);
}
if (resultKategorieWyd.Count > 0)
{
return(resultKategorieWyd);
}
else
{
return(null);
}
}
}
public List <BudgetModel> GetBudgets(string userName)
{
using (var context = new CheaperEntities())
{
var select = from c in context.BudgetsWithExpenses
where c.UserID == userName
orderby c.BudgetName ascending
select new BudgetModel()
{
BudgetID = c.BudgetID,
BudgetName = c.BudgetName,
CreationDate = c.CreationDate,
PositionsCount = (from inc in context.BudgetPositions
where inc.BudgetID == c.BudgetID
select inc).Count(),
LastMonthExpenses = c.ThisMonthExpenses,
LastYearExpenses = c.ThisYearExpenses
};
return(select.ToList());
}
}
public UserModel GetUserData(string userName)
{
using (var context = new CheaperEntities())
{
var select = from c in context.Users
join a in context.AdditionalUserInfo on c.UserName equals a.UserID
where c.UserName == userName
select new UserModel()
{
UserName = c.UserName,
Passwd = c.Passwd,
StatsEnabled = a.StatsEnabled,
ShowPhone = a.ShowPhone,
ShowBirthDate = a.ShowBirthDate,
ShowEmail = a.ShowEmail,
GaduGadu = a.GaduGadu,
Phone = a.Phone,
DisplayPic = a.DisplayPic
};
return(select.First());
}
}
public bool DodajSklep(string przyjaznaNazwa, string ulica, string miasto, string kodPocztowy, string userName)
{
using (var context = new CheaperEntities())
{
var nowySklep = new Shops();
nowySklep.FriendlyName = przyjaznaNazwa;
nowySklep.Street = ulica;
nowySklep.City = miasto;
nowySklep.PostCode = kodPocztowy;
nowySklep.UserID = userName;
context.Shops.AddObject(nowySklep);
if (context.SaveChanges() == 1)
{
return(true);
}
else
{
return(false);
}
}
}
