public void urunGuncVeriCek(int no, Ambiance_TextBox tbUAdi, Ambiance_TextBox tbUBarkod, Ambiance_ComboBox cbKategori,
Ambiance_TextBox Tb_Stok, Ambiance_ComboBox CbBirim, Ambiance_TextBox TbFiyat,
iTalk_Button_2 btnDuzenle, DataGridView dgUrun)
{
try
{
SqlConnection b = new SqlConnection();
b.ConnectionString = bag_cumlem;
b.Open();
string sql = "Select * from urunler where urun_id='" + no + "'";
SqlCommand k = new SqlCommand(sql, b);
SqlDataReader dr = k.ExecuteReader();
while (dr.Read())
{
tbUAdi.Text = dr["urun_adi"].ToString();
tbUBarkod.Text = dr["urun_barkod"].ToString();
cbKategori.Text = dr["urun_kategori"].ToString();
Tb_Stok.Text = dr["stok"].ToString();
CbBirim.Text = dr["birim"].ToString();
TbFiyat.Text = dr["fiyat"].ToString();
btnDuzenle.Visible = true;
}
}
catch
{
MessageBox.Show("Kullanıcı Getirilirken bir hata oluştu tekrar deneyiniz");
}
}
public void urunGuncelle(int id, string u_ad, int u_Barkod, int u_Kategori, int u_Stok, int u_Birim, double u_Fiyat,
iTalk_Button_2 btGuncellendi, DataGridView dg)
{
try
{
string sql = "Exec spUrunGunc '" + id + "','" + u_ad + "' ,'" + u_Barkod + "' ,'" + u_Kategori + "','" + u_Stok + "','" + u_Birim + "','" + u_Fiyat + "' ";
SqlConnection b = new SqlConnection();
b.ConnectionString = bag_cumlem;
b.Open();
SqlCommand k = new SqlCommand(sql, b);
k.ExecuteNonQuery();
MessageBox.Show("Kayıt Başarıyla Güncellendi");
btGuncellendi.Visible = false;
}
catch (Exception mesaj)
{
MessageBox.Show("Kayıt Güncellenirken Hata Oluştu");
MessageBox.Show(Convert.ToString(mesaj));
}
}
private void iTalk_Button_21_Click(object sender, EventArgs e)
{
ValidateMail = new Form();
iTalk_ThemeContainer container = new iTalk_ThemeContainer();
WebBrowser browser = new WebBrowser();
iTalk_Button_2 ButtonRefresh = new iTalk_Button_2();
iTalk_Button_2 ButtonBack = new iTalk_Button_2();
MessageBox.Show("If you dont Receive Mail, Maybe Sony Website got some trouble, wait few minutes to few hours...", "Infos", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
browser.ScriptErrorsSuppressed = true;
browser.Url = new Uri("http://email-fake.com/" + Domain.Replace("@", "") + "/" + Mail);
browser.SetBounds(3, 0x1c, 580, 0x155);
ButtonBack.Text = "Back and Confirm!";
ButtonBack.SetBounds(300, 377, 166, 40);
ButtonRefresh.Text = "Refresh";
ButtonRefresh.Location = new Point(ButtonBack.Location.X - (ButtonBack.Size.Width + 5), ButtonBack.Location.Y);
ValidateMail.TopMost = true;
ValidateMail.ShowInTaskbar = false;
ValidateMail.StartPosition = FormStartPosition.CenterScreen;
ValidateMail.Size = new Size(0x25d, 0x1e8);
ValidateMail.Controls.AddRange(new Control[] { container });
ValidateMail.SizeGripStyle = SizeGripStyle.Hide;
container.Controls.Add(browser);
container.Controls.Add(ButtonRefresh);
container.Controls.Add(ButtonBack);
container.Sizable = false;
ValidateMail.FormBorderStyle = FormBorderStyle.None;
ValidateMail.StartPosition = FormStartPosition.CenterScreen;
ButtonBack.Click += new EventHandler(ButtonClick);
ButtonRefresh.Click += (send, ei) =>
{
browser.Refresh();
};
base.Hide();
ValidateMail.Show();
}
