public static bool TaoMoi(HinhThucMuon item)
{
try
{
string query = string.Format("Insert into HinhThucMuon (TenHinhThucMuon) values (N'{0}')", item.TenHinhThucMuon);
if (DataProvider.ExecuteNonQuery(query) == 1)
{
return(true);
}
return(false);
}
catch (Exception)
{
throw;
}
}
public static bool CapNhat(HinhThucMuon item)
{
try
{
HinhThucMuon ht = GetHinhThucMuonTheoID(item.IDHinhThucMuon);
if (ht != null)
{
string query = "update HinhThucMuon set TenHinhThucMuon=N'" + item.TenHinhThucMuon + "' where IDHinhThucMuon=" + item.IDHinhThucMuon;
if (DataProvider.ExecuteNonQuery(query) == 1)
{
return(true);
}
}
return(false);
}
catch (Exception)
{
throw;
}
}
public static List <HinhThucMuon> GetDSHinhThucMuon()
{
try
{
List <HinhThucMuon> list = new List <HinhThucMuon>();
DataTable dt = DataProvider.ExecuteQuery("Select * from HinhThucMuon");
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
HinhThucMuon item = new HinhThucMuon();
item.IDHinhThucMuon = Convert.ToInt32(dr["IDHinhThucMuon"]);
item.TenHinhThucMuon = dr["TenHinhThucMuon"].ToString();
list.Add(item);
}
}
return(list);
}
catch (Exception)
{
throw;
}
}
