//xóa LOAI nhân viên
public void xoaLoaiNhanVien(int idLoai)
{
LoaiNV nv = (db.LoaiNVs.Where(p => p.IDLoaiNV == idLoai)).SingleOrDefault();
db.LoaiNVs.DeleteOnSubmit(nv);
db.SubmitChanges();
}
//sửa Loại Nhân viên
public void SuaLoaiNV(int idLoai, String tenL, int hs)
{
LoaiNV nv = (from a in db.LoaiNVs where a.IDLoaiNV == idLoai select a).SingleOrDefault();
nv.TenLoaiNV = tenL;
nv.HeSo = hs;
db.SubmitChanges();
}
public ActionResult DeleteConfirmed(string id)
{
LoaiNV loaiNV = db.LoaiNV.Find(id);
db.LoaiNV.Remove(loaiNV);
db.SaveChanges();
return(RedirectToAction("Index"));
}
private void frmNhanVienEdit_Load(object sender, EventArgs e)
{
//load loại nhân viên
cboLoaiNV.DataSource = LoaiNV.SelectAll();
cboLoaiNV.DisplayMember = "TenLoaiNV";
cboLoaiNV.ValueMember = "MaLoaiNV";
LoadUI(nv);
}
public ActionResult Edit([Bind(Include = "id_LoaiNV,tenLoai,LuongCB,phuCap,chucVu")] LoaiNV loaiNV)
{
if (ModelState.IsValid)
{
db.Entry(loaiNV).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(loaiNV));
}
public ActionResult Edit([Bind(Include = "MaLoaiNV,TenLoaiNV,MoTaLoaiNV,QuyenSD")] LoaiNV loaiNV)
{
if (ModelState.IsValid)
{
db.Entry(loaiNV).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(loaiNV));
}
private void frmQuanLyNhanVien_Load(object sender, EventArgs e)
{
//load loại nhân viên
cboLoaiNV.DataSource = LoaiNV.SelectAll();
cboLoaiNV.DisplayMember = "TenLoaiNV";
cboLoaiNV.ValueMember = "MaLoaiNV";
btnDatLai_Click(sender, e);
btnHienTatCa_Click(sender, e);
}
//thêm LOẠI Nhân Viên
public void ThemLoaiNV(String tenL, int hs)
{
LoaiNV loai = new LoaiNV()
{
TenLoaiNV = tenL, HeSo = hs
};
db.LoaiNVs.InsertOnSubmit(loai);
db.SubmitChanges();
}
public ActionResult Create([Bind(Include = "MaLoaiNV,TenLoaiNV,MoTaLoaiNV,QuyenSD")] LoaiNV loaiNV)
{
if (ModelState.IsValid)
{
db.LoaiNV.Add(loaiNV);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(loaiNV));
}
public ActionResult Create([Bind(Include = "id_LoaiNV,tenLoai,LuongCB,phuCap,chucVu")] LoaiNV loaiNV)
{
if (ModelState.IsValid)
{
db.LoaiNVs.Add(loaiNV);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(loaiNV));
}
public void ThemLNV(string ma, string ten)
{
using (GalaxyMobileEntities dbs = new GalaxyMobileEntities())
{
//dbs.spInsertLNV(ma, ten);
LoaiNV l = new LoaiNV();
l.MaLoaiNV = ma;
l.TenLoaiNV = ten;
dbs.LoaiNVs.Add(l);
dbs.SaveChanges();
}
}
public void SuaLNV(string ma, string ten)
{
using (GalaxyMobileEntities dbs = new GalaxyMobileEntities())
{
//dbs.spUpdateLNV(ma, ten);
LoaiNV l = new LoaiNV();
l.MaLoaiNV = ma;
l.TenLoaiNV = ten;
dbs.LoaiNVs.Attach(l);
dbs.Entry(l).State = System.Data.Entity.EntityState.Modified;
dbs.SaveChanges();
}
}
// GET: LoaiNVs/Delete/5
public ActionResult Delete(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
LoaiNV loaiNV = db.LoaiNV.Find(id);
if (loaiNV == null)
{
return(HttpNotFound());
}
return(View(loaiNV));
}
// GET: Admin/LoaiNVs/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
LoaiNV loaiNV = db.LoaiNVs.Find(id);
if (loaiNV == null)
{
return(HttpNotFound());
}
return(View(loaiNV));
}
private void frmThayDoiThongTinNV_Load(object sender, EventArgs e)
{
cboLoaiNV.DataSource = LoaiNV.SelectAll();
cboLoaiNV.DisplayMember = "TenLoaiNV";
cboLoaiNV.ValueMember = "MaLoaiNV";
NHANVIEN nv = NhanVien.Select(GlobalSettings.UserID);
txtMaNV.Text = nv.MaNV;
txtTenNV.Text = nv.TenNV;
txtEmail.Text = nv.EmailNV;
txtSDT.Text = nv.SdtNV;
cboLoaiNV.SelectedValue = nv.MaLoaiNV;
}
public ActionResult EditChucVu(int id_loainv, LoaiNV loai_nv)
{
bool tontaiChucvu = data.Table_LOAINHANVIENs.Any(m => m.Tenloainhanvien == loai_nv.Tenloainhanvien && m.ID_LOAINHANVIEN != id_loainv);
if (tontaiChucvu)
{
ModelState.AddModelError("Tenloainhanvien", "Chức vụ này đã tồn tại");
}
if (ModelState.IsValid)
{
var model = data.Table_LOAINHANVIENs.First(m => m.ID_LOAINHANVIEN == id_loainv);
model.Tenloainhanvien = loai_nv.Tenloainhanvien;
data.SubmitChanges();
return(RedirectToAction("ChucVu"));
}
return(View());
}
public ActionResult CreateChucVu(LoaiNV loai_nv)
{
bool tontaiChucvu = data.Table_LOAINHANVIENs.Any(m => m.Tenloainhanvien == loai_nv.Tenloainhanvien);
if (tontaiChucvu)
{
ModelState.AddModelError("Tenloainhanvien", "Chức vụ này đã tồn tại");
}
if (ModelState.IsValid)
{
DA_Web.Models.Table_LOAINHANVIEN tb_loai = new Table_LOAINHANVIEN();
tb_loai.Tenloainhanvien = loai_nv.Tenloainhanvien;
data.Table_LOAINHANVIENs.InsertOnSubmit(tb_loai);
data.SubmitChanges();
return(RedirectToAction("ChucVu"));
}
return(View());
}
