public BoPhanInfo(String maDV, String tenDV, PhongBanInfo phongBan, String gChu)
{
MaBoPhan = maDV;
TenBoPhan = tenDV;
TenPhongBan = phongBan;
GhiChu = gChu;
}
public NguoiDungInfo(string maND, PhongBanInfo phongBan, BoPhanInfo boPhan, string tenDN, string matKhau, string hoTen, string phanQuyen, string gChu)
{
MaNguoiDung = maND;
PhongBan = phongBan;
BoPhan = boPhan;
TenDangNhap = tenDN;
MatKhau = matKhau;
HoTen = hoTen;
PhanQuyen = phanQuyen;
GhiChu = gChu;
}
protected void btnThemMoi_Click(object sender, EventArgs e)
{
PhongBanInfo info = new PhongBanInfo();
info.IDTrungTam = ConvertUtility.ToInt32(dropTrungTam.SelectedValue);
info.Ten = txtTen.Text.Trim();
info.MoTa = txtMoTa.Text;
info.TyTrong = ConvertUtility.ToDouble(txtTyTrong.Text);
info.IDNhanVienTruongPhong = ConvertUtility.ToInt32(dropTruongPhongBan.SelectedValue);
info.SoNguoi = 0;
info.IDParent = ConvertUtility.ToInt32(dropParent.SelectedValue);
PhongBanController.Insert(info);
}
protected void btnThemMoi_Click(object sender, EventArgs e)
{
PhongBanInfo info = new PhongBanInfo();
info.IDTrungTam = ConvertUtility.ToInt32(dropTrungTam.SelectedValue);
info.Ten = txtTen.Text.Trim();
info.MoTa = txtMoTa.Text;
info.TyTrong = ConvertUtility.ToDouble(txtTyTrong.Text);
info.IDNhanVienTruongPhong = ConvertUtility.ToInt32(dropTruongPhongBan.SelectedValue);
info.SoNguoi = 0;
info.IDParent = ConvertUtility.ToInt32(dropParent.SelectedValue);
PhongBanController.Insert(info);
}
private void BindForm(string mangach)
{
if (controller_PhongBan == null)
{
controller_PhongBan = new PhongBanController();
}
PhongBanInfo recordPhongBan = controller_PhongBan.HienThiRecordPhongBan(mangach);
//bind text to form
txtMaPhongBan.Text = recordPhongBan.MaPhong;
txtTenPhongBan.Text = recordPhongBan.TenPhong;
TxtSoNhanVien.Text = recordPhongBan.SoNhanVien.ToString();
TxtGhiChu.Text = recordPhongBan.GhiChu;
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
int id = ConvertUtility.ToInt32(Request.QueryString["idphong"]);
PhongBanInfo info = new PhongBanInfo();
info.ID = id;
info.IDTrungTam = ConvertUtility.ToInt32(dropTrungTam.SelectedValue);
info.Ten = txtTen.Text.Trim();
info.MoTa = txtMoTa.Text;
info.TyTrong = ConvertUtility.ToDouble(txtTyTrong.Text);
info.IDNhanVienTruongPhong = ConvertUtility.ToInt32(dropTruongPhongBan.SelectedValue);
info.SoNguoi = 0;//ConvertUtility.ToInt32(txtSoNguoi.Text);
info.IDParent = ConvertUtility.ToInt32(dropParent.SelectedValue);
PhongBanController.Update(info);
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
int id = ConvertUtility.ToInt32(Request.QueryString["idphong"]);
PhongBanInfo info = new PhongBanInfo();
info.ID = id;
info.IDTrungTam = ConvertUtility.ToInt32(dropTrungTam.SelectedValue);
info.Ten = txtTen.Text.Trim();
info.MoTa = txtMoTa.Text;
info.TyTrong = ConvertUtility.ToDouble(txtTyTrong.Text);
info.IDNhanVienTruongPhong = ConvertUtility.ToInt32(dropTruongPhongBan.SelectedValue);
info.SoNguoi = 0;//ConvertUtility.ToInt32(txtSoNguoi.Text);
info.IDParent = ConvertUtility.ToInt32(dropParent.SelectedValue);
PhongBanController.Update(info);
}
protected override void OnPreRender(EventArgs e)
{
base.OnPreRender(e);
DataTable dt = PhongBanController.GetAll(ConvertUtility.ToInt32(dropTrungTamSearch.SelectedValue));
PhongBanController.LoadPhongBan(dropParent.Items, ConvertUtility.ToInt32(dropTrungTam.SelectedValue));
dropParent.Items.Insert(0, new ListItem("Root", "0"));
int id = ConvertUtility.ToInt32(Request.QueryString["idPhong"]);
if (id > 0)
{
PhongBanInfo info = PhongBanController.GetInfo(id);
if (info != null)
{
dropTrungTam.SelectedValue = info.IDTrungTam.ToString();
txtTen.Text = info.Ten;
txtMoTa.Text = info.MoTa;
txtTyTrong.Text = info.TyTrong.ToString();
dropTruongPhongBan.SelectedValue = info.IDNhanVienTruongPhong.ToString();
try
{
dropParent.SelectedValue = info.IDParent.ToString();
}
catch
{
dropParent.SelectedIndex = -1;
}
}
}
else
{
btnUpdate.Visible = false;
}
dgrPhongBan.DataSource = dt;
dgrPhongBan.DataBind();
}
public abstract void UpdatePhong(PhongBanInfo _PhongBanInfo);
public abstract int InsertPhong(PhongBanInfo _PhongBanInfo);
public static int Insert(PhongBanInfo _PhongBanInfo)
{
return DataAccessProvider.Instance().InsertPhong(_PhongBanInfo);
}
public static void Update(PhongBanInfo _PhongBanInfo)
{
DataAccessProvider.Instance().UpdatePhong(_PhongBanInfo);
}
public override void UpdatePhong(PhongBanInfo _PhongBanInfo)
{
SqlHelper.ExecuteNonQuery(this.ConnectionString, "PhongBan_Update",
_PhongBanInfo.ID,
_PhongBanInfo.IDTrungTam,
_PhongBanInfo.Ten,
_PhongBanInfo.MoTa,
_PhongBanInfo.TyTrong,
_PhongBanInfo.IDNhanVienTruongPhong,
_PhongBanInfo.SoNguoi,
_PhongBanInfo.IDParent);
}
public override int InsertPhong(PhongBanInfo _PhongBanInfo)
{
return (int)SqlHelper.ExecuteScalar(this.ConnectionString, "PhongBan_Insert",
_PhongBanInfo.IDTrungTam,
_PhongBanInfo.Ten,
_PhongBanInfo.MoTa,
_PhongBanInfo.TyTrong,
_PhongBanInfo.IDNhanVienTruongPhong,
_PhongBanInfo.SoNguoi,
_PhongBanInfo.IDParent
);
}
public abstract void UpdatePhong(PhongBanInfo _PhongBanInfo);
public abstract int InsertPhong(PhongBanInfo _PhongBanInfo);
