public int ThemDocGia(TheDocGia_DTO dto)
{
ThemDocGiaDAO nvd = new ThemDocGiaDAO();
int k = nvd.ThemDocGia(dto);
return(k);
}
private void btn_them_Click(object sender, EventArgs e)
{
ThemDocGiaBUS nvbus = new ThemDocGiaBUS();
TheDocGia_DTO dtonv = new TheDocGia_DTO();
dtonv.Hoten = txt_hoTen.Text;
dtonv.Tennv = txt_nguoiLap.Text;
dtonv.Ngaysinh = dtngaysinh.Text;
dtonv.Diachi = txt_diaChi.Text;
dtonv.Email = txt_email.Text;
dtonv.Ngaylapthe = dtngaylap.Text;
dtonv.Maloai = Int32.Parse(cbbloaidocgia.SelectedItem.ToString());
int k = nvbus.ThemDocGia(dtonv);
if (k > 0)
{
MessageBox.Show("Bạn đã thêm thành công");
}
else
{
MessageBox.Show("Không thể thêm nhân viên");
}
fr_TheDocGia_Load(sender, e);
}
public bool UpDate(TheDocGia_DTO thedocgia)
{
// thuoc tinh ma thu thu khong duoc cap nhap lai
try
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlCommand cmd;
string sqlQuyery1 = " select count(*) from THEDOCGIA where MaThe = N'" + thedocgia.MaThe + "'";
cmd = new SqlCommand(sqlQuyery1, con);
var i = cmd.ExecuteScalar();
if (int.Parse(i.ToString()) == 0)
{
return(false);
}
else
{
string sqlQuery = @"Update THEDOCGIA set MaDocGia = N'" + thedocgia.MaDocGia + "', NgayLamThe =N'" + thedocgia.NgayLamThe
+ "', HanThe = N'" + thedocgia.HanThe + "', LoaiThe = N'" + thedocgia.LoaiThe
+ "' where MaThe = N'" + thedocgia.MaThe + "'";
cmd = new SqlCommand(sqlQuery, con);
cmd.ExecuteNonQuery();
con.Close();
return(true);
}
}
catch
{
return(false);
}
}
public bool KiemTra(TheDocGia_DTO thedocgia)
{
if (thedocgia.MaThe == "" || thedocgia.MaDocGia == "" || thedocgia.NgayLamThe == "" || thedocgia.HanThe == "" || thedocgia.LoaiThe == "")
{
return(false);
}
return(true);
}
public frm_PhieuDocGia()
{
InitializeComponent();
thedocgiaBUS = new TheDocGia_BUS();
thedocgiaDTO = new TheDocGia_DTO();
qd = new QuyDinh1_BUS();
DataTable table = qd.Select();
var i = table.Rows[0].ItemArray;
dtNgayLamThe.Text = DateTime.Now.ToShortDateString();
dthanThe.Text = DateTime.Now.AddMonths(int.Parse(i[2].ToString())).ToShortDateString();
KhoiTaoCmbTiemKiem();
KhoiTaoCmbLoaiThe();
}
public bool Delete(TheDocGia_DTO thedocgia)
{
try
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
string sqlQuery = "delete from THEDOCGIA where MaThe= '" + thedocgia.MaThe + "'";
SqlCommand cmd = new SqlCommand(sqlQuery, con);
cmd.ExecuteNonQuery();
con.Close();
return(true);
}
catch
{
return(false);
}
}
public bool Insert(TheDocGia_DTO thedocgia)
{
try
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
string sqlQuery = @"INSERT INTO THEDOCGIA(MaThe, MaDocGia, LoaiThe, NgayLamThe, HanThe )
VALUES (N'" + thedocgia.MaThe + "', N'" + thedocgia.MaDocGia + "', N'" + thedocgia.LoaiThe + "'" +
",N'" + thedocgia.NgayLamThe + "',N'" + thedocgia.HanThe + "')";
// thuc hien insert
SqlCommand cmd = new SqlCommand(sqlQuery, con);
cmd.ExecuteNonQuery();
con.Close();
return(true); // them thanh cong
}
catch
{
return(false); // them that bai;
}
}
public int ThemDocGia(TheDocGia_DTO dtonv)
{
int k = -1;
SqlConnection connect = new SqlConnection();
SqlConnectionString constring = new SqlConnectionString();
connect = SqlConnectionString.HamKetNoi();
connect.Open();
SqlCommand cmd = new SqlCommand("sp_themdocgia", connect);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@hoten", SqlDbType.NVarChar);
cmd.Parameters.Add("@tennv", SqlDbType.NVarChar);
cmd.Parameters.Add("@ngaysinh", SqlDbType.DateTime);
cmd.Parameters.Add("@diachi", SqlDbType.NVarChar);
cmd.Parameters.Add("@email", SqlDbType.NChar);
cmd.Parameters.Add("@ngaylapthe", SqlDbType.DateTime);
cmd.Parameters.Add("@maloai", SqlDbType.Int);
cmd.Parameters["@hoten"].Value = dtonv.Hoten;
cmd.Parameters["@tennv"].Value = dtonv.Tennv;
cmd.Parameters["@ngaysinh"].Value = dtonv.Ngaysinh;
cmd.Parameters["@diachi"].Value = dtonv.Diachi;
cmd.Parameters["@email"].Value = dtonv.Email;
cmd.Parameters["@ngaylapthe"].Value = dtonv.Ngaylapthe;
cmd.Parameters["@maloai"].Value = dtonv.Maloai;
k = cmd.ExecuteNonQuery();
connect.Close();
if (k > 0)
{
return(k);
}
return(0);
}
public bool Delete(TheDocGia_DTO thedocgia)
{
return(TDG.Delete(thedocgia));
}
public bool UpDate(TheDocGia_DTO thedocgia)
{
return(TDG.UpDate(thedocgia));
}
public bool Insert(TheDocGia_DTO thedocgia)
{
return(TDG.Insert(thedocgia));
}
