public string DatHang(string noigiaoSP)
{
dondat dd = new dondat();
List <ItemGioHang> kq = Session["cart"] as List <ItemGioHang>;
thanhvien tv = Session["login"] as thanhvien;
if (kq == null || tv == null)
{
return("err");
}
else
{
dd.TenDangNhap = tv.TenDangNhap;
dd.TrangThai = "Đã đặt hàng, chờ xác nhận";
dd.NoiGiao = noigiaoSP;
dd.NgayDat = DateTime.Now;
db.dondats.Add(dd);
foreach (var item in kq)
{
ct_dondat ctdd = new ct_dondat();
ctdd.MaDonDat = dd.MaDonDat;
ctdd.MaSanPham = item.MaSP;
ctdd.SoLuong = item.SoLuong;
db.ct_dondat.Add(ctdd);
}
db.SaveChanges();
Session["cart"] = null;
return("ok");
}
}
public bool Them_NV(thanhvien tv)
{
string query = $"Insert into Thanhvien(MaTV,STT,hoten,loaithanhvien,soDT,email,diachi,diemtichluy) values(N'{tv._matv}',{tv._stt},N'{tv._hoten}',N'{tv._loaitv}',N'{tv._sodt}',N'{tv._email}',N'{tv._diachi}',{tv._diemTl})";
Load_DB(query);
return(true);
}
public bool Sua_NV(thanhvien tv)
{
string query = $"update Thanhvien set Matv=N'{tv._matv}',STT={tv._stt},hoten=N'{tv._hoten}',loaithanhvien=N'{tv._loaitv}',soDT='{tv._sodt}',email=N'{tv._email}',diachi=N'{tv._diachi}',diemtichluy={tv._diemTl} Where MaTV=N'{tv._matv}' ";
Load_DB(query);
return(true);
}
public IHttpActionResult Putthanhvien(int id, thanhvien thanhvien)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != thanhvien.matv)
{
return(BadRequest());
}
db.Entry(thanhvien).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!Exists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult Postthanhvien([FromBody] thanhvien thanhvien)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.thanhviens.Add(thanhvien);
try
{
db.SaveChanges();
}
catch
{
if (thanhvienExists(thanhvien.tendangnhap))
{
return(Conflict());
}
else
{
throw;
}
}
return(CreatedAtRoute("DefaultApi", new { id = thanhvien.matv }, thanhvien));
}
protected void Page_Load(object sender, EventArgs e)
{
if (ViewState["stateThanhVien"] != null)
{
thanhviens = (List <thanhvien>)ViewState["stateThanhVien"];
}
else
{
thanhviens = new List <thanhvien>();
}
GridView1.DataSource = thanhviens;
GridView1.DataBind();
if (!IsPostBack)
{
DateTime ngaybatdau = new DateTime();
DateTime ngayketthuc = new DateTime();;
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["connstring"].ToString()))
{
// Goi cau lenh procedure
using (SqlCommand cmd = new SqlCommand("THOIGIANDANGKY_GETTIME1", conn))
{
//Gan keu truy van la Procedure
cmd.CommandType = CommandType.StoredProcedure;
//Truyen bien vao cau lenh
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
ngaybatdau = reader.GetDateTime(1);
ngayketthuc = reader.GetDateTime(2);
}
conn.Close();
}
if (DateTime.Now < ngaybatdau || DateTime.Now > ngayketthuc)
{
Response.Redirect("baoloithoigiandangky.aspx");
}
thanhviens = new List <thanhvien>();
taoma tm = new taoma();
txtMaDeTai.Text = tm.taomangaunhien("DX");
thanhvien tv1 = new thanhvien();
tv1.MaNV = ((dangnhapnguoidung)Session["dangnhap"]).cb_id;
tv1.Hoten = ((dangnhapnguoidung)Session["dangnhap"]).cb_hoten;
tv1.Vitri = "Chủ nhiệm đề tài";
tv1.Email = ((dangnhapnguoidung)Session["dangnhap"]).cb_email;
thanhviens.Add(tv1);
ViewState["stateThanhVien"] = thanhviens;
GridView1.DataSource = thanhviens;
GridView1.DataBind();
}
}
}
public ActionResult Updatepass(string user)
{
if (Session["login"] == null)
{
return(RedirectToAction("Index"));
}
thanhvien tv = db.thanhviens.Single(n => n.TenDangNhap == user);
return(PartialView(tv));
}
public IHttpActionResult Getthanhvien(int id)
{
thanhvien thanhvien = db.thanhviens.Find(id);
if (thanhvien == null)
{
return(NotFound());
}
return(Ok(thanhvien));
}
public ActionResult MemberEdit([Bind(Include = "TenDangNhap,MatKhau,HoTen,NgaySinh,GioiTinh,DiaChi,DienThoai,Email,HinhAnh")] thanhvien thanhvien)
{
if (Session["admin"] == null)
{
return(RedirectToAction("Login"));
}
if (ModelState.IsValid)
{
db.Entry(thanhvien).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Member"));
}
return(View(thanhvien));
}
public IHttpActionResult Deletethanhvien(int id)
{
thanhvien thanhvien = db.thanhviens.Find(id);
if (thanhvien == null)
{
return(NotFound());
}
db.thanhviens.Remove(thanhvien);
db.SaveChanges();
return(Ok(thanhvien));
}
public ActionResult Account(string id)
{
thanhvien tamp = db.thanhviens.Find(id);
if (Session["login"] == null)
{
return(RedirectToAction("Index"));
}
if (((thanhvien)Session["login"]).TenDangNhap != tamp.TenDangNhap)
{
return(RedirectToAction("Index"));
}
return(View(tamp));
}
public ActionResult MemberDele(string idloaisp)
{
if (Session["admin"] == null)
{
return(RedirectToAction("Login"));
}
thanhvien ls = db.thanhviens.Find(idloaisp);
if (ls != null)
{
db.thanhviens.Remove(ls);
db.SaveChanges();
}
return(RedirectToAction("Member"));
}
public ActionResult Checkout()
{
thanhvien tv = new thanhvien();
if (Session["login"] != null)
{
thanhvien t = (thanhvien)Session["login"];
tv = db.thanhviens.Find(t.TenDangNhap);
}
List <ItemGioHang> kq = GetGioHang();
ViewBag.cart = kq;
ViewBag.TongTien = TongTien();
return(View(tv));
}
public ActionResult Singup(string url, string username, string password)
{
thanhvien tv = new thanhvien();
tv.TenDangNhap = username;
tv.MatKhau = password;
db.thanhviens.Add(tv);
int sr = db.SaveChanges();
if (sr > 0)
{
Session["login"] = tv;
}
return(Redirect(url));
}
public ActionResult ThemBinhLuan(int?masp, string nd)
{
thanhvien tv = Session["login"] as thanhvien;
if (tv != null)
{
binhluan bl = new binhluan();
bl.MaSanPham = masp;
bl.NoiDungBinhLuan = nd;
bl.TenDangNhap = tv.TenDangNhap;
bl.NgayBinhLuan = DateTime.Now;
db.binhluans.Add(bl);
db.SaveChanges();
}
return(PartialView(db.binhluans.Where(n => n.MaSanPham == masp).ToList()));
}
public ActionResult Account([Bind(Include = "TenDangNhap,MatKhau,HoTen,NgaySinh,GioiTinh,DiaChi,DienThoai,Email,HinhAnh")] thanhvien thanhvien, FormCollection f)
{
string gtt = f["gtinh"].ToString();
if (gtt == "N")
{
thanhvien.GioiTinh = "Nam";
}
else
{
thanhvien.GioiTinh = "Nữ";
}
db.Entry(thanhvien).State = EntityState.Modified;
db.SaveChanges();
return(View(thanhvien));
}
public ActionResult MemberEdit(string id)
{
if (Session["admin"] == null)
{
return(RedirectToAction("Login"));
}
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
thanhvien thanhvien = db.thanhviens.Find(id);
if (thanhvien == null)
{
return(HttpNotFound());
}
return(View(thanhvien));
}
public string Login(string username, string password)
{
thanhvien tv = db.thanhviens.Find(username);
if (tv != null)
{
if (tv.MatKhau != password)
{
return("Tên đăng nhập hoặc mật khẩu không chính xác");
}
else
{
Session["login"] = tv;
return("ok");
}
}
return("Tên đăng nhập hoặc mật khẩu không chính xác");
}
protected void btnthem_Click(object sender, EventArgs e)
{
thanhvien tv = new thanhvien();
tv.MaNV = txtMaCB.Text;
tv.Hoten = txtHoTen.Text;
tv.Vitri = ddlVitri.Text;
tv.Email = txtemail.Text;
thanhviens.Add(tv);
ViewState["stateThanhVien"] = thanhviens;
GridView1.DataSource = thanhviens;
GridView1.DataBind();
txtMaCB.Text = "";
txtHoTen.Text = "";
ddlVitri.Text = "";
txtemail.Text = "";
}
public ActionResult formUpdateBL([Bind(Include = "MaBinhLuan,TenDangNhap,MaSanPham,NgayBinhLuan,NoiDungBinhLuan")] binhluan bl,
int?mabl, string noidungbt, string tdn, int?masp, DateTime nbl)
{
binhluan ble = db.binhluans.Find(mabl);
sanpham sp = db.sanphams.Find(masp);
thanhvien tv = db.thanhviens.Find(tdn);
if (ble == null || sp == null || tv == null)
{
return(null);
}
ble.MaBinhLuan = ble.MaBinhLuan;
ble.NoiDungBinhLuan = noidungbt;
ble.TenDangNhap = tdn;
ble.MaSanPham = masp;
ble.NgayBinhLuan = nbl;
db.Entry(ble).State = EntityState.Modified;
db.SaveChanges();
return(PartialView("ThemBinhLuan", db.binhluans.Where(n => n.MaSanPham == masp).ToList()));
}
protected void Page_Load(object sender, EventArgs e)
{
if (ViewState["stateThanhVien"] != null)
{
thanhviens = (List <thanhvien>)ViewState["stateThanhVien"];
}
else
{
thanhviens = new List <thanhvien>();
}
GridView1.DataSource = thanhviens;
GridView1.DataBind();
if (!IsPostBack)
{
thanhviens = new List <thanhvien>();
//load noi dung de xuat de tai
txtMaThuyetMinh.Text = Session["CapNhatThuyetMinh"].ToString();
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["connstring"].ToString()))
{
// Goi cau lenh procedure
using (SqlCommand cmd = new SqlCommand("THUYETMINHDETAI_SELECT_ROW", conn))
{
//Gan keu truy van la Procedure
cmd.CommandType = CommandType.StoredProcedure;
//Truyen bien vao cau lenh
cmd.Parameters.AddWithValue("@TMDT_ID", txtMaThuyetMinh.Text);
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
txtMaDeTai.Text = reader.GetString(1);
txtTenDeTai.Text = reader.GetString(2);
chuoiLV = reader.GetString(3);
chuoiLH = (reader.IsDBNull(4)? "" : reader.GetString(4));
txtTGThucHien.Text = (reader.IsDBNull(5) ? "" : reader.GetString(5));
txtCQCTDT.Text = (reader.IsDBNull(6) ? "" : reader.GetString(6));
txtSDTCQCTDT.Text = (reader.IsDBNull(7) ? "" : reader.GetString(7));
txtDCCQCTDT.Text = (reader.IsDBNull(8) ? "" : reader.GetString(8));
txtDVTH.Text = (reader.IsDBNull(9) ? "" : reader.GetString(9));
txtSDTDVTH.Text = (reader.IsDBNull(10) ? "" : reader.GetString(10));
txtDCTDVTH.Text = (reader.IsDBNull(11) ? "" : reader.GetString(11));
ckeTrongNuoc.Text = (reader.IsDBNull(12) ? "" : reader.GetString(12));
ckeNgoaiNuoc.Text = (reader.IsDBNull(13) ? "" : reader.GetString(13));
ckeDoiTuongNghienCuu.Text = (reader.IsDBNull(13) ? "" : reader.GetString(29));
ckephamvinghiencuu.Text = (reader.IsDBNull(13) ? "" : reader.GetString(30));
ckecachtiepcan.Text = (reader.IsDBNull(13) ? "" : reader.GetString(31));
ckephuongphapnghiencuu.Text = (reader.IsDBNull(13) ? "" : reader.GetString(32));
ckeTinhCapThiet.Text = reader.GetString(14);
ckeMucTieu.Text = reader.GetString(15);
ckeNoiDung.Text = reader.GetString(16);
chuoispkh = (reader.IsDBNull(17) ? "" : reader.GetString(17));
chuoispdt = (reader.IsDBNull(18) ? "" : reader.GetString(18));
chuoispud = (reader.IsDBNull(19) ? "" : reader.GetString(19));
txtSanPhamKhac.Text = (reader.IsDBNull(20) ? "" : reader.GetString(20));
ckeHieuQua.Text = reader.GetString(21);
ckePTChuyenGiao.Text = (reader.IsDBNull(22) ? "" : reader.GetString(22));
txtGioNCKH.Text = reader.GetString(23);
txtKinhPhi.Text = reader.GetString(24);
txtNganSachTruong.Text = reader.GetString(25);
txtCacNguonKPKhac.Text = reader.GetString(26);
}
conn.Close();
}
}
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["connstring"].ToString()))
{
// Goi cau lenh procedure
using (SqlCommand cmd = new SqlCommand("DKDT_THANHVIEN_SELECTDETAI", conn))
{
//Gan keu truy van la Procedure
cmd.CommandType = CommandType.StoredProcedure;
//Truyen bien vao cau lenh
cmd.Parameters.AddWithValue("@DKDT_ID", txtMaDeTai.Text);
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
thanhvien tv = new thanhvien();
tv.MaNV = reader.GetString(2);
tv.Hoten = reader.GetString(3);
tv.Vitri = reader.GetString(4);
tv.Email = (reader.IsDBNull(5) ? "" : reader.GetString(5));
thanhviens.Add(tv);
}
conn.Close();
GridView1.DataSource = thanhviens;
GridView1.DataBind();
ViewState["stateThanhVien"] = thanhviens;
}
}
for (int i = 0; i < chkspud.Items.Count; i++)
{
if (chuoispud.Contains(chkspud.Items[i].Value.ToString()))
{
chkspud.Items[i].Selected = true;
}
}
for (int i = 0; i < chkspdt.Items.Count; i++)
{
if (chuoispdt.Contains(chkspdt.Items[i].Value.ToString()))
{
chkspdt.Items[i].Selected = true;
}
}
for (int i = 0; i < chkspkh.Items.Count; i++)
{
if (chuoispkh.Contains(chkspkh.Items[i].Value.ToString()))
{
chkspkh.Items[i].Selected = true;
}
}
}
}
public bool Them_NV(thanhvien tv)
{
return(dal.Them_NV(tv));
}
public bool Sua_NV(thanhvien tv)
{
return(dal.Sua_NV(tv));
}
protected void Page_Load(object sender, EventArgs e)
{
if (ViewState["stateThanhVien"] != null)
{
thanhviens = (List <thanhvien>)ViewState["stateThanhVien"];
}
else
{
thanhviens = new List <thanhvien>();
}
GridView1.DataSource = thanhviens;
GridView1.DataBind();
if (!IsPostBack)
{
thanhviens = new List <thanhvien>();
//load noi dung de xuat de tai
txtMaDeTai.Text = Session["CapNhatDeTai"].ToString();
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["connstring"].ToString()))
{
// Goi cau lenh procedure
using (SqlCommand cmd = new SqlCommand("DANGKYDETAI_SELECT_ROW", conn))
{
//Gan keu truy van la Procedure
cmd.CommandType = CommandType.StoredProcedure;
//Truyen bien vao cau lenh
cmd.Parameters.AddWithValue("@DKDT_ID", txtMaDeTai.Text);
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
txtTenDeTai.Text = reader.GetString(1);
chuoiLV = reader.GetString(2);
ckeTinhCapThiet.Text = reader.GetString(3);
ckeMucTieu.Text = reader.GetString(4);
ckeNoiDung.Text = reader.GetString(5);
ckeHieuQua.Text = reader.GetString(6);
ckeSanPham.Text = reader.GetString(7);
txtGioNCKH.Text = reader.GetString(8);
txtKinhPhi.Text = reader.GetString(9);
txtNganSachTruong.Text = reader.GetString(10);
txtCacNguonKPKhac.Text = reader.GetString(11);
txtThoiGianThucHien.Text = reader.GetString(14);
}
conn.Close();
}
}
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["connstring"].ToString()))
{
// Goi cau lenh procedure
using (SqlCommand cmd = new SqlCommand("DKDT_THANHVIEN_SELECTDETAI", conn))
{
//Gan keu truy van la Procedure
cmd.CommandType = CommandType.StoredProcedure;
//Truyen bien vao cau lenh
cmd.Parameters.AddWithValue("@DKDT_ID", txtMaDeTai.Text);
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
thanhvien tv = new thanhvien();
tv.MaNV = reader.GetString(2);
tv.Hoten = reader.GetString(3);
tv.Vitri = reader.GetString(4);
tv.Email = reader.GetString(5);
thanhviens.Add(tv);
}
conn.Close();
GridView1.DataSource = thanhviens;
GridView1.DataBind();
ViewState["stateThanhVien"] = thanhviens;
}
}
}
}
