protected void Luuhinhvaodatabase(string hinh_nv, string ma_nv)
{
NHANVIENBusiness hinhnv = new NHANVIENBusiness();
Hinh_NHANVIEN n_v = new Hinh_NHANVIEN();
n_v.manv = ma_nv;
n_v.hinh = hinh_nv;
hinhnv.Update_hinh(n_v);
}
protected void List_Nhanvien(string mnv)
{
try
{
NHANVIENBusiness nhanvien = new NHANVIENBusiness();
DataTable tbl = nhanvien.DetailsByField("manv", mnv);
manhanvien.Text = tbl.Rows[0]["manv"].ToString();
hovaten.Text = tbl.Rows[0]["tennv"].ToString();
noisinh.Text = tbl.Rows[0]["noisinh"].ToString();
choohientai.Text = tbl.Rows[0]["noiohientai"].ToString();
ngaysinh.Text = tbl.Rows[0]["ngaysinh"].ToString().Substring(0, 10);
CMND.Text = tbl.Rows[0]["socmnd"].ToString();
noisinh.Text = tbl.Rows[0]["noisinh"].ToString();
dienthoai.Text = tbl.Rows[0]["sodt"].ToString();
hdldso.Text = tbl.Rows[0]["sohd"].ToString();
donvi.SelectedIndex = donvi.Items.IndexOf(donvi.Items.FindByValue(tbl.Rows[0]["donviid"].ToString()));
machuyenmon.SelectedIndex = machuyenmon.Items.IndexOf(machuyenmon.Items.FindByValue(tbl.Rows[0]["cmid"].ToString()));
maphong.SelectedIndex = maphong.Items.IndexOf(maphong.Items.FindByValue(tbl.Rows[0]["phongid"].ToString()));
machucvu.SelectedIndex = machucvu.Items.IndexOf(machucvu.Items.FindByValue(tbl.Rows[0]["cvid"].ToString()));
dantoc.SelectedIndex = dantoc.Items.IndexOf(dantoc.Items.FindByValue(tbl.Rows[0]["dantoc"].ToString()));
tongiao.SelectedIndex = tongiao.Items.IndexOf(tongiao.Items.FindByValue(tbl.Rows[0]["tongiao"].ToString()));
loaihd.SelectedIndex = loaihd.Items.IndexOf(loaihd.Items.FindByValue(tbl.Rows[0]["loaihd"].ToString()));
gioitinh.SelectedIndex = gioitinh.Items.IndexOf(gioitinh.Items.FindByValue(tbl.Rows[0]["gioitinh"].ToString()));
giadinh.SelectedIndex = giadinh.Items.IndexOf(giadinh.Items.FindByValue(tbl.Rows[0]["giadinh"].ToString()));
if (tbl.Rows[0]["hinh"] == DBNull.Value)
{
hinhnhanvien.ImageUrl = "/Images/noimage.png";
}
else
{
if (File.Exists(Server.MapPath("/Images/" + tbl.Rows[0]["hinh"].ToString())) == true)
{
hinhnhanvien.ImageUrl = "/Images/" + tbl.Rows[0]["hinh"].ToString();
}
else
{
hinhnhanvien.ImageUrl = "/Images/noimage.png";
}
}
ngayhd.Text = tbl.Rows[0]["ngayhd"].ToString().Substring(0, 10);
ngaybd.Text = tbl.Rows[0]["ngaybd"].ToString().Substring(0, 10);
}
catch
{ }
}
protected void them_Click(object sender, EventArgs e)
{
try
{
NHANVIENBusiness nv = new NHANVIENBusiness();
NHANVIEN n_v = new NHANVIEN();
DataNHANVIEN dtnv = new DataNHANVIEN();
DataTable dtsl = dtnv.DataGetListNHANVIEN();
int sl = dtsl.Rows.Count + 1;
manhanvien.Text = Taomanv(donvi.SelectedValue, maphong.Text, sl);
n_v.manv = manhanvien.Text;
n_v.honv = hovaten.Text;
n_v.bacluong = float.Parse(bacluong.SelectedValue.ToString());
n_v.bhxh = "";
n_v.cmid = decimal.Parse(machuyenmon.SelectedValue);
n_v.cvid = decimal.Parse(machucvu.SelectedValue);
n_v.dantoc = decimal.Parse(dantoc.SelectedValue);
n_v.donviid = decimal.Parse(donvi.SelectedValue);
n_v.email = "";
n_v.giadinh = decimal.Parse(giadinh.SelectedValue);
n_v.gioitinh = decimal.Parse(gioitinh.SelectedValue);
n_v.honv = hovaten.Text;
n_v.loaihd = decimal.Parse(loaihd.SelectedValue);
n_v.ngaybd = DateTime.Parse(ngaybd.Text);
n_v.ngayct = DateTime.Parse(ngaybd.Text);
n_v.ngayhd = DateTime.Parse(ngayhd.Text);
n_v.ngaykt = System.DateTime.Now;
n_v.ngaysinh = DateTime.Parse(ngaysinh.Text);
n_v.noiohientai = choohientai.Text;
n_v.noisinh = noisinh.Text;
n_v.phongid = decimal.Parse(maphong.SelectedValue);
n_v.socmnd = CMND.Text;
n_v.sodt = dienthoai.Text;
n_v.sohd = hdldso.Text;
n_v.tdid = decimal.Parse(matrinhdo.SelectedValue);
n_v.tennv = hovaten.Text;
n_v.tongiao = decimal.Parse(tongiao.SelectedValue);
nv.Insert(n_v);
Luuhinhvaodatabase(loadhinh.FileName, manhanvien.Text);
}
catch
{
}
}
protected void Page_Load(object sender, EventArgs e)
{
Form.Action = Request.RawUrl;
if (!IsPostBack)
{
NHANVIENBusiness nhanvien = new NHANVIENBusiness();
DataTable ds_nhanvien = nhanvien.GetList();
danhsachnhanvien.DataSource = ds_nhanvien;
danhsachnhanvien.DataBind();
// -------------------------
Load_Phong();
Load_chucvu();
Load_trinhdo();
Load_chuyenmon();
Load_dantoc();
Load_tongiao();
Load_bacluong();
Load_loaihd();
Load_gioitinh();
Load_donvi();
}
}
