public ActionResult AddEditProject(ProjectModels mdl)
{
if (mdl.Id > 0)
{
XDocument xmlDoc = XDocument.Load(Server.MapPath("~/XML/ProjectList.xml"));
var items = (from item in xmlDoc.Descendants("Project") select item).ToList();
XElement selected = items.Where(p => p.Element("Id").Value == mdl.Id.ToString()).FirstOrDefault();
selected.Remove();
xmlDoc.Save(Server.MapPath("~/XML/ProjectList.xml"));
xmlDoc.Element("Projects").Add(new XElement("Project", new XElement("Id", mdl.Id), new XElement("ProjectName", mdl.ProjectName), new XElement("Location", mdl.Location)));
xmlDoc.Save(Server.MapPath("~/XML/ProjectList.xml"));
return(RedirectToAction("Index", "Admin"));
}
else
{
XmlDocument oXmlDocument = new XmlDocument();
oXmlDocument.Load(Server.MapPath("~/XML/ProjectList.xml"));
XmlNodeList nodelist = oXmlDocument.GetElementsByTagName("Project");
var x = oXmlDocument.GetElementsByTagName("Id");
int Max = 0;
foreach (XmlElement item in x)
{
int EId = Convert.ToInt32(item.InnerText.ToString());
if (EId > Max)
{
Max = EId;
}
}
Max = Max + 1;
XDocument xmlDoc = XDocument.Load(Server.MapPath("~/XML/ProjectList.xml"));
xmlDoc.Element("Projects").Add(new XElement("Project", new XElement("Id", Max), new XElement("ProjectName", mdl.ProjectName), new XElement("Location", mdl.Location)));
xmlDoc.Save(Server.MapPath("~/XML/ProjectList.xml"));
return(RedirectToAction("Index", "Admin"));
}
}
public ActionResult Index()
{
var tag = Request.QueryString["tag"];
var db = new ProjectModels();
List <Article> list;
if (string.IsNullOrEmpty(tag))
{
list = db.Article.OrderByDescending(a => a.addtime).ToList();
}
else
{
int tid = 0;
if (int.TryParse(tag, out tid))
{
var rlist = db.R_ArticleTags.Where(a => a.tagid == tid).Select(a => a.articleid).ToArray();
list = db.Article.Where(a => rlist.Contains(a.id)).OrderByDescending(a => a.addtime).ToList();
}
else
{
list = db.Article.OrderByDescending(a => a.addtime).ToList();
}
}
return(View(list));
}
public ActionResult FinalTranslation(ProjectModels model)
{
if (model.Id > 0)
{
string xml_path = HostingEnvironment.MapPath("~/App_Data/TranslateList.xml");
XDocument oXmlDocument = XDocument.Load(xml_path);
var items = (from item in oXmlDocument.Descendants("Translation")
where Convert.ToInt32(item.Attribute("id").Value) == model.Id
select new ProjectModels
{
Id = Convert.ToInt32(item.Attribute("id").Value),
From = item.Element("From").Value,
To = item.Element("To").Value,
}).SingleOrDefault();
if (items != null)
{
model.Id = items.Id;
model.From = items.From;
model.To = items.To;
}
return(View(model));
}
return(Redirect("Index"));
}
public ActionResult Update(ProjectModels project, FormCollection collection)
{
doc.Load(Server.MapPath(xmlDocLocation));
XmlNode RootNode = doc.SelectSingleNode("Projects");
XmlNodeList projects = RootNode.ChildNodes;
XmlNode node = projects[0];
foreach (XmlNode ns in projects)
{
//match the selected id
if (ns["Id"].InnerText == project.ProjId.ToString())
{
node = ns;
}
}
//update the node value from new value entered
node["ProjectName"].InnerText = project.ProjName;
node["Location"].InnerText = project.Location;
doc.Save(Server.MapPath(xmlDocLocation));
return(RedirectToAction("Index"));
}
private void PopulateBackgroundWorkerOnDoWork(object sender, DoWorkEventArgs doWorkEventArgs)
{
this.Logger().Trace("Begin Populate");
Application.Current.Dispatcher.Invoke(() => IsPopulating = true, DispatcherPriority.Normal);
Project[] projects;
if (teamPilgrimServiceModelProvider.TryGetProjects(out projects, TfsTeamProjectCollection))
{
Application.Current.Dispatcher.Invoke(() => ProjectModels.Clear(), DispatcherPriority.Normal);
var pilgrimProjectModels = projects
.Select(project =>
new ProjectServiceModel(teamPilgrimServiceModelProvider, teamPilgrimVsService,
TeamPilgrimServiceModel, TfsTeamProjectCollection, project))
.ToArray();
var index = 0;
foreach (var pilgrimProjectModel in pilgrimProjectModels)
{
var localScoprProjectModel = pilgrimProjectModel;
Application.Current.Dispatcher.Invoke(() => ProjectModels.Add(localScoprProjectModel), DispatcherPriority.Normal);
_populateBackgroundWorker.ReportProgress((int)(index++ / (decimal)pilgrimProjectModels.Count() * 100));
index++;
}
}
Application.Current.Dispatcher.Invoke(() => IsPopulating = false, DispatcherPriority.Normal);
this.Logger().Trace("End Populate");
}
public JsonResult SaveBlog(int id, int tagid, string title, string content, string contenthtml)
{
var db = new ProjectModels();
Article o;
if (id > 0)
{
o = db.Article.First(a => a.id == id);
}
else
{
o = new Article();
}
o.title = title;
o.content = content;
o.contenthtml = contenthtml;
if (id == 0)
{
o.addtime = DateTime.Now;
db.Article.Add(o);
db.SaveChanges();
}
db.R_ArticleTags.RemoveRange(db.R_ArticleTags.Where(a => a.articleid == id));
db.R_ArticleTags.Add(new R_ArticleTags()
{
articleid = o.id, tagid = tagid, addtime = DateTime.Now
});
db.SaveChanges();
return(Json(new { id = o.id }));
}
//
// GET: /Admin/
public ActionResult Index()
{
int i2344 = 0;
List <ProjectModels> lstProject = new List <ProjectModels>();
DataSet ds = new DataSet();
ds.ReadXml(Server.MapPath("~/XML/ProjectList.xml"));
DataView dvPrograms;
dvPrograms = ds.Tables[0].DefaultView;
dvPrograms.Sort = "Id";
foreach (DataRowView dr in dvPrograms)
{
ProjectModels model = new ProjectModels();
model.Id = Convert.ToInt32(dr[0]);
model.ProjectName = Convert.ToString(dr[1]);
model.Location = Convert.ToString(dr[2]);
lstProject.Add(model);
}
if (lstProject.Count > 0)
{
return(View(lstProject));
}
return(View());
}
public JsonResult Tags()
{
var db = new ProjectModels();
var list = db.R_ArticleTags.GroupBy(a => a.tagid, (a, v) => new { tagid = a, cc = v.Count() }).Join(db.Tags, a => a.tagid, b => b.id, (a, b) => new { id = a.tagid, tname = b.tname, cc = a.cc, sort = b.sort }).OrderBy(a => a.sort).ToList();
return(Json(list, JsonRequestBehavior.AllowGet));
}
// GET: ProjectTasks/Create
public ActionResult Create(int projectId)
{
ProjectModels Project = db.ProjectModels.Find(projectId);
ViewBag.ProjectModel = Project;
ViewBag.UserId = User.Identity.GetUserId();
return(View());
}
public ActionResult Item(int id)
{
var db = new ProjectModels();
var o = db.Article.First(a => a.id == id);
ViewBag.Title = o.title;
return(View(o));
}
public ActionResult DeleteConfirmed(int id)
{
ProjectModels projectModels = db.ProjectModels.Find(id);
db.ProjectModels.Remove(projectModels);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Denial(ProjectModels projectModels, int?id)
{
if (projectModels == null)
{
return(HttpNotFound());
}
return(View(db.ProjectModels.Find(id)));
}
public BaseController()
{
var db = new ProjectModels();
var list = db.R_ArticleTags.GroupBy(a => a.tagid, (a, v) => new { tagid = a, cc = v.Count() }).Join(db.Tags, a => a.tagid, b => b.id, (a, b) => new TagsUse {
id = a.tagid, tname = b.tname, cc = a.cc, sort = b.sort
}).OrderBy(a => a.sort).ToList();
ViewData["taglist"] = list;
}
public ActionResult Edit([Bind(Include = "Id,Description,FirstName,LastName,ApplicationUserId,OwnerUserID")] ProjectModels projectModels)
{
if (ModelState.IsValid)
{
db.Entry(projectModels).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
//ViewBag.OwnerUserID = new SelectList(db.ApplicationUsers, "Id", "Email", projectModels.OwnerUserID);
return(View(projectModels));
}
private string ConstructThanks(ProjectModels currentModel)
{
var user = new ApplicationDbContext().Users.Find(User.Identity.GetUserId());
var client = new ApplicationDbContext().Users.Where(x => x.UserName == currentModel.projectClientID).SingleOrDefault();
string body = client.ContactName + "\n" + client.CompanyName + "\n" + client.Street1 + "\n" + client.Street2 + "\n"
+ client.City + ", " + client.State + "\n" + client.Zip + "\n" + client.Phone + "\n\n" + currentModel.projectClientID
+ "\n\r\n\rThank you for choosing Lively Literature Editing and Writing Services. I have received payment for the Project: "
+ currentModel.projectName + " in the amount of $" + currentModel.projectOfferedPaymentAmount + ". Thank you for your timely payment."
+ " I appreciate your business and hope to serve you again in the future!\n\r\n\r" + user.ContactName + "\n\rLively Literature Editing and Writing Services";
return(body);
}
public ActionResult DetailsForAdmin(int id)
{
ProjectModels projectModels = db.ProjectModels.Find(id);
if (projectModels == null)
{
return(HttpNotFound());
}
//Project Member Authenticated, serving View
return(View("Details", projectModels));
}
private string ConstructAccept(ProjectModels currentModel)
{
var user = new ApplicationDbContext().Users.Find(User.Identity.GetUserId());
var client = new ApplicationDbContext().Users.Where(x => x.UserName == currentModel.projectClientID).SingleOrDefault();
string body = client.ContactName + "\n" + client.CompanyName + "\n" + client.Street1 + "\n" + client.Street2 + "\n"
+ client.City + ", " + client.State + "\n" + client.Zip + "\n" + client.Phone + "\n\n" + currentModel.projectClientID
+ "\n\r\n\rThank you for choosing Lively Literature Editing and Writing Services. I pleased to inform you that your requested project, "
+ currentModel.projectName + ", has been has been accepted. Work will begin on the project shortly, and you can expect the completion of the project by the requested due date." +
"If you have any qustions or concerns about this project going forward, please contact me directly at [email protected] and reference the project title in the subject line. Further editing of the project online may delay the completion of your project.\n\r" +
"I appreciate your business and hope to serve you again in the future!\n\r\n\r" + user.ContactName + "\n\rLively Literature Editing and Writing Services";
return(body);
}
private string ConstructInvoice(ProjectModels currentModel)
{
var user = new ApplicationDbContext().Users.Find(User.Identity.GetUserId());
var client = new ApplicationDbContext().Users.Where(x => x.UserName == currentModel.projectClientID).SingleOrDefault();
string body = client.ContactName + "\n" + client.CompanyName + "\n" + client.Street1 + "\n" + client.Street2 + "\n"
+ client.City + ", " + client.State + "\n" + client.Zip + "\n" + client.Phone + "\n\n" + currentModel.projectClientID
+ "\n\r\n\rThank you for choosing Lively Literature Editing and Writing Services. Your requested project, "
+ currentModel.projectName + ", has been completed. Please remit the agreed upon fee of $"
+ currentModel.projectOfferedPaymentAmount + " within 30 days of receiving this invoice to avoid any additional late payment fees"
+ " I appreciate your business and hope to serve you again in the future!\n\r\n\r" + user.ContactName + "\n\rLively Literature Editing and Writing Services";
return(body);
}
// GET: ProjectModels/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ProjectModels projectModels = db.ProjectModels.Find(id);
if (projectModels == null)
{
return(HttpNotFound());
}
return(View(projectModels));
}
public ActionResult Denial(ProjectModels projectModels)
{
var model = db.ProjectModels.Find(projectModels.ID);
model.projectDenial = projectModels.projectDenial;
if (ModelState.IsValid)
{
db.Entry(model).State = EntityState.Modified;
db.SaveChanges();
SendEmail(projectModels, "declined");
return(RedirectToAction("ProjectCalendar"));
}
return(View(projectModels));
}
private string ConstructDecline(ProjectModels currentModel)
{
currentModel = db.ProjectModels.Find(currentModel.ID);
var user = new ApplicationDbContext().Users.Find(User.Identity.GetUserId());
var client = new ApplicationDbContext().Users.Where(x => x.UserName == currentModel.projectClientID).SingleOrDefault();
string body = client.ContactName + "\n" + client.CompanyName + "\n" + client.Street1 + "\n" + client.Street2 + "\n"
+ client.City + ", " + client.State + "\n" + client.Zip + "\n" + client.Phone + "\n\n" + currentModel.projectClientID
+ "\n\r\n\rThank you for choosing Lively Literature Editing and Writing Services. I regret to inform you that your requested project, "
+ currentModel.projectName + ", has been has been declined. Please refer to the following as to the reasoning behind the declination.\n\r\n\r"
+ currentModel.projectDenial + "\n\r\n\rIf you would like to renegotiate the terms of the project based on these issues, please feel free to edit the project by using the CHANGE option in the project manager. The project will remain in the site for 14 days before being removed."
+ " I appreciate your business and hope to serve you again in the future!\n\r\n\r" + user.ContactName + "\n\rLively Literature Editing and Writing Services";
return(body);
}
public ActionResult Create(ProjectModels project)
{
try
{
// TODO: Add insert logic here
doc.Load(Server.MapPath(xmlDocLocation));
XmlNode node = doc.SelectSingleNode("Projects");
XmlNodeList nodeList = node.ChildNodes;
//get the last id
var x = doc.GetElementsByTagName("Id");
int Max = 0;
foreach (XmlElement item in x)
{
int EId = Convert.ToInt32(item.InnerText.ToString());
if (EId > Max)
{
Max = EId;
}
}
Max += 1; //increment the last id by 1
//now to new node
XmlNode newNode = node.AppendChild(
doc.CreateNode(XmlNodeType.Element, "project", "")
);
// TODO: Add last incremental Id logic
newNode.AppendChild(
doc.CreateNode(XmlNodeType.Element, "Id", "")
).InnerText = Max.ToString();
// add project name
newNode.AppendChild(
doc.CreateNode(XmlNodeType.Element, "ProjectName", "")
).InnerText = project.ProjName;
// add project location
newNode.AppendChild(
doc.CreateNode(XmlNodeType.Element, "Location", "")
).InnerText = project.Location;
// now save the changes
doc.Save(Server.MapPath(xmlDocLocation));
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public ActionResult Project(ProjectModels model)
{
if (ModelState.IsValid)
{
try
{
DateTime tgl = Convert.ToDateTime(model.StartDate);
ProjectBusiness.InsertProject(model.Nama, model.Kota, model.Alamat, tgl, model.NoKontrak, model.NoSpk, model.TelpSpk);
}
catch (Exception ex)
{
ModelState.AddModelError("", ex.Message);
}
}
public ActionResult Change([Bind(Include = "ID,projectName,projectClientID,projectCategoryID,projectDescription,projectRequestedDueDate,projectOfferedPaymentAmount,projectPaymentMethodID,projectStatusID")] ProjectModels projectModels)
{
if (ModelState.IsValid)
{
projectModels.projectStatusID = 1;
projectModels.projectClientID = User.Identity.Name;
db.Entry(projectModels).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.projectCategoryID = new SelectList(db.CategoryModels, "ID", "categoryName", projectModels.projectCategoryID);
ViewBag.projectStatusID = new SelectList(db.ProjectStatusModels, "ID", "projectStatusName", projectModels.projectStatusID);
ViewBag.projectPaymentMethodID = new SelectList(db.PaymentMethodModels, "ID", "projectPaymentMethod", projectModels.projectPaymentMethodID);
return(View(projectModels));
}
// GET: ProjectModels/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ProjectModels projectModels = db.ProjectModels.Find(id);
if (projectModels == null)
{
return(HttpNotFound());
}
//ViewBag.OwnerUserID = new SelectList(db.ApplicationUsers, "Id", "Email", projectModels.OwnerUserID);
return(View(projectModels));
}
private void SetActiveProject(ProjectServiceModel activeProjectServiceModel)
{
if (activeProjectServiceModel.IsActive)
{
return;
}
foreach (var projectServiceModel in ProjectModels.Except(new[] { activeProjectServiceModel }))
{
projectServiceModel.IsActive = false;
}
activeProjectServiceModel.IsActive = true;
teamPilgrimVsService.TeamFoundationHost.SetContext(TfsTeamProjectCollection, activeProjectServiceModel.Project.Uri.ToString());
}
public ActionResult Create([Bind(Include = "Id,Title,Description,ApplicationUserId,OwnerUserID")] ProjectModels projectModels)
{
var userId = User.Identity.GetUserId();
//ApplicationUser user = System.Web.HttpContext.Current.GetOwinContext().GetUserManager<ApplicationUserManager>().FindById(System.Web.HttpContext.Current.User.Identity.GetUserId());
projectModels.ApplicationUserId = userId;
projectModels.OwnerUserID = userId;
projectModels.OwnerUser = db.Users.Where(u => u.Id == userId).FirstOrDefault();
projectModels.ProjectMembers.Add(db.UserAccounts.Where(u => u.ApplicationUserId == userId).FirstOrDefault());
db.ProjectModels.Add(projectModels);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Change(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ProjectModels projectModels = db.ProjectModels.Find(id);
if (projectModels == null)
{
return(HttpNotFound());
}
ViewBag.projectCategoryID = new SelectList(db.CategoryModels, "ID", "categoryName", projectModels.projectCategoryID);
ViewBag.projectStatusID = new SelectList(db.ProjectStatusModels, "ID", "projectStatusName", projectModels.projectStatusID);
ViewBag.projectPaymentMethodID = new SelectList(db.PaymentMethodModels, "ID", "projectPaymentMethod", projectModels.projectPaymentMethodID);
return(View(projectModels));
}
public void AddNewProject()
{
//Arrange
ProjectController controller = new ProjectController();
var mockedDb = new MockedApplicationDbContext();
mockedDb.ProjectModels = new FakeDbSet <ProjectModels>();
var projectModel = new ProjectModels {
Id = 1, ApplicationUserId = "123abc",
Title = "New Project", Description = "New Project Description",
};
//Act
mockedDb.ProjectModels.Add(projectModel);
//Assert
mockedDb.ProjectModels.Contains(projectModel);
}
public ActionResult Blog(int id)
{
var db = new ProjectModels();
BlogViewModel o = new BlogViewModel();
if (id > 0)
{
o.article = db.Article.First(a => a.id == id);
o.tagid = db.R_ArticleTags.First(a => a.articleid == id).tagid;
}
else
{
o.article = new Article();
o.tagid = 0;
}
o.tags = db.Tags.OrderBy(a => a.sort).ToList();
return(View(o));
}
