internal bool RestoreTable(DataBaseName dbName)
{
bool result = false;
switch (dbName)
{
case DataBaseName.Users:
result = LoadSQLTextFile(SQLStatement.GetInsertUserQuery());
break;
case DataBaseName.Category:
result = LoadSQLTextFile(SQLStatement.GetInsertCategoryQuery());
break;
case DataBaseName.Period_Type:
result = LoadSQLTextFile(SQLStatement.GetInsertPeriodTypeQuery());
break;
case DataBaseName.Period:
break;
case DataBaseName.Staff:
break;
case DataBaseName.All:
result = (LoadSQLTextFile(SQLStatement.GetInsertUserQuery()) &&
LoadSQLTextFile(SQLStatement.GetInsertCategoryQuery()) &&
LoadSQLTextFile(SQLStatement.GetInsertPeriodTypeQuery()));
break;
}
return(result);
}
void InitDatabase()
{
LoadSQLTextFile(SQLStatement.GetCreateUserTableQuery());
LoadSQLTextFile(SQLStatement.GetCreateStaffTableQuery());
LoadSQLTextFile(SQLStatement.GetCreatePeriodTypeTableQuery());
LoadSQLTextFile(SQLStatement.GetCreatePeriodTableQuery());
LoadSQLTextFile(SQLStatement.GetCreateCategoryTableQuery());
LoadSQLTextFile(SQLStatement.GetCreatePaymentTableQuery());
LoadSQLTextFile(SQLStatement.GetInsertUserQuery());
LoadSQLTextFile(SQLStatement.GetInsertCategoryQuery());
LoadSQLTextFile(SQLStatement.GetInsertPeriodTypeQuery());
}
private void BuildStaffFromTable()
{
staffTable = dbManager.GetDataTable(SQLStatement.GetStaffTableQuery());
if (staffTable != null)
{
foreach (DataRow r in staffTable.Rows)
{
Staff staff = new Staff(r["Name"].ToString(), r["Phone"].ToString());
fromStaffs.Add(staff);
}
}
UpdateButtonsStatus(ButtonStatus.CanAdd);
StaffListFrom.DataContext = fromStaffs;
StaffListTo.DataContext = toStaffs;
}
// testing function
internal Boolean CheckUser(String username, String password)
{
Boolean valideUser = false;
DataTable table = GetDataTable(SQLStatement.GetUserTableQuery());
if (table != null)
{
string filter = string.Format("Login_Name='{0}'", username);
DataRow[] rows = table.Select(filter);
foreach (DataRow r in rows)
{
if (r["Password"].ToString().Equals(MD5PWD.MD5HashPassword(password)))
{
valideUser = true;
break;
}
}
}
return(valideUser);
}
private void CreateReportGroup()
{
int periodNum;
// remove all rows
if (PeriodGrid.RowDefinitions.Count > 0)
{
PeriodGrid.RowDefinitions.RemoveRange(0, PeriodGrid.RowDefinitions.Count);
PeriodGrid.Children.Clear();
}
periodTable = dbManager.GetDataTable(SQLStatement.GetPeriodTypeTableQuery());
if (periodTable == null || periodTable.Rows.Count == 0)
{
// create a message label to indicate there is no period type available
// and offer a button to create default period type table
RowDefinition periodRow1 = new RowDefinition();
RowDefinition periodRow2 = new RowDefinition();
PeriodGrid.RowDefinitions.Add(periodRow1);
PeriodGrid.RowDefinitions.Add(periodRow2);
// add a label to the first row
TextBlock txtMsg = new TextBlock();
txtMsg.Text = @"Unable to detect any period type in the database, please either add a new period type from the Period button, or use the button below to create default period types: Daily, Weekly, Fortnightly, Monthly, Quarterly, Annually.";
txtMsg.TextWrapping = TextWrapping.Wrap;
txtMsg.FontSize = 15;
txtMsg.FontWeight = FontWeights.Bold;
txtMsg.Margin = new Thickness(12);
btnPeriod.BorderBrush = Brushes.Red;
btnPeriod.BorderThickness = new Thickness(6);
Grid.SetRow(txtMsg, 0);
PeriodGrid.Children.Add(txtMsg);
// add a button to the second row
Button btnAddDefault = new Button();
btnAddDefault.Content = @"Restore Default Period Types";
btnAddDefault.FontSize = 15;
btnAddDefault.Foreground = Brushes.Red;
btnAddDefault.Margin = new Thickness(12);
btnAddDefault.VerticalAlignment = VerticalAlignment.Top;
btnAddDefault.Click += btnAddDefault_Click;
Grid.SetRow(btnAddDefault, 1);
PeriodGrid.Children.Add(btnAddDefault);
}
else
{
periodNum = periodTable.Rows.Count;
for (int i = 1; i <= periodNum; i++)
{
RowDefinition periodRow = new RowDefinition();
PeriodGrid.RowDefinitions.Add(periodRow);
}
// add buttons
for (int i = 0; i < periodNum; i++)
{
Button btn = new Button();
string btnContent = string.Format("{0} Report", periodTable.Rows[i]["Period_Type"].ToString());
btn.Content = btnContent;
btn.FontSize = 15;
// btn.Foreground = Brushes.Red;
btn.Margin = new Thickness(12);
// set tag
btn.Tag = periodTable.Rows[i]["Period_Type_ID"];
btn.Click += BTN_Period_Type_Clicked;
Grid.SetRow(btn, i);
PeriodGrid.Children.Add(btn);
}
}
}
