/// <summary> /// Xóa đối tác /// </summary> /// <param name="o"></param> public static void Delete(Partners o) { DBHelp db = new DBHelp(); db.AddParameter("@PartnerID", o.PartnerID); db.ExecuteNonQuery("sp_Partner_Delete", CommandType.StoredProcedure); }
/// <summary> /// Thêm mới đối tác /// </summary> /// <param name="o"></param> public static void Insert(Partners o) { DBHelp db = new DBHelp(); db.AddParameter("@Name", o.PartnerName); db.AddParameter("@ImageURL", o.ImageURL); db.AddParameter("@Description", o.Description); db.AddParameter("@Website", o.Website); db.AddParameter("@Email", o.Email); db.AddParameter("@CreateDate", DateTime.Now.ToShortDateString()); db.AddParameter("@CreateUser", o.CreateUser); db.ExecuteNonQuery("sp_Partner_Insert", CommandType.StoredProcedure); }
/// <summary> /// Truy xuất toàn bộ bảng đối tác /// </summary> /// <returns></returns> public static Partners GetByID(Partners o) { Partners obj = new Partners(); DBHelp db = new DBHelp(); db.AddParameter("@PartnerID", o.PartnerID); SqlDataReader reader = db.ExecuteReader("sp_Partner_Select", CommandType.StoredProcedure); if (reader.Read()) { obj = new Partners(reader); } reader.Close(); return(obj); }