public int CreateFaqsCateGet(FaqsCate _faqsCate)
{
using (SqlConnection connection = GetConnection())
{
SqlCommand command = new SqlCommand("_FaqsCateInsert", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@FaqsCateID", 0);
command.Parameters.AddWithValue("@FaqsCateParentID", _faqsCate.FaqsCateParentID);
command.Parameters.AddWithValue("@FaqsCateName", _faqsCate.FaqsCateName);
command.Parameters.AddWithValue("@FaqsCateOrder", _faqsCate.FaqsCateOrder);
command.Parameters.AddWithValue("@Icon", _faqsCate.Icon);
command.Parameters.AddWithValue("@Phone", _faqsCate.Phone);
command.Parameters.AddWithValue("@Note", _faqsCate.Note);
command.Parameters.AddWithValue("@UserName", _faqsCate.UserName);
command.Parameters.AddWithValue("@Created", _faqsCate.Created);
SqlParameter sp = new SqlParameter("@pReturnValue", SqlDbType.Int);
sp.Direction = ParameterDirection.Output;
command.Parameters.Add(sp);
connection.Open();
command.ExecuteNonQuery();
int id = Convert.ToInt32(sp.Value.ToString());
return(id);
}
}
public FaqsCate GetFaqsCateById(int cId)
{
FaqsCate _faqsCate = null;
using (SqlConnection connection = GetConnection())
{
SqlCommand command = new SqlCommand("_FaqsCateById", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@FaqsCateID", cId);
connection.Open();
using (SqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection))
{
if (reader.Read())
{
_faqsCate = FaqsCateReader(reader);
}
else
{
throw new DataAccessException("Không tìm thấy danh mục");
}
command.Dispose();
}
}
return(_faqsCate);
}
public void CreateFaqsCate(FaqsCate _faqsCate)
{
using (SqlConnection connection = GetConnection())
{
SqlCommand command = new SqlCommand("_FaqsCateUpdate", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@Type", 0);
command.Parameters.AddWithValue("@FaqsCateID", 0);
command.Parameters.AddWithValue("@FaqsCateParentID", _faqsCate.FaqsCateParentID);
command.Parameters.AddWithValue("@FaqsCateName", _faqsCate.FaqsCateName);
command.Parameters.AddWithValue("@FaqsCateOrder", _faqsCate.FaqsCateOrder);
command.Parameters.AddWithValue("@Icon", _faqsCate.Icon);
command.Parameters.AddWithValue("@Phone", _faqsCate.Phone);
command.Parameters.AddWithValue("@Note", _faqsCate.Note);
command.Parameters.AddWithValue("@UserName", _faqsCate.UserName);
command.Parameters.AddWithValue("@Created", _faqsCate.Created);
connection.Open();
if (command.ExecuteNonQuery() <= 0)
{
throw new DataAccessException("Không thể tạo danh mục tin");
}
else
{
command.Dispose();
}
}
}
private FaqsCate FaqsCateReader(SqlDataReader reader)
{
FaqsCate _faqsCate = new FaqsCate();
_faqsCate.FaqsCateID = (int)reader["FaqsCateID"];
_faqsCate.FaqsCateParentID = (int)reader["FaqsCateParentID"];
_faqsCate.FaqsCateName = (string)reader["FaqsCateName"];
_faqsCate.FaqsCateOrder = (int)reader["FaqsCateOrder"];
_faqsCate.Icon = (string)reader["Icon"];
_faqsCate.Phone = (string)reader["Phone"];
_faqsCate.Note = (string)reader["Note"];
_faqsCate.UserName = (string)reader["UserName"];
_faqsCate.Created = (DateTime)reader["Created"];
return(_faqsCate);
}
protected void btn_add_faqs(object sender, EventArgs e)
{
Faqs obj = ReceiveHtml();
if (txtCapcha.Text.ToLower() == Session["Random"].ToString().ToLower())
{
FaqsBSO objBSO = new FaqsBSO();
FaqsCateBSO faqscateBSO = new FaqsCateBSO();
FaqsCate _faqCate = faqscateBSO.GetFaqsCateById(obj.FaqsCateID);
int i = objBSO.CreateFaqsGet(obj);
string strBody = "<b>Thông tin khách hàng : </b><br/>";
strBody += "<b>Họ tên khách hàng : </b> " + obj.FullName + "<br/>";
strBody += "<b>Email : </b> " + obj.Email + "<br/>";
strBody += "<b>Điện thoại : </b> " + obj.Phone + "<br/>";
strBody += "<b>Đơn vị công tác : </b> " + obj.Department + "<br/>";
strBody += "<b>Địa chỉ : </b> " + obj.Address + "<br/><br/>";
strBody += "<b>Thông tin yêu cầu hỗ trợ : </b> <br/>";
strBody += "<b>Tiêu đề : </b> " + obj.Title + "<br/><br/>";
strBody += "<b>Nội dung yêu cầu : </b> " + obj.Contents + "<br/><br/>";
strBody += "<a href='" + Variables.sWebRoot + "d3/faqs/" + GetString(obj.Title) + "-" + obj.FaqsID + ".aspx'><b>Xem chi tiết</b></a>";
strBody += "<br/>";
ConfigBSO configBSO = new ConfigBSO();
Config config = configBSO.GetAllConfig(Language.language);
MailBSO mailBSO = new MailBSO();
mailBSO.EmailFrom = config.Email_from;
string strObj = "Thông tin yêu cầu hỗ trợ trên website " + config.WebName + " ngày: " + DateTime.Now.ToString("dd:MM:yyyy");
mailBSO.SendMail(config.Email_to, strObj, strBody);
//string strObj1 = "Website Thoitrangdongphuc.com.vn tran trong cam on ";
//mailBSO.SendMail(obj.Email, strObj1, contentMail());
//string strObj3 = "Website Thoitrangdongphuc.com.vn gioi thieu ";
//mailBSO.SendMail(obj.Email, strObj3, contentSendMail());
Tool.Message(this.Page, "Cám ơn bạn đã gửi yêu cầu hỗ trợ đến chúng tôi, tất cả các thông tin bạn yêu cầu chúng tôi sẽ trả lời ngay khi chúng tôi nhận được. Trân trọng!");
}
else
{
Tool.Message(this.Page, "Sai mã xác nhận. Trân trọng!");
}
}
public void UpdateFaqsCate(FaqsCate _faqsCate)
{
FaqsCateDAO _faqsCateDAO = new FaqsCateDAO();
_faqsCateDAO.UpdateFaqsCate(_faqsCate);
}
public int CreateCateNewGet(FaqsCate _faqsCate)
{
FaqsCateDAO _faqsCateDAO = new FaqsCateDAO();
return(_faqsCateDAO.CreateFaqsCateGet(_faqsCate));
}
public void CreateCateNew(FaqsCate _faqsCate)
{
FaqsCateDAO _faqsCateDAO = new FaqsCateDAO();
_faqsCateDAO.CreateFaqsCate(_faqsCate);
}
