public static int AddHanghoa(Hanghoa hanghoa)
{
var sql = "insert into Hanghoa(HanghoaId,TenHanghoa,NhomHanghoaId) values (@HanghoaId,@TenHanghoa,@NhomHanghoaId)";
var param = new List <SqlParameter>();
param.Add(new SqlParameter
{
ParameterName = "@HanghoaId",
Value = hanghoa.HanghoaId,
SqlDbType = SqlDbType.Int //DbType = DbType.Int32
});
param.Add(new SqlParameter
{
ParameterName = "@TenHanghoa",
Value = hanghoa.TenHanghoa,
SqlDbType = SqlDbType.NVarChar //DbType = DbType.String
});
param.Add(new SqlParameter
{
ParameterName = "@NhomHanghoaId",
Value = hanghoa.NhomHanghoaId,
SqlDbType = SqlDbType.Int //DbType = DbType.Int32
});
return(db.ExecuteNonQuery(sql, param));
}
public static int DeleteHanghoa(Hanghoa cur)
{
//return DeleteGeneric(new { cur.HanghoaId }, cur.GetType().Name);
var sql = "delete from Hanghoa where HanghoaId = @HanghoaId";
var param = new List <SqlParameter>();
param.Add(new SqlParameter
{
ParameterName = "@HanghoaId",
Value = cur.HanghoaId,
SqlDbType = SqlDbType.Int //DbType = DbType.Int32
});
return(db.ExecuteNonQuery(sql, param));
}
public static int InsertHanghoa(Hanghoa cur)
{
return(InsertGeneric(cur));
}
