//Adding likes and dislikes public JsonResult AddLike(int id, bool status) { if (id != 0) { likes_detail likeDetails = new likes_detail { BlogId = id, IpAddress = Request.UserHostAddress, LikeStatus = status, CreatedDate = DateTime.Now, ModifiedDate = DateTime.Now }; var ifExists = db.like_details.Where(i => i.BlogId == id && i.IpAddress == Request.UserHostAddress).SingleOrDefault(); if (ifExists != null) { ifExists.LikeStatus = status; db.Entry(ifExists).State = EntityState.Modified; db.SaveChanges(); } else { db.like_details.Add(likeDetails); db.SaveChanges(); } } return(Json("hii")); }
public bool UserSave(TUser user) { if (user.Id == default) { //执行添加 user.Id = Guid.NewGuid(); user.IsDelete = false; user.CreateTime = DateTime.Now; user.RoleId = Guid.Parse("136A214E-7523-42F2-9760-8EED42B31BA1"); db.TUser.Add(user); } else { //执行修改 var dbUserSys = db.TUser.Where(t => t.Id == user.Id).FirstOrDefault(); dbUserSys.Name = user.Name; dbUserSys.NickName = user.NickName; dbUserSys.Phone = user.Phone; dbUserSys.Email = user.Email; dbUserSys.PassWord = user.PassWord; } db.SaveChanges(); return(true); }
public static bool Authenticate(string userName, string userPassword) { CreateAdmin(); // Comment out this line if you already have admin account if (string.IsNullOrWhiteSpace(userName) || string.IsNullOrWhiteSpace(userPassword)) { return(false); } var user = _db.Users.Where(x => x.UserName == userName.Trim().ToLower()).FirstOrDefault(); if (user == null) { return(false); } if (!user.IsActive) { return(false); } bool valid = VerifyPasswordHash(userPassword, user.PasswordSalt, user.PasswordHash); if (valid) { user.LastLogin = DateTime.Now; _db.Entry(user).State = System.Data.Entity.EntityState.Modified; _db.SaveChanges(); CurrentUser = user; // Set current user return(true); } return(false); }
public void addAssignment(AssignmentViewModel newAssignment) { using (var context = new dbContext()) { assignment model = new assignment { name = newAssignment.Name, maxSubmisions = newAssignment.MaxSubmissions, groupSize = newAssignment.GroupSize, startDate = newAssignment.AssignmentStart, endDate = newAssignment.AssignmentEnd, courseID = newAssignment.CourseID }; context.assignments.Add(model); context.SaveChanges(); assignmentPart modelPart = new assignmentPart { descriptoin = newAssignment.Description, solutionFile = newAssignment.SolutionFile, assignmentID = model.ID }; context.assignmentParts.Add(modelPart); context.SaveChanges(); } }
public IActionResult Register(Users user, IFormFile photo) { if (photo == null || photo.Length == 0) { user.Pic = "No Image"; } else { var path = Path.Combine(Directory.GetCurrentDirectory(), "", photo.FileName); var stream = new FileStream(path, FileMode.Create); user.Pic = photo.FileName; } byte[] data = UTF8Encoding.UTF8.GetBytes(user.Password); using (MD5CryptoServiceProvider md5 = new MD5CryptoServiceProvider()) { byte[] keys = md5.ComputeHash(UTF8Encoding.UTF8.GetBytes("hash")); using (TripleDESCryptoServiceProvider tripDes = new TripleDESCryptoServiceProvider() { Key = keys, Mode = CipherMode.ECB, Padding = PaddingMode.PKCS7 }) { ICryptoTransform transform = tripDes.CreateEncryptor(); byte[] results = transform.TransformFinalBlock(data, 0, data.Length); user.Password = Convert.ToBase64String(results, 0, results.Length); } } user.Type = "user"; user.Status = "Enable"; _context.Users.Add(user); _context.SaveChanges(); ViewBag.email = HttpContext.Session.GetString("email"); return(RedirectToAction("Home")); }
public IHttpActionResult PutEndUser(string id, EndUser endUser) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != endUser.user_name) { return(BadRequest()); } db.Entry(endUser).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!EndUserExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public void deletedraftmail(int draft_mail_id) { var delete_obj = _context.draft_mail_table.SingleOrDefault(m => m.draft_mail_ID == draft_mail_id); _context.draft_mail_table.Remove(delete_obj); _context.SaveChanges(); }
public void ToggleUpdate(bool isChecked, string propertyName) { var user = CurrentLoggedUser.Instance.GetLoggedUser(); using (var ctx = new dbContext()) { User usrSettings = ctx.Users.FirstOrDefault(x => x.Id == user.Id); if (usrSettings.Settings == null) { Setting settings = new Setting(); Type type = settings.GetType(); PropertyInfo prop = type.GetProperty(propertyName); prop.SetValue(settings, isChecked, null); usrSettings.Settings = settings; ctx.Entry(usrSettings.Settings).State = EntityState.Added; ctx.SaveChanges(); } else { Type type = usrSettings.Settings.GetType(); PropertyInfo prop = type.GetProperty(propertyName); prop.SetValue(usrSettings.Settings, isChecked, null); ctx.Entry(usrSettings.Settings).State = EntityState.Modified; ctx.SaveChanges(); } } }
public HttpResponseMessage PutProduct(int id, Product product) { HttpResponseMessage res; try { var entity = db.Products.FirstOrDefault(p => p.Id == product.Id); if (entity != null) { entity.Name = product.Name; db.SaveChanges(); res = Request.CreateResponse(HttpStatusCode.OK, entity); } else { res = Request.CreateResponse(HttpStatusCode.NotFound, "Product id= " + product.Id + " not found"); } } catch (Exception ex) { res = Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex); //res.Headers.Add("Access-Control-Allow-Origin", "*"); return(res); } res.Headers.Add("Access-Control-Allow-Origin", "*"); return(res); }
public void UpdateEveryMin(bool isUpdateEveryOn, string updateEveryMin) { var user = CurrentLoggedUser.Instance.GetLoggedUser(); using (var ctx = new dbContext()) { User usrSettings = ctx.Users.FirstOrDefault(x => x.Id == user.Id); if (usrSettings.Settings == null) { Setting settings = new Setting(); settings.isUpdateEveryOn = isUpdateEveryOn; settings.UpdateEveryMin = Convert.ToInt32(updateEveryMin); usrSettings.Settings = settings; ctx.Entry(usrSettings.Settings).State = EntityState.Added; ctx.SaveChanges(); } else { usrSettings.Settings.isUpdateEveryOn = isUpdateEveryOn; usrSettings.Settings.UpdateEveryMin = Convert.ToInt32(updateEveryMin); ctx.Entry(usrSettings.Settings).State = EntityState.Modified; ctx.SaveChanges(); } } }
public ActionResult Create([Bind("MenuID,CategoryID,Content,ContentType,CreatedBy,CreatedDate,IsDeleted,MenuDescription,MenuName,MenuPrice,StatusID,UpdatedBy,UpdatedDate")] Menu menu, ICollection <IFormFile> files) { if (ModelState.IsValid) { //var uploads = Path.Combine(_environment.WebRootPath, "uploads"); foreach (var file in files) { if (file.Length > 0) { using (var fileStream = file.OpenReadStream()) using (var ms = new MemoryStream()) { fileStream.CopyTo(ms); var fileBytes = ms.ToArray(); string s = Convert.ToBase64String(fileBytes); menu.Content = fileBytes; menu.ContentType = file.ContentType; // act on the Base64 data } } } menu.CreatedBy = "Admin"; menu.CreatedDate = DateTime.Now; _context.Add(menu); _context.SaveChanges(); return(RedirectToAction("Index")); } ViewData["CategoryID"] = new SelectList(_context.Category, "CategoryID", "CategoryName", menu.CategoryID); ViewData["StatusID"] = new SelectList(_context.Status, "StatusID", "StatusName", menu.StatusID); return(View(menu)); }
public ActionResult Create([Bind(Include = "ModelId,Name,IsEnabled")] SampleModels sampleModels, HttpPostedFileBase LargeImage) { if (ModelState.IsValid) { if (LargeImage != null) { //saving both small and large images and receiving back their urls. SampleModelMethods sampleModelMethods = new SampleModelMethods(); sampleModels.LargeImageUrl = sampleModelMethods.SaveLargeImage(LargeImage); //adding records to database.. db.models.Add(sampleModels); db.SaveChanges(); return(RedirectToAction("Index")); } else { ModelState.AddModelError("", "Please Select an image for project."); } //db.models.Add(sampleModels); //db.SaveChanges(); //return RedirectToAction("Index"); } return(View(sampleModels)); }
public IActionResult UpdateVehicles(Vehicle vehicle, IFormFile photo) { Vehicle vehicles = _context.Vehicle.Find(vehicle.VehicleNo); if (photo == null || photo.Length == 0) { vehicle.Pic = vehicles.Pic; } else { var path = Path.Combine(Directory.GetCurrentDirectory(), "", photo.FileName); var stream = new FileStream(path, FileMode.Create); vehicle.Pic = photo.FileName; } vehicle.VehicleAvailability = true; _context.Vehicle.Attach(vehicles); vehicles.VehicleType = vehicle.VehicleType; vehicles.Amount = vehicle.Amount; vehicles.VehicleAvailability = vehicle.VehicleAvailability; vehicles.Class = vehicle.Class; _context.SaveChanges(); return(RedirectToAction("ViewVehicle")); }
/// <summary> /// Добавление посещений /// </summary> /// <param name="model"></param> /// <returns></returns> public IActionResult AddVisit(VisitViewModel model) { var date = model.Date; var saved = HttpContext.Session.GetString("SessionStorageThemes"); var storage = new List <SessionStorageThemes>(); if (storage != null) { storage = JsonConvert.DeserializeObject <List <SessionStorageThemes> >(saved); } var themeVisits = new List <ThemeVisit>(); foreach (var savedTheme in storage) { var theme = _db.Theme.Include(x => x.ThemeGroup).Include(x => x.Subject).ThenInclude(x => x.Semester).Where(x => x.Id == savedTheme.ThemeId).FirstOrDefault(); theme.ThemeGroup.UsedHours = savedTheme.ThemeGroup.UsedHours; var hoursPerVisit = savedTheme.Reserved; var typeSubject = theme.Type; var themeVisit = new ThemeVisit() { HoursPerVisit = hoursPerVisit, Theme = theme, TypeSubject = typeSubject }; themeVisits.Add(themeVisit); } var visit = new GroupVisit() { Date = date, ThemeVisits = themeVisits, Subject = _db.Subject.Find(model.SubjectId), Group = _db.Group.Find(model.GroupId), Semester = _db.Subject.Include(x => x.Semester).Where(x => x.Id == model.SubjectId).FirstOrDefault().Semester, Theme = themeVisits.FirstOrDefault().Theme }; _db.GroupVisit.Add(visit); foreach (var visitModify in model.Output.VisitsModify) { var studentVisit = new StudentVisit() { TypeVisit = visitModify.TypeVisit, Student = _db.Student.Find(visitModify.StudentId), GroupVisit = visit, Subject = _db.Subject.Find(model.SubjectId), Theme = visit.ThemeVisits.FirstOrDefault().Theme }; _db.StudentVisit.Add(studentVisit); visit.StudentVisits.Add(studentVisit); visit.Theme.StudentVisits.Add(studentVisit); } _db.SaveChanges(); return(View("VisitAddedView")); }
public void Create([Bind(Include = "ProductId,ProductName,Price,RenewPrice")] Product product) { if (ModelState.IsValid) { db.Products.Add(product); db.SaveChanges(); } }
public IActionResult Delete(int id) { var merchant = _context.Merchants.First(i => i.Id == id); _context.Merchants.Remove(merchant); _context.SaveChanges(); return(Ok(merchant)); }
public void ResetCountAndDateError(string mail) { var User = db.mst_user.SingleOrDefault(x => x.mail == mail); User.cnt_login_error = 0; User.date_login_error = null; db.SaveChanges(); }
public object Insert(List <FileModel> files, function item, Function_Extend itemExtend) { Message msg = new Message { Error = false }; using (DbContextTransaction dbTran = _dbContext.Database.BeginTransaction()) { try { if (getNotExistsFunctionWhenInsert(item.Function1)) { item.CreatedBy = ((account)Session["informationOfAccount"]).Account1; item.CreatedDate = DateTime.Now; item.ModifiedBy = ((account)Session["informationOfAccount"]).Account1; item.ModifiedDate = DateTime.Now; if (item.functionCategories != null) { item.functionCategoriesTitle = _dbContext.functionCategories.First(x => x.functionCategories == item.functionCategories).functionCategoriesTitle; } _dbContext.functions.Add(item); _dbContext.SaveChanges(); msg.Title = Function_Message_InsertSuccess; var ChildFunction = _dbContext.childOfFunctions.ToList(); foreach (var itemChild in ChildFunction) { if (itemExtend.ArrayFunction != null) { if (itemExtend.ArrayFunction.Find(x => x == itemChild.ChildOfFunction1) == null) { itemChild.RemoveFunction += "#" + itemExtend.Function1 + "#"; _dbContext.Entry(itemChild).Property(x => x.ID).IsModified = false; _dbContext.Entry(itemChild).Property(x => x.Title).IsModified = false; _dbContext.Entry(itemChild).Property(x => x.Order).IsModified = false; _dbContext.SaveChanges(); } } } dbTran.Commit(); } else { msg.Title = Function_Message_InsertErrror; msg.Error = true; dbTran.Rollback(); } } catch (Exception ex) { msg.Title = Function_Message_InsertErrror; msg.Error = true; msg.Data = ex.ToString(); dbTran.Rollback(); } } return(Json(msg, JsonRequestBehavior.AllowGet)); }
public ActionResult Create(Animal animal) { if (ModelState.IsValid) { db.Animais.Add(animal); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(animal)); }
public ActionResult Create([Bind(Include = "Id,PageUrl,PageTitle,Keywords,Descriptions,PageContent")] PagesData pagesData) { if (ModelState.IsValid) { db.pageDataList.Add(pagesData); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(pagesData)); }
public ActionResult Save(Models.StudentViewModel model) { if (ModelState.IsValid) { if (model.Student.Id == 0) { //new var stu = new Models.Student(); //Note: Map file and model together. stu.Name = model.Student.Name; stu.Surname = model.Student.Surname; stu.Email = model.Student.Email; stu.StudentNumber = model.Student.StudentNumber; stu.MobileNumber = model.Student.MobileNumber; stu.TelNumber = model.Student.TelNumber; stu.IsActive = model.Student.IsActive; if (model.File != null) { string ext = Path.GetExtension(model.File.FileName); stu.FilePath = @"~/datafolder/images/" + model.Student.ImageName + ext; if (!Directory.Exists(Server.MapPath("/datafolder/images/"))) { Directory.CreateDirectory(Server.MapPath("/datafolder/images/")); } model.File.SaveAs(Server.MapPath(stu.FilePath.Remove(0, 1))); Blob.StorageHandler.Upload(Server.MapPath(stu.FilePath.Remove(0, 1)), stu.FilePath); } _db.Students.Add(stu); } else { //edit var studentindb = _db.Students.Single(s => s.Id == model.Student.Id); //Note: Map file and model together. studentindb.Name = model.Student.Name; studentindb.Surname = model.Student.Surname; studentindb.Email = model.Student.Email; studentindb.StudentNumber = model.Student.StudentNumber; studentindb.MobileNumber = model.Student.MobileNumber; studentindb.TelNumber = model.Student.TelNumber; studentindb.IsActive = model.Student.IsActive; if (model.File != null) { string ext = Path.GetExtension(model.File.FileName); studentindb.FilePath = @"~/datafolder/images/" + model.Student.ImageName + ext; model.File.SaveAs(Server.MapPath(studentindb.FilePath)); Blob.StorageHandler.Upload(Server.MapPath(studentindb.FilePath), studentindb.FilePath); } } _db.SaveChanges(); } return(RedirectToAction("Index")); }
public IActionResult PostCustomer(RequestData <Customer> customer) { _context.Customer.Add(customer.data.attributes); _context.SaveChanges(); return(Ok(new { message = "success retrieve data", status = true, data = customer })); }
//Adds a new user to the [Users] table public Users AddNewUser(Users newUser) { if (db.Users.FirstOrDefault (u => u.UserId == newUser.UserId) == null) { db.Users.Add(newUser); db.SaveChanges(); return(newUser); } return(null); }
public ActionResult Create([Bind("BillID,BillDate,CreatedBy,CreatedDate,IsDeleted,OrderID,TotalPrice,UpdatedBy,UpdatedDate")] Bill bill) { if (ModelState.IsValid) { _context.Add(bill); _context.SaveChanges(); return(RedirectToAction("Index")); } ViewData["OrderID"] = new SelectList(_context.Order, "OrderID", "OrderID", bill.OrderID); return(View(bill)); }
public ActionResult Create([Bind(Include = "Id_ClienteExterno,CExt_Nombre,CExt_Direccion,CExt_Telefono,CExt_FechaCreacion,CExt_Estado")] ClienteExterno clienteExterno) { if (ModelState.IsValid) { db.ClienteExternoes.Add(clienteExterno); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(clienteExterno)); }
public IActionResult Insertar([FromBody] Servicio servicio) { if (ModelState.IsValid) { db.Servicio.Add(servicio); db.SaveChanges(); return(Json(servicio)); } return(BadRequest()); }
public void changeMailStatus(int mail_id) { MailTable mailTable = new MailTable() { mail_ID = mail_id, mail_status = "read" }; _context.mail_table.Attach(mailTable); _context.Entry(mailTable).Property(x => x.mail_status).IsModified = true; _context.SaveChanges(); }
public IActionResult Insertar([FromBody] Cliente cliente) { if (ModelState.IsValid) { db.Cliente.Add(cliente); db.SaveChanges(); return(Json(cliente)); } return(BadRequest()); }
public ActionResult Create([Bind(Include = "StudentId,StudentName,Age")] Infor infor) { if (ModelState.IsValid) { db.Infors.Add(infor); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(infor)); }
public ActionResult Create([Bind(Include = "id,aName,DOB,city")] Artist artist) { if (ModelState.IsValid) { db.Artists.Add(artist); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(artist)); }