private void UserControl_Loaded(object sender, RoutedEventArgs e)
{
using (var context = new DatabaseContext())
{
var markstrat = new MarketingStrategy();
if (MarketingStrategiesId > 0)
{
var markstarte = context.MarketingStrategies.FirstOrDefault(c => c.MarketingStrategyId == MarketingStrategiesId);
if (markstarte != null)
{
lblMarketingStrategyId.Visibility = Visibility.Visible;
txtMarketingStrategyId.Visibility = Visibility.Visible;
Grid.SetRow(lblMarketingStrategyName, 1);
Grid.SetRow(txtMarketingStrategyName, 1); Grid.SetColumn(txtMarketingStrategyName, 1);
txtMarketingStrategyId.Text = Convert.ToString(markstarte.MarketingStrategyId);
txtMarketingStrategyName.Text = markstarte.Description;
}
}
else
{
lblMarketingStrategyId.Visibility = Visibility.Hidden;
txtMarketingStrategyId.Visibility = Visibility.Hidden;
Grid.SetRow(lblMarketingStrategyName, 0);
Grid.SetRow(txtMarketingStrategyName, 0); Grid.SetColumn(txtMarketingStrategyName, 1);
txtMarketingStrategyName.Text = "";
}
}
}
private void btnSave_Click(object sender, RoutedEventArgs e)
{
using (var context = new DatabaseContext())
{
var mark = new MarketingStrategy();
if (txtMarketingStrategyName.Text != "" && txtMarketingStrategyName.Text != null)
{
if (MarketingStrategiesId > 0)
{
var starts = context.MarketingStrategies.FirstOrDefault(c => c.MarketingStrategyId == MarketingStrategiesId);
if (starts != null)
{
var startsname = context.MarketingStrategies.FirstOrDefault(c => c.Description == txtMarketingStrategyName.Text);
if (startsname != null)
{
if (starts.Description.ToLower() == startsname.Description.ToLower())
{
starts.Description = txtMarketingStrategyName.Text;
var log = new Log();
log.Date = DateTime.Now.ToString("MM/dd/yyyy");
log.Description = NotificationWindow.username + " modifies "
+ starts.Description + "'s details.";
log.Time = DateTime.Now.ToString("hh:mm:ss tt");
context.Logs.Add(log);
context.SaveChanges();
var windows = new NoticeWindow();
NoticeWindow.message = "Marketing strategy successfully updated";
windows.Height = 0;
windows.Top = screenTopEdge + 8;
windows.Left = (screenWidth / 2) - (windows.Width / 2);
if (screenLeftEdge > 0 || screenLeftEdge < -8) { windows.Left += screenLeftEdge; }
windows.ShowDialog();
}
else
{
var log = new Log();
log.Date = DateTime.Now.ToString("MM/dd/yyyy");
log.Description = NotificationWindow.username + " fails to modify "
+ starts.Description
+ "'s details due to a similar strategy is already existing.";
log.Time = DateTime.Now.ToString("hh:mm:ss tt");
context.Logs.Add(log);
context.SaveChanges();
var windows = new NoticeWindow();
NoticeWindow.message = "Similar marketing strategy detected";
windows.Height = 0;
windows.Top = screenTopEdge + 8;
windows.Left = (screenWidth / 2) - (windows.Width / 2);
if (screenLeftEdge > 0 || screenLeftEdge < -8) { windows.Left += screenLeftEdge; }
windows.ShowDialog();
}
}
else
{
starts.Description = txtMarketingStrategyName.Text;
var log = new Log();
log.Date = DateTime.Now.ToString("MM/dd/yyyy");
log.Description = NotificationWindow.username + " modifies "
+ starts.Description + "'s details.";
log.Time = DateTime.Now.ToString("hh:mm:ss tt");
context.Logs.Add(log);
context.SaveChanges();
var windows = new NoticeWindow();
NoticeWindow.message = "Marketing strategy successfully updated";
windows.Height = 0;
windows.Top = screenTopEdge + 8;
windows.Left = (screenWidth / 2) - (windows.Width / 2);
if (screenLeftEdge > 0 || screenLeftEdge < -8) { windows.Left += screenLeftEdge; }
windows.ShowDialog();
}
}
}
else
{
var strats = context.MarketingStrategies.FirstOrDefault
(c => c.Description.ToLower() == txtMarketingStrategyName.Text.ToLower());
if (strats == null)
{
strats = new MarketingStrategy();
strats.Description = txtMarketingStrategyName.Text;
var log = new Log();
log.Date = DateTime.Now.ToString("MM/dd/yyyy");
log.Description = NotificationWindow.username + " creates a new marketing strategy. ("
+ txtMarketingStrategyName.Text + ")";
log.Time = DateTime.Now.ToString("hh:mm:ss tt");
context.Logs.Add(log);
context.MarketingStrategies.Add(strats);
context.SaveChanges();
var windows = new Shared.Windows.NoticeWindow();
Shared.Windows.NoticeWindow.message = "Marketing strategy successfully created";
windows.Height = 0;
windows.Top = screenTopEdge + 8;
windows.Left = (screenWidth / 2) - (windows.Width / 2);
if (screenLeftEdge > 0 || screenLeftEdge < -8) { windows.Left += screenLeftEdge; }
windows.ShowDialog();
}
else
{
var log = new Log();
log.Date = DateTime.Now.ToString("MM/dd/yyyy");
log.Description = NotificationWindow.username
+ " failed to create due to a similar strategy is already existing.";
log.Time = DateTime.Now.ToString("hh:mm:ss tt");
context.Logs.Add(log);
context.SaveChanges();
var windows = new NoticeWindow();
NoticeWindow.message = "Marketing strategy already exists";
windows.Height = 0;
windows.Top = screenTopEdge + 8;
windows.Left = (screenWidth / 2) - (windows.Width / 2);
if (screenLeftEdge > 0 || screenLeftEdge < -8) { windows.Left += screenLeftEdge; }
windows.ShowDialog();
}
}
}
else
{
var windows = new NoticeWindow();
NoticeWindow.message = "Please provide all boxes labeled with an asterisk(*).";
windows.Height = 0;
windows.Top = screenTopEdge + 8;
windows.Left = (screenWidth / 2) - (windows.Width / 2);
if (screenLeftEdge > 0 || screenLeftEdge < -8) { windows.Left += screenLeftEdge; }
windows.ShowDialog();
}
}
}