public IActionResult AddUser(AddUser addUserModel) { if (addUserModel.Password.Equals(addUserModel.ReenterPassword)) { using (var txn = _session.BeginTransaction()) { string UserName = addUserModel.UserName; string Password = addUserModel.Password; //string ReenterPassword = addUserModel.ReenterPassword; string Email = addUserModel.Email; string Bio = addUserModel.Bio; DateTime DOB = addUserModel.DOB; Ctry Country = addUserModel.Country; User newUser = new User(UserName, Password, Email, Country, Bio, DOB); _session.Save(newUser); txn.Commit(); } return(RedirectToAction("Index")); } else { ModelState.AddModelError("", "Passwords Donot Match"); return(View(addUserModel)); } }
public ActionResult AcceptGift(int Id) { Gift gift = _session.Get <Gift>(Id); Game game = _session.Get <Game>(gift.GameId); User user = _session.Get <User>(_context.UserId); if (user.GamesOwned.Contains <Game>(game)) { ViewData["error"] = "You already own this game. Please return to sender"; return(RedirectToAction("MyGifts")); } List <Game> gamesList = new List <Game> { game }; using (var txn = _session.BeginTransaction()) { user.GiftsOwned = user.GiftsOwned.Where(g => g.Id != gift.Id); user.GamesOwned = user.GamesOwned.Concat(gamesList); _session.SaveOrUpdate(user); txn.Commit(); } ViewData["error"] = game.Title + " has been added to your library!"; return(RedirectToAction("MyGifts")); }
/// <summary> /// Creates the specified parameters. /// </summary> /// <param name="parameters">The parameters.</param> public void Create(CreateUserParameters parameters) { parameters.Password = _crypto.Hash(parameters.Password); using (ITransaction trans = _session.BeginTransaction()) { _session.CreateCommandProcedure("User_Create", parameters) .ExecuteUpdate(); trans.Commit(); } }
private async Task <IActionResult> Remove <T>(int id) where T : class { try { using (NHibernate.ISession session = sessionFactory.OpenSession()) using (var transaction = session.BeginTransaction()) { //DigitalOutputGroup s;s. var @object = await session.CreateCriteria <T>().Add(Restrictions.Eq("Id", id)).UniqueResultAsync <T>(); if (@object == null) { return(BadRequest(ApiResult.BadRequest($"대상 ID {id}가 존재하지 않습니다"))); } await session.DeleteAsync(@object); await transaction.CommitAsync(); return(Ok(ApiResult.OK_200)); } } catch (Exception ex) { return(BadRequest(ApiResult.BadRequest(ex.Message))); } }
/// <DeleteDiscoverySearchByUserid> /// Delete DiscoverySearch from database by userId(Guid) /// </summary> /// <param name="userid">UserId of DiscoverySearch(Guid)</param> /// <returns>Return integer 1 for true 0 for false</returns> public int DeleteDiscoverySearchByUserid(Guid userid) { //Creates a database connection and opens up a session using (NHibernate.ISession session = SessionFactory.GetNewSession()) { //After Session creation, start Transaction. using (NHibernate.ITransaction transaction = session.BeginTransaction()) { try { //Proceed action to delete discoverysearch by userid. NHibernate.IQuery query = session.CreateQuery("delete from DiscoverySearch where UserId = :userid") .SetParameter("userid", userid); int isUpdated = query.ExecuteUpdate(); transaction.Commit(); return(isUpdated); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); return(0); } } //End Transaction } //End session }
public List <User> GetUserByCouponCode(User user) { List <User> alstUser = new List <User>(); try { using (NHibernate.ISession session = SessionFactory.GetNewSession()) { using (NHibernate.ITransaction transaction = session.BeginTransaction()) { try { alstUser = session.CreateQuery("from User where CouponCode=:couponCode") .SetParameter("couponCode", user.CouponCode) .List <User>().ToList <User>(); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } } } } catch (Exception ex) { Console.WriteLine("Error : " + ex.StackTrace); } return(alstUser); }
/********************/ public List <User> testing() { using (NHibernate.ISession session = SessionFactory.GetNewSession()) { using (NHibernate.ITransaction transaction = session.BeginTransaction()) { try { List <User> s = session.CreateQuery("from User").List <User>().ToList <User>(); return(s); //List<User> alstUser = new List<User>(); //foreach (User item in query.Enumerable()) //{ // alstUser.Add(item); //} //return alstUser; } catch (Exception ex) { Console.WriteLine(ex.StackTrace); return(null); } } } }
public static void UpdateAccountType(User user) { using (NHibernate.ISession session = SessionFactory.GetNewSession()) { using (NHibernate.ITransaction transaction = session.BeginTransaction()) { try { int i = session.CreateQuery("Update User set ProfileUrl =:profileurl, UserName =: username , EmailId=:emailid,AccountType=:accounttype,UserStatus=:userstatus,ExpiryDate=:expirydate,TimeZone=:timezone where Id = :twtuserid") .SetParameter("twtuserid", user.Id) .SetParameter("profileurl", user.ProfileUrl) .SetParameter("username", user.UserName) .SetParameter("emailid", user.EmailId) .SetParameter("accounttype", user.AccountType) .SetParameter("userstatus", user.UserStatus) .SetParameter("expirydate", user.ExpiryDate) .SetParameter("timezone", user.TimeZone) .ExecuteUpdate(); transaction.Commit(); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } } } }
public void SetUserByUserId(string emailid, string password, Guid id, string username, string accounttype, string couponcode) { using (NHibernate.ISession session = SessionFactory.GetNewSession()) { using (NHibernate.ITransaction transaction = session.BeginTransaction()) { try { int i = session.CreateQuery("Update User set EmailId=:email, UserName =: username, Password =:pass, AccountType= :acctype,CouponCode=:couponCode where Id = :twtuserid") .SetParameter("twtuserid", id) .SetParameter("email", emailid) .SetParameter("pass", password) .SetParameter("acctype", accounttype) .SetParameter("username", username) .SetParameter("couponCode", couponcode) .ExecuteUpdate(); transaction.Commit(); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } } } }
/// <updateTaskStatus> /// update Task Status /// </summary> /// <param name="TaskId">Task id.(guid)</param> /// <param name="UserId">User id.(Guid)</param> /// <param name="status">Status.(Bool)</param> public void updateTaskStatus(Guid TaskId, Guid UserId, bool status) { //Creates a database connection and opens up a session using (NHibernate.ISession session = SessionFactory.GetNewSession()) { //After Session creation, start Transaction. using (NHibernate.ITransaction transaction = session.BeginTransaction()) { try { //Proceed action, to get Task status and completion date by user id and task id. session.CreateQuery("Update Tasks set TaskStatus=:TaskStatus, CompletionDate=:completedate where Id = :taskid and UserId = :userid") .SetParameter("userid", UserId) .SetParameter("taskid", TaskId) .SetParameter("TaskStatus", status) .SetParameter("completedate", DateTime.Now) .ExecuteUpdate(); transaction.Commit(); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); // return 0; } } //End Transaction } //End Session }
/// <checkTaskExists> /// checkTaskExists /// </summary> /// <param name="TaskId">Task id.(String)</param> /// <param name="Userid">User id.(Guid)</param> /// <returns>True and False.(bool)</returns> public bool checkTaskExists(string TaskId, Guid Userid) { //Creates a database connection and opens up a session using (NHibernate.ISession session = SessionFactory.GetNewSession()) { //After Session creation, start Transaction. using (NHibernate.ITransaction transaction = session.BeginTransaction()) { try { //Proceed action, to get task details by userid and task id. NHibernate.IQuery query = session.CreateQuery("from Task where UserId = :userid and Id = :taskid"); query.SetParameter("userid", Userid); query.SetParameter("taskid", TaskId); var result = query.UniqueResult(); if (result == null) { return(false); } else { return(true); } } catch (Exception ex) { Console.WriteLine(ex.StackTrace); return(true); } } //End Transaction } //End Session }
//public ArrayList getAllTasksOfUser(Guid UserId) //{ // ArrayList alstTask = new ArrayList(); // try // { // //Creates a database connection and opens up a session // using (NHibernate.ISession session = SessionFactory.GetNewSession()) // { // //After Session creation, start Transaction. // using (NHibernate.ITransaction transaction = session.BeginTransaction()) // { // //Proceed action, to get all task of user. // NHibernate.IQuery query = session.CreateQuery("from Tasks where UserId = :UserId and AssignTaskTo !=:UserId"); // query.SetParameter("UserId", UserId); // query.SetParameter("UserId", UserId); // //query.SetParameter("GroupId", GroupId); // foreach (var item in query.Enumerable()) // { // alstTask.Add(item); // } // }//End Transaction // }//End Session // } // catch (Exception ex) // { // Console.WriteLine("Error : " + ex.StackTrace); // } // return alstTask; //} public ArrayList getAllTasksOfUser(Guid UserId) { ArrayList alstTask = new ArrayList(); try { //Creates a database connection and opens up a session using (NHibernate.ISession session = SessionFactory.GetNewSession()) { //After Session creation, start Transaction. using (NHibernate.ITransaction transaction = session.BeginTransaction()) { //Proceed action, to get all task of user. NHibernate.IQuery query = session.CreateQuery("from Tasks where UserId = :UserId "); query.SetParameter("UserId", UserId); query.SetParameter("UserId", UserId); //query.SetParameter("GroupId", GroupId); foreach (var item in query.Enumerable()) { alstTask.Add(item); } } //End Transaction } //End Session } catch (Exception ex) { Console.WriteLine("Error : " + ex.StackTrace); } return(alstTask); }
public ActionResult Create(Anexos anexo, HttpPostedFileBase file = null) { try { using (NHibernate.ISession session = NHibernateHelper.AbreSessao()) { if (file != null) { var arquivo = Request.Files[0]; var nomeArquivo = "Arq" + DateTime.Now.Millisecond.ToString() + ".pdf"; if (arquivo != null && arquivo.ContentLength() > 0) { anexo.Caminho_Arquivo = Path.Combine(dirArquivos, file.FileName); var path = Path.Combine(dirArquivos, Path.GetFileName(file.FileName)); arquivo.SaveAs(path); } } using (ITransaction transacao = session.BeginTransaction()) { session.Save(anexo); transacao.Commit(); } } return RedirectToAction(nameof(Index)); } catch { return View(); } }
public ActionResult Create(FormCollection collection) { try { Expense expense = new Expense(); expense.account = collection["title"].ToString(); expense.amount = Convert.ToInt32(collection["amount"]); expense.category = collection["category"].ToString(); expense.colorCode = collection["colorCode"].ToString(); expense.date = DateTime.Parse(collection["date"]); //expense.id = Convert.ToInt32(collection["id"]); expense.impulse = bool.Parse(collection["impulse"]); expense.memo = collection["memo"].ToString(); expense.payee = collection["payee"].ToString(); expense.repeat = bool.Parse(collection["repeat"]); using (ISession session = _nHibernateSession.OpenSession()) { using (ITransaction transaction = session.BeginTransaction()) { session.Save(expense); transaction.Commit(); } } return(RedirectToAction("Index")); } catch (Exception e) { return(View()); } }
public int UpdateQuery(GroupCampaign groupCamp) { using (NHibernate.ISession session = SessionFactory.GetNewSession()) { using (ITransaction transaction = session.BeginTransaction()) { var query = session.CreateQuery("Update GroupCampaign set Account=:Account,PicFilePath=:PicFilePath,VideoFilePath=:VideoFilePath,MessageFilepath=:MessageFilepath,ScheduleTime=:ScheduleTime,CmpStartTime=:CmpStartTime,Accomplish=:Accomplish,NoOfMessage=:NoOfMessage,MessageMode=:MessageMode,MessageType=:MessageType,TextMessage=:TextMessage where GroupCampaignName=:GroupCampaignName and Module =:module"); //session.SaveOrUpdate(groupCamp); query.SetParameter("GroupCampaignName", groupCamp.GroupCampaignName); query.SetParameter("Account", groupCamp.Account); query.SetParameter("PicFilePath", groupCamp.PicFilePath); query.SetParameter("VideoFilePath", groupCamp.VideoFilePath); query.SetParameter("MessageFilepath", groupCamp.MessageFilePath); query.SetParameter("ScheduleTime", groupCamp.ScheduleTime); query.SetParameter("CmpStartTime", groupCamp.CmpStartTime); query.SetParameter("Accomplish", groupCamp.Accomplish); query.SetParameter("NoOfMessage", groupCamp.NoOfMessage); query.SetParameter("MessageMode", groupCamp.MessageMode); query.SetParameter("MessageType", groupCamp.MessageType); query.SetParameter("TextMessage", groupCamp.TextMessage); query.SetParameter("module", groupCamp.Module); int res = query.ExecuteUpdate(); transaction.Commit(); return(res); } } }
public User getUserInfoByEmail(string emailId) { List <User> lstUser = new List <User>(); User user = new User(); using (NHibernate.ISession session = SessionFactory.GetNewSession()) { using (NHibernate.ITransaction transaction = session.BeginTransaction()) { try { lstUser = session.CreateQuery("from User u where u.EmailId = : email") .SetParameter("email", emailId).List <User>().ToList <User>(); user = lstUser[0]; } catch (Exception ex) { Console.WriteLine(ex.StackTrace); user = null; } } } return(user); }
public int UpdateUserExpiryDateById(User user) { int i = 0; try { using (NHibernate.ISession session = SessionFactory.GetNewSession()) { using (NHibernate.ITransaction transaction = session.BeginTransaction()) { try { i = session.CreateQuery("Update User set ExpiryDate=:expirydate, AccountType=:accounttype where Id = :id") .SetParameter("id", user.Id) .SetParameter("accounttype", user.AccountType) .SetParameter("expirydate", user.ExpiryDate) .ExecuteUpdate(); transaction.Commit(); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } } } } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } return(i); }
/// <deleteTask> /// Delete Task /// </summary> /// <param name="taskid">Task id.(String)</param> /// <param name="userid">User id.(Guid)</param> /// <returns>Return 1 for true and 0 for false.(int)</returns> public int deleteTask(string taskid, Guid userid) { //Creates a database connection and opens up a session using (NHibernate.ISession session = SessionFactory.GetNewSession()) { //After Session creation, start Transaction. using (NHibernate.ITransaction transaction = session.BeginTransaction()) { try { //Proceed action, to delete task by task id and user id. NHibernate.IQuery query = session.CreateQuery("delete from Task where Id = :taskid and UserId = :userid") .SetParameter("taskid", taskid) .SetParameter("userid", userid); int isUpdated = query.ExecuteUpdate(); transaction.Commit(); return(isUpdated); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); return(0); } } //End Transaction } //End Session }
public List <User> getAllUsers() { using (NHibernate.ISession session = SessionFactory.GetNewSession()) { using (NHibernate.ITransaction transaction = session.BeginTransaction()) { try { NHibernate.IQuery query = session.CreateQuery("from User where Id !=null"); List <User> alstUser = new List <User>(); foreach (User item in query.Enumerable()) { alstUser.Add(item); } return(alstUser); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); return(null); } } } }
/// <getTasksByUserwithDetail> /// Get Tasks By User with Detail /// </summary> /// <param name="USerId">User id.(Guid)</param> /// <param name="days">Number of Days.(int)</param> /// <returns>Return values in the form of array list.(ArrayList)</returns> public ArrayList getTasksByUserwithDetail(Guid USerId, int days, Guid GroupId) { //Creates a database connection and opens up a session using (NHibernate.ISession session = SessionFactory.GetNewSession()) { //After Session creation, start Transaction. using (NHibernate.ITransaction transaction = session.BeginTransaction()) { //Proceed action, to get details of task. //ts.UserId=:userid and //.SetParameter("userid", USerId) //var queryString = @"SELECT * FROM Tasks ts LEFT JOIN User u on ts.AssignTaskTo=u.Id where ts.UserId=:userid and AssignDate>=DATE_ADD(NOW(),INTERVAL -" + days + " DAY)"; //var queryString = @"SELECT * FROM Tasks ts LEFT JOIN User u on ts.AssignTaskTo=u.Id where ts.GroupId=:GroupId and AssignDate>=DATE_ADD(NOW(),INTERVAL -" + days + " DAY)"; try { var queryString = @"select * from tasks where (AssignTaskTo =:userid or UserId =:userid) and GroupId =:GroupId and AssignDate>=DATE_ADD(NOW(),INTERVAL -" + days + " DAY)"; var query = session.CreateSQLQuery(queryString) .SetParameter("userid", USerId) .SetParameter("GroupId", GroupId); //.SetParameter("GroupId", GroupId); ArrayList alstTask = new ArrayList(); foreach (var item in query.List()) { alstTask.Add(item); } return(alstTask); } catch (Exception) { throw; } } //End Transaction } //End Session }
public int UpdatePaymentStatusByUserId(User user) { int i = 0; try { using (NHibernate.ISession session = SessionFactory.GetNewSession()) { using (NHibernate.ITransaction transaction = session.BeginTransaction()) { try { i = session.CreateQuery("Update User set PaymentStatus=:paymentStatus where Id = :userid") .SetParameter("userid", user.Id) .SetParameter("paymentStatus", user.PaymentStatus) .ExecuteUpdate(); transaction.Commit(); } catch { } } } } catch (Exception ex) { Console.WriteLine("Error : " + ex.StackTrace); } return(i); }
public List <Domain.Socioboard.Domain.Tasks> getAllTasksOfUserBYDays(Guid Userid, Guid GroupId, int days) { List <Domain.Socioboard.Domain.Tasks> alstTask = new List <Domain.Socioboard.Domain.Tasks>(); try { //Creates a database connection and opens up a session using (NHibernate.ISession session = SessionFactory.GetNewSession()) { //After Session creation, start Transaction. using (NHibernate.ITransaction transaction = session.BeginTransaction()) { DateTime AssignDate = DateTime.Now; string AssinDate = AssignDate.AddDays(-days).ToString("yyyy-MM-dd HH:mm:ss"); //Proceed action, to get all task of user. //NHibernate.IQuery query = session.CreateQuery("from Tasks where (UserId = :Userid or AssignTaskTo =:Userid) and GroupId =:GroupId and AssignDate>=DATE_ADD(NOW(),INTERVAL -" + days + " DAY)"); NHibernate.IQuery query = session.CreateQuery("from Tasks where UserId = :Userid and GroupId =:GroupId and AssignDate>=:AssinDate"); query.SetParameter("Userid", Userid); query.SetParameter("GroupId", GroupId); query.SetParameter("AssinDate", AssinDate); foreach (var item in query.Enumerable()) { alstTask.Add((Domain.Socioboard.Domain.Tasks)item); } } //End Transaction } //End Session } catch (Exception ex) { Console.WriteLine("Error : " + ex.StackTrace); } return(alstTask); }
//public int ResetPassword(Guid id, string password) //{ // using (NHibernate.ISession session = SessionFactory.GetNewSession()) // { // using (NHibernate.ITransaction transaction = session.BeginTransaction()) // { // try // { // int i = session.CreateQuery("Update User set Password =:pass where Id = :userid") // .SetParameter("userid", id) // .SetParameter("pass", password) // .ExecuteUpdate(); // transaction.Commit(); // return i; // } // catch (Exception ex) // { // Console.WriteLine(ex.StackTrace); // return 0; // } // } // } //} public List <User> GetAllUsersByCreateDate(string date) { List <User> alstUser = new List <User>(); try { using (NHibernate.ISession session = SessionFactory.GetNewSession()) { using (NHibernate.ITransaction transaction = session.BeginTransaction()) { try { alstUser = session.CreateQuery("from User where CreateDate < '2014-02-10' order by CreateDate desc").List <User>().ToList <User>(); //.SetParameter("date", date).List<User>().ToList<User>(); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); return(null); } } } } catch (Exception ex) { Console.WriteLine("Error : " + ex.StackTrace); } return(alstUser); }
/// <updateTask> /// Update Task /// </summary> /// <param name="task">Set Values in a Tasks Class Property and Pass the Object of Tasks Class.(Domein.Tasks)</param> public void updateTask(Domain.Socioboard.Domain.Tasks task) { //Creates a database connection and opens up a session using (NHibernate.ISession session = SessionFactory.GetNewSession()) { //After Session creation, start Transaction. using (NHibernate.ITransaction transaction = session.BeginTransaction()) { try { //Proceed action, to update task session.CreateQuery("Update Tasks set TaskMessage =:TaskMessage,UserId =:UserId,AssignTaskTo =:AssignTaskTo,TaskStatus=:TaskStatus,AssignDate=:AssignDate where Id = :taskid and UserId = :userid") .SetParameter("TaskMessage", task.TaskMessage) .SetParameter("UserId", task.UserId) .SetParameter("AssignTaskTo", task.AssignTaskTo) .SetParameter("TaskStatus", task.TaskStatus) .SetParameter("AssignDate", task.AssignDate) .SetParameter("taskid", task.Id) .SetParameter("userid", task.UserId) .ExecuteUpdate(); transaction.Commit(); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); // return 0; } } //End Transaction } //End Session }
public int UpdateReferenceUserByUserId(User user) { int i = 0; try { using (NHibernate.ISession session = SessionFactory.GetNewSession()) { using (NHibernate.ITransaction transaction = session.BeginTransaction()) { try { i = session.CreateQuery("Update User set ReferenceStatus =:referenceStatus where Id = :id") .SetParameter("referenceStatus", user.ReferenceStatus) .SetParameter("id", user.Id) .ExecuteUpdate(); transaction.Commit(); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } } } } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } return(i); }
public int UpdateCreatDateByUserId(User user) { int i = 0; try { using (NHibernate.ISession session = SessionFactory.GetNewSession()) { using (NHibernate.ITransaction transaction = session.BeginTransaction()) { try { i = session.CreateQuery("Update User set CreateDate =:createDate, AccountType =: accountType , PaymentStatus=:paymentStatus where Id = :id") .SetParameter("createDate", user.CreateDate) .SetParameter("accountType", user.AccountType) .SetParameter("paymentStatus", user.PaymentStatus) .SetParameter("id", user.Id) .ExecuteUpdate(); transaction.Commit(); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } } } } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } return(i); }
/// <getResultsFromKeyword> /// Get result from database by keyword /// </summary> /// <param name="keyword">Keyword of DiscoverySearch(string)</param> /// <returns>List of all results by Keyword</returns> public List <Domain.Socioboard.Domain.DiscoverySearch> getResultsFromKeyword(string keyword) { //Creates a database connection and opens up a session using (NHibernate.ISession session = SessionFactory.GetNewSession()) { //After Session creation, start Transaction. using (NHibernate.ITransaction transaction = session.BeginTransaction()) { try { //proceed action to get all results by Keyword. List <Domain.Socioboard.Domain.DiscoverySearch> lst = session.CreateQuery("from DiscoverySearch where SearchKeyword = :keyword") .SetParameter("keyword", keyword) .List <Domain.Socioboard.Domain.DiscoverySearch>() .ToList <Domain.Socioboard.Domain.DiscoverySearch>(); #region Oldcode //foreach (DiscoverySearch item in query.Enumerable()) //{ // lst.Add(item); //} #endregion return(lst); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); return(null); } } //End Transaction } //End session }
public bool IsUserExist(string Emailid) { using (NHibernate.ISession session = SessionFactory.GetNewSession()) { using (NHibernate.ITransaction transaction = session.BeginTransaction()) { try { NHibernate.IQuery query = session.CreateQuery("from User u where u.EmailId = : email"); query.SetParameter("email", Emailid); var result = query.UniqueResult(); if (result == null) { return(false); } else { return(true); } } catch (Exception ex) { Console.WriteLine(ex.StackTrace); return(true); } } } }
public System.Collections.Generic.IList <EventoEN> ReadAllDefault(int first, int size, NHibernate.ISession session) { System.Collections.Generic.IList <EventoEN> result = null; try { using (ITransaction tx = session.BeginTransaction()) { if (size > 0) { result = session.CreateCriteria(typeof(EventoEN)). SetFirstResult(first).SetMaxResults(size).List <EventoEN>(); } else { result = session.CreateCriteria(typeof(EventoEN)).List <EventoEN>(); } } } catch (Exception ex) { SessionRollBack(); if (ex is NuevoInmueblateGenNHibernate.Exceptions.ModelException) { throw ex; } throw new NuevoInmueblateGenNHibernate.Exceptions.DataLayerException("Error in EventoCAD.", ex); } return(result); }
public int ChangePassword(string newpassword, string oldpassword, string Emailid) { using (NHibernate.ISession session = SessionFactory.GetNewSession()) { using (NHibernate.ITransaction transaction = session.BeginTransaction()) { try { //NHibernate.IQuery query = session.CreateQuery("Update User set Password=:password where EmailId = :email and Password = :oldpass"); //query.SetParameter("email", Emailid); //query.SetParameter("oldpass",oldpassword); //query.SetParameter("password",newpassword); //query.ExecuteUpdate(); int i = session.CreateQuery("Update User set Password=:password where EmailId = :email and Password = :oldpass") .SetParameter("email", Emailid) .SetParameter("oldpass", oldpassword) .SetParameter("password", newpassword) .ExecuteUpdate(); transaction.Commit(); return(i); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); return(0); } } } }