//them protected void submit_create_Click(object sender, EventArgs e) { //kiem tra trong if (txtTenTinTuc.Text == "" || txtMoTaNgan.Text == "" || txtChiTiet.Text == "") { ClientScript.RegisterStartupScript(this.GetType(), "vanh", "blank()", true); return; } //them DTO.TinTuc tint = new DTO.TinTuc(); tint.TenTinTuc = txtTenTinTuc.Text; tint.MoTa = txtMoTaNgan.Text; tint.ChiTiet = txtChiTiet.Text; tint.NguoiDang = txtNguoiDang.Text; tint.LuotXem = Int32.Parse(txtLuotXem.Text); tint.Status = checkStatus_create.Checked; tint.Created_at = Convert.ToString(DateTime.Now); string path = Server.MapPath("../assets/images/TinTucs/"); FileUploadImage.SaveAs(path + FileUploadImage.FileName); tint.Anh = FileUploadImage.FileName; tint.DanhMucTinTuc_Id = Int32.Parse(ddrDanhMuc.SelectedValue); obj.create(tint); //load list Response.Redirect(Request.Url.ToString()); }
public void create(DTO.TinTuc c) { // string sql = "insert tbl_TinTuc values(N'" + c.TenTinTuc + "' , '" + "~/assets/images/TinTucs/" + c.Anh + "', '" + c.DanhMucTinTuc_Id + "', N'" + c.MoTa + "', N'" + c.ChiTiet + "','" + c.NguoiDang + "','" + c.LuotXem + "', '" + c.Status + "', '" + c.Created_at + "')"; obj.ExecuteNonQuery(sql); }
protected void Page_Load(object sender, EventArgs e) { load(); string id = Request.QueryString["Id"]; DTO.TinTuc tint = new DTO.TinTuc(); DataTable tb = new DataTable(); tb = obj.searchByID(id); string luotxem = ""; if (tb.Rows.Count > 0) { luotxem = tb.Rows[0]["LuotXem"].ToString(); } tint.LuotXem = Int32.Parse(luotxem) + 1; obj.updateLuotXem(tint.LuotXem, id); }
protected void btnSua_Click(object sender, EventArgs e) { int id = Convert.ToInt32(Request.QueryString["Id"]); DTO.TinTuc tint = new DTO.TinTuc(); tint.TenTinTuc = txtTen.Text; //tint.Anh = FileUploadAnhSua.FileName; //string path = Server.MapPath("../assets/images/TinTucs/"); //FileUploadAnhSua.SaveAs(path + FileUploadAnhSua.FileName); tint.Anh = FileUploadAnhSua.FileName; if (FileUploadAnhSua.HasFile) { string path = Server.MapPath("../assets/images/TinTucs/"); FileUploadAnhSua.SaveAs(path + FileUploadAnhSua.FileName); tint.Anh = FileUploadAnhSua.FileName; string fileName = "~/assets/images/TinTucs/" + FileUploadAnhSua.FileName; imgSua.ImageUrl = fileName; } else { tint.Anh = txtlink.Value; } tint.MoTa = txtMoTa.Text; tint.ChiTiet = CKEditorControl1.Text; tint.NguoiDang = txtNguoiDang.Text; tint.LuotXem = Int32.Parse(txtLuotXem.Text) + 1; tint.Status = CheckBox1.Checked; tint.DanhMucTinTuc_Id = Int32.Parse(DropDownList1.SelectedValue); tint.Created_at = Convert.ToString(DateTime.Now); obj.update(tint, id); Response.Redirect("TinTuc.aspx"); }
public void updateLuotXem(DTO.TinTuc c, int id) { string sql = "update tbl_TinTuc set LuotXem = N'" + c.LuotXem + "' where id = '" + id + "'"; obj.ExecuteNonQuery(sql); }
public void update(DTO.TinTuc c, int id) { string sql = "update tbl_TinTuc set TenTinTuc = N'" + c.TenTinTuc + "' , Anh = '" + "~/assets/images/TinTucs/" + c.Anh + "',DanhMucTinTuc_Id= '" + c.DanhMucTinTuc_Id + "' , MoTa = N'" + c.MoTa + "', ChiTiet = N'" + c.ChiTiet + "', NguoiDang = N'" + c.NguoiDang + "', LuotXem = N'" + c.LuotXem + "', status = '" + c.Status + "',Created_at= '" + c.Created_at + "' where id = '" + id + "'"; obj.ExecuteNonQuery(sql); }