protected void Page_Load(object sender, EventArgs e)
{
string id = Request.QueryString["id"];
ExchangeItem = DataHelper.GetExchangeItem(Convert.ToInt64(id));
ExchangeAdvert = AdvertsDataHelper.GetAdvert(ExchangeItem.AdvertId);
}
/// <summary>
/// 广告列表
/// </summary>
public ActionResult AdvertList(int adPosId = 0, int pageSize = 15, int pageNumber = 1)
{
PageModel pageModel = new PageModel(pageSize, pageNumber, Adverts.AdminGetAdvertCount(adPosId));
AdvertListModel model = new AdvertListModel()
{
PageModel = pageModel,
AdPosId = adPosId,
AdvertList = Adverts.AdminGetAdvertList(pageModel.PageSize, pageModel.PageNumber, adPosId)
};
List <SelectListItem> itemList = new List <SelectListItem>();
itemList.Add(new SelectListItem()
{
Text = "全部广告位置", Value = "0"
});
foreach (AdvertPositionInfo advertPositionInfo in Adverts.GetAllAdvertPosition())
{
itemList.Add(new SelectListItem()
{
Text = advertPositionInfo.Title, Value = advertPositionInfo.AdPosId.ToString()
});
}
ViewData["advertPositionList"] = itemList;
SiteUtils.SetAdminRefererCookie(Url.Action("advertlist"));
return(View(model));
}
protected void Page_Load(object sender, EventArgs e)
{
long id = Convert.ToInt64(Request.QueryString["id"]);
if (id == 0)
{
Response.Redirect("/");
}
if (!IsPostBack)
{
AdvertItem = AdvertsDataHelper.GetAdvert(id);
if (User != null)
{
WatchedDataHelper.AddWatched(User.UserId, id);
}
else
{
if (Request.Cookies["uid"] != null)
{
string value = Request.Cookies["uid"].Value;
WatchedDataHelper.AddWatchedByCookies(value, id);
}
}
}
string tempId = Page.RouteData.Values["id"] as string;
}
public async Task <ActionResult <Adverts> > PostAdverts(Adverts adverts)
{
_context.Adverts.Add(adverts);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetAdverts", new { id = adverts.Id }, adverts));
}
public ActionResult EditAdvert(AdvertModel model, int adId = -1)
{
AdvertInfo advertInfo = Adverts.AdminGetAdvertById(adId);
if (advertInfo == null)
{
return(PromptView("广告不存在"));
}
int oldAdPosId = advertInfo.AdPosId;
if (ModelState.IsValid)
{
advertInfo.AdPosId = model.AdPosId;
advertInfo.Type = model.Type;
advertInfo.Title = model.Title;
advertInfo.Body = model.Body;
advertInfo.Url = model.Url ?? "";
advertInfo.StartTime = model.StartTime;
advertInfo.EndTime = model.EndTime;
advertInfo.State = model.State;
advertInfo.DisplayOrder = model.DisplayOrder;
Adverts.UpdateAdvert(oldAdPosId, advertInfo);
AddAdminOperateLog("修改广告", "修改广告,广告ID为:" + adId);
return(PromptView("广告修改成功"));
}
Load();
return(View(model));
}
public ActionResult AddAdvert(AdvertModel model)
{
if (Adverts.GetAdvertPositionById(model.AdPosId) == null)
{
ModelState.AddModelError("AdPosId", "广告位置不存在");
}
if (ModelState.IsValid)
{
AdvertInfo advertInfo = new AdvertInfo()
{
ClickCount = 0,
AdPosId = model.AdPosId,
Type = model.Type,
Title = model.Title,
Body = model.Body,
Url = model.Url ?? "",
StartTime = model.StartTime,
EndTime = model.EndTime,
State = model.State,
DisplayOrder = model.DisplayOrder
};
Adverts.CreateAdvert(advertInfo);
AddAdminOperateLog("添加广告", "添加广告,广告为:" + model.Title);
return(PromptView("广告添加成功"));
}
Load();
return(View(model));
}
void Awake()
{
if (instance != null)
{
//throw new System.Exception("You have more than 1 GlobalScript in the scene.");
Destroy(this);
return;
}
#if UNITY_ANDROID
Advertisement.Initialize("1278938", false);
#endif
#if UNITY_IOS
Advertisement.Initialize("1278937", false);
#endif
Debug.Log(Advertisement.isInitialized);
Debug.Log(Advertisement.testMode);
Debug.Log(Advertisement.isSupported);
support = Advertisement.isSupported;
showChance = baseChance;
// Initialize the static class variables
instance = this;
DontDestroyOnLoad(gameObject);
}
public ActionResult Create([Bind(Include = "ID,CarID,Description,Active,Price,Photo,Email,phone")] Adverts adverts)
{
string main = Server.MapPath("~/Content/Photo/AdvertsPhoto");
if (ModelState.IsValid)
{
HttpPostedFileBase postedFile = Request.Files["Photo"];
if (postedFile.ContentLength > 0)
{
var fileName = Path.GetFileName(postedFile.FileName);
var path = Path.Combine(main, fileName);
adverts.Photo = fileName;
postedFile.SaveAs(path);
}
db.Notice.Add(adverts);
db.SaveChanges();
return(RedirectToAction("Index"));
}
//var email = User.Identity.GetUserName();
//ViewBag.RepairID = new SelectList(db.Repairs.Where(u => u.Email == email), "ID", "Name");
//ViewBag.CarID = new SelectList(db.Car, "ID", "Brand", adverts.CarID);
return(View(adverts));
}
public async Task <IActionResult> PutAdverts(int id, Adverts adverts)
{
if (id != adverts.Id)
{
return(BadRequest());
}
_context.Entry(adverts).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!AdvertsExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
// GET: Adverts/AdvertDetails
public ActionResult AdvertDetails(Guid?id)
{
try
{
if (id == null)
{
LogHelper.Log(Log.Event.GET_ADVERT_DETAILS, "AdvertID cannot be found");
Response.StatusCode = (int)HttpStatusCode.NotFound;
return(Error("AdvertID cannot be found"));
}
Adverts adverts = db.Adverts.Find(id);
if (adverts == null)
{
LogHelper.Log(Log.Event.GET_ADVERT_DETAILS, "Advert Details cannot be found");
Response.StatusCode = (int)HttpStatusCode.BadRequest;
return(Error("Advert Details cannot be found"));
}
return(Json(new
{
success = true,
message = "Advert details",
data = new
{
Adverts = db.Adverts.Where(x => x.AdvertID == id).Select(x => new
{
x.AdvertStatusID,
x.Headline,
DepartmentName = db.AdvertLotNumber.Where(y => y.AdvertID == x.AdvertID).Select(y => y.Procurements.Department.DepartmentName).FirstOrDefault(),
BudgetYear = db.BudgetYear.Where(y => y.BudgetYearID == x.BudgetYearID).Select(y => y.BudgetYear1.Value.Year).FirstOrDefault(),
AdvertCategory = db.AdvertLotNumber.Where(z => z.AdvertID == x.AdvertID).Select(z => new
{
z.ProcurementID,
ProjectCategoryID = db.AdvertCategoryNumber.Where(a => a.AdvertID == x.AdvertID).Select(a => a.ProjectCategoryID).FirstOrDefault(),
AdvertCategoryNumberID = db.AdvertCategoryNumber.Where(a => a.AdvertID == x.AdvertID).Select(a => a.AdvertCategoryNumberID).FirstOrDefault(),
AdvertLotNumberID = db.AdvertLotNumber.Where(a => a.AdvertID == x.AdvertID).Select(a => a.AdvertLotNumberID).FirstOrDefault(),
CategoryName = db.AdvertCategoryNumber.Where(a => a.AdvertID == x.AdvertID).Select(a => a.ProjectCategory.Name).FirstOrDefault(),
CategoryLotCode = db.AdvertCategoryNumber.Where(a => a.AdvertID == x.AdvertID).Select(a => a.CategoryLotCode).FirstOrDefault(),
z.Procurements.ProjectName
}),
ProjectCategory = db.ProjectCategoryOrganizationSettings.Where(z => z.EnableProjectCategory == true).Select(z => new
{
z.ProjectCategoryID,
z.ProjectCategory.Name
})
})
}
}, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
LogHelper.Log(Log.Event.ADVERT_DETAIL, ex.Message);
return(Json(new
{
success = false,
message = "" + ex.Message,
data = new { }
}, JsonRequestBehavior.AllowGet));
}
}
public ActionResult DeleteConfirmed(int id)
{
Adverts adverts = db.Notice.Find(id);
db.Notice.Remove(adverts);
db.SaveChanges();
return(RedirectToAction("Index"));
}
protected void Page_Load(object sender, EventArgs e)
{
long id = Convert.ToInt64(Request.QueryString["id"]);
advId = (int)id;
ItemLikes = DataHelper.GetItemLikes(0, advId);
ItemDislikes = DataHelper.GetItemDisLikes(0, advId);
if (id == 0)
{
Response.Redirect("/");
}
AdvertItem = AdvertsDataHelper.GetAdvert(id);
AnotherUser = DataHelper.GetUser(AdvertItem.CreatedUserId);
if (!IsPostBack)
{
ViewsCount = DataHelper.GetUserViewsCount((int)id, StructsHelper.ViewedType["product"]);
if (User != null)
{
// if user didnt authorised, it will be null
UserViews userViews = new UserViews()
{
Date = DateTime.Now,
UserId = User.UserId,
Type = StructsHelper.ViewedType["product"],
ObjectId = (int)id
};
DataHelper.TryAddUserView(userViews);
}
if (User != null)
{
WatchedDataHelper.AddWatched(User.UserId, id);
}
else
{
if (Request.Cookies["uid"] != null)
{
string value = Request.Cookies["uid"].Value;
WatchedDataHelper.AddWatchedByCookies(value, id);
}
}
}
}
public void TestGetAdvertSummay()
{
Adverts adverts = new Adverts
{
};
var testGetAdvertSummay = new AdvertsController();
var result = (JsonResult)testGetAdvertSummay.AdvertSummary();
Console.WriteLine(result.Data);
Assert.IsTrue((result.Data + "").Contains("Advert Summary"));
}
public ActionResult Edit([Bind(Include = "AdvertID,BudgetYearID,AdvertStatusID,Headline,Introduction,ScopeOfWork,EligibiltyRequirement,CollectionOfTenderDocument,BidSubmission,OtherImportantInformation,BidOpeningDate,BidClosingDate,CreatedBy,DateCreated,DateModified")] Adverts adverts)
{
if (ModelState.IsValid)
{
db.Entry(adverts).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.AdvertStatusID = new SelectList(db.AdvertStatus, "AdvertStatusID", "Status", adverts.AdvertStatusID);
ViewBag.BudgetYearID = new SelectList(db.BudgetYear, "BudgetYearID", "CreatedBy", adverts.BudgetYearID);
return(View(adverts));
}
void Awake()
{
if (instance != null)
{
//throw new System.Exception("You have more than 1 GlobalScript in the scene.");
Destroy(this);
return;
}
// Initialize the static class variables
instance = this;
DontDestroyOnLoad(gameObject);
}
public IActionResult AddAdvert([FromBody] Adverts model)
{
try
{
_repoAdvert.Add(model);
//success log
return(Json(true));
}
catch (Exception ex)
{
//log at
return(Json(false));
}
}
// GET: Adverts/Delete/5
public ActionResult Delete(Guid?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Adverts adverts = db.Adverts.Find(id);
if (adverts == null)
{
return(HttpNotFound());
}
return(View(adverts));
}
// GET: Adverts/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Adverts adverts = db.Notice.Find(id);
if (adverts == null)
{
return(HttpNotFound());
}
return(View(adverts));
}
// GET: Adverts/Edit/5
public ActionResult Edit(Guid?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Adverts adverts = db.Adverts.Find(id);
if (adverts == null)
{
return(HttpNotFound());
}
ViewBag.AdvertStatusID = new SelectList(db.AdvertStatus, "AdvertStatusID", "Status", adverts.AdvertStatusID);
ViewBag.BudgetYearID = new SelectList(db.BudgetYear, "BudgetYearID", "CreatedBy", adverts.BudgetYearID);
return(View(adverts));
}
/// <summary>
/// 广告位置列表
/// </summary>
public ActionResult AdvertPositionList(int pageSize = 15, int pageNumber = 1)
{
PageModel pageModel = new PageModel(pageSize, pageNumber, Adverts.GetAdvertPositionCount());
AdvertPositionListModel model = new AdvertPositionListModel()
{
PageModel = pageModel,
AdvertPositionList = Adverts.GetAdvertPositionList(pageSize, pageNumber)
};
SiteUtils.SetAdminRefererCookie(string.Format("{0}?pageNumber={1}&pageSize={2}",
Url.Action("advertpositionlist"),
pageModel.PageNumber,
pageModel.PageSize));
return(View(model));
}
protected void Page_Load(object sender, EventArgs e)
{
long id = Convert.ToInt64(Request.QueryString["id"]);
if (id == 0)
{
Response.Redirect("/");
}
if (!IsPostBack)
{
AdvertItem = AdvertsDataHelper.GetAdvert(id);
}
string tempId = Page.RouteData.Values["id"] as string;
}
public IActionResult AdvertDelete(int advertId)
{
try
{
Adverts old = _repoAdvert.Where(x => x.Id == advertId).FirstOrDefault();
old.IsDeleted = true;
_repoAdvert.Update(old);
//log
return(Json(true));
}
catch (Exception ex)
{
//log
return(Json(false));
}
}
public ActionResult EditAdvertPosition(int adPosId = -1)
{
AdvertPositionInfo advertPositionInfo = Adverts.GetAdvertPositionById(adPosId);
if (advertPositionInfo == null)
{
return(PromptView("广告位置不存在"));
}
AdvertPositionModel model = new AdvertPositionModel();
model.Title = advertPositionInfo.Title;
model.Description = advertPositionInfo.Description;
ViewData["referer"] = SiteUtils.GetAdminRefererCookie();
return(View(model));
}
public ActionResult AddAdvertPosition(AdvertPositionModel model)
{
if (ModelState.IsValid)
{
AdvertPositionInfo advertPositionInfo = new AdvertPositionInfo()
{
Title = model.Title,
Description = model.Description ?? ""
};
Adverts.CreateAdvertPosition(advertPositionInfo);
AddAdminOperateLog("添加广告位置", "添加广告位置,广告位置为:" + model.Title);
return(PromptView("广告位置添加成功"));
}
ViewData["referer"] = SiteUtils.GetAdminRefererCookie();
return(View(model));
}
private void Load()
{
List <SelectListItem> itemList = new List <SelectListItem>();
itemList.Add(new SelectListItem()
{
Text = "请选择广告位置", Value = "0"
});
foreach (AdvertPositionInfo advertPositionInfo in Adverts.GetAllAdvertPosition())
{
itemList.Add(new SelectListItem()
{
Text = advertPositionInfo.Title, Value = advertPositionInfo.AdPosId.ToString()
});
}
ViewData["advertPositionList"] = itemList;
ViewData["referer"] = SiteUtils.GetAdminRefererCookie();
}
// GET: Adverts/AdvertSummary
public ActionResult AdvertSummary()
{
try
{
Adverts adverts = new Adverts();
if (adverts == null)
{
LogHelper.Log(Log.Event.GET_ADVERT_Summary, "Advert Details cannot be found");
Response.StatusCode = (int)HttpStatusCode.BadRequest;
return(Error("Advert Details cannot be found"));
}
else
{
return(Json(new
{
success = true,
message = "Advert Summary",
data = db.Adverts.Where(y => y.AdvertStatusID == y.AdvertStatusID).Select(x => new
{
x.AdvertID,
x.Headline,
x.BidOpeningDate,
x.BidClosingDate,
x.AdvertStatusID,
x.AdvertStatus.Status
})
}, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
LogHelper.Log(Log.Event.ADVERT_SUMMARY, ex.Message);
return(Json(new
{
success = false,
message = "" + ex.Message,
data = new { }
}, JsonRequestBehavior.AllowGet));
}
}
public ActionResult AddAdvert(int BudgetYear, string Headline, string DepartmentName)
{
try
{
DateTime dt = DateTime.Now;
var DepartmentID = db.Department.Where(x => x.DepartmentName == DepartmentName).Select(x => x.DepartmentID).FirstOrDefault();
Adverts adverts = new Adverts();
var BudgetYearId = db.BudgetYear.Where(x => x.BudgetYear1.Value.Year == BudgetYear).Select(x => x.BudgetYearID).FirstOrDefault();
int AdvertStatusID = 0;
int.TryParse(GetConfiguration("DraftAdvertStatusID"), out AdvertStatusID);
var checkIfBudgetYearExists = db.BudgetYear.Where(x => x.BudgetYearID == x.BudgetYearID).Select(x => x.BudgetYearID).FirstOrDefault();
if (checkIfBudgetYearExists == null)
{
LogHelper.Log(Log.Event.ADD_ADVERT_TO_DRAFT, " Budget Year does not exist.");
Response.StatusCode = (int)HttpStatusCode.BadRequest;
return(Error("Budget Year does not exist."));
}
adverts.AdvertID = Guid.NewGuid();
adverts.BudgetYearID = BudgetYearId;
adverts.AdvertStatusID = AdvertStatusID;
adverts.Headline = Headline;
adverts.DateCreated = dt;
adverts.CreatedBy = "Employee";
db.Adverts.Add(adverts);
db.SaveChanges();
return(SentAdvertJson(BudgetYear, DepartmentID));
}
catch (Exception ex)
{
LogHelper.Log(Log.Event.ADD_ADVERT, ex.Message);
return(Json(new
{
success = false,
message = "" + ex.Message,
data = new { }
}, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Edit([Bind(Include = "ID,CarID,Description,Active,Price,Photo,Email,phone")] Adverts adverts)
{
string main = Server.MapPath("~/Content/Photo/AdvertsPhoto");
if (ModelState.IsValid)
{
HttpPostedFileBase postedFile = Request.Files["Photo"];
if (postedFile.ContentLength > 0)
{
var fileName = Path.GetFileName(postedFile.FileName);
var path = Path.Combine(main, fileName);
adverts.Photo = fileName;
postedFile.SaveAs(path);
}
db.Entry(adverts).State = EntityState.Modified;
return(RedirectToAction("Index"));
}
ViewBag.CarID = new SelectList(db.Car, "ID", "Brand", adverts.CarID);
return(View(adverts));
}
public ActionResult EditAdvertPosition(AdvertPositionModel model, int adPosId = -1)
{
AdvertPositionInfo advertPositionInfo = Adverts.GetAdvertPositionById(adPosId);
if (advertPositionInfo == null)
{
return(PromptView("广告位置不存在"));
}
if (ModelState.IsValid)
{
advertPositionInfo.Title = model.Title;
advertPositionInfo.Description = model.Description ?? "";
Adverts.UpdateAdvertPosition(advertPositionInfo);
AddAdminOperateLog("修改广告位置", "修改广告位置,广告位置ID为:" + adPosId);
return(PromptView("广告位置修改成功"));
}
ViewData["referer"] = SiteUtils.GetAdminRefererCookie();
return(View(model));
}
public List <Adverts> FinAdvertByBrandID(int aid)
{
List <Adverts> adverts = new List <Adverts>();
// create connection
SqlConnection connection = new SqlConnection();
connection.ConnectionString = datasource;
connection.Open();
// Create a command Object
SqlCommand command = new SqlCommand("sp_Advert_FindAdvByBrandID", connection);
command.CommandType = System.Data.CommandType.StoredProcedure;
command.Parameters.Add(new SqlParameter("@id", aid));
//Execute the command
SqlDataReader reader = command.ExecuteReader();
// Handle the result
while (reader.Read())
{
Adverts adverts1 = new Adverts();
adverts1.AdID = Convert.ToInt32(reader["AdID"]);
adverts1.AdTitle = Convert.ToString(reader["AdTitle"]);
adverts1.AdCost = Convert.ToInt32(reader["AdCost"]);
adverts1.StartDate = Convert.ToDateTime(reader["Ad_Start_Date"]);
adverts1.EndDate = Convert.ToDateTime(reader["Ad_End_Date"]);
adverts1.Frequency = Convert.ToInt32(reader["Ad_Frequency"]);
adverts1.BrandID = Convert.ToInt32(reader["BrandID"]);
adverts.Add(adverts1);
}
// Close the Connection
connection.Close();
// return the clients List
return(adverts);
}
