public void InsertUpdateCompagnie(Compagnie comp)
{
using (IDbCommand cmd = Connection.Connection.Instance.Con.CreateCommand())
{
if (comp.Id == 0)
{
cmd.CommandText = "INSERT INTO `easy_to_go`.`compagnie` (`noms`,`description`,`adresse`,`photo`,`rccm`)"
+ " VALUES (@noms,@description,@adresse,@photo,@rccm); " +
"UPDATE `easy_to_go`.`utilisateur` SET `description` = @noms WHERE `id` = @idUser; ";
SetParameter(cmd, "@idUser", DbType.Int32, 10, User.Instance.IdSession);
SetParameter(cmd, "@noms", DbType.String, 255, comp.Noms);
SetParameter(cmd, "@description", DbType.String, 255, comp.Description);
SetParameter(cmd, "@adresse", DbType.String, 255, comp.Adresse);
SetParameter(cmd, "@rccm", DbType.String, 35, comp.Rccm);
SetParameter(cmd, "@photo", DbType.Binary, int.MaxValue, comp.Photo);
}
else
{
cmd.CommandText = "UPDATE `easy_to_go`.`compagnie` SET `noms` = @noms, `description` = @description, "
+ "`adresse` = @adresse, `photo` = @photo, `rccm` = @rccm WHERE `id` = @id; " +
"UPDATE `easy_to_go`.`utilisateur` SET `description` = @noms WHERE `id` = @idUser; ";
SetParameter(cmd, "@idUser", DbType.Int32, 10, User.Instance.IdSession);
SetParameter(cmd, "@id", DbType.Int32, 10, comp.Id);
SetParameter(cmd, "@noms", DbType.String, 255, comp.Noms);
SetParameter(cmd, "@description", DbType.String, 255, comp.Description);
SetParameter(cmd, "@adresse", DbType.String, 255, comp.Adresse);
SetParameter(cmd, "@rccm", DbType.String, 35, comp.Rccm);
SetParameter(cmd, "@photo", DbType.Binary, int.MaxValue, comp.Photo);
}
cmd.ExecuteNonQuery();
}
}
public Compagnie GetCompagnie(string name = null)
{
Compagnie compagnie = null;
byte[] photo = null;
using (IDbCommand cmd = Connection.Connection.Instance.Con.CreateCommand())
{
if (name != null)
{
cmd.CommandText = "SELECT * FROM easy_to_go.compagnie WHERE `compagnie`.`noms` = @name; ";
SetParameter(cmd, "@name", DbType.String, 255, name);
using (IDataReader dr = cmd.ExecuteReader())
{
if (dr.Read())
{
compagnie = new Compagnie
{
Id = Convert.ToInt32(dr["id"]),
Adresse = dr["adresse"].ToString(),
Description = dr["description"].ToString(),
Noms = dr["noms"].ToString(),
Rccm = dr["rccm"].ToString(),
Photo = dr["photo"] == DBNull.Value ? photo : (byte[])dr["photo"]
};
}
}
}
else
{
throw new Exception("Ce profile n'existe pas. Veillez contacter l'adminisatrateur du sytème");
}
return(compagnie);
}
}
/// <summary>
/// Chargé en mémoire le fichier Rom spécifier par this._FileName
/// </summary>
/// <returns>Return true si le fichier est bien chargé</returns>
public bool Load()
{
if (File.Exists(this._FileName))
{
if (SnesRom.isValid(this._FileName)) //Verifie si le fichier Rom valide
//Variable de Verification pour determiner de quel type est la rom a charg
{
string CheckLow1 = Convertir.StringHexa_LittleEndian(ExtractData.AspireString("81DC", "81DD", this.FileName, true));
string CheckLow2 = Convertir.StringHexa_LittleEndian(ExtractData.AspireString("81DE", "81DF", this.FileName, true));
string CheckLow1b = Convertir.StringHexa_LittleEndian(ExtractData.AspireString("7FDC", "7FDD", this.FileName, true));
string CheckLow2b = Convertir.StringHexa_LittleEndian(ExtractData.AspireString("7FDE", "7FDF", this.FileName, true));
string CheckHigh1 = Convertir.StringHexa_LittleEndian(ExtractData.AspireString("101DC", "101DD", this.FileName, true));
string CheckHigh2 = Convertir.StringHexa_LittleEndian(ExtractData.AspireString("101DE", "101DF", this.FileName, true));
string CheckHigh1b = Convertir.StringHexa_LittleEndian(ExtractData.AspireString("FFDC", "FFDD", this.FileName, true));
string CheckHigh2b = Convertir.StringHexa_LittleEndian(ExtractData.AspireString("FFDE", "FFDF", this.FileName, true));
long ValCheckLowb = Convertir.HexaToDecimal(CheckLow1b) + Convertir.HexaToDecimal(CheckLow2b);
long ValCheckHigh = Convertir.HexaToDecimal(CheckHigh1) + Convertir.HexaToDecimal(CheckHigh2);
long ValCheckHighb = Convertir.HexaToDecimal(CheckHigh1b) + Convertir.HexaToDecimal(CheckHigh2b);
long ValCheckLow = Convertir.HexaToDecimal(CheckLow1) + Convertir.HexaToDecimal(CheckLow2);
//Extraire les informations sur la rom dependant du type de rom
if (ValCheckLow == 65535) //LowRom 1
{
this._RomType = RomType.LowRom_School_1;
this._RomName = ExtractData.AspireString("81C0", "81D4", this.FileName).TrimEnd(new char[] { ' ' });
this._PostitionName = (int)Convertir.HexaToDecimal("81C0");
this._InfoCart = (InformationCartouche)
Convertir.HexaToDecimal(
Convertir.StringHexa_LittleEndian(
ExtractData.AspireString("81D6", "81D6", this.FileName, true)));
this._RomSizeMB = (ROMSize)
Convertir.HexaToDecimal(
Convertir.StringHexa_LittleEndian(
ExtractData.AspireString("81D7", "81D7", this.FileName, true)));
this._RamSizeKB = (RAMSize)
Convertir.HexaToDecimal(
Convertir.StringHexa_LittleEndian(
ExtractData.AspireString("81D8", "81D8", this.FileName, true)));
this._Country = (Country)
Convertir.HexaToDecimal(
Convertir.StringHexa_LittleEndian(
ExtractData.AspireString("81D9", "81D9", this.FileName, true)));
this._Compagnie = (Compagnie)
Convertir.HexaToDecimal(
Convertir.StringHexa_LittleEndian(
ExtractData.AspireString("81DA", "81DA", this.FileName, true)));
this._Version = Convertir.StringHexa_LittleEndian(ExtractData.AspireString("81DB", "81DB", this.FileName, true));
this._CompChecksum = Convertir.StringHexa_LittleEndian(ExtractData.AspireString("81DC", "81DD", this.FileName, true));
this._Checksum = Convertir.StringHexa_LittleEndian(ExtractData.AspireString("81DE", "81DF", this.FileName, true));
this._NmiVblVector = Convertir.StringHexa_LittleEndian(ExtractData.AspireString("81EA", "81EB", this.FileName, true));
this._ResetVector = Convertir.StringHexa_LittleEndian(ExtractData.AspireString("81FC", "81FD", this.FileName, true));
}
else if (ValCheckLowb == 65535) //LowRom 2
{
this._RomType = RomType.LowRom_School_2;
this._RomName = ExtractData.AspireString("7FC0", "7FD4", this.FileName).TrimEnd(new char[] { ' ' });
this._PostitionName = (int)Convertir.HexaToDecimal("7FC0");
this._InfoCart = (InformationCartouche)
Convertir.HexaToDecimal(
Convertir.StringHexa_LittleEndian(
ExtractData.AspireString("7FD6", "7FD6", this.FileName, true)));
this._RomSizeMB = (ROMSize)
Convertir.HexaToDecimal(
Convertir.StringHexa_LittleEndian(
ExtractData.AspireString("7FD7", "7FD7", this.FileName, true)));
this._RamSizeKB = (RAMSize)
Convertir.HexaToDecimal(
Convertir.StringHexa_LittleEndian(
ExtractData.AspireString("7FD8", "7FD8", this.FileName, true)));
this._Country = (Country)
Convertir.HexaToDecimal(
Convertir.StringHexa_LittleEndian(
ExtractData.AspireString("7FD9", "7FD9", this.FileName, true)));
this._Compagnie = (Compagnie)
Convertir.HexaToDecimal(
Convertir.StringHexa_LittleEndian(
ExtractData.AspireString("7FDA", "7FDA", this.FileName, true)));
this._Version = Convertir.StringHexa_LittleEndian(ExtractData.AspireString("7FDB", "7FDB", this.FileName, true));
this._CompChecksum = Convertir.StringHexa_LittleEndian(ExtractData.AspireString("7FDC", "7FDD", this.FileName, true));
this._Checksum = Convertir.StringHexa_LittleEndian(ExtractData.AspireString("7FDE", "7FDF", this.FileName, true));
this._NmiVblVector = Convertir.StringHexa_LittleEndian(ExtractData.AspireString("7FEA", "7FEB", this.FileName, true));
this._ResetVector = Convertir.StringHexa_LittleEndian(ExtractData.AspireString("7FFC", "7FFD", this.FileName, true));
}
else if (ValCheckHigh == 65535) // HighRom
{
this._RomType = RomType.HighRom;
this._RomName = ExtractData.AspireString("101C0", "101D4", this.FileName).TrimEnd(new char[] { ' ' });
this._PostitionName = (int)Convertir.HexaToDecimal("101C0");
this._InfoCart = (InformationCartouche)
Convertir.HexaToDecimal(
Convertir.StringHexa_LittleEndian(
ExtractData.AspireString("101D6", "101D6", this.FileName, true)));
this._RomSizeMB = (ROMSize)
Convertir.HexaToDecimal(
Convertir.StringHexa_LittleEndian(
ExtractData.AspireString("101D7", "101D7", this.FileName, true)));
this._RamSizeKB = (RAMSize)
Convertir.HexaToDecimal(
Convertir.StringHexa_LittleEndian(
ExtractData.AspireString("101D8", "101D8", this.FileName, true)));
this._Country = (Country)
Convertir.HexaToDecimal(
Convertir.StringHexa_LittleEndian(
ExtractData.AspireString("101D9", "101D9", this.FileName, true)));
this._Compagnie = (Compagnie)
Convertir.HexaToDecimal(
Convertir.StringHexa_LittleEndian(
ExtractData.AspireString("101DA", "101DA", this.FileName, true)));
this._Version = Convertir.StringHexa_LittleEndian(ExtractData.AspireString("101DB", "101DB", this.FileName, true));
this._CompChecksum = Convertir.StringHexa_LittleEndian(ExtractData.AspireString("101DC", "101DD", this.FileName, true));
this._Checksum = Convertir.StringHexa_LittleEndian(ExtractData.AspireString("101DE", "101DF", this.FileName, true));
this._NmiVblVector = Convertir.StringHexa_LittleEndian(ExtractData.AspireString("101EA", "101EB", this.FileName, true));
this._ResetVector = Convertir.StringHexa_LittleEndian(ExtractData.AspireString("101FC", "101FD", this.FileName, true));
}
else if (ValCheckHighb == 65535) // HighRom
{
this._RomType = RomType.HighRom;
this._RomName = ExtractData.AspireString("FFC0", "FFD4", this.FileName).TrimEnd(new char[] { ' ' });
this._PostitionName = (int)Convertir.HexaToDecimal("FFC0");
this._InfoCart = (InformationCartouche)
Convertir.HexaToDecimal(
Convertir.StringHexa_LittleEndian(
ExtractData.AspireString("FFD6", "FFD6", this.FileName, true)));
this._RomSizeMB = (ROMSize)
Convertir.HexaToDecimal(
Convertir.StringHexa_LittleEndian(
ExtractData.AspireString("FFD7", "FFD7", this.FileName, true)));
this._RamSizeKB = (RAMSize)
Convertir.HexaToDecimal(
Convertir.StringHexa_LittleEndian(
ExtractData.AspireString("FFD8", "FFD8", this.FileName, true)));
this._Country = (Country)
Convertir.HexaToDecimal(
Convertir.StringHexa_LittleEndian(
ExtractData.AspireString("FFD9", "FFD9", this.FileName, true)));
this._Compagnie = (Compagnie)
Convertir.HexaToDecimal(
Convertir.StringHexa_LittleEndian(
ExtractData.AspireString("FFDA", "FFDA", this.FileName, true)));
this._Version = Convertir.StringHexa_LittleEndian(ExtractData.AspireString("FFDB", "FFDB", this.FileName, true));
this._CompChecksum = Convertir.StringHexa_LittleEndian(ExtractData.AspireString("FFDC", "FFDD", this.FileName, true));
this._Checksum = Convertir.StringHexa_LittleEndian(ExtractData.AspireString("FFDE", "FFDF", this.FileName, true));
this._NmiVblVector = Convertir.StringHexa_LittleEndian(ExtractData.AspireString("FFEA", "FFEB", this.FileName, true));
this._ResetVector = Convertir.StringHexa_LittleEndian(ExtractData.AspireString("FFFC", "FFFD", this.FileName, true));
}
//Format d'affichage
if (this._Country.ToString() == "Japon" ||
this._Country.ToString() == "USA")
{
this._FormatAffichage = FormatAffichage.NTSC;
}
else
{
this._FormatAffichage = FormatAffichage.PAL;
}
//MD5 hashing
this._MD5 = HashFile.GetMD5Hexa(this._FileName);
#region DEBUG INFOS : Informations sur la Rom
// #if DEBUG //Informations de debuggage
// Debug.WriteLine("DEBUG INFOS START : VRS.Library.Console.SuperNintendo.SnesRom.Load()");
// Debug.WriteLine("CheckLow1 :" + CheckLow1);
// Debug.WriteLine("CheckLow2 :" + CheckLow2);
// Debug.WriteLine("CheckLow1b :" + CheckLow1b);
// Debug.WriteLine("CheckLow2b :" + CheckLow2b);
// Debug.WriteLine("CheckHigh1 :" + CheckHigh1);
// Debug.WriteLine("CheckHigh2 :" + CheckHigh2);
// Debug.WriteLine("CheckHigh1b :" + CheckHigh1b);
// Debug.WriteLine("CheckHigh2b :" + CheckHigh2b);
// Debug.WriteLine("ValCheckLowb :" + ValCheckLowb);
// Debug.WriteLine("ValCheckHigh :" + ValCheckHigh);
// Debug.WriteLine("ValCheckHighb :" + ValCheckHighb);
// Debug.WriteLine("ValCheckLow :" + ValCheckLow);
// Debug.WriteLine("this._RomName :" + this._RomName);
// Debug.WriteLine("this._InfoCart :" + this._InfoCart.ToString());
// Debug.WriteLine("this._RomSizeMB :" + this._RomSizeMB.ToString());
// Debug.WriteLine("this._RamSizeKB :" + this._RamSizeKB.ToString());
// Debug.WriteLine("this._Country :" + this._Country.ToString());
// Debug.WriteLine("this._Compagnie :" + this._Compagnie.ToString());
// Debug.WriteLine("this._version : 1." + this._Version);
// Debug.WriteLine("this._CompChecksum :" + this._CompChecksum);
// Debug.WriteLine("this._Checksum :" + this._Checksum);
// Debug.WriteLine("this._ResetVector :" + this._ResetVector);
// Debug.WriteLine("this._NmiVblVector :" + this._NmiVblVector);
// Debug.WriteLine("this._FormatAffichage :" + this._FormatAffichage);
// Debug.WriteLine("this._MD5 :" + this._MD5);
// Debug.WriteLine("DEBUG INFOS END : VRS.Library.Console.SuperNintendo.SnesRom.Load()");
// #endif
#endregion
return(true);
}
else
{
return(false);
}
}
else
{
throw new FileNotFoundException();
}
}
