public ActionResult Create(InscriptionModel inscriptionModel)
{
try
{
if (ModelState.IsValid)
{
string connectionString = Configuration["ConnectionStrings:DefaultConnection"];
using (SqlConnection connection = new SqlConnection(connectionString))
{
string Salt = Securite.GetSalt();
string EncryptedPassword = Securite.GenerateSHA256String(inscriptionModel.Password + Salt);
EncryptedPassword += ":" + Salt;
string sql = $"Insert Into dbo.Utilisateur (TypeUtilisateurID, Prenom, Nom, Inscription, Courriel, MotDePasse, Username) Values ('1', '{inscriptionModel.Prenom}','{inscriptionModel.Nom}',GETDATE(),'{inscriptionModel.Courriel}','{EncryptedPassword}','{inscriptionModel.Username}')";
using (SqlCommand command = new SqlCommand(sql, connection))
{
command.CommandType = CommandType.Text;
connection.Open();
command.ExecuteNonQuery();
connection.Close();
}
return(Redirect("/Home"));
}
}
else
{
return(RedirectToAction(nameof(Index)));
}
}
catch
{
return(View());
}
}
public async Task <ActionResult <InscriptionModel> > Post(InscriptionModel model)
{
try
{
var inscription = _mapper.Map <Inscriptions>(model);
_uow.GetRepository <Inscriptions>().Add(inscription);
await _uow.CommitAsync();
if (inscription.Id != 0)
{
var url = _linkGenerator.GetPathByAction(HttpContext,
"Get",
values: new { id = inscription.Id });
return(Created(url, _mapper.Map <InscriptionModel>(inscription)));
}
else
{
_logger.LogWarning($"Erreur lors de l'ajout de l'inscription: {inscription.Guid}");
return(BadRequest("Erreur lors de l'ajout de l'inscription."));
}
}
catch (Exception ex)
{
_logger.LogError($"Error inscription-post-one : {ex.Message}");
return(StatusCode(StatusCodes.Status500InternalServerError, ex.Message));
}
}
private void Init()
{
InscriptionPageMode ip = new InscriptionPageMode();
ip._inscriptionPageId = 1;
ip._inscriptionPageName = "法穿";
ip._inscriptionModelList = new List <InscriptionModel>();
for (int i = 0; i < 10; i++)
{
InscriptionModel im = new InscriptionModel();
im._inscriptionColor = InscriptionColor.GREEN;
im._inscriptionID = 2;
im._inscriptionPosId = i + 1;
ip._inscriptionModelList.Add(im);
}
for (int i = 0; i < 10; i++)
{
InscriptionModel im = new InscriptionModel();
im._inscriptionColor = InscriptionColor.RED;
im._inscriptionID = 1;
im._inscriptionPosId = i + 1;
ip._inscriptionModelList.Add(im);
}
for (int i = 0; i < 10; i++)
{
InscriptionModel im = new InscriptionModel();
im._inscriptionColor = InscriptionColor.BLUE;
im._inscriptionID = 8;
im._inscriptionPosId = i + 1;
ip._inscriptionModelList.Add(im);
}
PlayerInscriptionPageMessage.InscriptionPageList.Add(1, ip);
}
public async Task <IActionResult> postInscription([FromBody] InscriptionModel inscription)
{
if (ModelState.IsValid)
{
var result = await service.postInscription(inscription);
return(Ok(Tuple.Create(result)));
}
return(BadRequest("Algo salio mal en la peticion"));
}
public ActionResult Inscription(InscriptionModel model)
{
if (!ModelState.IsValid)
{
return(View(model));
}
InscriptionRepository IR = new InscriptionRepository();
IR.Add(model);
return(RedirectToAction("Index"));
}
public Adresse MapInscriptionModelToAdresse(InscriptionModel o)
{
Adresse a = new Adresse
{
Boite = o.Boite,
CP = o.CP,
Numero = o.Numero,
Rue = o.Rue,
Ville = o.Ville,
IdPersonne = 0,
IdAdresse = 0
};
return(a);
}
public Personne MapInscriptionModelToPersonne(InscriptionModel o)
{
Personne p = new Personne
{
Nom = o.Nom,
Prenom = o.Prenom,
Age = o.Age,
Sexe = o.Sexe,
Mail = o.Mail,
Pseudo = o.Pseudo,
IdPersonne = 0
};
p.Hash = HashGenerator();
p.MotDePasse = MD5Password(o.MotDePasse, p.Hash);
return(p);
}
public async Task <bool> postInscription(InscriptionModel inscription)
{
var validate = await repository.GetInscription(inscription.CourseId, inscription.UserId);
if (validate != null)
{
return(false);
}
else
{
inscription.Id = null;
inscription.State = false;
inscription.Status = true;
inscription.UpdateDate = DateTime.Now;
inscription.CreateDate = DateTime.Now;
var inscriptionEntity = mapper.Map <InscriptionEntity>(inscription);
repository.postInscription(inscriptionEntity);
await repository.SaveChangesAsync();
return(true);
}
}
public ActionResult Index(InscriptionModel model)
{
if (model.mdp != model.mdpbis)
{
return(RedirectToAction("Index"));
}
Dbo.Account acc = new Dbo.Account()
{
Email = model.email,
Firstname = model.firstname,
Lastname = model.name,
Login = model.username,
Password = model.mdp
};
if (!BusinessManagement.Registration.RegisterAccount(acc))
{
return(RedirectToAction("Index"));
}
return(RedirectToAction("OnAccountCreated"));
}
IEnumerator LoadData()
{
WWW www = new WWW("http://60.205.213.83:8080/Gamelol/" + LoadGameData.loginPlayerId.ToString() + ".xml");
try
{
while (!www.isDone)
{
yield return(www);
string text = System.Text.RegularExpressions.Regex.Replace(www.text, "^[^<]", "");
XmlDocument xmlDoc = new XmlDocument();
xmlDoc.LoadXml(text);
XmlNodeList baseMessageNodeList = xmlDoc.SelectSingleNode("PlayerMessage/BaseMessage").ChildNodes;
foreach (XmlElement xe in baseMessageNodeList)
{
if (xe.Name == "playerId")
{
PlayerBaseMessage.PlayerId = int.Parse(xe.InnerText);
}
else if (xe.Name == "playerName")
{
PlayerBaseMessage.PlayerName = xe.InnerText;
}
else if (xe.Name == "playerLevel")
{
PlayerBaseMessage.PlayerLevel = int.Parse(xe.InnerText);
}
else if (xe.Name == "playerExperence")
{
PlayerBaseMessage.CurrentExperence = int.Parse(xe.InnerText);
}
else if (xe.Name == "playerHeadImage")
{
PlayerBaseMessage.HeadImage = int.Parse(xe.InnerText);
}
else if (xe.Name == "playerGoldNumber")
{
PlayerBaseMessage.GoldNumbere = int.Parse(xe.InnerText);
}
else if (xe.Name == "playerDiamondsNumber")
{
PlayerBaseMessage.DiamondsNumber = int.Parse(xe.InnerText);
}
else if (xe.Name == "playerVolumeNumber")
{
PlayerBaseMessage.VolumeNumber = int.Parse(xe.InnerText);
}
else if (xe.Name == "playerInscriptionNumber")
{
PlayerBaseMessage.InscriptionNumber = int.Parse(xe.InnerText);
}
}
XmlNodeList inscriptionNodeList = xmlDoc.SelectSingleNode("PlayerMessage/InscriptionMessage").ChildNodes;
foreach (XmlElement xe in inscriptionNodeList)
{
XmlNodeList xn = xe.ChildNodes;
InscriptionMessage inscriptionMessage = new InscriptionMessage();
foreach (XmlNode node in xn)
{
if (node.Name == "inscriptionId")
{
inscriptionMessage.inscriptionId = int.Parse(node.InnerText);
}
else if (node.Name == "inscriptionNumber")
{
inscriptionMessage.inscriptionNumber = int.Parse(node.InnerText);
}
else if (node.Name == "inscriptionUseNumber")
{
inscriptionMessage.inscriptionUseNumber = int.Parse(node.InnerText);
}
}
PlayerInscriptionMessage.InscriptionList.Add(inscriptionMessage.inscriptionId, inscriptionMessage);
}
XmlNodeList inscriptionPageNodeList = xmlDoc.SelectSingleNode("PlayerMessage/InscriptionPageMessage").ChildNodes;
foreach (XmlElement xe in inscriptionPageNodeList)
{
XmlNodeList xn = xe.ChildNodes;
InscriptionPageMode inscriptionPageMode = new InscriptionPageMode();
inscriptionPageMode._inscriptionModelList = new List <InscriptionModel>();
//InscriptionModel inscriptionModel = new InscriptionModel();
foreach (XmlNode node in xn)
{
if (node.Name == "InscriptionPageId")
{
inscriptionPageMode._inscriptionPageId = int.Parse(node.InnerText);
}
else if (node.Name == "InscriptionPageName")
{
inscriptionPageMode._inscriptionPageName = node.InnerText;
}
else if (node.Name == "BlueInscription")
{
if (int.Parse(node.InnerText) != 0)
{
InscriptionModel inscriptionModel = new InscriptionModel();
int soitId = int.Parse(((XmlElement)node).GetAttribute("SoitId"));
inscriptionModel._inscriptionColor = InscriptionColor.BLUE;
inscriptionModel._inscriptionID = int.Parse(node.InnerText);
inscriptionModel._inscriptionPosId = soitId;
inscriptionPageMode._inscriptionModelList.Add(inscriptionModel);
}
}
else if (node.Name == "RedInscription")
{
if (int.Parse(node.InnerText) != 0)
{
InscriptionModel inscriptionModel = new InscriptionModel();
int soitId = int.Parse(((XmlElement)node).GetAttribute("SoitId"));
inscriptionModel._inscriptionColor = InscriptionColor.RED;
inscriptionModel._inscriptionID = int.Parse(node.InnerText);
inscriptionModel._inscriptionPosId = soitId;
inscriptionPageMode._inscriptionModelList.Add(inscriptionModel);
}
}
else if (node.Name == "GreenInscription")
{
if (int.Parse(node.InnerText) != 0)
{
InscriptionModel inscriptionModel = new InscriptionModel();
int soitId = int.Parse(((XmlElement)node).GetAttribute("SoitId"));
inscriptionModel._inscriptionColor = InscriptionColor.GREEN;
inscriptionModel._inscriptionID = int.Parse(node.InnerText);
inscriptionModel._inscriptionPosId = soitId;
inscriptionPageMode._inscriptionModelList.Add(inscriptionModel);
}
}
}
PlayerInscriptionPageMessage.InscriptionPageList.Add(inscriptionPageMode._inscriptionPageId, inscriptionPageMode);
}
LoginNetWork.Instance.socket.Close();
NetConnection.NetWorkScript a = NetConnection.NetWorkScript.Instance;
UnityEngine.SceneManagement.SceneManager.LoadScene("MainScene");
}
}
finally
{
www.Dispose();
}
}
IEnumerator opnen()
{
WWW www = new WWW("http://60.205.213.83:8080/Gamelol/1.xml");
try
{
while (!www.isDone)
{
yield return(www);
string text = System.Text.RegularExpressions.Regex.Replace(www.text, "^[^<]", "");
XmlDocument xmlDoc = new XmlDocument();
xmlDoc.LoadXml(text);
XmlNodeList baseMessageNodeList = xmlDoc.SelectSingleNode("PlayerMessage/BaseMessage").ChildNodes;
foreach (XmlElement xe in baseMessageNodeList)
{
if (xe.Name == "playerId")
{
PlayerBaseMessage.PlayerId = int.Parse(xe.InnerText);
}
else if (xe.Name == "playerName")
{
PlayerBaseMessage.PlayerName = xe.InnerText;
}
else if (xe.Name == "playerLevel")
{
PlayerBaseMessage.PlayerLevel = int.Parse(xe.InnerText);
}
else if (xe.Name == "playerExperence")
{
PlayerBaseMessage.CurrentExperence = int.Parse(xe.InnerText);
}
else if (xe.Name == "playerHeadImage")
{
PlayerBaseMessage.HeadImage = int.Parse(xe.InnerText);
}
else if (xe.Name == "playerGoldNumber")
{
PlayerBaseMessage.GoldNumbere = int.Parse(xe.InnerText);
}
else if (xe.Name == "playerDiamondsNumber")
{
PlayerBaseMessage.DiamondsNumber = int.Parse(xe.InnerText);
}
else if (xe.Name == "playerVolumeNumber")
{
PlayerBaseMessage.VolumeNumber = int.Parse(xe.InnerText);
}
else if (xe.Name == "playerInscriptionNumber")
{
PlayerBaseMessage.InscriptionNumber = int.Parse(xe.InnerText);
}
}
XmlNodeList inscriptionNodeList = xmlDoc.SelectSingleNode("PlayerMessage/InscriptionMessage").ChildNodes;
foreach (XmlElement xe in inscriptionNodeList)
{
XmlNodeList xn = xe.ChildNodes;
InscriptionMessage inscriptionMessage = new InscriptionMessage();
foreach (XmlNode node in xn)
{
if (node.Name == "inscriptionId")
{
inscriptionMessage.inscriptionId = int.Parse(node.InnerText);
}
else if (node.Name == "inscriptionNumber")
{
inscriptionMessage.inscriptionNumber = int.Parse(node.InnerText);
}
else if (node.Name == "inscriptionUseNumber")
{
inscriptionMessage.inscriptionUseNumber = int.Parse(node.InnerText);
}
}
PlayerInscriptionMessage.InscriptionList.Add(inscriptionMessage.inscriptionId, inscriptionMessage);
}
XmlNodeList inscriptionPageNodeList = xmlDoc.SelectSingleNode("PlayerMessage/InscriptionPageMessage").ChildNodes;
foreach (XmlElement xe in inscriptionPageNodeList)
{
XmlNodeList xn = xe.ChildNodes;
InscriptionPageMode inscriptionPageMode = new InscriptionPageMode();
inscriptionPageMode._inscriptionModelList = new List <InscriptionModel>();
foreach (XmlNode node in xn)
{
if (node.Name == "InscriptionPageId")
{
inscriptionPageMode._inscriptionPageId = int.Parse(node.InnerText);
}
else if (node.Name == "InscriptionPageName")
{
inscriptionPageMode._inscriptionPageName = node.InnerText;
}
else if (node.Name == "BlueInscription")
{
InscriptionModel inscriptionModel = new InscriptionModel();
int soitId = int.Parse(((XmlElement)node).GetAttribute("SoitId"));
inscriptionModel._inscriptionColor = InscriptionColor.BLUE;
inscriptionModel._inscriptionID = int.Parse(node.InnerText);
inscriptionModel._inscriptionPosId = soitId;
inscriptionPageMode._inscriptionModelList.Add(inscriptionModel);
}
else if (node.Name == "RedInscription")
{
InscriptionModel inscriptionModel = new InscriptionModel();
int soitId = int.Parse(((XmlElement)node).GetAttribute("SoitId"));
inscriptionModel._inscriptionColor = InscriptionColor.RED;
inscriptionModel._inscriptionID = int.Parse(node.InnerText);
inscriptionModel._inscriptionPosId = soitId;
inscriptionPageMode._inscriptionModelList.Add(inscriptionModel);
}
else if (node.Name == "GreenInscription")
{
InscriptionModel inscriptionModel = new InscriptionModel();
int soitId = int.Parse(((XmlElement)node).GetAttribute("SoitId"));
inscriptionModel._inscriptionColor = InscriptionColor.GREEN;
inscriptionModel._inscriptionID = int.Parse(node.InnerText);
inscriptionModel._inscriptionPosId = soitId;
inscriptionPageMode._inscriptionModelList.Add(inscriptionModel);
}
}
PlayerInscriptionPageMessage.InscriptionPageList.Add(inscriptionPageMode._inscriptionPageId, inscriptionPageMode);
}
foreach (KeyValuePair <int, InscriptionPageMode> item in PlayerInscriptionPageMessage.InscriptionPageList)
{
Debug.Log(item.Value._inscriptionPageName);
if (item.Key == 2)
{
break;
}
foreach (InscriptionModel ttt in item.Value._inscriptionModelList)
{
//Debug.Log(ttt._inscriptionID);
// Debug.Log(ttt._inscriptionPosId);
Debug.Log(ttt._inscriptionColor);
}
}
}
}
finally
{
www.Dispose();
}
}
