public async Task <int> SuaCongTy(CongTyRequest model)
{
CongTy detailCompany = _context.CongTys.Where(a => a.ID_CongTy == model.ID_CongTy).FirstOrDefault();
if (detailCompany == null)
{
throw new Exception("Công ty không tồn tại.");
}
detailCompany.TenCongTy = model.TenCongTy;
detailCompany.DiaChiCongTy = model.DiaChiCongTy;
detailCompany.MaCongTy = model.MaCongTy;
detailCompany.EmailCongTy = model.EmailCongTy;
detailCompany.NguoiDaiDien = model.NguoiDaiDien;
detailCompany.Hotline = model.Hotline;
detailCompany.DienThoaiBan = model.DienThoaiBan;
detailCompany.SoDiDong = model.SoDiDong;
detailCompany.Note = model.Note;
detailCompany.CreateDate = DateTime.Now;
detailCompany.LastModifiedDate = DateTime.Now;
detailCompany.Delete = false;
detailCompany.ModifyBy = model.ModifyBy;
detailCompany.AnhDaiDien = model.AnhDaiDien;
detailCompany.CreateBy = model.CreateBy;
detailCompany.TrangThai = model.TrangThai;
_context.CongTys.Update(detailCompany);
await _context.SaveChangesAsync();
return(detailCompany.ID_CongTy);
}
public async Task Update(CongTy congty)
{
CongTy newcongty = await newContext.CongTy.FindAsync(congty.CongTyID);
newcongty = congty;
await newContext.SaveChangesAsync();
}
public async Task <int> ThemCongTy(CongTyRequest model)
{
CongTy congty = new CongTy();
congty.TenCongTy = model.TenCongTy;
congty.DiaChiCongTy = model.DiaChiCongTy;
congty.MaCongTy = model.MaCongTy;
congty.EmailCongTy = model.EmailCongTy;
congty.NguoiDaiDien = model.NguoiDaiDien;
congty.Hotline = model.Hotline;
congty.DienThoaiBan = model.DienThoaiBan;
congty.SoDiDong = model.SoDiDong;
congty.Note = model.Note;
congty.CreateDate = DateTime.Now;
congty.LastModifiedDate = DateTime.Now;
congty.Delete = false;
congty.ModifyBy = model.ModifyBy;
congty.AnhDaiDien = model.AnhDaiDien;
congty.CreateBy = model.CreateBy;
congty.TrangThai = model.TrangThai;
_context.CongTys.Add(congty);
await _context.SaveChangesAsync();
return(congty.ID_CongTy);
}
private void LoadDSCongTy( )
{
cboCongTy.ValueMember = "CongTyID";
cboCongTy.DisplayMember = "TenCongTy";
cboCongTy.DataSource = null;
cboCongTy.DataSource = CongTy.GetAllDSCongTy();
}
public async Task Remove(int ID)
{
CongTy congty = await newContext.CongTy.FindAsync(ID);
newContext.Remove(congty);
await newContext.SaveChangesAsync();
}
private void LoadDSCongTy()
{
comboBox1.ValueMember = "CongTyID";
comboBox1.DisplayMember = "TenCongTy";
comboBox1.DataSource = CongTy.GetListOfCongTys_NAME();
comboBox1.SelectedIndex = 0;
}
//thêm công ty
public static Boolean ThemCongTy(CongTiesViewModel CT)
{
var entity = new QuanLyThueXeEntities();
try
{
var Ct = new CongTy();
Ct.MaCongTy = TuTangMaCT();
Ct.TenCongTy = CT.TenCongTy;
Ct.Email = CT.Email;
Ct.DiaChi = CT.DiaChi;
Ct.SDT = CT.SDT;
Ct.Fax = CT.Fax;
Ct.NguoiLienHe = CT.NguoiLienHe;
Ct.GhiChu = CT.GhiChu;
Ct.Dang = true;
entity.CongTies.Add(Ct);
entity.SaveChanges();
return(true);
}
catch (Exception ex)
{
entity.Dispose();
return(false);
}
}
public void LuuCongTy(CongTy ct)
{
string sql = "INSERT INTO CongTy(TenCongTy, TenDangNhap, MatKhau, DiaChi, QuyMo, SDT, Mota, NguoiDaiDien, Email, ID_ThanhPho) "
+ "VALUES (N'" + ct.TenCongTy + "', '" + ct.TenDangNhap + "', '" + ct.MatKhau + "', N'" + ct.DiaChi + "', N'" + ct.QuyMo + "','" + ct.SDT + "',N'" + ct.MoTa + "', N'" + ct.NguoiDaiDien + "', '" + ct.Email + "', '" + ct.ID_ThanhPho + "')";
data.NowR(sql);
}
protected void btnCT_DangNhap_Click(object sender, EventArgs e)
{
string matkhau = encrypt.GetMD5(txtCT_MatKhau.Text);
var kq = ctbll.KiemTraTenDangNhapCT(txtCT_TenDangNhap.Text.Trim());
if (kq == true)
{
//Session.SetCurrent_NhaTuyenDung(kq, kq);
CongTy current_ct = new CongTy();
current_ct = ctbll.Get_CongTy(txtCT_TenDangNhap.Text.Trim());
Session["NhaTuyenDung"] = current_ct;
Session["TenDangNhap"] = current_ct.TenDangNhap;
Session["TenCongTy"] = current_ct.TenCongTy;
Session["IDCongTy"] = current_ct.ID_CongTy;
string returnUrl = Request.QueryString["returnUrl"];
if (!string.IsNullOrEmpty(returnUrl))
{
Response.Redirect(returnUrl);
}
else
{
Response.Redirect("NhaTuyenDung.aspx");
}
}
else
{
Response.Write("<script> alert('Đăng nhập không thành công.')</script>");
}
}
public async Task <IActionResult> Edit(int id, [Bind("CongTyID,TenCongTy,NhanVienID,ThamNienID")] CongTy congTy)
{
if (id != congTy.CongTyID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(congTy);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!CongTyExists(congTy.CongTyID))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["NhanVienID"] = new SelectList(_context.NhanVien, "NhanVienID", "TenNhanVien", congTy.NhanVienID);
ViewData["ThamNienID"] = new SelectList(_context.ThamNien, "ThamNienID", "ThamNienID", congTy.ThamNienID);
return(View(congTy));
}
public CongTy Get_CongTy(string tendangnhap)
{
CongTy ct = new CongTy();
try
{
string kq = "Select * From CongTy Where TenDangNhap = '" + tendangnhap + "'";
DataTable mytable = new DataTable();
//UngVienDTO ct = new UngVienDTO();
ct.ID_CongTy = Convert.ToInt32(data.GetTable(kq).Rows[0][0]);
ct.TenCongTy = data.GetTable(kq).Rows[0][1].ToString();
ct.TenDangNhap = data.GetTable(kq).Rows[0][2].ToString();
ct.MatKhau = data.GetTable(kq).Rows[0][3].ToString();
ct.DiaChi = data.GetTable(kq).Rows[0][4].ToString();
ct.QuyMo = data.GetTable(kq).Rows[0][5].ToString();
ct.SDT = data.GetTable(kq).Rows[0][6].ToString();
ct.MoTa = data.GetTable(kq).Rows[0][8].ToString();
ct.NguoiDaiDien = data.GetTable(kq).Rows[0][9].ToString();
ct.Email = data.GetTable(kq).Rows[0][10].ToString();
ct.ID_ThanhPho = Convert.ToInt32(data.GetTable(kq).Rows[0][11]);
return(ct);
}
catch
{
return(ct);
}
}
public CongTyMap(CongTy item, IEnumerable <ThuocTinh> _thuoc_tinh)
{
id_cong_ty = item.id_cong_ty;
ten_cong_ty = item.ten_cong_ty;
app_id = item.app_id;
dia_chi = item.dia_chi;
dien_thoai = item.dien_thoai;
ghi_chu = item.ghi_chu;
info_gui_hop_dong = item.info_gui_hop_dong;
info_tax = item.info_tax;
lien_he = item.lien_he;
ma_so_thue = item.ma_so_thue;
ngay_sua = item.ngay_sua;
ngay_tao = item.ngay_tao;
nguoi_sua = item.nguoi_sua;
nguoi_tao = item.nguoi_tao;
so_dkkd = item.so_dkkd;
tai_khoan_ngan_hang = item.tai_khoan_ngan_hang;
trang_thai = item.trang_thai;
website = item.website;
ngay_sua = item.ngay_sua;
ngay_tao = item.ngay_tao;
nguoi_tao = item.nguoi_tao;
nguoi_sua = item.nguoi_sua;
auto_id = item.auto_id;
thuoc_tinh = _thuoc_tinh.Select(x => new { gia_tri = x.gia_tri, ten = x.ten, nhom = x.nhom, type = x.type });
}
protected void Page_Load(object sender, EventArgs e)
{
ThongTinCongTy.Visible = true;
SuaThongTinCongTy.Visible = false;
if (!Page.IsPostBack)
{
LoadThanhPho();
EnableTextBox(false);
}
string tendangnhap = (string)Session["TenDangNhap"];
CongTy ct = new CongTy();
ct = ctbll.Get_CongTy(tendangnhap);
if (ct != null)
{
CurrentID = ct.ID_CongTy;
lblNTD_DiaChi.Text = ct.DiaChi;
lblNTD_Email.Text = ct.Email;
lblNTD_MoTa.Text = ct.MoTa;
lblNTD_NguoiDaiDien.Text = ct.NguoiDaiDien;
lblNTD_SDT.Text = ct.SDT;
lblNTD_TenCongTy.Text = ct.TenCongTy;
lblNTD_QuyMo.Text = ct.QuyMo;
}
}
public ActionResult Login(Employer model, string returnurl)
{
var result = new LoginMember().LoginEmployer(model.Emaildangnhap, LoginMember.MD5Hash(model.Matkhau));
if (result == 1)
{
var user = db.CongTies.Where(x => x.Emaildangnhap == model.Emaildangnhap).FirstOrDefault();
Session["Employer"] = new CongTy()
{
MACT = user.MACT, Emaildangnhap = user.Emaildangnhap, Tinhtrang = user.Tinhtrang
};
user.matkhaureset = null;
db.SaveChanges();
if (returnurl == null || returnurl == "")
{
return(RedirectToAction("Index", "Employer"));
}
else
{
return(Redirect(returnurl));
}
}
else if (result == 2)
{
ModelState.AddModelError("", "Tài khoản Chưa được Kích hoạt");
TempData["Error"] = "Tài khoản Chưa được Kích hoạt";
return(Redirect(Request.UrlReferrer.ToString()));
}
else
{
ModelState.AddModelError("", "Email hoặc mật khẩu không chính xác");
TempData["Error"] = "Email hoặc mật khẩu không chính xác";
return(Redirect(Request.UrlReferrer.ToString()));
}
}
private void LoadDSCongTy(int CongTyID)
{
cboCongTy.ValueMember = "CongTyID";
cboCongTy.DisplayMember = "TenCongTy";
cboCongTy.DataSource = null;
cboCongTy.DataSource = CongTy.GetAllDSCongTy();
if (CongTyID > 0)
{
int iIndex = -1;
foreach (Janus.Windows.EditControls.UIComboBoxItem objItem in cboCongTy.Items)
{
iIndex += 1;
if (objItem.Value.ToString() == CongTyID.ToString())
{
break;
}
}
cboCongTy.SelectedIndex = iIndex;
}
else
{
cboCongTy.SelectedIndex = 0;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
loadNganh();
loadThanhPho();
loadTrinhDo();
loadViTri();
loadKinhNghiem();
loadSearchNganh();
loadSearchThanhPho();
// ứng viên
UngVienDTO uv = new UngVienDTO();
if (Session["UngVien"] != null)
{
lblDefault_User.Text = "Xin chào: ";
lbtDefault_User.Text = (String)Session["TenUV"];
lblDefault_User.Visible = true;
}
// nhà tuyển dụng
if (Session["NhaTuyenDung"] != null)
{
lblDefault_User.Text = "Xin chào: ";
string tendangnhap = (string)Session["TenDangNhap"];
CongTy ct = new CongTy();
ct = ctbll.Get_CongTy(tendangnhap);
lbtDefault_User.Text = ct.TenCongTy;
lblDefault_User.Visible = true;
}
}
}
public ActionResult ChangeCauHinhWeb(HttpPostedFileBase cauhinh_logo, string ten_congty, int id, string ten_viet_tat, string ten_viet_tat_nm, string ten_nha_may, int id_nm, string dia_chi_nm)
{
string fileName = "default_logo.png";
try
{
if (cauhinh_logo != null)
{
//fileName = System.IO.Path.GetFileName(cauhinh_logo.FileName)+"/"+ id;
fileName = "logoFactory_" + id + ".png";
string path_avatar = System.IO.Path.Combine(Server.MapPath("~/images/logoFactory"), fileName);
// file is uploaded
cauhinh_logo.SaveAs(path_avatar);
}
CongTy ct = CongTyDAO.getCongTyById(id);
if (ct == null)
{
return(Json(new { success = false, message = "Không tìm thấy thông tin công ty" }));
}
ct.Logo = fileName;
ct.TenCongTy = ten_congty;
ct.TenVietTat = ten_viet_tat;
var rs = CongTyDAO.updateCongTyInformation(ct);
NhaMay nm = NhaMayDAO.GetNhaMayById(id_nm);
if (nm == null)
{
return(Json(new { success = false, message = "Không tìm thấy thông tin nhà máy" }));
}
nm.TenNhaMay = ten_nha_may;
nm.TenVietTat = ten_viet_tat_nm;
nm.DiaChi = dia_chi_nm;
var rs_nm = NhaMayDAO.updateNhaMayInformation(nm);
if (rs != "success")
{
return(Json(new { success = false, message = rs }));
}
if (rs_nm != "success")
{
return(Json(new { success = false, message = rs_nm }));
}
Session["CongTy"] = ct;
Session["NhaMay"] = nm;
return(Json(new { success = true, message = string.Empty }));
}
catch
{
return(Json(new { success = false, message = "Không thể truy cập cơ sở dữ liệu" }));
}
}
public bool Update(CongTy data)
{
string id = $"{data.id_cong_ty}";
data.id_cong_ty = string.Empty;
data.ngay_sua = XMedia.XUtil.TimeInEpoch(DateTime.Now);
return(Update(_default_index, data, id));
}
public string Index(CongTy data)
{
data.auto_id = GenAutoId(data.app_id);
if (data.auto_id > 0)
{
return(Index <CongTy>(_default_index, data));
}
return("");
}
public void LoadDSCongTy()
{
cbCongTy.ValueMember = "CongTyID";
cbCongTy.DisplayMember = "TenCongTy";
cbCongTy.DataSource = null;
DataTable a = CongTy.GetListOfCongTys_NAME();
cbCongTy.DataSource = CongTy.GetListOfCongTys_NAME();
cbCongTy.SelectedIndex = 0;
}
public ActionResult QuanTriCauHinh()
{
//id cong ty default
CauHinhWebViewModel model = new CauHinhWebViewModel();
CongTy ct = (CongTy)Session["CongTy"];
NhaMay nm = (NhaMay)Session["NhaMay"];
model.ct = ct;
model.nm = nm;
return(View(model));
}
public static CongTy LayDL()
{
DataTable data = DataProvider.Instance.ExecuteQuery("select * from CongTy");
CongTy ct = new CongTy();
DataRow r = data.Rows[0];
ct.ChuTich = r["ChuTich"].ToString();
ct.TenCty = r["TenCTy"].ToString();
ct.HotLine = r["HotLine"].ToString();
ct.DiaChi = r["DiaChi"].ToString();
return(ct);
}
private void btnThemNhanVien_Click(object sender, EventArgs e)
{
if (txbHoTen.Text == "")
{
MessageBox.Show("Tên Cty không được để trống", "Lưu ý");
return;
}
double a;
double.TryParse(txbLuong.Text, out a);
if (a == 0)
{
MessageBox.Show("Lương không hợp lệ !", "Lưu ý");
return;
}
else
{
if (a < 300)
{
MessageBox.Show("Lương phải từ 300USB trở lên !", "Lưu ý :");
return;
}
}
companyDB.OpenDB();
CongTy cty = companyDB.DB.Query(delegate(CongTy c)
{
if (c.TenCongTy == cbbHomebase.Text)
{
return(true);
}
return(false);
}).FirstOrDefault();
var nv = new NhanVien
{
ID = Guid.NewGuid(),
HoTen = txbHoTen.Text,
Skill = txbSkill.Text,
HomeBase = cty,
QuanLy = null,
Luong = Double.Parse(txbLuong.Text)
};
employeeDB.InsertObject <NhanVien>(nv);
companyDB.CloseDB();
}
public FrmCTy()
{
InitializeComponent();
try
{
CongTy ct = CongTyDAO.LayDL();
txtCT.Text = ct.ChuTich;
txtDC.Text = ct.DiaChi;
txtHotLine.Text = ct.HotLine;
txtTen.Text = ct.TenCty;
}
catch { }
}
public void TestMySqlAddCongTy1()
{
CongTy cty = new CongTy();
cty.MaCongTy = "congty001";
cty.TenCongTy = "ten";
cty.DiaChiWeb = "diachiweb";
cty.DiaChiTruSo = "diachi";
cty.Sdt = "0011";
int result = congTy.MySqlAddCongTy(cty);
Assert.That(result, Is.EqualTo(0));
}
public async Task <IActionResult> Create([Bind("CongTyID,TenCongTy,NhanVienID,ThamNienID")] CongTy congTy)
{
if (ModelState.IsValid)
{
_context.Add(congTy);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["NhanVienID"] = new SelectList(_context.NhanVien, "NhanVienID", "TenNhanVien", congTy.NhanVienID);
ViewData["ThamNienID"] = new SelectList(_context.ThamNien, "ThamNienID", "ThamNienID", congTy.ThamNienID);
return(View(congTy));
}
public bool Exit(int ID)
{
CongTy congty = newContext.CongTy.Find(ID);
if (congty != null)
{
return(true);
}
else
{
return(false);
}
}
private void button1_Click(object sender, EventArgs e)
{
IObjectContainer db = Db4oEmbedded.OpenFile("ADBTeamTPTPT_EmployeeManage.yap");
CongTy add = new CongTy(textBox1.Text, textBox2.Text, textBox3.Text, textBox4.Text, textBox5.Text);
db.Store(add);
textBox1.Text = "";
textBox2.Text = "";
textBox3.Text = "";
textBox4.Text = "";
textBox5.Text = "";
db.Close();
}
// GET: Account
public ActionResult Login()
{
CongTy ct = CongTyDAO.getCongTyByDefault();
Session["CongTy"] = ct;
NhaMay nm = NhaMayDAO.GetNhaMayByDefault();
Session["NhaMay"] = nm;
if (User.Identity.IsAuthenticated)
{
return(RedirectToAction("Index", "Home"));
}
return(View());
}
private CongTy ConvertDoc(IHit <CongTy> hit)
{
CongTy u = new CongTy();
try
{
u = hit.Source;
u.id_cong_ty = hit.Id;
}
catch
{
}
return(u);
}
