/// <summary> /// Phương thức thêm mới nhân viên /// </summary> /// <param name="userName"></param> /// <param name="hoTen"></param> /// <param name="email"></param> /// <param name="sdt"></param> /// <param name="soThe"></param> /// <param name="gioiTinh"></param> /// <param name="ngaySinh"></param> /// <param name="passWord"></param> /// <param name="idXaPhuong"></param> public static void ThemMoiNhanVien(string userName, string hoTen, string email, string sdt, string soThe, string gioiTinh, string ngaySinh, string passWord, string idXaPhuong) { DateTime ns = XuLyNgayThang.XuLyChuoiNgayThang(ngaySinh); int idXP = int.Parse(idXaPhuong); bool gt = (gioiTinh == "Nam") ? true : false; DAL.DAL_QuanLyTaiKhoan.DAL_NhanVien.Nhanvien_Inser(userName, hoTen, email, sdt, soThe, gt, ns, passWord, idXP); }
/// <summary> /// Phương thức thêm mới phim /// </summary> /// <param name="tenPhim"></param> /// <param name="anhDaiDien"></param> /// <param name="maTheLoai"></param> /// <param name="maQuocGia"></param> /// <param name="thoiLuong"></param> /// <param name="khoiChieu"></param> /// <param name="ketThuc"></param> /// <param name="daoDien"></param> /// <param name="noiDung"></param> /// <param name="trailer"></param> /// <param name="maDinhDang"></param> /// <param name="maNhanVien"></param> public static void Themmoiphim(string tenPhim, string anhDaiDien, int maTheLoai, int maQuocGia, string thoiLuong, string khoiChieu, string ketThuc, string daoDien, string noiDung, string trailer, int maDinhDang, int maNhanVien) { DateTime kc, kt; kc = XuLyNgayThang.XuLyChuoiNgayThang(khoiChieu); kt = XuLyNgayThang.XuLyChuoiNgayThang(ketThuc); DAL.DAL_QuanLyPhim.DAL_Phim.Phim_Inser(tenPhim, anhDaiDien, maTheLoai, maQuocGia, thoiLuong, kc, kt, daoDien, noiDung, trailer, maDinhDang, maNhanVien); }
/// <summary> /// Phương thức thêm mới thành viên /// </summary> /// <param name="hoTen"></param> /// <param name="email"></param> /// <param name="sdt"></param> /// <param name="soThe"></param> /// <param name="gioiTinh"></param> /// <param name="ngaySinh"></param> /// <param name="passWord"></param> /// <param name="idXaPhuong"></param> /// <param name="trangThai"></param> public static void ThemMoiThanhVien(string hoTen, string email, string sdt, string soThe, string gioiTinh, string ngaySinh, string passWord, string idXaPhuong, string trangThai) { DateTime ns = XuLyNgayThang.XuLyChuoiNgayThang(ngaySinh); int idXP = int.Parse(idXaPhuong); bool gt = (gioiTinh == "Nam") ? true : false; bool tt = (trangThai == "Đã kích hoạt") ? true : false; DAL.DAL_QuanLyTaiKhoan.DAL_ThanhVien.ThanhVien_Inser(hoTen, email, sdt, soThe, gt, ns, MaHoa.MaHoaMD5(passWord), idXP, tt); }
/// <summary> /// Phương thức cập nhật KTG /// </summary> /// <param name="maKTG"></param> /// <param name="ngayChieu"></param> /// <param name="gioChieu"></param> public static void CapNhatKTG(int maKTG, string ngayChieu, string gioChieu) { DataTable dt = DAL.DAL_QuanLyLichChieu.DAL_KhungThoiGian.ThongTinKTGTheoMa(maKTG); if (dt.Rows.Count > 0) { DateTime nc = XuLyNgayThang.XuLyChuoiNgayThang(ngayChieu); DAL.DAL_QuanLyLichChieu.DAL_KhungThoiGian.KTG_Update(maKTG, nc, gioChieu); } }
/// <summary> /// Phương thức cập nhật nhân viên /// </summary> /// <param name="userName"></param> /// <param name="hoTen"></param> /// <param name="email"></param> /// <param name="sdt"></param> /// <param name="soThe"></param> /// <param name="gioiTinh"></param> /// <param name="ngaySinh"></param> /// <param name="passWord"></param> /// <param name="idXaPhuong"></param> /// <param name="maNhanVien"></param> public static void CapNhatNhanVien(string userName, string hoTen, string email, string sdt, string soThe, string gioiTinh, string ngaySinh, string passWord, string idXaPhuong, int maNhanVien) { DataTable dt = DAL.DAL_QuanLyTaiKhoan.DAL_NhanVien.LayNhanvienTheoMa(maNhanVien); if (dt.Rows.Count > 0) { DateTime ns = XuLyNgayThang.XuLyChuoiNgayThang(ngaySinh); int idXP = int.Parse(idXaPhuong); bool gt = (gioiTinh == "Nam" || gioiTinh == "nam") ? true : false; DAL.DAL_QuanLyTaiKhoan.DAL_NhanVien.Nhanvien_Update(userName, hoTen, email, sdt, soThe, gt, ns, passWord, idXP, maNhanVien); } }
/// <summary> /// Phương thức cập nhật phim /// </summary> /// <param name="maPhim"></param> /// <param name="tenPhim"></param> /// <param name="anhDaiDien"></param> /// <param name="maTheLoai"></param> /// <param name="maQuocGia"></param> /// <param name="thoiLuong"></param> /// <param name="khoiChieu"></param> /// <param name="ketThuc"></param> /// <param name="daoDien"></param> /// <param name="noiDung"></param> /// <param name="trailer"></param> /// <param name="maDinhDang"></param> /// <param name="maNhanVien"></param> public static void CapNhatPhim(int maPhim, string tenPhim, string anhDaiDien, int maTheLoai, int maQuocGia, string thoiLuong, string khoiChieu, string ketThuc, string daoDien, string noiDung, string trailer, int maDinhDang, int maNhanVien) { DataTable dt = DAL.DAL_QuanLyPhim.DAL_Phim.ThongTinPhimTheoMa(maPhim); if (dt.Rows.Count > 0) { DateTime kc, kt; kc = XuLyNgayThang.XuLyChuoiNgayThang(khoiChieu); kt = XuLyNgayThang.XuLyChuoiNgayThang(ketThuc); DAL.DAL_QuanLyPhim.DAL_Phim.Phim_Update(maPhim, tenPhim, anhDaiDien, maTheLoai, maQuocGia, thoiLuong, kc, kt, daoDien, noiDung, trailer, maDinhDang, maNhanVien); } }
/// <summary> /// Phương thức cập nhật Thành viên /// </summary> /// <param name="hoTen"></param> /// <param name="email"></param> /// <param name="sdt"></param> /// <param name="soThe"></param> /// <param name="gioiTinh"></param> /// <param name="ngaySinh"></param> /// <param name="passWord"></param> /// <param name="idXaPhuong"></param> /// <param name="trangThai"></param> /// <param name="maThanhVien"></param> public static void CapNhatThanhVien(string hoTen, string email, string sdt, string soThe, string gioiTinh, string ngaySinh, string passWord, string idXaPhuong, string trangThai, int maThanhVien) { DataTable dt = DAL.DAL_QuanLyTaiKhoan.DAL_ThanhVien.ThongTinThanhVienByMa(maThanhVien); if (dt.Rows.Count > 0) { DateTime ns = XuLyNgayThang.XuLyChuoiNgayThang(ngaySinh); int idXP = int.Parse(idXaPhuong); bool gt = (gioiTinh == "Nam") ? true : false; bool tt = (trangThai == "Đã kích hoạt") ? true : false; DAL.DAL_QuanLyTaiKhoan.DAL_ThanhVien.ThanhVien_Update(hoTen, email, sdt, soThe, gt, ns, passWord, idXP, tt, maThanhVien); } }
/// <summary> /// Thêm mới KTG /// </summary> /// <param name="ngayChieu"></param> /// <param name="gioChieu"></param> public static void ThemMoiKTG(string ngayChieu, string gioChieu) { DateTime nc = XuLyNgayThang.XuLyChuoiNgayThang(ngayChieu); DAL.DAL_QuanLyLichChieu.DAL_KhungThoiGian.KTG_Insert(nc, gioChieu); }
public ActionResult Update_UserMetas(HttpPostedFileBase file) { try { DataSet ds = new DataSet(); if (Request.Files["file"].ContentLength > 0) { string fileExtension = System.IO.Path.GetExtension(Request.Files["file"].FileName); if (fileExtension == ".xls" || fileExtension == ".xlsx") { string fileLocation = Server.MapPath("~/Content/") + Request.Files["file"].FileName; if (System.IO.File.Exists(fileLocation)) { System.IO.File.Delete(fileLocation); } Request.Files["file"].SaveAs(fileLocation); string excelConnectionString = string.Empty; excelConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + fileLocation + ";Extended Properties=\"Excel 12.0;HDR=Yes;IMEX=2\""; //connection String for xls file format. if (fileExtension == ".xls") { excelConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + fileLocation + ";Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=2\""; } //connection String for xlsx file format. else if (fileExtension == ".xlsx") { excelConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + fileLocation + ";Extended Properties=\"Excel 12.0;HDR=Yes;IMEX=2\""; } //Create Connection to Excel work book and add oledb namespace OleDbConnection excelConnection = new OleDbConnection(excelConnectionString); excelConnection.Open(); DataTable dt = new DataTable(); dt = excelConnection.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null); if (dt == null) { return(null); } String[] excelSheets = new String[dt.Rows.Count]; int t = 0; //excel data saves in temp file here. foreach (DataRow row in dt.Rows) { excelSheets[t] = row["TABLE_NAME"].ToString(); t++; } OleDbConnection excelConnection1 = new OleDbConnection(excelConnectionString); string query = string.Format("Select * from [{0}]", excelSheets[0]); using (OleDbDataAdapter dataAdapter = new OleDbDataAdapter(query, excelConnection1)) { dataAdapter.Fill(ds); } } if (fileExtension.ToString().ToLower().Equals(".xml")) { string fileLocation = Server.MapPath("~/Content/") + Request.Files["FileUpload"].FileName; if (System.IO.File.Exists(fileLocation)) { System.IO.File.Delete(fileLocation); } Request.Files["FileUpload"].SaveAs(fileLocation); XmlTextReader xmlreader = new XmlTextReader(fileLocation); // DataSet ds = new DataSet(); ds.ReadXml(xmlreader); xmlreader.Close(); } so_dong_thanh_cong = 0; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { string usname = ds.Tables[0].Rows[i][0].ToString(); var query = (from u in db.USERS where u.USERNAME == usname select u).FirstOrDefault(); int id = query.USER_ID; var query_meta = (from u in db.USER_METAS where u.USER_ID == id select u).FirstOrDefault(); //query.USERNAME = ds.Tables[0].Rows[i][0].ToString(); query_meta.DEPARTMENT_ID = ds.Tables[0].Rows[i][1].ToString(); query_meta.SEX = ds.Tables[0].Rows[i][2].ToString(); query_meta.BIRTHDAY = xuLyNgayThang.XuLyChuoiNgayThang(ds.Tables[0].Rows[i][3].ToString()); query_meta.START_TIME = xuLyNgayThang.XuLyChuoiNgayThang(ds.Tables[0].Rows[i][4].ToString()); query_meta.NUMBER_PHONE = ds.Tables[0].Rows[i][5].ToString(); query_meta.SENIORITY = ds.Tables[0].Rows[i][6].ToString(); query_meta.NATIVE_LAND = ds.Tables[0].Rows[i][7].ToString(); query_meta.LITERACY = ds.Tables[0].Rows[i][8].ToString(); //db.USERS.Add(query); db.SaveChanges(); so_dong_thanh_cong++; } } } catch (Exception Ex) { ViewBag.Error = " Đã xảy ra lỗi, Liên hệ ngay với admin. " + Environment.NewLine + " Thông tin chi tiết về lỗi:" + Environment.NewLine + Ex; } finally { ViewBag.Message = "Đã import thành công " + so_dong_thanh_cong + " dòng"; } return(View()); }