public int DeleteServiceStyle(ServiceStyle ss) { using (System.Data.Common.DbTransaction myTran = dt.Connection.BeginTransaction()) { try { dt.Transaction = myTran; if (CheckIfExist(ss.id_SeviceStyle) != null) { dt.ServiceStyles.DeleteOnSubmit(ss); dt.SubmitChanges(); dt.Transaction.Commit(); return(1); } else { return(0); } }catch (Exception ex) { dt.Transaction.Rollback(); throw new Exception("Error Del Service Style " + ex.Message); } } }
private ServiceStyle CreateServiceStyle() { ServiceStyle ss = new ServiceStyle(); ss.id_SeviceStyle = txtID_LDV.Text; ss.NameStyle = txtTenLDV.Text; return(ss); }
public ServiceStyle CheckIfExist(string id) { ServiceStyle temp = (from n in dt.ServiceStyles where n.id_SeviceStyle.Equals(id) select n).FirstOrDefault(); return(temp); }
private ListViewItem GreateItem(ServiceStyle i) { ListViewItem item; item = new ListViewItem(i.id_SeviceStyle); item.SubItems.Add(i.NameStyle); item.Tag = i; return(item); }
private void btnSuaLDV_Click(object sender, EventArgs e) { if (lvwLDV.SelectedItems.Count > 0) { ServiceStyle ss = CreateServiceStyle(); ServiceStyle.ChangeServiceStyle(ss); LoadListToView(lvwLDV, ListServiceStyle); ClearInput_1(); } }
private void btnThemLDV_Click(object sender, EventArgs e) { ServiceStyle ss = CreateServiceStyle(); if (ServiceStyle.InsertServiceStyle(ss) == 0) { MessageBox.Show("Mã loại dịch vụ đã tồn tại!!", "Thông báo"); } LoadListToView(lvwLDV, ListServiceStyle); ClearInput_1(); }
private void lvwLDV_SelectedIndexChanged(object sender, EventArgs e) { ServiceStyle service = null; if (lvwLDV.SelectedItems.Count > 0) { btnXoaLDV.Enabled = true; btnSuaLDV.Enabled = true; service = (ServiceStyle)lvwLDV.SelectedItems[0].Tag; LoadServiceStyleToTextBox(service); } }
public void ChangeServiceStyle(ServiceStyle ss) { using (System.Data.Common.DbTransaction myTran = dt.Connection.BeginTransaction()) { try { dt.Transaction = myTran; ServiceStyle temp = (from n in dt.ServiceStyles where n.id_SeviceStyle.Equals(ss.id_SeviceStyle) select n).FirstOrDefault(); temp.NameStyle = ss.NameStyle; dt.SubmitChanges(); dt.Transaction.Commit(); } catch (Exception ex) { dt.Transaction.Rollback(); throw new Exception("Error Change Service Style " + ex.Message); } } }
private void LoadServiceStyleToTextBox(ServiceStyle ss) { txtID_LDV.Text = ss.id_SeviceStyle; txtTenLDV.Text = ss.NameStyle; }