/// helper apps
private string GetUniqueRefCode(string refDescription, WebSiteContext db)
{
if (refDescription.Length < 3)
{
refDescription = refDescription.PadRight(3, 'A');
}
var refCode = refDescription.Substring(0, 3).ToUpper();
Ref exists = new Ref();
while (exists != null)
{
exists = db.Refs.Where(r => r.RefCode == refCode).FirstOrDefault();
if (exists != null)
{
char nextLastChar = refCode.Last();
if (nextLastChar == ' ')
{
nextLastChar = 'A';
}
if (nextLastChar == 'Z')
{
nextLastChar = 'A';
}
else
{
nextLastChar = (char)(((int)nextLastChar) + 1);
}
refCode = refCode.Substring(0, 2) + nextLastChar;
}
}
return(refCode);
}
public string Post(RefItem refItem)
{
string success = "";
try
{
using (WebSiteContext db = new WebSiteContext())
{
Ref @ref = new Ref();
@ref.RefType = refItem.RefType;
@ref.RefCode = GetUniqueRefCode(refItem.RefDescription, db);
@ref.RefDescription = refItem.RefDescription;
db.Refs.Add(@ref);
db.SaveChanges();
//refModel.RefCode = @ref.RefCode;
success = "ok";
}
}
catch (Exception ex)
{
success = ex.Message;
}
return(success);
}
public string Put(Comment updateComment)
{
string success = "";
try
{
using (WebSiteContext db = new WebSiteContext())
{
Comment comment = db.Comments.Where(c => c.CommentId == updateComment.CommentId).FirstOrDefault();
if (comment != null)
{
comment.CommentText = updateComment.CommentText;
comment.CommentTitle = updateComment.CommentTitle;
db.SaveChanges();
success = "ok";
}
else
{
success = "comment not found";
}
}
}
catch (Exception ex)
{
success = Helpers.ErrorDetails(ex);
}
return(success);
}
public RefModel GetRefsForRefType(string refType)
{
var refModel = new RefModel();
try
{
using (WebSiteContext db = new WebSiteContext())
{
IList <Ref> dbrefs = db.Refs.Where(r => r.RefType == refType).OrderBy(r => r.RefDescription).ToList();
foreach (Ref r in dbrefs)
{
refModel.RefItems.Add(new RefModelItem()
{
RefCode = r.RefCode,
RefDescription = r.RefDescription
});
}
refModel.Success = "ok";
}
}
catch (Exception ex)
{
refModel.Success = Helpers.ErrorDetails(ex);
}
return(refModel);
}
public string UpdateArticle(VwArticle articleModel)
{
var success = "";
try
{
using (WebSiteContext db = new WebSiteContext())
{
Article updateArticle = db.Articles.Where(a => a.Id.ToString() == articleModel.Id).FirstOrDefault();
updateArticle.Title = articleModel.Title;
updateArticle.CategoryRef = articleModel.CategoryRef;
updateArticle.SubCategoryRef = articleModel.SubCategoryRef;
updateArticle.ImageName = articleModel.ImageName;
updateArticle.LastUpdated = articleModel.LastUpdated; //DateTime.Now;
updateArticle.ByLineRef = articleModel.ByLineRef;
updateArticle.Content = articleModel.Content;
updateArticle.Summary = articleModel.Summary;
//db.ArticleTags.RemoveRange(db.ArticleTags.Where(t => t.articleId.ToString() == editArticle.Id));
////article.ArticleTags = null;
//foreach (DbArticleTagModel tagModel in editArticle.Tags)
//{
// article.ArticleTags.Add(new ArticleTag() { articleId = article.Id, Id = tagModel.Id, TagName = tagModel.TagName });
//}
db.SaveChanges();
success = "ok";
}
}
catch (Exception ex) { success = Helpers.ErrorDetails(ex); }
return(success);
}
public CommentsModel Post(CommentsModel newComment)
{
try
{
using (WebSiteContext db = new WebSiteContext())
{
var comment = new Comment();
comment.CreateDate = DateTime.Now;
comment.ArticleId = newComment.ArticleId;
comment.CommentText = newComment.CommentText;
comment.CommentTitle = newComment.CommentTitle;
comment.UserId = newComment.UserId;
comment.UserName = newComment.UserName;
db.Comments.Add(comment);
db.SaveChanges();
newComment.CommentId = comment.CommentId;
newComment.CreateDate = comment.CreateDate.ToShortDateString();
newComment.success = "ok";
//newComment.success = new GodaddyEmailController().SendEmail("Somebody Actually Made A comment", comment.UserName + " said: " + comment.CommentText);
}
}
catch (Exception ex)
{
newComment.success = Helpers.ErrorDetails(ex);
}
return(newComment);
}
//[Route("api/Home/EmailTest")]
public string EmailTest()
{
string success;
using (var db = new WebSiteContext())
{
//success= godaddyEmailController.SendEmail("this is a test", "message 8");
success = "ok";
}
return(success);
}
public SuccessModel AddImage(ImageData data)
{
var successModel = new SuccessModel();
try
{
// data:image/jpeg;base64,
string imageFullFileName = Path.Combine(imagesPath, data.FileName);
string trimData = data.Data.ToString().Substring(23);
byte[] byteArray = Convert.FromBase64String(trimData);
//Byte[] byteArray = data.Data.ReadAsByteArrayAsync().Result;
File.WriteAllBytes(imageFullFileName, byteArray);
// USE WEBREQUEST TO UPLOAD THE FILE
FtpWebRequest webRequest = null;
string destPath = ftpHost + articleImagesFolder;
if (!FtpUtilies.DirectoryExists(destPath))
{
FtpUtilies.CreateDirectory(destPath);
}
webRequest = (FtpWebRequest)WebRequest.Create(destPath + "/" + data.FileName);
webRequest.Credentials = networkCredentials;
webRequest.Method = WebRequestMethods.Ftp.UploadFile;
using (Stream requestStream = webRequest.GetRequestStream())
{
byte[] fileContents = System.IO.File.ReadAllBytes(imageFullFileName);
webRequest.ContentLength = fileContents.Length;
requestStream.Write(fileContents, 0, fileContents.Length);
requestStream.Flush();
requestStream.Close();
}
using (WebSiteContext db = new WebSiteContext())
{
Article article = db.Articles.Where(a => a.Id == data.ArticleId).FirstOrDefault();
article.ImageName = data.FileName;
db.SaveChanges();
successModel.ReturnValue = data.FileName;
}
successModel.Success = "ok";
}
catch (Exception ex)
{
successModel.Success = Helpers.ErrorDetails(ex);
}
return(successModel);
}
public string Put(RefItem refItem)
{
string success = "";
try
{
using (WebSiteContext db = new WebSiteContext())
{
Ref @ref = db.Refs.Where(r => r.RefCode == refItem.RefCode).First();
@ref.RefDescription = refItem.RefDescription;
db.SaveChanges();
success = "ok";
}
}
catch (Exception ex) { success = ex.Message; }
return(success);
}
// GET: api/Comments
public IList <CommentsModel> Get(string articleId)
{
var results = new List <CommentsModel>();
try
{
using (WebSiteContext db = new WebSiteContext())
{
List <Comment> comments = db.Comments.Where(c => c.ArticleId == articleId).ToList();
foreach (Comment c in comments)
{
results.Add(new CommentsModel()
{
UserName = c.UserName,
UserId = c.UserId,
CommentId = c.CommentId,
CommentTitle = c.CommentTitle,
CommentText = c.CommentText,
CreateDate = c.CreateDate.ToShortDateString()
});
}
//results = (from comments in db.Comments
// join users in dbn.AspNetUsers on comments.UserId.ToString() equals users.Id
// where comments.ArticleId.ToString() == articleId.ToString().ToUpper()
// orderby comments.CreateDate ascending
// select new CommentsModel
// {
// UserName = users.UserName,
// UserId = users.Id,
// CreateDate = comments.CreateDate,
// CommentTitle = comments.CommentTitle,
// CommentText = comments.CommentText
// }).ToList().AsQueryable();
}
}
catch (Exception ex)
{
results.Add(new CommentsModel()
{
CommentText = Helpers.ErrorDetails(ex)
});
//results = results.Concat(new[] { new CommentsModel() { success = Helpers.ErrorDetails(ex) } });
}
return(results); //Json(results, JsonRequestBehavior.AllowGet);
}
public string Post(DbArticleTagModel tag)
{
var success = "";
try
{
var dbTag = new ArticleTag();
dbTag.TagName = tag.TagName;
dbTag.articleId = tag.ArticleId;
using (WebSiteContext db = new WebSiteContext())
{
db.ArticleTags.Add(dbTag);
db.SaveChanges();
success = "ok";
}
}
catch (Exception ex) { success = Helpers.ErrorDetails(ex); }
return(success);
}
public ArticleModel GetSingleArticle(string articleId)
{
var articleModel = new ArticleModel();
try
{
using (WebSiteContext db = new WebSiteContext())
{
VwArticle dbVwArticle = db.VwArticles.Where(a => a.Id.ToString() == articleId).FirstOrDefault();
if (dbVwArticle != null)
{
articleModel.Article = dbVwArticle;
articleModel.Success = "ok";
}
}
}
catch (Exception ex) { articleModel.Success = Helpers.ErrorDetails(ex); }
return(articleModel);
}
public ArticlesModel GetArticleList(int start, int take, string filterType, string filter)
{
var articleModel = new ArticlesModel();
try
{
using (WebSiteContext db = new WebSiteContext())
{
switch (filterType)
{
case "Category":
articleModel.ArticleList = db.VwArticles.Where(a => a.CategoryRef == filter).
OrderByDescending(a => a.LastUpdated).Skip(start).Take(take).ToList();
break;
case "Byline":
articleModel.ArticleList = db.VwArticles.Where(a => a.ByLine == filter).
OrderByDescending(a => a.LastUpdated).Skip(start).Take(take).ToList();
break;
case "Latest":
articleModel.ArticleList = db.VwArticles.Where(a => a.CategoryRef != "COM")
.OrderByDescending(a => a.LastUpdated).Skip(start).Take(take).ToList();
break;
case "Summary":
articleModel.ArticleList = db.VwArticles.OrderByDescending(a => a.LastUpdated).ToList();
break;
default:
articleModel.Success = "filterType: " + filterType;
break;
}
articleModel.Success = "ok";
}
}
catch (Exception ex)
{
articleModel.Success = Helpers.ErrorDetails(ex);
}
return(articleModel);
}
public CarouselModel LoadCarousel(string filterContext)
{
var carouselModel = new CarouselModel();
try
{
using (WebSiteContext db = new WebSiteContext())
{
var items = new List <VwArticle>();
if (filterContext == "General")
{
items = db.VwArticles.Where(a => a.CategoryRef != "COM").OrderByDescending(a => a.LastUpdated).ToList();
}
else
{
items = db.VwArticles.OrderByDescending(a => a.Created).ToList();
}
foreach (VwArticle vwArticle in items)
{
carouselModel.CarouselItems.Add(new CarouselItem()
{
Id = vwArticle.Id,
Title = vwArticle.Title,
Category = vwArticle.Category,
CategoryRef = vwArticle.CategoryRef,
ImageName = articleImagesFolder + vwArticle.ImageName,
});
}
carouselModel.Success = "ok";
}
}
catch (Exception ex)
{
carouselModel.Success = Helpers.ErrorDetails(ex);
}
return(carouselModel);
}
public string VerifyConnection()
{
string success = "ono";
var timer = new System.Diagnostics.Stopwatch();
timer.Start();
try
{
using (WebSiteContext db = new WebSiteContext())
{
var dbTest = db.Refs.FirstOrDefault();
success = "ok";
}
timer.Stop();
//successModel.ReturnValue = timer.Elapsed.ToString();
//System.Diagnostics.Debug.WriteLine("VerifyConnection took: " + timer.Elapsed);
}
catch (Exception ex)
{
success = Helpers.ErrorDetails(ex);
}
return(success);
}
public string AddNewArticle(VwArticle articleModel)
{
string success;
try
{
Article newArticle = new Article
{
//Id = Guid.NewGuid().ToString(),
Id = articleModel.Id,
Title = articleModel.Title,
CategoryRef = articleModel.CategoryRef,
SubCategoryRef = articleModel.SubCategoryRef,
ImageName = articleModel.ImageName,
Created = DateTime.Now,
LastUpdated = DateTime.Now,
Content = articleModel.Content,
Summary = articleModel.Summary,
ByLineRef = articleModel.ByLineRef
};
//foreach (DbArticleTagModel tag in articleModel.Tags)
// if (tag.TagName != null)
// newArticle.ArticleTags.Add(new ArticleTag() { TagName = tag.TagName, TagCategoryRef = tag.TagCategoryRef });
using (WebSiteContext db = new WebSiteContext())
{
db.Articles.Add(newArticle);
db.SaveChanges();
success = "ok";
}
}
catch (Exception ex)
{
success = Helpers.ErrorDetails(ex);
}
return(success);
}
