public void updateSematInfo(VahedReshteDTO vrd)
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "graduate.SP_updateSematInfo";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@id", vrd.id);
cmd.Parameters.AddWithValue("@semat", vrd.sematName);
cmd.Connection = conn;
try
{
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
catch
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
throw;
}
}
public void updateReshteVahedInfo(VahedReshteDTO vrd)
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "graduate.SP_updateReshteVahedInfo";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@reshte", vrd.reshte);
cmd.Parameters.AddWithValue("@Vahed", vrd.Vahed);
cmd.Parameters.AddWithValue("@voroodi", vrd.voroodi);
cmd.Connection = conn;
try
{
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
catch
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
throw;
}
}
public int setSematInfo(VahedReshteDTO vrd)
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "graduate.SP_setSematInfo";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@semat", vrd.sematName);
cmd.Connection = conn;
try
{
conn.Open();
int id = Convert.ToInt32(cmd.ExecuteScalar());
conn.Close();
return(id);
}
catch
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
return(0);
throw;
}
}
public void updateSematVahedInfo(VahedReshteDTO vrd)
{
vrDAO.updateSematVahedInfo(vrd);
}
public int setSematInfo(VahedReshteDTO vrd)
{
return(vrDAO.setSematInfo(vrd));
}
public int setSematvahed(VahedReshteDTO vrd)
{
return(vrDAO.setSematVahed(vrd));
}
public int setvahedReshte(VahedReshteDTO vrd)
{
return(vrDAO.setVahedReshte(vrd));
}
