public BirthdayModel GetById(int Id)
{
BirthdayModel birthdayModel = new BirthdayModel();
var sqlQuery = "SELECT * FROM Birthday WHERE Id = " + Id;
using (SqlConnection con = new SqlConnection(_connectionString))
{
using (var sqlConnection = new SqlConnection(_connectionString)) //já faz o close e dispose
using (var sqlCommand = new SqlCommand(sqlQuery, sqlConnection))
{
sqlCommand.CommandType = CommandType.Text;
sqlConnection.Open();
using (var reader = sqlCommand.ExecuteReader())
{
var idColumnIndex = reader.GetOrdinal(nameof(BirthdayModel.Id));
var nomeColumnIndex = reader.GetOrdinal(nameof(BirthdayModel.Nome));
var sobrenomeColumnIndex = reader.GetOrdinal(nameof(BirthdayModel.Sobrenome));
var dataNascimentoColumnIndex = reader.GetOrdinal(nameof(BirthdayModel.DataNascimento));
while (reader.Read())
{
birthdayModel.Id = reader.GetFieldValue <int>(idColumnIndex);
birthdayModel.Nome = reader.GetFieldValue <string>(nomeColumnIndex);
birthdayModel.Sobrenome = reader.GetFieldValue <string>(sobrenomeColumnIndex);
birthdayModel.DataNascimento = reader.GetFieldValue <DateTime>(dataNascimentoColumnIndex);
}
}
}
}
return(birthdayModel);
}
public override Task InitializeAsync(object navigationData)
{
_birthdayId = (int)navigationData;
if (_birthdayId == 0)
{
Title = Resmgr.Value.GetString(ConstantsHelper.CreateBirthdayTitle, CultureInfo.CurrentCulture);
SelectedBirthDateViewModel = BirthDateViewModels.FirstOrDefault();
}
else
{
_model = App.BirthdaysRepository.Value.GetBirthdayAsync(_birthdayId);
Title = _model.Name;
Name = _model.Name;
ImageContent = _model.ImageContent;
AdditionalInfo = _model.GiftDescription;
SelectedBirthDateViewModel = BirthDateViewModels
.FirstOrDefault(x => x.MonthNumber == _model.BirthDayDate.Month);
OnAppearing();
SelectedBirthDateViewModel.SelectDay(_model.BirthDayDate.Day);
}
return(base.InitializeAsync(navigationData));
}
public NotificationsModel GetNotifications()
{
string BaseUrl = ConfigurationManager.ConnectionStrings["NotificationServerName"].ConnectionString;
string url = BaseUrl + DestinationNames.GetNotifications;
HttpWebRequest req = (HttpWebRequest)HttpWebRequest.Create(url);
req.Method = "GET";
HttpWebResponse resp = (HttpWebResponse)req.GetResponse();
using (Stream stream = resp.GetResponseStream())
{
BinaryFormatter bf = new BinaryFormatter();
var sr = new StreamReader(stream);
Notifications notifications = (Notifications)bf.Deserialize(stream);
NotificationsModel notificationsModel = new NotificationsModel();
foreach (Notification el in notifications.ListOfEvents)
{
Models.NotificationModel item = new NotificationModel();
DateTime newDt = new DateTime(DateTime.Now.Year, el.Date.Month, el.Date.Day);
item.Date = newDt;
item.Address = el.Address;
item.Type = el.Type;
notificationsModel.ListOfEvents.Add(item);
}
foreach (Birthday el in notifications.ListOfBirthdays)
{
BirthdayModel day = new BirthdayModel();
day.Date = el.Date;
day.FirstName = el.FirstName;
day.LastName = el.LastName;
notificationsModel.ListOfBirthdays.Add(day);
}
return(notificationsModel);
}
}
public static Birthday MapToBirthday(BirthdayModel contractBirthday)
{
return(new Birthday
{
Id = contractBirthday.Id,
Name = contractBirthday.Name,
Birthdate = contractBirthday.Birthdate
});
}
public void Save(BirthdayModel model)
{
if (model.Id != 0)
{
_db.InsertOrReplaceWithChildren(model);
}
else
{
_db.InsertWithChildren(model);
}
}
public static BirthdayViewModel ToBirthdayViewModel(this BirthdayModel model)
{
return(new BirthdayViewModel
{
Id = model.Id,
Name = model.Name,
ImageContent = model.ImageContent,
BirthDayDate = model.BirthDayDate,
GiftDescription = model.GiftDescription
});
}
public void Put(int id, [FromBody] BirthdayModel birthdayModel)
{
Birthday birthDay = _myService.GetMyEntities(bd => bd.Id == id).FirstOrDefault();
if (birthDay != null)
{
birthDay.Birthdate = !string.IsNullOrWhiteSpace(birthdayModel.Birthdate.ToString("yyyy-mm-dd")) ? birthdayModel.Birthdate : birthDay.Birthdate;
birthDay.Name = !string.IsNullOrWhiteSpace(birthdayModel.Name) ? birthdayModel.Name : birthDay.Name;
_myService.UpdateMyEntity(birthDay);
}
}
public void Insert(BirthdayModel birthdayModel)
{
if (birthdayModel == null)
{
throw new ArgumentNullException("Error");
}
if (string.IsNullOrWhiteSpace(birthdayModel.Nome) || birthdayModel.Nome.Length < 3)
{
throw new ArgumentException("Nome da pessoa inválido");
}
_birthdayDB.Insert(birthdayModel);
}
public ActionResult Edit(BirthdayModel editBirthdayModel)
{
try
{
// TODO: Add update logic here
_birthdayRepository.Update(editBirthdayModel);
return(RedirectToAction(nameof(Index)));
}
catch
{
return(View());
}
}
public IActionResult Delete(BirthdayModel birthdayDelete)
{
try
{
// TODO: Add delete logic here
_birthdayService.Delete(birthdayDelete.Id);
return(RedirectToAction(nameof(Index)));
}
catch
{
return(View());
}
}
public ActionResult Create(BirthdayModel createBirthdayModel)
{
try
{
// TODO: Add insert logic here
_birthdayRepository.Add(createBirthdayModel);
return(RedirectToAction(nameof(Index)));
}
catch
{
return(View());
}
}
public ActionResult Create(BirthdayModel birthdayCreate)
{
try
{
// TODO: Add insert logic here
_birthdayService.Insert(birthdayCreate);
return(RedirectToAction(nameof(Index)));
}
catch
{
return(View());
}
}
public ActionResult Delete(BirthdayModel birthdayModel)
{
try
{
// TODO: Add delete logic here
_birthdayRepository.Remove(birthdayModel.Id);
return(RedirectToAction(nameof(Index)));
}
catch
{
return(View());
}
}
public IEnumerable <BirthdayModel> GetAll()
{
var sqlQuery = $"SELECT " +
$"Id as '{nameof(BirthdayModel.Id)}', " +
$"Nome as '{nameof(BirthdayModel.Nome)}', " +
$"Sobrenome as '{nameof(BirthdayModel.Sobrenome)}', " +
$"DataNascimento as '{nameof(BirthdayModel.DataNascimento)}' " +
$"FROM Birthday ORDER BY Id";
var birthdayList = new List <BirthdayModel>();
using (var sqlConnection = new SqlConnection(_connectionString)) //já faz o close e dispose
using (var sqlCommand = new SqlCommand(sqlQuery, sqlConnection)) //já faz o close
{
sqlCommand.CommandType = CommandType.Text;
sqlConnection.Open();
using (var reader = sqlCommand.ExecuteReader())
{
var idColumnIndex = reader.GetOrdinal(nameof(BirthdayModel.Id));
var nomeColumnIndex = reader.GetOrdinal(nameof(BirthdayModel.Nome));
var sobrenomeColumnIndex = reader.GetOrdinal(nameof(BirthdayModel.Sobrenome));
var dataNascimentoColumnIndex = reader.GetOrdinal(nameof(BirthdayModel.DataNascimento));
while (reader.Read())
{
var id = reader.GetFieldValue <int>(idColumnIndex);
var nome = reader.GetFieldValue <string>(nomeColumnIndex);
var sobrenome = reader.GetFieldValue <string>(sobrenomeColumnIndex);
var dataNascimento = reader.GetFieldValue <DateTime>(dataNascimentoColumnIndex);
var entry = new BirthdayModel
{
Id = id,
Nome = nome,
Sobrenome = sobrenome,
DataNascimento = dataNascimento
};
birthdayList.Add(entry);
}
}
}
return(birthdayList);
}
public void Initialize()
{
if (!Initialized)
{
using (var session = Store.OpenSession())
{
var model = session.Load <BirthdayModel>(BirthdayDocumentName);
if (model == null)
{
model = new BirthdayModel();
session.Store(model, BirthdayDocumentName);
session.SaveChanges();
}
Model = model;
Initialized = true;
}
}
}
public IActionResult Edit(int id, [Bind] BirthdayModel birthdayEdit)
{
try
{
// TODO: Add update logic here
if (id != birthdayEdit.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
_birthdayService.Update(birthdayEdit);
}
return(RedirectToAction(nameof(Index)));
}
catch
{
return(View(birthdayEdit));
}
}
public void Insert(BirthdayModel birthdayModel)
{
var sqlQuery = "INSERT INTO Birthday" +
" (Nome, Sobrenome, DataNascimento)"+
"VALUES (@nome, @sobrenome, @dataNascimento);";
using (var sqlConnection = new SqlConnection(_connectionString)) //já faz o close e dispose
using (var sqlCommand = new SqlCommand(sqlQuery, sqlConnection)) //já faz o close
{
sqlCommand.CommandType = CommandType.Text;
sqlCommand.Parameters
.Add("@nome", SqlDbType.VarChar).Value = birthdayModel.Nome;
sqlCommand.Parameters
.Add("@sobrenome", SqlDbType.VarChar).Value = birthdayModel.Sobrenome;
sqlCommand.Parameters
.Add("@dataNascimento", SqlDbType.DateTime).Value = birthdayModel.DataNascimento;
sqlConnection.Open();
var resutScalar = sqlCommand.ExecuteScalar();
}
}
public void Update(BirthdayModel birthdayModel)
{
var sqlQuery = "UPDATE Birthday SET Nome = @nome, Sobrenome = @sobrenome, DataNascimento = @dataNascimento WHERE Id = @id";
using (var sqlConnection = new SqlConnection(_connectionString)) //já faz o close e dispose
using (var sqlCommand = new SqlCommand(sqlQuery, sqlConnection)) //já faz o close
{
sqlCommand.CommandType = CommandType.Text;
sqlCommand.Parameters
.Add("@nome", SqlDbType.VarChar).Value = birthdayModel.Nome;
sqlCommand.Parameters
.Add("@sobrenome", SqlDbType.VarChar).Value = birthdayModel.Sobrenome;
sqlCommand.Parameters
.Add("@dataNascimento", SqlDbType.DateTime).Value = birthdayModel.DataNascimento;
sqlCommand.Parameters
.Add("@id", SqlDbType.Int).Value = birthdayModel.Id;
sqlConnection.Open();
sqlCommand.ExecuteNonQuery();
}
}
private async Task SaveBirthday()
{
if (_model == null)
{
_model = new BirthdayModel();
}
// We need to find latest leap year in order to have possibility to
// pick 29 of Feb as someone's Birthday
const int latestLeapYear = 2020;
var dateTime = new DateTime(
latestLeapYear,
SelectedBirthDateViewModel.MonthNumber,
SelectedBirthDateViewModel.SelectedDay.Number);
_model.Name = Name;
_model.GiftDescription = AdditionalInfo;
_model.ImageContent = ImageContent;
_model.BirthDayDate = dateTime;
_model.UserId = Settings.CurrentUserId;
App.BirthdaysRepository?.Value.Save(_model);
await NavigationService.NavigateBackAsync();
}
public void SaveUser(BirthdayModel config)
{
Database.Store(config, BirthdayModel.DocumentName(config.UserId));
}
public BirthdayModel GetUser(ulong userId)
{
var config = Database.Load <BirthdayModel>(BirthdayModel.DocumentName(userId));
return(config);
}
// GET: Birthday/Delete/5
public IActionResult Delete(int id)
{
BirthdayModel birthdayDelete = _birthdayService.GetById(id);
return(View(birthdayDelete));
}
// GET: Birthday/Details/5
public ActionResult Details(int id)
{
BirthdayModel birthdayDetails = _birthdayService.GetById(id);
return(View(birthdayDetails));
}
public void Update(BirthdayModel editBirthdayModel)
{
var oldBirthDayModel = GetById(editBirthdayModel.Id);
oldBirthDayModel.Nome = editBirthdayModel.Nome;
}
public void Update(BirthdayModel birthdayModel)
{
_birthdayDB.Update(birthdayModel);
}
public void Post([FromBody] BirthdayModel birthDay)
{
birthDay.Id = 0;
_myService.CreateMyEntity(BirthdaysMapper.MapToBirthday(birthDay));
}
// GET: Birthday/Edit/5
public ActionResult Edit(int id)
{
BirthdayModel birthdayEdit = _birthdayService.GetById(id);
return(View(birthdayEdit));
}
public int DeleteBirthday(BirthdayModel model)
{
return(_db.Delete(model));
}
public void Add(BirthdayModel createBirthdayModel)
{
Birthdays.Add(createBirthdayModel);
}
