private void btTimKiem_Click(object sender, EventArgs e)
{
DMLoaiDichVuInfor dmLoaiDichVuInfor = new DMLoaiDichVuInfor();
dmLoaiDichVuInfor.TenDichVu = txtTenLoaiDichVu.Text;
dgvList.DataSource = DMLoaiDichVuDataProvider.Search(dmLoaiDichVuInfor);
}
internal int Insert(DMLoaiDichVuInfor dmLoaiDichVuInfor)
{
CreateCommonCommand(Declare.StoreProcedureNamespace.spLoaiDichVuInsert);
SetParams(dmLoaiDichVuInfor);
Parameters["@IdLoaiDichVu"].Direction = ParameterDirection.Output;
ExecuteNoneQuery();
return(Convert.ToInt32(Parameters["@IdLoaiDichVu"].Value.ToString()));
}
internal bool Exist(DMLoaiDichVuInfor dmLoaiDichVuInfor)
{
CreateCommonCommand(Declare.StoreProcedureNamespace.spLoaiDichVuExist);
Parameters.AddWithValue("@Count", 0).Direction = ParameterDirection.Output;
Parameters.AddWithValue("@IdLoaiDichVu", dmLoaiDichVuInfor.IdLoaiDichVu);
Parameters.AddWithValue("@MaLoaiDichVu", dmLoaiDichVuInfor.MaLoaiDichVu);
ExecuteNoneQuery();
return(Convert.ToInt32(Parameters["@Count"].Value) == 1);
}
private DMLoaiDichVuInfor SetLoaiDichVuInfo()
{
DMLoaiDichVuInfor dm = new DMLoaiDichVuInfor();
dm.MaLoaiDichVu = txtMaLoaiDichVu.Text.Trim();
dm.TenDichVu = txtTenLoaiDichVu.Text.Trim();
dm.GhiChu = txtGhiChu.Text.Trim();
return(dm);
}
private void ucActions1_OnAdd(object obj)
{
DMLoaiDichVuInfor dmLoaiDichVuInfor = new DMLoaiDichVuInfor();
dmLoaiDichVuInfor.MaLoaiDichVu = txtMaLoaiDichVu.Text;
dmLoaiDichVuInfor.TenDichVu = txtTenLoaiDichVu.Text;
dmLoaiDichVuInfor.GhiChu = txtGhiChu.Text;
dmLoaiDichVuInfor.SuDung = Convert.ToInt32(cbSuDung.Checked);
DMLoaiDichVuDataProvider.Insert(dmLoaiDichVuInfor);
MessageBox.Show("Thêm bảng thành công!");
dgvList.DataSource = DMLoaiDichVuDataProvider.GetListDichVuInfo();
}
private void Save()
{
if (Check())
{
if (frm.isAdd)
{
DMLoaiDichVuDataProvider.Insert(SetLoaiDichVuInfo());
Reset();
}
else
{
DMLoaiDichVuInfor dm = SetLoaiDichVuInfo();
dm.IdLoaiDichVu = frm.Oid;
DMLoaiDichVuDataProvider.Update(dm);
}
}
}
private void LoadData()
{
if (frm.isAdd)
{
Reset();
btnXoa.Enabled = false;
}
else
{
dm = DMLoaiDichVuDataProvider.GetTrungTamByIdInfo(frm.Oid);
txtTenLoaiDichVu.Text = dm.TenDichVu;
txtMaLoaiDichVu.Text = dm.MaLoaiDichVu;
txtGhiChu.Text = dm.GhiChu;
cbSuDung.Checked = dm.SuDung == 1;
}
if (frm.IsSync)
{
//không cho phép người dùng sửa, xóa các thông tin trên form.
txtMaLoaiDichVu.Enabled = false;
txtTenLoaiDichVu.Enabled = false;
btnXoa.Enabled = false;
}
}
internal List <DMLoaiDichVuInfor> Search(DMLoaiDichVuInfor dmLoaiDichVuInfor)
{
CreateGetListCommand(Declare.StoreProcedureNamespace.spLoaiDichVuSearch);
Parameters.AddWithValue("@IdLoaiDichVu", dmLoaiDichVuInfor.TenDichVu);
return(FillToList <DMLoaiDichVuInfor>());
}
internal void Delete(DMLoaiDichVuInfor dmLoaiDichVuInfor)
{
CreateCommonCommand(Declare.StoreProcedureNamespace.spLoaiDichVuDelete);
Parameters.AddWithValue("@IdLoaiDichVu", dmLoaiDichVuInfor.IdLoaiDichVu);
ExecuteNoneQuery();
}
internal void Update(DMLoaiDichVuInfor dmLoaiDichVuInfor)
{
CreateCommonCommand(Declare.StoreProcedureNamespace.spLoaiDichVuUpdate);
SetParams(dmLoaiDichVuInfor);
ExecuteNoneQuery();
}
internal static bool Kiemtra(DMLoaiDichVuInfor dmLoaiDichVuInfor)
{
return(DmLoaiDichVuDAO.Instance.Exist(dmLoaiDichVuInfor));
}
internal static void Update(DMLoaiDichVuInfor dmLoaiDichVuInfor)
{
DmLoaiDichVuDAO.Instance.Update(dmLoaiDichVuInfor);
}
internal static void Delete(DMLoaiDichVuInfor dmLoaiDichVuInfor)
{
DmLoaiDichVuDAO.Instance.Delete(dmLoaiDichVuInfor);
}
internal static void Insert(DMLoaiDichVuInfor dmLoaiDichVuInfor)
{
DmLoaiDichVuDAO.Instance.Insert(dmLoaiDichVuInfor);
}
private bool timkiem(DMLoaiDichVuInfor dmLoaiDichVuInfor)
{
return(txtTenLoaiDichVuSearch.Text.Trim() == String.Empty || (txtTenLoaiDichVuSearch.Text.Trim() != String.Empty &&
dmLoaiDichVuInfor.TenDichVu.ToLower().Contains(txtTenLoaiDichVuSearch.Text.Trim().ToLower())));
}
internal static List <DMLoaiDichVuInfor> Search(DMLoaiDichVuInfor dmLoaiDichVuInfor)
{
return(DmLoaiDichVuDAO.Instance.Search(dmLoaiDichVuInfor));
}
private bool Exist(DMLoaiDichVuInfor dmLoaiDichVuInfor)
{
return(dmLoaiDichVuInfor.MaLoaiDichVu != null && dmLoaiDichVuInfor.MaLoaiDichVu.ToLower() == txtMaLoaiDichVu.Text.Trim().ToLower());
}
