public int AddLoaiNCC(vo_LoaiNhaCungCap vo_loaiNCC)
{
try
{
dao_LoaiNhaCungCap dao = new dao_LoaiNhaCungCap();
int value = dao.insertLoaiNCC(vo_loaiNCC);
return(value);
}
catch (Exception ex)
{
throw ex;
}
}
public pl_windowThemLoaiNhaCungCap()
{
try
{
InitializeComponent();
this.bus_LoaiNCC = new bus_LoaiNhaCungCap();
this.vo_loaiNCC = new vo_LoaiNhaCungCap();
this.DataContext = vo_loaiNCC;
// tao ma loai nha cung cap
this.vo_loaiNCC.Id = bus_LoaiNCC.GetLastesIDLoaiNCC() + 1;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Loi!", MessageBoxButton.OK, MessageBoxImage.Information);
}
}
public ObservableCollection <vo_LoaiNhaCungCap> getListLoaiNhaCungCap()
{
try
{
dao_LoaiNhaCungCap dao = new dao_LoaiNhaCungCap();
DataTable dt = dao.getAllLoaiNhaCungCap();
ObservableCollection <vo_LoaiNhaCungCap> dsLoaiNCC = new ObservableCollection <vo_LoaiNhaCungCap>();
foreach (DataRow row in dt.Rows)
{
vo_LoaiNhaCungCap vo = new vo_LoaiNhaCungCap(int.Parse(row["ID"].ToString()), row["TENLOAINHACUNGCAP"].ToString());
dsLoaiNCC.Add(vo);
}
return(dsLoaiNCC);
}
catch (Exception ex)
{
throw ex;
}
}
public int insertLoaiNCC(params object[] oParams)
{
try
{
if (oParams != null)
{
vo_LoaiNhaCungCap vo_LoaiNCC = (vo_LoaiNhaCungCap)oParams[0];
ConnectionString cnn = new ConnectionString();
string query = "INSERT INTO LOAINHACUNGCAP(TENLOAINHACUNGCAP) output INSERTED.ID VALUES(@name)";
string[] arrParam = new string[] { "@name" };
SqlDbType[] arrType = new SqlDbType[] { SqlDbType.NVarChar };
object[] arrvalues = new object[] { vo_LoaiNCC.Name };
return(cnn.conn.ExecuteQueryReturnID(query, arrParam, arrvalues, arrType));
}
return(0);
}
catch (Exception ex)
{
throw ex;
}
}
