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) { }