public static List<ProductGroup> GetAllProductGroups() { List<ProductGroup> list = new List<ProductGroup>(); DataTable dt = DAL.GetAllProductGroups(); foreach (DataRow row in dt.Rows) { ProductGroup item = new ProductGroup() { Id = row.Field<int>("Id"), ProductGroupName = row.Field<string>("Name"), RecordDate = row.Field<DateTime>("RecordDate") }; list.Add(item); } return list; }
private void btnSaveProductGroup_Click(object sender, EventArgs e) { if (tbProductGroup.Text.Replace(" ", "") != string.Empty) { ProductGroup productGrup = new ProductGroup() { ProductGroupName = tbProductGroup.Text.Replace(" ", "") }; bool result = productGrup.Save(); if (result) MessageBox.Show("ürün grubu eklem işleminiz gerçekleştirilmiştir.", "Bilgilendirme", MessageBoxButtons.OK, MessageBoxIcon.Information); else MessageBox.Show("İşlemde hata gerçekleşti.", "Dikkat", MessageBoxButtons.OK, MessageBoxIcon.Error); LoadProductGroups(); tbProductGroup.Text = string.Empty; } else { MessageBox.Show("Lütfen ürün grubu giriniz", "Dikkat", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void dtProductGroup_KeyDown(object sender, KeyEventArgs e) { if (e.KeyValue == 46) { DialogResult dialogResult = MessageBox.Show("Silmek istediğinize emin misiniz ? ", "Dikkat", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dialogResult == System.Windows.Forms.DialogResult.Yes) { int Id = Convert.ToInt32(dtProductGroup.SelectedRows[0].Cells[0].Value); ProductGroup t = new ProductGroup() { Id = Id }; t.Delete(); } LoadProductGroups(); } }
private void tbProductGroup_KeyDown(object sender, KeyEventArgs e) { if (e.KeyValue == 13) { if (tbProductGroup.Text.Replace(" ", "") != string.Empty) { ProductGroup productGroup = new ProductGroup() { ProductGroupName = tbProductGroup.Text.Replace(" ", "") }; bool result = productGroup.Save(); if (result) MessageBox.Show("Ürün Grubu ekleme işleminiz gerçekleştirilmiştir.", "Bilgilendirme", MessageBoxButtons.OK, MessageBoxIcon.Information); else MessageBox.Show("İşlemde hata gerçekleşti.", "Dikkat", MessageBoxButtons.OK, MessageBoxIcon.Error); LoadProductGroups(); tbProductGroup.Text = string.Empty; } else { MessageBox.Show("Lütfen masa adı giriniz", "Dikkat", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
private void dtProductGroup_CellEndEdit(object sender, DataGridViewCellEventArgs e) { var a = dtProductGroup.Rows[e.RowIndex].DataBoundItem as ProductGroup; string value = dtProductGroup.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString(); int Id = a.Id; //int Id = Convert.ToInt32(dtProductGroup.Rows[e.RowIndex].Cells[0].Value); DialogResult dialogResult = MessageBox.Show("Güncellemek istediğinize emin misiniz ? ", "Dikkat", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dialogResult == System.Windows.Forms.DialogResult.Yes) { ProductGroup t = new ProductGroup() { Id = Id, ProductGroupName = value }; t.Update(); MessageBox.Show("Ürün grubu güncelleme işleminiz gerçekleştirilmiştir.", "Bilgilendirme", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { LoadProductGroups(); } }