public static int sua(string nvID)
{
classNV nv = classTim.tim_theo_ID(nvID);
//...sua thanh con return 0, 0 thanh con return 1
return(0);
}
public static classNV tim_theo_ID(string ID)
{
classNV result = new classNV();
return(result);
//tim khong thanh cong return null
}
public static classNV tim_theo_ten(string name)
{
classNV result = new classNV();
int n;
int i;
return(result);
}
private void butInsert_Click(object sender, EventArgs e)
{
classNV nv = new classNV();
nv.hoten = in_boxName.Text;
nv.ns = in_boxNS.Value;
nv.quequan = in_boxQq.Text;
nv.donvi = in_boxDV.Text;
nv.hesoluong = int.Parse(in_boxBL.Text);
nv.socmnd = in_boxCMND.Text;
nv.sodienthoai = in_BoxDT.Text;
string mess = connect.insert(nv) ? "Them thanh cong " : "Them that bai";
MessageBox.Show(mess);
}
private void butEdit_Click(object sender, EventArgs e)
{
classNV nv = new classNV();
nv.hoten = sHoten.Text;
nv.ns = sNgaysinh.Value;
nv.quequan = sQuequan.Text;
nv.donvi = sDonvi.Text;
nv.hesoluong = int.Parse(sBacluong.Text);
nv.socmnd = sCMND.Text;
nv.sodienthoai = sDienthoai.Text;
string mess = connect.edit(nv,sCMND.Text) ? "Sua thanh cong " : "Sua that bai";
MessageBox.Show(mess);
}
private void butEdit_Click(object sender, EventArgs e)
{
classNV nv = new classNV();
nv.hoten = sHoten.Text;
nv.ns = sNgaysinh.Value;
nv.quequan = sQuequan.Text;
nv.donvi = sDonvi.Text;
nv.hesoluong = int.Parse(sBacluong.Text);
nv.socmnd = sCMND.Text;
nv.sodienthoai = sDienthoai.Text;
string mess = connect.edit(nv, sCMND.Text) ? "Sua thanh cong " : "Sua that bai";
MessageBox.Show(mess);
}
private void butInsert_Click(object sender, EventArgs e)
{
classNV nv = new classNV();
nv.hoten = in_boxName.Text;
nv.ns = in_boxNS.Value;
nv.quequan = in_boxQq.Text;
nv.donvi = in_boxDV.Text;
nv.hesoluong = int.Parse(in_boxBL.Text);
nv.socmnd = in_boxCMND.Text;
nv.sodienthoai = in_BoxDT.Text;
string mess = connect.insert(nv) ? "Them thanh cong " : "Them that bai";
MessageBox.Show(mess);
}
public static bool insert(classNV s)
{
bool isInsert = false;
if (isConnect())
{
SqlCommand com = new SqlCommand();
com.CommandText = "Add_NV";
com.CommandType = CommandType.StoredProcedure;
com.Parameters.AddWithValue("@hoten", s.hoten);
com.Parameters.AddWithValue("@ngaysinh", s.ns);
com.Parameters.AddWithValue("@quequan", s.quequan);
com.Parameters.AddWithValue("@hesoluong", s.hesoluong);
com.Parameters.AddWithValue("@maphong", s.donvi);
com.Parameters.AddWithValue("@sodt", s.sodienthoai);
com.Parameters.AddWithValue("@socmnd", s.socmnd);
com.Connection = con;
int i = com.ExecuteNonQuery();
isInsert = i > 0 ? true : false;
}
return isInsert;
}
public static bool insert(classNV s)
{
bool isInsert = false;
if (isConnect())
{
SqlCommand com = new SqlCommand();
com.CommandText = "Add_NV";
com.CommandType = CommandType.StoredProcedure;
com.Parameters.AddWithValue("@hoten", s.hoten);
com.Parameters.AddWithValue("@ngaysinh", s.ns);
com.Parameters.AddWithValue("@quequan", s.quequan);
com.Parameters.AddWithValue("@hesoluong", s.hesoluong);
com.Parameters.AddWithValue("@maphong", s.donvi);
com.Parameters.AddWithValue("@sodt", s.sodienthoai);
com.Parameters.AddWithValue("@socmnd", s.socmnd);
com.Connection = con;
int i = com.ExecuteNonQuery();
isInsert = i > 0 ? true : false;
}
return(isInsert);
}
public static classNV tim_theo_ten(string name)
{
classNV result = new classNV();
return result;
}
public static classNV tim_theo_ID(string ID)
{
classNV result = new classNV();
return result;
//tim khong thanh cong return null
}
