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); }