/// <summary> /// Truy xuất UserID theo mã UserID và Password /// </summary> /// <param name="userid"></param> /// <param name="password"></param> /// <returns></returns> public string GetByUserIDPass(string userid, string password) { DBHelp db = new DBHelp(); db.AddParameter("@UserID", userid); db.AddParameter("@Password", password); SqlDataReader reader = db.ExecuteReader("sp_Account_SelectByUserIDPass", CommandType.StoredProcedure); return(reader.GetString(0)); }
/// <summary> /// Thêm mới mẫu tin hỏi đáp /// </summary> /// <param name="o"></param> public static void Insert(FAQs o) { DBHelp db = new DBHelp(); db.AddParameter("@Title", o.Title); db.AddParameter("@Description", o.Description); db.AddParameter("@CreateDate", DateTime.Now.ToShortDateString()); db.AddParameter("@CreateUser", o.CreateUser); db.ExecuteNonQuery("sp_FAQ_Insert", CommandType.StoredProcedure); }
/// <summary> /// Thêm mới dịch vụ /// </summary> /// <param name="o"></param> public static void Insert(Services o) { DBHelp db = new DBHelp(); db.AddParameter("@Name", o.ServiceName); db.AddParameter("@ImageURL", o.ImageURL); db.AddParameter("@Description", o.Description); db.AddParameter("@CreateDate", DateTime.Now.ToShortDateString()); db.AddParameter("@CreateUser", o.CreateUser); db.ExecuteNonQuery("sp_Service_Insert", CommandType.StoredProcedure); }
/// <summary> /// Cập nhập thông tin giới thiệu doanh nghiệp /// </summary> /// <param name="b"></param> public static void Update(AboutUs o) { DBHelp db = new DBHelp(); db.AddParameter("@IntroID", o.IntroID); db.AddParameter("@Description", o.Description); db.AddParameter("@Active", o.Active); db.AddParameter("@EditDate", DateTime.Now.ToShortDateString()); db.AddParameter("@EditUser", o.CreateUser); db.ExecuteNonQuery("sp_AboutUs_Update", CommandType.StoredProcedure); }
/// <summary> /// Cập nhật mẫu tin hỏi đáp /// </summary> /// <param name="o"></param> public static void Update(FAQs o) { DBHelp db = new DBHelp(); db.AddParameter("@FAQID", o.FAQID); db.AddParameter("@Title", o.Title); db.AddParameter("@Description", o.Description); db.AddParameter("@EditDate", DateTime.Now.ToShortDateString()); db.AddParameter("@EditUser", o.EditUser); db.ExecuteNonQuery("sp_FAQ_Update", CommandType.StoredProcedure); }
/// <summary> /// Cập nhập mẫu thông tin liên hệ /// </summary> /// <param name="o"></param> public static void Update(Contacts o) { DBHelp db = new DBHelp(); db.AddParameter("@ContactID", o.ContactID); db.AddParameter("@FullName", o.FullName); db.AddParameter("@Email", o.Email); db.AddParameter("@Subject", o.Subject); db.AddParameter("@Contents", o.Contents); db.AddParameter("@Phone", o.Phone); db.AddParameter("@Address", o.Address); db.AddParameter("@IPClient", o.IPClient); db.AddParameter("@EditeDate", DateTime.Now.ToShortDateString()); db.AddParameter("@EditeUser", o.CreateUser); db.ExecuteNonQuery("sp_Contact_Update", CommandType.StoredProcedure); }
/// <summary> /// Xóa tài khoản người dùng /// </summary> /// <param name="o"></param> public static void Delete(Accounts o) { DBHelp db = new DBHelp(); db.AddParameter("@UserID", o.UserID); db.ExecuteNonQuery("sp_Account_Delete", CommandType.StoredProcedure); }
/// <summary> /// Xóa liên kết /// </summary> /// <param name="b"></param> public static void Delete(Links o) { DBHelp db = new DBHelp(); db.AddParameter("@LinkID", o.LinkID); db.ExecuteNonQuery("sp_Link_Delete", CommandType.StoredProcedure); }
/// <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> /// Xóa mẫu tin hỏi đáp /// </summary> /// <param name="o"></param> public static void Delete(FAQs o) { DBHelp db = new DBHelp(); db.AddParameter("@FAQID", o.FAQID); db.ExecuteNonQuery("sp_FAQ_Delete", CommandType.StoredProcedure); }
/// <summary> /// Xóa mẫu thông tin liên hệ /// </summary> /// <param name="o"></param> public static void Delete(Contacts o) { DBHelp db = new DBHelp(); db.AddParameter("@ContactID", o.ContactID); db.ExecuteNonQuery("sp_Contact_Delete", CommandType.StoredProcedure); }
/// <summary> /// Xóa dịch vụ /// </summary> /// <param name="o"></param> public static void Delete(Services o) { DBHelp db = new DBHelp(); db.AddParameter("@ServiceID", o.ServiceID); db.ExecuteNonQuery("sp_Service_Delete", CommandType.StoredProcedure); }
/// <summary> /// Xóa thông tin giới thiệu doanh nghiệp /// </summary> /// <param name="b"></param> public static void Delete(AboutUs o) { DBHelp db = new DBHelp(); db.AddParameter("@IntroID", o.IntroID); db.ExecuteNonQuery("sp_AboutUs_Delete", CommandType.StoredProcedure); }
/// <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> /// Phương thức xóa dữ liệu /// </summary> /// <param name="o"></param> public static void Delete(Categories o) { DBHelp db = new DBHelp(); db.AddParameter("@CateID", o.CateID); db.ExecuteNonQuery("sp_Categories_Delete", CommandType.StoredProcedure); }
/// <summary> /// Xóa một mẫu tin tức /// </summary> /// <param name="o"></param> public static void Delete(News o) { DBHelp db = new DBHelp(); db.AddParameter("@NewsID", o.NewsID); db.ExecuteNonQuery("sp_News_Delete", CommandType.StoredProcedure); }
/// <summary> /// Phương thức cập nhật dữ liệu /// </summary> /// <param name="o"></param> public static void Update(Categories o) { DBHelp db = new DBHelp(); db.AddParameter("@ID", o.ID); db.AddParameter("@ParentID", o.ParentID); db.AddParameter("@Level", o.Level); db.AddParameter("@CateID", o.CateID); db.AddParameter("@CateName", o.CateName); db.AddParameter("@ImageURL", o.ImageURL); db.AddParameter("@CatePos", o.CatePos); db.AddParameter("@EditDate", DateTime.Now.ToShortDateString()); db.AddParameter("@EditUser", o.EditUser); db.ExecuteNonQuery("sp_Categories_Update", CommandType.StoredProcedure); }
/// <summary> /// Thêm mới Tin tức /// </summary> /// <param name="o"></param> public static void Insert(News o) { DBHelp db = new DBHelp(); db.AddParameter("@Title", o.Title); db.AddParameter("@ImageURL", o.ImageURL); db.AddParameter("@ShortDescript", o.ShortDescript); db.AddParameter("@Description", o.Description); db.AddParameter("@Copyright", o.Copyright); db.AddParameter("@IsHotNews", o.IsHotNews); db.AddParameter("@PostDate", DateTime.Now.ToShortDateString()); db.AddParameter("@CreateDate", DateTime.Now.ToShortDateString()); db.AddParameter("@CreateUser", o.CreateUser); db.ExecuteNonQuery("sp_News_Insert", CommandType.StoredProcedure); }
/// <summary> /// Cập nhập tài khoản /// </summary> /// <param name="o"></param> public static void Update(Accounts o) { DBHelp db = new DBHelp(); db.AddParameter("@UserID", o.UserID); db.AddParameter("@Password", o.Password); db.AddParameter("@Email", o.Email); db.AddParameter("@Mobile", o.Mobile); db.AddParameter("@FullName", o.FullName); db.AddParameter("@Active", o.Active); db.AddParameter("@EditDate", DateTime.Now.ToShortDateString()); db.AddParameter("@EditUser", o.EditUser); db.ExecuteNonQuery("sp_Account_Update", CommandType.StoredProcedure); }
/// <summary> /// Cập nhập thông tin đối tác /// </summary> /// <param name="o"></param> public static void Update(Partners o) { DBHelp db = new DBHelp(); db.AddParameter("@PartnerID", o.PartnerID); 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("@EditDate", DateTime.Now.ToShortDateString()); db.AddParameter("@EditUser", o.EditUser); db.ExecuteNonQuery("sp_Partner_Update", CommandType.StoredProcedure); }
/// <summary> /// Cập nhập liên kết /// </summary> /// <param name="o"></param> public static void Update(Links o) { DBHelp db = new DBHelp(); db.AddParameter("@LinkID", o.LinkID); db.AddParameter("@Name", o.LinkName); db.AddParameter("@URL", o.URL); db.AddParameter("@Pos", o.Pos); db.AddParameter("@Logo", o.Logo); db.AddParameter("@EditDate", DateTime.Now.ToShortDateString()); db.AddParameter("@EditUser", o.EditUser); db.ExecuteNonQuery("sp_Link_Update", CommandType.StoredProcedure); }
/// <summary> /// Cập nhật sản phẩm /// </summary> /// <param name="o"></param> public static void Update(Products o) { DBHelp db = new DBHelp(); db.AddParameter("@ProductID", o.ProductID); db.AddParameter("@CateID", o.CateID); db.AddParameter("@ProductTitle", o.ProductTitle); db.AddParameter("@ImageURL", o.ImageUrl); db.AddParameter("@Description", o.Description); db.AddParameter("@EditDate", DateTime.Now.ToShortDateString()); db.AddParameter("@EditUser", o.EditUser); db.ExecuteNonQuery("sp_Product_Update", CommandType.StoredProcedure); }
/// <summary> /// Thêm mới khách hàng /// </summary> /// <param name="c"></param> public static void Insert(Customers o) { DBHelp db = new DBHelp(); db.AddParameter("@Name", o.CustomerName); 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_Customer_Insert", CommandType.StoredProcedure); }
/// <summary> /// Truy xuất theo mã khách hàng /// </summary> /// <param name="cusid"></param> /// <returns></returns> public static Customers GetByID(Customers o) { Customers obj = new Customers(); DBHelp db = new DBHelp(); db.AddParameter("@CustomerID", o.CustomerID); SqlDataReader reader = db.ExecuteReader("sp_Customer_Select", CommandType.StoredProcedure); while (reader.Read()) { obj = new Customers(reader); } reader.Close(); return(obj); }
/// <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> /// Truy xuất liên kết theo ID /// </summary> /// <returns></returns> public static Links GetByID(Links o) { Links obj = new Links(); DBHelp db = new DBHelp(); db.AddParameter("@LinkID", o.LinkID); SqlDataReader reader = db.ExecuteReader("sp_Link_Select", CommandType.StoredProcedure); if (reader.Read()) { obj = new Links(reader); } reader.Close(); return(obj); }
/// <summary> /// Truy xuất toàn bộ bảng hỏi đáp /// </summary> /// <param name="o"></param> /// <returns></returns> public static FAQs GetByID(FAQs o) { FAQs obj = new FAQs(); DBHelp db = new DBHelp(); db.AddParameter("@FAQID", o.FAQID); SqlDataReader reader = db.ExecuteReader("sp_FAQ_Select", CommandType.StoredProcedure); if (reader.Read()) { obj = new FAQs(reader); } reader.Close(); return(obj); }
/// <summary> /// Truy xuất thông tin liên hệ theo ContactID /// </summary> /// <returns></returns> public static Contacts GetByID(Contacts o) { Contacts obj = new Contacts(); DBHelp db = new DBHelp(); db.AddParameter("@ContactID", o.ContactID); SqlDataReader reader = db.ExecuteReader("sp_Contact_Select", CommandType.StoredProcedure); if (reader.Read()) { obj = new Contacts(reader); } reader.Close(); return(obj); }
/// <summary> /// Truy xuất theo mã dịch vụ /// </summary> /// <param name="o"></param> /// <returns></returns> public static Services GetByID(Services o) { Services obj = new Services(); DBHelp db = new DBHelp(); db.AddParameter("@ServiceID", o.ServiceID); SqlDataReader reader = db.ExecuteReader("sp_Service_Select", CommandType.StoredProcedure); if (reader.Read()) { obj = new Services(reader); } reader.Close(); return(obj); }
/// <summary> /// Truy xuất sản phẩm theo mã thể loại /// </summary> /// <param name="o"></param> /// <returns></returns> public static IList <Products> GetByCateIDTop3(Products o) { DBHelp db = new DBHelp(); IList <Products> list = new List <Products>(); db.AddParameter("@CateID", o.CateID); SqlDataReader reader = db.ExecuteReader("sp_Product_SelectByCateIDTop3", CommandType.StoredProcedure); while (reader.Read()) { list.Add(new Products(reader)); } reader.Close(); return(list); }