public OrderDetail Save(OrderDetail orderDetail) { var orderDetailRepo = Mapper.Map <OrderDetailRepo>(orderDetail); NH.Run(s => s.SaveOrUpdate(orderDetailRepo)); return(Mapper.Map <OrderDetail>(orderDetailRepo)); }
public Album Save(Album album) { var albumRepo = Mapper.Map <AlbumRepo>(album); NH.Run(s => s.SaveOrUpdate(albumRepo)); return(Mapper.Map <Album>(albumRepo)); }
public Artist Save(Artist artist) { var artistRepo = Mapper.Map <ArtistRepo>(artist); NH.Run(s => s.SaveOrUpdate(artistRepo)); return(Mapper.Map <Artist>(artistRepo)); }
public Cart Save(Cart cart) { var artistRepo = Mapper.Map <CartRepo>(cart); NH.Run(s => s.SaveOrUpdate(cart)); return(Mapper.Map <Cart>(artistRepo)); }
public List <Driver> GetActiveDrivers() { using (var session = NH.OpenSession()) { return(session.Query <Driver>().Where(x => x.Drv_Timing >= DateTime.Now.AddMinutes(-30)).ToList()); } }
public Order Save(Order genre) { var orderRepo = Mapper.Map <OrderRepo>(genre); NH.Run(s => s.SaveOrUpdate(orderRepo)); return(Mapper.Map <Order>(orderRepo)); }
public Driver Login(LoginBody loginBody) { using (ISession session = NH.OpenSession()) { try { var _password = session.CreateSQLQuery($"select Drv_Password from dbo.Drivers where Drv_Ident={loginBody.ident}").UniqueResult <string>(); Log(_password); var check = loginBody.password == _password;//BCrypt.Net.BCrypt.CheckPassword(loginBody.password, _password); if (check) { return(session.Query <Driver>().FetchMany(x => x.OpinionList) .Where(x => x.Drv_Identity == loginBody.ident).FirstOrDefault()); } else { return(null); } // return result;//result.FirstOrDefault(); } catch (Exception e) { Log(e.Message); return(null); } } }
public bool Register(RegisterBody registerBody) { using (var session = NH.OpenSession()) { if (session.Query <Driver>().Where(x => x.Drv_Identity == registerBody.driver.Drv_Identity).FirstOrDefault() != null) { return(false); } else { try { using (var trans = session.BeginTransaction()) { var driv = registerBody.driver; session.CreateSQLQuery($"insert into dbo.drivers(Drv_Name,Drv_Surname,Drv_Identity,Drv_Password,Drv_Phone) values ('{driv.Drv_Name}','{driv.Drv_Surname}','{driv.Drv_Identity}','','{driv.Drv_Phone}')").ExecuteUpdate(); trans.Commit(); } session.CreateSQLQuery($"update dbo.drivers set Drv_Password='******'").ExecuteUpdate(); return(true); } catch (Exception e) { Log(e.Message); return(false); } } } }
public Genre Save(Genre genre) { var genreRepo = Mapper.Map <GenreRepo>(genre); NH.Run(s => s.SaveOrUpdate(genreRepo)); return(Mapper.Map <Genre>(genreRepo)); }
public void MedianTest() { var median = NH.Median <int>(input); var median3 = NH.Median <int>(input3); var median4 = NH.Median <int>(input4); var median5 = NH.Median <int>(input5); //DebugLogger.Instance.WriteLine(median); }
public bool Locate(LocateBody locateBody)//string ident, decimal lat, decimal lng) { try { using (var session = NH.OpenSession()) { session.CreateSQLQuery($"update dbo.drivers set Drv_Latitude={locateBody.lat},Drv_Longitude={locateBody.lng},Drv_Timing={DateTime.Now} where Drv_Ident={locateBody.ident}").ExecuteUpdate(); } return(true); } catch { return(false); } }
/// <summary> /// 保存关系WF_NodePage /// </summary> public ActionResult SaveRelation_NodePage(int NodeID, List <string> PageIDS) { foreach (var item in PageIDS) { var entity = NH.GetSession <WF_Node>().QueryOver <WF_NodePage>().Where(x => x.PageID == item && x.NodeID == NodeID).List().FirstOrDefault(); if (entity == null) { entity = new WF_NodePage() { NodeID = NodeID, PageID = item }; entity.Save(); } } return(Json(new { success = true })); }
/// <summary> /// 保存关系WF_NodeEmp /// </summary> public ActionResult SaveRelation_NodeEmp(int FK_Node, List <string> FK_EmpS) { foreach (var item in FK_EmpS) { var entity = NH.GetSession <WF_Node>().QueryOver <WF_NodeEmp>().Where(x => x.FK_Emp == item && x.FK_Node == FK_Node).List().FirstOrDefault(); if (entity == null) { entity = new WF_NodeEmp() { FK_Node = FK_Node, FK_Emp = item }; entity.Save(); } } return(Json(new { success = true })); }
/// <summary> /// 保存关系Auth_Rlt_UserRole /// </summary> public ActionResult SaveRelation_UserRole(string RoleID, List <string> UserIDS) { foreach (var item in UserIDS) { var entity = NH.GetSession <Auth_Role>().QueryOver <Auth_Rlt_UserRole>().Where(x => x.UserID == item && x.RoleID == RoleID).List().FirstOrDefault(); if (entity == null) { entity = new Auth_Rlt_UserRole() { RoleID = RoleID, UserID = item }; entity.Save(); } } return(Json(new { success = true })); }
/// <summary> /// 保存关系Auth_Rlt_RoleAuthorization /// </summary> public ActionResult SaveRelation_RoleAuthorization(string AuthorizationID, List <string> RoleIDS) { foreach (var item in RoleIDS) { var entity = NH.GetSession <Auth_Authorization>().QueryOver <Auth_Rlt_RoleAuthorization>().Where(x => x.RoleID == item && x.AuthorizationID == AuthorizationID).List().FirstOrDefault(); if (entity == null) { entity = new Auth_Rlt_RoleAuthorization() { AuthorizationID = AuthorizationID, RoleID = item }; entity.Save(); } } return(Json(new { success = true })); }
/// <summary> /// 保存 /// </summary> /// <returns></returns> public ActionResult SaveDirection() { try { var entity = GetUpdateModel(null, "MYPK"); var list = NH.GetSession <WF_Direction>().QueryOver <WF_Direction>().Where(x => x.MyPK == entity.MyPK).List(); if (list.Count > 0) { throw new Exception("重复的连接线!"); } entity.SaveOrUpdate(); return(Json(new { success = true, entity = entity })); } catch (Exception ex) { return(Json(new { success = false, msg = "保存失败!" + ex.Message, error = JsonConvert.SerializeObject(ex) })); } }
public bool AddOpinion(Opinion opinion) { using (ISession session = NH.OpenSession()) { try { using (var transaction = session.BeginTransaction()) { session.Save(opinion); transaction.Commit(); } return(true);//result.FirstOrDefault(); } catch { return(false); } } }
public ActionResult LoadMyForm(string FK_Flow, int NodeID, int ToNodeID) { var entity = NH.GetSession <WF_Cond>().QueryOver <WF_Cond>().Where(x => x.NodeID == NodeID && x.ToNodeID == ToNodeID).List().FirstOrDefault(); if (entity == null) { entity = new WF_Cond() { FK_Flow = FK_Flow, NodeID = NodeID, ToNodeID = ToNodeID, CondType = (int)BP.WF.Template.CondType.Dir, DataFrom = (int)BP.WF.Template.ConnDataFrom.Paras, FK_Operator = "=", ConnJudgeWay = 0, PRI = 0, CondOrAnd = 0 }; } return(Json_Get(entity)); }
protected override string GetColumnName(NH.PropertyPath subject) { return GetBaseColumnName(subject) + "Id"; }
public IList <Artist> GetList() { return(Mapper.Map <IList <Artist> >(NH.Select(s => s.QueryOver <ArtistRepo>().List()))); }
public OrderDetail GetById(long id) { return(Mapper.Map <OrderDetail>(NH.Select(s => s.Get <OrderDetail>(id)))); }
public void Delete(Artist artist) { NH.Run(s => s.Delete(Mapper.Map <ArtistRepo>(artist))); }
public Artist GetById(long id) { return(Mapper.Map <Artist>(NH.Select(s => s.Get <AlbumRepo>(id)))); }
public Genre GetById(long id) { return(Mapper.Map <Genre>(NH.Select(s => s.Get <GenreRepo>(id)))); }
public void Delete(Genre genre) { NH.Run(s => s.Delete(Mapper.Map <GenreRepo>(genre))); }
protected override string GetIndexColumnName(NH.PropertyPath subject) { return base.GetIndexColumnName(subject).Underscore(); }
public IList <Genre> GetList() { var genreList = Mapper.Map <IList <Genre> >(NH.Select(s => s.QueryOver <GenreRepo>().List())); return(genreList.OrderBy(a => a.Name).ToList()); }
public void Median2Test() { var median = NH.Median2 <double>(input2); //DebugLogger.Instance.WriteLine(median); }
static TaxiService() { NH.Init("Server = KAROL-PC\\KAROLSERV; Database = RestDB; User Id = sa; Password = admin"); }
public void Delete(Order order) { NH.Run(s => s.Delete(Mapper.Map <OrderRepo>(order))); }
public IList <Order> GetList() { return(Mapper.Map <IList <Order> >(NH.Select(s => s.QueryOver <OrderRepo>().List()))); }
public Order GetById(long id) { return(Mapper.Map <Order>(NH.Select(s => s.Get <OrderRepo>(id)))); }