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