public ActionResult Edit([Bind(Include = "id,username,password,dateOfBirth,mic,headset,online")] users users, FormCollection fc)
{
if (users.id != null && users.username != "" && users.password != "")
{
//userGame table data
bool lol = fc["League"] == "on" ? true : false;
bool cs = fc["Counter"] == "on" ? true : false;
bool pubg = fc["PlayerUnknown's"] == "on" ? true : false;
bool rocket = fc["Rocket"] == "on" ? true : false;
bool fort = fc["Fortnite"] == "on" ? true : false;
int lolHours = int.Parse(fc["lolHours"]);
int csHours = int.Parse(fc["csHours"]);
string gameIDcs = fc["gameConnectIDcs"];
string gameNickcs = fc["gameNickNamecs"];
string gameNicklol = fc["gameNickNamelol"];
//userGameDesc table data
var rankcs = fc["rankCs"];
var ranklol = fc["rankLol"];
bool awp = fc["AWP"] == "on" ? true : false; //CS ROLES
bool lurker = fc["Lurker"] == "on" ? true : false;
bool rifle = fc["Rifle"] == "on" ? true : false;
bool igl = fc["IGL"] == "on" ? true : false;
bool supporter = fc["Supporter"] == "on" ? true : false;
bool frag = fc["Fragger"] == "on" ? true : false;
bool top = fc["Top"] == "on" ? true : false; //LOL ROLES
bool mid = fc["Mid"] == "on" ? true : false;
bool jung = fc["Jungle"] == "on" ? true : false;
bool adc = fc["Adc"] == "on" ? true : false;
bool sup = fc["Support"] == "on" ? true : false;
bool ggg = fc["asdasdasd"] == "on" ? true : false;
users usr = db.user.Find(users.id);
userGames usrGameLol = usr.userGame.Where(u => u.game.id == 1).FirstOrDefault();
userGames usrGameCs = usr.userGame.Where(u => u.game.id == 2).FirstOrDefault();
List <userGameDescs> lolDataList = db.userGameDesc.Where(u => u.userGame.user.id == users.id && u.userGame.game.id == 1).ToList();
List <userGameDescs> csDataList = db.userGameDesc.Where(u => u.userGame.user.id == users.id && u.userGame.game.id == 2).ToList();
userGames userCs = new userGames();
userGames userLol = new userGames();
users.mic = fc["mic"] == "on" ? true : false;
users.headset = fc["headset"] == "on" ? true : false;
userCs.user = usr;
//lol yoksa ve yeni girme işlemi yaparsa, yeni userGame nesnesi doldurma
if (usrGameLol == null && lol)
{
userLol.game = db.game.Find(1);
userLol.time = lolHours;
userLol.user = usr;
userLol.gameNickName = gameNicklol;
db.userGame.Add(userLol);
}
//cs yoksa ve yeni girme işlemi yaparsa, yeni userGame nesnesi doldurma
if (usrGameCs == null && cs)
{
userCs.game = db.game.Find(2);
userCs.time = csHours;
userCs.user = usr;
userCs.gameConnectID = gameIDcs;
userCs.gameNickName = gameNickcs;
db.userGame.Add(userCs);
}
//Lol kaldırdı ise
if (usrGameLol != null && lol == false) //Lol tiki kaldırıldıysa tüm lol verilerini siler.
{
foreach (var item in lolDataList)
{
db.userGameDesc.Remove(item);
}
db.userGame.Remove(usrGameLol);
}
else if (lol == true)
{
if (usrGameLol != null)
{
if (usrGameLol.time != lolHours)
{
usrGameLol.time = lolHours;
db.Entry(usrGameLol).State = EntityState.Modified;
}
if (usrGameLol.gameNickName != gameNicklol)
{
usrGameLol.gameNickName = gameNicklol;
db.Entry(usrGameLol).State = EntityState.Modified;
}
}
if (usrGameLol == null && top)
{
userGameDescs row = new userGameDescs();
row.compAtt = db.compAtt.Find(82);
row.userGame = userLol;
db.userGameDesc.Add(row);
}
else if (lolDataList.Any(u => u.compAtt.id == 82) == false && top == true)
{
userGameDescs row = new userGameDescs();
row.compAtt = db.compAtt.Find(82);
row.userGame = usrGameLol;
db.userGameDesc.Add(row);
}
else if (lolDataList.Any(u => u.compAtt.id == 82) && top == false)
{
var temp = lolDataList.Where(a => a.compAtt.id == 82).First();
db.userGameDesc.Remove(lolDataList.Where(a => a.compAtt.id == 82).First());
lolDataList.Remove(temp);
}
if (usrGameLol == null && mid)
{
userGameDescs row = new userGameDescs();
row.compAtt = db.compAtt.Find(83);
row.userGame = userLol;
db.userGameDesc.Add(row);
}
else if (lolDataList.Any(u => u.compAtt.id == 83) == false && mid == true)
{
userGameDescs row = new userGameDescs();
row.compAtt = db.compAtt.Find(83);
row.userGame = usrGameLol;
db.userGameDesc.Add(row);
}
else if (lolDataList.Any(u => u.compAtt.id == 83) && mid == false)
{
var temp = lolDataList.Where(a => a.compAtt.id == 83).First();
db.userGameDesc.Remove(lolDataList.Where(a => a.compAtt.id == 83).First());
lolDataList.Remove(temp);
}
if (usrGameLol == null && jung)
{
userGameDescs row = new userGameDescs();
row.compAtt = db.compAtt.Find(84);
row.userGame = userLol;
db.userGameDesc.Add(row);
}
else if (lolDataList.Any(u => u.compAtt.id == 84) == false && jung == true)
{
userGameDescs row = new userGameDescs();
row.compAtt = db.compAtt.Find(84);
row.userGame = usrGameLol;
db.userGameDesc.Add(row);
}
else if (lolDataList.Any(u => u.compAtt.id == 84) && jung == false)
{
var temp = lolDataList.Where(a => a.compAtt.id == 84).First();
db.userGameDesc.Remove(lolDataList.Where(a => a.compAtt.id == 84).First());
lolDataList.Remove(temp);
}
if (usrGameLol == null && adc)
{
userGameDescs row = new userGameDescs();
row.compAtt = db.compAtt.Find(85);
row.userGame = userLol;
db.userGameDesc.Add(row);
}
else if (lolDataList.Any(u => u.compAtt.id == 85) == false && adc == true)
{
userGameDescs row = new userGameDescs();
row.compAtt = db.compAtt.Find(85);
row.userGame = usrGameLol;
db.userGameDesc.Add(row);
}
else if (lolDataList.Any(u => u.compAtt.id == 85) && adc == false)
{
var temp = lolDataList.Where(a => a.compAtt.id == 85).First();
db.userGameDesc.Remove(lolDataList.Where(a => a.compAtt.id == 85).First());
lolDataList.Remove(temp);
}
if (usrGameLol == null && sup)
{
userGameDescs row = new userGameDescs();
row.compAtt = db.compAtt.Find(86);
row.userGame = userLol;
db.userGameDesc.Add(row);
}
else if (lolDataList.Any(u => u.compAtt.id == 86) == false && sup == true)
{
userGameDescs row = new userGameDescs();
row.compAtt = db.compAtt.Find(86);
row.userGame = usrGameLol;
db.userGameDesc.Add(row);
}
else if (lolDataList.Any(u => u.compAtt.id == 86) && sup == false)
{
var temp = lolDataList.Where(a => a.compAtt.id == 86).First();
db.userGameDesc.Remove(lolDataList.Where(a => a.compAtt.id == 86).First());
lolDataList.Remove(temp);
}
if (usrGameLol == null)///sadasdas
{
userGameDescs row = new userGameDescs();
row.compAtt = db.compAtt.Find(int.Parse(ranklol));
row.userGame = userLol;
db.userGameDesc.Add(row);
}
else if (lolDataList.Where(u => u.compAtt.gameComponent.id == 3).First().compAtt.id != int.Parse(ranklol))
{
lolDataList.Where(u => u.compAtt.gameComponent.id == 3).First().compAtt = db.compAtt.Find(int.Parse(ranklol));
db.Entry(lolDataList.Where(u => u.compAtt.gameComponent.id == 3).First()).State = EntityState.Modified;
}
}
if (cs == false && usrGameCs != null)//Cs verisi var ve tiki kaldırılmış tüm cs verilerini siler.
{
foreach (var item in csDataList)
{
db.userGameDesc.Remove(item);
}
db.userGame.Remove(usrGameCs);
}
else if (cs == true)//Cs verisi (tik) girmiş
{
if (usrGameCs != null)
{
if (usrGameCs.time != csHours) //Önceden olan cs verisi saat kontrolü ####HATA
{
usrGameCs.time = csHours;
db.Entry(usrGameCs).State = EntityState.Modified;
}
if (usrGameCs.gameConnectID != gameIDcs)
{
usrGameCs.gameConnectID = gameIDcs;
db.Entry(usrGameCs).State = EntityState.Modified;
}
if (usrGameCs.gameNickName != gameNickcs)
{
usrGameCs.gameNickName = gameNickcs;
db.Entry(usrGameCs).State = EntityState.Modified;
}
}
if (usrGameCs == null && awp == true) //Tik işaretli ama veri ilk defa girilecek
{
userGameDescs row = new userGameDescs();
row.compAtt = db.compAtt.Find(105);
row.userGame = userCs;
db.userGameDesc.Add(row);
}
else if (csDataList.Any(u => u.compAtt.id == 105) == false && awp == true)//Tik işaretlendiğinde değiştirme işlemi
{
userGameDescs row = new userGameDescs();
row.compAtt = db.compAtt.Find(105);
row.userGame = usrGameCs;
db.userGameDesc.Add(row);
}
else if (csDataList.Any(u => u.compAtt.id == 105) && awp == false) //Tik kaldırdığında değiştirme işlemi
{
var temp = csDataList.Where(a => a.compAtt.id == 105).First();
db.userGameDesc.Remove(csDataList.Where(a => a.compAtt.id == 105).First());
csDataList.Remove(temp);
}
if (usrGameCs == null && lurker == true)
{
userGameDescs row = new userGameDescs();
row.compAtt = db.compAtt.Find(106);
row.userGame = userCs;
db.userGameDesc.Add(row);
}
else if (csDataList.Any(u => u.compAtt.id == 106) == false && lurker == true)
{
userGameDescs row = new userGameDescs();
row.compAtt = db.compAtt.Find(106);
row.userGame = usrGameCs;
db.userGameDesc.Add(row);
}
else if (csDataList.Any(u => u.compAtt.id == 106) && lurker == false)
{
var temp = csDataList.Where(a => a.compAtt.id == 106).First();
db.userGameDesc.Remove(csDataList.Where(a => a.compAtt.id == 106).First());
csDataList.Remove(temp);
}
if (usrGameCs == null && rifle == true)
{
userGameDescs row = new userGameDescs();
row.compAtt = db.compAtt.Find(107);
row.userGame = userCs;
db.userGameDesc.Add(row);
}
else if (csDataList.Any(u => u.compAtt.id == 107) == false && rifle == true)
{
userGameDescs row = new userGameDescs();
row.compAtt = db.compAtt.Find(107);
row.userGame = usrGameCs;
db.userGameDesc.Add(row);
}
else if (csDataList.Any(u => u.compAtt.id == 107) && rifle == false)
{
var temp = csDataList.Where(a => a.compAtt.id == 107).First();
db.userGameDesc.Remove(csDataList.Where(a => a.compAtt.id == 107).First());
csDataList.Remove(temp);
}
if (usrGameCs == null && igl == true)
{
userGameDescs row = new userGameDescs();
row.compAtt = db.compAtt.Find(108);
row.userGame = userCs;
db.userGameDesc.Add(row);
}
else if (csDataList.Any(u => u.compAtt.id == 108) == false && igl == true)
{
userGameDescs row = new userGameDescs();
row.compAtt = db.compAtt.Find(108);
row.userGame = usrGameCs;
db.userGameDesc.Add(row);
}
else if (csDataList.Any(u => u.compAtt.id == 108) && igl == false)
{
var temp = csDataList.Where(a => a.compAtt.id == 108).First();
db.userGameDesc.Remove(csDataList.Where(a => a.compAtt.id == 108).First());
csDataList.Remove(temp);
}
if (usrGameCs == null && supporter == true)
{
userGameDescs row = new userGameDescs();
row.compAtt = db.compAtt.Find(109);
row.userGame = userCs;
db.userGameDesc.Add(row);
}
else if (csDataList.Any(u => u.compAtt.id == 109) == false && supporter == true)
{
userGameDescs row = new userGameDescs();
row.compAtt = db.compAtt.Find(109);
row.userGame = usrGameCs;
db.userGameDesc.Add(row);
}
else if (csDataList.Any(u => u.compAtt.id == 109) && supporter == false)
{
var temp = csDataList.Where(a => a.compAtt.id == 109).First();
db.userGameDesc.Remove(csDataList.Where(a => a.compAtt.id == 109).First());
csDataList.Remove(temp);
}
if (usrGameCs == null && frag == true)
{
userGameDescs row = new userGameDescs();
row.compAtt = db.compAtt.Find(110);
row.userGame = userCs;
db.userGameDesc.Add(row);
}
else if (csDataList.Any(u => u.compAtt.id == 110) == false && frag == true)
{
userGameDescs row = new userGameDescs();
row.compAtt = db.compAtt.Find(109);
row.userGame = usrGameCs;
db.userGameDesc.Add(row);
}
else if (csDataList.Any(u => u.compAtt.id == 110) && frag == false)
{
var temp = csDataList.Where(a => a.compAtt.id == 110).First();
db.userGameDesc.Remove(csDataList.Where(a => a.compAtt.id == 110).First());
csDataList.Remove(temp);
}
if (usrGameCs == null)
{
userGameDescs row = new userGameDescs();
row.compAtt = db.compAtt.Find(int.Parse(rankcs));
row.userGame = userCs;
db.userGameDesc.Add(row);
}
else if (csDataList.Where(u => u.compAtt.gameComponent.id == 5).First().compAtt.id != int.Parse(rankcs))
{
csDataList.Where(u => u.compAtt.gameComponent.id == 5).First().compAtt = db.compAtt.Find(int.Parse(rankcs));
db.Entry(csDataList.Where(u => u.compAtt.gameComponent.id == 5).First()).State = EntityState.Modified;
}
}
usr.dateOfBirth = users.dateOfBirth;;
usr.headset = users.headset;;
usr.mic = users.mic;
usr.password = users.password;
usr.username = users.username;
if (usr.userGame.Any(u => u.game.id == 5) == false && fort) // fortnite yok ama işaretlemiş - fort ekle
{
userGames usrGame = new userGames();
usrGame.game = db.game.Find(5);
usrGame.user = usr;
db.userGame.Add(usrGame);
}
else if (usr.userGame.Any(u => u.game.id == 5) == true && fort == false)// fortnite var ama işaretlememiş - fort sil
{
userGames temp = usr.userGame.Where(a => a.game.id == 5).First();
db.userGame.Remove(temp);
}
if (usr.userGame.Any(u => u.game.id == 3) == false && pubg)// pubg yok ama işaretlemiş - pubg ekle
{
userGames usrGame = new userGames();
usrGame.game = db.game.Find(3);
usrGame.user = usr;
db.userGame.Add(usrGame);
}
else if (usr.userGame.Any(u => u.game.id == 3) == true && pubg == false)// pubg var ama işaretlememiş - pubg sil
{
userGames temp = usr.userGame.Where(a => a.game.id == 3).First();
db.userGame.Remove(temp);
}
if (usr.userGame.Any(u => u.game.id == 4) == false && rocket)// rocket yok ama işaretlemiş - rocket ekle
{
userGames usrGame = new userGames();
usrGame.game = db.game.Find(4);
usrGame.user = usr;
db.userGame.Add(usrGame);
}
else if (usr.userGame.Any(u => u.game.id == 4) == true && rocket == false)// rocket var ama işaretlememiş - rocket sil
{
userGames temp = usr.userGame.Where(a => a.game.id == 4).First();
db.userGame.Remove(temp);
}
db.Entry(usr).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(users));
}
public ActionResult Create(FormCollection fc)
{
//if (fc["registerPage"] == "1")
//{
// if (((fc["usernameK"]).ToString()).Count() > 4)
// {
// var a = fc["usernameK"];
// var b = fc["passK"];
// var c = fc["emailK"];
// DateTime dt = new DateTime(2000, 01, 01);
// users user = new users();
// user.username = a;
// user.password = b;
// user.dateOfBirth = dt;
// user.role = db.role.Where(u => u.id == 3).FirstOrDefault();
// db.user.Add(user);
// db.SaveChanges();
// return RedirectToAction("Login");
// }
//}
//else
//{
//user table data
string usrname = fc["username"];
string psw = fc["password"];
var date1 = fc["date"];
bool mic = fc["mic"] == "on" ? true : false;
bool hs = fc["headset"] == "on" ? true : false;
//userGame table data
bool lol = fc["League"] == "on" ? true : false;
bool cs = fc["Counter"] == "on" ? true : false;
bool pubg = fc["PlayerUnknown's"] == "on" ? true : false;
bool rocket = fc["Rocket"] == "on" ? true : false;
bool fort = fc["Fortnite"] == "on" ? true : false;
int lolHours = int.Parse(fc["lolHours"]);
int csHours = int.Parse(fc["csHours"]);
//userGameDesc table data
var rankcs = fc["rankCs"];
var ranklol = fc["rankLol"];
bool awp = fc["AWP"] == "on" ? true : false; //CS ROLES
bool lurker = fc["Lurker"] == "on" ? true : false;
bool rifle = fc["Rifler"] == "on" ? true : false;
bool igl = fc["IGL"] == "on" ? true : false;
bool supporter = fc["Supporter"] == "on" ? true : false;
bool frag = fc["Fragger"] == "on" ? true : false;
bool top = fc["Top"] == "on" ? true : false; //LOL ROLES
bool mid = fc["Mid"] == "on" ? true : false;
bool jung = fc["Jungle"] == "on" ? true : false;
bool adc = fc["Adc"] == "on" ? true : false;
bool sup = fc["Support"] == "on" ? true : false;
string gameIDcs = fc["gameConnectIDcs"];
string gameNickcs = fc["gameNickNamecs"];
string gameNicklol = fc["gameNickNamelol"];
DateTime date = new DateTime();
date = Convert.ToDateTime(date1);
users usr = new users();
userGames usrGameLol = new userGames();
userGames usrGameCs = new userGames();
userGames usrGameFort = new userGames();
userGames usrGamePubg = new userGames();
userGames usrGameRocket = new userGames();
userGameDescs topData = new userGameDescs();
userGameDescs midData = new userGameDescs();
userGameDescs jungData = new userGameDescs();
userGameDescs adcData = new userGameDescs();
userGameDescs supData = new userGameDescs();
userGameDescs lolRankData = new userGameDescs();
userGameDescs awpData = new userGameDescs();
userGameDescs lurkerData = new userGameDescs();
userGameDescs rifleData = new userGameDescs();
userGameDescs iglData = new userGameDescs();
userGameDescs supporterData = new userGameDescs();
userGameDescs fragData = new userGameDescs();
userGameDescs csRankData = new userGameDescs();
userGameDescs usrGameDescCs = new userGameDescs();
List <userGameDescs> userGameDescListLol = new List <userGameDescs>();
List <userGameDescs> userGameDescListCs = new List <userGameDescs>();
List <userGames> userGameList = new List <userGames>();
if (lol)
{
usrGameLol.game = db.game.Find(1);
usrGameLol.time = lolHours;
usrGameLol.gameNickName = gameNicklol;
lolRankData.compAtt = db.compAtt.Find(int.Parse(ranklol));
userGameDescListLol.Add(lolRankData);
if (top)
{
topData.compAtt = db.compAtt.Find(82);
userGameDescListLol.Add(topData);
}
if (jung)
{
jungData.compAtt = db.compAtt.Find(84);
userGameDescListLol.Add(jungData);
}
if (mid)
{
midData.compAtt = db.compAtt.Find(83);
//var a2 = midData;
userGameDescListLol.Add(midData);
}
if (adc)
{
adcData.compAtt = db.compAtt.Find(85);
userGameDescListLol.Add(adcData);
}
if (sup)
{
supData.compAtt = db.compAtt.Find(86);
userGameDescListLol.Add(supData);
}
usrGameLol.userGameDesc = userGameDescListLol;
userGameList.Add(usrGameLol);
}
if (cs)
{
usrGameCs.game = db.game.Find(2);
usrGameCs.time = csHours;
usrGameCs.gameConnectID = gameIDcs;
usrGameCs.gameNickName = gameNickcs;
csRankData.compAtt = db.compAtt.Find(int.Parse(rankcs));
userGameDescListCs.Add(csRankData);
if (awp)
{
awpData.compAtt = db.compAtt.Find(105);
userGameDescListCs.Add(awpData);
}
if (lurker)
{
lurkerData.compAtt = db.compAtt.Find(106);
userGameDescListCs.Add(lurkerData);
}
if (rifle)
{
rifleData.compAtt = db.compAtt.Find(107);
userGameDescListCs.Add(rifleData);
}
if (igl)
{
iglData.compAtt = db.compAtt.Find(108);
userGameDescListCs.Add(iglData);
}
if (supporter)
{
supporterData.compAtt = db.compAtt.Find(109);
userGameDescListCs.Add(supporterData);
}
if (frag)
{
fragData.compAtt = db.compAtt.Find(110);
userGameDescListCs.Add(fragData);
}
usrGameCs.userGameDesc = userGameDescListCs;
userGameList.Add(usrGameCs);
}
if (fort)
{
usrGameFort.game = db.game.Find(5);
userGameList.Add(usrGameFort);
}
if (pubg)
{
usrGamePubg.game = db.game.Find(3);
userGameList.Add(usrGamePubg);
}
if (rocket)
{
usrGameRocket.game = db.game.Find(4);
userGameList.Add(usrGameRocket);
}
usr.username = usrname; //User table data
usr.password = psw;
usr.dateOfBirth = date;
usr.role = db.role.Where(u => u.id == 3).FirstOrDefault();
usr.mic = mic;
usr.headset = hs;
usr.search = true;
usr.userGame = userGameList;
db.user.Add(usr);
db.SaveChanges();
return(RedirectToAction("Index", "users"));
//}
return(RedirectToAction("Login"));
}
