public IActionResult NewQuote()
{
List <Material> myMaterials = new List <Material>();
string sql = "SELECT * FROM Material ORDER BY price;";
MySqlConnection myConnection = new MySqlConnection(connecitonString);
MySqlCommand myCommand = new MySqlCommand(sql, myConnection);
myConnection.Open();
MySqlDataReader myReader;
myReader = myCommand.ExecuteReader();
// Always call Read before accessing data.
while (myReader.Read())
{
myMaterials.Add(
new Material
{
Id = Int32.Parse(myReader["materialID"].ToString()),
Description = myReader["description"].ToString(),
Price = Double.Parse(myReader["price"].ToString())
});
}
MaterialsViewModel vm = new MaterialsViewModel {
material = myMaterials
};
return(View(vm));
}
public ActionResult Materials(string SearchTerm = "")
{
try
{
IEnumerable <IMaterial> validEntries = TemplateCache.GetAll <IMaterial>(true);
ApplicationUser user = null;
string searcher = SearchTerm.Trim().ToLower();
if (User.Identity.IsAuthenticated)
{
user = UserManager.FindById(User.Identity.GetUserId());
StaffRank userRank = user.GetStaffRank(User);
}
MaterialsViewModel vModel = new MaterialsViewModel(validEntries.Where(item => item.Name.ToLower().Contains(searcher)))
{
AuthedUser = user,
SearchTerm = SearchTerm,
};
return(View(vModel));
}
catch (Exception ex)
{
LoggingUtility.LogError(ex);
}
return(View());
}
protected override void OnActionExecuting(ActionExecutingContext filterContext)
{
base.OnActionExecuting(filterContext);
ViewBag.ControllerName = (String)RouteData.Values["controller"];
ViewBag.ActionName = RouteData.Values["action"].ToString().ToLower();
ViewBag.HttpKeys = Request.QueryString.AllKeys;
ViewBag.Query = Request.QueryString;
filter = getFilter(page_size);
model = new MaterialsViewModel()
{
Account = AccountInfo,
Settings = SettingsInfo,
UserResolution = UserResolutionInfo,
ControllerName = ControllerName,
ActionName = ActionName
};
//Справочник всех доступных категорий
MaterialsGroup[] GroupsValues = _cmsRepository.getAllMaterialGroups();
ViewBag.AllGroups = GroupsValues;
#region Метатеги
ViewBag.Title = UserResolutionInfo.Title;
ViewBag.Description = "";
ViewBag.KeyWords = "";
#endregion
}
public MaterialAdapter(MaterialsView materialsView, MaterialsViewModel materialViewModel, List <Material> Materials, Context context, Android.Support.V4.App.FragmentManager fragmentManager)
{
this.materialsViewModel = materialViewModel;
this.Materials = Materials;
this.context = context;
this.transaction = fragmentManager;
this.materialsView = materialsView;
}
public ActionResult Index()
{
var model = new MaterialsViewModel
{
FilterText = ""
};
return(View(model));
}
public IActionResult Show(Guid id)
{
Materials materials = new Materials();
materials = materialsService.GetMaterialsById(id);
materials.Browses++;
materialsService.Update(materials);
MaterialsViewModel model = new MaterialsViewModel(materials);
return(View(model));
}
public IActionResult Edit(Guid?Id)
{
List <MaterialsCategory> categories = materialsService.GetAllMaterialsCategories();
ViewData["CategoryList"] = categories.Select(x => new SelectListItem {
Text = x.Title, Value = x.Id.ToString()
});
//List<SelectListItem> CategoryList = new List<SelectListItem>();
//CategoryList.Add(new SelectListItem { Value = "", Text = "分类" });
//foreach (var item in categories)
//{
// CategoryList.Add(new SelectListItem { Value = item.Id.ToString(), Text = item.Title });
//}
//ViewData["CategoryList"] = CategoryList;
//List<SelectListItem> MaterialsTypeList = new List<SelectListItem>();
//MaterialsTypeList.Add(new SelectListItem { Value = "", Text = "资料类型" });
//MaterialsTypeList.Add(new SelectListItem { Value = "0", Text = "视屏" });
//MaterialsTypeList.Add(new SelectListItem { Value = "1", Text = "电子书" });
//MaterialsTypeList.Add(new SelectListItem { Value = "2", Text = "文档资料" });
//MaterialsTypeList.Add(new SelectListItem { Value = "3", Text = "博客" });
//MaterialsTypeList.Add(new SelectListItem { Value = "4", Text = "项目" });
//ViewData["MaterialsTypeList"] = MaterialsTypeList;
//List<SelectListItem> SourceTypeList = new List<SelectListItem>();
//SourceTypeList.Add(new SelectListItem { Value = "", Text = "来源类型" });
//SourceTypeList.Add(new SelectListItem { Value = "0", Text = "原创" });
//SourceTypeList.Add(new SelectListItem { Value = "1", Text = "转载" });
//ViewData["SourceTypeList"] = SourceTypeList;
MaterialsViewModel model = null;
if (Id.HasValue)
{
Materials Materials = materialsService.GetMaterialsById(Id);
model = new MaterialsViewModel(Materials);
model.IsNew = false;
}
else
{
model = new MaterialsViewModel();
model.IsNew = true;
}
return(View(model));
}
public IActionResult Index(string name, int page = 1, SortState sortOrder = SortState.MaterialIdAsc)
{
int pageSize = 10;
IQueryable <Material> source = db.Materials;
if (!String.IsNullOrEmpty(name))
{
source = source.Where(p => p.Name.Contains(name));
}
switch (sortOrder)
{
case SortState.MaterialNameAsc:
source = source.OrderBy(s => s.Name);
break;
case SortState.MaterialTypeAsc:
source = source.OrderBy(s => s.Type);
break;
case SortState.MaterialIdDec:
source = source.OrderByDescending(s => s.Id);
break;
case SortState.MaterialNameDec:
source = source.OrderByDescending(s => s.Name);
break;
case SortState.MaterialTypeDec:
source = source.OrderByDescending(s => s.Type);
break;
}
var count = source.Count();
var items = source.Skip((page - 1) * pageSize).Take(pageSize).ToList();
PageViewModel pageViewModel = new PageViewModel(count, page, pageSize);
MaterialsViewModel viewModel = new MaterialsViewModel
{
Materials = items,
PageViewModel = pageViewModel,
SortViewModel = new MaterialSortViewModel(sortOrder),
FilterViewModel = new WebApplicationSewingStudio.ViewModels.MaterialsViewModels.FilterViewModel(name)
};
return(View(viewModel));
}
public IActionResult Materials()
{
var model = new MaterialsViewModel();
var baseMaterials = _dbContext.Materials.Include(m => m.MaterialCategory)
.Where(m => m.MaterialCategoryId < 3).ToList();
var locks = _dbContext.Materials.Include(m => m.MaterialCategory)
.Where(m => m.MaterialCategoryId >= 3).ToList();
var colors = _dbContext.Colors.ToList();
var colorsCode = new List <string>()
{
"#000000", "#FBEC5D", "#645452", "#F0DC82", "#cd7f32", "#964B00", "#F0FFFF", "#3D2B1F", "#2B1700", " #080808", "#F5F5DC"
};
model.BaseMaterials = baseMaterials;
model.Locks = locks;
model.Colors = colors;
model.ColorCode = colorsCode;
return(View(model));
}
public IActionResult Edit(MaterialsViewModel model)
{
Materials Materials = new Materials();
Materials.Id = model.Id;
Materials.MaterialsType = model.MaterialsType;
Materials.Source = model.Source;
Materials.SourceType = model.SourceType;
Materials.Title = model.Title;
Materials.CategoryId = model.CategoryId;
Materials.Description = model.Description;
if (model.IsNew)
{
Materials.CreateBy = CurrentUser.Id;
materialsService.Save(Materials);
DynamicModel dModel = new DynamicModel();
dModel.CreateDate = Materials.CreateDate;
dModel.Title = Materials.Title;
dModel.Url = "/Materials/Show" + Materials.Id;
dModel.Id = Materials.Id;
///将更新发到全部的客户端 这里用到了DI
IConnectionManager conn = HttpContext.RequestServices.GetService <ConnectionManager>();
IHubContext context = conn.GetHubContext <SMHub>();
context.Clients.All.Send("info", dModel);
}
else
{
Materials.ModifyBy = CurrentUser.Id;
materialsService.Update(Materials);
}
if (materialsService.IsSuccess)
{
return(Redirect("/Admin/Materials/Index"));
}
else
{
ModelState.AddModelError("", materialsService.ReturnMsg);
}
return(View());
}
public IActionResult Materials(int lessonId)
{
var lesson = _traversalService.GetLesson(lessonId);
if (lesson == null)
{
return(RedirectToAction("ResourceNotFound", "Error", new { error = "przedmiot o podanym Id nie istnieje." }));
}
ConfigureMaterialsBreadcrumbs(lesson);
var materials = lesson.Materials;
var materialViewModels = materials.Select(m =>
new MaterialViewModel
{
MaterialId = m.MaterialId,
Name = m.Name,
Description = m.Description,
CreatorUsername = m.Creator.Username,
UploadDate = m.UploadDate,
UpdaterUsername = m.Updater?.Username,
ModificationDate = m.ModificationDate,
State = m.State.Name
}
).ToList();
var vms = new MaterialsViewModel
{
Materials = materialViewModels,
IsWithSubtitles = true,
LessonId = lessonId
};
return(View(vms));
}
public ViewModels(Models models)
{
m_models = models;
// view model initialization
ConsoleOutput = new ConsoleOutputViewModel(m_models);
Display = new DisplayViewModel(m_models);
Cameras = new CamerasViewModel(m_models);
Lights = new LightsViewModel(m_models);
Materials = new MaterialsViewModel(m_models);
Toolbar = new ToolbarViewModel(m_models);
Statusbar = new StatusbarViewModel(m_models);
Profiler = new ProfilerViewModel(m_models);
Renderer = new RendererViewModel(m_models, Toolbar.PlayPauseCommand, Toolbar.ResetCommand);
Scene = new SceneViewModel(m_models);
RenderTargetSelection = new RenderTargetSelectionViewModel(m_models, Toolbar.ResetCommand);
LoadWorld = new LoadWorldViewModel(m_models);
AnimationFrames = new AnimationFrameViewModel(m_models);
Tessellation = new TessellationViewModel(m_models);
// command initialization
AddLightCommand = new AddLightCommand(m_models);
LoadSceneCommand = new LoadSceneCommand(m_models);
SaveSceneCommand = new SaveSceneCommand(m_models);
SelectRendererCommand = new SelectRendererCommand(m_models);
OpenSettingsCommand = new OpenSettingsCommand(m_models);
DenoiseImageCommand = new SaveDenoisedScreenshotCommand(m_models);
RenderAnimatedSequenceCommand = new RenderSequenceCommand(m_models, 0, false, true);
KeyGestures = new KeyGestureViewModel(models);
}
public ActionResult Save(Guid Id, MaterialsViewModel bindData, HttpPostedFileBase upload)
{
ErrorMessage userMessage = new ErrorMessage();
userMessage.title = "Информация";
if (ModelState.IsValid)
{
var res = false;
var getMaterial = _cmsRepository.getMaterial(Id);
// добавление необходимых полей перед сохранением модели
bindData.Item.Id = Id;
#region Сохранение изображения
var width = 0;
var height = 0;
var defaultPreviewSizes = new string[] { "540", "360" };
// путь для сохранения изображения //Preview image
string savePath = Settings.UserFiles + Domain + Settings.MaterialsDir; //+2017_09
if (upload != null && upload.ContentLength > 0)
{
string fileExtension = upload.FileName.Substring(upload.FileName.LastIndexOf(".")).ToLower();
var validExtension = (!string.IsNullOrEmpty(Settings.PicTypes)) ? Settings.PicTypes.Split(',') : "jpg,jpeg,png,gif".Split(',');
if (!validExtension.Contains(fileExtension.Replace(".", "")))
{
model.Item = _cmsRepository.getMaterial(Id);
model.ErrorInfo = new ErrorMessage()
{
title = "Ошибка",
info = "Вы не можете загружать файлы данного формата",
buttons = new ErrorMassegeBtn[]
{
new ErrorMassegeBtn {
url = "#", text = "ок", action = "false", style = "primary"
}
}
};
return(View("Item", model));
}
var sizes = (!string.IsNullOrEmpty(Settings.MaterialPreviewImgSize)) ? Settings.MaterialPreviewImgSize.Split(',') : defaultPreviewSizes;
int.TryParse(sizes[0], out width);
int.TryParse(sizes[1], out height);
bindData.Item.PreviewImage = new Photo()
{
Name = Id.ToString() + fileExtension,
Size = Files.FileAnliz.SizeFromUpload(upload),
Url = Files.SaveImageResizeRename(upload, savePath, Id.ToString(), width, height),
Source = bindData.Item.PreviewImage.Source
};
}
#endregion
if (String.IsNullOrEmpty(bindData.Item.Alias))
{
bindData.Item.Alias = Transliteration.Translit(bindData.Item.Title);
}
else
{
bindData.Item.Alias = Transliteration.Translit(bindData.Item.Alias);
}
//Определяем Insert или Update
if (getMaterial != null)
{
userMessage.info = "Запись обновлена";
res = _cmsRepository.updateCmsMaterial(bindData.Item);
}
else
{
userMessage.info = "Запись добавлена";
res = _cmsRepository.insertCmsMaterial(bindData.Item);
}
//Сообщение пользователю
if (res)
{
string currentUrl = Request.Url.PathAndQuery;
userMessage.buttons = new ErrorMassegeBtn[] {
new ErrorMassegeBtn {
url = StartUrl + Request.Url.Query, text = "Вернуться в список"
},
new ErrorMassegeBtn {
url = currentUrl, text = "ок"
}
};
}
else
{
userMessage.info = "Произошла ошибка";
userMessage.buttons = new ErrorMassegeBtn[] {
new ErrorMassegeBtn {
url = StartUrl + Request.Url.Query, text = "Вернуться в список"
},
new ErrorMassegeBtn {
url = "#", text = "ок", action = "false"
}
};
}
}
else
{
userMessage.info = "Ошибка в заполнении формы. Поля в которых допушены ошибки - помечены цветом.";
userMessage.buttons = new ErrorMassegeBtn[] {
new ErrorMassegeBtn {
url = "#", text = "ок", action = "false"
}
};
}
model.Item = _cmsRepository.getMaterial(Id);
if (model.Item != null && model.Item.PreviewImage != null && !string.IsNullOrEmpty(model.Item.PreviewImage.Url))
{
var photo = model.Item.PreviewImage;
model.Item.PreviewImage = Files.getInfoImage(model.Item.PreviewImage.Url);
model.Item.PreviewImage.Source = photo.Source;
}
model.ErrorInfo = userMessage;
return(View("Item", model));
}
public IActionResult NewQuote(NewQuotesViewModel newQuote)
{
if (ModelState.IsValid)
{
//calculate total quote price
double quotePrice = 200;
double sqInSize = (Double)(newQuote.deskWidth * newQuote.deskLength);
quotePrice += (sqInSize) / 1000;
quotePrice += (Double)(newQuote.drawers * 50);
double materialFee = 0;
//material price comes from database
string materialPrice = "SELECT price FROM Material WHERE description = '" + newQuote.material + "';";
MySqlConnection myConnection = new MySqlConnection(connecitonString);
MySqlCommand myCommand = new MySqlCommand(materialPrice, myConnection);
myConnection.Open();
MySqlDataReader myReader;
myReader = myCommand.ExecuteReader();
// Always call Read before accessing data.
while (myReader.Read())
{
materialFee = Double.Parse(myReader["price"].ToString());
quotePrice += materialFee;
}
myConnection.Close();
//add in shipping cost
double shippingFee = 0;
switch (newQuote.shippingDays)
{
case 14:
//no additional cose
break;
case 3:
if (sqInSize < 1000)
{
shippingFee = 60;
quotePrice += 60;
}
else if (sqInSize >= 1000 && sqInSize < 2000)
{
shippingFee = 70;
quotePrice += 70;
}
else
{
shippingFee = 80;
quotePrice += 80;
}
break;
case 5:
if (sqInSize < 1000)
{
shippingFee = 40;
quotePrice += 40;
}
else if (sqInSize >= 1000 && sqInSize < 2000)
{
shippingFee = 50;
quotePrice += 50;
}
else
{
shippingFee = 60;
quotePrice += 60;
}
break;
case 7:
if (sqInSize < 1000)
{
shippingFee = 30;
quotePrice += 30;
}
else if (sqInSize >= 1000 && sqInSize < 2000)
{
shippingFee = 30;
quotePrice += 35;
}
else
{
shippingFee = 40;
quotePrice += 40;
}
break;
}
quotePrice = Math.Round(quotePrice, 2);
myConnection = new MySqlConnection(connecitonString);
MySqlCommand mySqlCommand = new MySqlCommand("insert_quote", myConnection);
mySqlCommand.CommandType = System.Data.CommandType.StoredProcedure;
mySqlCommand.Parameters.AddWithValue("pv_firstName", newQuote.FirstName);
mySqlCommand.Parameters.AddWithValue("pv_lastName", newQuote.LastName);
mySqlCommand.Parameters.AddWithValue("pv_shippingDays", newQuote.shippingDays);
mySqlCommand.Parameters.AddWithValue("pv_shippingPrice", shippingFee);
mySqlCommand.Parameters.AddWithValue("pv_quoteAmount", quotePrice);
mySqlCommand.Parameters.AddWithValue("pv_description", newQuote.material); //mat des
mySqlCommand.Parameters.AddWithValue("pv_price", materialFee); //mat cost
mySqlCommand.Parameters.AddWithValue("pv_deskWidth", newQuote.deskWidth);
mySqlCommand.Parameters.AddWithValue("pv_deskLength", newQuote.deskLength);
mySqlCommand.Parameters.AddWithValue("pv_drawers", newQuote.drawers);
myConnection.Open();
//MySqlDataReader myReader;
myReader = mySqlCommand.ExecuteReader();
myConnection.Close();
//string tmp = firstName + " " + lastName + " " + deskWidth + " " + deskLength + " " + material + " " + shippingDays;
//return tmp;
return(RedirectToAction("Index"));
}
else
{
List <Material> myMaterials = new List <Material>();
string sql = "SELECT * FROM Material ORDER BY price;";
MySqlConnection myConnection = new MySqlConnection(connecitonString);
MySqlCommand myCommand = new MySqlCommand(sql, myConnection);
myConnection.Open();
MySqlDataReader myReader;
myReader = myCommand.ExecuteReader();
// Always call Read before accessing data.
while (myReader.Read())
{
myMaterials.Add(
new Material
{
Id = Int32.Parse(myReader["materialID"].ToString()),
Description = myReader["description"].ToString(),
Price = Double.Parse(myReader["price"].ToString())
});
}
MaterialsViewModel vm = new MaterialsViewModel {
material = myMaterials
};
NewQuotesViewModelResponce vm2 = new NewQuotesViewModelResponce
{
responceVM = newQuote,
materialsVM = vm
};
return(View("NewQuoteWithErrors", vm2));
}
}
// GET: Materials
public IActionResult Index(string namematerial, double?massmaterial, string units, string property, int page = 1, MaterialsSortState sortOrder = MaterialsSortState.NameMaterialAsc)
{
int pageSize = 10;
IQueryable <Materials> source = _context.Materials;
if (namematerial != null)
{
source = source.Where(x => x.NameMaterial == namematerial);
}
if (massmaterial != null && massmaterial != 0)
{
source = source.Where(x => x.MassMaterial.Value == massmaterial.Value);
}
if (units != null)
{
source = source.Where(x => x.Units == units);
}
if (property != null)
{
source = source.Where(x => x.Property == property);
}
switch (sortOrder)
{
case MaterialsSortState.NameMaterialAsc:
source = source.OrderBy(x => x.NameMaterial);
break;
case MaterialsSortState.NameMaterialDesc:
source = source.OrderByDescending(x => x.NameMaterial);
break;
case MaterialsSortState.MassMaterialAsc:
source = source.OrderBy(x => x.MassMaterial);
break;
case MaterialsSortState.MassMaterialDesc:
source = source.OrderByDescending(x => x.MassMaterial);
break;
case MaterialsSortState.UnitsAsc:
source = source.OrderBy(x => x.Units);
break;
case MaterialsSortState.UnitsDesc:
source = source.OrderByDescending(x => x.Units);
break;
case MaterialsSortState.PropertyAsc:
source = source.OrderBy(x => x.Property);
break;
case MaterialsSortState.PropertyDesc:
source = source.OrderByDescending(x => x.Property);
break;
default:
source = source.OrderBy(x => x.NameMaterial);
break;
}
var count = source.Count();
var items = source.Skip((page - 1) * pageSize).Take(pageSize);
PageViewModel pageView = new PageViewModel(count, page, pageSize);
MaterialsViewModel ivm = new MaterialsViewModel
{
PageViewModel = pageView,
SortViewModel = new SortMaterialsViewModel(sortOrder),
FilterViewModel = new FilterMaterialsViewModel(namematerial, massmaterial, units, property),
Materials = items
};
return(View(ivm));
}
