public bool Delete(cfiBLL u)
{
bool isSucces = false;
SqlConnection conn = new SqlConnection(myconnstring);
try
{
string sql = "delete FROM Cfi where Id=@Id";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@Id", u.Id);
conn.Open();
int rows = cmd.ExecuteNonQuery();
if (rows > 0)
{
isSucces = true;
}
else
{
isSucces = false;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
return(isSucces);
}
public bool Insert(cfiBLL u)
{
bool isSucces = false;
SqlConnection conn = new SqlConnection(myconnstring);
try
{
string sql = "INSERT INTO Cfi (Cfi,Description,CfiRatach) VALUES (@Cfi,@Description,@CfiRatach) ";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@Cfi", u.Cfi);
cmd.Parameters.AddWithValue("@Description", u.Description);
cmd.Parameters.AddWithValue("@CfiRatach", u.CfiRatach);
conn.Open();
int rows = cmd.ExecuteNonQuery();
if (rows > 0)
{
isSucces = true;
}
else
{
isSucces = false;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
return(isSucces);
}
public bool Modifier(cfiBLL u)
{
bool isSucces = false;
SqlConnection conn = new SqlConnection(myconnstring);
try
{
string sql = "UPDATE Cfi set Cfi=@Cfi,Description=@Description,CfiRatach=@CfiRatach where Id=@Id";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@Cfi", u.Cfi);
cmd.Parameters.AddWithValue("@Description", u.Description);
cmd.Parameters.AddWithValue("@CfiRatach", u.CfiRatach);
cmd.Parameters.AddWithValue("@Id", u.Id);
conn.Open();
int rows = cmd.ExecuteNonQuery();
if (rows > 0)
{
isSucces = true;
}
else
{
isSucces = false;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
return(isSucces);
}
