public Result <T> Update(T item)
{
//var i = new T();
Result <T> r = new Result <T>();
try
{
using (CarCosmeticSalonEntities2 db = new CarCosmeticSalonEntities2())
{
db.Configuration.LazyLoadingEnabled = false;
db.Entry(item).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
r.value = item;
r.info = "poprawnie dodane";
r.status = true;
return(r);
}
catch (Exception e)
{
r.value = null;
r.info = "Error:" + e.Message;
r.status = false;
return(r);
}
}
public bool UserExist(string login)
{
using (CarCosmeticSalonEntities2 db = new CarCosmeticSalonEntities2())
{
return(db.Users.Any(u => u.Login == login));
}
}
public Result <T> Remove(int id)
{
try
{
T i;
using (CarCosmeticSalonEntities2 db = new CarCosmeticSalonEntities2())
{
T p = db.Set <T>().Find(id);
db.Configuration.LazyLoadingEnabled = false;
i = db.Set <T>().Remove(p);
db.SaveChanges();
}
Result <T> r = new Result <T>();
r.value = i;
r.info = "usunięto";
r.status = true;
return(r);
}
catch (Exception e)
{
Result <T> r = new Result <T>();
r.value = null;
r.info = "error " + e.Message;
r.status = false;
return(r);
}
}
public Result <T> Add(T item) // item.AccoutCreateDate = DateTime.Now; dla usera
{
var r = new Result <T>();
try
{
using (CarCosmeticSalonEntities2 db = new CarCosmeticSalonEntities2())
{
db.Configuration.LazyLoadingEnabled = false;
r.info = "Poprawnie dodane";
r.status = true;
r.value = item;
db.Entry(item).State = System.Data.Entity.EntityState.Added;
db.SaveChanges();
return(r);
}
}catch (Exception e)
{
r.status = false;
r.value = null;
r.info = "Nie udało się dodać, error:" + e.ToString();
return(r);
}
}
public Result <List <DifDayInfo> > getMonthDiffInfo(DateTime month)
{
using (CarCosmeticSalonEntities2 db = new CarCosmeticSalonEntities2())
{
db.Configuration.LazyLoadingEnabled = false;
var r = new Result <List <DifDayInfo> >();
r.info = "Informacja o zmianach terminów w miesiącu: " + month.ToString();
r.value =
db.DifDayInfoes.Where(e => e.ExactChangeDate.Month == month.Month && e.ExactChangeDate.Year == month.Year)
.ToList();
if (r.value.Count > 0)
{
foreach (var day in r.value)
{
day.DayInfo = _dayInfoRepository.GetById(day.DayId).value;
}
r.status = true;
}
else
{
r.status = false;
}
return(r);
}
}
public bool IsFirstUser()
{
using (CarCosmeticSalonEntities2 db = new CarCosmeticSalonEntities2())
{
return(db.Users.Count() < 1);
}
}
public new Result <User> GetById(int id)
{
var r = base.GetById(id);
using (CarCosmeticSalonEntities2 db = new CarCosmeticSalonEntities2())
{
db.Configuration.LazyLoadingEnabled = false;
r.value.UserType = db.UserTypes.FirstOrDefault(u => u.UserTypeId == r.value.UserTypeId);
}
return(r);
}
public Result <List <T> > Get()
{
using (CarCosmeticSalonEntities2 db = new CarCosmeticSalonEntities2())
{
db.Configuration.LazyLoadingEnabled = false;
var r = new Result <List <T> >();
r.info = "get all";
r.status = true;
r.value = db.Set <T>().ToList();
return(r);
}
}
public Result <List <Order> > GetStarted(bool started)
{
using (CarCosmeticSalonEntities2 db = new CarCosmeticSalonEntities2())
{
db.Configuration.LazyLoadingEnabled = false;
var r = new Result <List <Order> >();
r.info = "get Started " + started;
r.status = true;
r.value = db.Orders.Where(e => e.IsOrderStarted == started).ToList();
r.value = AddTemplateOrderToList(r.value);
return(r);
}
}
public Result <List <Order> > GetOrdersFromMonth(System.DateTime date)
{
using (CarCosmeticSalonEntities2 db = new CarCosmeticSalonEntities2())
{
db.Configuration.LazyLoadingEnabled = false;
var r = new Result <List <Order> >();
r.info = "get orders from month " + date.Month + "/" + date.Year + "/";
r.status = true;
r.value = db.Orders.Where(e => e.ExpectedStartOfOrder.Value.Date.Year == date.Date.Year && e.ExpectedStartOfOrder.Value.Date.Month == date.Date.Month).ToList();
r.value = AddTemplateOrderToList(r.value);
return(r);
}
}
public Result <List <Order> > GetByUserId(int id)
{
using (CarCosmeticSalonEntities2 db = new CarCosmeticSalonEntities2())
{
db.Configuration.LazyLoadingEnabled = false;
var r = new Result <List <Order> >();
r.info = "get by user id " + id;
r.status = true;
r.value = db.Orders.Where(e => e.UserId == id).ToList();
r.value = AddTemplateOrderToList(r.value);
return(r);
}
}
public new Result <List <User> > Get()
{
var r = new Result <List <User> >();
r = base.Get();
using (CarCosmeticSalonEntities2 db = new CarCosmeticSalonEntities2())
{
db.Configuration.LazyLoadingEnabled = false;
foreach (var u in r.value)
{
u.UserType = (UserType)(db.UserTypes.FirstOrDefault(v => v.UserTypeId == u.UserTypeId));
u.UserType.Users = null;
}
return(r);
}
}
public Result <T> GetById(int id)
{
using (CarCosmeticSalonEntities2 db = new CarCosmeticSalonEntities2())
{
db.Configuration.LazyLoadingEnabled = false;
var r = new Result <T>();
r.value = db.Set <T>().Find(id);
if (r.value != null)
{
r.info = "znaleziono encję o tym id";
r.status = true;
}
else
{
r.info = "nie znaleziono encji o id:" + id;
r.status = false;
}
return(r);
}
}
public Result <List <OrdersTemplateImage> > GetImagesFromOrderTemplateId(int orderTemplateId)
{
using (CarCosmeticSalonEntities2 db = new CarCosmeticSalonEntities2())
{
db.Configuration.LazyLoadingEnabled = false;
var r = new Result <List <OrdersTemplateImage> >();
r.value = db.OrdersTemplateImages.Where(e => e.OrderTemplateId == orderTemplateId).ToList();
if (r.value != null)
{
r.info = "znaleziono zdjęcia dołączone do tego Template: " + orderTemplateId;
r.status = true;
}
else
{
r.info = "nie znaleziono zdjęć dołączonych do tego Template: " + orderTemplateId;
r.status = false;
}
return(r);
}
}
public new Result <Order> GetById(int id)
{
var R = base.GetById(id);
if (R.status)
{
var templ = OTempRepository.GetById(R.value.OrderTemplateId);
List <OrdersInformation> info;
using (CarCosmeticSalonEntities2 db = new CarCosmeticSalonEntities2())
{
info = db.OrdersInformations.Where(i => i.OrderId == R.value.OrderId).ToList();
}
R.value.OrdersInformations = info;
if (templ.status)
{
R.value.OrdersTemplate = templ.value;
}
}
return(R);
}
public Result <User> GetByLogin(string login)
{
using (CarCosmeticSalonEntities2 db = new CarCosmeticSalonEntities2())
{
db.Configuration.LazyLoadingEnabled = false;
var r = new Result <User>();
r.value = db.Users.FirstOrDefault(u => u.Login == login);
if (r.value != null)
{
r.info = "znaleziono użytkownika";
r.status = true;
r.value.UserType = db.UserTypes.FirstOrDefault(u => u.UserTypeId == r.value.UserTypeId);
}
else
{
r.info = "nie znaleziono użytkownika";
r.status = false;
}
return(r);
}
}
public Result <int> GetIdByLogin(string login)
{
using (CarCosmeticSalonEntities2 db = new CarCosmeticSalonEntities2())
{
var r = new Result <int>();
var i = db.Users.FirstOrDefault(u => u.Login == login).UserId;
if (i == 0)
{
r.info = "brak użytkownika o takim loginie";
r.status = false;
}
else
{
r.info = "znaleziono id użytkownika";
r.status = true;
r.value = i;
}
return(r);
}
}
public Result <DifDayInfo> getDayDiffInfo(DateTime day)
{
using (CarCosmeticSalonEntities2 db = new CarCosmeticSalonEntities2())
{
db.Configuration.LazyLoadingEnabled = false;
var r = new Result <DifDayInfo>();
r.info = "Zmiana informacji o dniu: " + day.ToString();
//linku nie porównuje Date dlatego musiałem osobno year,month,day
r.value =
db.DifDayInfoes.Where(e => e.ExactChangeDate.Year == day.Year && e.ExactChangeDate.Month == day.Month && e.ExactChangeDate.Day == day.Day).FirstOrDefault();
if (r.value != null)
{
r.value.DayInfo = _dayInfoRepository.GetById(r.value.DayId).value;
}
return(r);
}
}
public Result <Order> GetByPayUOrderId(string payuIdOrd)
{
var r = new Result <Order>();
using (CarCosmeticSalonEntities2 db = new CarCosmeticSalonEntities2())
{
db.Configuration.LazyLoadingEnabled = false;
r.info = "get by payu id:" + payuIdOrd;
r.value = db.Orders.Where(e => e.PayUOrderId == payuIdOrd).First();
if (r.value != null)
{
r.status = true;
}
else
{
r.status = false;
}
}
return(r);
}
public Result <OrdersTemplate> GetByName(string name)
{
using (CarCosmeticSalonEntities2 db = new CarCosmeticSalonEntities2())
{
db.Configuration.LazyLoadingEnabled = false;
var r = new Result <OrdersTemplate>();
r.info = "test mess";
r.value = db.OrdersTemplates.FirstOrDefault(p => p.Name == name);
if (r.value != null)
{
r.status = true;
r.info = "Istnieje order template o tej nazwie";
}
else
{
r.status = false;
r.info = "order template o tej nazwie nie istnieje";
}
return(r);
}
}
public Result <User> Login(string login, string password)
{
using (CarCosmeticSalonEntities2 db = new CarCosmeticSalonEntities2())
{
db.Configuration.LazyLoadingEnabled = false;
var r = new Result <User>();
r.value = db.Users.FirstOrDefault(u => u.Login.Equals(login));
ScryptEncoder encoder = new ScryptEncoder();
if (r.value != null)
{
//porównaj czy hash w bazie zgadza się z zwykłym hasłem przesłanym przez użytkownika
if (encoder.Compare(password, r.value.Password))
{
r.value.UserType = db.UserTypes.FirstOrDefault(u => u.UserTypeId == r.value.UserTypeId);
r.info = "zalogowany:";
r.status = true;
}
else
{
r.info = "Nie znaleziono użytkownika o podanym loginie i haśle";
r.status = false;
}
}
else
{
r.info = "Nie znaleziono użytkownika o podanym loginie i haśle";
r.status = false;
}
return(r);
}
}
