public ActionResult SaveData(BannerModel sp)
{
int result = 0;
bool kq = false;
if (ModelState.IsValid)
{
var dao = new BannerDAO();
var user = ((UserLogin)Session[CommonStants.USER_SESSION]);
sp.TENTK = user.userID;
result = dao.SaveData(sp, user.userName);
if (result == 1)
{
SetAlert("Cập Nhật Thành Công!", "success");
kq = true;
}
else if (result == 2)
{
SetAlert("Thêm Thành Công!", "success");
kq = true;
}
else
{
SetAlert("Thất Công!", "warning");
}
}
return(Json(kq, JsonRequestBehavior.AllowGet));
}
public BannerModel ReadData(int id)
{
BannerModel bannerModel = new BannerModel();
DataTable dtblBanner = new DataTable();
using (SqlConnection sqlConn = new SqlConnection(Sql.ConnectionString))
{
SqlCommand cmd = new SqlCommand("spBanner", sqlConn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@StatementType", "Select");
cmd.Parameters.AddWithValue("@prodID", id);
sqlConn.Open();
SqlDataReader sqlread = cmd.ExecuteReader();
dtblBanner.Load(sqlread);
sqlConn.Close();
}
if (dtblBanner.Rows.Count == 1)
{
bannerModel.ProductID = Convert.ToInt32(dtblBanner.Rows[0][0].ToString());
bannerModel.ProductType = dtblBanner.Rows[0][1].ToString();
bannerModel.ProductTitle = dtblBanner.Rows[0][2].ToString();
bannerModel.ProductDescription = dtblBanner.Rows[0][3].ToString();
bannerModel.ProductImage = dtblBanner.Rows[0][4].ToString();
}
return(bannerModel);
}
// GET: Banner/Details/5
public async Task <ActionResult> Details(int id)
{
BannerModel banner = new BannerModel();
using (var client = new HttpClient())
{
//Passing service base url
client.BaseAddress = new Uri("http://localhost:55462");
client.DefaultRequestHeaders.Clear();
//Define request data format
client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
//Sending request to find web api REST service resource GetAllEmployees using HttpClient
HttpResponseMessage Res = await client.GetAsync("api/bannerflow/" + id);
//Checking the response is successful or not which is sent using HttpClient
if (Res.IsSuccessStatusCode)
{
//Storing the response details recieved from web api
var bannerResponse = Res.Content.ReadAsStringAsync().Result;
//Deserializing the response recieved from web api and storing into the Employee list
banner = JsonConvert.DeserializeObject <BannerModel>(bannerResponse);
}
//returning the employee list to view
return(View(banner));
}
}
private Banner GetBannerFromModel(BannerModel model)
{
if (model == null)
{
throw new ArgumentNullException(nameof(model));
}
if (_bannerRepository.Set().Any(a => a.Id == model.BannerId))
{
throw new ArgumentException($"banner with id {model.BannerId} is already exist", nameof(model));
}
var category = _categoryRepository.Set().FirstOrDefault(c => c.Id == model.CategoryId);
var image = _imageRepository.Set().FirstOrDefault(i => i.Id == model.ImageId);
if (image == null && model.ImageUri != default)
{
image = new Image
{
Uri = model.ImageUri
};
}
return(new Banner
{
Image = image,
Category = category,
IsPublished = (bool)model.IsPublished,
LastUpdateDate = DateTime.Now,
IsClosed = (bool)model.IsClosed
});
}
public ActionResult New(BannerModel model)
{
if (ModelState.IsValid)
{
// file
if (Request.Files != null &&
Request.Files.Count > 0 &&
Request.Files[0].ContentLength > 0)
{
var picture = FileHelper.SaveBannerImage(Request.Files[0]);
model.Picture = picture;
}
var banner = new Banner();
banner.BackgroundColor = model.BackgroundColor;
banner.Desctiption = model.Desctiption;
banner.Picture = model.Picture;
banner.SortIndex = model.SortIndex;
banner.Status = model.Status;
banner.Title = model.Title;
jlService.AddBanner(banner);
ViewData.Add("ResultObject", ResultObject.Succeed());
}
return(View());
}
public ActionResult Edit(BannerModel model, int id)
{
if (ModelState.IsValid)
{
string picture = null;
// file
if (Request.Files != null &&
Request.Files.Count > 0)
{
picture = FileHelper.SaveBannerImage(Request.Files[0]);
model.Picture = picture;
}
var banner = jlService.GetBanner(id);
banner.BackgroundColor = model.BackgroundColor;
banner.Desctiption = model.Desctiption;
banner.Picture = model.Picture;
banner.SortIndex = model.SortIndex;
banner.Status = model.Status;
banner.Title = model.Title;
jlService.UpdateBanner(banner);
ViewData.Add("ResultObject", ResultObject.Succeed());
}
return(View(model));
}
public BannerModel Get(int id)
{
var entity =_BannerService.GetBannerById(id);
var model = new BannerModel
{
Id = entity.Id,
Title = entity.Title,
ImgUrl = entity.ImgUrl,
Order = entity.Order,
Adduser = entity.Adduser,
Addtime = entity.Addtime,
Upduser = entity.Upduser,
Updtime = entity.Updtime,
// Content = entity.Content,
};
return model;
}
public ActionResult BannerInfo(string widgetZone, int?categoryId)
{
var model = new BannerModel();
var bannerWidgetzone = _bannerService.GetBannerWidgetzoneByZone(widgetZone);
if (bannerWidgetzone == null)
{
return(View("~/Plugins/Widgets.IkBanner/Views/WidgetsBanner/BannerInfo.cshtml", model));
}
model.IsStatic = bannerWidgetzone.IsStatic;
var banners = _bannerService.GetAllByWidgetzone(bannerWidgetzone.Id, categoryId.HasValue ? categoryId.Value : 0);
foreach (var banner in banners)
{
if (banner.StoreId == 0 || banner.StoreId == _storeContext.CurrentStore.Id)
{
var bim = new BannerInfoModel();
bim.Id = banner.Id;
bim.BannerHtml = banner.BannerHtml;
bim.StoreId = banner.StoreId;
bim.CategoryId = banner.CategoryId;
bim.WidgetzoneId = banner.WidgetzoneId;
model.AvailableBanners.Add(bim);
}
}
return(View("~/Plugins/Widgets.IkBanner/Views/WidgetsBanner/BannerInfo.cshtml", model));
}
public ActionResult AddBanner()
{
var model = new BannerModel();
ViewBag.Message = "";
return(View(model));
}
public ActionResult Edit(BannerModel model, int id = -1)
{
BannerInfo bannerInfo = AdminBanners.AdminGetBannerById(id);
if (bannerInfo == null)
{
return(PromptView("Banner不存在"));
}
if (ModelState.IsValid)
{
//bannerInfo.Type = model.BannerType;
bannerInfo.StartTime = model.StartTime;
bannerInfo.EndTime = model.EndTime;
bannerInfo.IsShow = model.IsShow;
bannerInfo.Title = model.BannerTitle == null ? "" : model.BannerTitle;
bannerInfo.Img = model.Img;
bannerInfo.Url = model.Url;
bannerInfo.DisplayOrder = model.DisplayOrder;
AdminBanners.UpdateBanner(bannerInfo);
AddMallAdminLog("修改banner", "修改banner,bannerID为:" + id);
return(PromptView("banner修改成功"));
}
Load();
return(View(model));
}
public virtual ActionResult Create(BannerModel model, bool continueEditing)
{
if (!_permissionService.Authorize(StandardPermissionProvider.ManageBanner))
{
return(AccessDeniedView());
}
if (ModelState.IsValid)
{
var banner = model.ToEntity();
banner.CreateTime = DateTime.UtcNow;
banner.BannerImg = "";
banner.Pictures.Add(new BannerPicture {
PictureId = model.PictureModel.PictureId
});
_bannerService.InsertBanner(banner);
if (continueEditing)
{
//selected tab
SaveSelectedTabName();
return(RedirectToAction("Edit", new { id = banner.Id }));
}
}
model.AvailableBannerStatuses = BannerStatus.Display.ToSelectList(true).ToList();
model.AvailableBannerTypes = BannerType.Index.ToSelectList(true).ToList();
return(View(model));
}
public ActionResult GetListBannerServices()
{
IRepositryBase <Fly_Banner> repository = new BannerDAO();
BannerModel vm = new BannerModel();
var rs = new object();
try
{
vm.listBanner = repository.getAllItems().Where(x => x.Published == true && x.Fly_BannerType.BannerTypeTitle.Equals("Banner Service")).ToList();
rs = vm.listBanner.Select(x => new
{
id = x.BannerID,
title = x.BannerTitle,
link = x.BannerLink,
shortcontent = x.BannerShortContent,
imglink = x.Fly_Picture.OriginalURL,
type = x.Fly_BannerType.BannerTypeTitle
});
}
catch (Exception ex)
{
return(Json(new { result = ex.Message, Message = ex.Message }));
}
return(Json(new { result = rs }, JsonRequestBehavior.AllowGet));
}
public bool Post(BannerModel model)
{
var entity = new BannerEntity
{
Title = model.Title,
ImgUrl = model.ImgUrl,
Order = model.Order,
Adduser = model.Adduser,
Addtime = model.Addtime,
Upduser = model.Upduser,
Updtime = model.Updtime,
// Content = model.Content,
};
if (_BannerService.Create(entity).Id > 0)
{
return(true);
}
return(false);
}
public IActionResult Edit(BannerModel model, bool continueEditing)
{
if (!_permissionService.Authorize(StandardPermissionProvider.ManageBanners))
{
return(AccessDeniedView());
}
var banner = _bannerService.GetBannerById(model.Id);
if (banner == null)
{
return(RedirectToAction("List"));
}
if (ModelState.IsValid)
{
banner = model.ToEntity(banner);
banner.Locales = UpdateLocales(banner, model);
_bannerService.UpdateBanner(banner);
SuccessNotification(_localizationService.GetResource("Admin.Promotions.Banners.Updated"));
return(continueEditing ? RedirectToAction("Edit", new { id = banner.Id }) : RedirectToAction("List"));
}
return(View(model));
}
public JsonResult Edit(BannerModel entity)
{
ResponseMessage resp = new ResponseMessage();
string[] Images = entity.ImageList.Split(',');
if (Images.Length <= 0)
{
resp.IsSuccess = false;
resp.Message = "无图不Banner!";
return(Json(resp));
}
T_Banner banner = null;
IList <T_Banner> BannerList = new List <T_Banner>();
string[] ImageAndRedirect = null;
for (int i = 0; i < Images.Length; i++)
{
banner = new T_Banner();
banner.Title = entity.Title;
banner.Position = entity.Position;
banner.IsDelete = false;
banner.Creator = Admin.Id;
banner.CreateTime = DateTime.Now;
ImageAndRedirect = Images[i].Split(';');
banner.ImageUrl = ImageAndRedirect[0];
banner.RedirectUrl = ImageAndRedirect[1];
banner.SortId = i;
BannerList.Add(banner);
}
service.UpdateBatch(BannerList);
return(Json(resp));
}
public BannerModel Get(int id)
{
var entity = _BannerService.GetBannerById(id);
var model = new BannerModel
{
Id = entity.Id,
Title = entity.Title,
ImgUrl = entity.ImgUrl,
Order = entity.Order,
Adduser = entity.Adduser,
Addtime = entity.Addtime,
Upduser = entity.Upduser,
Updtime = entity.Updtime,
// Content = entity.Content,
};
return(model);
}
/// <summary>
/// Creates a new Banner
/// </summary>
/// <param name="model"></param>
public void CreateBanner(BannerModel model)
{
_db.Banners.Add(new Banner {
Text = model.Text, IsActive = true
});
_db.SaveChanges();
}
public JsonResult AddBanner(BannerModel bannerModel, IFormCollection collection)
{
var files = collection.Files;
if (files.Count > 0)
{
var webRootPath = host.WebRootPath;
string relativeDirPath = "\\BannerPic";
string absolutePath = webRootPath + relativeDirPath;
string[] fileTypes = new string[] { ".gif", ".jpg", ".jpeg", ".png", ".bmp" };
string extension = Path.GetExtension(files[0].FileName);
if (fileTypes.Contains(extension.ToLower()))
{
if (!Directory.Exists(absolutePath))
{
Directory.CreateDirectory(absolutePath);
}
string fileName = DateTime.Now.ToString("yyyyMMddHHmmss") + extension;
var filePath = absolutePath + "\\" + fileName;
using (var stream = new FileStream(filePath, FileMode.Create))
{
files[0].CopyTo(stream);
}
bannerModel.Image = "/BannerPic/" + fileName;
return(Json(bannerServices.AddBanner(bannerModel)));
}
return(Json(new ResponseModel {
code = 0, message = "图片格式有误"
}));
}
return(Json(new ResponseModel {
code = 0, message = "请上传图片文件"
}));
}
public ActionResult Edit(int id)
{
var banner = _bannerService.GetBannerById(id);
var model = new BannerModel();
if (banner.BannerType == BannerTypeEnum.Productpage)
{
var category = _categoryService.GetCategoryById(banner.CategoryId.Value);
model.CategoryName = category.Name;
model.CategoryId = category.Id;
}
var categories = _categoryService.GetAllCategories();
model.AviableCategories = categories.Select(x => new SelectListItem()
{
Value = x.Id.ToString(),
Text = x.Name,
Selected = x.Id == model.CategoryId
}).ToList();
model.Id = banner.Id;
model.Size = GetBannerWidth(banner.BannerType);
model.Height = GetBannerHeight(banner.BannerType);
model.DisplayOnMain = banner.DisplayOnMain;
model.BannerType = banner.BannerType;
model.Alt = banner.Alt;
model.PictureId = banner.PictureId;
model.Title = banner.Title;
model.Url = banner.Url;
model.NetBanner = banner.NetBanner;
model.BannerTypeId = banner.BannerTypeId;
model.BannerType = banner.BannerType;
model.BannerTypeString = banner.BannerType.GetLocalizedEnum(_localizationService, _workContext.WorkingLanguage.Id);
return(View(model));
}
public ActionResult AddBanner(BannerModel model)
{
if (Banners.GetBannerPositionById(model.BanPosId) == null)
{
ModelState.AddModelError("BanPosId", "Banner位置不存在");
}
if (ModelState.IsValid)
{
BannerInfo bannerInfo = new BannerInfo()
{
BanPosId = model.BanPosId,
StartTime = model.StartTime,
EndTime = model.EndTime,
IsShow = model.IsShow,
Title = model.BannerTitle == null ? "" : model.BannerTitle,
Img = model.Img,
Url = model.Url,
DisplayOrder = model.DisplayOrder
};
Banners.CreateBanner(bannerInfo);
AddAdminOperateLog("添加banner", "添加banner,banner为:" + model.BannerTitle);
return(PromptView("banner添加成功"));
}
Load();
return(View(model));
}
/// <summary>
/// 添加头部信息
/// </summary>
/// <param name="bannerModel">Banner</param>
/// <returns>响应实体模型</returns>
public ResponseModel AddBanner(BannerModel bannerModel)
{
Banner banner = new Banner();
try
{
banner.Id = bannerModel.Id;
banner.Image = bannerModel.Image;
banner.Remark = bannerModel.Remark;
banner.Url = bannerModel.Url;
banner.AddTime = DateTime.Now;
}
catch { return(new ResponseModel {
code = 0, message = "内部添加错误,请重试"
}); }
bool add = bannerRepository.AddEntity(banner);
if (add == false)
{
return new ResponseModel {
code = 0, message = "添加失败"
}
}
;
return(new ResponseModel {
code = 200, message = "添加成功"
});
}
public ActionResult Create(int ID)
{
BannerModel model = new BannerModel();
if (ID != 0)
{
var response = client.GetAsync(string.Format("{0}/api/Banners/{1}", WebAPIUrl, ID)).Result;
if (response.IsSuccessStatusCode)
{
var responseString = JObject.Parse(response.Content.ReadAsStringAsync().Result);
string code = responseString.SelectToken("code").ToString();
if (code == "0")
{
model.ID = (int)responseString["data"]["ID"];
model.ImageName = (string)responseString["data"]["Name"];
model.Active = Convert.ToBoolean(responseString["data"]["Active"]);
}
else
{
}
}
return(View(model));
}
else
{
return(View(model));
}
}
// GET: Banner/Edit/5
public ActionResult Edit(int id)
{
BannerModel bannerModel = new BannerModel();
DataTable dtblBanner = new DataTable();
using (SqlConnection sqlConn = new SqlConnection(connectionString))
{
sqlConn.Open();
string query = "Select * from Banner where ProductID=@ProductID";
SqlDataAdapter sqlDa = new SqlDataAdapter(query, sqlConn);
sqlDa.SelectCommand.Parameters.AddWithValue("@ProductID", id);
sqlDa.Fill(dtblBanner);
}
if (dtblBanner.Rows.Count == 1)
{
bannerModel.ProductID = Convert.ToInt32(dtblBanner.Rows[0][0].ToString());
bannerModel.ProductType = dtblBanner.Rows[0][1].ToString();
bannerModel.ProductTitle = dtblBanner.Rows[0][2].ToString();
bannerModel.ProductDescription = dtblBanner.Rows[0][3].ToString();
return(View(bannerModel));
}
else
{
return(RedirectToAction("Index"));
}
}
public ActionResult Add()
{
BannerModel model = new BannerModel();
Load();
return(View(model));
}
public Banner AddBannerFromModel(BannerModel model)
{
var banner = GetBannerFromModel(model);
_bannerRepository.Insert(banner);
return(banner);
}
public IActionResult Create(BannerModel model, IFormFile image)
{
try
{
if (ModelState.IsValid)
{
if (model.ID == 0)
{
#region For Create
var banner = _mapper.Map <Banner>(model);
if (image != null)
{
string urlImage = MyTool.UploadImage(image, "wwwroot", "Image", "Sliders");
if (!string.IsNullOrEmpty(urlImage))
{
banner.ImagePath = urlImage;
}
}
db.Banners.Add(banner);
db.SaveChanges();
#endregion For Create
TempData["StatusMessage"] = "Successfully created";
}
else
{
#region for edit
var bannerEdit = _mapper.Map <Banner>(model);
if (image != null)
{
string urlImage = MyTool.UploadImage(image, "wwwroot", "Image", "Sliders");
if (!string.IsNullOrEmpty(urlImage))
{
bannerEdit.ImagePath = urlImage;
}
}
db.Update(bannerEdit);
db.SaveChanges();
#endregion for edit
TempData["StatusMessage"] = "Successfully updated";
}
return(RedirectToAction("Index"));
}
}
catch (Exception ex)
{
TempData["StatusMessage"] = ex.Message;
return(View(model));
}
return(View(model));
}
public ActionResult CreateBanner([Bind(Include = "BannerId,Url,CreatedOn,LastUpdatedOn,IsActive")] BannerModel BannerModel, HttpPostedFileBase file)
{
TempData["ShowMessage"] = "";
TempData["MessageBody"] = "";
UserPermissionAction("admin", RoleAction.create.ToString());
CheckPermission();
Mapper.CreateMap <CommunicationApp.Web.Models.BannerModel, CommunicationApp.Entity.Banner>();
CommunicationApp.Entity.Banner banner = Mapper.Map <CommunicationApp.Web.Models.BannerModel, CommunicationApp.Entity.Banner>(BannerModel);
if (ModelState.IsValid)
{
if (file != null)
{
banner.Url = Savefile(file);
}
banner.CustomerId = Convert.ToInt32(Session["CustomerId"]);
_BannerService.InsertBanner(banner);
TempData["ShowMessage"] = "Success";
TempData["MessageBody"] = "banner successfully saved.";
}
else
{
var errors = ModelState.Where(x => x.Value.Errors.Count > 0).Select(x => new { x.Key, x.Value.Errors }).ToArray();
var modelStateErrors = this.ModelState.Keys.SelectMany(key => this.ModelState[key].Errors);
TempData["ShowMessage"] = "Error";
TempData["MessageBody"] = "Please fill the required data.";
return(View(BannerModel));
}
int id = Convert.ToInt32(Session["CustomerId"]);
return(RedirectToAction("BannerDetail/" + id + ""));
}
public bool Put(BannerModel model)
{
var entity = _BannerService.GetBannerById(model.Id);
if (entity == null)
{
return(false);
}
entity.Title = model.Title;
entity.ImgUrl = model.ImgUrl;
entity.Order = model.Order;
entity.Adduser = model.Adduser;
entity.Addtime = model.Addtime;
entity.Upduser = model.Upduser;
entity.Updtime = model.Updtime;
// entity.Content = model.Content;
if (_BannerService.Update(entity) != null)
{
return(true);
}
return(false);
}
public IActionResult Create()
{
var model = new BannerModel();
//locales
AddLocales(_languageService, model.Locales);
return(View(model));
}
public JsonResult DeleteBanner(BannerModel obj)
{
var baseUrl = Server.MapPath("~/Images/Banners/") + obj.FileName;
System.IO.File.Delete(baseUrl);
BannerService.DeleteBanner(obj.Id);
return(Json(true, JsonRequestBehavior.AllowGet));
}
public async Task <IActionResult> Create()
{
var model = new BannerModel();
//locales
await AddLocales(_languageService, model.Locales);
return(View(model));
}
public bool Post(BannerModel model)
{
var entity = new BannerEntity
{
Title = model.Title,
ImgUrl = model.ImgUrl,
Order = model.Order,
Adduser = model.Adduser,
Addtime = model.Addtime,
Upduser = model.Upduser,
Updtime = model.Updtime,
// Content = model.Content,
};
if(_BannerService.Create(entity).Id > 0)
{
return true;
}
return false;
}
public bool Put(BannerModel model)
{
var entity = _BannerService.GetBannerById(model.Id);
if(entity == null)
return false;
entity.Title = model.Title;
entity.ImgUrl = model.ImgUrl;
entity.Order = model.Order;
entity.Adduser = model.Adduser;
entity.Addtime = model.Addtime;
entity.Upduser = model.Upduser;
entity.Updtime = model.Updtime;
// entity.Content = model.Content;
if(_BannerService.Update(entity) != null)
return true;
return false;
}
