public ActionResult CreateOrEditTag(TagModel model)
{
var Tag = new Tag();
if (!ModelState.IsValid)
return View(model);
if (model.ID == 0)
{
if (TagService.GetTags().Any(t => t.Title == model.Title))
ModelState.AddModelError("Title", "ასეთი კატეგორია უკვე არსებობს");
if (!ModelState.IsValid)
return View(model);
Tag.Title = model.Title;
Tag.AddedDate = DateTime.UtcNow;
TagService.Insert(Tag);
if (Tag.ID > 0)
{
return RedirectToAction("index");
}
}
else
{
Tag TagEntity = TagService.GetTag(model.ID);
TagEntity.Title = model.Title;
TagService.UpdateTag(TagEntity);
if (TagEntity.ID > 0)
{
return RedirectToAction("index");
}
}
return View(model);
}
private IEnumerable<Tag> ReconsileTags(IEnumerable<TagCheckbox> list)
{
foreach (var tag in list.Where(t => t.IsChecked))
{
if (tag.Id != null)
{
yield return tagService.GetTag((long)tag.Id);
continue;
}
var existingTag = tagService.GetTags().FirstOrDefault(t => t.Title == tag.Name);
if (existingTag!=null)
{
yield return existingTag;
continue;
}
var newTag = new Tag
{
Title = tag.Name
};
tagService.Insert(newTag);
yield return newTag;
}
}
public ActionResult SearchResults(Tag tag)
{
ViewBag.Ups = "";
if (string.IsNullOrWhiteSpace(tag.Title))
{
ViewBag.Ups = "შიგ ხომ სე?";
return PartialView("_searchRes", null);
}
List<Tag> tags = tagService.GetTags().Where(t => t.Title.StartsWith(tag.Title)).ToList();
if (tags.Capacity != 0)
{
ViewBag.Ups = "nice";
return PartialView("_searchRes",tags);
}
ViewBag.Ups = "არ მოიძებნა";
return PartialView("_searchRes",tags);
}
public ActionResult JsonAdd(Tag tag)
{
if(string.IsNullOrWhiteSpace(tag.Title))
{
return PartialView("_tag");
}
tag.AddedDate = DateTime.UtcNow;
var someTag = tagService.GetTags().Where(t => t.Title == tag.Title);
if (someTag.Count() !=0)
{
ViewBag.Success = "false";
return PartialView("_tag");
}
ViewBag.Success = "true";
tagService.Insert(tag);
return PartialView("_tag");
}
internal static List<Tag> GetPagedTags(PagingContext pager)
{
List<Tag> list = new List<Tag>(pager.RecordsPerPage);
SafeProcedure.ExecuteAndMapRecords(Database.GetDatabase(D4DDefine.DBInstanceName),
"dbo.GetPagedTags",
delegate(IParameterSet parameters)
{
parameters.AddWithValue("@PageIndex", pager.CurrentPageNumber);
parameters.AddWithValue("@PageSize", pager.RecordsPerPage);
parameters.AddWithValue("@NumberOfCount", 0, ParameterDirectionWrap.Output);
},
delegate(IRecord record)
{
Tag tag = new Tag();
tag.TagId = record.GetInt32OrDefault(0, 0);
tag.TagName = record.GetStringOrEmpty(1);
tag.Hits = record.GetInt32OrDefault(2, 0);
tag.AddUserID = record.GetInt32OrDefault(3, 0);
tag.AddDate = record.GetDateTime(4);
list.Add(tag);
},
delegate(IParameterSet outputParameters)
{
pager.TotalRecordCount = outputParameters.GetValue("@NumberOfCount") == DBNull.Value ? 0 : (int)outputParameters.GetValue("@NumberOfCount");
}
);
return list;
}
/// <summary>
/// tagid<0 表示新增
/// >0 则为更新
/// </summary>
/// <param name="tag"></param>
/// <returns></returns>
internal static int SetTag(Tag tag)
{
if (tag == null) return -1;
SafeProcedure.ExecuteNonQuery(
Database.GetDatabase(D4DDefine.DBInstanceName),
"dbo.Tags_AddTag",
delegate(IParameterSet parameters)
{
parameters.AddWithValue("@TagID", tag.TagId);
parameters.AddWithValue("@Name", tag.TagName);
parameters.AddWithValue("@AddUserID", tag.AddUserID);
parameters.AddWithValue("@RetVal", DBNull.Value, ParameterDirectionWrap.ReturnValue);
},
delegate(IParameterSet outputParameters)
{
tag.TagId = Convert.ToInt32(outputParameters.GetValue("@RetVal"));
});
return tag.TagId;
}
/// <summary>
/// 获取tag的top列表
/// </summary>
/// <param name="maxCount"></param>
/// <returns></returns>
internal static List<Tag> GetTopTags(int maxCount)
{
List<Tag> list = new List<Tag>(maxCount);
SafeProcedure.ExecuteAndMapRecords(
Database.GetDatabase(D4DDefine.DBInstanceName),
"dbo.Tags_GetTopTag",
delegate(IRecord record)
{
Tag tag = new Tag();
tag.TagId = record.GetInt32OrDefault(0, 0);
tag.TagName = record.GetStringOrEmpty(1);
tag.Hits = record.GetInt32OrDefault(2, 0);
tag.AddUserID = record.GetInt32OrDefault(3, 0);
tag.AddDate = record.GetDateTime(4);
list.Add(tag);
},
maxCount);
return list;
}
internal static Dictionary<int, Tag> GetTags20(List<int> tagIds)
{
Dictionary<int, Tag> dic = new Dictionary<int, Tag>();
if (tagIds != null && tagIds.Count > 0)
{
SafeProcedure.ExecuteAndMapRecords(Database.GetDatabase(D4DDefine.DBInstanceName),
"dbo.Tags_GetTags20",
delegate(IParameterSet parameters)
{
int maxCount = tagIds.Count > 20 ? 20 : tagIds.Count;
for (int i = 0; i < maxCount; i++)
{
parameters.AddWithValue("@tid" + (i + 1).ToString(), tagIds[i]);
}
},
delegate(IRecord record)
{
Tag tag = new Tag();
tag.TagId = record.GetInt32OrDefault(0, 0);
tag.TagName = record.GetStringOrEmpty(1);
tag.Hits = record.GetInt32OrDefault(2, 0);
tag.AddUserID = record.GetInt32OrDefault(3, 0);
tag.AddDate = record.GetDateTime(4);
if (!dic.ContainsKey(tag.TagId))
dic.Add(tag.TagId, tag);
}
);
}
return dic;
}
/// <summary>
/// 获取OneTag
/// </summary>
/// <param name="tagId"></param>
/// <returns></returns>
internal static Tag GetTag(int tagId)
{
Tag tag = new Tag(tagId);
if (tagId > 0)
{
SafeProcedure.ExecuteAndMapRecords(
Database.GetDatabase(D4DDefine.DBInstanceName),
"dbo.Tags_GetTag",
delegate(IRecord record)
{
tag.TagName = record.GetStringOrEmpty(1);
tag.Hits = record.GetInt32OrDefault(2,0);
tag.AddUserID = record.GetInt32OrDefault(3,0);
tag.AddDate = record.GetDateTime(4);
},
tagId);
}
return tag;
}
