public ActionResult Create([Bind(Include = "ID,PostFK,PicTitle,EditDate,PictPict")] Picts picts)
{
var file = Request.Files[0];
var sessUnq = Session.SessionID.Substring(Session.SessionID.Length - 4);
if (file != null && file.ContentLength > 0)
{
var fileName = sessUnq + Path.GetFileName(file.FileName);
var path = Path.Combine(Server.MapPath("~/UploadPictures/"), fileName);
file.SaveAs(path);
picts.PictPict = fileName;
}
if (ModelState.IsValid)
{
//picts.PostFK = ViewBag.aId;
String aDate = DateTime.UtcNow.ToString("yyMMddHHmmss");
picts.EditDate = aDate;
db.Picts.Add(picts);
db.SaveChanges();
int fkid = picts.PostFK;
return(RedirectToAction("Details", "Main", new { id = fkid }));
//return RedirectToAction("Index");
}
return(View(picts));
}
public IHttpActionResult PutPost(Guid id, Post post)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != post.ID)
{
return(BadRequest());
}
db.Entry(post).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!PostExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public static void PostDbSeeder(PostDbContext context)
{
var postTable = context.Set <Post>();
if (!postTable.Any())
{
var post1 = new Post(
@"Asp.NetCore源码学习[1-1]：配置[Configuration]",
@"",
@"初始数据",
@"",
true);
post1.SetAuthor(1, "demo");
postTable.Add(post1);
var post2 = new Post(
@"Asp.NetCore源码学习[1-2]：配置[Configuration]",
@"",
@"初始数据",
@"",
true);
post2.SetAuthor(1, "demo");
postTable.Add(post1);
var post3 = new Post(
@"alan发布的博客",
@"",
@"alan发布的博客",
@"",
true);
post2.SetAuthor(2, "alan");
postTable.Add(post1);
postTable.Add(post2);
context.SaveChanges();
}
context.SaveChanges();
}
public ActionResult Create([Bind(Include = "ID,PostTitle,PostAuthor,PostTags,PostText,TitlePic,EditDate")] Posts posts)
{
if (ModelState.IsValid)
{
String aDate = DateTime.UtcNow.ToString("yyMMddHHmmss");
posts.EditDate = aDate;
db.Posts.Add(posts);
db.SaveChanges();
//grab id for new record
//Posts posts = db.Posts.
//int aId = int.Parse(db.Posts
// .OrderByDescending(b => b.ID)
// .Select(c => c.ID)
// .First()
// .ToString());
int aId = posts.ID;
//return RedirectToAction("Index");
return(RedirectToAction("Details", new { id = aId }));
}
//nn to drive to edit action...f**k f**k f**k --- done done done m**********r
return(View(posts));
}
public ActionResult Create([Bind(Include = "ID,PostTitle,PostAuthor,PostTags,PostText,TitlePic,EditDate")] Posts posts)
{
if (ModelState.IsValid)
{
db.Posts.Add(posts);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(posts));
}
public ActionResult Create([Bind(Include = "BlogID,Name")] Blog blog)
{
if (ModelState.IsValid)
{
db.Blogs.Add(blog);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(blog));
}
public ActionResult Create(PostCategory postCategory)
{
if (ModelState.IsValid)
{
postCategory.CreatedBy = LoggedUserInfo.GetLoggedUserInfo().ID;
db.PostCategory.Add(postCategory);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(postCategory));
}
public ActionResult Create([Bind(Include = "ID,TagName,CreatedAt")] PostTag postTag)
{
if (ModelState.IsValid)
{
postTag.ID = Guid.NewGuid();
db.PostTag.Add(postTag);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(postTag));
}
public ActionResult Create([Bind(Include = "ID,Username,Password,UserRoleEnum,CreatedAt,UpdatedAt,CreatedBy")] Users users)
{
if (ModelState.IsValid)
{
users.ID = Guid.NewGuid();
users.Password = Crypto.SHA256(users.Password);
db.Users.Add(users);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(users));
}
public ActionResult Create([Bind(Include = "AuthorID,FirstName,LastName,AuthorName,Email")] Author author)
{
if (ModelState.IsValid)
{
var FullName = author.FirstName + " " + author.LastName;
author.AuthorName = FullName;
db.Authors.Add(author);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(author));
}
public IActionResult CreatePost([FromBody] Post user)
{
try
{
if (user == null)
{
_serviceLogger.SendHiddenMessageErrorQuery();
return(BadRequest("User is null"));
}
if (!ModelState.IsValid)
{
_serviceLogger.SendHiddenMessageErrorQuery();
return(BadRequest("Invalid model"));
}
user.Id = Guid.NewGuid();
_context.Add(user);
_context.SaveChanges();
_serviceLogger.SendHiddenMessageInformation();
return(StatusCode(201));
}
catch (Exception ex)
{
_serviceLogger.SendHiddenMessageError();
return(StatusCode(500, $"Internal server error: {ex}"));
}
}
public ActionResult Create([Bind(Include = "ID,PostTitle,PostAuthor,PostTags,PostText,TitlePic,EditDate")] Posts posts)
{
if (ModelState.IsValid)
{
String aDate = DateTime.UtcNow.ToString("yyMMddHHmmss");
posts.EditDate = aDate;
db.Posts.Add(posts);
db.SaveChanges();
return(RedirectToAction("Index"));
}
//nn to drive to edit action...f**k f**k f**k
return(View(posts));
}
public static void AdicionarDadosTeste(PostDbContext context)
{
context.Post.AddRange(GetPostRepository());
context.Author.AddRange(GetAuthorRepository());
context.Comment.AddRange(GetComentRepository());
context.SaveChanges();
}
public ActionResult DeleteConfirmed(Guid id)
{
Post post = db.Post.Find(id);
db.Post.Remove(post);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public bool Guardar_Genero(Genero obj)
{
using (var modeldb = new PostDbContext())
{
modeldb.Genero.Add(obj);
modeldb.SaveChanges();
return(true);
}
}
public bool Guardar_Artista(Artista obj)
{
using (var modeldb = new PostDbContext())
{
modeldb.Artista.Add(obj);
modeldb.SaveChanges();
return(true);
}
}
public bool Guardar_Cancion(Cancion obj)
{
using (var modeldb = new PostDbContext())
{
modeldb.Cancion.Add(obj);
modeldb.SaveChanges();
return(true);
}
}
public void Actualizar_Genero(Genero obj)
{
using (var modeldb = new PostDbContext())
{
var genero = new Genero {
CveGenero = obj.CveGenero
};
modeldb.Genero.Attach(genero);
genero.NombreGenero = obj.NombreGenero;
modeldb.SaveChanges();
}
}
public void Eliminar_Artista(Artista obj)
{
using (var modeldb = new PostDbContext())
{
var artista = new Artista {
CveArtista = obj.CveArtista
};
modeldb.Artista.Attach(artista);
modeldb.Artista.Remove(artista);
modeldb.SaveChanges();
}
}
public void Actualizar_Artista(Artista obj)
{
using (var modeldb = new PostDbContext())
{
var artista = new Artista {
CveArtista = obj.CveArtista
};
modeldb.Artista.Attach(artista);
artista.NombreArtista = obj.NombreArtista;
modeldb.SaveChanges();
}
}
public void Eliminar_Cancion(Cancion obj)
{
using (var modeldb = new PostDbContext())
{
var cancion = new Cancion {
CveCancion = obj.CveCancion
};
modeldb.Cancion.Attach(cancion);
modeldb.Cancion.Remove(cancion);
modeldb.SaveChanges();
}
}
public void Eliminar_Genero(Genero obj)
{
using (var modeldb = new PostDbContext())
{
var genero = new Genero {
CveGenero = obj.CveGenero
};
modeldb.Genero.Attach(genero);
modeldb.Genero.Remove(genero);
modeldb.SaveChanges();
}
}
public ActionResult Create([Bind(Include = "PostID,Tag,FeaturedImageURL,Title,AuthorID,BlogID,Content,Date")] Post post)
{
Post matchingPost = db.Posts.Where(cm => string.Compare(cm.Title, post.Title, true) == 0).FirstOrDefault();
if (matchingPost != null)
{
ModelState.AddModelError("", "A post with that title has already been created!");
return(View(post));
}
if (ModelState.IsValid)
{
post.Date = DateTime.Now.ToString("MM-dd-yyyy");
db.Posts.Add(post);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.AuthorID = new SelectList(db.Authors, "AuthorID", "FirstName", post.AuthorID);
ViewBag.BlogID = new SelectList(db.Blogs, "BlogID", "Name", post.BlogID);
return(View(post));
}
public IActionResult Index(PostInfoVM postVm)
{
if (ModelState.IsValid)
{
_db.Posts.Add(postVm.Post);
_db.SaveChanges();
return(RedirectToAction(nameof(Index)));
}
ModelState.Clear();
return(View());
}
public AccountLoginModel()
{
int oldAdmin = db.Users.Where(x => x.Username.ToLower().Contains("admin")).Count();
if (oldAdmin == 0)
{
//Create Admin Username
Users user = new Users();
user.Username = "******";
user.Password = Crypto.SHA256("123456");
user.UserRoleEnum = UserRoleEnum.Admin;
db.Users.Add(user);
db.SaveChanges();
}
}
public void Actualizar_Cancion(Cancion obj)
{
using (var modeldb = new PostDbContext())
{
var cancion = new Cancion {
CveCancion = obj.CveCancion
};
modeldb.Cancion.Attach(cancion);
cancion.NombreCancion = obj.NombreCancion;
cancion.LetraCancion = obj.LetraCancion;
cancion.CveartistaCancion = obj.CveartistaCancion;
cancion.CvegeneroCancion = obj.CvegeneroCancion;
modeldb.SaveChanges();
}
}
public void Post([FromBody] Post post)
{
postDbContext.Add(post);
int id = postDbContext.SaveChanges();
var postModel = new PostModel
{
Id = id.ToString(),
IsActive = post.IsActive,
Description = post.Description,
Price = post.Price,
Title = post.Title
};
solrIndexService.AddUpdate(postModel);;
}
static void AddingData()
{
using (PostDbContext context = new PostDbContext())
{
//Creamos el profesor
Profesores profesor = new Profesores()
{
Nombre = "Pedro"
};
context.Add(profesor);
//Creamos los cursos
Cursos curso1 = new Cursos()
{
Nombre = "Matematicas", IdProfesor = profesor.IdProfesor
};
context.Add(curso1);
Cursos curso2 = new Cursos()
{
Nombre = "Lenguaje", IdProfesor = profesor.IdProfesor
};
context.Add(curso2);
//Creamos los alumnos
Alumnos alumno1 = new Alumnos()
{
Nombre = "Jorge", IdCurso = curso1.IdCurso
};
context.Add(alumno1);
Alumnos alumno2 = new Alumnos()
{
Nombre = "Juan", IdCurso = curso1.IdCurso
};
context.Add(alumno2);
Alumnos alumno3 = new Alumnos()
{
Nombre = "Andrea", IdCurso = curso2.IdCurso
};
context.Add(alumno3);
Alumnos alumno4 = new Alumnos()
{
Nombre = "Sandra", IdCurso = curso2.IdCurso
};
context.Add(alumno4);
//Guardamos los cambios
context.SaveChanges();
}
}
public HttpResponseMessage PostMessage([FromBody] Post p)
{
var authorUserId = User.Identity.GetUserId();
HttpResponseMessage result;
if (ModelState.IsValid)
{
using (var ctx = new PostDbContext())
{
ctx.Posts.Add(p);
ctx.SaveChanges();
}
result = Request.CreateResponse(HttpStatusCode.OK, "Meddelande skickat");
}
else
{
result = Request.CreateResponse(HttpStatusCode.BadRequest, "Någonting gick fel, försök igen!");
}
return(result);
}
public ActionResult Index(ResetPasswordViewModel model)
{
if (ModelState.IsValid)
{
PostDbContext db = new PostDbContext();
string username = LoggedUserInfo.GetLoggedUserInfo().Username;
string pp = LoggedUserInfo.GetLoggedUserInfo().PasswordHash;
string passwoord_hash = Crypto.SHA256(model.PresentPassword);
int res = db.Users.Where(x => x.Username == username && x.Password == passwoord_hash).Count();
if (res == 1)
{
//update password
try
{
Users u = db.Users.Where(x => x.Username == username && x.Password == passwoord_hash).SingleOrDefault();
u.Password = Crypto.SHA256(model.ConfirmPassword);
db.SaveChanges();
TempData["message"] = "Successfully Changed Password. Login Again with new Password";
TempData["alertType"] = "success";
Session.Abandon();
}
catch (Exception)
{
TempData["message"] = "Failed To Change Password";
TempData["alertType"] = "danger";
}
}
else
{
TempData["message"] = "Incorrect Old password";
TempData["alertType"] = "info";
}
}
return(View(model));
}
