public IActionResult Register([FromForm] ContasReceberModel model)
{
const string sql = "RegistarReceber";
using (SqlConnection connection = new SqlConnection(
@"Data Source=TD50001424\SQLEXPRESS;Initial Catalog=Db_Contas;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False"))
using (SqlCommand command = new SqlCommand(sql, connection))
{
command.CommandType = System.Data.CommandType.StoredProcedure;
command.Parameters.Add(new SqlParameter(@"DataVencimento", System.Data.SqlDbType.Date));
command.Parameters[@"DataVencimento"].Value = model.DataVencimento;
command.Parameters.Add(new SqlParameter(@"ClienteId", System.Data.SqlDbType.Int));
command.Parameters[@"ClienteId"].Value = model.ClienteId;
command.Parameters.Add(new SqlParameter(@"Valor", System.Data.SqlDbType.Money));
command.Parameters[@"Valor"].Value = model.Valor;
connection.Open();
command.ExecuteNonQuery();
connection.Close();
}
return(View(model));
}
public IActionResult Alterar(int Id)
{
DataTable results = new DataTable();
using (SqlConnection connection = new SqlConnection(@"Data Source=TD50001424\SQLEXPRESS;Initial Catalog=Db_Contas;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False"))
{
//Define a t-sql query string that has a parameter form id
string sql = "select FaturaId, DataVencimento, DataPgamento, ClienteId, Valor, ValorPago from dbo.ContasReceber";
using (SqlCommand command = new SqlCommand(sql, connection))
{
connection.Open();
//run query by Execuetereader
using (SqlDataReader dataReader = command.ExecuteReader())
{
results.Load(dataReader);
dataReader.Close();
}
connection.Close();
var model = new ContasReceberModel
{
FaturaId = int.Parse(results.Rows[0]["FaturaId"].ToString()),
//DataVencimento = DateTime.Parse(results.Rows[0]["DataVencimento"].ToString()),
//DataPagamento = DateTime.Parse(results.Rows[0]["DataPgamento"].ToString()),
ClienteId = int.Parse(results.Rows[0]["ClienteId"].ToString()),
Valor = decimal.Parse(results.Rows[0]["Valor"].ToString()),
//ValorPago = decimal.Parse(results.Rows[0]["ValorPago"].ToString()),
};
ContasReceberModel contas = new ContasReceberModel();
contas.CalcValorPago();
return(View(model));
}
}
}