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