public string editBaidang(BaiDang bd)
{
try
{
conn.Open();
string sql = "UPDATE BaiDang SET maNhaTuyenDung = @mntd,tieuDe = @td, viTriCongViec = @vtcv,maNganhNghe = @mnn,moTa = @mt,soLuongTuyen = @slt,mucLuong = @ml,soDienThoai = @sdt,diaChi = @dc WHERE maBaiDang = @mbd";
var cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("mntd", bd.maNhaTuyenDung);
cmd.Parameters.AddWithValue("td", bd.tieuDe);
cmd.Parameters.AddWithValue("vtcv", bd.viTriCongViec);
cmd.Parameters.AddWithValue("mnn", bd.maNganhNghe);
cmd.Parameters.AddWithValue("mt", bd.moTa);
cmd.Parameters.AddWithValue("slt", bd.soLuongTuyen);
cmd.Parameters.AddWithValue("ml", bd.mucLuong);
cmd.Parameters.AddWithValue("sdt", bd.soDienThoai);
cmd.Parameters.AddWithValue("dc", bd.diaChi);
cmd.Parameters.AddWithValue("mbd", bd.maBaiDang);
cmd.ExecuteNonQuery();
conn.Close();
return("Sửa thành công");
}
catch (Exception)
{
return("Xảy ra lỗi");
}
}
public ActionResult Xoa(BaiDang bd)
{
var dao = new DAO.BaiDangDAO();
int ID = dao.XoaDonHang(bd.ma);
return(View("Index", dao.getListBaiDang2(ID)));
}
public ActionResult convert(BaiDang bd)
{
var dao = new DAO.BaiDangDAO();
BaiDang bdsua = dao.SuaBaiDang(bd);
return(View("TrangSua", bd));
}
public string addBaidang(BaiDang bd)
{
try
{
conn.Open();
string sql = "INSERT INTO BaiDang VALUES(@mntd,@td,@vtcv,@mnn,@mt,@slt,@ml,@sdt,@dc)";
var cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("mntd", bd.maNhaTuyenDung);
cmd.Parameters.AddWithValue("td", bd.tieuDe);
cmd.Parameters.AddWithValue("vtcv", bd.viTriCongViec);
cmd.Parameters.AddWithValue("mnn", bd.maNganhNghe);
cmd.Parameters.AddWithValue("mt", bd.moTa);
cmd.Parameters.AddWithValue("slt", bd.soLuongTuyen);
cmd.Parameters.AddWithValue("ml", bd.mucLuong);
cmd.Parameters.AddWithValue("sdt", bd.soDienThoai);
cmd.Parameters.AddWithValue("dc", bd.diaChi);
cmd.ExecuteNonQuery();
conn.Close();
return("Thêm thành công");
}
catch (Exception)
{
return("Xảy ra lỗi");
}
}
public int XoaDonHang(int ma)
{
BaiDang BaiDang_del = db.BaiDangs.Where(p => p.ma.Equals(ma)).SingleOrDefault();
int ID = BaiDang_del.mataikhoan;
db.BaiDangs.Remove(BaiDang_del);
db.SaveChanges();
return(ID);
}
protected void btnedit_Click(object sender, CommandEventArgs e)
{
if (e.CommandName == "edit")
{
BaiDang bd = bdc.getMotBaidang(Convert.ToInt32(e.CommandArgument));
Session["baidang"] = bd;
Response.Redirect("EditPost.aspx");
}
}
public int SuaBaiDang(BaiDang Db_New)
{
// BaiDang BaiDang_old = db.BaiDangs.Where(p => p.ma.Equals(Db_New.ma)).SingleOrDefault();
BaiDang bdold = db.BaiDangs.Where(w => w.ma == Db_New.ma).SingleOrDefault();
bdold = Db_New;
db.SaveChanges();
return(5);
// return Db_New.mataikhoan;
}
public ActionResult GetBaiDang(int id)
{
BaiDang baiDang = database.BaiDangs.Find(id);
ViewBag.GetBaiDang = baiDang;
var x = database.BinhLuans.Where(i => i.IDBaiDang == id).ToList();
ViewBag.GetBinhLuan = x;
return(View("Index", database.BaiDangs));
}
public ViewResult XemCT(string matin)
{
BaiDang baidang = db.BaiDangs.SingleOrDefault(n => n.MaTin.Equals(matin));
if (baidang == null)
{
Response.StatusCode = 404;
return(null);
}
return(View(baidang));
}
public ActionResult TrangSua(BaiDang bd)
{
//if (bd != null)
// bd_edit = bd;
//if (img_edit != null)
//{
// bd.hinhanh = img_edit;
//}
convert(bd);
return(View(bd));
}
protected void Page_Load(object sender, EventArgs e)
{
int id = Convert.ToInt32(Request.QueryString["maBaiDang"]);
BaiDang bd = new BaiDang();
bd = bdc.getMotBaidang(id);
lblmabaidang.Text = bd.maBaiDang.ToString();
lblmantd.Text = bd.maNhaTuyenDung.ToString();
lbltieude.Text = bd.tieuDe;
lblvitri.Text = bd.viTriCongViec;
lblmann.Text = bd.maNganhNghe.ToString();
lblml.Text = bd.mucLuong.ToString("0000,0 đ");
lblslt.Text = bd.soLuongTuyen.ToString();
lblsdt.Text = bd.soDienThoai;
lbldiachi.Text = bd.diaChi;
DataList1.Visible = false;
TaiKhoan tk = (TaiKhoan)Session["tk"];
if (tk == null)
{
btnApply.Visible = false;
btnshowappliedCV.Visible = false;
}
else
{
int mantd = ntdc.getmantd(tk.maTaiKhoan);
if (tk.loaiTaiKhoan == 1)
{
btnApply.Visible = false;
if (mantd == bd.maNhaTuyenDung)
{
btnshowappliedCV.Visible = true;
}
else
{
btnshowappliedCV.Visible = false;
}
}
else if (tk.loaiTaiKhoan == 0)
{
btnApply.Visible = false;
btnshowappliedCV.Visible = false;
}
else
{
btnApply.Visible = true;
btnshowappliedCV.Visible = false;
}
}
}
protected void btnadd_Click(object sender, EventArgs e)
{
BaiDang bdn = new BaiDang();
bdn.maNhaTuyenDung = Convert.ToInt32(lblmantd.Text);
bdn.tieuDe = txttieude.Text;
bdn.viTriCongViec = txtvitri.Text;
bdn.maNganhNghe = Convert.ToInt32(ddlnganhnghe.SelectedValue);
bdn.moTa = txtmota.Text;
bdn.soLuongTuyen = Convert.ToInt32(txtsoluongtuyen.Text);
bdn.mucLuong = Convert.ToInt32(txtmucluong.Text);
bdn.soDienThoai = txtsodienthoai.Text;
bdn.diaChi = txtdiachi.Text;
lblalert.Text = bdc.addBaidang(bdn);
}
public ActionResult PostQuestion(string title, string editor1)
{
BaiDang baiDang = new BaiDang
{
TieuDe = title,
NoiDung = editor1,
TenDangNhap = (Session["NguoiDungDangNhap"] as NguoiDung).TenDangNhap,
ThoiGian = DateTime.Now
};
database.BaiDangs.Add(baiDang);
database.SaveChanges();
return(View("Index", database.BaiDangs));
}
public ActionResult UploadH2(BaiDang viewModel, HttpPostedFileBase file)
{
if (file != null)
{
string path = Path.Combine(Server.MapPath("~/Image"),
Path.GetFileName(file.FileName));
file.SaveAs(path);
string s = "/Image/" + Path.GetFileName(file.FileName);
viewModel.hinhanh = s;
}
UserLogin a = (UserLogin)Session[CommonConstrants.USER_SESSION];
var BDsum = new BaiDangDAO();
viewModel.mataikhoan = a.ID;
convert(viewModel);
return(View("TrangSua", viewModel));
}
public BaiDang SuaBaiDang(BaiDang Db_New)
{
BaiDang BaiDang_old = db.BaiDangs.Where(p => p.ma.Equals(Db_New.ma)).SingleOrDefault();
BaiDang_old.gioithieu = Db_New.gioithieu;
BaiDang_old.ten = Db_New.ten;
BaiDang_old.TacGia = Db_New.TacGia;
BaiDang_old.matacgia = Db_New.matacgia;
BaiDang_old.manxb = Db_New.manxb;
BaiDang_old.trangthai = Db_New.trangthai;
BaiDang_old.gia = Db_New.gia;
BaiDang_old.matheloai = Db_New.matheloai;
if (Db_New.hinhanh != null)
{
BaiDang_old.hinhanh = Db_New.hinhanh;
}
Db_New = null;
db.SaveChanges();
return(BaiDang_old);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BaiDang bd = (BaiDang)Session["baidang"];
lblmabaidang.Text = (bd.maBaiDang).ToString();
lblmantd.Text = (bd.maNhaTuyenDung).ToString();
txttieude.Text = bd.tieuDe;
txtvitri.Text = bd.viTriCongViec;
ddlnganhnghe.SelectedValue = (bd.maNganhNghe).ToString();
txtmota.Text = bd.moTa;
txtsoluongtuyen.Text = (bd.soLuongTuyen).ToString();
txtmucluong.Text = (bd.mucLuong).ToString();
txtsodienthoai.Text = bd.soDienThoai;
txtdiachi.Text = bd.diaChi;
//dropdownlist
ddlnganhnghe.DataSource = nnc.getNganhNghe();
ddlnganhnghe.DataTextField = "TenNganhNghe";
ddlnganhnghe.DataValueField = "maNganhNghe";
ddlnganhnghe.DataBind();
}
}
public ActionResult create(BaiDang bd)
{
UserLogin a = (UserLogin)Session[CommonConstrants.USER_SESSION];
//bd_create = bd;
var BDsum = new BaiDangDAO();
BaiDang bd_temp = new BaiDang();
bd.mataikhoan = a.ID;
bd_temp.ten = null;
string TacGia = Request.Form["TacGia"];
string NXB = Request.Form["NXB"];
string tenTheLoai = Request.Form["TheLoai"];
if (BDsum.insertBaiDang(bd))
{
Response.Write("<script type=\"text/javascript\">alert('Tạo Bài đăng thành công !!! ');</script>");
return(View("create", bd_temp));
}
else
{
// img_create = null;
return(View("create", bd_temp));
}
}
public BaiDang getMotBaidang(int maBaiDang)
{
conn.Open();
string sql = "SELECT * FROM BaiDang WHERE maBaiDang = " + maBaiDang + "";
var cmd = new SqlCommand(sql, conn);
var rd = cmd.ExecuteReader();
BaiDang bd = new BaiDang();
if (rd.Read())
{
bd.maBaiDang = (int)rd["maBaiDang"];
bd.maNhaTuyenDung = (int)rd["maNhaTuyenDung"];
bd.tieuDe = (string)rd["tieuDe"];
bd.viTriCongViec = (string)rd["viTriCongViec"];
bd.maNganhNghe = (int)rd["maNganhNghe"];
bd.moTa = (string)rd["moTa"];
bd.soLuongTuyen = (int)rd["soLuongTuyen"];
bd.mucLuong = (int)rd["mucLuong"];
bd.soDienThoai = (string)rd["soDienThoai"];
bd.diaChi = (string)rd["diaChi"];
}
conn.Close();
return(bd);
}
public bool insertBaiDang(BaiDang bd)
{
Boolean temp = true;
if (bd.ten == null)
{
temp = false;
return(temp);
}
db.BaiDangs.Add(bd);
try
{
db.SaveChanges();
db.SaveChangesAsync();
db.SaveChanges();
}
catch (Exception ex)
{
temp = false;
}
return(temp);
}
public void setBaiDang(BaiDang bd1)
{
bd = bd1;
}
public void LoadData()
{
BaiDang.DataSource = obj.getBaiDang();
BaiDang.DataBind();
}
public void BaiDang(BaiDang donh)
{
donhang = donh;
}
public ActionResult UploadH(BaiDang viewModel, HttpPostedFileBase file)
{
if (file != null)
{
string path = Path.Combine(Server.MapPath("~/Image"),
Path.GetFileName(file.FileName));
file.SaveAs(path);
string s = "/Image/" + Path.GetFileName(file.FileName);
viewModel.hinhanh = s;
}
UserLogin a = (UserLogin)Session[CommonConstrants.USER_SESSION];
var BDsum = new BaiDangDAO();
viewModel.mataikhoan = a.ID;
string TacGia = Request.Form["TacGia"];
string NXB = Request.Form["NXB"];
string tenTheLoai = Request.Form["TheLoai"];
if (TacGia != null)
{
TacGia tempTG = new TacGia();
tempTG = BDsum.getTacGiabyTen(TacGia);
if (tempTG != null)
{
viewModel.setTG(tempTG);
}
else
{
if (BDsum.insertTacGia(TacGia))
{
tempTG = BDsum.getTacGiabyTen(TacGia);
viewModel.setTG(tempTG);
}
else
{
Response.Write("<script type=\"text/javascript\">alert('Insert tác giả không thành công!!! ');</script>");
}
}
}
if (NXB != null)
{
NhaXuatBan tempTG = new NhaXuatBan();
tempTG = BDsum.getNXBbyTen(NXB);
if (tempTG != null)
{
viewModel.NhaXuatBan = tempTG;
}
else
{
if (BDsum.insertNXB(NXB))
{
tempTG = BDsum.getNXBbyTen(NXB);
viewModel.NhaXuatBan = tempTG;
}
else
{
Response.Write("<script type=\"text/javascript\">alert('Insert NXB không thành công!!! ');</script>");
}
}
}
if (tenTheLoai != null)
{
TheLoai tempTG = new TheLoai();
tempTG = BDsum.getTheloaibyTen(tenTheLoai);
if (tempTG != null)
{
viewModel.TheLoai = tempTG;
}
else
{
if (BDsum.insertTheLoai(tenTheLoai))
{
tempTG = BDsum.getTheloaibyTen(tenTheLoai);
viewModel.TheLoai = tempTG;
}
else
{
Response.Write("<script type=\"text/javascript\">alert('Insert TheLoai không thành công!!! ');</script>");
}
}
}
if (BDsum.insertBaiDang(viewModel))
{
Response.Write("<script type=\"text/javascript\">alert('Tạo Bài đăng thành công !!! ');</script>");
return(View("Index", BDsum.getListBaiDang2(a.ID)));
}
else
{
Response.Write("<script type=\"text/javascript\">alert('Tạo Bài đăng ko thành công !!! ');</script>");
return(View("create", viewModel));
}
}
