public void Update(User obj) { using (ProjectEntities db = new ProjectEntities()) { db.Users.Attach(obj); db.Entry(obj).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } }
public JsonResult <List <Models.ProjectDetails> > GetAllProjectDetailsSorted(string sortBy, bool ascending) { List <DataAccessLayer.ProjectDetail> prodList = ProjectEntities.GetAllProjects().AsQueryable().OrderByPropertyName(sortBy, ascending).ToList(); var result = new List <DataAccessLayer.ProjectDetail>(); var projectObject = Mapper.Map <List <DataAccessLayer.ProjectDetail>, List <Models.ProjectDetails> >(prodList); return(Json(projectObject)); }
public void Delete(User_Book obj) { using (ProjectEntities db = new ProjectEntities()) { db.User_Book.Attach(obj); db.User_Book.Remove(obj); db.SaveChanges(); } }
//הפונקציה בודקת האם למיקום הזה יש למשתמש חנות קרובה עבור אחת מהקטגוריות public static WebResult <List <SearchInShop> > CheckDistance(UserIdWithLocation userIdWithLocation) { using (ProjectEntities db = new ProjectEntities()) { List <SearchInShop> searchesFound = new List <SearchInShop>(); double lat = userIdWithLocation.Lat; double lng = userIdWithLocation.Lng; var codeUser = db.Users.First(f => f.passwordUser == userIdWithLocation.Uuid).codeUser; foreach (var search in db.Searches) { //only if the search is from this user and its status is 0, to find if (search.codeUser == codeUser && search.status == 0) { foreach (var shop in db.Shops) { //if distance is less than 1000 meter if (getDistance(lat, lng, shop.latitude, shop.longitude) < search.distance) { //if there is the category that the user search in that shop if (Casting.ShopCast.GetShopDTO(shop).Categories.FirstOrDefault(f => f.codeCategory == search.codeCategory) != null) { TimeSpan fromHour = TimeSpan.MinValue, toHour = TimeSpan.MaxValue; TimeSpan now = DateTime.Now.TimeOfDay; //if shop is opened if (shop.fromHour != null && shop.toHour != null) { fromHour = TimeSpan.Parse(shop.fromHour); toHour = TimeSpan.Parse(shop.toHour); } if (fromHour < now && toHour > now) { searchesFound.Add(new SearchInShop() { CodeSearch = search.codeSearch, NameProduct = search.nameProduct, AddressString = shop.addressString, NameShop = shop.nameShop, PhoneShop = shop.phoneShop, MailShop = shop.mailShop, FromHour = shop.fromHour, ToHour = shop.toHour }); } } } } } } return(new WebResult <List <SearchInShop> >() { Status = true, Message = "return searches found", Value = searchesFound }); } }
public ActionResult LecturerReg() { using (var db = new ProjectEntities()) { ViewBag.courseID = new SelectList(db.Courses.ToList(), "courseID", "course_title"); ViewBag.lecturerID = new SelectList(db.Lecturers.ToList(), "lecturerID", "lecturer_name"); return(View()); } }
public User_Book Insert(User_Book obj) { using (ProjectEntities db = new ProjectEntities()) { db.User_Book.Add(obj); db.SaveChanges(); return(obj); } }
public ActionResult CourseReg() { using (var db = new ProjectEntities()) { ViewBag.courseID = new SelectList(db.Courses.ToList(), "courseID", "course_title"); ViewBag.studentID = new SelectList(db.Students.ToList(), "studentID", "student_name"); return(View()); } }
/// <summary> /// 执行原始SQL命令 /// </summary> /// <param name="commandText">SQL命令</param> /// <param name="parameters">参数</param> /// <returns>影响的记录数</returns> public Object[] ExecuteSqlNonQuery <T>(string commandText, params Object[] parameters) { using (ProjectEntities context = new ProjectEntities()) { var results = context.Database.SqlQuery <T>(commandText, parameters); results.Single(); return(parameters); } }
public static List <Subject> GetSubjects() { using (ProjectEntities db = new ProjectEntities()) { List <Subject> sbList = db.Subject.ToList(); return(sbList); } }
public void DeleteProject(ProjectModel model) { using (var db = new ProjectEntities()) { var deleteProject = db.UserProjects.Where(x => x.ID == model.ProjectID).First(); db.UserProjects.Remove(deleteProject); db.SaveChanges(); } }
// GET: Logs public ActionResult Index(int?id) { using (var db = new ProjectEntities()) { Attendance attendance = new Attendance(); var getDate = DateTime.Now.ToLongDateString(); var getCurrent = db.Attendances.Include(a => a.Course).Include(a => a.Student).Where(a => a.date == getDate && a.courseID == id); return(View(getCurrent.ToList())); } }
public static long ChangeStateByProjectId(long projectId, int stateId) { using (ProjectEntities db = new ProjectEntities()) { Proj_Project pr = db.Proj_Project.SingleOrDefault(p => p.ProjectID == projectId); pr.StateID = stateId;//项目状态变更 db.SaveChanges(); return(1); } }
/// <summary> /// 记录成员在项目中的成绩 /// </summary> /// <param name="mId"></param> /// <param name="score"></param> /// <returns></returns> public static long UpdateMemberScore(long mId, float score) { using (ProjectEntities db = new ProjectEntities()) { Proj_Member pm = db.Proj_Member.SingleOrDefault(p => p.MemberID == mId); pm.Score = score; db.SaveChanges(); return(1); } }
/// <summary> /// 获取参加过项目的所有成员,从视图Proj_VUserScore /// </summary> /// <returns></returns> public static long[] GetProjUser() { using (ProjectEntities db = new ProjectEntities()) { List <Proj_VUserScore> psList = db.Proj_VUserScore.ToList(); long[] ArrUserId = psList.Select(ps => ps.UserID).Distinct().ToArray(); return(ArrUserId); } }
public JsonResult <List <Models.ProjectDetails> > GetAllProjectDetails() { List <DataAccessLayer.ProjectDetail> projectList = ProjectEntities.GetAllProjects(); List <Models.ProjectDetails> projects = new List <Models.ProjectDetails>(); List <Models.ProjectDetails> projectObj = Mapper.Map <List <DataAccessLayer.ProjectDetail>, List <Models.ProjectDetails> >(projectList); return(Json(projectObj)); }
//Returns history of the searches, even thouse the user found public static WebResult <List <SearchDetailsForUser> > GetHistory(string passwordUser) { using (ProjectEntities db = new ProjectEntities()) { string pass = passwordUser; User CurrentUser = db.Users.FirstOrDefault(f => f.passwordUser == pass); if (CurrentUser == null) { return(new WebResult <List <SearchDetailsForUser> > { Message = "the user cant find!", Value = null, Status = false }); } List <SearchDetailsForUser> searchesForUser = new List <SearchDetailsForUser>(); var searches = SearchCast.GetSearchesDTO(db.Searches.ToList()); foreach (var search in searches) { if (search.codeUser == CurrentUser.codeUser && search.status != EStatus.Deleted) { searchesForUser.Add(new SearchDetailsForUser() { CodeSearch = search.codeSearch, NameProduct = search.nameProduct, nameCategory = db.Categories.First(f => f.codeCategory == search.codeCategory).nameCategory, Status = search.status, dateStart = search.dateStart, dateEnd = search.dateEnd, codeShop = search.codeShop, nameShop = search.codeShop == null ? "" : db.Shops.First(f => f.codeShop == search.codeShop).nameShop, IsFavoriteShop = search.codeShop == null ? null : db.Shops.First(f => f.codeShop == search.codeShop).isFavorite }); } } string queryString = @" UPDATE Shops SET Shops.isFavorite = 1 FROM Shops INNER JOIN Searches ON Shops.codeShop = Searches.codeShop "; int effected = db.Database.ExecuteSqlCommand(queryString); searchesForUser.Reverse(); return(new WebResult <List <SearchDetailsForUser> > { Message = "חיפושי המשתמש נשלחו בהצלחה", Value = searchesForUser, Status = true }); } }
/// <summary> /// 成员退出 /// </summary> /// <param name="mId"></param> /// <param name="outReason"></param> /// <returns></returns> public static long SetMemberOut(long mId, string outReason) { using (ProjectEntities db = new ProjectEntities()) { Proj_Member pm = db.Proj_Member.SingleOrDefault(p => p.MemberID == mId); pm.OutReason = outReason; pm.ApplyOutTime = DateTime.Now; db.SaveChanges(); return(1); } }
//Update shop with categories public static WebResult <ShopDTO> Update(ShopDTO shopDTO) { using (ProjectEntities db = new ProjectEntities()) { Shop shop = db.Shops.FirstOrDefault(f => f.mailShop == shopDTO.mailShop); //למייל אסור להשתנות if (shop == null) { return new WebResult <ShopDTO> { Message = "החנות לא נמצאה", Status = false, Value = null } } ; shop.nameShop = shopDTO.nameShop; shop.phoneShop = shopDTO.phoneShop; shop.latitude = shopDTO.latitude; shop.longitude = shopDTO.longitude; shop.fromHour = shopDTO.fromHour; shop.toHour = shopDTO.toHour; shop.addressString = shopDTO.addressString; List <CategoryDTO> sourceCats = shopDTO.Categories; //למחוק קודם את כל הקטגוריות של החנות List <Category_to_shop> category_To_Shops = db.Category_to_shop.ToList(); category_To_Shops.ForEach(item => { if (item.codeShop == shop.codeShop) { db.Category_to_shop.Remove(item); } }); db.SaveChanges(); // להוסיף את כל הקטגוריות החדשות לחנות foreach (var item in sourceCats) { db.Category_to_shop.Add(new Category_to_shop() { codeCategory = item.codeCategory, codeShop = shop.codeShop }); } db.SaveChanges(); return(new WebResult <ShopDTO> { Message = "הנתונים התעדכנו בהצלחה", Value = shopDTO, Status = true }); } }
public static long UpdateProjectsMatch(long MatchID, int IsAccetpted) { using (ProjectEntities db = new ProjectEntities()) { Proj_Match pr = db.Proj_Match.SingleOrDefault(p => p.MatchID == MatchID); pr.IsAccepted = IsAccetpted; pr.AcceptedTime = DateTime.Now; db.SaveChanges(); } return(1); }
public static int ApproveNewRole(UserRole dr)//为用户审批新角色 { using (var db = new ProjectEntities()) { UserRole ur = db.UserRole.FirstOrDefault(r => r.UserRoleID == dr.UserRoleID); ur.StateID = dr.StateID;//-1拒绝,1同意 ur.Approved = dr.Approved; ur.ApprovedBy = dr.ApprovedBy; db.SaveChanges(); return(1); } }
/// <summary> /// 删除项目 /// </summary> /// <param name="dr"></param> /// <param name="delBy"></param> /// <param name="closedTime"></param> /// <returns></returns> public static long DelProjectById(Proj_Project dr, long delBy, DateTime closedTime) { using (ProjectEntities db = new ProjectEntities()) { Proj_Project pr = db.Proj_Project.SingleOrDefault(p => p.ProjectID == dr.ProjectID); pr.ModifiedBy = delBy; pr.ModifyTime = closedTime; pr.Flag = 0;//项目删除 db.SaveChanges(); return(1); } }
/// <summary> /// Loads all tables into the context. /// </summary> public void LoadTablesIntoContext() { ProjectEntities.Load(); PersonEntities.Load(); ExpertEntities.Load(); EventTreeEntities.Load(); TreeEventEntities.Load(); ExpertClassEstimationEntities.Load(); FragilityCurveElementEntities.Load(); TreeEventFragilityCurveElementEntities.Load(); HydraulicConditionElementEntities.Load(); }
/// <summary> /// 变更项目状态(项目状态:0.未启动;1.进行中;2.已结束;3. 已转化;4.延期;5.暂停;-1.关闭) /// </summary> /// <param name="projectId">项目ID</param> /// <param name="stateId">状态参数</param> /// <param name="changedBy">状态变更人</param> /// <param name="changedTime">状态变更时间</param> /// <returns></returns> public static long ChangeStateByProjectId(long projectId, int stateId, long changedBy, DateTime changedTime) { using (ProjectEntities db = new ProjectEntities()) { Proj_Project pr = db.Proj_Project.SingleOrDefault(p => p.ProjectID == projectId); pr.ModifiedBy = changedBy; pr.ModifyTime = changedTime; pr.StateID = stateId;//项目状态变更 db.SaveChanges(); return(1); } }
//Returns the categories for choosing public static WebResult <List <CategoryDTO> > GetAllCategories() { using (ProjectEntities db = new ProjectEntities()) { return(new WebResult <List <CategoryDTO> > { Message = "רשימת קטגוריות כללית נשלחה בהצלחה", Value = CategoryCast.GetCategoriesDTO(db.Categories.ToList()), Status = true }); } }
//Register public async static Task <WebResult <LoginData <ShopDTO> > > Register(ShopDTO shopDto, Uri request) { using (ProjectEntities db = new ProjectEntities()) { if (db.Shops.FirstOrDefault(w => w.passwordShop == shopDto.passwordShop) != null || db.Shops.FirstOrDefault(w => w.mailShop == shopDto.mailShop) != null)//אם יש כבר כזה מייל או כזו סיסמה { return new WebResult <LoginData <ShopDTO> > { Message = "אחד מהפרטים שהוקשו כבר קיים במערכת", Status = false, Value = null } } ; List <CategoryDTO> sourceCats = shopDto.Categories; List <Category_to_shop> category_To_Shops = new List <Category_to_shop>(); foreach (var item in sourceCats) { db.Category_to_shop.Add(new Category_to_shop() { codeCategory = item.codeCategory, codeShop = shopDto.codeShop }); } db.Shops.Add(ShopCast.GetShop(shopDto)); if (db.SaveChanges() > 0)//בדיקה שהמידע נשמר { var accessToken = await GetTokenDataAsync(shopDto.mailShop, shopDto.passwordShop, request); if (!string.IsNullOrEmpty(accessToken)) { return(new WebResult <LoginData <ShopDTO> > { Status = true, Message = "התחברת בהצלחה", Value = new LoginData <ShopDTO> { TokenJson = accessToken, objectDTO = shopDto } }); } } return(new WebResult <LoginData <ShopDTO> > { Status = false, Message = "ההרשמה נכשלה", Value = null }); } }
public JsonResult <Models.ProjectDetails> GetProjectDetail(int id) { var ProjectEntitiesInfo = ProjectEntities.GetProject(id); var project = new Models.ProjectDetails(); Models.ProjectDetails obj = Mapper.Map <DataAccessLayer.ProjectDetail, Models.ProjectDetails>(ProjectEntitiesInfo); var managerInfo = UserEntities.GetUsers((int)ProjectEntitiesInfo.ManagerId); obj.Manager = Mapper.Map <DataAccessLayer.User, Models.User>(managerInfo); return(Json <Models.ProjectDetails>(obj)); }
public bool InsertProjectDetail(Models.ProjectDetails projectDetails) { bool status = false; if (ModelState.IsValid) { projectDetails.Id = ProjectEntities.GetMaxProjectId() + 1; var projectDetailsObj = Mapper.Map <Models.ProjectDetails, DataAccessLayer.ProjectDetail>(projectDetails); status = ProjectEntities.InsertProjectDetail(projectDetailsObj); } return(status); }
public ActionResult StaffRegistration(Lecturer lecturer) { using (var _context = new ProjectEntities()) { if (ModelState.IsValid) { _context.Lecturers.Add(lecturer); _context.SaveChanges(); return(RedirectToAction("StaffList")); } } return(View()); }
public ActionResult StudentRegistration(Student student) { using (var _context = new ProjectEntities()) { if (ModelState.IsValid) { _context.Students.Add(student); _context.SaveChanges(); return(RedirectToAction("Students")); } } return(View()); }
public static CategoryDTO GetCategoryDTO(Category category) { using (ProjectEntities db = new ProjectEntities()) { List <int> codesShops = db.Category_to_shop.Where(c => c.codeCategory == category.codeCategory).Select(x => x.codeShop).ToList(); return(new CategoryDTO() { codeCategory = category.codeCategory, nameCategory = category.nameCategory }); } }