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;
}
