public ActionResult Index(FormCollection collection, int p = 0)
{
MenuModel.MeunOrderbyTypeEnum _MeunOrderbyTypeEnum = (MenuModel.MeunOrderbyTypeEnum)Enum.Parse(typeof(MenuModel.MeunOrderbyTypeEnum), collection["Sort"], true);
List <PackageViewModel> model = new List <PackageViewModel>();
var _value = PackagesModel.GetPackageList(collection["PG_Name"], p + 1, take, _MeunOrderbyTypeEnum);
//多取一，若有表示有下一頁
if (_value.Count == (take + 1))
{
ViewBag.pn = p + 1;
_value.RemoveAt(take);
}
else
{
ViewBag.pn = 0;
}
ViewBag.pi = p;
for (int i = 0; i < _value.Count; i++)
{
model.Add(new PackageViewModel()
{
Budget = 0,
CreateDate = _value[i].CreateDate,
EndDate = _value[i].EndDate.HasValue ? _value[i].EndDate.Value : DateTime.Now.AddDays(-1),
PG_Name = _value[i].PackagesName,
PG_No = _value[i].PackagesNo.ToString(),
WorksAmount = _value[i].ItemAmount
});
}
setSortDropDown(_MeunOrderbyTypeEnum);
ViewBag.pt = take.ToString();
return(View(model));
}
// GET: Package
public ActionResult Index(int p = 0)
{
List <PackageViewModel> model = new List <PackageViewModel>();
var _value = PackagesModel.GetPackageList("", p + 1, take, MenuModel.MeunOrderbyTypeEnum.預設排序);
//多取一，若有表示有下一頁
if (_value.Count == (take + 1))
{
ViewBag.pn = p + 1;
_value.RemoveAt(take);
}
else
{
ViewBag.pn = 0;
}
ViewBag.pi = p;
for (int i = 0; i < _value.Count; i++)
{
model.Add(new PackageViewModel()
{
Budget = 0,
CreateDate = _value[i].CreateDate,
EndDate = _value[i].EndDate.HasValue ? _value[i].EndDate.Value : DateTime.Now.AddDays(-1),
PG_Name = _value[i].PackagesName,
PG_No = _value[i].PackagesNo.ToString(),
WorksAmount = _value[i].ItemAmount,
CreateUser = _value[i].CreateUser
});
}
setSortDropDown();
ViewBag.pt = take.ToString();
return(View(model));
}
public ActionResult Packages()
{
PackagesModel model = new PackagesModel {
GridDef = GetGridModel()
};
return(View(model));
}
public async Task <PackagesDataModel> UpdatePackages(string token, PackagesModel packagesModel)
{
string attachmentstring = JsonConvert.SerializeObject(packagesModel);
var httpContent = new StringContent(attachmentstring, Encoding.UTF8, "application/json");
var requestUrl = CreateRequestUri(string.Format(System.Globalization.CultureInfo.InvariantCulture,
"api/Packages/UpdatePackages"));
return(await PostAsync <PackagesDataModel>(requestUrl, httpContent));
}
public ActionResult Filter(AdSearchViewModel collection, string id = "")
{
WorksSearchModel value = new WorksSearchModel()
{
Budget = collection.Budget,
MaxDeep = collection.MaxDeep,
MaxHeight = collection.MaxHeight,
MaxLength = collection.MaxLength,
MaxPrice = collection.Price_U,
MaxTimeLength = collection.MaxTimeLength,
MaxWidth = collection.MaxWidth,
MineDeep = collection.MineDeep,
MineHeight = collection.MineHeight,
MineLength = collection.MineLength,
MinePrice = collection.Price_L,
MineTimeLength = collection.MineTimeLength,
MineWidth = collection.MineWidth,
WorksName = collection.WorksName,
StyleNoList = collection.StyleNoList,
AuthorNoList = collection.AuthorNoList,
GenreNoList = collection.GenreNoList,
GradedNoList = collection.GradedNoList,
OrderbyType = MenuModel.WorkOrderbyTypeEnum.稱姓名小至大
};
PackagesModel pm = new PackagesModel();
if (string.IsNullOrEmpty(id))
{
pm.PackagesName = "未命名" + DateTime.Now.ToString("yyMMddHHmmss");
short d = 1;
Int16.TryParse(SystemGeneralModel.GetConfigure(SystemGeneralModel.ConfigureClassEnum.OpenDays.ToString()).ConfigureContent, out d);
pm.EndDate = DateTime.Now.AddDays(d);
pm.Create();
id = pm.PackagesNo;
}
pm = PackagesModel.GetPackageDetail(id);
pm.PackagesName = "";
// 將搜尋結果加入PackagesModel 的WorksNos
var model = value.Search();
for (int i = 0; i < model.Count; i++)
{
pm.PackageItems.Add(new PackagesModel.PackageItemModel()
{
WorksNo = model[i].WorksNo,
IsJoin = "N"
});
}
pm.SearchJson = JsonConvert.SerializeObject(value);
pm.Budget = collection.Budget;
pm.Update();
//儲存篩選條件
return(RedirectToAction("Edit_WorksList", new { id = pm.PackagesNo }));
}
public async Task <DbStatusResult> UpdatePackages(PackagesModel entity)
{
var cmd = new DbStatusCommand();
await ExecuteSQLWithParams("[dbo].UpdatePackages",
GetJsonParam("@Packages", entity),
cmd.IdParam,
cmd.StatusParam,
cmd.MessageParam);
return(cmd.StatusResult);
}
public ActionResult Edit_WorksList(string id = "", string showType = "img")
{
if (string.IsNullOrEmpty(id))
{
return(RedirectToAction("Filter"));
}
PackagesModel value = new PackagesModel();
value = PackagesModel.GetPackageDetail(id);
value.GetPackageItemList(false);
if (value.PackageItems == null || value.PackageItems.Count == 0)
{
return(RedirectToAction("Filter", new { id = id }));
}
PackageViewModel model = new PackageViewModel();
model.PG_No = id;
model.PG_Name = value.PackagesName;
model.Budget = value.Budget;
model.WorksList = new List <WorksInfoViewModel>();
for (int i = 0; i < value.PackageItems.Count; i++)
{
// test
//if (i > 10)
//{
// continue;
//}
model.WorksList.Add(new WorksInfoViewModel()
{
No = value.PackageItems[i].WorksNo,
Author = value.PackageItems[i].AuthorsName,
MedImg = value.PackageItems[i].WorksImg_m,
MiniImgBase64 = value.PackageItems[i].WorksImgBase64,
Name = value.PackageItems[i].WorksName,
Price = value.PackageItems[i].Price.ToString("#,#"),
Checked = value.PackageItems[i].IsJoin == "Y",
Cost = value.PackageItems[i].Cost.ToString("#,#"),
Years = value.PackageItems[i].Year
});
if (model.WorksList[i].Checked)
{
model.Summary += value.PackageItems[i].Price;
}
}
HttpCookie cookie = new HttpCookie("PID");
cookie.Value = id;
HttpContext.Response.Cookies.Remove("PID");
HttpContext.Response.SetCookie(cookie);
ViewBag.ShowType = showType;
return(View(model));
}
public JsonResult Delete(string[] id)
{
for (int i = 0; i < id.Length; i++)
{
try
{ // TODO: Add delete logic here
PackagesModel.Delete(id[i]);
}
catch
{
//return View();
return(Json(id[i]));
}
}
return(Json(id));
}
// GET: Package/Create
public ActionResult Create(string id = "")
{
if (string.IsNullOrEmpty(id))
{
id = Guid.NewGuid().ToString();
PackagesModel pm = new PackagesModel();
pm.PackagesName = "未命名" + DateTime.Now.ToString("yyMMddHHmmss");
pm.PackageItems = new List <PackagesModel.PackageItemModel>();
short d = 1;
Int16.TryParse(SystemGeneralModel.GetConfigure(SystemGeneralModel.ConfigureClassEnum.OpenDays.ToString()).ConfigureContent, out d);
pm.EndDate = DateTime.Now.AddDays(d);
pm.Create();
id = pm.PackagesNo;
}
return(RedirectToAction("Edit", new { id = id }));
}
// GET: Package/Edit/5
public ActionResult Edit(string id)
{
PackagesModel value = new PackagesModel();
value = PackagesModel.GetPackageDetail(id);
short d = 1;
Int16.TryParse(SystemGeneralModel.GetConfigure(SystemGeneralModel.ConfigureClassEnum.OpenDays.ToString()).ConfigureContent, out d);
PackageViewModel model = new PackageViewModel()
{
PG_No = value.PackagesNo,
PG_Name = value.PackagesName,
CreateDate = value.CreateDate,
EndDate = value.EndDate ?? DateTime.Now.AddDays(d),
Url = this.Url.Action("Detail_Works", "Package", new { id = id }, this.Request.Url.Scheme),
QRImg = PackagesModel.DrawQRcodeToImgBase64sting(this.Url.Action("Detail_Works", "Package", new { id = id }, this.Request.Url.Scheme)),
Remark = value.PackagesMemo,
WorksAmount = value.ItemAmount,
Budget = value.Budget,
SumCost = value.SumCost,
SumPrice = value.SumPrice,
};
model.WorksList = new List <WorksInfoViewModel>();
var valueistem = PackagesModel.ReturnPackageItemList(id, true);
for (int i = 0; i < valueistem.Count; i++)
{
model.WorksList.Add(new WorksInfoViewModel()
{
//No = valueistem[i].WorksNo,
Author = valueistem[i].AuthorsName,
//MiniImgBase64 = valueistem[i].WorksImgBase64,
//MedImg = valueistem[i].WorksImg_m,
//MiniImgID = valueistem[i].WorksImgID,
Name = valueistem[i].WorksName,
Price = valueistem[i].Price.ToString("#,#"),
Years = valueistem[i].Year,
Cost = valueistem[i].Cost.ToString("#,#")
});
model.Summary += valueistem[i].Price;
}
return(View(model));
}
public ActionResult Edit(string id, PackageViewModel collection)
{
//try
//{
PackagesModel value = new PackagesModel();
value = PackagesModel.GetPackageDetail(collection.PG_No);
value.PackagesName = collection.PG_Name;
value.EndDate = collection.EndDate;
value.PackagesMemo = collection.Remark ?? "";
value.Budget = collection.Budget;
value.Update();
ViewData["Message"] = "儲存成功";
collection.Url = this.Url.Action("Detail_Works", "Package", new { id = id }, this.Request.Url.Scheme);
collection.QRImg = PackagesModel.DrawQRcodeToImgBase64sting(this.Url.Action("Detail_Works", "Package", new { id = id }, this.Request.Url.Scheme));
collection.WorksList = new List <WorksInfoViewModel>();
var valueistem = PackagesModel.ReturnPackageItemList(id, true);
for (int i = 0; i < valueistem.Count; i++)
{
collection.WorksList.Add(new WorksInfoViewModel()
{
//No = valueistem[i].WorksNo,
Author = valueistem[i].AuthorsName,
//MiniImgBase64 = valueistem[i].WorksImgBase64,
//MedImg = valueistem[i].WorksImg_m,
//MiniImgID = valueistem[i].WorksImgID,
Name = valueistem[i].WorksName,
Price = valueistem[i].Price.ToString("#,#"),
Years = valueistem[i].Year,
Cost = valueistem[i].Cost.ToString("#,#")
});
collection.Summary += valueistem[i].Price;
}
return(View(collection));
//}
//catch
//{
// return Json("儲存失敗");
//}
}
// GET: Package/Details/5
public ActionResult Detail_Works(string id = "")
{
PackageViewModel model = new PackageViewModel();
if (!string.IsNullOrEmpty(id))
{
var value = PackagesModel.GetPackageDetail(id);
model.PG_No = value.PackagesNo;
model.PG_Name = value.PackagesName;
model.Budget = value.Budget;
model.WorksAmount = value.ItemAmount.Substring(0, value.ItemAmount.IndexOf('('));
model.EndDate = value.EndDate.HasValue ? value.EndDate.Value : DateTime.Now.AddDays(-1);
model.SumPrice = value.SumPrice;
model.SumCost = value.SumCost;
model.WorksList = new List <WorksInfoViewModel>();
var valueistem = PackagesModel.ReturnPackageItemList(id, true);
for (int i = 0; i < valueistem.Count; i++)
{
model.WorksList.Add(new WorksInfoViewModel()
{
No = valueistem[i].WorksNo,
Author = valueistem[i].AuthorsName,
MiniImgBase64 = valueistem[i].WorksImgBase64,
MedImg = valueistem[i].WorksImg_m,
//MiniImgID = valueistem[i].WorksImgID,
Name = valueistem[i].WorksName,
Price = valueistem[i].Price.ToString("#,#"),
Years = valueistem[i].Year,
Cost = valueistem[i].Cost.ToString("#,#")
});
model.Summary += valueistem[i].Price;
}
}
//if (model.EndDate < DateTime.Now)
//{
// return RedirectToAction("Expired");
//}
return(View(model));
}
public async Task <ActionResult <ResponseModel> > UpdatePackages([FromBody] PackagesModel Packages)
{
var model = new ResponseModel();
var result = await _dataContext.UpdatePackages(Packages);
if (!result.Status)
{
model.StatusCode = 404;
model.Message = result.Message;
}
else
{
model.StatusCode = 200;
var objPackagesList = await _dataContext.GetPackagesByPram(0, string.Empty, string.Empty, 0, 10000).ToListAsync();
if (objPackagesList != null)
{
model.ResponseObject = objPackagesList;
}
}
return(model);
}
// GET: Works/Details/5
public ActionResult DetailfoC(string id, string p = "")
{
WorksModel value = null;
PackagesModel _PackagesModel = null;
WorksDetailViewModel model = null;
if (!string.IsNullOrEmpty(id))
{
value = WorksModel.GetWorksModelDetail(id);
_PackagesModel = PackagesModel.GetPackageDetail(p);
List <string> Worksize = new List <string>();;
foreach (var mod in value.WorksModuleList)
{
string str_Size = "";
List <string> _SizeList = new List <string>();
string m = mod.Material.MenuName + " ";
if (mod.Height > 0.0)
{
_SizeList.Add(mod.Height.ToString());
}
if (mod.Width > 0.0)
{
_SizeList.Add(mod.Width.ToString());
}
if (mod.Deep > 0.0)
{
_SizeList.Add(mod.Deep.ToString());
}
if (_SizeList.Count > 0)
{
str_Size = string.Join("x", _SizeList.ToArray()) + "cm";
}
//string h = mod.Height > 0.0 ? "" + mod.Height.ToString() + " x " : "";
//string w = mod.Width > 0.0 ? "" + mod.Width.ToString() + " x " : "";
//string d = mod.Deep > 0.0 ? "" + mod.Deep.ToString() + "cm " : "";
string t = mod.TimeLength.Length > 0 ? "影片長度：" + mod.TimeLength : "";
string c = mod.Amount > 1 ? " " + mod.Amount + mod.CountNoun.MenuName : "";
Worksize.Add(m + str_Size + t + c);
}
model = new WorksDetailViewModel()
{
PackagesNo = p,
WorksNo = value.WorksNo,
WorksName = value.WorksName,
AuthorsName = string.Join(",", value.WorksAuthors.Select(a => a.MenuName)),
MaterialsName = Worksize,
Remarks = value.Remarks,
Owner = string.Join(",", value.WorksPropOwnerList.Select(o => o.MenuName)),
PropWare = string.Join(",", value.WorksPropWareTypeList.Select(o => o.MenuName)),
Cost = value.Cost.ToString("#,#"),
Price = value.Price.ToString("#,#"),
PricingDate = value.PricingDate.ToString("yyyy-MM-dd"),
GrossMargin = value.GrossMargin.ToString() + " %",
GenreNo = string.Join(",", value.WorksPropGenreList.Select(o => o.MenuName)),
PropStyle = string.Join(",", value.WorksPropStyleList.Select(o => o.MenuName)),
Years = value.YearStart.ToString() + (value.YearStart == value.YearEnd ? "" : " ~ " + value.YearEnd.ToString()),
WordsRating = value.Rating,
EndDate = _PackagesModel.EndDate.Value
};
}
return(View(model));
}
public ActionResult Filter(string id = "")
{
AdSearchViewModel model = new AdSearchViewModel();
if (!string.IsNullOrEmpty(id))
{
var value = PackagesModel.GetPackageDetail(id);
model = JsonConvert.DeserializeObject <AdSearchViewModel>(value.SearchJson);
if (model != null)
{
model.Budget = value.Budget;
model.PG_Name = value.PackagesName;
model.PG_No = value.PackagesNo;
}
else
{
model = new AdSearchViewModel();
}
}
MenuModel mm = new MenuModel();
List <SelectListItem> Authorsitems = new List <SelectListItem>();
var _AuthorNoList = AuthorsModel.GetAuthorList();
for (int i = 0; i < _AuthorNoList.Count; i++)
{
Authorsitems.Add(new SelectListItem()
{
Text = _AuthorNoList[i].AuthorsCName,
Value = _AuthorNoList[i].AuthorsNo.ToString()
});
}
ViewBag.AuthorNoList = Authorsitems;
List <SelectListItem> WorksStyleitems = new List <SelectListItem>();
var _WorksStyleList = mm.GetMenu(MenuModel.MenuClassEnum.Style);
for (int i = 0; i < _WorksStyleList.Count; i++)
{
WorksStyleitems.Add(new SelectListItem()
{
Text = _WorksStyleList[i].MenuName,
Value = _WorksStyleList[i].MenuID.ToString()
});
}
ViewBag.StyleNoList = WorksStyleitems;
List <SelectListItem> WorksGenreitems = new List <SelectListItem>();
var _WorksGenreList = mm.GetMenu(MenuModel.MenuClassEnum.Genre);
for (int i = 0; i < _WorksGenreList.Count; i++)
{
WorksGenreitems.Add(new SelectListItem()
{
Text = _WorksGenreList[i].MenuName,
Value = _WorksGenreList[i].MenuID.ToString()
});
}
ViewBag.GenreNoList = WorksGenreitems;
ViewBag.GradedNoList = new List <SelectListItem>();
return(View(model));
}
public JsonResult PackageAddWorks(PackageAddWorksJSONModel value)
{
//更改列表中，作品是否被勾選
PackagesModel.SetPackageItemJoin(value.PackageNo, value.WorkNo, value.addtype);
return(Json(value));
}
public async Task <JsonResult> SaveUpdate(PackagesModelViewModel packagesModel)
{
var data = new PackagesDataModel();
var objResponse = new SaveResponse();
string viewFromCurrentController = string.Empty;
List <string> lstString = new List <string>
{
string.Empty
};
if (ModelState.IsValid)
{
try
{
string token = string.Empty;
var claimsIdentity = (ClaimsIdentity)HttpContext.User.Identity;
var userTokenClaim = claimsIdentity.Claims.SingleOrDefault(c => c.Type == "Token");
if (userTokenClaim != null)
{
token = userTokenClaim.Value;
}
var model = new PackagesModel()
{
AddedDate = DateTime.UtcNow, // Convert.ToDateTime("2020-06-19T18:44:40.633Z"),
IsActive = packagesModel.IsActive,
ModifiedDate = DateTime.UtcNow, // Convert.ToDateTime("2020-06-19T18:44:40.633Z"),
PackageId = packagesModel.PackageId,
PackagePrice = packagesModel.PackagePrice,
PackageTitle = packagesModel.PackageTitle,
ProductIdentifier = packagesModel.ProductIdentifier,
SortOrder = packagesModel.SortOrder,
TokenCreditsPoint = packagesModel.TokenCreditsPoint
};
if (model.PackageId > 0)
{
data = await ApiClientFactory.Instance.UpdatePackages(token, model);
}
else
{
data = await ApiClientFactory.Instance.SavePackages(token, model);
}
if (data.responseObject != null && data.responseObject.Any())
{
viewFromCurrentController = await this.RenderViewToStringAsync("PartialGetPackages", data.responseObject);
}
objResponse.StatusCode = Convert.ToInt32(data.statusCode);
objResponse.Html = viewFromCurrentController;
if (Convert.ToInt32(data.statusCode) == 200)
{
objResponse.Message = "Record saved successfully";
await TrackingInfo.TrackInfo(token, EmployeeId, ControllerContext.ActionDescriptor.ControllerName, model.PackageTitle,
model.PackageId, model.PackageId > 0?"Update" : "Save");
}
else
{
objResponse.Message = "Record not saved successfully";
}
return(new JsonResult(new {
objResponse
}));
}
catch (Exception ex)
{
string exep = ex.ToString();
}
}
return(new JsonResult(new List <string>()));
}
