/// <summary>
/// Inserts the request to the database.
/// </summary>
private int UpdateTransaction()
{
string uid = Application.Current.Resources["uid"].ToString();
string[] dt = pmsutil.GetServerDateTime().Split(null);
cDate = Convert.ToDateTime(dt[0]);
cTime = DateTime.Parse(dt[1] + " " + dt[2]);
curDate = cDate.ToString("yyyy-MM-dd");
curTime = cTime.ToString("HH:mm:ss");
dbman = new DBConnectionManager();
using (conn = new MySqlConnection(dbman.GetConnStr()))
{
conn.Open();
if (conn.State == ConnectionState.Open)
{
MySqlCommand cmd = conn.CreateCommand();
cmd.CommandText =
"UPDATE transactions SET status = @status, completion_date = @completion_date, completion_time = @completion_time, completed_by = @completed_by WHERE transaction_id = @transaction_id;";
cmd.Parameters.AddWithValue("@transaction_id", tid);
cmd.Parameters.AddWithValue("@status", "Cancelled");
cmd.Parameters.AddWithValue("@completion_date", cDate);
cmd.Parameters.AddWithValue("@completion_time", cTime);
cmd.Parameters.AddWithValue("@completed_by", uid);
cmd.Prepare();
int stat_code = cmd.ExecuteNonQuery();
conn.Close();
return(stat_code);
}
else
{
return(0);
}
}
}
private string GetPriest(string pid)
{
string ret = "";
dbman = new DBConnectionManager();
if (dbman.DBConnect().State == ConnectionState.Open)
{
MySqlCommand cmd = dbman.DBConnect().CreateCommand();
cmd.CommandText = "SELECT priest_name FROM residing_priests WHERE priest_id = @pid LIMIT 1;";
cmd.Parameters.AddWithValue("@pid", pid);
cmd.Prepare();
MySqlDataReader db_reader = cmd.ExecuteReader();
while (db_reader.Read())
{
ret = db_reader.GetString("priest_name");
}
//close Connection
dbman.DBClose();
}
else
{
ret = "";
}
return(ret);
}
//private string GetPriestFilters()
//{
// string ret = "";
// dbman = new DBConnectionManager();
// if (dbman.DBConnect().State == ConnectionState.Open)
// {
// MySqlCommand cmd = dbman.DBConnect().CreateCommand();
// cmd.CommandText = "SELECT priest_name FROM residing_priests ORDER BY priest_name ASC";
// cmd.Prepare();
// MySqlDataReader db_reader = cmd.ExecuteReader();
// while (db_reader.Read())
// {
// PriestFilter.Items.Add(db_reader.GetString("priest_name"));
// }
// //close Connection
// dbman.DBClose();
// }
// else
// {
// ret = "";
// }
// return ret;
//}
internal void FetchAptType()
{
dbman = new DBConnectionManager();
using (conn = new MySqlConnection(dbman.GetConnStr()))
{
conn.Open();
if (conn.State == ConnectionState.Open)
{
MySqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "SELECT * FROM appointment_types;";
cmd.Prepare();
using (MySqlDataReader db_reader = cmd.ExecuteReader())
{
while (db_reader.Read())
{
Label lbl = new Label();
lbl.HorizontalAlignment = HorizontalAlignment.Stretch;
var bc = new System.Windows.Media.BrushConverter();
lbl.Foreground = (System.Windows.Media.Brush)bc.ConvertFrom("#FF3E3E3E");
lbl.MouseDown += DragTest;
lbl.Content = new EventTypeItemDraggable(db_reader.GetString("appointment_type"), null);
AppointmentTypeList.Items.Add(lbl);
}
}
}
}
}
private string GetPriestID(string pname)
{
string ret = "";
dbman = new DBConnectionManager();
using (conn = new MySqlConnection(dbman.GetConnStr()))
{
conn.Open();
if (conn.State == ConnectionState.Open)
{
MySqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "SELECT priest_id FROM residing_priests WHERE priest_name = @pname LIMIT 1;";
cmd.Parameters.AddWithValue("@pname", pname);
cmd.Prepare();
MySqlDataReader db_reader = cmd.ExecuteReader();
while (db_reader.Read())
{
ret = db_reader.GetString("priest_id");
}
}
else
{
ret = "";
}
}
return(ret);
}
private string GetStatus(string aid)
{
string ret = "";
dbman = new DBConnectionManager();
if (dbman.DBConnect().State == ConnectionState.Open)
{
MySqlCommand cmd = dbman.DBConnect().CreateCommand();
cmd.CommandText = "SELECT status FROM transactions WHERE target_id = @aid LIMIT 1;";
cmd.Parameters.AddWithValue("@aid", aid);
cmd.Prepare();
MySqlDataReader db_reader = cmd.ExecuteReader();
while (db_reader.Read())
{
ret = db_reader.GetString("status");
}
//close Connection
dbman.DBClose();
}
else
{
ret = "";
}
return(ret);
}
private String sqlStatementGetDebtorID = @"SELECT debtorID FROM debtors WHERE debtorName = @paramTypeName";//Modify the getID method of DataInsertionUtils class to use a more generic record ID retrieval method from the SQLCommandBuilder class
public int execute(QueryData paramContainer)
{
Guard.notNull(paramContainer, "parameter container");
int executionResult = -1;
//Retrieving the ID of the selected debtor
int debtorID = DataInsertionUtils.getID(sqlStatementGetDebtorID, paramContainer.DebtorName);
//Creating a new param container object that contains all the values from the param container received as argument plus the debtor ID(which will be necessary for inserting the new receivable record)
QueryData updatedParamContainer = new QueryData.Builder(paramContainer.UserID)
.addItemName(paramContainer.ItemName)
.addItemValue(paramContainer.ItemValue)
.addDebtorName(paramContainer.DebtorName)
.addDebtorID(debtorID)
.addStartDate(paramContainer.StartDate)
.addEndDate(paramContainer.EndDate)
.addIncomeSource(paramContainer.IncomeSource)
.addPaidAmount(paramContainer.PaidAmount)
.build();
MySqlCommand insertReceivableCommand = SQLCommandBuilder.getReceivableInsertionCommand(sqlStatementInsertReceivable, updatedParamContainer);
executionResult = DBConnectionManager.insertData(insertReceivableCommand);
return(executionResult);
}
internal string GetRecordName(string rid)
{
string ret = "";
dbman2 = new DBConnectionManager();
if (dbman2.DBConnect().State == ConnectionState.Open)
{
MySqlCommand cmd2 = dbman2.DBConnect().CreateCommand();
cmd2.CommandText = "SELECT * FROM records WHERE record_id = @record_id LIMIT 1;";
cmd2.Parameters.AddWithValue("@record_id", rid);
cmd2.Prepare();
MySqlDataReader db_reader2 = cmd2.ExecuteReader();
while (db_reader2.Read())
{
ret = db_reader2.GetString("recordholder_fullname");
}
//close Connection
dbman2.DBClose();
}
else
{
ret = "";
}
return(ret);
}
private bool IsAvailable(string adate, string atime, string apriest)
{
bool ret = false;
dbman = new DBConnectionManager();
if (dbman.DBConnect().State == ConnectionState.Open)
{
MySqlCommand cmd = dbman.DBConnect().CreateCommand();
cmd.CommandText = "SELECT COUNT(*) FROM appointments WHERE assigned_priest = @apriest AND appointment_date = @adate AND appointment_time = @atime;";
cmd.Parameters.AddWithValue("apriest", apriest);
cmd.Parameters.AddWithValue("adate", adate);
cmd.Parameters.AddWithValue("atime", atime);
cmd.Prepare();
MySqlDataReader db_reader = cmd.ExecuteReader();
while (db_reader.Read())
{
if (db_reader.GetInt32("COUNT(*)") > 0)
{
ret = false;
}
else
{
ret = true;
}
}
//close Connection
dbman.DBClose();
}
else
{
}
return(ret);
}
//Method that gets the total value of the selected element for the specified month
private int getTotalValueForSelectedElement(BudgetItemType itemType, String sqlStatement, QueryData paramContainer)
{
int totalValue = 0;
//Getting the correct SQL comand for the selected element
MySqlCommand command = getCommand(itemType, sqlStatement, paramContainer);
if (command == null)
{
return(-1);
}
//Getting the data based on the previously created command
DataTable resultDataTable = DBConnectionManager.getData(command);
//Checking if the DataTable contains data and if so converting the value to int
if (resultDataTable != null && resultDataTable.Rows.Count == 1)
{
Object result = resultDataTable.Rows[0].ItemArray[0];
totalValue = result != DBNull.Value ? Convert.ToInt32(result) : 0;
return(totalValue);
}
return(-1);
}
public frmConnectionManager(DBConnectionManager connManager)
{
//
// The InitializeComponent() call is required for Windows Forms designer support.
//
InitializeComponent();
connMan = connManager;
connMan.loadConnections();
cboDatabaseType.Items.AddRange(connMan.DBTypes.ToArray());
if (connMan.ConnectionList != null)
{
if (connMan.ConnectionList.Count > 0)
{
updateConnectionList();
getFirstListViewItem();
setDBControls();
CboDatabaseTypeTextChanged(this, null);
ChkIntegratedSecurityCheckedChanged(this, null);
}
else
{
BtnNewClick(this, null);
}
}
}
private string GetPriestFilters()
{
AppFilter.Items.Add("All");
string ret = "";
dbman = new DBConnectionManager();
if (dbman.DBConnect().State == ConnectionState.Open)
{
MySqlCommand cmd = dbman.DBConnect().CreateCommand();
cmd.CommandText = "SELECT priest_name FROM residing_priests WHERE priest_name != 'NA' ORDER BY priest_name ASC";
cmd.Prepare();
MySqlDataReader db_reader = cmd.ExecuteReader();
while (db_reader.Read())
{
AppFilter.Items.Add(db_reader.GetString("priest_name"));
}
//close Connection
dbman.DBClose();
}
else
{
ret = "";
}
return(ret);
}
internal bool CheckDupli()
{
dbman = new DBConnectionManager();
pmsutil = new PMSUtil();
using (conn = new MySqlConnection(dbman.GetConnStr()))
{
conn.Open();
if (conn.State == ConnectionState.Open)
{
string selTime = HourPicker.Text + ":" + MinutePicker.Text + " " + ModePicker.Text;
MySqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "SELECT COUNT(*) FROM timeslots WHERE timeslot = @tslot";
cmd.Prepare();
cmd.Parameters.AddWithValue("@tslot", DateTime.Parse(selTime).ToString("HH:mm:ss"));
using (MySqlDataReader db_reader = cmd.ExecuteReader())
{
while (db_reader.Read())
{
if (db_reader.GetInt32("COUNT(*)") > 0)
{
return(true);
}
}
}
}
}
return(false);
}
internal bool IsArchived(int bookNum)
{
dbman = new DBConnectionManager();
using (conn = new MySqlConnection(dbman.GetConnStr()))
{
conn.Open();
if (conn.State == ConnectionState.Open)
{
MySqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "SELECT * FROM registers WHERE book_number = @bookNum;";
cmd.Parameters.AddWithValue("@bookNum", bookNum);
MySqlDataReader db_reader = cmd.ExecuteReader();
while (db_reader.Read())
{
if (db_reader.GetString("status") == "Archived")
{
return(true);
}
else
{
return(false);
}
}
}
}
return(false);
}
private int CountAssignedServicesUnfinished(string pid)
{
int ret = 0;
dbman = new DBConnectionManager();
using (conn = new MySqlConnection(dbman.GetConnStr()))
{
conn.Open();
if (conn.State == ConnectionState.Open)
{
MySqlCommand cmd = dbman.DBConnect().CreateCommand();
cmd.CommandText = "SELECT COUNT(*) FROM appointments WHERE assigned_priest = @pid AND status = 1;";
cmd.Parameters.AddWithValue("@pid", pid);
cmd.Prepare();
MySqlDataReader db_reader = cmd.ExecuteReader();
while (db_reader.Read())
{
ret = db_reader.GetInt32("COUNT(*)");
}
//close Connection
dbman.DBClose();
}
else
{
ret += 0;
}
}
return(ret);
}
private bool CheckRequirements()
{
bool ret = false;
dbman = new DBConnectionManager();
if (dbman.DBConnect().State == ConnectionState.Open)
{
MySqlCommand cmd = dbman.DBConnect().CreateCommand();
cmd.CommandText = "SELECT COUNT(*) FROM records, registers WHERE registers.book_type = 'Burial' AND registers.book_number = records.book_number AND records.recordholder_fullname = @fname;";
cmd.Parameters.AddWithValue("@fname", FullName.Text);
cmd.Prepare();
MySqlDataReader db_reader = cmd.ExecuteReader();
while (db_reader.Read())
{
if (db_reader.GetInt32("COUNT(*)") == 0)
{
ret = true;
}
}
//close Connection
dbman.DBClose();
}
else
{
ret = false;
}
return(ret);
}
private void FetchBookEntryNum()
{
int ret = 0;
PageNum.Value = vre.Page.Value;
dbman = new DBConnectionManager();
if (dbman.DBConnect().State == ConnectionState.Open)
{
MySqlCommand cmd = dbman.DBConnect().CreateCommand();
cmd.CommandText = "SELECT entry_number FROM records WHERE book_number = @bnum AND page_number = @pnum;";
cmd.Parameters.AddWithValue("@bnum", bookNum);
cmd.Parameters.AddWithValue("@pnum", vre.Page.Value);
cmd.Prepare();
MySqlDataReader db_reader = cmd.ExecuteReader();
while (db_reader.Read())
{
ret = Convert.ToInt32(db_reader.GetString("entry_number"));
}
//close Connection
dbman.DBClose();
}
else
{
ret = 0;
}
EntryNum.Value = ret + 1;
}
private void ShowSuggestions6(object sender, System.Windows.Controls.TextChangedEventArgs e)
{
dbman = new DBConnectionManager();
PlaceOfIntermentSuggestionArea.Items.Clear();
if (dbman.DBConnect().State == ConnectionState.Open)
{
MySqlCommand cmd = dbman.DBConnect().CreateCommand();
cmd.CommandText = "SELECT DISTINCT place_of_interment FROM burial_records WHERE " +
"place_of_interment LIKE @query;";
cmd.Parameters.AddWithValue("@query", "%" + PlaceOfInterment.Text + "%");
cmd.Prepare();
MySqlDataReader db_reader = cmd.ExecuteReader();
while (db_reader.Read())
{
PlaceOfIntermentSuggestionArea.Items.Add(db_reader.GetString("place_of_interment"));
}
//close Connection
dbman.DBClose();
Suggestions6.Visibility = System.Windows.Visibility.Visible;
}
else
{
}
}
/// <summary>
/// Inserts the request to the database.
/// </summary>
private int InsertRegister()
{
dbman = new DBConnectionManager();
//TODO
try
{
MySqlCommand cmd = dbman.DBConnect().CreateCommand();
cmd.CommandText =
"INSERT INTO registers(book_number, register_number, book, book_type, creation_date, addition_date, addition_time)" +
"VALUES(@book_number, @register_number, @book, @book_type, @creation_date, @additionDate, @addition_time)";
cmd.Prepare();
cmd.Parameters.AddWithValue("@book_number", bookNum);
cmd.Parameters.AddWithValue("@register_number", registerNum);
cmd.Parameters.AddWithValue("@book", book);
cmd.Parameters.AddWithValue("@book_type", regType);
cmd.Parameters.AddWithValue("@creation_date", creationDate);
cmd.Parameters.AddWithValue("@additionDate", curDate);
cmd.Parameters.AddWithValue("@addition_time", curTime);
int stat_code = cmd.ExecuteNonQuery();
return(stat_code);
}
catch (MySqlException ex)
{
Console.WriteLine("Error: {0}", ex.ToString());
return(0);
}
}
internal int CheckIfArchived(int bookNum)
{
int returnVal = 0;
dbman = new DBConnectionManager();
if (dbman.DBConnect().State == ConnectionState.Open)
{
MySqlCommand cmd = dbman.DBConnect().CreateCommand();
cmd.CommandText = "SELECT COUNT(book_number) FROM archives WHERE book_number = @book_number;";
cmd.Parameters.AddWithValue("@book_number", bookNum);
MySqlDataReader db_reader = cmd.ExecuteReader();
while (db_reader.Read())
{
if (db_reader.GetInt32("COUNT(book_number)") > 0)
{
//Archived
returnVal = 1;
}
else
{
//Not Archived
returnVal = 2;
}
}
//close Connection
dbman.DBClose();
}
return(returnVal);
}
internal bool CheckDupli()
{
dbman = new DBConnectionManager();
pmsutil = new PMSUtil();
using (conn = new MySqlConnection(dbman.GetConnStr()))
{
conn.Open();
if (conn.State == ConnectionState.Open)
{
MySqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "SELECT COUNT(*) FROM residing_priests WHERE priest_name = @pname";
cmd.Prepare();
cmd.Parameters.AddWithValue("@pname", PriestName.Text);
using (MySqlDataReader db_reader = cmd.ExecuteReader())
{
while (db_reader.Read())
{
if (db_reader.GetInt32("COUNT(*)") > 0)
{
return(true);
}
}
}
}
}
return(false);
}
private int CheckTrans(string tid)
{
int ret = 2;
dbman = new DBConnectionManager();
pmsutil = new PMSUtil();
using (conn = new MySqlConnection(dbman.GetConnStr()))
{
conn.Open();
if (conn.State == ConnectionState.Open)
{
MySqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "SELECT * FROM transactions WHERE transaction_id = @transaction_id LIMIT 1;";
cmd.Parameters.AddWithValue("@transaction_id", tid);
cmd.Prepare();
MySqlDataReader db_reader = cmd.ExecuteReader();
while (db_reader.Read())
{
if (db_reader.GetString("status") == "Paid")
{
ret = 0;
}
else if (db_reader.GetString("status") == "Cancelled")
{
ret = 1;
}
else
{
}
}
}
}
return(ret);
}
private void GetData(SEActivities activities, Guid threadId, string kind, DateTime offset)
{
SPWeb web = SPContext.Current.Web;
int userId = web.CurrentUser.ID;
_regionalSettings = SPContext.Current.RegionalSettings;
using (var connectionManager = new DBConnectionManager(web))
{
DBConnectionManager manager = connectionManager;
List <DataRow> threadRows = GetThreads(manager, userId, web, 0, 0, threadId).AsEnumerable().ToList();
List <SEActivities.Thread> threads =
threadRows.Select(tr => BuildThread(tr, manager, userId, 0, 0, activities, offset, kind))
.ToList();
foreach (SEActivities.Thread thread in threads)
{
activities.threads.Add(thread);
}
}
SortThreadActivities(activities);
}
private int CountEvents(DateTime d)
{
int ret = 0;
dbman = new DBConnectionManager();
using (conn = new MySqlConnection(dbman.GetConnStr()))
{
conn.Open();
if (conn.State == ConnectionState.Open)
{
using (MySqlConnection conn2 = new MySqlConnection(dbman.GetConnStr()))
{
conn2.Open();
MySqlCommand cmd = conn2.CreateCommand();
cmd.CommandText = "SELECT COUNT(appointment_id) FROM appointments WHERE appointment_date = @sdate;";
cmd.Parameters.AddWithValue("@sdate", d.ToString("yyyy-MM-dd"));
cmd.Prepare();
using (MySqlDataReader db_reader = cmd.ExecuteReader())
{
while (db_reader.Read())
{
ret = db_reader.GetInt32("COUNT(appointment_id)");
}
}
}
}
}
return(ret);
}
private void GetData(int page, int limit, int activityLimit, int commentLimit, SEActivities activities)
{
SPWeb web = SPContext.Current.Web;
int userId = web.CurrentUser.ID;
_regionalSettings = SPContext.Current.RegionalSettings;
using (var connectionManager = new DBConnectionManager(web))
{
DBConnectionManager manager = connectionManager;
List <DataRow> threadRows = GetThreads(manager, userId, web, page, limit, null).AsEnumerable().ToList();
List <SEActivities.Thread> threads =
threadRows.Select(
tr => BuildThread(tr, manager, userId, activityLimit, commentLimit, activities, null))
.ToList();
foreach (SEActivities.Thread thread in threads)
{
if (thread.activities.Count != 0 || thread.comments.Count != 0)
{
activities.threads.Add(thread);
}
}
}
activities.threads = activities.threads.Distinct().ToList();
activities.webs = activities.webs.Distinct().ToList();
activities.lists = activities.lists.Distinct().ToList();
activities.users = activities.users.Distinct().ToList();
SortThreadActivities(activities);
}
private bool IsCustom(string tid)
{
bool ret = false;
dbman = new DBConnectionManager();
if (dbman.DBConnect().State == ConnectionState.Open)
{
MySqlCommand cmd = dbman.DBConnect().CreateCommand();
cmd.CommandText = "SELECT custom FROM appointment_types WHERE type_id = @tid;";
cmd.Parameters.AddWithValue("@tid", tid);
cmd.Prepare();
MySqlDataReader db_reader = cmd.ExecuteReader();
while (db_reader.Read())
{
if (db_reader.GetInt32("custom") == 1)
{
ret = false;
}
else
{
ret = true;
}
}
//close Connection
dbman.DBClose();
}
else
{
ret = false;
}
return(ret);
}
private DataTable GetThreads(DBConnectionManager connectionManager, int userId, SPWeb web, int page, int limit,
Guid?threadId)
{
var dataTable = new DataTable();
using (var sqlCommand = new SqlCommand("SS_GetLatestThreads", connectionManager.SqlConnection))
{
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.AddWithValue("@UserId", userId);
sqlCommand.Parameters.AddWithValue("@WebUrl", web.ServerRelativeUrl);
if (page > 0)
{
sqlCommand.Parameters.AddWithValue("@Page", page);
}
if (limit > 0)
{
sqlCommand.Parameters.AddWithValue("@Limit", limit);
}
if (threadId.HasValue)
{
sqlCommand.Parameters.AddWithValue("@ThreadId", threadId.Value);
}
SqlDataReader reader = sqlCommand.ExecuteReader();
dataTable.Load(reader);
}
return(dataTable);
}
private string GetAType(string tid)
{
string ret = "";
dbman = new DBConnectionManager();
if (dbman.DBConnect().State == ConnectionState.Open)
{
MySqlCommand cmd = dbman.DBConnect().CreateCommand();
cmd.CommandText = "SELECT appointment_type FROM appointment_types WHERE type_id = @tid;";
cmd.Parameters.AddWithValue("@tid", tid);
cmd.Prepare();
MySqlDataReader db_reader = cmd.ExecuteReader();
while (db_reader.Read())
{
ret = db_reader.GetString("appointment_type");
}
//close Connection
dbman.DBClose();
}
else
{
ret = "";
}
return(ret);
}
/// <summary>
/// Fetches default confirmation stipend value.
/// </summary>
private int FetchBurialStipend()
{
int ret = 0;
dbman = new DBConnectionManager();
if (dbman.DBConnect().State == ConnectionState.Open)
{
MySqlCommand cmd = dbman.DBConnect().CreateCommand();
cmd.CommandText = "SELECT key_value FROM settings WHERE key_name = 'Matrimonial Stipend';";
cmd.Prepare();
MySqlDataReader db_reader = cmd.ExecuteReader();
while (db_reader.Read())
{
ret = Convert.ToInt32(db_reader.GetString("key_value"));
}
//close Connection
dbman.DBClose();
}
else
{
ret = 0;
}
return(ret);
}
private void ConfirmPayment_Click(object sender, System.Windows.RoutedEventArgs e)
{
dbman = new DBConnectionManager();
pmsutil = new PMSUtil();
using (conn = new MySqlConnection(dbman.GetConnStr()))
{
conn.Open();
if (conn.State == ConnectionState.Open)
{
MySqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "DELETE FROM appointment_types WHERE type_id = @eid LIMIT 1;";
cmd.Parameters.AddWithValue("@eid", eid);
cmd.Prepare();
int stat_code = cmd.ExecuteNonQuery();
conn.Close();
if (stat_code > 0)
{
etype.SyncEventTypes();
MsgSuccess();
this.Close();
}
else
{
InfoArea.Foreground = new SolidColorBrush(Colors.Red);
InfoArea.Content = "Unable to Delete Selected Event Type!";
}
}
}
}
public LoggerForm()
{
InitializeComponent();
string path = "";
OpenFileDialog file = new OpenFileDialog();
if (file.ShowDialog() == DialogResult.OK)
{
path = file.FileName;
}
else
{
Application.Exit();
}
DBConnectionManager cm = new DBConnectionManager(path, "OleDb");
logger = new Logger(cm.GetAdapter("SELECT * FROM Messages"), cm.GetAdapter("SELECT * FROM Users"));
LoginForm frm = new LoginForm();
string res = "";
do
{
frm.ShowDialog();
res = PonyboxClient.LoadUser(frm.GetUser(), frm.GetPass());
} while (res == "");
initCB(res);
}
