public IHttpActionResult PutTinhThanhPho(string id, TinhThanhPho tinhThanhPho) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != tinhThanhPho.TinhThanhPho_ID) { return(BadRequest()); } db.Entry(tinhThanhPho).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!TinhThanhPhoExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public IHttpActionResult PutDonHang(string id, DonHang donHang) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != donHang.SoHieu) { return(BadRequest()); } db.Entry(donHang).State = EntityState.Modified; try { //Update loại hàng UpdateLoaiHang(donHang.LoaiHang_Name); db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!DonHangExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public IHttpActionResult PutNhanVien(string id, NhanVien nhanVien) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != nhanVien.NhanVien_ID) { return(BadRequest()); } db.Entry(nhanVien).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!NhanVienExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public IHttpActionResult PutAspNetUsers(string id, AspNetUsers aspNetUsers) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != aspNetUsers.Id) { return(BadRequest()); } db.Entry(aspNetUsers).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!AspNetUsersExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public IHttpActionResult PutKhachHang(string id, KhachHang khachHang) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != khachHang.KhachHang_ID) { return(BadRequest()); } db.Entry(khachHang).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!KhachHangExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public ActionResult AddToMyFav(int?newsID, int?videosID) { if (newsID != null) { if (!database.Favorites.Any(i => i.NewsID == newsID && i.Username == HttpContext.User.Identity.Name)) { database.Favorites.Add(new Favorites { NewsID = newsID, Username = HttpContext.User.Identity.Name }); database.SaveChanges(); return(Json(new { msg = "ثبت خبر با موفقیت انجام شد" })); } else { return(Json(new { msg = "این خبر قبلا در لیست علاقمندی ها ثبت شده است" })); } } if (videosID != null) { if (!database.Favorites.Any(i => i.VideosID == videosID && i.Username == HttpContext.User.Identity.Name)) { database.Favorites.Add(new Favorites { VideosID = videosID, Username = HttpContext.User.Identity.Name }); database.SaveChanges(); return(Json(new { msg = "ثبت ویدیو با موفقیت انجام شد" })); } else { return(Json(new { msg = "این ویدیو قبلا در لیست علاقمندی ها ثبت شده است" })); } } return(Json(new { msg = "...." })); }
public IHttpActionResult PutDichVu(string id, DichVu dichVu) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != dichVu.DichVu_ID) { return(BadRequest()); } db.Entry(dichVu).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!DichVuExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public ActionResult Create([Bind(Include = "GroupID,GroupTitle")] Product_Groups product_Groups) { if (ModelState.IsValid) { product_Groups.GroupID = Guid.NewGuid(); db.Product_Groups.Add(product_Groups); db.SaveChanges(); return(PartialView("ListGroup", db.Product_Groups.ToList())); } return(View(product_Groups)); }
public ActionResult Create([Bind(Include = "ID,Title,Text,ForumGroupID,CreatedBy,CreatedDate")] ForumPosts forumPosts) { if (ModelState.IsValid) { db.ForumPosts.Add(forumPosts); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ForumGroupID = new SelectList(db.ForumGroups, "ID", "Title", forumPosts.ForumGroupID); return(View(forumPosts)); }
public async Task <ActionResult> Register(RegisterViewModel model) { //Lấy danh sách khóa ngoại var DonVis = _db.DonVi; //Tạo list cho View ViewBag.DonVi_ID = new SelectList(DonVis, "DonVi_ID", "DonVi_Name", model.DonVi_ID); ViewBag.Role = new SelectList(_context.Roles.Where(p => p.Name == "Administrator" || p.Name == "Nhân viên bưu điện"), "Name", "Name", model.Role); if (ModelState.IsValid) { var user = new Web.Models.ApplicationUser { UserName = model.Email, Email = model.Email }; var result = await UserManager.CreateAsync(user, model.Password); if (result.Succeeded) { //Assign Role to user Here await this.UserManager.AddToRoleAsync(user.Id, model.Role); var temp = _db.AspNetUsers.Where(p => p.Id == user.Id).FirstOrDefault(); if (temp != null) { temp.TenNguoiDung = model.TenNguoiDung; temp.DiaChi = model.DiaChi; temp.PhoneNumber = model.PhoneNumber; temp.DonVi_ID = model.DonVi_ID; _db.SaveChanges(); } var callbackUrl = await generateConfirmAccountEmail(user.Id); #if DEBUG TempData["ViewBagLink"] = callbackUrl; #endif ViewBag.Message = "Vui lòng xác nhận Email trước khi đăng nhập."; return(View("Info")); } AddErrors(result); } // If we got this far, something failed, redisplay form return(View(model)); }
public ActionResult Save(ClientTable client) { bool status = false; if (ModelState.IsValid) { using (MainDBEntities mainDB = new MainDBEntities()) { if (client.ClientID > 0) { //edycja var s = mainDB.ClientTables.Where(a => a.ClientID == client.ClientID).FirstOrDefault(); if (s != null) { s.Nip = client.Nip; s.CompanyName = client.CompanyName; s.Address = client.Address; s.Phone = client.Phone; s.Email = client.Email; } } else { //zapis mainDB.ClientTables.Add(client); } mainDB.SaveChanges(); status = true; } } return(new JsonResult { Data = new { status = status } }); }
public ActionResult Registration(CommerceIdeaBank.Models.User user) { if (ModelState.IsValid) { using (var db = new MainDBEntities()) { var crypto = new SimpleCrypto.PBKDF2(); var encrpPass = crypto.Compute(user.Password); var sysUser = db.Users.Create(); sysUser.Username = user.Username; sysUser.Email = user.Email; sysUser.Password = encrpPass; sysUser.PasswordSalt = crypto.Salt; sysUser.UserRole = 1; sysUser.IsActive = true; db.Users.Add(sysUser); db.SaveChanges(); return(RedirectToAction("Index", "Home")); } } return(View(user)); }
public ActionResult Save(StatusTable statuss) { bool status = false; if (ModelState.IsValid) { using (MainDBEntities mainDB = new MainDBEntities()) { if (statuss.StatusID > 0) { //edycja var s = mainDB.StatusTables.Where(a => a.StatusID == statuss.StatusID).FirstOrDefault(); if (s != null) { s.StatusName = statuss.StatusName; } } else { //zapis mainDB.StatusTables.Add(statuss); } mainDB.SaveChanges(); status = true; } } return(new JsonResult { Data = new { status = status } }); }
public int HuyXacNhanChotDonHang(string id) { using (MainDBEntities db = new MainDBEntities()) { db.Configuration.LazyLoadingEnabled = false; db.Configuration.ProxyCreationEnabled = false; var listId = id.Split(','); foreach (var item in listId) { //Cập nhật trạng thái Xác nhận cho chốt đơn hàng var chotDonHang = db.ChotDonHang.Where(p => p.ChotDonHang_ID.ToString() == item).FirstOrDefault(); if (chotDonHang != null) { chotDonHang.TrangThaiXacNhanDonHang = "CHUAXACNHAN"; chotDonHang.ThoiGianXacNhanDonHang = null; } } try { db.SaveChanges(); return(1); } catch (Exception) { return(0); throw; } } }
public bool RemoveAmbassFromSchool(int?selected_school_id) { //Input validation if (selected_school_id == null || selected_school_id < 0) { return(false); } //Remove ambassador from selected school using (var context = new MainDBEntities()) { //Find project with id = project_id, store in temp_project School school = context.Schools.Find(selected_school_id); //Ensure there's a point to the update if (school.Username == null || school.Username == "") { return(true); } //Ensure user is actually ambassador before assignment and that //user actually exists in database school.Username = null; //Verify that valid project was found context.Schools.Add(school); //Indicate modification and make changes persistent context.Entry(school).State = EntityState.Modified; context.SaveChanges(); //Return true indicating successful project edit return(true); } }
public ActionResult DeleteSelected(String[] ids) { if (ids == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Guid[] id = null; //getting the guid of the current user; String user = System.Web.HttpContext.Current.User.Identity.Name; Guid currentGuid; using (var dc = new MainDBEntities()) { currentGuid = dc.users.FirstOrDefault(u => u.email == user).userId; } //ViewBag.CurrentUserGuid = currentGuid.ToString(); if (ids != null) { id = new Guid[ids.Length]; int j = 0; foreach (String i in ids) { Guid.TryParse(i, out id[j++]); } } foreach (Guid i in id) { if (i == currentGuid) { //return JavaScript(alert('Hello this is an alert')); //ViewBag.Message = "Mymessage"; return(Content("<script language='javascript' type='text/javascript'>alert('You Cant Delete Yourself');</script>")); // ViewBag.DataExists = true; // return RedirectToAction("List"); } } if (id != null && id.Length > 0) { List <user> personInfo = new List <user>(); using (var dc = new MainDBEntities()) { personInfo = dc.users.Where(u => id.Contains(u.userId)).ToList(); foreach (var i in personInfo) { dc.users.Remove(i); } dc.SaveChanges(); } } return(RedirectToAction("List")); }
public ActionResult Create(WareHouse ware) { ware.Date = DateTime.Now; db.WareHouse.Add(ware); db.SaveChanges(); return(RedirectToAction("Index")); }
//Func Desc: Used to delete project idea. Admin function. // Input: The id of the project to delete // Output: Bool indicating deletion status. T = successful deletion, F = failure to delete. public bool DeleteProject(int?project_id) { if (project_id == null) { return(false); } try { Project domain_model = new Project(); using (var context = new MainDBEntities()) { domain_model = context.Projects.Find(project_id); IEnumerable <ProjectAssignment> dependent_projects = context.ProjectAssignments.Where(x => x.ProjectID == project_id); if (dependent_projects != null) { foreach (ProjectAssignment assignment in dependent_projects.ToList()) { //Remove project context.ProjectAssignments.Remove(assignment); } context.SaveChanges(); } context.Projects.Remove(domain_model); context.SaveChanges(); //Indicate delete success return(true); } } catch { //Indicate deletion failure return(false); } }
public ActionResult Comment(Product_Comments comment) { if (ModelState.IsValid) { comment.CommentID = Guid.NewGuid(); comment.Date = DateTime.Now; db.Product_Comments.Add(comment); db.SaveChanges(); } return(PartialView("ListComment", db.Product_Comments.Where(p => p.ProductID == comment.ProductID && p.ParentID == null))); }
public ActionResult RequestEditPOST(RequestEditViewModel dupa) { ActionResult actionResult; var tmp = dupa; if (ModelState.IsValid) { using (MainDBEntities mainDB = new MainDBEntities()) { var requstResult = mainDB.RequestTables.FirstOrDefault(a => a.RequestID == dupa.RequestID); if (requstResult != null) { requstResult.Title = dupa.Title; requstResult.RequestDate = dupa.RequestDate; requstResult.StatusID = dupa.StatusId; requstResult.Description = dupa.Description; requstResult.RequestTime = dupa.RequestTime; requstResult.Solution = dupa.Solution; } mainDB.SaveChanges(); } actionResult = RedirectToAction("Index"); } else { using (MainDBEntities mainDB = new MainDBEntities()) { var statuses = mainDB.StatusTables.ToArray(); dupa.GetStatuses(statuses); var requstResult = mainDB.RequestTables.FirstOrDefault(a => a.RequestID == dupa.RequestID); var detailsList = requstResult.RequestDetails.Select(x => new DetailsViewModel { StageNumber = x.StageNumber, StageDate = x.StageDate.Value.ToShortDateString(), StageDesc = x.StageDesc, StageTime = x.StageTime, Status = statuses.FirstOrDefault(y => y.StatusID == x.StatusID).StatusName, UserName = mainDB.UserAccounts.FirstOrDefault(y => x.UserID == requstResult.UserID).UserName }).ToArray(); dupa.Details = detailsList; } actionResult = View("RequestEdit", dupa); } return(actionResult); }
public bool AdminUpdateProjectStatus(int project_id, string new_status) { //Perform input validation if (new_status == null || new_status == "") { return(false); } if ((new_status != ProjectStatus.ASSIGNED) && (new_status != ProjectStatus.IN_PROGRESS) && (new_status != ProjectStatus.INTERN) && (new_status != ProjectStatus.PRODUCTION) && (new_status != ProjectStatus.ARCHIVED)) { return(false); } using (var context = new MainDBEntities()) { //Access object checks if (this.GetType() == typeof(AdminAccess)) { ProjectAssignment current_project = new ProjectAssignment(); //Read in necessary object current_project = context.ProjectAssignments.Find(project_id); //Modify status current_project.ProgressStatus = new_status; //Indicate that that value has been modified context.ProjectAssignments.Attach(current_project); var entry = context.Entry(current_project); //Indicate that IsArchived property has been modified (indicates to EF that property //needs update entry.Property(x => x.ProgressStatus).IsModified = true; //Save update context.SaveChanges(); //Indicate successful update return(true); } else { //Invalid access object return(false); } } }
public JsonResult Save(RequestTable request /*RequestDetail rd*/) { bool status = false; DateTime dateOrg; var isValidDate = DateTime.TryParseExact(request.RequestDateString, "mm-dd-yyyy", null, System.Globalization.DateTimeStyles.None, out dateOrg); if (isValidDate) { request.RequestDate = dateOrg; } if (ModelState.IsValid) { using (MainDBEntities mainDB = new MainDBEntities()) { //var isValidModel = TryUpdateModel(request); if (request.RequestID > 0 /*|| request.StatusID == 1*/) { //edycja var s = mainDB.RequestTables.Where(a => a.RequestID == request.RequestID).FirstOrDefault(); if (s != null) { s.RequestID = request.RequestID; s.RequestDate = request.RequestDate; s.Title = request.Title; s.ClientID = request.ClientID; s.TypeID = request.TypeID; s.StatusID = request.StatusID; s.UserID = request.UserID; s.Description = request.Description; } } else /*if(isValidModel)*/ { //zapis mainDB.RequestTables.Add(request); //mainDB.RequestDetails.Add(rd); } mainDB.SaveChanges(); status = true; } } RedirectToAction("index", "Request"); return(new JsonResult { Data = new { status = status } }); }
//Func Desc: // Input: // Output: public bool AssignProjectToSchool(int?project_id, int?school_id) { if (project_id == null) { return(false); } if (school_id == null) { return(false); } if (school_id < 0) { return(false); } if (project_id < 0) { return(false); } using (var context = new MainDBEntities()) { //Find project with id = project_id, store in temp_project Project temp_project = context.Projects.Find(project_id); //Verify that valid project was found if (temp_project == null) { return(false); } //Create Project Assignment ProjectAssignment new_assignment = new ProjectAssignment(); //Set starting assignment values new_assignment.ProgressStatus = ProjectStatus.ASSIGNED; new_assignment.ProjectID = (int)project_id; new_assignment.SchoolID = (int)school_id; new_assignment.DateAssigned = DateTime.Now; //Save changes to the database context.ProjectAssignments.Add(new_assignment); //Save update context.SaveChanges(); //Indicate successful assignment return(true); } }
public int XoaChotDonHang(string id) { using (MainDBEntities db = new MainDBEntities()) { db.Configuration.LazyLoadingEnabled = false; db.Configuration.ProxyCreationEnabled = false; var listId = id.Split(','); foreach (var item in listId) { //Xóa chốt đơn hàng var chotDonHang = db.ChotDonHang.Where(p => p.ChotDonHang_ID.ToString() == item).FirstOrDefault(); if (chotDonHang != null) { db.ChotDonHang.Remove(chotDonHang); //Xóa chi tiết chốt đơn var chitiets = db.ChiTietChotDonHang.Where(p => p.ChotDonHang_ID == chotDonHang.ChotDonHang_ID).ToList(); if (chitiets != null) { //Cập nhật trạng thái đơn foreach (var chitiet in chitiets) { var donhang = db.DonHang.Where(p => p.SoHieu == chitiet.SoHieu).FirstOrDefault(); if (donhang != null) { donhang.TrangThai = "CHUACHOT"; } } db.ChiTietChotDonHang.RemoveRange(chitiets); } } } try { db.SaveChanges(); return(1); } catch (Exception) { return(0); throw; } } }
public bool UpdateUserRole(string username, int?new_role) { if (username == null || username == "") { return(false); } if ((new_role != UserRole.ADMIN) && (new_role != UserRole.AMBASSADOR) && (new_role != UserRole.CONTRIBUTOR)) { return(false); } using (var context = new MainDBEntities()) { User selected_user = context.Users.Find(username); if (selected_user == null) { return(false); } //Modify status if (new_role != null) { selected_user.UserRole = (int)new_role; } else { return(false); } //Indicate that that value has been modified context.Users.Attach(selected_user); var entry = context.Entry(selected_user); //Indicate that IsArchived property has been modified (indicates to EF that property //needs update entry.Property(x => x.UserRole).IsModified = true; //Save update context.SaveChanges(); //Indicate successful archive return(true); } }
public int HuyCap(string id) { using (MainDBEntities db = new MainDBEntities()) { var model = db.KhoSo.Where(p => p.SoHieu.Contains(id)).FirstOrDefault(); if (model != null) { model.TrangThai = "CHUACAP"; db.SaveChanges(); return(1); } return(0); } }
public bool AddAmbassToSchool(int?selected_school_id, string new_ambassador_username) { //Input validation if (selected_school_id == null || selected_school_id < 0) { return(false); } if (new_ambassador_username == null || new_ambassador_username == "") { return(false); } using (var context = new MainDBEntities()) { //Find project with id = project_id, store in temp_project School school = context.Schools.Find(selected_school_id); User ambassador = context.Users.Find(new_ambassador_username); //Perform input validation if (school == null || ambassador == null) { return(false); } //Ensure user is actually ambassador before assignment and that //user actually exists in database if (ambassador.UserRole != UserRole.AMBASSADOR) { return(false); } else { school.Username = new_ambassador_username; //Verify that valid project was found context.Schools.Add(school); //Indicate modification and make changes persistent context.Entry(school).State = EntityState.Modified; context.SaveChanges(); //Return true indicating successful project edit return(true); } } }
public bool UpdateActiveStatusToInProg(int?active_project_id) { //Input checks if (active_project_id == null) { return(false); } if (active_project_id < 0) { return(false); } using (var context = new MainDBEntities()) { //Access object checks if ((this.GetType() == typeof(AdminAccess)) || (this.GetType() == typeof(AmbassadorAccess))) { ProjectAssignment active_project = new ProjectAssignment(); //Read in necessary object active_project = context.ProjectAssignments.Find(active_project_id); //Modify status active_project.ProgressStatus = ProjectStatus.IN_PROGRESS; //Indicate that that value has been modified context.ProjectAssignments.Attach(active_project); var entry = context.Entry(active_project); //Indicate that IsArchived property has been modified (indicates to EF that property //needs update entry.Property(x => x.ProgressStatus).IsModified = true; //Save update context.SaveChanges(); //Indicate successful archive return(true); } else { //Invalid access object return(false); } } }
public ActionResult DeleteClient(int id) { bool status = false; using (MainDBEntities mainDB = new MainDBEntities()) { var del = mainDB.ClientTables.Where(a => a.ClientID == id).FirstOrDefault(); if (del != null) { mainDB.ClientTables.Remove(del); mainDB.SaveChanges(); status = true; } } return(new JsonResult { Data = new { status = status } }); }
public ActionResult DeleteRequest(int id) { bool status = false; using (MainDBEntities mainDB = new MainDBEntities()) { var del = mainDB.UserAccounts.Where(a => a.UserID == id).FirstOrDefault(); if (del != null) { mainDB.UserAccounts.Remove(del); mainDB.SaveChanges(); status = true; } } new JsonResult { Data = new { status = status } }; return(RedirectToAction("index", "Account")); }
public bool AddAmbassToSchool(int? selected_school_id, string new_ambassador_username) { //Input validation if (selected_school_id == null || selected_school_id < 0) { return false; } if (new_ambassador_username == null || new_ambassador_username == "") { return false; } using (var context = new MainDBEntities()) { //Find project with id = project_id, store in temp_project School school = context.Schools.Find(selected_school_id); User ambassador = context.Users.Find(new_ambassador_username); //Perform input validation if (school == null || ambassador == null) { return false; } //Ensure user is actually ambassador before assignment and that //user actually exists in database if (ambassador.UserRole != UserRole.AMBASSADOR) { return false; } else { school.Username = new_ambassador_username; //Verify that valid project was found context.Schools.Add(school); //Indicate modification and make changes persistent context.Entry(school).State = EntityState.Modified; context.SaveChanges(); //Return true indicating successful project edit return true; } } }
public bool UpdateUserRole(string username, int? new_role) { if (username == null || username == "") { return false; } if ( (new_role != UserRole.ADMIN) && (new_role != UserRole.AMBASSADOR) && (new_role != UserRole.CONTRIBUTOR)) { return false; } using (var context = new MainDBEntities()) { User selected_user = context.Users.Find(username); if (selected_user == null) { return false; } //Modify status if (new_role != null) { selected_user.UserRole = (int)new_role; } else { return false; } //Indicate that that value has been modified context.Users.Attach(selected_user); var entry = context.Entry(selected_user); //Indicate that IsArchived property has been modified (indicates to EF that property //needs update entry.Property(x => x.UserRole).IsModified = true; //Save update context.SaveChanges(); //Indicate successful archive return true; } }
public bool UpdateActiveStatusToProduction(int? active_project_id) { //Input checks if (active_project_id == null) { return false; } if (active_project_id < 0) { return false; } using (var context = new MainDBEntities()) { //Access object checks if ((this.GetType() == typeof(AdminAccess)) || (this.GetType() == typeof(AmbassadorAccess))) { ProjectAssignment active_project = new ProjectAssignment(); //Read in necessary object active_project = context.ProjectAssignments.Find(active_project_id); //Modify status active_project.ProgressStatus = ProjectStatus.PRODUCTION; //Indicate that that value has been modified context.ProjectAssignments.Attach(active_project); var entry = context.Entry(active_project); //Indicate that IsArchived property has been modified (indicates to EF that property //needs update entry.Property(x => x.ProgressStatus).IsModified = true; //Save update context.SaveChanges(); //Indicate successful archive return true; } else { //Invalid access object return false; } } }
//Func Desc: Used to submit school to database // Input: A SchoolViewModel object instance // Output: A bool indicating whether submission succeeded. T = success, F = failure public bool SubmitSchool(AdminSchoolViewModel new_school) { //Input checks if (new_school == null) { return false; } try { using (var context = new MainDBEntities()) { ApplicationSpecificMapper mapper = new ApplicationSpecificMapper(); //Create new project instance School school = new School(); //Map the view model to the domain model school = (School)mapper.Map(new_school, typeof(School)); //Submit the project to the db context.Schools.Add(school); //Save changes context.SaveChanges(); //Indicate successful submission return true; } } catch { //Return false indicating failure to submit project return false; } }
public bool RemoveAmbassFromSchool(int? selected_school_id) { //Input validation if (selected_school_id == null || selected_school_id < 0) { return false; } //Remove ambassador from selected school using (var context = new MainDBEntities()) { //Find project with id = project_id, store in temp_project School school = context.Schools.Find(selected_school_id); //Ensure there's a point to the update if (school.Username == null || school.Username == "") { return true; } //Ensure user is actually ambassador before assignment and that //user actually exists in database school.Username = null; //Verify that valid project was found context.Schools.Add(school); //Indicate modification and make changes persistent context.Entry(school).State = EntityState.Modified; context.SaveChanges(); //Return true indicating successful project edit return true; } }
public ActionResult ExternalLoginConfirmation(RegisterExternalLoginModel model, string returnUrl) { string provider = null; string providerUserId = null; if (User.Identity.IsAuthenticated || !OAuthWebSecurity.TryDeserializeProviderUserId(model.ExternalLoginData, out provider, out providerUserId)) { return RedirectToAction("Manage"); } if (ModelState.IsValid) { // Insert a new user into the database using (MainDBEntities db = new MainDBEntities()) { user userEx = db.users.FirstOrDefault(u => u.email == model.UserName); // Check if user already exists if (userEx != null) { userEx.userName = model.twitterName; userEx.firstName = model.firstName; userEx.lastName = model.lastName; db.Entry(userEx).State = EntityState.Modified; db.SaveChanges(); FormsAuthentication.SetAuthCookie(userEx.email, false); return RedirectToAction("List"); } if (userEx == null) { ///////////////////////////////////////// try { using (var df = new MainDBEntities()) { var sysUser = df.users.Create(); sysUser.userId = Guid.NewGuid(); sysUser.email = model.UserName; sysUser.password = "******"; sysUser.userName = model.twitterName; sysUser.firstName = model.firstName; sysUser.lastName = model.lastName; df.users.Add(sysUser); df.SaveChanges(); //return RedirectToAction("List"); FormsAuthentication.SetAuthCookie(model.UserName, false); return RedirectToAction("List"); } } catch { ModelState.AddModelError("UserName", "User name or twitter name already exists. Please enter a different user name or twitter name."); } ///////////////////////////////// // Insert name into the profile table // db.UserProfiles.Add(new UserProfile { UserName = model.UserName }); // db.SaveChanges(); //OAuthWebSecurity.CreateOrUpdateAccount(provider, providerUserId, model.UserName); //OAuthWebSecurity.Login(provider, providerUserId, createPersistentCookie: false); //return RedirectToLocal(returnUrl); } else { ModelState.AddModelError("UserName", "User name already exists. Please enter a different user name."); } } } ViewBag.ProviderDisplayName = OAuthWebSecurity.GetOAuthClientData(provider).DisplayName; ViewBag.ReturnUrl = returnUrl; return View(model); }
//Func Desc: // Input: // Output: public bool AssignProjectToSchool(int? project_id, int? school_id) { if (project_id == null) { return false; } if (school_id == null) { return false; } if (school_id < 0) { return false; } if (project_id < 0) { return false; } using (var context = new MainDBEntities()) { //Find project with id = project_id, store in temp_project Project temp_project = context.Projects.Find(project_id); //Verify that valid project was found if (temp_project == null) { return false; } //Create Project Assignment ProjectAssignment new_assignment = new ProjectAssignment(); //Set starting assignment values new_assignment.ProgressStatus = ProjectStatus.ASSIGNED; new_assignment.ProjectID = (int)project_id; new_assignment.SchoolID = (int)school_id; new_assignment.DateAssigned = DateTime.Now; //Save changes to the database context.ProjectAssignments.Add(new_assignment); //Save update context.SaveChanges(); //Indicate successful assignment return true; } }
//Func Desc: Used to mark the project with primary key id to archived. // Input: Int representing id of project to archive. // Output: A bool indicating whether update was successful or not. T = success, F = failure. public bool ArchiveProject(int? id) { if (id == null) { return false; } using (var context = new MainDBEntities()) { //Retrieve project Project project = context.Projects.Find(id); //Mark the project as archived if (project != null) { project.IsArchived = true; } else { //Indicate error status return false; } //Indicate that that value has been modified context.Projects.Attach(project); var entry = context.Entry(project); //Indicate that IsArchived property has been modified (indicates to EF that property //needs update entry.Property(x => x.IsArchived).IsModified = true; //Save update context.SaveChanges(); //Indicate successful archive return true; } }
//Func Desc: Used to return a project from its id. // Input: Int representing id of project to locate. // Output: An instance of the project that has the specified id, or null public bool EditProject(object vm_project) { //Input checks if (vm_project == null) { return false; } if ( (vm_project.GetType() != typeof(AdminProjectViewModel)) && (vm_project.GetType() != typeof(AmbassProjectViewModel)) && (vm_project.GetType() != typeof(ContributorProjectViewModel))) { //Invalid view model Debug.WriteLine("\n\n***** " + "View model input into EditProject of ContributorAccess is invalid in type. " + "ERROR IN: CommerceIdeaBank.DatabaseInterface.BusinessLogic.ContributorAccess EditProject()" + "*****\n\n" ); //Indicate failure in status return false; } using (var context = new MainDBEntities()) { ApplicationSpecificMapper mapper = new ApplicationSpecificMapper(); if (this.GetType() == typeof(AdminAccess)) { Project proj = (Project)mapper.Map((AdminProjectViewModel)vm_project, typeof(Project)); //Create the project edit and populate necessary attributes ProjectEdit edit = new ProjectEdit(); edit.Username = proj.Username; edit.ProjectID = proj.ProjectID; edit.EditDate = DateTime.Now; context.ProjectEdits.Add(edit); //Indicate modification and make changes persistent context.Entry(proj).State = EntityState.Modified; context.SaveChanges(); //Return true indicating successful project edit return true; } else if (this.GetType() == typeof(AmbassadorAccess)) { Project proj = (Project)mapper.Map((AmbassProjectViewModel)vm_project, typeof(Project)); //Create the project edit and populate necessary attributes ProjectEdit edit = new ProjectEdit(); edit.Username = proj.Username; edit.ProjectID = proj.ProjectID; edit.EditDate = DateTime.Now; context.ProjectEdits.Add(edit); //Indicate modification and make changes persistent context.Entry(proj).State = EntityState.Modified; context.SaveChanges(); //Return true indicating successful project edit return true; } else if (this.GetType() == typeof(ContributorAccess)) { Project proj = (Project)mapper.Map((ContributorProjectViewModel)vm_project, typeof(Project)); //Create the project edit and populate necessary attributes ProjectEdit edit = new ProjectEdit(); edit.Username = proj.Username; edit.ProjectID = proj.ProjectID; edit.EditDate = DateTime.Now; context.ProjectEdits.Add(edit); //Indicate modification and make changes persistent context.Entry(proj).State = EntityState.Modified; context.SaveChanges(); //Return true indicating successful project edit return true; } else { //Access type not recognized Debug.WriteLine("\n\n***** " + "Access object type wasn't recognized during EditProject(). " + "ERROR IN: CommerceIdeaBank.DatabaseInterface.BusinessLogic.ContributorAccess EditProject()" + "*****\n\n"); //Indicate error status return false; } } }
//Func Desc: Used to submit project idea // Input: A ProjectView instance // Output: Bool indicating submission status. T = successful submission, F = failure to submit. public bool SubmitProject(object new_project) { //Input checks if (new_project == null) { return false; } using(var context = new MainDBEntities()) { //Determine response based on access privilages if (this.GetType() == typeof(AdminAccess)) // IF ADMINISTRATOR { try { //Cast object to admin project view model type AdminProjectViewModel admin_project = (AdminProjectViewModel)new_project; //Create new project instance Project proj = new Project(); //Transfer necessary values proj.ProjectName = admin_project.ProjectName; proj.ProjectDesc = admin_project.ProjectDesc; proj.BusinessJustification = admin_project.BusinessJustification; proj.Username = admin_project.Username; proj.Status = IdeaStatus.SUBMITTED; proj.IsArchived = false; //Not yet archived proj.PostDate = DateTime.Now; proj.AssignDate = null; proj.FinishDate = null; //Submit the project to the db context.Projects.Add(proj); //Save changes context.SaveChanges(); //Indicate successful submission return true; } catch { //Return false indicating failure to submit project return false; } } else if (this.GetType() == typeof(AmbassadorAccess)) { try { //Cast object to contributor project view model type AmbassProjectViewModel contributor_project = (AmbassProjectViewModel)new_project; //Create new project instance Project proj = new Project(); //Transfer necessary values proj.ProjectName = contributor_project.ProjectName; proj.ProjectDesc = contributor_project.ProjectDesc; proj.BusinessJustification = contributor_project.BusinessJustification; proj.Username = contributor_project.Username; proj.Status = IdeaStatus.SUBMITTED; proj.IsArchived = false; //Not yet archived proj.PostDate = DateTime.Now; proj.AssignDate = null; proj.FinishDate = null; //Submit the project to the db context.Projects.Add(proj); //Save changes context.SaveChanges(); //Indicate successful submission return true; } catch { //Return false indicating failure to submit project return false; } } else if (this.GetType() == typeof(ContributorAccess)) { try { // ContributorProjectViewModel contributor_project = (ContributorProjectViewModel)new_project; //Create new project instance Project proj = new Project(); //Transfer necessary values proj.ProjectName = contributor_project.ProjectName; proj.ProjectDesc = contributor_project.ProjectDesc; proj.BusinessJustification = contributor_project.BusinessJustification; proj.Username = contributor_project.Username; proj.Status = IdeaStatus.SUBMITTED; proj.IsArchived = false; //Not yet archived proj.PostDate = DateTime.Now; proj.AssignDate = null; proj.FinishDate = null; //Submit the project to the db context.Projects.Add(proj); //Save changes context.SaveChanges(); //Indicate successful submission return true; } catch { //Return false indicating failure to submit project return false; } } else { //Access object not recognized Debug.WriteLine("\n\n***** " + "Access object type wasn't recognized during SubmitProject(). " + "ERROR IN: CommerceIdeaBank.DatabaseInterface.BusinessLogic.ContributorAccess SubmitProject()" + "*****\n\n"); //Indicate error return false; } } }
public ActionResult DeleteSelected(String[] ids) { if (ids == null) { return new HttpStatusCodeResult(HttpStatusCode.BadRequest); } Guid[] id = null; //getting the guid of the current user; String user = System.Web.HttpContext.Current.User.Identity.Name; Guid currentGuid; using (var dc = new MainDBEntities()) { currentGuid = dc.users.FirstOrDefault(u => u.email == user).userId; } //ViewBag.CurrentUserGuid = currentGuid.ToString(); if (ids != null) { id = new Guid[ids.Length]; int j = 0; foreach (String i in ids) { Guid.TryParse(i, out id[j++]); } } foreach (Guid i in id) { if (i == currentGuid) { //return JavaScript(alert('Hello this is an alert')); //ViewBag.Message = "Mymessage"; return Content("<script language='javascript' type='text/javascript'>alert('You Cant Delete Yourself');</script>"); // ViewBag.DataExists = true; // return RedirectToAction("List"); } } if (id != null && id.Length > 0) { List<user> personInfo = new List<user>(); using (var dc = new MainDBEntities()) { personInfo = dc.users.Where(u => id.Contains(u.userId)).ToList(); foreach (var i in personInfo) { dc.users.Remove(i); } dc.SaveChanges(); } } return RedirectToAction("List"); }
public ActionResult Edit([Bind(Include = "userId,email,userName,password,firstName,lastName")] user userE) { if (ModelState.IsValid) { try { using (var dc = new MainDBEntities()) { //user userEdit = dc.users.Find(userId); dc.Entry(userE).State = EntityState.Modified; dc.SaveChanges(); return RedirectToAction("List"); } } catch { ModelState.AddModelError("", "Add value to the password field"); return View(); } } return View(userE); }
public bool AdminUpdateProjectStatus(int project_id, string new_status) { //Perform input validation if (new_status == null || new_status == "") { return false; } if( (new_status != ProjectStatus.ASSIGNED) && (new_status != ProjectStatus.IN_PROGRESS) && (new_status != ProjectStatus.INTERN) && (new_status != ProjectStatus.PRODUCTION) && (new_status != ProjectStatus.ARCHIVED) ) { return false; } using (var context = new MainDBEntities()) { //Access object checks if (this.GetType() == typeof(AdminAccess)) { ProjectAssignment current_project = new ProjectAssignment(); //Read in necessary object current_project = context.ProjectAssignments.Find(project_id); //Modify status current_project.ProgressStatus = new_status; //Indicate that that value has been modified context.ProjectAssignments.Attach(current_project); var entry = context.Entry(current_project); //Indicate that IsArchived property has been modified (indicates to EF that property //needs update entry.Property(x => x.ProgressStatus).IsModified = true; //Save update context.SaveChanges(); //Indicate successful update return true; } else { //Invalid access object return false; } } }
public ActionResult Registration(CommerceIdeaBank.Models.User user) { if (ModelState.IsValid) { using (var db = new MainDBEntities()) { var crypto = new SimpleCrypto.PBKDF2(); var encrpPass = crypto.Compute(user.Password); var sysUser = db.Users.Create(); sysUser.Username = user.Username; sysUser.Email = user.Email; sysUser.Password = encrpPass; sysUser.PasswordSalt = crypto.Salt; sysUser.UserRole = 1; sysUser.IsActive = true; db.Users.Add(sysUser); db.SaveChanges(); return RedirectToAction("Index", "Home"); } } return View(user); }
//Func Desc: Used to delete project idea. Admin function. // Input: The id of the project to delete // Output: Bool indicating deletion status. T = successful deletion, F = failure to delete. public bool DeleteProject(int? project_id) { if (project_id == null) { return false; } try { Project domain_model = new Project(); using (var context = new MainDBEntities()) { domain_model = context.Projects.Find(project_id); IEnumerable<ProjectAssignment> dependent_projects = context.ProjectAssignments.Where( x => x.ProjectID == project_id ); if (dependent_projects != null) { foreach (ProjectAssignment assignment in dependent_projects.ToList()) { //Remove project context.ProjectAssignments.Remove(assignment); } context.SaveChanges(); } context.Projects.Remove(domain_model); context.SaveChanges(); //Indicate delete success return true; } } catch { //Indicate deletion failure return false; } }
public bool EditSchool(AdminSchoolViewModel vm_school) { if (vm_school == null) { return false; } try { using (var context = new MainDBEntities()) { ApplicationSpecificMapper mapper = new ApplicationSpecificMapper(); //Validate input if (mapper == null) { return false; } School school = (School)mapper.Map((AdminSchoolViewModel)vm_school, typeof(School)); //Validate input if (school == null) { return false; } //Create the project edit and populate necessary attributes SchoolEdit edit = new SchoolEdit(); edit.SchoolID = school.SchoolID; edit.Username = school.Username; edit.SchoolName = school.SchoolName; edit.Phone = (int)school.Phone; edit.Email = school.Email; edit.ContactEmail = school.ContactEmail; edit.ContactName = school.ContactName; edit.ContactPhone = school.ContactPhone; edit.Department = school.Department; edit.Class = school.Class; edit.StreetNumber = school.StreetNumber; edit.StreetName = school.StreetName; edit.ZipCode = school.ZipCode; edit.City = school.City; edit.State = school.State; edit.EditDate = DateTime.Now; context.SchoolEdits.Add(edit); //Indicate modification and make changes persistent context.Entry(school).State = EntityState.Modified; context.SaveChanges(); //Return true indicating successful project edit return true; } } catch { //There was an error during school edit return false; } }
public ActionResult Registration(MVCLoginInternet.Models.userModel user) { if (ModelState.IsValid) { try { using (var db = new MainDBEntities()) { var sysUser = db.users.Create(); sysUser.userId = Guid.NewGuid(); sysUser.email = user.email; sysUser.password = user.password; sysUser.userName = user.userName; sysUser.firstName = user.firstName; sysUser.lastName = user.lastName; //sysUser.twitterName = user.twitterName; // sysUser.tw // sysUser.twitterName = user.twitterName; db.users.Add(sysUser); db.SaveChanges(); FormsAuthentication.SetAuthCookie(user.email, false); return RedirectToAction("List"); // return RedirectToAction("Index", "Home"); } } catch (Exception ex) { ModelState.AddModelError("", "Add unique values to username and email, this user already exists"); return View(); } } else { ModelState.AddModelError("", "Registration data is incorrect"); } return View(); }