protected void Page_Load(object sender, EventArgs e)
{
string email = Session["account"].ToString();
Models.AccountEntity accEntity = new Models.AccountEntity();
Models.Account loginACC = accEntity.FindByEmail(email);
lblNguoiChamCong.Text = loginACC.NhanVien.NVTen;
_ngaychamcong = DateTime.Now;
Models.DonVi donvichamcong = new Models.DonVi();
if (loginACC.ACCChucNang != 0)
{
donvichamcong = loginACC.PhuTrachChamCongs.FirstOrDefault().DonVi;
}
else
{
Models.LamViec lamviec = loginACC.NhanVien.LamViecs.OrderByDescending(x => x.LVTuNgay).FirstOrDefault();
donvichamcong = (lamviec != null) ? lamviec.DonVi : null;
}
_lamviecs = (donvichamcong != null) ? donvichamcong.LamViecs : null;
_donvichamcongID = (donvichamcong != null) ? donvichamcong.DVID : 0;
if (!this.Page.IsPostBack)
{
_ccEntity.Load_DonViChamCongList_ToRadComboBox(cbbDonVi, loginACC);
cbbDonVi.SelectedValue = (donvichamcong != null) ? donvichamcong.DVID.ToString() : "";
dpkNgayThang.SelectedDate = DateTime.Now;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
_donviEntity.Load_DataSource_RadDropDownTree(ddtTrucThuoc);
}
if (this.Page.RouteData.Values["donvi"] == null)
{
this.CreateStatus();
}
else
{
this.UpdateStatus();
_currentDVID = Convert.ToInt32(this.Page.RouteData.Values["donvi"]);
if (!IsPostBack)
{
Models.DonVi currentDV = _donviEntity.Find_DonVi(_currentDVID);
txtTen.Text = currentDV.DVTen;
txtBienChe.Text = currentDV.DVBienChe.ToString();
txtChucNang.Text = currentDV.DVNoiDung;
rblTrangThai.SelectedValue = currentDV.DVTrangThai.ToString();
ddtTrucThuoc.SelectedValue = currentDV.DVTrucThuocID.ToString();
txtSDT.Text = currentDV.DVSDT;
txtDiaChi.Text = currentDV.DVDiaChi;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["account"] != null)
{
Models.AccountEntity accEntity = new Models.AccountEntity();
string email = Session["account"].ToString();
Models.Account account = accEntity.FindByEmail(email);
if (account == null || account.ACCChucNang > 1)
{
Response.Redirect("~/");
}
else if (this.Page.RouteData.Values["donvi"] != null)
{
try
{
int donviID = Convert.ToInt32(this.Page.RouteData.Values["donvi"]);
Models.DonViEntity donviEntity = new Models.DonViEntity();
Models.DonVi donvi = donviEntity.Find_DonVi(donviID);
if (donvi == null)
{
Response.Redirect("~/DonVi");
}
}
catch (Exception)
{
Response.Redirect("~/DonVi");
}
}
}
else
{
Response.Redirect("~/");
}
}
public void Delete(int _donviID)
{
Models.EmployeeManagementEntities db = new EmployeeManagementEntities();
Models.DonVi donvi = db.DonVis.FirstOrDefault(x => x.DVID == _donviID);
db.DonVis.Remove(donvi);
db.SaveChanges();
db.Dispose();
}
public void Load_DonViChamCongList_ToRadComboBox(RadComboBox _cbb, Models.Account _loginAccount)
{
List <Models.DonVi> donvis = this.DonViChamCongList(_loginAccount);
_firstDonViChamCong = donvis.FirstOrDefault();
_cbb.DataSource = donvis;
_cbb.DataTextField = "DVTen";
_cbb.DataValueField = "DVID";
_cbb.DataBind();
}
private string DonViTrucThuocTen(Models.DonVi _donvi)
{
if (_donvi.DonVi1 != null)
{
return(_donvi.DonVi1.DVTen);
}
else
{
return("");
}
}
private string ConvertTrangThai(Models.DonVi _donvi)
{
if (_donvi.DVTrangThai)
{
return("Kích hoạt");
}
else
{
return("Khóa");
}
}
public JsonResult GetListUnit()
{
List <Models.DonVi> ListUnit = new List <Models.DonVi>();
Database db = new Database();
DataTable dt = db.Query("select * from DonVi ;");
for (int i = 0; i < dt.Rows.Count; i++)
{
Models.DonVi Unit = new Models.DonVi();
Unit.MaDonVi = dt.Rows[i]["MaDV"].ToString();
Unit.TenDonVi = dt.Rows[i]["TenDV"].ToString();
ListUnit.Add(Unit);
}
return(Json(ListUnit));
}
public void Update(int _donviID, string _ten, string _noidung, int _bienche, bool _trangthai, int _tructhuocID, string _sdt, string _diachi)
{
Models.EmployeeManagementEntities db = new EmployeeManagementEntities();
Models.DonVi donvi = db.DonVis.FirstOrDefault(x => x.DVID == _donviID);
donvi.DVTen = _ten;
donvi.DVNoiDung = _noidung;
donvi.DVBienChe = _bienche;
donvi.DVTrangThai = _trangthai;
if (_tructhuocID != 0)
{
donvi.DVTrucThuocID = _tructhuocID;
}
donvi.DVSDT = _sdt;
donvi.DVDiaChi = _diachi;
db.SaveChanges();
db.Dispose();
}
public void Insert(string _ten, string _noidung, int _bienche, bool _trangthai, int _donvitructhuocID, string _sdt, string _diachi)
{
Models.EmployeeManagementEntities db = new EmployeeManagementEntities();
Models.DonVi donvi = new Models.DonVi();
donvi.DVTen = _ten;
donvi.DVNoiDung = _noidung;
donvi.DVBienChe = _bienche;
if (_donvitructhuocID != 0)
{
donvi.DVTrucThuocID = _donvitructhuocID;
}
donvi.DVTrangThai = _trangthai;
donvi.DVSDT = _sdt;
donvi.DVDiaChi = _diachi;
db.DonVis.Add(donvi);
db.SaveChanges();
db.Dispose();
}
public Models.DonVi Find_DonVi(int _donviID)
{
Models.EmployeeManagementEntities db = new Models.EmployeeManagementEntities();
Models.DonVi donvi = db.DonVis.FirstOrDefault(x => x.DVID == _donviID);
return(donvi);
}
public void AddUnit(Models.DonVi a)
{
Database db = new Database();
db.Insert("insert into DonVi values (N'" + a.TenDonVi + "');");
}
