public debtCollector Map(OracleDataReader reader)
{
var collector = new debtCollector();
collector.ID = (string)reader["ID"];
collector.FirstName = (string)reader["FirstName"];
collector.SecondName = (string)reader["SecondName"];
collector.LastName = (string)reader["LastName"];
collector.BirthDate = (DateTime)reader["BirthDate"];
collector.RegistrationDate = (DateTime)reader["RegistrationDate"];
collector.ZoneWork = (string)reader["ZoneWork"];
collector.MoneyCharge = (double)reader["MoneyCharge"];
return(collector);
}
public void Save(debtCollector collector)
{
using (var command = Connection.CreateCommand())
{
command.CommandText = "PKG_INSERTA.INSERTA_DEBTCOLLECTOR";
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(":ID", OracleDbType.Varchar2).Value = collector.ID;
command.Parameters.Add(":FirstName", OracleDbType.Varchar2).Value = collector.FirstName;
command.Parameters.Add(":SecondName", OracleDbType.Varchar2).Value = collector.SecondName;
command.Parameters.Add(":LastName", OracleDbType.Varchar2).Value = collector.LastName;
command.Parameters.Add(":BirthDate", OracleDbType.Date).Value = collector.BirthDate;
command.Parameters.Add(":RegistrationDate", OracleDbType.Date).Value = collector.RegistrationDate;
command.Parameters.Add(":ZoneWork", OracleDbType.Varchar2).Value = collector.ZoneWork;
command.Parameters.Add(":MoneyCharge", OracleDbType.Varchar2).Value = collector.MoneyCharge;
command.ExecuteNonQuery();
}
}
private void BtnSave_Click(object sender, EventArgs e)
{
var answer = new DebtCollectorService.Answer();
try
{
debtCollector collector = new debtCollector();
collector.ID = TxtID.Text.ToUpper();
collector.FirstName = TxtFirstName.Text.ToUpper();
collector.SecondName = TxtSecondName.Text.ToUpper();
collector.LastName = TxtLastName.Text.ToUpper();
collector.MoneyCharge = double.Parse(TxtMoneyCharge.Text.Trim());
collector.ZoneWork = CmbZoneWork.Text;
collector.BirthDate = DtpBirthDate.Value.Date;
collector.RegistrationDate = DtpRegistrationDate.Value.Date;
answer = service.Save(collector);
MessageBox.Show(answer.Message, "Resultado de guardar", MessageBoxButtons.OKCancel, MessageBoxIcon.Information);
}
catch (Exception)
{
throw;
}
}
public Answer Save(debtCollector collector)
{
var answer = new Answer();
answer.IsError = false;
try
{
Connection.Open();
repository.Save(collector);
answer.Message = $"Se registro satisfactoriamente al cobradiario {collector.FirstName}";
return(answer);
}
catch (Exception e)
{
Connection.Close();
answer.IsError = true;
answer.Message = "Error de Base de Datos:" + e.Message.ToString();
return(answer);
}
finally
{
Connection.Close();
}
}
