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