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); }