/// <summary>
/// This method Update a User registered
/// </summary>
/// <param name="id"></param>
/// <param name="name"></param>
/// <param name="finger"></param>
/// <param name="photo"></param>
public string update(int id, string name, string lastname, string nickname, string ci, string phono, string height, string weight, string skillful, string position, string birthday, string patchphoto, byte[] fingerOne, byte[] fingerTwo)
{
try
{
beginTransaction();
MySqlCommand cmd;
string cmdString = "UPDATE " + "players" +
" SET name=@name,last_name=@lastname,nickname=@nickname,ci=@ci,phono=@phono,height=@height,weight=@weight,skillful_leg=@skillful " +
",position=@position,birthday=@birthday,image=@image,fingerOne=@fingerOne,fingerTwo=@fingerTwo " +
" WHERE id= @id";
cmd = new MySqlCommand(cmdString, myConnection);
cmd.Parameters.Add("@id", MySqlDbType.Int16);
cmd.Parameters.Add("@name", MySqlDbType.VarChar, 45);
cmd.Parameters.Add("@lastname", MySqlDbType.VarChar, 45);
cmd.Parameters.Add("@nickname", MySqlDbType.VarChar, 40);
cmd.Parameters.Add("@ci", MySqlDbType.VarChar, 20);
cmd.Parameters.Add("@phono", MySqlDbType.VarChar, 30);
cmd.Parameters.Add("@height", MySqlDbType.VarChar, 10);
cmd.Parameters.Add("@weight", MySqlDbType.VarChar, 10);
cmd.Parameters.Add("@skillful", MySqlDbType.VarChar, 40);
cmd.Parameters.Add("@position", MySqlDbType.VarChar, 40);
cmd.Parameters.Add("@birthday", MySqlDbType.Date);
cmd.Parameters.Add("@image", MySqlDbType.Text);
cmd.Parameters.Add("@fingerOne", MySqlDbType.LongBlob);
cmd.Parameters.Add("@fingerTwo", MySqlDbType.LongBlob);
cmd.Parameters["@id"].Value = id;
cmd.Parameters["@name"].Value = name;
cmd.Parameters["@lastname"].Value = lastname;
cmd.Parameters["@nickname"].Value = nickname;
cmd.Parameters["@ci"].Value = ci;
cmd.Parameters["@phono"].Value = phono;
cmd.Parameters["@height"].Value = height;
cmd.Parameters["@weight"].Value = weight;
cmd.Parameters["@skillful"].Value = skillful;
cmd.Parameters["@position"].Value = position;
cmd.Parameters["@birthday"].Value = DateTime.Parse(birthday);
cmd.Parameters["@image"].Value = patchphoto;
cmd.Parameters["@fingerOne"].Value = fingerOne;
cmd.Parameters["@fingerTwo"].Value = fingerTwo;
cmd.ExecuteNonQuery();
ftp ftpClient = new ftp(@"ftp://sidbol.com", ConstactsCreadentials.userName, ConstactsCreadentials.pass);
/* Upload a File */
ftpClient.upload("public_html/afc/app/webroot/img/players/sm_" + patchphoto + ".jpg", Application.StartupPath + "\\Images\\sm_" + patchphoto + ".jpg");
myTrans.Commit();
}
catch (Exception e)
{
myTrans.Rollback();
return("***************** There is problem, please try again ***********************");
}
finally
{
myConnection.Close();
}
return("***** DATOS DEL JUGADOR ACTUALIZADO CORRECTAMENTE *****");
}
/// <summary>
/// this method do an insert to register user
/// </summary>
/// <param name="name"></param>
/// <param name="lastname"></param>
/// <param name="nickname"></param>
/// <param name="height"></param>
/// <param name="weight"></param>
/// <param name="skillful"></param>
/// <param name="position"></param>
/// <param name="birthday"></param>
/// <param name="patchphoto"></param>
/// <param name="fingerOne"></param>
/// <param name="fingerTwo"></param>
/// <returns></returns>
public string insert(string name, string lastname, string nickname, string ci,
string phono, string height, string weight, string skillful, string position,
string birthday, string patchphoto, byte[] fingerOne, byte[] fingerTwo, string idDivision, string idteam)
{
try
{
beginTransaction();
MySqlCommand cmd;
string cmdString = "INSERT INTO players(name,last_name,nickname,ci,phono,height,weight,skillful_leg,position,birthday,image,fingerOne,fingerTwo)values(@name,@lastname,@nickname,@ci,@phono,@height,@weight,@skillful,@position,@birthday,@image,@fingerOne,@fingerTwo)";
cmd = new MySqlCommand(cmdString, myConnection);
cmd.Parameters.Add("@name", MySqlDbType.VarChar, 45);
cmd.Parameters.Add("@lastname", MySqlDbType.VarChar, 45);
cmd.Parameters.Add("@nickname", MySqlDbType.VarChar, 40);
cmd.Parameters.Add("@ci", MySqlDbType.VarChar, 20);
cmd.Parameters.Add("@phono", MySqlDbType.VarChar, 30);
cmd.Parameters.Add("@height", MySqlDbType.VarChar, 10);
cmd.Parameters.Add("@weight", MySqlDbType.VarChar, 10);
cmd.Parameters.Add("@skillful", MySqlDbType.VarChar, 40);
cmd.Parameters.Add("@position", MySqlDbType.VarChar, 40);
cmd.Parameters.Add("@birthday", MySqlDbType.Date);
cmd.Parameters.Add("@image", MySqlDbType.Text);
cmd.Parameters.Add("@fingerOne", MySqlDbType.Blob);
cmd.Parameters.Add("@fingerTwo", MySqlDbType.Blob);
cmd.Parameters["@name"].Value = name;
cmd.Parameters["@lastname"].Value = lastname;
cmd.Parameters["@nickname"].Value = nickname;
cmd.Parameters["@ci"].Value = ci;
cmd.Parameters["@phono"].Value = phono;
cmd.Parameters["@height"].Value = height;
cmd.Parameters["@weight"].Value = weight;
cmd.Parameters["@skillful"].Value = skillful;
cmd.Parameters["@position"].Value = position;
cmd.Parameters["@birthday"].Value = DateTime.Parse(birthday);
cmd.Parameters["@image"].Value = patchphoto;
cmd.Parameters["@fingerOne"].Value = fingerOne;
cmd.Parameters["@fingerTwo"].Value = fingerTwo;
cmd.ExecuteNonQuery();
int idPlayer = Convert.ToInt32(cmd.LastInsertedId);
/* Create Object Instance */
ftp ftpClient = new ftp(@"ftp://sidbol.com", ConstactsCreadentials.userName, ConstactsCreadentials.pass);
/* Upload a File */
ftpClient.upload("public_html/afc/app/webroot/img/players/sm_" + patchphoto + ".jpg", Application.StartupPath + "\\Images\\sm_" + patchphoto + ".jpg");
myTrans.Commit();
DataTable tabla = this.getDivisionTeamsID(idDivision, idteam);
string idDivisionQuery = tabla.Rows[0]["id"].ToString();
tabla = this.getChampionsId(idDivision);
string idchampionShip = tabla.Rows[0]["championship_id"].ToString();
insertDivisionTeamsPLayers(idPlayer.ToString(), idDivisionQuery, idchampionShip);
}
catch (Exception e)
{
myTrans.Rollback();
return(e.Message + "*************** Ha ocurrido un error , porfavor contacte con SIDBOL ********************");
}
finally
{
myConnection.Close();
}
return("***** JUGADOR REGISTRADO CORRECTAMENTE *****");
}