void LoadList(object param) { if (param != null && param is String) { var db = new AddContext(); switch (param.ToString()) { case "Armor": break; case "Weapons": var view = new Views.ItemList(); var vm = new ViewModel.ListViewModel(); vm.Items = new ObservableCollection <dynamic> { db.Weapons }; view.DataContext = view; object dataContext = (Application.Current.MainWindow as MainWindow)?.DataContext; MainWindowViewModel mainWindowViewModel = (dataContext as MainWindowViewModel); mainWindowViewModel.CurrentView = view; break; default: break; } } }
public String Update(ViewModel.ListViewModel ListView) { try { ListView.TypeCopy = ListView.TypeCopy.Replace(" ", ""); ExponentPortalEntities db = new ExponentPortalEntities(); int TypeId = Util.GetTypeId(ListView.TypeCopy); string BinaryCode = Util.DecToBin(TypeId); //checking for upadation or new record creation if (ListView.Id == 0) { if (!exLogic.User.hasAccess("lOOKUP.CREATE")) { return(Util.jsonStat("error", "Access Denied")); } string SQL = "INSERT INTO LUP_DRONE(\n" + " Type,\n" + " Code,\n" + " TypeId,\n" + " BinaryCode,\n" + " Name,\n" + " CreatedBy,\n" + " CreatedOn,\n" + " IsActive\n" + ") VALUES(\n" + " '" + ListView.TypeCopy + "',\n" + " '" + ListView.Code + "',\n" + " " + TypeId + ",\n" + " '" + BinaryCode + "',\n" + " '" + ListView.Name + "',\n" + " " + Util.getLoginUserID() + ",\n" + " GETDATE(),\n" + " 'True'" + ")"; int ListId = Util.InsertSQL(SQL); return(JSonData(ListView)); } else { if (!exLogic.User.hasAccess("lOOKUP.EDIT")) { return(Util.jsonStat("error", "Access Denied")); } string SQL = "UPDATE LUP_DRONE SET\n" + " Type='" + ListView.TypeCopy + "',\n" + " Code='" + ListView.Code + "',\n" + " Name='" + ListView.Name + "',\n" + " ModifiedBy=" + Util.getLoginUserID() + ",\n" + " ModifiedOn=GETDATE()\n" + "where\n" + " Id=" + ListView.Id; int ListId = Util.doSQL(SQL); return(JSonData(ListView)); } // return RedirectToAction("Listnames"); } catch (Exception ex) { return(Util.jsonStat("error", ex.Message)); } }
// GET: List/Create public ActionResult Create() { if (!exLogic.User.hasAccess("lOOKUP.CREATE")) { return(RedirectToAction("NoAccess", "Home")); } var viewModel = new ViewModel.ListViewModel { Typelist = Util.LUPTypeList() }; return(View(viewModel)); }
public PartialViewResult ListNames(ViewModel.ListViewModel list, String TypeName) { ExponentPortalEntities db = new ExponentPortalEntities(); var result = from r in db.LUP_Drone where r.Type == TypeName & (bool)r.IsActive orderby r.Name select r; list.NameList = result; list.TypeCopy = TypeName; return(PartialView("LookupDetails", list)); }
private String JSonData(ViewModel.ListViewModel ListView) { StringBuilder JSON = new StringBuilder(); JSON.Append("{"); JSON.AppendLine("\"status\": \"ok\","); JSON.AppendLine("\"id\": \"" + ListView.Id.ToString() + "\","); JSON.AppendLine("\"code\": \"" + ListView.Code.ToString() + "\","); JSON.AppendLine("\"name\": \"" + ListView.Name.ToString() + "\""); JSON.Append("}"); return(JSON.ToString()); }
public ActionResult Add(int music_id) { var list = from p in db.List select p; var music = db.Music1.Find(music_id); var pictureinalbum = new ViewModel.ListViewModel { List2 = list, Music = music, }; return(View(pictureinalbum)); }