public int CreateCateNewsGet(CateNews catenews)
{
using (SqlConnection connection = base.GetConnection())
{
SqlCommand command = new SqlCommand("_CateNewsInsert", connection) {
CommandType = CommandType.StoredProcedure
};
command.Parameters.AddWithValue("@ParentNewsID", catenews.ParentNewsID);
command.Parameters.AddWithValue("@CateNewsName", catenews.CateNewsName);
command.Parameters.AddWithValue("@CateNewsTotal", catenews.CateNewsTotal);
command.Parameters.AddWithValue("@CateNewsOrder", catenews.CateNewsOrder);
command.Parameters.AddWithValue("@Language", catenews.Language);
command.Parameters.AddWithValue("@GroupCate", catenews.GroupCate);
command.Parameters.AddWithValue("@Icon", catenews.Icon);
command.Parameters.AddWithValue("@Slogan", catenews.Slogan);
command.Parameters.AddWithValue("@Roles", catenews.Roles);
command.Parameters.AddWithValue("@UserName", catenews.UserName);
command.Parameters.AddWithValue("@Created", catenews.Created);
command.Parameters.AddWithValue("@isUrl", catenews.isUrl);
command.Parameters.AddWithValue("@Url", catenews.Url);
command.Parameters.AddWithValue("@Image", catenews.Image);
SqlParameter sp = new SqlParameter("@pReturnValue", SqlDbType.Int) {
Direction = ParameterDirection.Output
};
command.Parameters.Add(sp);
connection.Open();
command.ExecuteNonQuery();
return Convert.ToInt32(sp.Value.ToString());
}
}
public void CreateCateNews(CateNews catenews)
{
using (SqlConnection connection = base.GetConnection())
{
SqlCommand command = new SqlCommand("_CateNewsUpdate", connection) {
CommandType = CommandType.StoredProcedure
};
command.Parameters.AddWithValue("@Type", 0);
command.Parameters.AddWithValue("@CateNewsID", 0);
command.Parameters.AddWithValue("@ParentNewsID", catenews.ParentNewsID);
command.Parameters.AddWithValue("@CateNewsName", catenews.CateNewsName);
command.Parameters.AddWithValue("@CateNewsTotal", catenews.CateNewsTotal);
command.Parameters.AddWithValue("@CateNewsOrder", catenews.CateNewsOrder);
command.Parameters.AddWithValue("@Language", catenews.Language);
command.Parameters.AddWithValue("@GroupCate", catenews.GroupCate);
command.Parameters.AddWithValue("@Icon", catenews.Icon);
command.Parameters.AddWithValue("@Slogan", catenews.Slogan);
command.Parameters.AddWithValue("@Roles", catenews.Roles);
command.Parameters.AddWithValue("@UserName", catenews.UserName);
command.Parameters.AddWithValue("@Created", catenews.Created);
command.Parameters.AddWithValue("@Url", catenews.Url);
command.Parameters.AddWithValue("@isUrl", catenews.isUrl);
connection.Open();
if (command.ExecuteNonQuery() <= 0)
{
throw new DataAccessException("Kh\x00f4ng thể tạo danh mục tin");
}
command.Dispose();
}
}
private void sendMailToGroup(ListQuestion lstQuestion)
{
/* ------------- Gui email den nguoi co trach nhiem tra loi cau hoi --*/
string strObj = "Ban nhan duoc yeu cau ho tro tu khach hang cua EVNIT. Ngay gui: " + DateTime.Now.ToString("dd/MM/yyyy");
string strBody = "Khách hàng có gửi cho bạn một yêu cầu hỗ trợ.<br /><br/>";
strBody += "<i>Tiêu đề : </i><strong>" + lstQuestion.Question_Title + "</strong><br/>";
strBody += "<span><i>Nội dung:</i><br /></span>";
strBody += "<div style='margin-left: 20px; font-size: 11pt; border-left: 3px solid green; padding: 5px;'>";
strBody += lstQuestion.Question_Content;
strBody += "</div>";
strBody += "<div style='border-bottom: 1px dashed red; width: 500px; height: 20px;'/>";
strBody += "<p>Trang hỗ trợ sản phẩm dịch vụ EVNIT <strong>http://support.evn.com.vn</strong></p>";
MailBSO mailBSO = new MailBSO();
ConfigBSO configBSO = new ConfigBSO();
Config config = configBSO.GetAllConfig(Language.language);
mailBSO.EmailFrom = config.Email_from;
CateNewsBSO cateNewsBSO = new CateNewsBSO();
CateNews cateNews = new CateNews();
cateNews = cateNewsBSO.GetCateNewsById(int.Parse(ddlCateNews.SelectedValue.ToString())); //list user of product
//Get list email
AdminBSO adminBSO = new AdminBSO();
DataTable dtUser = new DataTable();
dtUser = adminBSO.GetAllAdmin();
if (dtUser.Rows.Count > 0)
{
DataView view1 = new DataView(dtUser);
string strUser = cateNews.Roles;
strUser = strUser.Remove(strUser.LastIndexOf(",")).Replace(",", "','");
view1.RowFilter = "Admin_UserName in('" + strUser + "')";
dtUser = view1.ToTable();
for (int i = 0; i < dtUser.Rows.Count; i++)
{
//clientview.Text += dtUser.Rows[i]["Admin_Email"].ToString();
mailBSO.SendMail(dtUser.Rows[i]["Admin_Email"].ToString(), strObj, strBody);
//sendMailToGroup(dtUser.Rows[i]["Admin_Email"].ToString().Trim()); //Gui mai den nhom support cua san pham
}
}
/* ------------- End Gui email den nguoi co trach nhiem tra loi cau hoi --*/
}
private CateNews ReceiveHtml()
{
ConfigBSO configBSO = new ConfigBSO();
Config config = configBSO.GetAllConfig(Language.language);
int icon_w = Convert.ToInt32(config.New_icon_w);
int icon_h = Convert.ToInt32(config.New_icon_h);
int img_w = Convert.ToInt32(config.New_large_w);
int img_h = Convert.ToInt32(config.New_large_h);
string path = Request.PhysicalApplicationPath.Replace(@"\", "/") + "Upload/Category/";
commonBSO commonBSO = new commonBSO();
string image_icon = commonBSO.UploadImage(file_icon, path, icon_w, icon_h);
string image = commonBSO.UploadImage(FileUpload1, path, img_w, img_h);
CateNews catenews = new CateNews();
catenews.CateNewsID = (hddCateNewsID.Value != "") ? Convert.ToInt32(hddCateNewsID.Value) : 0;
catenews.ParentNewsID = (ddlCateNews.SelectedValue != "") ? Convert.ToInt32(ddlCateNews.SelectedValue) : 0;
catenews.CateNewsName = txtCateNewsName.Text;
catenews.CateNewsOrder = (hddCateNewsOrder.Value != "") ? Convert.ToInt32(hddCateNewsOrder.Value) : 0;
catenews.CateNewsTotal = (hddCateNewsTotal.Value != "") ? Convert.ToInt32(hddCateNewsTotal.Value) : 0;
catenews.Language = Language.language;
catenews.GroupCate = Convert.ToInt32(HddGroupCate.Value);
catenews.Icon = (image_icon != "") ? image_icon : hddIcon.Value;
catenews.Image = (image != "") ? image : hddImage.Value;
catenews.Slogan = txtSlogan.Text;
catenews.UserName = (hddUserName.Value != "") ? hddUserName.Value : Session["Admin_UserName"].ToString();
catenews.Created = (hddCreated.Value != "") ? Convert.ToDateTime(hddCreated.Value) : DateTime.Now;
catenews.isUrl = Convert.ToBoolean(rdbType.SelectedValue);
catenews.Url = txtUrl.Text;
catenews.Roles = "";
return catenews;
}
public void UpdateCateNews(CateNews catenews)
{
new CateNewsDAO().UpdateCateNews(catenews);
}
public int CreateCateNewGet(CateNews catenews)
{
CateNewsDAO catenewsDAO = new CateNewsDAO();
return catenewsDAO.CreateCateNewsGet(catenews);
}
public void CreateCateNew(CateNews catenews)
{
new CateNewsDAO().CreateCateNews(catenews);
}
