public bool Delete(PhieuTamVang ptv)
{
string query = string.Empty;
query += "DELETE FROM [PHIEU_TAM_VANG] WHERE [Ma] = @Ma";
using (SqlConnection _cnn = new SqlConnection(ConnectionString))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = _cnn;
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = query;
cmd.Parameters.AddWithValue("@Ma", ptv.Ma);
try
{
_cnn.Open();
cmd.ExecuteNonQuery();
_cnn.Close();
_cnn.Dispose();
}
catch (Exception ex)
{
_cnn.Close();
return(false);
}
}
}
return(true);
}
public FrmChiTietPhieuTamVang(PhieuTamVang phieu)
{
InitializeComponent();
if (phieu == null)
{
SetThemState();
phieuTamVang = new PhieuTamVang();
phieuTamVang.NgayCap = DateTime.Now;
phieuTamVang.ThoiGianBatDau = DateTime.Now;
phieuTamVang.ThoiGianKetThuc = DateTime.Now;
}
else
{
SetSuaState();
disableSua();
rbKhong.Select();
phieuTamVang = phieu;
}
setData(phieuTamVang);
rbCo.Click += RbCo_Click;
rbKhong.Click += RbKhong_Click;
btnLuuSua.Click += BtnLuu_Click;
btnLuuThem.Click += BtnLuuThem_Click;
btnQuayLai.Click += BtnQuayLai_Click;
}
private PhieuTamVang GetFromReader(SqlDataReader reader)
{
PhieuTamVang ptv = new PhieuTamVang();
ptv.LyDo = reader["LyDo"].ToString();
ptv.Ma = int.Parse(reader["Ma"].ToString());
ptv.MaNguoiKhaiBao = int.Parse(reader["MaNguoiKhaiBao"].ToString());
ptv.TenNguoiKhaiBao = reader["TenNguoiKhaiBao"].ToString();
ptv.NguoiCap = reader["NguoiCap"].ToString();
ptv.NoiCap = reader["NoiCap"].ToString();
ptv.NoiTamTru = reader["NoiTamTru"].ToString();
string ThoiGianBatDau, ThoiGianKetThuc, NgayCap;
ThoiGianBatDau = reader["ThoiGianBatDau"].ToString();
ThoiGianKetThuc = reader["ThoiGianKetThuc"].ToString();
NgayCap = reader["NgayCap"].ToString();
if (!string.IsNullOrEmpty(ThoiGianBatDau.Trim()))
{
ptv.ThoiGianBatDau = DateTime.Parse(ThoiGianBatDau);
}
if (!string.IsNullOrEmpty(ThoiGianKetThuc.Trim()))
{
ptv.ThoiGianKetThuc = DateTime.Parse(ThoiGianKetThuc);
}
if (!string.IsNullOrEmpty(NgayCap.Trim()))
{
ptv.NgayCap = DateTime.Parse(NgayCap);
}
return(ptv);
}
private static void SetParam(PhieuTamVang ptv, SqlCommand cmd)
{
cmd.Parameters.AddWithValue("@LyDo", ptv.LyDo);
cmd.Parameters.AddWithValue("@MaNguoiKhaiBao", ptv.MaNguoiKhaiBao);
cmd.Parameters.AddWithValue("@TenNguoiKhaiBao", ptv.TenNguoiKhaiBao);
cmd.Parameters.AddWithValue("@NgayCap", ptv.NgayCap);
cmd.Parameters.AddWithValue("@NguoiCap", ptv.NguoiCap);
cmd.Parameters.AddWithValue("@NoiCap", ptv.NoiCap);
cmd.Parameters.AddWithValue("@NoiTamTru", ptv.NoiTamTru);
cmd.Parameters.AddWithValue("@ThoiGianBatDau", ptv.ThoiGianBatDau);
cmd.Parameters.AddWithValue("@ThoiGianKetThuc", ptv.ThoiGianKetThuc);
}
public bool Add(PhieuTamVang ptv)
{
string query = string.Empty;
query += @"
INSERT INTO [PHIEU_TAM_VANG] (
[LyDo],
[MaNguoiKhaiBao],
[TenNguoiKhaiBao],
[NgayCap],
[NguoiCap],
[NoiCap],
[NoiTamTru],
[ThoiGianBatDau],
[ThoiGianKetThuc]
)";
query += @"VALUES (
@LyDo,
@MaNguoiKhaiBao,
@TenNguoiKhaiBao,
@NgayCap,
@NguoiCap,
@NoiCap,
@NoiTamTru,
@ThoiGianBatDau,
@ThoiGianKetThuc
)";
using (SqlConnection _cnn = new SqlConnection(ConnectionString))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = _cnn;
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = query;
SetParam(ptv, cmd);
try
{
_cnn.Open();
cmd.ExecuteNonQuery();
_cnn.Close();
_cnn.Dispose();
}
catch (Exception ex)
{
_cnn.Close();
return(false);
}
}
}
return(true);
}
private void DgvPhieuTamVang_CellClick(object sender, DataGridViewCellEventArgs e)
{
int numrow;
numrow = e.RowIndex;
if (numrow == -1)
{
disableSelect();
}
else
{
enableSelect();
phieuTamVangSelected = listPhieuTamVang[numrow];
}
}
public List <PhieuTamVang> ReadAllByKeyword(string key)
{
string query = string.Empty;
query += @"select * from [PHIEU_TAM_VANG]
where
";
List <PhieuTamVang> congDans = new List <PhieuTamVang>();
using (SqlConnection con = new SqlConnection(ConnectionString))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = query;
cmd.Parameters.AddWithValue("@Param", '%' + key + '%');
try
{
con.Open();
SqlDataReader reader = null;
reader = cmd.ExecuteReader();
if (reader.HasRows == true)
{
while (reader.Read())
{
PhieuTamVang ptv = GetFromReader(reader);
congDans.Add(ptv);
}
}
con.Close();
con.Dispose();
}
catch (Exception ex)
{
con.Close();
return(null);
}
}
}
return(congDans);
}
public List <PhieuTamVang> ReadAll()
{
string query = string.Empty;
query += "SELECT * ";
query += "FROM [PHIEU_TAM_VANG]";
List <PhieuTamVang> ptvs = new List <PhieuTamVang>();
using (SqlConnection con = new SqlConnection(ConnectionString))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = query;
try
{
con.Open();
SqlDataReader reader = null;
reader = cmd.ExecuteReader();
if (reader.HasRows == true)
{
while (reader.Read())
{
PhieuTamVang ptv = GetFromReader(reader);
ptvs.Add(ptv);
}
}
con.Close();
con.Dispose();
}
catch (Exception ex)
{
con.Close();
return(null);
}
}
}
return(ptvs);
}
public bool Update(PhieuTamVang ptv)
{
string query = string.Empty;
query += "UPDATE [PHIEU_TAM_VANG] SET ";
query += "[LyDo] = @LyDo, ";
query += "[MaNguoiKhaiBao] = @MaNguoiKhaiBao, ";
query += "[TenNguoiKhaiBao] = @TenNguoiKhaiBao, ";
query += "[NgayCap] = @NgayCap, ";
query += "[NguoiCap] = @NguoiCap, ";
query += "[NoiCap] = @NoiCap, ";
query += "[NoiTamTru] = @NoiTamTru, ";
query += "[NoiTamTru] = @NoiTamTru, ";
query += "[ThoiGianBatDau] = @ThoiGianBatDau, ";
query += "[ThoiGianKetThuc] = @ThoiGianKetThuc ";
query += "WHERE [Ma] = @Ma";
using (SqlConnection _cnn = new SqlConnection(ConnectionString))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = _cnn;
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = query;
cmd.Parameters.AddWithValue("@Ma", ptv.Ma);
SetParam(ptv, cmd);
try
{
_cnn.Open();
cmd.ExecuteNonQuery();
_cnn.Close();
_cnn.Dispose();
}
catch (Exception ex)
{
_cnn.Close();
return(false);
}
}
}
return(true);
}
private void setData(PhieuTamVang result)
{
//tbHoTen.Text = result.NguoiKhaiBao;
//tbCmndCccd.Text = result.SoCmndCccd;
//tbNgheNghiep.Text = result.NgheNghiep ;
//tbNoiLamViec.Text = result.NoiLamViec ;
//tbDiaChi.Text = result.SoNha ;
//tbQuanHe.Text = result.QuanHeChuHo ;
//tbNguoiCapPhieu.Text = result.NguoiCap ;
//tbDanhSachTreEm.Text = result.DanhSachTreEm;
//tbNoiTamTru.Text = result.NoiTamTru ;
//tbLyDo.Text = result.LyDo ;
//dtpTgBd.Value = result.ThoiGianBatDau;
//dtpTgKt.Value = result.ThoiGianKetThuc;
//dtpNgayGhi.Value = result.NgayKhaiBao;
}
public PhieuTamVang Read(string ma)
{
string query = string.Empty;
query += "SELECT TOP 1 * ";
query += "FROM [PHIEU_TAM_VANG] WHERE [Ma]=@Ma";
PhieuTamVang ptv = new PhieuTamVang();
using (SqlConnection con = new SqlConnection(ConnectionString))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = query;
cmd.Parameters.AddWithValue("@Ma", ma);
try
{
con.Open();
SqlDataReader reader = null;
reader = cmd.ExecuteReader();
reader.Read();
ptv = GetFromReader(reader);
con.Close();
con.Dispose();
}
catch (Exception ex)
{
con.Close();
return(null);
}
}
}
return(ptv);
}
public bool Validate(PhieuTamVang phieu, ref string error)
{
return(true);
}
public bool Delete(PhieuTamVang cd)
{
return(PhieuTamVangDAL.GetInstance().Delete(cd));
}
public bool Update(PhieuTamVang cd)
{
return(PhieuTamVangDAL.GetInstance().Update(cd));
}
public bool Add(PhieuTamVang cd)
{
return(PhieuTamVangDAL.GetInstance().Add(cd));
}
