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