public void UpdateImage(string filepath, string username)
{
Costumer costumer = Costumer.getInstance();
dh.baglanti.Open();
SqlCommand komut = new SqlCommand("Select * from Tbl_Uyeler where Username=@Username", baglanti);
komut.Parameters.AddWithValue("Username", username);
SqlDataReader dr = komut.ExecuteReader();
dr.Read();
string Username = "******";
string Password = "******";
string Urlpath = "ftp://185.149.103.190";
WebClient Client = new WebClient();
Client.Credentials = new System.Net.NetworkCredential(Username, Password);
Client.BaseAddress = Urlpath;
string deneme = username;
Client.UploadFile(username + ".jpg", WebRequestMethods.Ftp.UploadFile, filepath);
dh.baglanti.Close();
}
public static Costumer getInstance()
{
if (instance == null)
{
instance = new Costumer();
}
return(instance);
}
public Costumer GetCostumer(string username, string password)
{
Costumer costumer = null;
try
{
dh.baglanti.Open();
SqlCommand komut = new SqlCommand("Select * from Tbl_Uyeler where Username=@Username", baglanti);
komut.Parameters.AddWithValue("Username", username);
SqlDataReader dr = komut.ExecuteReader();
dr.Read();
if (password == (string)dr["Password"])
{
costumer = Costumer.getInstance();
costumer.UserId = (int)(dr["Userid"]);
costumer.Name = dr["Name"].ToString();
costumer.Adress = dr["Adress"].ToString();
costumer.Email = dr["Mail"].ToString();
costumer.Username = dr["Username"].ToString();
costumer.Password = dr["Password"].ToString();
costumer.Gender = (bool)dr["Gender"];
costumer.Image = dr["UserPicture"].ToString();
if ((bool)dr["Admincheck"] == true)
{
MainForm.Isroot = true;
}
else
{
MainForm.Isroot = false;
}
try
{
costumer.Image = "http://torrent-oyun.gen.tr/images/" + costumer.UserId + ".jpg";
}
catch
{
if (costumer.Gender)
{
costumer.Image = "http://torrent-oyun.gen.tr/images/male.png";
}
else
{
costumer.Image = "http://torrent-oyun.gen.tr/images/female.png";
}
}
}
}
catch (Exception ex)
{
MessageBox.Show("Server Connection Crashed, Please try again. \n" + ex.Message, "Connection Crashed", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
dh.baglanti.Close();
return(costumer);
}
public void CustomerUpdate(Costumer cstmr)
{
string kayitcustomer = "UPDATE Customer SET Name=@Name,Address=@Address,Mail=@Mail,Username=@Username,Password=@Password,Gender=@Gender where ID=@ID";
dh.baglanti.Open();
SqlCommand cmd = new SqlCommand(kayitcustomer, baglanti);
cmd.Parameters.AddWithValue("ID", cstmr.UserId);
cmd.Parameters.AddWithValue("Name", cstmr.Name);
cmd.Parameters.AddWithValue("Address", cstmr.Adress);
cmd.Parameters.AddWithValue("Email", cstmr.Email);
cmd.Parameters.AddWithValue("Username", cstmr.Username);
cmd.Parameters.AddWithValue("Password", cstmr.Password);
cmd.Parameters.AddWithValue("Gender", cstmr.Gender);
cmd.ExecuteNonQuery();
dh.baglanti.Close();
}
public void CreateCostumer(Costumer c1, string path)
{
string create = ("INSERT INTO Tbl_Uyeler (Username,Name,Password,Mail,Adress,Gender,UserPicture,UserTel,Admincheck) VALUES (@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,'0')");
dh.baglanti.Open();
SqlCommand cmd = new SqlCommand(create, baglanti);
cmd.Parameters.AddWithValue("@p1", c1.Username);
cmd.Parameters.AddWithValue("@p2", c1.Name);
cmd.Parameters.AddWithValue("@p3", c1.Password);
cmd.Parameters.AddWithValue("@p4", c1.Email);
cmd.Parameters.AddWithValue("@p5", c1.Adress);
cmd.Parameters.AddWithValue("@p6", c1.Gender);
cmd.Parameters.AddWithValue("@p7", path);
cmd.Parameters.AddWithValue("@p8", "000");
cmd.ExecuteNonQuery();
dh.baglanti.Close();
}
private void btnGiris_MouseClick(object sender, MouseEventArgs e)
{
Getdatabase dh = Getdatabase.getInstance();
//Costumer logined = Costumer.getInstance();
Costumer customer = dh.GetCostumer(txtKadi.Text, txtSifre.Text);
if (customer != null)
{
if (txtKadi.Text == customer.Username && txtSifre.Text == customer.Password)
{
MessageBox.Show("Girdi");
}
}
else
{
MessageBox.Show("Wrong Username or Password.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void updateScreen()
{
Costumer cs = Costumer.getInstance();
Console.WriteLine(cs.Name.ToString());
if (cs != null)
{
btnCard.Visible = true;
btnLogout.Visible = true;
btnMyprofile.Visible = true;
btnPrev.Visible = true;
bool flag = false;
Getdatabase db = new Getdatabase();
db.IsAdmin(cs, ref flag);
if (flag)
{
btnAdmin.Visible = true;
}
}
}
public void IsAdmin(Costumer costumer, ref bool flag)
{
try
{
dh.baglanti.Open();
SqlCommand komut = new SqlCommand("Select * from Tbl_Uyeler where Username=@Username", baglanti);
komut.Parameters.AddWithValue("Username", costumer.Username);
SqlDataReader dr = komut.ExecuteReader();
dr.Read();
if (costumer.Password == (string)dr["Password"] && (bool)dr["Admincheck"] == true)
{
flag = true;
}
else
{
flag = false;
}
}
catch
{
}
}
public void Add(Costumer costumer)
{
}
