//Game Information Specification
private void GameInfo_Select(int Game_ID)
{
Games_Arena_DB_Context dbContext = new Games_Arena_DB_Context();
Game game = dbContext.Games.FirstOrDefault(x => x.Game_ID == Game_ID);
if (game != null)
{
txtGameFullName.Text = game.Game_Full_Name;
txtGameShortName.Text = game.Game_Short_Name;
txtGameCompany.Text = game.Company;
dateRelease.Value = Convert.ToDateTime(game.Release_Date).ToString("yyyy-MM-dd");
dateUploaded.Value = Convert.ToDateTime(game.Upload_Date).ToString("yyyy-MM-dd");
txtGameMinSpecID.Text = game.Min_Spc_ID.ToString();
txtGameRecSpecID.Text = game.Rec_Spc.Specification_ID.ToString();
txtGamePrimaryComment.Text = game.Primary_Comment;
txtGameWarning.Text = game.Warnings;
txtGameComment1.Text = game.Developer_Comment_1;
txtGameComment2.Text = game.Developer_Comment_2;
string[] gamesTypes = game.Game_Type.Split(",".ToCharArray().FirstOrDefault());
SettingRepeaterControl(gamesTypes);
ErrorMessageGameInfo("", false);
}
else
{
ErrorMessageGameInfo("ID = " + Game_ID + " Does not Exsist !", true);
}
}
protected void btnImgUpdate_Click(object sender, EventArgs e)
{
int ID = 0;
if (int.TryParse(txtGameID.Text, out ID))
{
Games_Arena_DB_Context dbContext = new Games_Arena_DB_Context();
StringBuilder errorMessage = new StringBuilder();
string message;
Game_Images game_Images = null;
try
{
game_Images = dbContext.Game_Images.FirstOrDefault(x => x.Game_ID == ID);
if (ValidateFileUpload(fu_Game_Images_1.PostedFile, out message))
{
game_Images.Large_Image_1 = ConvertImageToByte(fu_Game_Images_1.PostedFile);
}
errorMessage.Append(message);
if (ValidateFileUpload(fu_Game_Images_2.PostedFile, out message))
{
game_Images.Large_Image_2 = ConvertImageToByte(fu_Game_Images_2.PostedFile);
}
errorMessage.Append(message);
if (ValidateFileUpload(fu_Game_Images_3.PostedFile, out message))
{
game_Images.Large_Image_3 = ConvertImageToByte(fu_Game_Images_3.PostedFile);
}
errorMessage.Append(message);
if (ValidateFileUpload(fu_Game_Images_4.PostedFile, out message))
{
game_Images.Large_Image_4 = ConvertImageToByte(fu_Game_Images_4.PostedFile);
}
errorMessage.Append(message);
if (ValidateFileUpload(fu_Game_Images_5.PostedFile, out message))
{
game_Images.Small_Image = ConvertImageToByte(fu_Game_Images_5.PostedFile);
}
errorMessage.Append(message);
dbContext.SaveChanges();
if (errorMessage.Length > 10)
{
ErrorMessageImageUploads(errorMessage.ToString(), true);
}
else
{
ErrorMessageImageUploads("", false);
}
GameImages_Select(ID);
}
catch (Exception ex)
{
ErrorMessageImageUploads(ex.Message, true);
}
}
else
{
ErrorMessageImageUploads("ID = " + txtGameID.Text + " Does not Exsist !", true);
}
}
protected void btnCAADelete_Click(object sender, EventArgs e)
{
Games_Arena_DB_Context dbContext = new Games_Arena_DB_Context();
User user = dbContext.Users.FirstOrDefault(x => x.Email_Address == txtCAEmail.Text);
if (user != null)
{
dbContext.Users.Remove(user);
dbContext.SaveChanges();
ErrorMessageCreateAccount(user.Email_Address + " has Deleted", true);
}
else
{
ErrorMessageCreateAccount("No User is Deleted", true);
}
}
private void GameInfo_InsertUpdateDelete(int Game_ID, Operation operation)
{
Games_Arena_DB_Context dbContext = new Games_Arena_DB_Context();
Game game = new Game();
try
{
if (operation.ToString() == "Update" || operation.ToString() == "Delete")
{
game = dbContext.Games.FirstOrDefault(x => x.Game_ID == Game_ID);
}
if (operation.ToString() == "Update" || operation.ToString() == "Insert")
{
game.Game_Full_Name = txtGameFullName.Text;
game.Game_Short_Name = txtGameShortName.Text;
game.Company = txtGameCompany.Text;
game.Release_Date = Convert.ToDateTime(dateRelease.Value);
game.Upload_Date = DateTime.Now;
game.Min_Spc_ID = Convert.ToInt32(txtGameMinSpecID.Text);
game.Rec_Spc_ID = Convert.ToInt32(txtGameRecSpecID.Text);
game.Primary_Comment = txtGamePrimaryComment.Text;
game.Warnings = txtGameWarning.Text;
game.Developer_Comment_1 = txtGameComment1.Text;
game.Developer_Comment_2 = txtGameComment2.Text;
game.Game_Type = ConvertListOfPagestoString(rptrPages.Items);
}
if (operation.ToString() == "Insert")
{
dbContext.Games.Add(game);
dbContext.SaveChanges();
txtGameID.Text = dbContext.Games.OrderByDescending(x => x.Game_ID).Select(x => x.Game_ID).FirstOrDefault().ToString();
}
else if (operation.ToString() == "Delete")
{
dbContext.Games.Remove(game);
}
dbContext.SaveChanges();
ErrorMessageGameInfo("", false);
}
catch (Exception ex)
{
ErrorMessageGameInfo(ex.Message, true);
}
}
//Create New Account
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string currentuser = CurrentUserEmail();
Games_Arena_DB_Context dbContext = new Games_Arena_DB_Context();
User user = dbContext.Users.FirstOrDefault(x => x.Email_Address == currentuser);
if (currentuser == "Administrator")
{
showHideControls(true);
}
else
{
showHideControls(false);
}
AssigningValuesToControls(user);
}
}
private void TechSpc_Select(int Game_ID)
{
Games_Arena_DB_Context dbContext = new Games_Arena_DB_Context();
Specifications_Technical Tech_spc = dbContext.Specifications_Technical.FirstOrDefault(x => x.Game_ID == Game_ID);
if (Tech_spc != null)
{
txtTSAudioLanguage.Text = Tech_spc.Audio_Language;
txtTSGameSize.Text = Tech_spc.Game_Download_Size;
txtTSGameVersion.Text = Tech_spc.Game_Version;
txtTSInterfaceLanguage.Text = Tech_spc.Interface_Language;
txtTSMDSSUM.Text = Tech_spc.MDSSUM;
txtTSUploader.Text = Tech_spc.Uploader;
ErrorMessageTechSpc("", false);
}
else
{
ErrorMessageTechSpc("ID = " + Game_ID + " Does not Exsist !", true);
}
}
protected void btnCAAccount_Click(object sender, EventArgs e)
{
Games_Arena_DB_Context dbContext = new Games_Arena_DB_Context();
User user = dbContext.Users.FirstOrDefault(x => x.Email_Address == txtCAEmail.Text);
if (user == null)
{
User newUser = new User();
if (RecivingValuesFromControls(newUser))
{
newUser.Email_Address = txtCAEmail.Text;
dbContext.Users.Add(newUser);
dbContext.SaveChanges();
}
}
else
{
ErrorMessageCreateAccount("Email Address already Exsist, Please try another", true);
}
}
protected void btnTechSpcUpdate_Click(object sender, EventArgs e)
{
int ID = 0;
if (int.TryParse(txtGameID.Text, out ID))
{
Games_Arena_DB_Context dbContext = new Games_Arena_DB_Context();
Specifications_Technical Tech_spc = null;
try
{
//File Size must be Less than 5 GB
if (fuGameFileName.FileContent.Length < 5368709120)
{
Tech_spc = dbContext.Specifications_Technical.FirstOrDefault(x => x.Game_ID == ID);
if (fuGameFileName.HasFile)
{
string extension = Path.GetExtension(fuGameFileName.FileName);
Tech_spc.Game_Download_Size = ComputeFileSize(fuGameFileName.FileContent.Length);
fuGameFileName.SaveAs(Server.MapPath("~/Games/" + txtGameID.Text + " - " + txtGameShortName.Text + extension));
Tech_spc.Game_File_Name = txtGameID.Text + " - " + txtGameShortName.Text + extension;
}
Tech_spc.Audio_Language = txtTSAudioLanguage.Text;
Tech_spc.Game_Version = txtTSGameVersion.Text;
Tech_spc.Interface_Language = txtTSInterfaceLanguage.Text;
Tech_spc.MDSSUM = txtTSMDSSUM.Text;
Tech_spc.Uploader = txtTSUploader.Text;
dbContext.SaveChanges();
TechSpc_Select(ID);
ErrorMessageTechSpc("", false);
}
}
catch (Exception ex)
{
ErrorMessageTechSpc(ex.Message, true);
}
}
else
{
ErrorMessageTechSpc("ID = " + txtGameID.Text + " Does not Exsist !", true);
}
}
private void MinSpc_Select(int Spc_ID)
{
Games_Arena_DB_Context dbContext = new Games_Arena_DB_Context();
Specification spc = dbContext.Specifications.FirstOrDefault(x => x.Specification_ID == Spc_ID);
if (spc != null)
{
txtMinRecSpcDirectX.Text = spc.DirectX;
txtMinRecSpcGraphics.Text = spc.Graphics;
txtMinRecSpcMemory.Text = spc.Memory;
txtMinRecSpcOS.Text = spc.OS;
txtMinRecSpcProcessor.Text = spc.Processor;
txtMinRecSpcSoundCard.Text = spc.Sound_Card;
txtMinRecSpcStorage.Text = spc.Storage;
ErrorMessageMinRecSpc("", false);
}
else
{
ErrorMessageMinRecSpc("ID = " + Spc_ID + " Does not Exsist !", true);
}
}
private void MinSpc_InsertUpdateDelete(int Spc_ID, Operation operation)
{
try
{
Games_Arena_DB_Context dbContext = new Games_Arena_DB_Context();
Specification spc = null;
if (operation.ToString() == "Update" || operation.ToString() == "Delete")
{
spc = dbContext.Specifications.FirstOrDefault(x => x.Specification_ID == Spc_ID);
}
else if (operation.ToString() == "Insert")
{
spc = new Specification();
}
if (operation.ToString() == "Update" || operation.ToString() == "Insert")
{
spc.DirectX = txtMinRecSpcDirectX.Text;
spc.Graphics = txtMinRecSpcGraphics.Text;
spc.Memory = txtMinRecSpcMemory.Text;
spc.OS = txtMinRecSpcOS.Text;
spc.Processor = txtMinRecSpcProcessor.Text;
spc.Sound_Card = txtMinRecSpcSoundCard.Text;
spc.Storage = txtMinRecSpcStorage.Text;
}
if (operation.ToString() == "Insert")
{
dbContext.Specifications.Add(spc);
}
else if (operation.ToString() == "Delete")
{
dbContext.Specifications.Remove(spc);
}
dbContext.SaveChanges();
ErrorMessageMinRecSpc("", false);
}
catch (Exception ex)
{
ErrorMessageMinRecSpc(ex.Message, true);
}
}
private void GameImages_Select(int Game_ID)
{
Games_Arena_DB_Context dbContext = new Games_Arena_DB_Context();
Game_Images game_Images = dbContext.Game_Images.FirstOrDefault(x => x.Game_ID == Game_ID);
if (game_Images != null)
{
Image1.ImageUrl = "";
Image2.ImageUrl = "";
Image3.ImageUrl = "";
Image4.ImageUrl = "";
Image5.ImageUrl = "";
if (game_Images.Large_Image_1 != null)
{
Image1.ImageUrl = ConvertBytesToImage(game_Images.Large_Image_1);
}
if (game_Images.Large_Image_2 != null)
{
Image2.ImageUrl = ConvertBytesToImage(game_Images.Large_Image_2);
}
if (game_Images.Large_Image_3 != null)
{
Image3.ImageUrl = ConvertBytesToImage(game_Images.Large_Image_3);
}
if (game_Images.Large_Image_4 != null)
{
Image4.ImageUrl = ConvertBytesToImage(game_Images.Large_Image_4);
}
if (game_Images.Small_Image != null)
{
Image5.ImageUrl = ConvertBytesToImage(game_Images.Small_Image);
}
ErrorMessageImageUploads("", false);
}
else
{
ErrorMessageImageUploads("ID = " + Game_ID + " Does not Exsist !", true);
}
}
protected void btnCAAUpdateAccount_Click(object sender, EventArgs e)
{
Games_Arena_DB_Context dbContext = new Games_Arena_DB_Context();
string currentuser = CurrentUserEmail();
User user = null;
if (currentuser == "Administrator")
{
user = dbContext.Users.FirstOrDefault(x => x.Email_Address == txtCAEmail.Text);
}
else
{
user = dbContext.Users.FirstOrDefault(x => x.Email_Address == currentuser);
}
if (user != null)
{
if (RecivingValuesFromControls(user))
{
dbContext.SaveChanges();
}
}
}
protected void btnSearchID_Click(object sender, EventArgs e)
{
ErrorMessageCreateAccount("", false);
int id = 0;
if (int.TryParse(txtUserID.Text, out id))
{
Games_Arena_DB_Context dbContext = new Games_Arena_DB_Context();
User user = dbContext.Users.FirstOrDefault(x => x.User_ID == id);
if (user != null)
{
AssigningValuesToControls(user);
}
else
{
ErrorMessageCreateAccount(txtUserID.Text + " ID not Found", true);
}
}
else
{
ErrorMessageCreateAccount(txtUserID.Text + " is not Valid", true);
}
}
