public ActionResult Login(LoginViewModel model, string returnUrl)
{
if (!ModelState.IsValid)
{
return(View(model));
}
Korisnik korisnik = new Korisnik();
using (var session = FluentNHibernateHelper.OpenSession())
{
try
{
korisnik = ((List <Korisnik>)session.QueryOver <Korisnik>()
.Where(k => k.Username == model.Email).List()).ElementAt(0);
}
catch (Exception e)
{
return(View());
}
}
if (korisnik.Lozinka == model.Password)
{
Session["LogIn"] = true;
Session["User"] = korisnik;
return(RedirectToAction("BucketItems", "Korisnik"));
}
else
{
return(View());
}
}
public T RetornarPorId(int Id)
{
using (ISession session = FluentNHibernateHelper.AbrirSession())
{
return(session.Get <T>(Id));
}
}
public IList <T> Consultar()
{
using (ISession session = FluentNHibernateHelper.AbrirSession())
{
return((from c in session.Query <T>() select c).ToList());
}
}
public ActionResult Create(BuketListModel model)
{
try
{
BucketItem bucketItem = new BucketItem();
bucketItem.Ime = model.Ime;
bucketItem.Ostvareno = model.Ostvareno;
MemoryStream target = new MemoryStream();
model.Slika.InputStream.CopyTo(target);
byte[] data = target.ToArray();
bucketItem.Slika = data;
bucketItem.Opis = model.Opis;
bucketItem.Korisnik = (Korisnik)Session["User"];
using (var session = FluentNHibernateHelper.OpenSession())
{
List <Kategorija> kategorija = (List <Kategorija>)session.QueryOver <Kategorija>()
.Where(k => k.Id == int.Parse(model.KategorijaId)).List();
bucketItem.Kategorija = kategorija[0];
session.SaveOrUpdate(bucketItem);
}
return(RedirectToAction("BucketItems", "Korisnik"));
}
catch
{
return(View());
}
}
protected override bool IsAuthorized(HttpActionContext actionContext)
{
var userName = Thread.CurrentPrincipal.Identity.Name;
Method methodObj = new Method();
var action = actionContext.Request.Method.Method.ToLower();
var method = actionContext.ActionDescriptor.ActionName;
var nParams = actionContext.Request.GetRouteData().Values.Count;
using (var repo = FluentNHibernateHelper.GetRepository())
{
methodObj = repo.Where <Method>(m => m.Params == nParams && m.Name == method && m.Action == action).FirstOrDefault();
if (methodObj != null)
{
UserMethodSub ums = new UserMethodSub(userName, methodObj.Id);
if (UserRoles.user_method_dict.ContainsKey(ums))
{
return(true);
}
}
}
return(false);
}
private void CreateTeendoDb(TeendoLista teendo)
{
using (var session = FluentNHibernateHelper.OpenSession())
using (var transaction = session.BeginTransaction())
{
var ujTeendo = new Entities.TeendoLista()
{
Allapot = teendo.Allapot,
Fontossag = teendo.Fontossag.ToString(),
Hatarido = teendo.Hatarido,
Letrehozas = teendo.Letrehozas,
SzinKod = teendo.SzinkodMegadva ? teendo.SzinKod : null,
};
foreach (var teendoListaElem in teendo.TeendoListaElemek)
{
var ujElem = new Entities.TeendoListaElem()
{
Szoveg = teendoListaElem.Szoveg,
Teendo = ujTeendo
};
ujTeendo.TeendoListaElemek.Add(ujElem);
}
session.Save(ujTeendo);
transaction.Commit();
}
}
public ActionResult ChangeImage(ImageViewModel model)
{
if (!ModelState.IsValid)
{
// the user didn't upload any file =>
// render the same view again in order to display the error message
return(RedirectToAction("Details", "Korisnik"));
}
Korisnik korisnik = (Korisnik)Session["User"];
MemoryStream target = new MemoryStream();
model.File.InputStream.CopyTo(target);
byte[] data = target.ToArray();
korisnik.Slika = data;
using (var session = FluentNHibernateHelper.OpenSession())
{
session.Update(korisnik);
session.Flush();
}
return(RedirectToAction("Details", "Korisnik"));
}
private void SaveTeendok(TeendokListaja lista)
{
/*
* var toFile = _serializeService.Serialize(lista.Save());
* var result = _persisterService.Save(new Uri(_file), toFile);
*/
using (var session = FluentNHibernateHelper.OpenSession())
using (var transaction = session.BeginTransaction())
{
foreach (var teendoBase in lista.Teendok)
{
var teendo = teendoBase as Teendo;
if (teendo != null)
{
var ujTeendo = new Entities.Teendo()
{
Allapot = teendo.Allapot,
Fontossag = teendo.Fontossag.ToString(),
Hatarido = teendo.Hatarido,
Letrehozas = teendo.Letrehozas,
SzinKod = teendo.SzinkodMegadva ? teendo.SzinKod : null,
Szoveg = teendo.Szoveg
};
session.SaveOrUpdate(ujTeendo);
}
}
transaction.Commit();
}
}
public ActionResult ChangeBucketItem(int itemId)
{
BucketItem bucketItem = new BucketItem();
BuketListModelWithoutPicture buketListModel = new BuketListModelWithoutPicture();
using (var session = FluentNHibernateHelper.OpenSession())
{
bucketItem = ((List <BucketItem>)session.QueryOver <BucketItem>()
.Where(k => k.Id == itemId).List()).ElementAt(0);
buketListModel.Id = bucketItem.Id;
buketListModel.Ime = bucketItem.Ime;
buketListModel.KategorijaId = bucketItem.Kategorija.Id.ToString();
buketListModel.Opis = bucketItem.Opis;
buketListModel.Ostvareno = bucketItem.Ostvareno;
List <Kategorija> kategorije = (List <Kategorija>)session
.QueryOver <Kategorija>()
.List();
foreach (var kategorija in kategorije)
{
SelectListItem selectListItem = new SelectListItem();
selectListItem.Text = kategorija.Naziv;
selectListItem.Value = kategorija.Id.ToString();
buketListModel.kategorijaItems.Add(selectListItem);
}
}
return(View(buketListModel));
}
public ActionResult Register(RegisterViewModel model)
{
if (ModelState.IsValid)
{
Korisnik korisnik = new Korisnik();
Image slika;
using (var session = FluentNHibernateHelper.OpenSession())
{
korisnik.Ime = model.Ime; korisnik.Prezime = model.Prezime;
korisnik.Username = model.Email; korisnik.Moto = model.Moto;
korisnik.Opis = model.Opis; korisnik.Lozinka = model.Password;
if (model.Spol == "Male")
{
slika = Image.FromFile(Server.MapPath(@"~/Content/Images/boyDefault.PNG"));
}
else
{
slika = Image.FromFile(@"~/Content/Images/girlDefault.PNG");
}
using (var ms = new MemoryStream())
{
slika.Save(ms, System.Drawing.Imaging.ImageFormat.Png);
korisnik.Slika = ms.ToArray();
}
session.SaveOrUpdate(korisnik);
Session["LogIn"] = true;
Session["User"] = korisnik;
}
return(RedirectToAction("Index", "Home"));
}
return(View(model));
}
public static User GetUserDetail(string username, string password)
{
using (IRepository repository = FluentNHibernateHelper.GetRepository())
{
return(repository.Where <User>(user =>
user.UserName == username && user.PassWord == password).FirstOrDefault());
}
}
private Entities.TeendoBase GetTeendoDb(int id)
{
using (var session = FluentNHibernateHelper.OpenSession())
{
var teendo = session.Get <Entities.TeendoBase>(id);
return(teendo);
}
}
public IEnumerable <OperadoraDTO> Get()
{
using (ISession session = FluentNHibernateHelper.OpenSession())
{
var operadoras = Mapper.Map <List <OperadoraDTO> >(session.Query <DataModel.Entities.Operadora>());
return(operadoras);
}
}
public IHttpActionResult GetAll()
{
using (var repository = FluentNHibernateHelper.GetRepository())
{
var blogs = repository.GetAll <Blog>();
return(Ok(blogs));
}
}
public void DoCsvExport()
{
var session = FluentNHibernateHelper.OpenSession();
var records = session.Query <ScoredHandle>().ToList();
const string path = @"C:\Users\Nishant\Desktop\Dropbox\Ouzero\DatabaseExport.csv";
Utilities.WriteDatabaseExportFile(path, records);
}
public IHttpActionResult GetById(long id)
{
using (var repository = FluentNHibernateHelper.GetRepository())
{
Blog blog = repository.Get <Blog>(id);
return(Ok(blog));
}
}
public void Insert(Product product)
{
//products.Add(product);
using (ISession s = FluentNHibernateHelper.OpenSession())
{
s.SaveOrUpdate(product);
s.Flush();
}
}
private void SaveTeendoDb(Entities.TeendoBase teendo)
{
using (var session = FluentNHibernateHelper.OpenSession())
using (var transaction = session.BeginTransaction())
{
session.SaveOrUpdate(teendo);
transaction.Commit();
}
}
public static bool Login(string username, string password)
{
using (var repository = FluentNHibernateHelper.GetRepository())
{
var user = repository.Where <User>(u =>
u.UserName == username && u.PassWord == password);
return(user.Count != 0);
}
}
private void InitializeDataBaseConnection()
{
FluentNHibernateHelper.InitializeDatabase();
_barometricPressureDataBaseConnector = new BarometricPressureDataBaseConnector(_eventAggregator);
_temperatureDataBaseConnector = new TemperatureDataBaseConnector(_eventAggregator);
_eventAggregator.GetEvent <NewTemperature>().Subscribe(_temperatureDataBaseConnector.SaveMeasurement);
_eventAggregator.GetEvent <NewBarPressure>().Subscribe(_barometricPressureDataBaseConnector.SaveMeasurement);
}
private static void RemoveTestCommitsFromDb()
{
var session = FluentNHibernateHelper.OpenSession();
using (session)
{
var rowsAffected = session.CreateQuery("delete from ScoredHandle where Username = '******'").ExecuteUpdate();
Console.WriteLine(@"Delete, affected rows: " + rowsAffected);
}
}
public ActionResult BucketItemsMobile()
{
var bucketItemsModel = new BucketItemsModel();
using (var session = FluentNHibernateHelper.OpenSession())
{
List <BucketItem> bucketItems = (List <BucketItem>)session.QueryOver <BucketItem>().List();
return(Json(bucketItems));
}
}
private void DeleteTeendoDb(int id)
{
var toroltTeendo = GetTeendoDb(id);
using (var session = FluentNHibernateHelper.OpenSession())
using (var transaction = session.BeginTransaction())
{
session.Delete(toroltTeendo);
transaction.Commit();
}
}
public void CoreDaoTest()
{
FluentNHibernateHelper.Connect();
CoreDao <Product> dao = new CoreDao <Product>(new SessionProviderFNH());
dao.Put(new Product {
Name = "PS2", Description = "VideoConsole"
});
dao.Put(new Product {
Name = "PS3", Description = "VideoConsole"
});
IList <Product> products = dao.Get();
}
public ActionResult usernameSubmit(string newUsername)
{
Korisnik korisnik = (Korisnik)Session["User"];
korisnik.Username = newUsername;
Session["User"] = korisnik;
using (var session = FluentNHibernateHelper.OpenSession())
{
session.Update(korisnik);
session.Flush();
}
return(RedirectToAction("Details"));
}
public ActionResult About()
{
Korisnik prviKorisnik;
using (var session = FluentNHibernateHelper.OpenSession())
{
List <Korisnik> korisnik = (List <Korisnik>)session.QueryOver <Korisnik>()
.Where(k => k.Id == 4).List();
prviKorisnik = korisnik.ElementAt(0);
BucketItem bucketItem = prviKorisnik.BucketItems[0];
}
ViewBag.Message = "Your application username: " + prviKorisnik.Username;
return(View());
}
private void LoadUserMethod()
{
UserRoles.user_method_dict = new Dictionary <UserMethodSub, bool>(new UserMethodEqualityComparer());
IList <UserMethod> userMethodList = new List <UserMethod>();
using (var repo = FluentNHibernateHelper.GetRepository())
{
userMethodList = repo.GetAll <UserMethod>();
}
foreach (var userMethod in userMethodList)
{
UserRoles.user_method_dict.Add(new UserMethodSub(userMethod), true);
}
}
public HttpResponseMessage GetContatos()
{
try
{
using (ISession session = FluentNHibernateHelper.OpenSession())
{
var contatos = Mapper.Map <List <ContatoDTO> >(session.Query <Contato>());
return(Request.CreateResponse(HttpStatusCode.OK, contatos));
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex.Message));
}
}
public IList <Modelo> buscarPorMarca(int id)
{
using (ISession session = FluentNHibernateHelper.AbrirSession())
{
try
{
var query = session.Query <Modelo>();
IList <Modelo> modelo = query.Where(x => x.Marca.Id == id).ToList();
return(modelo);
}
catch (Exception ex)
{
throw new Exception("Erro ao buscar cliente pelo cpf: " + ex.Message);
}
}
}
public HttpResponseMessage Post([FromBody] KorisnikModel Korisnik)
{
if (ModelState.IsValid)
{
Korisnik korisnik = new Korisnik();
Image Slika;
using (var session = FluentNHibernateHelper.OpenSession())
{
korisnik.Ime = Korisnik.Ime; korisnik.Prezime = Korisnik.Prezime;
korisnik.Username = Korisnik.Username; korisnik.Moto = Korisnik.Moto;
korisnik.Opis = Korisnik.Opis; korisnik.Lozinka = Korisnik.Lozinka;
if (Korisnik.Slika == null)
{
//Slika = Image.FromFile(@"~/Content/Images/boyDefault.png");
//using (var ms = new MemoryStream())
//{
// Slika.Save(ms, System.Drawing.Imaging.ImageFormat.Png);
// korisnik.Slika = ms.ToArray();
//}
}
else
{
korisnik.Slika = Korisnik.Slika;
}
session.SaveOrUpdate(korisnik);
}
var novi = new KorisnikModel();
novi.Id = korisnik.Id;
novi.Ime = korisnik.Ime;
novi.Lozinka = korisnik.Lozinka;
novi.Moto = korisnik.Moto;
novi.Opis = korisnik.Opis;
novi.Prezime = korisnik.Prezime;
novi.Slika = korisnik.Slika;
novi.Username = korisnik.Username;
response = Request.CreateResponse(HttpStatusCode.OK, novi);
return(response);
}
Korisnik prazan = new Korisnik();
response = Request.CreateResponse(HttpStatusCode.OK, prazan);
return(response);
}
