public ActionResult GetRegChar() { KarmaDBEntities db = new KarmaDBEntities(); var DBRolesList = db.roles_list.ToList(); string ItemName = ""; DropDownList DropDownListRoles = new DropDownList(); ArrayList items = new ArrayList(); foreach (var item in DBRolesList) { ItemName = item.Id_Roles; items.Add(new ListItem(ItemName)); } DropDownListRoles.DataSource = items; ViewBag.DropRolesList = new SelectList(db.roles_list.Select(i => i.Id_Roles).ToList(), "Id_Roles"); var DBClassList = db.class_list.ToList(); ItemName = ""; DropDownList DropDownListClass = new DropDownList(); items = new ArrayList(); foreach (var item in DBRolesList) { ItemName = item.Id_Roles; items.Add(new ListItem(ItemName)); } DropDownListRoles.DataSource = items; ViewBag.DropClassList = new SelectList(db.class_list.Select(i => i.Id_Class).ToList(), "Id_Class"); ViewBag.Description = "Заполните данные чтобы ваш персонаж добавился в ростер. Укажите ID для привязки персонажа."; ViewBag.NewRegistr = true; return(this.View(HomeControllerAction.GetRegChar)); }
public ViewResult GetRegChar(KarmaDBEntities Roster, string Nickname, string IDPlayer, string DropDownListClass, string DropDownListRoles) { ViewBag.Description = "Персонаж зарегистрирован"; ViewBag.NewRegistr = false; dataInsert(Nickname, IDPlayer, DropDownListRoles, DropDownListClass); return(this.View(HomeControllerAction.GetRegChar)); }
public IEnumerable <List <KL> > KarmaAssembler(DateTime RaidDate) { KarmaDBEntities db = new KarmaDBEntities(); var DBRosterList = db.chartable.Join(db.playerdata, c => c.idplayer, p => p.idPlayer, (c, p) => new { c, p }).Where(t => t.p.IsActive == 1).OrderBy(s => s.p.idPlayer).ToList(); string ID = ""; sbyte isActive = 0; List <KL> ResultList = new List <KL>(); KL Row = new KL(); foreach (var Character in DBRosterList) { ID = Character.p.idPlayer; isActive = Character.p.IsActive ?? 1; if (ID != "" && ID != null) { Row = new KL(); //Получить данные о персе Row.ID = ID; Row.CHARS = CharAssembler(ID); //Получить данные о аттендансе Row.KARMA = KarmaGet(ID, RaidDate); Row.Date = RaidDate; } ResultList.Add(Row); } IEnumerable <List <KL> > RGList = ResultList.GroupBy(x => x.ID) .Select(group => group.ToList()) .ToList(); return(RGList); }
public IEnumerable <List <RL> > CharsAssembler(sbyte ActiveS) { KarmaDBEntities db = new KarmaDBEntities(); var DBRosterList = db.chartable.Join(db.playerdata, c => c.idplayer, p => p.idPlayer, (c, p) => new { c, p }).Where(t => t.p.IsActive == ActiveS).OrderBy(s => s.p.idPlayer).ToList(); string ID = ""; sbyte isActive = 0; List <RL> ResultList = new List <RL>(); RL Row = new RL(); foreach (var Character in DBRosterList) { ID = Character.p.idPlayer; isActive = Character.p.IsActive ?? 1; if (ID != "" && ID != null) { Row = new RL(); Row.ID = ID; Row.CHARS = CharAssembler(ID); Row.ACTIV = isActive; Row.KARMA = KarmaAsemble(ID); Row.NADEZ = NadezAsemble(ID); } ResultList.Add(Row); } IEnumerable <List <RL> > RGList = ResultList.Where(t => t.ACTIV == ActiveS).GroupBy(x => x.ID) .Select(group => group.ToList()) .ToList(); return(RGList); }
public string CharAssembler(string IDPlayer) { KarmaDBEntities db = new KarmaDBEntities(); var DBRosterCharNames = db.chartable.Where(t => t.idplayer == IDPlayer); string CharacterString = ""; foreach (var Character in DBRosterCharNames) { CharacterString = CharacterString + Character.charname + "(" + Character.char_class + "/" + Character.char_role + "),"; } CharacterString = CharacterString.Substring(0, (CharacterString.Length - 1)); return(CharacterString); }
public ActionResult GetSettings() { KarmaDBEntities db = new KarmaDBEntities(); var DBRolesList = db.settingstable.ToList(); ViewBag.kwOValue = DBRolesList[0].ValueSetting; ViewBag.AValue = DBRolesList[1].ValueSetting; ViewBag.wMValue = DBRolesList[2].ValueSetting; ViewBag.kwAValue = DBRolesList[3].ValueSetting; ViewBag.STValue = DBRolesList[4].ValueSetting; ViewBag.wPValue = DBRolesList[5].ValueSetting; ViewBag.kwBValue = DBRolesList[6].ValueSetting; return(this.View(HomeControllerAction.GetSettings)); }
public ActionResult GetAbsForm(KarmaDBEntities Roster, string Reason, string IDPlayer, DateTime?Date1, DateTime?Date2) { ViewBag.NewAbsent = false; ViewBag.Description = "Ваша заявка внесена"; if (Date2.HasValue) { Date2 = Date1; } ; DateTime RealDate1 = Date1 ?? DateTime.Now; DateTime RealDate2 = Date2 ?? DateTime.Now; AbsebtInsert(Reason, IDPlayer, RealDate1, RealDate2); return(this.View(HomeControllerAction.AbsForm)); }
public ActionResult GetSettings(KarmaDBEntities Roster, int AValue, int wPValue, int wMValue, int kwBValue, int kwOValue, int kwAValue, int STValue) { KarmaDBEntities db = new KarmaDBEntities(); var DBRolesList = db.settingstable.ToList(); DBRolesList[0].ValueSetting = kwOValue; DBRolesList[1].ValueSetting = AValue; DBRolesList[2].ValueSetting = wMValue; DBRolesList[3].ValueSetting = kwAValue; DBRolesList[4].ValueSetting = STValue; DBRolesList[5].ValueSetting = wPValue; DBRolesList[6].ValueSetting = kwBValue; ViewBag.kwOValue = DBRolesList[0].ValueSetting; ViewBag.AValue = DBRolesList[1].ValueSetting; ViewBag.wMValue = DBRolesList[2].ValueSetting; ViewBag.kwAValue = DBRolesList[3].ValueSetting; ViewBag.STValue = DBRolesList[4].ValueSetting; ViewBag.wPValue = DBRolesList[5].ValueSetting; ViewBag.kwBValue = DBRolesList[6].ValueSetting; db.SaveChanges(); return(this.View(HomeControllerAction.GetSettings)); }
public ActionResult Roster() { KarmaDBEntities db = new KarmaDBEntities(); var DBRosterList = db.chartable.Join(db.playerdata, c => c.idplayer, p => p.idPlayer, (c, p) => new { c, p }); var DBCharsList = db.playerdata.OrderByDescending(t => t.IsActive).ToList(); var QueryData = DBRosterList.Where(t => t.c.char_role == "ТАНК" && t.p.IsActive == 1).ToList(); ViewBag.ATanksCount = QueryData.Count(); QueryData = DBRosterList.Where(t => t.c.char_role == "МДД" && t.p.IsActive == 1).ToList(); ViewBag.AMddCount = QueryData.Count(); QueryData = DBRosterList.Where(t => t.c.char_role == "РДД" && t.p.IsActive == 1).ToList(); ViewBag.ARddCount = QueryData.Count(); QueryData = DBRosterList.Where(t => t.c.char_role == "ХИЛЛ" && t.p.IsActive == 1).ToList(); ViewBag.AHealsCount = QueryData.Count(); QueryData = DBRosterList.Where(t => t.c.char_role == "ТАНК" && t.p.IsActive == 0).ToList(); ViewBag.ITanksCount = QueryData.Count(); QueryData = DBRosterList.Where(t => t.c.char_role == "МДД" && t.p.IsActive == 0).ToList(); ViewBag.IMddCount = QueryData.Count(); QueryData = DBRosterList.Where(t => t.c.char_role == "РДД" && t.p.IsActive == 0).ToList(); ViewBag.IRddCount = QueryData.Count(); QueryData = DBRosterList.Where(t => t.c.char_role == "ХИЛЛ" && t.p.IsActive == 0).ToList(); ViewBag.IHealsCount = QueryData.Count(); return(this.View(DBCharsList)); }