/// <summary>
/// Get TipoServico by id
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public TipoServico GetTipoServico(string id)
{
int newId;
if (!Int32.TryParse(id, out newId))
{
return(null);
}
SqlDataReader rdr = null;
OpenDB();
// create a command object
SqlCommand cmd = new SqlCommand("select * from TipoServico", cnn);
rdr = cmd.ExecuteReader();
while (rdr.Read())
{
if (newId == (int)rdr["TipoServicoID"])
{
TipoServico s = new TipoServico();
s.TipoServicoId = (int)rdr["TipoServicoID"];
s.NomeServico = (string)rdr["NomeServico"];
s.PrefixoServico = (string)rdr["PrefixoServico"];
return(s);
}
}
CloseDB();
return(null);
}
/// <summary>
/// Update TipoServico
/// </summary>
/// <param name="st"></param>
/// <returns></returns>
public bool UpdateTipoServico(TipoServico st)
{
StringBuilder query = new StringBuilder();
SqlDataReader rdr = null;
OpenDB();
query.AppendFormat("UPDATE TipoServico SET NomeServico='{0}', PrefixoServico='{1}' WHERE TipoServicoID={2};"
, st.NomeServico, st.PrefixoServico, st.TipoServicoId);
// create a command object
SqlCommand cmd = new SqlCommand(query.ToString(), cnn);
rdr = cmd.ExecuteReader();
CloseDB();
return(true);
}
/// <summary>
/// Add TipoServico
/// </summary>
/// <param name="st"></param>
/// <returns></returns>
public bool AddTipoServico(TipoServico st)
{
StringBuilder query = new StringBuilder();
SqlDataReader rdr = null;
OpenDB();
query.AppendFormat("INSERT INTO TipoServico (TipoServicoID, NomeServico, PrefixoServico) VALUES ({0}, '{1}', '{2}');"
, st.TipoServicoId, st.NomeServico, st.PrefixoServico);
// create a command object
SqlCommand cmd = new SqlCommand(query.ToString(), cnn);
rdr = cmd.ExecuteReader();
CloseDB();
return(true);
}
/// <summary>
/// Get all TipoServico
/// </summary>
/// <returns></returns>
public List <TipoServico> GetAllTipoServico()
{
List <TipoServico> list = new List <TipoServico>();
SqlDataReader rdr = null;
OpenDB();
// create a command object
SqlCommand cmd = new SqlCommand("select * from TipoServico", cnn);
rdr = cmd.ExecuteReader();
while (rdr.Read())
{
TipoServico s = new TipoServico();
s.TipoServicoId = (int)rdr["TipoServicoID"];
s.NomeServico = (string)rdr["NomeServico"];
s.PrefixoServico = (string)rdr["PrefixoServico"];
list.Add(s);
}
CloseDB();
return(list);
}