public bool Update(Employee employee)
{
using (con)
{
try
{
con.Open();
cmd = new SqlCommand("uspUpdateTemptble", con)
{
CommandType = CommandType.StoredProcedure
};
cmd.Parameters.AddWithValue("@id", employee.Id);
cmd.Parameters.AddWithValue("@name", employee.Name);
cmd.Parameters.AddWithValue("@salary", employee.Salary);
cmd.Parameters.AddWithValue("@yearsInAdapty", employee.YearsInAdapty);
cmd.ExecuteNonQuery();
return(true);
}
catch (Exception ex)
{
ExLogger.Logger(ex, con);
}
}
return(false);
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
AppDomain currentDomain = AppDomain.CurrentDomain;
currentDomain.UnhandledException += UnhandledExceptionsHandler;
TaskScheduler.UnobservedTaskException += UnobservedTaskException;
Application.Current.DispatcherUnhandledException += DispatcherUnhandledException;
try
{
bot = new TwitchBot();
bot.NotifyAboutNotices += OpenErrorMessageFromDifThread;
bot.ShowStaff += ShowStaffFromDifThread;
bot.Destination = new Endpoint();
bot.Destination.EndpointAddress = "irc.twitch.tv";
bot.Destination.EndpointPort = 6667;
}
catch (Exception ex)
{
string errorMessage = String.Format("[FatalError]{0}", ex.ToString());
ExLogger.ExLog(ex.ToString());
OpenErrorMessage(errorMessage);
throw;
}
MainWindowName.DataContext = bot;
}
public List <Employee> GetAllData()
{
using (con)
{
try
{
con.Open();
cmd = new SqlCommand("uspGetAllDataTemptble", con)
{
CommandType = CommandType.StoredProcedure
};
reader = cmd.ExecuteReader();
List <Employee> employees = new List <Employee>();
while (reader.Read())
{
employees.Add(new Employee
{
Id = Convert.ToInt32(reader["id"]),
Date = Convert.ToDateTime(reader["date"]),
Name = Convert.ToString(reader["name"]),
Salary = Convert.ToDecimal(reader["salary"]),
CalculatedSalary = Convert.ToDecimal(GetSafeValue(reader["calculatedSalary"])),
YearsInAdapty = Convert.ToDouble(GetSafeValue(reader["yearsInAdapty"]))
});
}
;
return(employees);
}
catch (Exception ex)
{
ExLogger.Logger(ex, con);
return(null);
}
}
}
public bool Save(Employee employee)
{
using (con)
{
try
{
con.Open();
cmd = new SqlCommand("uspInsertTemptble", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@name", employee.Name);
cmd.Parameters.AddWithValue("@salary", employee.Salary);
cmd.Parameters.AddWithValue("@yearsInAdapty", employee.YearsInAdapty);
cmd.ExecuteNonQuery();
return(true);
}
catch (Exception ex)
{
ExLogger.Logger(ex, con);
}
//cannot write return false; in finally block because finally block cannot have return
}
return(false);
}
void UnhandledExceptionsHandler(object sender, UnhandledExceptionEventArgs args)
{
Exception e = (Exception)args.ExceptionObject;
string errorMessage = "[UnhandledExceptionsHandler]" + e.ToString();
ExLogger.ExLog(errorMessage);
}
private void ForwardQuizButtonClick(object sender, RoutedEventArgs e)
{
try
{
bot.NextQuestion();
}
catch (Exception ex)
{
string errorMessage = String.Format("[FatalError]{0}", ex.ToString());
ExLogger.ExLog(ex.ToString());
OpenErrorMessage(errorMessage);
throw;
}
}
private void QuickAddQuestion(object sender, RoutedEventArgs e)
{
try
{
bot.AddNewQuizObject("", "");
}
catch (Exception ex)
{
string errorMessage = String.Format("[FatalError]{0}", ex.ToString());
ExLogger.ExLog(ex.ToString());
OpenErrorMessage(errorMessage);
throw;
}
}
public ActionResult Delete(Employee employee)
{
try
{
// TODO: Add delete logic here
employees.Delete(employee);
return(RedirectToAction("Index"));
}
catch (Exception ex)
{
ExLogger.Logger(ex, @"D:\ErrorLog.txt");
return(View(ex.Message));
}
}
private void DropTheList(object sender, RoutedEventArgs e)
{
try
{
bot.DropTheQuizList();
}
catch (Exception ex)
{
string errorMessage = String.Format("[FatalError]{0}", ex.ToString());
ExLogger.ExLog(ex.ToString());
OpenErrorMessage(errorMessage);
throw;
}
}
public ActionResult Edit(Employee employee)
{
if (!ModelState.IsValid)
{
return(View());
}
try
{
// TODO: Add update logic here
employees.Update(employee);
return(RedirectToAction("Index"));
}
catch (Exception ex)
{
ExLogger.Logger(ex, @"D:\ErrorLog.txt");
return(View(ex.Message));
}
}
private void AskSelectedQuestion(object sender, RoutedEventArgs e)
{
try
{
QuizObject qo = (QuizObject)QuizDataGrid.SelectedItem;
if (qo != null)
{
bot.AskScpecifiedQuestion(qo);
}
}
catch (Exception ex)
{
string errorMessage = String.Format("[FatalError]{0}", ex.ToString());
ExLogger.ExLog(ex.ToString());
OpenErrorMessage(errorMessage);
throw;
}
}
public ActionResult Create(Employee employee)
{
if (!ModelState.IsValid)
{
return(View());
}
try
{
// TODO: Add insert logic here
employees.Create(employee);
return(RedirectToAction("Index"));
}
catch (Exception ex)
{
ExLogger.Logger(ex, @"D:\ErrorLog.txt");
return(View("Error"));
}
}
private void SendClick(object sender, RoutedEventArgs e)
{
try
{
string messageToSend = MessageBox.Text;
//IrcCommand ic = new IrcCommand(null, "PRIVMSG", new IrcCommandParameter("#"+bot.TwitchChannel, false), new IrcCommandParameter(messageToSend, true));
//bot.SendMessage(ic.ToString() + "\r\n");
bot.SendMessageToCurrentChannel(messageToSend);
MessageBox.Text = "";
}
catch (Exception ex)
{
string errorMessage = String.Format("[FatalError]{0}", ex.ToString());
ExLogger.ExLog(ex.ToString());
OpenErrorMessage(errorMessage);
throw;
}
}
private void SelectionChangedOccured(object sender, SelectionChangedEventArgs e)
{
try
{
QuizObject qo = (QuizObject)QuizDataGrid.SelectedItem;
if (qo != null)
{
QuizDataGrid.ScrollIntoView(qo);
}
Console.WriteLine();
}
catch (Exception ex)
{
string errorMessage = String.Format("[FatalError]{0}", ex.ToString());
ExLogger.ExLog(ex.ToString());
OpenErrorMessage(errorMessage);
throw;
}
}
public bool Delete(Employee employee)
{
using (con)
{
try
{
con.Open();
cmd = new SqlCommand("uspDeleteTemptble", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@id", employee.Id);
cmd.ExecuteNonQuery();
return(true);
}
catch (Exception ex)
{
ExLogger.Logger(ex, con);
}
}
return(false);
}
private void StartQuizButtonClick(object sender, RoutedEventArgs e)
{
try
{
if (bot.QuizList.Count() == 0)
{
OpenErrorMessage("You should specify file containing a quiz or manually add some questions!");
}
else
{
bot.SendMessageToCurrentChannel("Quiz is starting!");
bot.StartQuiz();
}
}
catch (Exception ex)
{
string errorMessage = String.Format("[FatalError]{0}", ex.ToString());
ExLogger.ExLog(ex.ToString());
OpenErrorMessage(errorMessage);
throw;
}
}
private void AppendQuestionToTheFile(object sender, RoutedEventArgs e)
{
if (String.IsNullOrEmpty(bot.QuizFile) || String.IsNullOrWhiteSpace(bot.QuizFile))
{
OpenErrorMessage("You should specify a quiz file first");
return;
}
try
{
QuizObject qo = (QuizObject)QuizDataGrid.SelectedItem;
if (qo != null)
{
bot.AppendQuizObjectToTheQuizFile(qo);
}
}
catch (Exception ex)
{
string errorMessage = String.Format("[FatalError]{0}", ex.ToString());
ExLogger.ExLog(ex.ToString());
OpenErrorMessage(errorMessage);
throw;
}
}
void UnobservedTaskException(object sender, UnobservedTaskExceptionEventArgs e)
{
string errorMessage = "[UnobservedTaskException]" + e.ToString();
ExLogger.ExLog(errorMessage);
}
void DispatcherUnhandledException(object sender, System.Windows.Threading.DispatcherUnhandledExceptionEventArgs e)
{
string errorMessage = "[DispatcherUnhandledException]" + e.ToString();
ExLogger.ExLog(errorMessage);
}
