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