public ActionResult Save(Customer customer)
{
if (!ModelState.IsValid)
{
var viewModel = new CustomerFormViewModel
{
Customer = customer,
MembershipTypes = db.MembershipTypes.ToList()
};
return(View("CustomerForm", viewModel));
}
if (customer.Id == 0)
{
db.Customers.Add(customer);
db.SaveChanges();
}
else
{
var customerInDb = db.Customers.Single(c => c.Id == customer.Id);
customerInDb.Name = customer.Name;
customerInDb.Birthday = customer.Birthday;
customerInDb.IsSubscribedToNewsletter = customer.IsSubscribedToNewsletter;
customerInDb.MembershipTypeId = customer.MembershipTypeId;
}
db.SaveChanges();
return(RedirectToAction("Index", "Customers"));
}
public IHttpActionResult CreateCustomer(CustomerDto customerdto)
{
if (!ModelState.IsValid)
return BadRequest();
var customer = Mapper.Map<CustomerDto, Customer>(customerdto);
db.Customers.Add(customer);
db.SaveChanges();
customerdto.Id = customer.Id;
return Created(new Uri(Request.RequestUri + "/" + customer.Id), customerdto);
}
public IHttpActionResult SettingsSave(dynamic data)
{
try
{
foreach (var file in data.files)
{
foreach (var item in data.list)
{
if (item.DictKey.ToString() == file.propertyName.ToString())
{
item.DictValue = UpFileClass.FileSave(file.filePath.ToString(), item.DictValue.ToString(), (int)file.fileType);
}
}
}
Dbctx.GgcmsDictionaries
.ToList()
.ForEach(x =>
{
foreach (var item in data.list)
{
if (x.Id == (int)item.Id)
{
x.DictValue = item.DictValue.ToString();
}
}
});
Dbctx.SaveChanges();
CacheHelper.RemoveAllCache(CacheTypeNames.SysConfigs.ToString());
return(Ok(data.list));
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
public IHttpActionResult ModifyPassword(dynamic passData)
{
string oldPassword = passData.oldPassword.ToString();
string newPassword = passData.newPassword.ToString();
string rePassword = passData.rePassword.ToString();
string sessionKey = SystemEnums.login_user.ToString();
if (Session[sessionKey] != null)
{
GgcmsMembers m = Session[sessionKey] as GgcmsMembers;
GgcmsMembers info = Dbctx.GgcmsMembers.Find(m.Id);
if (info.PassWord != oldPassword)
{
return(BadRequest("原密码不正确"));
}
else if (newPassword != rePassword)
{
return(BadRequest("新密码和确认密码不同"));
}
else
{
info.PassWord = newPassword;
var ent = Dbctx.Entry(info);
ent.Property("PassWord").IsModified = true;
Dbctx.SaveChanges();
Session.RemoveAll();
}
return(Ok(info));
}
return(BadRequest("请先登录"));
}
public IHttpActionResult CreateMovie(MovieDto movieDto)
{
if (!ModelState.IsValid)
{
return(BadRequest());
}
var movie = Mapper.Map <MovieDto, Movie>(movieDto);
db.Movies.Add(movie);
db.SaveChanges();
movieDto.Id = movie.Id;
return(Created(new Uri(Request.RequestUri + "/" + movie.Id), movieDto));
}
public ActionResult Save(Movie movie)
{
if (!ModelState.IsValid)
{
var viewModel = new MovieFormViewModel
{
Movie = movie,
Genres = db.Genres.ToList()
};
return(View("MovieForm", viewModel));
}
if (movie.Id == 0)
{
db.Movies.Add(movie);
}
else
{
var movieInDb = db.Movies.Single(c => c.Id == movie.Id);
movieInDb.Name = movie.Name;
movieInDb.GenreId = movie.GenreId;
}
db.SaveChanges();
return(RedirectToAction("Index", "Movies"));
}
// DELETE: api/GgcmsCategories/5
public IHttpActionResult Delete(int id)
{
GgcmsArticles info = Dbctx.GgcmsArticles.Find(id);
if (info == null)
{
return(BadRequest("信息不存在"));
}
//删除关联模型数据
var category = dbHelper.Categories(Math.Abs(info.Category_Id));
if (category != null)
{
if (category.ExtModelId > 0)
{
ExtendModule.Delete(info.Id, category.ExtModelId);
}
updateArticleNumber(info.Category_Id, -1);
}
Dbctx.GgcmsArticles.Remove(info);
//删除关联附件
Dbctx.GgcmsAttachments.RemoveRange(Dbctx.GgcmsAttachments.Where(x => x.Articles_Id == info.Id));
//删除关联分页
Dbctx.GgcmsArticlePages.RemoveRange(Dbctx.GgcmsArticlePages.Where(x => x.Article_Id == info.Id));
Dbctx.SaveChanges();
ClearCache();
CacheHelper.RemoveAllCache(CacheTypeNames.Categorys);
return(Ok(info));
}
public IHttpActionResult MultDelete(int[] ids)
{
var query = Dbctx.GgcmsArticles.Where(x => ids.Contains(x.Id));
foreach (GgcmsArticles item in query.ToList())
{
//删除关联附件
var attalist = Dbctx.GgcmsAttachments.Where(x => x.Articles_Id == item.Id);
Dbctx.GgcmsAttachments.RemoveRange(attalist);
//删除关联模型数据
var category = dbHelper.Categories(Math.Abs(item.Category_Id));
if (category != null)
{
if (category.ExtModelId > 0)
{
ExtendModule.Delete(item.Id, category.ExtModelId);
}
updateArticleNumber(item.Category_Id, -1);
}
//删除关联分页
Dbctx.GgcmsArticlePages.RemoveRange(Dbctx.GgcmsArticlePages.Where(x => x.Article_Id == item.Id));
}
Dbctx.GgcmsArticles.RemoveRange(query);
int c = Dbctx.SaveChanges();
ClearCache();
CacheHelper.RemoveAllCache(CacheTypeNames.Categorys);
return(Ok(c));
}
public IHttpActionResult CategorySortSave(dynamic[] list)
{
try {
Dbctx.GgcmsCategories
.ToList()
.ForEach(x => {
foreach (var item in list)
{
if (x.Id == (int)item.Id)
{
x.OrderId = (int)item.OrderId;
x.ParentId = (int)item.ParentId;
}
}
});
int c = Dbctx.SaveChanges();
ClearCache();
CacheHelper.RemoveAllCache(CacheTypeNames.Categorys);
return(Ok(c));
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
// PUT: api/GgcmsCategories/5
public IHttpActionResult Edit(GgcmsMembers info)
{
var oldinfo = Dbctx.GgcmsMembers.Find(info.Id);
if (oldinfo == null)
{
return(BadRequest("信息不存在"));
}
Dbctx.Entry(oldinfo).State = EntityState.Detached;
//Dbctx.GgcmsMembers.Attach(info);
//Dbctx.Entry(info).Property("goods_name").IsModified = true;
//密码为空时，使用旧密码
if (string.IsNullOrWhiteSpace(info.PassWord))
{
info.PassWord = oldinfo.PassWord;
}
var ent = Dbctx.Entry(info);
ent.State = EntityState.Modified;
Dbctx.SaveChanges();
ClearCache();
info.PassWord = "";
return(Ok(info));
}
// POST: api/GgcmsCategories
public IHttpActionResult Add(GgcmsStyles styleInfo)
{
string staticDir = ConfigurationManager.AppSettings["StaticDir"].ToString();
string styleDir = ConfigurationManager.AppSettings["StyleDir"].ToString();
string root = "/" + staticDir + "/" + styleDir + "/" + styleInfo.Folder;
string templateDir = ConfigurationManager.AppSettings["TemplateDir"].ToString();
templateDir = "/Views/" + templateDir + "/" + styleInfo.Folder;
string rootpath = HttpContext.Current.Server.MapPath("~" + root);
string templatePath = HttpContext.Current.Server.MapPath("~" + templateDir);
if (Directory.Exists(rootpath) || Directory.Exists(templatePath))
{
BadRequest("文件夹已经存在");
}
else
{
Directory.CreateDirectory(rootpath);
Directory.CreateDirectory(templatePath);
}
var result = Dbctx.GgcmsStyles.Add(styleInfo);
Dbctx.SaveChanges();
ClearCache();
return(Ok(result));
}
public IHttpActionResult MultDelete(int[] ids)
{
string staticDir = ConfigurationManager.AppSettings["StaticDir"].ToString();
string styleDir = ConfigurationManager.AppSettings["StyleDir"].ToString();
styleDir = "/" + staticDir + "/" + styleDir + "/";
string templateDir = ConfigurationManager.AppSettings["TemplateDir"].ToString();
templateDir = "/Views/" + templateDir + "/";
try
{
var query = Dbctx.GgcmsStyles.Where(x => ids.Contains(x.Id));
foreach (var item in query.ToList())
{
GgcmsStyles styleInfo = item as GgcmsStyles;
string stylePath = HttpContext.Current.Server.MapPath("~" + styleDir + styleInfo.Folder);
string templatePath = HttpContext.Current.Server.MapPath("~" + templateDir + styleInfo.Folder);
Directory.Delete(stylePath, true);
Directory.Delete(templatePath, true);
}
Dbctx.GgcmsStyles.RemoveRange(query);
int c = Dbctx.SaveChanges();
ClearCache();
return(Ok(c));
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
// POST: api/GgcmsCategories
public IHttpActionResult Add(GgcmsPowers info)
{
var result = Dbctx.GgcmsPowers.Add(info);
Dbctx.SaveChanges();
ClearCache();
return(Ok(result));
}
// POST: api/GgcmsCategories
public IHttpActionResult Add(GgcmsAdverts info)
{
UpFileClass.FileSave(info, info.files.FindAll(x => x.fileType != 3));
var result = Dbctx.GgcmsAdverts.Add(info);
Dbctx.SaveChanges();
ClearCache();
return(Ok(result));
}
// POST: api/GgcmsCategories
public IHttpActionResult Add(GgcmsArticles info)
{
//提交除附加模型外的文件-标题图，内容中的图
UpFileClass.FileSave(info, info.files.FindAll(x => x.fileType != 3));
info.CreateTime = DateTime.Now;
updateArticleNumber(info.Category_Id, 1);
CacheHelper.RemoveAllCache(CacheTypeNames.Categorys);
if (info.ModuleInfo != null && info.ModuleInfo.Id > 0)
{
info.ExtModelId = info.ModuleInfo.Id;
}
info.pagesCount = info.pages.Count + 1;
var result = Dbctx.GgcmsArticles.Add(info);
Dbctx.SaveChanges();
//附件
using (GgcmsDB db = new GgcmsDB())
{
foreach (GgcmsAttachments attach in info.attachments)
{
attach.Articles_Id = info.Id;
attach.CreateTime = DateTime.Now;
db.GgcmsAttachments.Add(attach);
}
db.SaveChanges();
}
//数据模型
if (info.ModuleInfo != null && info.ModuleInfo.Id > 0)
{
foreach (var file in info.files.FindAll(x => x.fileType == 3))
{
foreach (var item in info.ModuleInfo.Columns)
{
if (item.ColName == file.propertyName)
{
item.Value = UpFileClass.FileSave(file.filePath.ToString(), item.Value.ToString(), (int)file.fileType);
}
}
}
ExtendModule.SaveData(info.Id, info.ModuleInfo);
}
//分页保存
if (info.pages.Count > 0)
{
foreach (var page in info.pages)
{
UpFileClass.FileSave(page, page.files);
page.Article_Id = info.Id;
Dbctx.GgcmsArticlePages.Add(page);
}
Dbctx.SaveChanges();
}
ClearCache();
return(Ok(result));
}
// POST: api/GgcmsCategories
public IHttpActionResult Add(GgcmsFriendLinks info)
{
var result = Dbctx.GgcmsFriendLinks.Add(info);
UpFileClass.FileSave(info, info.files);
Dbctx.SaveChanges();
ClearCache();
CacheHelper.RemoveAllCache(CacheTypeNames.Keys);
return(Ok(result));
}
public IHttpActionResult MultDelete(int[] ids)
{
var query = Dbctx.GgcmsCategories.Where(x => ids.Contains(x.Id));
Dbctx.GgcmsCategories.RemoveRange(query);
int c = Dbctx.SaveChanges();
ClearCache();
return(Ok(c));
}
private void adminStyle()
{
Dbctx.GgcmsStyles.Add(new GgcmsStyles()
{
StyleName = "默认风格",
Folder = "default",
Descrip = "默认风格"
});
Dbctx.SaveChanges();
}
public IHttpActionResult MultDelete(int[] ids)
{
var query = Dbctx.GgcmsFriendLinks.Where(x => ids.Contains(x.Id));
Dbctx.GgcmsFriendLinks.RemoveRange(query);
int c = Dbctx.SaveChanges();
ClearCache();
CacheHelper.RemoveAllCache(CacheTypeNames.Keys);
return(Ok(c));
}
// POST: api/GgcmsCategories
public IHttpActionResult Add(GgcmsTasks info)
{
info.RunTime = DateTime.Now;
info.SetNextRuntime();
var result = Dbctx.GgcmsTasks.Add(info);
Dbctx.SaveChanges();
ClearCache();
CacheHelper.RemoveAllCache(CacheTypeNames.Tasks);
return(Ok(result));
}
public IHttpActionResult MultDelete(int[] ids)
{
var user = this.GetLoginUser();
var idlist = ids.Where(x => x != user.Id).ToArray();
var query = Dbctx.GgcmsMembers.Where(x => idlist.Contains(x.Id));
Dbctx.GgcmsMembers.RemoveRange(query);
int c = Dbctx.SaveChanges();
ClearCache();
return(Ok(c));
}
private void categoriesInit()
{
Dbctx.GgcmsCategories.AddRange(new List <GgcmsCategories>()
{
new GgcmsCategories()
{
CategoryName = "首页",
RedirectUrl = "/"
}
});
Dbctx.SaveChanges();
}
private void adminInit()
{
Dbctx.GgcmsMembers.AddRange(new List <GgcmsMembers>()
{
new GgcmsMembers()
{
UserName = "******",
PassWord = Tools.getMd5Hash("123456"),
JoinTime = DateTime.Now,
}
});
Dbctx.SaveChanges();
}
public IHttpActionResult Delete(int id)
{
ExtendModule.TableDelete(id);
GgcmsModules module = Dbctx.GgcmsModules.Where(x => x.Id == id).FirstOrDefault();
if (module != null)
{
Dbctx.GgcmsModules.Remove(module);
Dbctx.SaveChanges();
}
ClearCache();
return(Ok(id));
}
// DELETE: api/GgcmsCategories/5
public IHttpActionResult Delete(int id)
{
GgcmsDictionaries oldinfo = Dbctx.GgcmsDictionaries.Find(id);
if (oldinfo == null)
{
return(BadRequest("信息不存在"));
}
Dbctx.GgcmsDictionaries.Remove(oldinfo);
Dbctx.SaveChanges();
ClearCache();
return(Ok(oldinfo));
}
// PUT: api/GgcmsCategories/5
public IHttpActionResult Edit(GgcmsPowers info)
{
if (Dbctx.GgcmsPowers.Where(x => x.Id == info.Id).Count() == 0)
{
return(BadRequest("信息不存在"));
}
//Dbctx.GgcmsPowers.Attach(info);
//Dbctx.Entry(info).Property("goods_name").IsModified = true;
var ent = Dbctx.Entry(info);
ent.State = EntityState.Modified;
Dbctx.SaveChanges();
ClearCache();
return(Ok(info));
}
public IHttpActionResult addview(int id)
{
var info = Dbctx.GgcmsArticles.Find(id);
if (info != null)
{
info.Hits++;
Dbctx.SaveChanges();
return(Ok(info.Hits));
}
else
{
return(NotFound());
}
}
public IHttpActionResult RunNow(int id)
{
var task = Dbctx.GgcmsTasks.Find(id);
if (task == null)
{
return(BadRequest("任务不存在"));
}
task.RunTime = DateTime.Now;
task.TaskState = TaskStatus.Ready;
int c = Dbctx.SaveChanges();
ClearCache();
CacheHelper.RemoveAllCache(CacheTypeNames.Tasks);
return(Ok(c));
}
// POST: api/GgcmsCategories
public IHttpActionResult Add(GgcmsModules module)
{
if (!ExtendModule.ColumnsCheck(module))
{
return(BadRequest("字段关键字重复"));
}
var result = Dbctx.GgcmsModules.Add(module);
Dbctx.SaveChanges();
result.TableName = "moduleTab_" + result.Id.ToString();
result.ViewName = "moduleView_" + result.Id.ToString();
ExtendModule.TableCreate(module);
Dbctx.SaveChanges();
ClearCache();
return(Ok(result));
}
// PUT: api/GgcmsCategories/5
public IHttpActionResult Edit(GgcmsFriendLinks info)
{
if (Dbctx.GgcmsFriendLinks.Where(x => x.Id == info.Id).Count() == 0)
{
return(BadRequest("信息不存在"));
}
UpFileClass.FileSave(info, info.files);
//Dbctx.GgcmsFriendLinks.Attach(info);
//Dbctx.Entry(info).Property("goods_name").IsModified = true;
var ent = Dbctx.Entry(info);
ent.State = EntityState.Modified;
Dbctx.SaveChanges();
ClearCache();
CacheHelper.RemoveAllCache(CacheTypeNames.Keys);
return(Ok(info));
}
