public DataTable CreateTbCL(EC_CaLam _cl)
{
string sqlquery = "SELECT * FROM tb_Calam where maca like N'%{0}%' and tenca like N'%{1}%' and like N'%{2}%'";
sqlquery = string.Format(sqlquery, _cl.MaCa, _cl.TenCa, _cl.MoTa);
return(Connect.CreateTable(sqlquery));
}
public void AddCa(EC_CaLam _ca)
{
if (!sqlca.CheckCaLam(_ca.MaCa))
{
sqlca.AddCa(_ca);
}
else
{
MessageBox.Show("Mã này đã tồn tại,xin chọn Mã khác", "Chú Ý", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
public void AddCa(EC_CaLam _newca)
{
try
{
Connect.SqlConnect.Open();
string sqlquery = @"INSERT INTO tb_Calam
(maca, tenca, mota)
VALUES (N'{0}',N'{1}',N'{2}')" ;
sqlquery = string.Format(sqlquery, _newca.MaCa, _newca.TenCa, _newca.MoTa);
SqlCommand cmd = new SqlCommand(sqlquery, Connect.SqlConnect);
cmd.ExecuteNonQuery();
Connect.SqlConnect.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public void UpdateCa(EC_CaLam _ca)
{
try
{
Connect.SqlConnect.Open();
string sqlquery = @"UPDATE tb_Calam
SET tenca =N'{0}', mota = N'{1}' where maca =N'{2}'" ;
string.Format(sqlquery, _ca.TenCa, _ca.MoTa, _ca.MaCa);
SqlCommand cmd = new SqlCommand(sqlquery, Connect.SqlConnect);
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
Connect.SqlConnect.Close();
}
}
public void DeleteCa(EC_CaLam _ca)
{
Connect.ExcuteNonQuery("DELETE FROM [tb_Calam] WHERE maca=N'" + _ca.MaCa + "'");
}
public void DeleteCa(EC_CaLam _ca)
{
sqlca.DeleteCa(_ca);
}
public void UpdateCa(EC_CaLam _ca)
{
sqlca.UpdateCa(_ca);
}
public DataTable CreateTbCL(EC_CaLam _cl)
{
return(sqlca.CreateTbCL(_cl));
}