public bool UpdateSuCo(SuCo su)
{
SqlCommand command = new SqlCommand("Update_SuCo", Connection);
command.CommandType = CommandType.StoredProcedure;
try
{
command.Parameters.Add(new SqlParameter("@MaKH", SqlDbType.Int, 32, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, su.MaKeHoach));
command.Parameters.Add(new SqlParameter("@MaSC", SqlDbType.Int, 32, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, su.MaSC));
command.Parameters.Add(new SqlParameter("@DiaDanh", SqlDbType.NVarChar, 150, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, su.DiaDanh));
command.Parameters.Add(new SqlParameter("@DienTich", SqlDbType.Int, 64, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, su.DienTich));
Connection.Open();
command.ExecuteNonQuery();
return(true);
}
catch (SqlException ex)
{
Connection.Close();
command.Dispose();
throw new Exception("User::UpdatePass::Error occured.", ex);
}
finally
{
Connection.Close();
command.Dispose();
}
}
public bool DeleteSuCo(SuCo su)
{
string query = "Delete_SuCo";
string[] para;
para = new string[1];
para[0] = "@maSC";
object[] values;
values = new object[1];
values[0] = su.MaSC;
try
{
connection connect = new connection();
int a = Excute_Sql(query, CommandType.StoredProcedure, para, values);
if (a != 0)
{
return(true);
}
return(false);
}
catch (SqlException ex)
{
DialogResult d;
d = MessageBox.Show("Thông tin xóa không hợp lệ!");
return(false);
}
finally
{
}
}
public bool Insert_SuCo(SuCo su)
{
string query = "Insert_SuCo";
string[] para;
para = new string[4];
para[0] = "@MaKH";
para[1] = "@MaSC";
para[2] = "@DiaDanh";
para[3] = "@DienTich";
object[] values;
values = new object[4];
values[0] = su.MaKeHoach;
values[1] = su.MaSC;
values[2] = su.DiaDanh;
values[3] = su.DienTich;
try
{
int a = Excute_Sql(query, CommandType.StoredProcedure, para, values);
if (a != 0)
{
return(true);
}
return(false);
}
catch (SqlException ex)
{
DialogResult d;
d = MessageBox.Show("Thông tin thêm không hợp lệ!");
return(false);
}
finally
{
}
}