protected void grdDepartments_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
//connect
try
{
using (DefaultConnection conn = new DefaultConnection())
{
//get the selected DepartmentID
Int32 DepartmentID = Convert.ToInt32(grdDepartments.DataKeys[e.RowIndex].Values["DepartmentID"]);
var d = (from dep in conn.Departments
where dep.DepartmentID == DepartmentID
select dep).FirstOrDefault();
//process the delete
conn.Departments.Remove(d);
conn.SaveChanges();
//update the grid
GetDepartments();
}
}
catch
{
Response.Redirect("error.aspx");
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
//use EF to connect to SQL Server
try
{
using (DefaultConnection db = new DefaultConnection())
{
//use the Student model to save the new record
Student s = new Student();
Int32 StudentID = 0;
//check the querystring for an id so we can determine add / update
if (Request.QueryString["StudentID"] != null)
{
//get the id from the url
StudentID = Convert.ToInt32(Request.QueryString["StudentID"]);
//get the current student from EF
s = (from objS in db.Students
where objS.StudentID == StudentID
select objS).FirstOrDefault();
}
s.LastName = txtLastName.Text;
s.FirstMidName = txtFirstMidName.Text;
s.EnrollmentDate = Convert.ToDateTime(txtEnrollmentDate.Text);
//call add only if we have no student ID
if (StudentID == 0)
{
db.Students.Add(s);
}
//run the update or insert
db.SaveChanges();
//redirect to the updated students page
Response.Redirect("students.aspx");
}
}
catch
{
Response.Redirect("error.aspx");
}
}
protected void grdDepartments_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
//identify the department id to be deleted from the row the user selected
Int32 DepartmentID = Convert.ToInt32(grdDepartments.DataKeys[e.RowIndex].Values["DepartmentID"]);
//connect
using (DefaultConnection db = new DefaultConnection())
{
Department dep = (from d in db.Departments
where d.DepartmentID == DepartmentID
select d).FirstOrDefault();
//delete
db.Departments.Remove(dep);
db.SaveChanges();
//refresh the grid
GetDepartments();
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
//connect
using (DefaultConnection db = new DefaultConnection())
{
//create a new course and fill the properties
Course objC = new Course();
objC.Title = txtTitle.Text;
objC.Credits = Convert.ToInt32(txtCredits.Text);
objC.DepartmentID = Convert.ToInt32(ddlDepartment.SelectedValue);
//save
db.Courses.Add(objC);
db.SaveChanges();
//redirect
Response.Redirect("courses.aspx");
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
//connect to server
using (DefaultConnection db = new DefaultConnection())
{
//Create a new student_details in memory
Student stud = new Student();
Int32 StudentID = 0;
//check for a url
if (!String.IsNullOrEmpty(Request.QueryString["StudentID"]))
{
//get the id from the url
StudentID = Convert.ToInt32(Request.QueryString["StudentID"]);
//look up the student
stud = (from s in db.Students
where s.StudentID == StudentID
select s).FirstOrDefault();
}
//Fill the properties of the new student
stud.LastName = txtLastName.Text;
stud.FirstMidName = txtFirstMidName.Text;
stud.EnrollmentDate = Convert.ToDateTime(txtEnrollmentDate.Text);
//add if we have no id in the url
if (StudentID == 0)
{
db.Students.Add(stud);
}
//save the new student
db.SaveChanges();
//redirect to the students list page
Response.Redirect("students.aspx");
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
//connect to server
using (DefaultConnection db = new DefaultConnection())
{
//Create a new department_details in memory
Department dep = new Department();
Int32 DepartmentID = 0;
//check for a url
if (!String.IsNullOrEmpty(Request.QueryString["DepartmentID"]))
{
//get the id from the url
DepartmentID = Convert.ToInt32(Request.QueryString["DepartmentID"]);
//look up the department
dep = (from d in db.Departments
where d.DepartmentID == DepartmentID
select d).FirstOrDefault();
}
//Fill the properties of the new department
dep.Name = txtName.Text;
dep.Budget = Convert.ToDecimal(txtBudget.Text);
//add if we have no id in the url
if (DepartmentID == 0)
{
db.Departments.Add(dep);
}
//save the new department
db.SaveChanges();
//redirect to the departments list page
Response.Redirect("departments.aspx");
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
//connect
try
{
using (DefaultConnection conn = new DefaultConnection())
{
//instantiate a new deparment object in memory
Department d = new Department();
//decide if updating or adding, then save
if (Request.QueryString.Count > 0)
{
Int32 DepartmentID = Convert.ToInt32(Request.QueryString["DepartmentID"]);
d = (from dep in conn.Departments
where dep.DepartmentID == DepartmentID
select dep).FirstOrDefault();
}
//fill the properties of our object from the form inputs
d.Name = txtName.Text;
d.Budget = Convert.ToDecimal(txtBudget.Text);
if (Request.QueryString.Count == 0)
{
conn.Departments.Add(d);
}
conn.SaveChanges();
//redirect to updated departments page
Response.Redirect("departments.aspx");
}
}
catch
{
Response.Redirect("error.aspx");
}
}
// protected void grdStudents_PageIndexChanging(object sender, GridViewPageEventArgs e)
// {
//set the NewPageIndex and repopulate the grid
//grdStudents.PageIndex = e.NewPageIndex;
// GetStudents();
// }
protected void grdStudents_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
//Store which row was clicked
Int32 selectedRow = e.RowIndex;
//get the selected StudentID using the grid's Data collection
Int32 StudentID = Convert.ToInt32(grdStudents.DataKeys[selectedRow].Values["StudentID"]);
//connect
using (DefaultConnection db = new DefaultConnection())
{
Student stud = (from s in db.Students
where s.StudentID == StudentID
select s).FirstOrDefault();
//delete
db.Students.Remove(stud);
db.SaveChanges();
//refresh the grid
GetStudents();
}
}
protected void grdCourses_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
Int32 CourseID = Convert.ToInt32(grdCourses.DataKeys[e.RowIndex].Values["CourseID"].ToString());
try
{
using (DefaultConnection db = new DefaultConnection())
{
Course objC = (from c in db.Courses
where c.CourseID == CourseID
select c).FirstOrDefault();
db.Courses.Remove(objC);
db.SaveChanges();
}
GetCourses();
}
catch
{
Response.Redirect("error.aspx");
}
}
protected void SaveButton_Click(object sender, EventArgs e)
{
Department department = new Department();
using (DefaultConnection db = new DefaultConnection())
{
int departmentId = 0;
if (Request.QueryString.Count > 0)
{
departmentId = Convert.ToInt32(Request.QueryString["DepartmentID"]);
department = (from depart in db.Departments
where depart.DepartmentID == departmentId
select depart).FirstOrDefault();
}
department.Name = NameTextBox.Text;
department.Budget = Convert.ToDecimal(BudgetTextBox.Text.ToString());
if (departmentId == 0)
{
db.Departments.Add(department);
}
db.SaveChanges();
Response.Redirect("~/Departments.aspx");
}
}
protected void SaveButton_Click(object sender, EventArgs e)
{
//use EF to connect to the server
using (DefaultConnection db = new DefaultConnection())
{
//use the student model to save a new record
Student newStudent = new Student();
int StudentID = 0;
if (Request.QueryString.Count > 0)
{
//get the id from the URL
StudentID = Convert.ToInt32(Request.QueryString["StudentID"]);
//get the current student from EF DB
newStudent = (from student in db.Students
where student.StudentID == StudentID
select student).FirstOrDefault();
}
newStudent.LastName = LastNameTextBox.Text;
newStudent.FirstMidName = FirstNameTextBox.Text;
newStudent.EnrollmentDate = Convert.ToDateTime(EnrollmentDateTextBox.Text);
if (StudentID == 0)
{
db.Students.Add(newStudent);
}
//run an insert command
db.SaveChanges();
//redirect back to the students page
Response.Redirect("~/Students.aspx");
}
}
protected void SaveButton_Click(object sender, EventArgs e)
{
// Use EF to connect to the server
using (DefaultConnection db = new DefaultConnection())
{
// use the Student model to create a new student object and
// save a new record
Student newStudent = new Student();
// add form data to the new student record
newStudent.LastName = LastNameTextBox.Text;
newStudent.FirstMidName = FirstNameTextBox.Text;
newStudent.EnrollmentDate = Convert.ToDateTime(EnrollmentDateTextBox.Text);
// use LINQ to ADO.NET to add / insert new student into the database
db.Students.Add(newStudent);
// save our changes
db.SaveChanges();
// Redirect back to the updated students page
Response.Redirect("~/Students.aspx");
}
}
protected void DepartmentsGridView_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
// store which row was clicked
int selectedRow = e.RowIndex;
// get the selected DepartmentID using the Grid's DataKey Collection
int DepartmentID = Convert.ToInt32(DepartmentsGridView.DataKeys[selectedRow].Values["DepartmentID"]);
// use EF to find the selected Department from DB and remove it
using (DefaultConnection db = new DefaultConnection())
{
Department deletedDepartment = (from DepartmentRecords in db.Departments
where DepartmentRecords.DepartmentID == DepartmentID
select DepartmentRecords).FirstOrDefault();
// perform the removal in the DB
db.Departments.Remove(deletedDepartment);
db.SaveChanges();
// refresh the grid
this.GetDepartments();
}
}
protected void SaveButton_Click(object sender, EventArgs e)
{
// connect to EF DB
using (DefaultConnection db = new DefaultConnection())
{
// use the student model to save a new record
Department newDepartment = new Department();
int DepartmentID = 0;
//IF adding a new student, run this, else skip it
if (Request.QueryString.Count > 0) //Our URL HAS a student id
{
DepartmentID = Convert.ToInt32(Request.QueryString["DepartmentID"]);
newDepartment = (from department in db.Departments
where department.DepartmentID == DepartmentID
select department).FirstOrDefault();
}
newDepartment.Name = NameTextBox.Text;
newDepartment.Budget = Convert.ToDecimal(BudgetTextBox.Text);
//Only add if new student
if (DepartmentID == 0)
{
db.Departments.Add(newDepartment);
}
// run insert in DB
db.SaveChanges();
// redirect to the updated students page
Response.Redirect("~/Departments.aspx");
}
}
public ActionResult VersionEdit([Bind(Include = "ID,Title,Category,Slug,Date,Body,Body2,UserID")] EP_POSTS EP_POST, int?return_id)
{
if (ModelState.IsValid)
{
EP_POSTS ep = db.EP_POST.Find(return_id);
string guidval = ep.GUID;
EP_POST.GUID = guidval;
EP_POST.Ref = guidval;
EP_POST.UserID = User.Identity.GetUserId();
EP_POST.Date = DateTime.Now;
EP_POST.Type = "Post";
db.EP_POST.Add(EP_POST);
db.SaveChanges();
return(RedirectToAction("Index", "Archive"));
}
return(View(EP_POST));
}
public IHttpActionResult SetMood(string id)
{
var mood = _db.Mood.ToList().Where(x => x.UserId == id.Split('_')[0]);
MoodModel mm = new MoodModel();
int type = Convert.ToInt32(id.Split('_')[1]);
var moodModels = mood as MoodModel[] ?? mood.ToArray();
if (moodModels.Any())
{
if (mm.Date == DateTime.Now.ToString())
{
mm = moodModels.First();
mm.Date = DateTime.Now.ToString();
mm.Type = type;
_db.Entry(mm).State = System.Data.Entity.EntityState.Modified;
_db.SaveChanges();
}
else
{
mm.Id = Guid.NewGuid().ToString();
mm.UserId = id;
mm.Date = DateTime.Now.ToString();
mm.Type = type;
_db.Mood.Add(mm);
_db.SaveChanges();
}
}
else
{
mm.Id = Guid.NewGuid().ToString();
mm.UserId = id;
mm.Date = DateTime.Now.ToString();
mm.Type = type;
_db.Mood.Add(mm);
_db.SaveChanges();
}
return(Ok("set"));
}
public Comment Create(Comment comment)
{
_db.Comments.Add(comment);
_db.SaveChanges();
return(comment);
}
public ActionResult EditProduct(ProductVM model, HttpPostedFileBase file)
{
// Get product id
int id = model.Id;
// Populate categories select list and gallery images
using (DefaultConnection db = new DefaultConnection())
{
model.Categories = new SelectList(db.Categories.ToList(), "Id", "Name");
}
model.GalleryImages = Directory.EnumerateFiles(Server.MapPath("~/Images/Uploads/Products/" + id + "/Gallery/Thumbs"))
.Select(fn => Path.GetFileName(fn));
// Check model state
if (!ModelState.IsValid)
{
return(View(model));
}
// Make sure product name is unique
using (DefaultConnection db = new DefaultConnection())
{
if (db.Products.Where(x => x.Id != id).Any(x => x.Name == model.Name))
{
ModelState.AddModelError("", "That product name is taken!");
return(View(model));
}
}
// Update product
using (DefaultConnection db = new DefaultConnection())
{
ProductDTO dto = db.Products.Find(id);
dto.Name = model.Name;
dto.Slug = model.Name.Replace(" ", "-").ToLower();
dto.Description = model.Description;
dto.Price = model.Price;
dto.CategoryId = model.CategoryId;
dto.ImageName = model.ImageName;
CategoryDTO catDTO = db.Categories.FirstOrDefault(x => x.Id == model.CategoryId);
dto.CategoryName = catDTO.Name;
db.SaveChanges();
}
// Set TempData message
TempData["SM"] = "You have edited the product!";
#region Image Upload
// Check for file upload
if (file != null && file.ContentLength > 0)
{
// Get extension
string ext = file.ContentType.ToLower();
// Verify extension
if (ext != "image/jpg" &&
ext != "image/jpeg" &&
ext != "image/pjpeg" &&
ext != "image/gif" &&
ext != "image/x-png" &&
ext != "image/png")
{
using (DefaultConnection db = new DefaultConnection())
{
ModelState.AddModelError("", "The image was not uploaded - wrong image extension.");
return(View(model));
}
}
// Set uplpad directory paths
var originalDirectory = new DirectoryInfo(string.Format("{0}Images\\Uploads", Server.MapPath(@"\")));
var pathString1 = Path.Combine(originalDirectory.ToString(), "Products\\" + id.ToString());
var pathString2 = Path.Combine(originalDirectory.ToString(), "Products\\" + id.ToString() + "\\Thumbs");
// Delete files from directories
DirectoryInfo di1 = new DirectoryInfo(pathString1);
DirectoryInfo di2 = new DirectoryInfo(pathString2);
foreach (FileInfo file2 in di1.GetFiles())
{
file2.Delete();
}
foreach (FileInfo file3 in di2.GetFiles())
{
file3.Delete();
}
// Save image name
string imageName = file.FileName;
using (DefaultConnection db = new DefaultConnection())
{
ProductDTO dto = db.Products.Find(id);
dto.ImageName = imageName;
db.SaveChanges();
}
// Save original and thumb images
var path = string.Format("{0}\\{1}", pathString1, imageName);
var path2 = string.Format("{0}\\{1}", pathString2, imageName);
file.SaveAs(path);
WebImage img = new WebImage(file.InputStream);
img.Resize(200, 200);
img.Save(path2);
}
#endregion
// Redirect
return(RedirectToAction("EditProduct"));
}
public ActionResult AddProduct(ProductVM model, HttpPostedFileBase file)
{
// Check model state
if (!ModelState.IsValid)
{
using (DefaultConnection db = new DefaultConnection())
{
model.Categories = new SelectList(db.Categories.ToList(), "Id", "Name");
return(View(model));
}
}
// Make sure product name is unique
using (DefaultConnection db = new DefaultConnection())
{
if (db.Products.Any(x => x.Name == model.Name))
{
model.Categories = new SelectList(db.Categories.ToList(), "Id", "Name");
ModelState.AddModelError("", "That product name is taken!");
return(View(model));
}
}
// Declare product id
int id;
// Init and save productDTO
using (DefaultConnection db = new DefaultConnection())
{
ProductDTO product = new ProductDTO();
product.Name = model.Name;
product.Slug = model.Name.Replace(" ", "-").ToLower();
product.Description = model.Description;
product.Price = model.Price;
product.CategoryId = model.CategoryId;
CategoryDTO catDTO = db.Categories.FirstOrDefault(x => x.Id == model.CategoryId);
product.CategoryName = catDTO.Name;
db.Products.Add(product);
db.SaveChanges();
// Get the id
id = product.Id;
}
// Set TempData message
TempData["SM"] = "You have added a product!";
#region Upload Image
// Create necessary directories
var originalDirectory = new DirectoryInfo(string.Format("{0}Images\\Uploads", Server.MapPath(@"\")));
var pathString1 = Path.Combine(originalDirectory.ToString(), "Products");
var pathString2 = Path.Combine(originalDirectory.ToString(), "Products\\" + id.ToString());
var pathString3 = Path.Combine(originalDirectory.ToString(), "Products\\" + id.ToString() + "\\Thumbs");
var pathString4 = Path.Combine(originalDirectory.ToString(), "Products\\" + id.ToString() + "\\Gallery");
var pathString5 = Path.Combine(originalDirectory.ToString(), "Products\\" + id.ToString() + "\\Gallery\\Thumbs");
if (!Directory.Exists(pathString1))
{
Directory.CreateDirectory(pathString1);
}
if (!Directory.Exists(pathString2))
{
Directory.CreateDirectory(pathString2);
}
if (!Directory.Exists(pathString3))
{
Directory.CreateDirectory(pathString3);
}
if (!Directory.Exists(pathString4))
{
Directory.CreateDirectory(pathString4);
}
if (!Directory.Exists(pathString5))
{
Directory.CreateDirectory(pathString5);
}
// Check if a file was uploaded
if (file != null && file.ContentLength > 0)
{
// Get file extension
string ext = file.ContentType.ToLower();
// Verify extension
if (ext != "image/jpg" &&
ext != "image/jpeg" &&
ext != "image/pjpeg" &&
ext != "image/gif" &&
ext != "image/x-png" &&
ext != "image/png")
{
using (DefaultConnection db = new DefaultConnection())
{
model.Categories = new SelectList(db.Categories.ToList(), "Id", "Name");
ModelState.AddModelError("", "The image was not uploaded - wrong image extension.");
return(View(model));
}
}
// Init image name
string imageName = file.FileName;
// Save image name to DTO
using (DefaultConnection db = new DefaultConnection())
{
ProductDTO dto = db.Products.Find(id);
dto.ImageName = imageName;
db.SaveChanges();
}
// Set original and thumb image paths
var path = string.Format("{0}\\{1}", pathString2, imageName);
var path2 = string.Format("{0}\\{1}", pathString3, imageName);
// Save original
file.SaveAs(path);
// Create and save thumb
WebImage img = new WebImage(file.InputStream);
img.Resize(200, 200);
img.Save(path2);
}
#endregion
// Redirect
return(RedirectToAction("AddProduct"));
}
public ArticleLike SaveLikeDislike(ArticleLike articleLike)
{
_db.ArticleLikes.Add(articleLike);
_db.SaveChanges();
return(articleLike);
}
public void NHanNanum(string url, int idx, EP_KEYWORD EP_KEYWORD)
{
try
{
FileInfo _finfo = new FileInfo(url);
if (_finfo.Exists == true)
{
XmlDocument xmldoc = new XmlDocument();
xmldoc.Load(url);
XmlElement root = xmldoc.DocumentElement;
XmlNodeList nodes = root.ChildNodes;
string document = "";
string link = "";
string title = "";
string category = "";
string tag = "";
foreach (XmlNode node in nodes)
{
switch (node.Name)
{
case "title":
title = node.InnerText;
break;
case "category":
category = node.InnerText;
break;
case "link":
link = node.InnerText;
break;
case "description":
document = node.InnerText;
break;
case "tag":
tag = node.InnerText;
break;
}
}
document = Regex.Replace(document, @"[<][a-z|A-Z|/](.|\n|\r)*?[>]", "");
document = document.Replace("\t", " ").Replace("\r", " ").Replace("\n", " ");
document = document.Replace(" ", " ").Replace("&", "").Replace(""", "").Replace("<", "").Replace(">", "");
if (document == "")
{
return;
}
EP_KEYWORD.ArticleID = idx;
EP_KEYWORD.Count = -1;
EP_KEYWORD.Link = link;
EP_KEYWORD.Description = document;
EP_KEYWORD.Title = title;
//EP_KEYWORD.Keyword = sp_tag[i];
db.EP_KEYWORD.Add(EP_KEYWORD);
db.SaveChanges();
if (tag != "")
{
string[] sp_tag = tag.Split(',');
if (sp_tag.Length > 1)
{
for (int i = 0; i < sp_tag.Length; i++)
{
EP_KEYWORD.ArticleID = idx;
EP_KEYWORD.Count = 0;
//EP_KEYWORD.Link = link;
//EP_KEYWORD.Description = document;
//EP_KEYWORD.Title = title;
EP_KEYWORD.Keyword = sp_tag[i];
db.EP_KEYWORD.Add(EP_KEYWORD);
db.SaveChanges();
}
}
else
{
EP_KEYWORD.ArticleID = idx;
EP_KEYWORD.Count = 0;
//EP_KEYWORD.Link = link;
//EP_KEYWORD.Description = document;
//EP_KEYWORD.Title = title;
EP_KEYWORD.Keyword = sp_tag[0];
db.EP_KEYWORD.Add(EP_KEYWORD);
db.SaveChanges();
}
}
//Workflow workflow = WorkflowFactory.getPredefinedWorkflow(WorkflowFactory.WORKFLOW_NOUN_EXTRACTOR);
string newFileName = "/";
string newFileLocation = HttpContext.Server.MapPath(newFileName);
Workflow workflow = new Workflow(newFileLocation);
workflow.appendPlainTextProcessor(new kr.ac.kaist.swrc.jhannanum.plugin.SupplementPlugin.PlainTextProcessor.SentenceSegmentor.SentenceSegmentor(), null);
workflow.appendPlainTextProcessor(new kr.ac.kaist.swrc.jhannanum.plugin.SupplementPlugin.PlainTextProcessor.InformalSentenceFilter.InformalSentenceFilter(), null);
workflow.setMorphAnalyzer(new kr.ac.kaist.swrc.jhannanum.plugin.MajorPlugin.MorphAnalyzer.ChartMorphAnalyzer.ChartMorphAnalyzer(), "conf/plugin/MajorPlugin/MorphAnalyzer/ChartMorphAnalyzer.json");
workflow.appendMorphemeProcessor(new kr.ac.kaist.swrc.jhannanum.plugin.SupplementPlugin.MorphemeProcessor.UnknownMorphProcessor.UnknownProcessor(), null);
workflow.setPosTagger(new kr.ac.kaist.swrc.jhannanum.plugin.MajorPlugin.PosTagger.HmmPosTagger.HMMTagger(), "conf/plugin/MajorPlugin/PosTagger/HmmPosTagger.json");
workflow.appendPosProcessor(new kr.ac.kaist.swrc.jhannanum.plugin.SupplementPlugin.PosProcessor.NounExtractor.NounExtractor(), null);
workflow.activateWorkflow(true);
workflow.analyze(document);
int cnt = 1;
List <Record> records = new List <Record>();
LinkedList <Sentence> resultList = workflow.getResultOfDocument(new Sentence(0, 0, false));
foreach (Sentence s in resultList)
{
Eojeol[] eojeolArray = s.Eojeols;
for (int i = 0; i < eojeolArray.Length; i++)
{
if (eojeolArray[i].length > 0)
{
String[] morphemes = eojeolArray[i].Morphemes;
for (int j = 0; j < morphemes.Length; j++)
{
records.Add(new Record()
{
Id = cnt, Value = morphemes[j]
});
cnt++;
}
}
}
}
var query = from r in records
group r by r.Value into g
select new { Count = g.Count(), Value = g.Key };
query = query.OrderByDescending(a => a.Count);
foreach (var v in query)
{
if (v.Count > 1 && v.Value[0].ToString() != @"\" && v.Value[0].ToString() != @"&" && v.Value.Length != 1)
{
EP_KEYWORD.ArticleID = idx;
EP_KEYWORD.Count = v.Count;
//EP_KEYWORD.Link = link;
//EP_KEYWORD.Description = document;
//EP_KEYWORD.Title = title;
EP_KEYWORD.Keyword = v.Value;
db.EP_KEYWORD.Add(EP_KEYWORD);
db.SaveChanges();
}
}
workflow.close();
}
else if (_finfo.Exists == false)
{
}
}
catch (Exception) { }
}
public void DeleteArticle(int id)
{
_db.Articles.Remove(_db.Articles.Find(id));
_db.SaveChanges();
}
public void add(Category category)
{
db.Category.Add(category);
db.SaveChanges();
}
public int Complete()
{
return(_context.SaveChanges());
}
public void Save()
{
db.SaveChanges();
}
public void Update(AspNetUser aspNetUser)
{
_db.AspNetUsers.AddOrUpdate(aspNetUser);
_db.SaveChanges();
}
public Role Create(Role role)
{
_db.Role.Add(role);
_db.SaveChanges();
return(role);
}
public IHttpActionResult Like(JObject jsonData)
{
var lm = new LikeModel();
dynamic json = jsonData;
var user = UserViewModel.GetCurrentUser();
var liked = _db.Like.ToList().Where(x => x.Type == Convert.ToInt32(json.type) && x.TypeId == json.typeId.ToString() && x.UserId == user.Id);
var likeModels = liked as LikeModel[] ?? liked.ToArray();
if (!likeModels.Any())
{
lm.Id = Guid.NewGuid().ToString();
lm.Type = json.type;
lm.UserId = user.Id;
lm.TypeId = json.typeId.ToString();
_db.Like.Add(lm);
if (json.type == 1)
{
DietModel d = _db.Diet.Find(json.typeId.ToString());
d.Likes++;
_db.Entry(d).State = System.Data.Entity.EntityState.Modified;
}
if (json.type == 2)
{
FitnessModel f = _db.Fitness.Find(json.typeId.ToString());
f.Likes++;
_db.Entry(f).State = System.Data.Entity.EntityState.Modified;
}
if (json.type == 3)
{
HealthModel h = _db.Health.Find(json.typeId.ToString());
h.Likes++;
_db.Entry(h).State = System.Data.Entity.EntityState.Modified;
}
_db.SaveChanges();
return(Ok(lm));
}
else
{
var like = likeModels.First();
_db.Like.Remove(like);
if (json.type == 1)
{
DietModel d = _db.Diet.Find(json.typeId.ToString());
d.Likes = d.Likes - 1;
_db.Entry(d).State = System.Data.Entity.EntityState.Modified;
}
if (json.type == 2)
{
FitnessModel f = _db.Fitness.Find(json.typeId.ToString());
f.Likes = f.Likes - 1;
_db.Entry(f).State = System.Data.Entity.EntityState.Modified;
}
if (json.type == 3)
{
HealthModel h = _db.Health.Find(json.typeId.ToString());
h.Likes = h.Likes - 1;
_db.Entry(h).State = System.Data.Entity.EntityState.Modified;
}
_db.SaveChanges();
return(Ok());
}
}
public ActionResult EditUser(UsersInRolesModel model /*AspNetUser aspNetUser*/)
{
db.Entry(model).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("UsersWithRoles"));
}
public ActionResult ReserveringToevoegenPost(ReserveringModel reserveringsModel)
{
reserveringsModel.Velden = repository.Velds.ToList();
reserveringsModel.Plaatsen = repository.Plaatss.ToList();
reserveringsModel.Reserveringen = repository.Reserverings.Where(p => p.BeginDatum >= reserveringsModel.Reservering.BeginDatum && p.BeginDatum <= reserveringsModel.Reservering.EindDatum || p.EindDatum <= reserveringsModel.Reservering.BeginDatum && p.EindDatum >= reserveringsModel.Reservering.EindDatum).ToList();
reserveringsModel.Boekingen = repository.Boekings.Where(d => d.BeginDatum >= reserveringsModel.Reservering.BeginDatum && d.BeginDatum <= reserveringsModel.Reservering.EindDatum || d.EindDatum <= reserveringsModel.Reservering.BeginDatum && d.EindDatum >= reserveringsModel.Reservering.EindDatum).ToList();
Reservering resv = new Reservering
{
BeginDatum = reserveringsModel.Reservering.BeginDatum,
EindDatum = reserveringsModel.Reservering.EindDatum,
Email = reserveringsModel.Reservering.Email,
Naam = reserveringsModel.Reservering.Naam,
Telnr = reserveringsModel.Reservering.Telnr,
PlaatsId = reserveringsModel.Reservering.PlaatsId,
AantalPersonen = reserveringsModel.Reservering.AantalPersonen
};
resv.Plaats = reserveringsModel.Plaatsen.Where(p => p.PlaatsID.Equals(reserveringsModel.Reservering.PlaatsId)).First();
if (reserveringsModel.Reserveringen != null)
{
int i = 0;
foreach (var id in reserveringsModel.Reserveringen)
{
idList.Add(id.PlaatsId);
}
foreach (var idB in reserveringsModel.Boekingen)
{
if (!idList.Contains(idB.PlaatsId))
{
idList.Add(idB.PlaatsId);
}
}
var resvIdArray = idList.ToArray();
var PlaatsArray = reserveringsModel.Plaatsen.ToArray();
while (i <= PlaatsArray.Length)
{
if (resvIdArray.Contains(PlaatsArray[i].PlaatsID))
{
i++;
if (i == PlaatsArray.Length)
{
//throw new Exception("Geen plek");
return(RedirectToAction("GeenPlek"));
}
else
{
continue;
}
}
else
{
resv.PlaatsId = PlaatsArray[i].PlaatsID;
}
resv.Plaats = reserveringsModel.Plaatsen.Where(p => p.PlaatsID.Equals(reserveringsModel.Reservering.PlaatsId)).First();
resv.VeldID = reserveringsModel.Velden.Where(p => p.VeldID.Equals(resv.PlaatsId)).First().VeldID;
resv.Plaats = null;
if (ModelState.IsValid)
{
if (reserveringsModel.Reservering.EindDatum > reserveringsModel.Reservering.BeginDatum)
{
db.Reserverings.Add(resv);
db.SaveChanges();
return(RedirectToAction("ReserveringSucces"));
}
}
return(View(reserveringsModel));
}
}
else
{
if (ModelState.IsValid)
{
if (reserveringsModel.Reservering.EindDatum > reserveringsModel.Reservering.BeginDatum)
{
resv.Plaats = reserveringsModel.Plaatsen.Where(p => p.PlaatsID.Equals(reserveringsModel.Reservering.PlaatsId)).First();
resv.VeldID = reserveringsModel.Velden.Where(p => p.VeldID.Equals(resv.PlaatsId)).First().VeldID;
db.Reserverings.Add(resv);
db.SaveChanges();
return(RedirectToAction("ReserveringSucces"));
}
}
return(View(reserveringsModel));
}
return(View(reserveringsModel));
}
public ActionResult EditBoekingPost(BoekingViewModel reserveringsModel)
{
reserveringsModel.Velden = repository.Velds.Where(p => p.VeldID.Equals(reserveringsModel.Reserv.VeldID)).ToList();
reserveringsModel.Plaatsen = repository.Plaatss.Where(p => p.VeldID.Equals(reserveringsModel.Reserv.VeldID)).ToList();
Plaats GekozenPlaats = reserveringsModel.Plaatsen.First();
Veld GekozenVeld = reserveringsModel.Velden.FirstOrDefault();
reserveringsModel.Resveringens = repository.Reserverings.Where(p => p.BeginDatum >= reserveringsModel.Reserv.BeginDatum && p.BeginDatum <= reserveringsModel.Reserv.EindDatum || p.EindDatum <= reserveringsModel.Reserv.BeginDatum && p.EindDatum >= reserveringsModel.Reserv.EindDatum).ToList();
reserveringsModel.Boekings = repository.Boekings.Where(p => p.BeginDatum >= reserveringsModel.Boeking.BeginDatum && p.BeginDatum <= reserveringsModel.Boeking.EindDatum || p.EindDatum <= reserveringsModel.Boeking.BeginDatum && p.EindDatum >= reserveringsModel.Boeking.EindDatum).ToList();
if (GekozenPlaats == null)
{
db.SaveChanges();
return(RedirectToAction("ReserveringSucces", "Bezoeker", new { area = "" }));
}
if (reserveringsModel.Resveringens != null)
{
int i = 0;
foreach (var id in reserveringsModel.Resveringens)
{
idList.Add(id.PlaatsId);
}
foreach (var id in reserveringsModel.Boekings)
{
if (!idList.Contains(id.PlaatsId))
{
idList.Add(id.PlaatsId);
}
}
var resvIdArray = idList.ToArray();
var PlaatsArray = reserveringsModel.Plaatsen.ToArray();
while (i <= PlaatsArray.Length)
{
if (resvIdArray.Contains(PlaatsArray[i].PlaatsID))
{
i++;
if (i == PlaatsArray.Length)
{
//throw new Exception("Geen plek");
return(RedirectToAction("GeenPlek", "Bezoeker", new { area = "" }));
}
else
{
continue;
}
}
else
{
reserveringsModel.Reserv.PlaatsId = PlaatsArray[i].PlaatsID;
}
if (ModelState.IsValid)
{
if (reserveringsModel.Reserv.EindDatum > reserveringsModel.Reserv.BeginDatum)
{
db.Entry(reserveringsModel.Boeking).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("ReserveringSucces", "Bezoeker", new { area = "" }));
}
}
return(View(reserveringsModel));
}
}
else
{
if (ModelState.IsValid)
{
if (reserveringsModel.Reserv.EindDatum > reserveringsModel.Reserv.BeginDatum)
{
db.Entry(reserveringsModel.Reserv).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("ReserveringSucces", "Bezoeker", new { area = "" }));
}
}
return(View(reserveringsModel));
}
return(View(reserveringsModel));
}
//public Article CreateArticle(Article article)
//{
// return _iArticleRepository.CreateArticle(article);
//}
public Article CreateArticle(Article article)
{
_db.Articles.Add(article);
_db.SaveChanges();
return(article);
}
public CommentReport SaveReport(CommentReport commentReport)
{
_db.CommentReports.Add(commentReport);
_db.SaveChanges();
return(commentReport);
}
public bool Post(SMI_Treasury treasury)
{
BD.SMI_Treasury.Add(treasury);
return(BD.SaveChanges() > 0);
}
public ActionResult Create(Customer cus)
{
db.Customers.Add(cus);
db.SaveChanges();
return(RedirectToAction("ShowToCart", "ShoppingCart"));
}
public ActionResult Create([Bind(Include = "ID,UserID,publish,publish_SITE,Publish_ID,Publish_PW,Publish_BLOGID,Publish_BLOGKEY")] EP_METAS eP_METAS, string SERVICE)
{
if (ModelState.IsValid)
{
if (SERVICE == "Tistory")
{
try
{
string[] strarray = eP_METAS.publish_SITE.Split('/');
MetaWeblog api = new MetaWeblog("http://" + strarray[2] + "/api");
Post[] check_login = new Post[1];
check_login = api.getRecentPosts(eP_METAS.Publish_BLOGID, eP_METAS.Publish_ID, eP_METAS.Publish_PW, 1);
}
catch
{
ModelState.AddModelError("", "사용자 이름 또는 암호가 잘못되었습니다.");
return(View());
}
}
if (SERVICE == "Naver")
{
try
{
string[] strarray = eP_METAS.publish_SITE.Split('/');
MetaWeblog api = new MetaWeblog("https://api.blog.naver.com/xmlrpc");
Post[] check_login = new Post[1];
check_login = api.getRecentPosts(eP_METAS.Publish_BLOGID, eP_METAS.Publish_ID, eP_METAS.Publish_BLOGKEY, 1);
}
catch
{
ModelState.AddModelError("", "사용자 이름 또는 암호가 잘못되었습니다.");
return(View());
}
}
if (SERVICE == "WordPress")
{
try
{
string[] strarray = eP_METAS.publish_SITE.Split('/');
MetaWeblog api = new MetaWeblog(eP_METAS.publish_SITE + "/xmlrpc.php");
Post[] check_login = new Post[1];
check_login = api.getRecentPosts("", eP_METAS.Publish_ID, eP_METAS.Publish_PW, 1);
}
catch
{
ModelState.AddModelError("", "사용자 이름 또는 암호가 잘못되었습니다.");
//return View();
return(RedirectToAction("Create", "BlogAPI", new { SERVICE = "WordPress" }));
}
}
//if (SERVICE == "Blogger")
//{
// try
// {
// string[] strarray = eP_METAS.publish_SITE.Split('/');
// MetaWeblog api = new MetaWeblog("http://www.blogger.com/feeds/" + eP_METAS.ID +"/posts/default");
// Post[] check_login = new Post[1];
// check_login = api.getRecentPosts("", eP_METAS.Publish_ID, eP_METAS.Publish_PW, 1);
// }
// catch
// {
// ModelState.AddModelError("", "사용자 이름 또는 암호가 잘못되었습니다.");
// return View();
// }
//}
eP_METAS.publish = SERVICE;
eP_METAS.UserID = User.Identity.GetUserId();
//eP_METAS.publish = ViewData["Metaservice"].ToString;
db.EP_META.Add(eP_METAS);
db.SaveChanges();
return(RedirectToAction("Manage", "Account"));
}
return(View(eP_METAS));
}