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));
}
