private void btnTableInfo_Click(object sender, EventArgs e)
{
try
{
var config = DropdownBoxHelper.GetGenericFromComboBox <DatabaseConfig>(comboBoxDB);
IDBAccess dbAccess = DBAccessManager.GetDBAccessInstance(config.DBID);
var tableInfoList = dbAccess.Database.GetTableInfoList(ckGetFieldInfo.Checked);
StringBuilder sb = new StringBuilder();
sb.AppendLine("----------------------------------------------------------------------------");
sb.AppendLine($"[{config.ConName}] [{tableInfoList.Count}]");
sb.AppendLine("----------------------------------------------------------------------------");
foreach (var tableInfo in tableInfoList)
{
sb.AppendLine($"[TableName:{tableInfo.Name}]");
sb.AppendLine($"[Comments:{tableInfo.Comments}]");
sb.AppendLine($"[PriKeyField:{string.Join(";", tableInfo.PriKeyFieldInfos.Select(t => { return t.FieldName; })) }]");
sb.AppendLine($"[Field:{string.Join(";", tableInfo.DbFieldInfos.Select(t => { return t.FieldName; })) }]");
string tmp = tableInfo.Indexs == null ? string.Empty : string.Join("; ", tableInfo.Indexs.Select(t => { return($"{t.IndexName}:{t.FieldName}"); }));
sb.AppendLine($"[Index:{tmp }]");
sb.AppendLine("----------------------------------------------------------------------------");
}
Loger.Info(sb.ToString());
}
catch (Exception ex)
{
Loger.Error(ex);
}
}
public DataImportWizardP2(string file)
{
_excelFile = file;
_dbManager = DBAccessManager.GetInstance();
InitializeComponent();
_dlgLbl = new DataDelegate(Update);
_dlgPrg = new ProgressDelegate(UpdateProgress);
new Thread(() => LoadData()).Start();
}
public MainForm()
{
InitializeComponent();
_aspectLocs = new Dictionary <string, List <float> >();
_aspectDims = new Dictionary <string, List <float> >();
_dbManager = DBAccessManager.GetInstance();
AddMenus();
isDirty = false;
//buttonUpdate.Text = "U" + "\n" + "P" + "\n" + "D" + "\n" + "A" + "\n" + "T" + "\n" + "E";
}
private void OnClearDbClick(object sender, RoutedEventArgs e)
{
var resut = MessageBox.Show("Ви впевнені, що хочете видалити дані?", "Розклад", MessageBoxButton.YesNo);
if (resut == MessageBoxResult.Yes)
{
DBAccessManager.ClearDataBase();
ShowPopup("Дані видалено");
FillDropDownsInfo();
SetDataView("", new DataTable());
}
}
private void btnPagingQuery_Click(object sender, EventArgs e)
{
try
{
var config = DropdownBoxHelper.GetGenericFromComboBox <DatabaseConfig>(comboBoxDB);
this._dbAccess = DBAccessManager.GetDBAccessInstance(config.DBID);
this.QueryPageInfo(this._dbAccess);
}
catch (Exception ex)
{
Loger.Error(ex);
}
}
private void btnDataBaseName_Click(object sender, EventArgs e)
{
try
{
var config = DropdownBoxHelper.GetGenericFromComboBox <DatabaseConfig>(comboBoxDB);
IDBAccess dbAccess = DBAccessManager.GetDBAccessInstance(config.DBID);
string databaseName = dbAccess.Database.GetDatabaseName();
Loger.Info($"[{config.ConName}] [DatabaseName:{databaseName}]");
}
catch (Exception ex)
{
Loger.Error(ex);
}
}
protected void PortalAcct_Save_Click(object sender, EventArgs e)
{
try
{
if (Page.IsValid == true)
{
String AddedBy = Page.User.IsInRole("HR Administrator").ToString();
Int32 AccountStatus = 1;
if (Tab1_RadioButton1.Checked == true)
{
AccountStatus = 1;
}
else
{
AccountStatus = 0;
}
string result = DBAccessManager.AccountSignUp(Tab1_EmployeeID.Text.ToString(), Tab1_UserName.Text.ToString().Trim(), EncodePasswordToBase64(Tab1_password.Text.ToString().Trim()), Int32.Parse(Tab1_RoleTypeList.SelectedValue), 1, 1, AccountStatus, AddedBy);
if (result == "")
{
ResetFields();
String Emp_FullName = "";
String UserName = Tab1_UserName.Text.ToString();
String Password = DecodeFrom64(Tab1_password.Text.ToString());
if (CheckEmail(UserName)) // Notify via Email if Email was used as a user Name
{
NotifyEmployee_PortaLoginViaEmail(Emp_FullName, UserName, Password);
}
this.Hmessage.Visible = true;
this.Hmessage.Text = "Account has been created successfully";
this.Hmessage.CssClass = "errorMessage";
}
else
{
this.Hmessage.Visible = true;
this.Hmessage.Text = result;
this.Hmessage.CssClass = "errorMessage";
}
}
}
catch (Exception exception)
{
this.Hmessage.Visible = true;
this.Hmessage.Text = ErrorLogging.LogError(exception, "Unknown Exception Occured.Please contact Support.");
this.Hmessage.CssClass = "errorMessage";
}
ViewState["myDataSet"] = null;
LoadPortalUserAccounts();
}
private void btnQuery_Click(object sender, EventArgs e)
{
try
{
var config = DropdownBoxHelper.GetGenericFromComboBox <DatabaseConfig>(comboBoxDB);
IDBAccess dbAccess = DBAccessManager.GetDBAccessInstance(config.DBID);
string sql = @"SELECT ID,SensNo,SensLocation,SensType,AddTime FROM Sensors";
DataTable dt = dbAccess.QueryDataToDataTable(sql);
dgv.ShowData(dt);
}
catch (Exception ex)
{
Loger.Error(ex);
}
}
private void btnLoad_Click(object sender, EventArgs e)
{
try
{
var dbConfig = DropdownBoxHelper.GetGenericFromComboBox <DatabaseConfig>(comboBoxDB);
var para = new PartAsynWaitPara <DatabaseConfig, object>();
para.Caption = "查询数据库结构";
para.IsShowCancel = false;
para.Para = dbConfig;
para.Function = (p) =>
{
p.AsynWait.Hint = $"正在查询数据库[{dbConfig.ConName}]结构,请稍候...";
IDBAccess dbAccess = DBAccessManager.GetDBAccessInstance(p.Para.DBID);
this._tableList = dbAccess.Database.GetTableInfoList(true).OrderBy(t => { return(t.Name); }).Select(t => { return(new DBTableInfoEx(t)); }).ToList();
if (p.AsynWait.InvokeRequired)
{
p.AsynWait.Invoke(new Action(() =>
{
this._tableBindingList.Clear();
this._tableBindingList.AddRange(this._tableList);
}));
}
else
{
this._tableBindingList.Clear();
this._tableBindingList.AddRange(this._tableList);
}
return(null);
};
para.Completed = (ret) =>
{
if (ret.Status == PartAsynExcuteStatus.Exception)
{
Loger.Error(ret.Exception);
}
};
PartAsynWaitHelper.Wait(para, this);
}
catch (Exception ex)
{
Loger.Error(ex);
MessageBox.Show(ex.Message);
}
}
protected void PortalEdit_Save_Click(object sender, EventArgs e)
{
try
{
if (Page.IsValid == true)
{
String AddedBy = Page.User.Identity.Name.ToString();// Page.User.IsInRole("HR Administrator").ToString();
Int32 AccountStatus = 1;
if (Tab2_RadioButton1.Checked == true)
{
AccountStatus = 1;
}
else
{
AccountStatus = 0;
}
String Password = "******"; // do not update password while editing-handled in SP.
string result = DBAccessManager.AccountSignUp(Tab2_EmployeeID.Text.ToString(), Tab2_UserName.Text.ToString().Trim(), Password, Int32.Parse(Tab2_RoleTypeList.SelectedValue), 1, 1, AccountStatus, AddedBy);
if (result == "")
{
ResetFields();
this.EditAccount.Visible = false;
this.AddAccount.Visible = true;
}
else
{
this.Editmessage.Visible = true;
this.Editmessage.Text = result;
this.Editmessage.CssClass = "errorMessage";
}
}
}
catch (Exception exception)
{
this.Hmessage.Visible = true;
this.Hmessage.Text = ErrorLogging.LogError(exception, "Unknown Exception Occured.Please contact Support.");
this.Hmessage.CssClass = "errorMessage";
}
ViewState["myDataSet"] = null;
LoadPortalUserAccounts();
}
private void SignMeUp_Click(object sender, System.EventArgs e)
{
try
{
if (Page.IsValid == true)
{
String AddedBy = "Employee"; // Used to determine the RoleTypeID
Int32 RoleTypeID = 0;
Int32 DivisionID = 0;
Int32 LocationID = 0;
Int32 AccountStatus = 1; // Enabled by Default
string result = DBAccessManager.AccountSignUp(this.Signup_EmployeeID.Text.ToString().Trim(), Signup_UserName.Text.ToString().Trim(), SchoolNetBase.EncodePasswordToBase64(Signup_Password.Text.ToString().Trim()), RoleTypeID, DivisionID, LocationID, AccountStatus, AddedBy);
if (result == "")
{
this.errorMessage.Visible = true;
this.Signup_EmployeeID.Text = "";
this.Signup_UserName.Text = "";
this.Signup_Password.Text = "";
this.errorMessage.Text = "Thank you for sign up.Your account has been created. Please click the login link below to sign in.";
this.errorMessage.CssClass = "errorMessage";
}
else
{
this.errorMessage.Visible = true;
this.EmailAddress.Text = "";
this.Login_Password.Text = "";
this.errorMessage.Text = result;
this.errorMessage.CssClass = "errorMessage";
}
}
}
catch (Exception exception)
{
this.errorMessage.Visible = true;
this.EmailAddress.Text = "";
this.Login_Password.Text = "";
this.errorMessage.Text = ErrorLogging.LogError(exception, "Unknown Exception Occured.Please contact Support.");
this.errorMessage.CssClass = "errorMessage";
}
}
private void btnExistTable_Click(object sender, EventArgs e)
{
try
{
string tblName = txtTblName.Text;
if (checkBoxIgnoreCase.Checked)
{
tblName = tblName.ToUpper();
}
var config = DropdownBoxHelper.GetGenericFromComboBox <DatabaseConfig>(comboBoxDB);
IDBAccess dbAccess = DBAccessManager.GetDBAccessInstance(config.DBID);
var isExist = dbAccess.Database.ExistTable(tblName);
Loger.Info($"[{config.ConName}] [{txtTblName.Text}] [{isExist}]");
}
catch (Exception ex)
{
Loger.Error(ex);
}
}
private void MemberLogin(object sender, System.EventArgs e)
{
try
{
if (Page.IsValid == true)
{
DataSet _DataList = null;
String userName = string.Empty;
String roleName = string.Empty;
String userEmail = string.Empty;
String MemberName = string.Empty;
String PasswordExpiry = string.Empty;
_DataList = DBAccessManager.ValidateLogin(this.EmailAddress.Text.ToString().Trim(), SchoolNetBase.EncodePasswordToBase64(this.Login_Password.Text.ToString().Trim()));
if (_DataList.Tables.Count > 0)
{
if (_DataList.Tables[0].Rows.Count > 0) // Member Login Information
{
DataRow _DataRow = _DataList.Tables[0].Rows[0];
userName = _DataRow["EmpId"].ToString();
roleName = _DataRow["RoleName"].ToString();
userEmail = _DataRow["Work_Email"].ToString();
MemberName = _DataRow["MemberName"].ToString();
PasswordExpiry = _DataRow["PasswordExpiry"].ToString();
}
// If the password has expired, redirect to change password screen
if (PasswordExpiry != "")
{
Tab1_keyField.Text = EmailAddress.Text.ToString().Trim();
Login_Pane.Visible = false;
ChangePassword.Visible = true;
errorMessage.Text = "";
}
else
{
DateTime expiryDate = DateTime.Now.AddMinutes(60);// Default
bool isPersistent = false;
if (login_RememberMe.Checked)
{
//clear any other tickets that are already in the response
Response.Cookies.Clear();
//set the new expiry date - to thirty days from now
expiryDate = DateTime.Now.AddDays(30);
//create a new forms auth ticket
isPersistent = true;
}
FormsAuthenticationTicket ticket = new FormsAuthenticationTicket(1, userName, DateTime.Now, expiryDate, isPersistent, roleName);
//encrypt the ticket
String encryptedTicket = FormsAuthentication.Encrypt(ticket);
//create a new authentication cookie - and set its expiration date
HttpCookie authenticationCookie = new HttpCookie(FormsAuthentication.FormsCookieName, encryptedTicket);
authenticationCookie.Expires = ticket.Expiration;
//add the cookie to the response.
Response.Cookies.Add(authenticationCookie);
Session["MemberName"] = MemberName;
Session["MemberEmail"] = userEmail;
String redirectUrl = "";
if (roleName == "HR Administrator")
{
redirectUrl = FormsAuthentication.GetRedirectUrl(userName, false);
}
if (roleName == "Payroll Administrator")
{
redirectUrl = Page.ResolveUrl("~/Payroll/PayrollDashboard.aspx");
}
if (roleName == "Supervisor" || roleName == "Employee")
{
redirectUrl = Page.ResolveUrl("~/Common/EmployeeProfile.aspx");
}
if (roleName == "Data Entry Clerk")
{
redirectUrl = Page.ResolveUrl("~/Clerical/EnterDailyFNTrans.aspx");
}
if (redirectUrl.Equals(String.Empty))
{
redirectUrl = Page.ResolveUrl("~/Common/EmployeeProfile.aspx");
}
Page.Response.Redirect(redirectUrl);
}
}
else
{
this.errorMessage.Visible = true;
this.EmailAddress.Text = "";
this.Login_Password.Text = "";
this.errorMessage.Text = "Invalid Email Id or Password. Please check your credentials.";
this.errorMessage.CssClass = "errorMessage";
}
}
}
catch (Exception exception)
{
this.errorMessage.Visible = true;
this.EmailAddress.Text = "";
this.Login_Password.Text = "";
this.errorMessage.Text = ErrorLogging.LogError(exception, "Unknown Exception Occured.Please contact Support.");
this.errorMessage.CssClass = "errorMessage";
}
}
private void btnDBQueryExpression_Click(object sender, EventArgs e)
{
try
{
// select treea.ID,treea.Name,treea.Age,treeb.City,treeb.Level From treea INNER JOIN treeb on treea.ID = treeb.AID
//where treea.Age > 23 AND treeb.Level < 5
//select A.ID,A.Name,A.Age,B.City,B.Level From treea A INNER JOIN treeb B on A.ID = B.AID
//where A.Age > 23 AND B.Level < 5
//string tblA = "TreeA";
//string tblB = "TreeB";
string tblA = "treea";
string tblB = "treeb";
var queryExpression = new DBQueryExpression();
queryExpression.QueryFields.Add(new DBQueryField(tblA, "ID"));
queryExpression.QueryFields.Add(new DBQueryField(tblA, "Name"));
queryExpression.QueryFields.Add(new DBQueryField(tblA, "Age"));
queryExpression.QueryFields.Add(new DBQueryField(tblB, "City"));
queryExpression.QueryFields.Add(new DBQueryField(tblB, "Level"));
queryExpression.ConditionExpressionNodes.LogicOperaters = LogicOperaters.AND;
queryExpression.ConditionExpressionNodes.Add(new ExpressionNode(CompareOperater.GreaterThan, tblA, "Age", 23));
queryExpression.ConditionExpressionNodes.Add(new ExpressionNode(CompareOperater.LessThan, tblB, "Level", 5));
var tableAliaNameDic = new Dictionary <string, string>();
tableAliaNameDic.Add("treea", "A");
tableAliaNameDic.Add("treeb", "B");
string fieldSql = queryExpression.QueryFields.ToQueryFieldSql(tableAliaNameDic);
Loger.Info(fieldSql);
var config = DropdownBoxHelper.GetGenericFromComboBox <DatabaseConfig>(comboBoxDB);
var dbAccess = DBAccessManager.GetDBAccessInstance(config.DBID);
List <DBTableInfo> dbTableInfos = dbAccess.Database.GetTableInfoList(true);
var dbTableInfoDic = dbTableInfos.ToDictionary(k => { return(k.Name); }, v => { return(v.DbFieldInfos.ToDictionary(t => { return t.FieldName; })); });
var filedValueConverterCollection = new DBFiledValueConverterCollection();
Dictionary <string, object> parameterNameValueDic;
int parameterIndex = 1;
string where = queryExpression.ConditionExpressionNodes.ToWhere(dbTableInfoDic, tableAliaNameDic,
filedValueConverterCollection, dbAccess.ParaSign, ref parameterIndex, out parameterNameValueDic);
Loger.Info(where);
ISqlFieldValueFormator fieldValueFormator = DBAccessManager.GetFieldValueFormator(config);
string whereNoPara = queryExpression.ConditionExpressionNodes.ToWhereNoParameter(dbTableInfoDic, tableAliaNameDic, filedValueConverterCollection, fieldValueFormator);
Loger.Info(whereNoPara);
//-------------------------------------------------------------------------------------------------------------------------------------
//A.Age > 23 AND (B.Level < 4 OR B.Level > 6)
var expressionNodeCollection = new ExpressionNodeCollection();
expressionNodeCollection.LogicOperaters = LogicOperaters.AND;
expressionNodeCollection.Add(new ExpressionNode(CompareOperater.GreaterThan, tblA, "Age", 23));
var orCondition = new ExpressionNode();
orCondition.Children.LogicOperaters = LogicOperaters.OR;
orCondition.Children.Add(new ExpressionNode(CompareOperater.LessThan, tblB, "Level", 4));
orCondition.Children.Add(new ExpressionNode(CompareOperater.GreaterThan, tblB, "Level", 6));
expressionNodeCollection.Add(orCondition);
parameterNameValueDic = null;
parameterIndex = 1;
string where2 = expressionNodeCollection.ToWhere(dbTableInfoDic, tableAliaNameDic, filedValueConverterCollection, dbAccess.ParaSign, ref parameterIndex, out parameterNameValueDic);
Loger.Info(where2);
string whereNoPara2 = expressionNodeCollection.ToWhereNoParameter(dbTableInfoDic, tableAliaNameDic, filedValueConverterCollection, fieldValueFormator);
Loger.Info(whereNoPara2);
tableAliaNameDic.Clear();
parameterNameValueDic = null;
parameterIndex = 1;
string where3 = expressionNodeCollection.ToWhere(dbTableInfoDic, tableAliaNameDic, filedValueConverterCollection, dbAccess.ParaSign, ref parameterIndex, out parameterNameValueDic);
Loger.Info(where3);
string whereNoPara3 = expressionNodeCollection.ToWhereNoParameter(dbTableInfoDic, tableAliaNameDic, filedValueConverterCollection, fieldValueFormator);
Loger.Info(whereNoPara3);
}
catch (Exception ex)
{
Loger.Error(ex);
}
}
private void TestEF(object state)
{
try
{
var config = (DatabaseConfig)state;
IDBAccess dbAccess = DBAccessManager.GetDBAccessInstance(config.DBID);
// //ManualSettingPKValue
// //ManualAssignPKValue
// //Expression<Func<Stu, long>> expression = t => t.ID;
// //((EFDbContext)context)._Expression = expression;
// using (var con = dbAccess.CreateConnection(DBVisitType.W))
// {
// var paraSign = dbAccess.ParaSign;
// var cmd = con.DbConnection.CreateCommand();
// cmd.CommandText = $@"INSERT INTO STU (ID,NAME,AGE,BIR) VALUES({paraSign}ID,{paraSign}NAME,{paraSign}AGE,{paraSign}BIR)";
// cmd.AddParameter("ID", 2);
// cmd.AddParameter("NAME", "yf");
// cmd.AddParameter("AGE", 22);
// cmd.AddParameter("BIR", new DateTime(1988, 11, 30, 2, 22, 45));
// cmd.ExecuteNonQuery();
// }
//if (config.DBID == this._oracleDbid)
//{
// using (var context = dbAccess.CreateEFDbContext(DBVisitType.R, (cfg, modelBuilder) =>
// {
// modelBuilder.Entity<StuOracle>().ToTable(nameof(Stu).ToUpper(), string.Empty);
// modelBuilder.Entity<StuOracle>().Property(p => p.ID).HasColumnName(nameof(StuOracle.ID).ToUpper()).HasDatabaseGeneratedOption(System.ComponentModel.DataAnnotations.Schema.DatabaseGeneratedOption.None);
// modelBuilder.Entity<StuOracle>().Property(p => p.Name).HasColumnName(nameof(StuOracle.Name).ToUpper());
// modelBuilder.Entity<StuOracle>().Property(p => p.Age).HasColumnName(nameof(StuOracle.Age).ToUpper());
// modelBuilder.Entity<StuOracle>().Property(p => p.Bir).HasColumnName(nameof(StuOracle.Bir).ToUpper());
// }))
// {
// var stu = new StuOracle();
// this.SetValue(stu);
// context.Insert(stu);
// }
//}
//else
//{
// using (var context = new TestContext(config.DBID, DBVisitType.W))
// {
// var stu = new Stu();
// this.SetValue(stu);
// context.Insert(stu);
// }
//}
using (var context = dbAccess.CreateEFDbContext(DBVisitType.R, this.CustomRegisteEntityTypeFunc))
{
if (config.DBID == this._oracleDbid)
{
//AssemblyEx.Enable = true;
var stu = new DotnetWinFormApp.DB.StuOracle();
this.SetValue(stu);
context.Insert(stu);
//var stuList = new List<StuOracle>();
//Random rnd = new Random();
//long id = 107;
//for (int i = 0; i < 1000; i++)
//{
// var stu = new StuOracle();
// this.SetValue(stu, id++);
// stuList.Add(stu);
//}
//context.InsertBulk(stuList);
}
else
{
var stu = new DotnetWinFormApp.DB.Stu();
this.SetValue(stu);
context.Insert(stu);
//var stuList = new List<Stu>();
//Random rnd = new Random();
//for (int i = 0; i < 1000; i++)
//{
// var stu = new Stu();
// this.SetValue(stu);
// stuList.Add(stu);
//}
//context.InsertBulk(stuList);
}
}
//using (var context = new TestContext(config.DBID, DBVisitType.W))
//{
// if (config.DBID == this._oracleDbid)
// {
// var stu = new StuOracle();
// this.SetValue(stu);
// context.Insert(stu);
// }
// else
// {
// var stu = new Stu();
// this.SetValue(stu);
// context.Insert(stu);
// }
//}
Loger.Info("Insert Completed...");
//var stus = context.Query<Stu>().ToArray();
//if (collection != null && collection.Count > 0)
//{
// List<IDbDataParameter> paras = new List<IDbDataParameter>();
// foreach (var para in collection)
// {
// paras.Add(this._interaction.CreateDbParameter(para));
// }
// return ((System.Data.Entity.DbContext)context).Database.SqlQuery<T>(sqlStr, paras.ToArray()).ToList();
//}
//else
//{
// return ((System.Data.Entity.DbContext)context).Database.SqlQuery<T>(sqlStr, null).ToList();
//}
// }
}
catch (Exception ex)
{
Loger.Error(ex);
}
}
// when is query is selected and filter parameters are set
private void OnSearchBtnClick(object sender, RoutedEventArgs e)
{
var header = string.Empty;
if (methodistTab.IsSelected)
{
if (mquery1.IsSelected)
{
var dataTable = GetAvailableClassRooms();
if (dataTable == null)
{
return;
}
if (dataTable.Rows.Count < 1)
{
ShowPopup("По заданим даним немає інформації");
}
else
{
header = GetMquery1Header();
}
SetDataView(header, dataTable);
}
else if (mquery2.IsSelected)
{
var dataTable = GetScheduleForWeek();
if (dataTable == null)
{
return;
}
if (dataTable.Rows.Count < 1)
{
ShowPopup("По заданим даним немає інформації");
}
else
{
header = GetMquery2Header();
}
SetDataView(header, dataTable);
}
else if (classroomConsistensy.IsSelected)
{
var inconsistentData = DBAccessManager.GetInconsistentClassrooms();
SetDataView("Перевірка аудиторій на несуперечливість", inconsistentData);
}
else if (teacherConsistensy.IsSelected)
{
var inconsistentData = DBAccessManager.GetInconsistentTeachers();
SetDataView("Перевірка вчителів на несуперечливість", inconsistentData);
}
}
else if (teacherTab.IsSelected)
{
if (teacherSubjectScheduleQuery.IsSelected)
{
var dataTable = GetSubjectScheduleTeacherTab();
if (dataTable == null)
{
return;
}
if (dataTable.Rows.Count < 1)
{
ShowPopup("По заданим даним немає інформації");
}
else
{
header = GetSubjectScheduleHeaderTeacherTab();
}
SetDataView(header, dataTable);
}
else if (teacherScheduleQuery.IsSelected)
{
var dataTable = GetTeacherSchedule();
if (dataTable == null)
{
return;
}
if (dataTable.Rows.Count < 1)
{
ShowPopup("По заданим даним немає інформації");
}
else
{
header = GetTeacherScheduleHeader();
}
SetDataView(header, dataTable);
}
}
else if (studentTab.IsSelected)
{
if (studentSubjectScheduleQuery.IsSelected)
{
var dataTable = GetSubjectScheduleStudentsTab();
if (dataTable == null)
{
return;
}
if (dataTable.Rows.Count < 1)
{
ShowPopup("По заданим даним немає інформації");
}
else
{
header = GetSubjectScheduleHeaderStudentTab();
}
SetDataView(header, dataTable);
}
else if (studentScheduleQuery.IsSelected)
{
var dataTable = GetStudentSchedule();
if (dataTable == null)
{
return;
}
if (dataTable.Rows.Count < 1)
{
ShowPopup("По заданим даним немає інформації");
}
else
{
header = GetStudentScheduleHeader();
}
SetDataView(header, dataTable);
}
}
}
private void FTest_FormClosing(object sender, FormClosingEventArgs e)
{
DBAccessManager.Release();
}
public void Init()
{
this._dbAccess = DBAccessManager.GetDBAccessInstance(1);
}
