/// <summary>
/// Database verilerini DataGridView'da göstermek için kullandığımız method.
/// </summary>
void dataGridView()
{
using (ntp_chatApplicationEntities1 db = new ntp_chatApplicationEntities1())
{
customerDataGrid.DataSource = db.table_chatUsers.ToList <table_chatUsers>();
}
}
/// <summary>
/// Databe update etmek için kullandığımız method.
/// </summary>
void updateData()
{
using (ntp_chatApplicationEntities1 db = new ntp_chatApplicationEntities1())
{
tableChat.name = txtName.Text;
tableChat.surname = txtSrName.Text;
tableChat.message_text = txtMessage.Text;
db.Entry(tableChat).State = EntityState.Modified;
db.SaveChanges();
}
}
/// <summary>
/// Database veri eklemek için kullandığımız method.
/// </summary>
void addData()
{
tableChat.name = txtName.Text;
tableChat.surname = txtSrName.Text;
tableChat.message_text = txtMessage.Text;
using (ntp_chatApplicationEntities1 db = new ntp_chatApplicationEntities1())
{
db.table_chatUsers.Add(tableChat);
db.SaveChanges();
}
}
//Data Grid üzerine double click yapılınca veriyi çekmek için
private void customerDataGrid_DoubleClick(object sender, EventArgs e)
{
if (customerDataGrid.CurrentRow.Index >= 0)
{
tableChat.user_id = Convert.ToInt32(customerDataGrid.CurrentRow.Cells["user_id"].Value);
using (ntp_chatApplicationEntities1 db = new ntp_chatApplicationEntities1())
{
tableChat = db.table_chatUsers.Where(x => x.user_id == tableChat.user_id).FirstOrDefault();
txtName.Text = tableChat.name;
txtSrName.Text = tableChat.surname;
txtMessage.Text = tableChat.message_text;
}
}
}
/// <summary>
/// Database'den veri silmek için kullandığımız method.
/// </summary>
void deleteData()
{
using (ntp_chatApplicationEntities1 db = new ntp_chatApplicationEntities1())
{
//db.Entry
var entry = db.Entry(tableChat);
if (entry.State == EntityState.Detached)
{
db.table_chatUsers.Attach(tableChat);
}
db.table_chatUsers.Remove(tableChat);
db.SaveChanges();
dataGridView();
clear();
//tableChat.name = txtName.Text;
//tableChat.surname = txtSrName.Text;
//tableChat.message_text = txtMessage.Text;
//db.table_chatUsers.Remove(tableChat);
//db.SaveChanges();
}
}
