/// <summary> /// Xóa mẫu thông tin liên hệ /// </summary> /// <param name="o"></param> public static void Delete(Branchs o) { DBHelp db = new DBHelp(); db.AddParameter("@BranchID", o.BranchID); db.ExecuteNonQuery("sp_Branch_Delete", CommandType.StoredProcedure); }
/// <summary> /// Truy xuất thông tin liên hệ theo BranchID /// </summary> /// <returns></returns> public static Branchs GetByID(Branchs o) { Branchs obj = new Branchs(); DBHelp db = new DBHelp(); db.AddParameter("@BranchID", o.BranchID); SqlDataReader reader = db.ExecuteReader("sp_Branch_Select", CommandType.StoredProcedure); if (reader.Read()) { obj = new Branchs(reader); } reader.Close(); return(obj); }
/// <summary> /// Thêm mới mẫu thông tin liên hệ /// </summary> /// <param name="o"></param> public static void Insert(Branchs o) { DBHelp db = new DBHelp(); db.AddParameter("@FullName", o.FullName); db.AddParameter("@ImageUrl", o._imageUrl); db.AddParameter("@Address", o.Address); db.AddParameter("@Phone", o.Phone); db.AddParameter("@Mobile", o.Mobile); db.AddParameter("@Fax", o.Fax); db.AddParameter("@Email", o.Email); db.AddParameter("@WebSite", o.WebSite); db.AddParameter("@Contents", o.Contents); db.AddParameter("@CreateDate", DateTime.Now.ToShortDateString()); db.AddParameter("@CreateUser", o.CreateUser); db.ExecuteNonQuery("sp_Branch_Insert", CommandType.StoredProcedure); }