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)); }