public bool Insert(Models.Servicos servico)
{
try
{
var sql = string.Format("INSERT INTO tbservicos ( nomeservico, descricao, vlservico, dtcadastro, dtultalteracao, situacao, unidade) VALUES ('{0}', '{1}', {2}, '{3}', '{4}', '{5}', '{6}')",
this.FormatString(servico.nomeServico),
!string.IsNullOrEmpty(servico.descricao) ? this.FormatString(servico.descricao) : "",
servico.vlServico.ToString().Replace(",", "."),
DateTime.Now.ToString("yyyy-MM-dd"),
DateTime.Now.ToString("yyyy-MM-dd"),
this.FormatString(servico.situacao),
this.FormatString(servico.unidade)
);
OpenConnection();
SqlQuery = new SqlCommand(sql, con);
int i = SqlQuery.ExecuteNonQuery();
if (i > 1)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception error)
{
throw new Exception(error.Message);
}
finally
{
CloseConnection();
}
}
public bool Update(Models.Servicos servicos)
{
try
{
string sql = "UPDATE tbservicos SET nomeservico = '"
+ this.FormatString(servicos.nomeServico) + "'," +
" descricao = '" + (!string.IsNullOrEmpty(servicos.descricao) ? this.FormatString(servicos.descricao) : "") + "'," +
" vlservico = " + this.FormatDecimal(servicos.vlServico) + ", " +
" situacao = '" + this.FormatString(servicos.situacao) + "'," +
" dtultalteracao = '" + DateTime.Now.ToString("yyyy-MM-dd") + "', " +
" unidade = '" + this.FormatString(servicos.unidade) + "'"
+ " WHERE codservico = " + servicos.codigo;
OpenConnection();
SqlQuery = new SqlCommand(sql, con);
int i = SqlQuery.ExecuteNonQuery();
if (i > 1)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception error)
{
throw new Exception(error.Message);
}
finally
{
CloseConnection();
}
}
public Servicos GetServico(int?codServico)
{
try
{
var model = new Models.Servicos();
if (codServico != null)
{
OpenConnection();
var sql = this.Search(codServico, null);
SqlQuery = new SqlCommand(sql, con);
reader = SqlQuery.ExecuteReader();
while (reader.Read())
{
model.codigo = Convert.ToInt32(reader["Servico_ID"]);
model.nomeServico = Convert.ToString(reader["Servico_Nome"]);
model.descricao = Convert.ToString(reader["Servico_Descricao"]);
model.vlServico = Convert.ToDecimal(reader["Servico_Valor"]);
model.dtCadastro = Convert.ToDateTime(reader["Servico_DataCadastro"]);
model.dtUltAlteracao = Convert.ToDateTime(reader["Servico_DataUltAlteracao"]);
model.situacao = Convert.ToString(reader["Servico_Situacao"]);
model.unidade = Convert.ToString(reader["Servico_Unidade"]);
}
}
return(model);
}
catch (Exception error)
{
throw new Exception(error.Message);
}
finally
{
CloseConnection();
}
}
