private void GetRecordById(int recordId)
{
BirthdateResponse res = _repo.GetRecordById(recordId);
Console.WriteLine($"Id: {res.Id}");
Console.WriteLine($"Name: {res.FullName}");
Console.WriteLine($"DOB: {res.Dob}");
Console.WriteLine($"DOD: {res.Dod}");
Console.WriteLine($"Notoriety: {res.Notoriety}");
Console.WriteLine($"Created At: {res.CreatedAt}");
Console.WriteLine($"Updated At: {res.UpdatedAt}");
}
public BirthdateResponse Create(BirthdateCreateRequest req)
{
int id = _birthdates.Create(req);
BirthdateResponse resp = new BirthdateResponse();
resp.Id = id;
resp.FullName = req.FullName;
resp.Dob = req.Dob;
resp.Dod = req.Dod;
resp.Notoriety = req.Notoriety;
resp.CreatedAt = DateTime.Now;
resp.UpdatedAt = DateTime.Now;
return(resp);
}
private static BirthdateResponse Mapper(SqlDataReader reader)
{
BirthdateResponse br = new BirthdateResponse();
br.Id = reader.GetInt32("Id");
br.FullName = reader.GetString("FulName");
br.Dob = reader.GetDateTime("Dob");
if (!reader.IsDBNull("Dod"))
{
br.Dod = reader.GetDateTime("Dod");
}
br.Notoriety = reader.GetString("Notoriety");
br.CreatedAt = reader.GetDateTime("CreatedAt");
br.UpdatedAt = reader.GetDateTime("UpdatedAt");
return(br);
}
public List <BirthdateResponse> GetAll()
{
List <BirthdateResponse> resp = new List <BirthdateResponse>();
using (SqlConnection conn = new SqlConnection(ConnString))
{
using (SqlCommand cmd = new SqlCommand("BirthDates_SelectAll", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
BirthdateResponse br = Mapper(reader);
resp.Add(br);
}
conn.Close();
}
}
return(resp);
}
public BirthdateResponse GetRecordById(int recordId)
{
BirthdateResponse resp = new BirthdateResponse();
using (SqlConnection conn = new SqlConnection(ConnString))
{
using (SqlCommand cmd = new SqlCommand("BirthDates_SelectById", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Id", recordId);
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
resp = Mapper(reader);
}
conn.Close();
}
}
return(resp);
}
private void UpdateRecord()
{
BirthdateUpdateRequest req = new BirthdateUpdateRequest();
Console.Write("Provide Record ID: ");
req.Id = int.Parse(Console.ReadLine());
BirthdateResponse res = _repo.GetRecordById(req.Id);
Console.Write($"Full Name({res.FullName}): ");
req.FullName = Console.ReadLine();
if (string.IsNullOrWhiteSpace(req.FullName))
{
req.FullName = res.FullName;
}
Console.Write($"Date of Birth({res.Dob}): ");
if (DateTime.TryParse(Console.ReadLine(), out var dob))
{
req.Dob = dob;
}
else
{
req.Dob = res.Dob;
}
Console.Write($"Date of Death({res.Dod}): ");
if (DateTime.TryParse(Console.ReadLine(), out var dod))
{
req.Dod = dod;
}
else
{
req.Dod = res.Dod;
}
Console.Write($"Notoriety({res.Notoriety}): ");
req.Notoriety = Console.ReadLine();
if (string.IsNullOrWhiteSpace(req.Notoriety))
{
req.Notoriety = res.Notoriety;
}
_repo.Update(req);
}
public IActionResult CreateBirthDate([FromBody] BirthdateCreateRequest req)
{
BirthdateResponse resp = _birthdateRepository.Create(req);
return(CreatedAtAction("GetBirthDateById", new { birthDateId = resp.Id }, resp));
}
public BirthdateResponse GetRecordById(int id)
{
BirthdateResponse res = _birthdates.GetRecordById(id);
return(res);
}
