/// <summary>
/// Fill grid
/// </summary>
private void FillGrid()
{
DbCommunicator db = DbCommunicator.CreateInstance(_connectionString);
try
{
log.Info("Get data to fill grid");
db.OpenConnection();
dataSet.Clear();
dataSet = db.ExecuteQuery(DBQuery.GET_TASK_DATA, "task");
dataGridView.DataSource = dataSet.Tables["task"];
}
catch (Exception ex)
{
log.Error("Exception message is : " + ex.Message);
throw ex;
}
finally
{
if (null != db)
{
db.CloseConnection();
}
}
}
/// <summary>
/// Add new task.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void AddTaskEventHanlder(object sender, EventArgs e)
{
DbCommunicator db = DbCommunicator.CreateInstance(_connectionString);
try
{
log.Info("Adding new task");
// Fields validation in add task form.
bool validationStatus = FieldValidation();
if (true == validationStatus)
{
log.Info("Successful validation");
db.OpenConnection();
int isReminder = (true == radioYes.Checked) ? 1 : 0;
string query = String.Format(DBQuery.INSERT_TASK, txtTitle.Text, txtItemDesc.Text,
DateTime.Parse(clderStartTime.Text).ToString("yyyy-MM-dd HH:mm:ss"),
DateTime.Parse(cldrEndTime.Text).ToString("yyyy-MM-dd HH:mm:ss"),
cmbStatus.SelectedItem,
isReminder,
txtNotificationTime.Text,
_name
);
log.Info("Query to add new task is : " + query);
int numberOfRows = db.ExecuteNonQuery(query);
if (0 < numberOfRows)
{
log.Info("New task added successfully with title " + txtTitle.Text);
MessageBox.Show("Task added successfully. You will be notified " +
txtNotificationTime.Text + " min(s) before the task",
this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
UpdateGridDataEvent();
}
else
{
log.Info("Failed to add new task.");
MessageBox.Show("Failed to add todo task record in database.",
this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
else
{
return;
}
}
catch (Exception ex)
{
log.Error("Exception message is : " + ex.Message);
MessageBox.Show("Failed to add todo task record in database.",
this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally {
if (null != db)
{
db.CloseConnection();
}
}
}
/// <summary>
/// Update task event handler
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void UpdateTaskEventHanlder(object sender, EventArgs e)
{
DbCommunicator db = DbCommunicator.CreateInstance(_connectionString);
try
{
log.Info("Updating task ");
// Fields validation in add task form.
bool validationStatus = FieldValidation();
if (true == validationStatus)
{
db.OpenConnection();
int isReminder = (true == radioYes.Checked) ? 1 : 0;
string query = String.Format(DBQuery.UPDATE_TASK, txtTitle.Text, txtItemDesc.Text,
clderStartTime.Text,
cldrEndTime.Text,
cmbStatus.SelectedItem,
isReminder,
txtNotificationTime.Text,
_taskId);
log.Info("Query to update task is : " + query);
int numberOfRows = db.ExecuteNonQuery(query);
if (0 < numberOfRows)
{
MessageBox.Show("Task updated successfully. You will be notified " +
txtNotificationTime.Text + " min(s) before the task",
this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
log.Info("Task updated successfully.");
// Fire event to upgrade grid data.
UpdateGridDataEvent();
}
else
{
log.Info("Failed to update task.");
MessageBox.Show("Failed to update todo task record in database.",
this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
else
{
return;
}
}
catch (Exception ex)
{
MessageBox.Show("Failed to update todo task record in database.",
this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
log.Info("Exception message is : " + ex.Message);
}
finally
{
if (null != db)
{
db.CloseConnection();
}
}
}
/// <summary>
/// click event handler for register button.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnRegister_Click(object sender, EventArgs e)
{
DbCommunicator db = DbCommunicator.CreateInstance(_connectionString);
try
{
log.Info("Clicked on Register button on New User form.");
//Validate Field on Add user form.
bool isValid = FieldsValidator();
if (true == isValid)
{
db.OpenConnection();
string query = String.Format(DBQuery.INSERT_USER, txtNewUsername.Text, txtNewPassword.Text, txtEmail.Text);
int numberofRows = db.ExecuteNonQuery(query);
if (0 < numberofRows)
{
log.Info("New user added successfully.");
MessageBox.Show(txtNewUsername.Text + " user added successfully.", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
log.Error("Failed to add new user");
MessageBox.Show("Failed to insert new user", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
return;
}
}
catch (Exception ex)
{
MessageBox.Show("Someting went wrong...", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
log.Error("Exception message is : " + ex.Message);
}
finally {
if (null != db)
{
db.CloseConnection();
}
}
}
/// <summary>
/// Check login status
/// </summary>
public void Login()
{
DbCommunicator db = DbCommunicator.CreateInstance(_connectionString);
try
{
log.Info("Checking login for user.");
db.OpenConnection();
string query = String.Format(DBQuery.GET_USER_COUNT, txtUserName.Text, txtPassword.Text);
int numberOfRows = db.ExecuteScalar(query);
if (0 < numberOfRows)
{
log.Info("Successful login for user" + txtUserName.Text);
// On login success open form main.
LoginSuccessEvent();
}
else
{
log.Error("Login failed for " + txtUserName.Text);
MessageBox.Show("Invalid credentails. \nPlease check username/password.",
this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
Application.Exit();
}
}
catch (Exception ex)
{
MessageBox.Show("Something went wrong",
this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
log.Error("Exception message is : " + ex.Message);
Application.Exit();
}
finally {
if (null != db)
{
db.CloseConnection();
}
}
}