protected override string FormatSystemMethods(SystemMethods systemMethod) { switch (systemMethod) { case SystemMethods.CurrentDateTime: return "CURRENT_TIMESTAMP"; } throw new NotImplementedException(); }
protected override string FormatSystemMethods(SystemMethods systemMethod) { switch (systemMethod) { case SystemMethods.CurrentDateTime: return "CURRENT_TIMESTAMP"; } return null; }
protected override string FormatSystemMethods(SystemMethods systemMethod) { switch (systemMethod) { case SystemMethods.NewGuid: return "sys_guid()"; } return null; }
protected override string FormatSystemMethods(SystemMethods systemMethod) { switch (systemMethod) { case SystemMethods.NewGuid: return "sys_guid()"; case SystemMethods.CurrentDateTime: return "SYSDATE"; } return null; }
protected override string FormatSystemMethods(SystemMethods systemMethod) { switch (systemMethod) { case SystemMethods.CurrentUTCDateTime: return "CURRENT_TIMESTAMP"; case SystemMethods.CurrentDateTime: return "datetime('now','localtime')"; } return null; }
protected override string FormatSystemMethods(SystemMethods systemMethod) { switch (systemMethod) { case SystemMethods.NewGuid: return "NEWID()"; case SystemMethods.CurrentDateTime: return "GETDATE()"; } return null; }
protected override string FormatSystemMethods(SystemMethods systemMethod) { switch (systemMethod) { case SystemMethods.NewGuid: //need to run the script share/contrib/uuid-ossp.sql to install the uuid_generate4 function return "uuid_generate_v4()"; case SystemMethods.CurrentDateTime: return "now()"; } throw new NotImplementedException(); }
protected override string FormatSystemMethods(SystemMethods systemMethod) { switch (systemMethod) { case SystemMethods.NewGuid: return "NEWID()"; case SystemMethods.NewSequentialId: return "NEWSEQUENTIALID()"; case SystemMethods.CurrentDateTime: return "GETDATE()"; case SystemMethods.CurrentUTCDateTime: return "GETUTCDATE()"; } return null; }
public override string FormatSystemMethods(SystemMethods value) { switch (value) { case SystemMethods.CurrentDateTimeOffset: case SystemMethods.CurrentDateTime: return("SYSDATE"); case SystemMethods.CurrentUTCDateTime: return("(SYSDATE at time zone 'UTC')"); case SystemMethods.CurrentUser: return("current_user"); } return(base.FormatSystemMethods(value)); }
protected override string FormatSystemMethods(SystemMethods systemMethod) { switch (systemMethod) { case SystemMethods.NewGuid: return("NEWID()"); case SystemMethods.CurrentDateTime: return("GETDATE()"); //case SystemMethods.NewSequentialId: // return "NEWSEQUENTIALID()"; //case SystemMethods.CurrentUTCDateTime: // return "GETUTCDATE()"; } return(null); }
public override string FormatSystemMethods(SystemMethods value) { switch (value) { case SystemMethods.NewSequentialId: case SystemMethods.NewGuid: return("gen_uuid()"); case SystemMethods.CurrentDateTime: return("CURRENT_TIMESTAMP"); case SystemMethods.CurrentUser: return("CURRENT_USER"); } return(base.FormatSystemMethods(value)); }
public IAlterColumnOptionSyntax WithDefault(SystemMethods method) { // we need to do a drop constraint and then add constraint to change the defualt value var dc = new AlterDefaultConstraintExpression { TableName = Expression.TableName, SchemaName = Expression.SchemaName, ColumnName = Expression.Column.Name, DefaultValue = method }; _context.Expressions.Add(dc); Expression.Column.DefaultValue = method; return(this); }
protected void btnSummarySave_Click(object sender, EventArgs e) { //saves summary. SystemMethods.executeStoredProcedureWithVars("stpUpdateSummary", new string[9, 3] { { "@functionId", Page.RouteData.Values["functionId"].ToString(), "int" }, { "@functionName", txtName.Text, "varChar" }, { "@description", txtDes.Text, "varChar" }, { "@fte", txtFTE.Text, "decimal" }, { "@equipment", txtEquipment.Text, "varChar" }, { "@supplies", txtSupplies.Text, "varChar" }, { "@records", txtRecords.Text, "varChar" }, { "@customers", txtCustomers.Text, "varChar" }, { "@software", txtSoftware.Text, "varChar" } }); //reloads summary to make sure its changes in database. loadSummary(); labSummaryError.Text = "Changes Saved. Page Updated."; }
/// <summary> /// ログデータの読み込みを実行する /// </summary> private void SetData() { //データを読み込む _logDataRecords = LogDataList.Load(_files[_logFileComboBox.SelectedIndex]); // if (_logDataRecords == null) { SystemMethods.GetMessageBox(MessageCategory.Error , "選択したファイルはログファイルではありません。" , ICADRenamer.Log.LogMessageKind.Error); return; } _logDataListBindingSource.DataSource = _logDataRecords; //レコードを最初へ _logDataListBindingSource.MoveFirst(); //レベルリスト更新 SetLevelComboBox(); }
public static string getStaffMembersForLeftMenu() { //this gets each staff member from database. DataTable staffMembers = SystemMethods.getDataTableFromStoredProcedure("stpGetStaffMembers"); //this is used for ABC order string letters = "ABCDEFGHIJKLMNOPQRSTUVWXYZ"; int rows = staffMembers.Rows.Count; //this will be the html code for the left menu. string html = ""; //this list is to store them in order List <CompanyStaffMember> staffMemberList = new List <CompanyStaffMember>(); for (int uth = 0; uth < rows; uth++) { staffMemberList.Add(new CompanyStaffMember(Int32.Parse(staffMembers.Rows[uth]["staffMemberId"].ToString()), staffMembers.Rows[uth]["lastName"].ToString() + ", " + staffMembers.Rows[uth]["firstName"].ToString())); } //this makes the html code for the left menu for (int uth = 0; uth < letters.Length; uth++) { int makeHeader = 1; while (true) { CompanyStaffMember foundMember = staffMemberList.Find(x => x.firstLetter == letters[uth]); if (foundMember == null) { break; } if (makeHeader == 1) { html += "<div id='" + letters[uth] + "'>"; html += "<h2><a href='#" + letters[uth] + "'>" + letters[uth] + "</a></h2>"; makeHeader = 0; } staffMemberList.Remove(foundMember); html += "<p><a href='/StaffMember/" + foundMember.staffMemberId + "#" + letters[uth] + "'>" + foundMember.staffMemberName + "</a></p>"; } if (makeHeader == 0) { html += "</div>"; } } return(html); }
/// <summary> /// Deletes a file or directory /// </summary> /// <param name="brickDirectoryPath">The relative path, must start with ../ and end with /</param> /// <param name="recursive">if true deletes the directory and all its contents</param> /// <returns><c>true</c> if deleted otherwise <c>false</c></returns> public static async Task <bool> DeleteDirectory(string brickDirectoryPath, bool recursive = false) { brickDirectoryPath = Firmware.FileSystem.ToBrickDirectoryPath(brickDirectoryPath); if (recursive) { DirectoryContent content = await GetDirectoryContent(brickDirectoryPath); foreach (File file in content.Files) { await DeleteFile(file.Path); } foreach (Directory directory in content.Directories) { await DeleteDirectory(directory.Path, recursive); } } return(await SystemMethods.Delete(Brick.Socket, brickDirectoryPath)); }
protected override string FormatSystemMethods(SystemMethods systemMethod) { switch (systemMethod) { case SystemMethods.NewGuid: //need to run the script share/contrib/uuid-ossp.sql to install the uuid_generate4 function return "uuid_generate_v4()"; case SystemMethods.NewSequentialId: return "uuid_generate_v1()"; case SystemMethods.CurrentDateTime: return "now()"; case SystemMethods.CurrentUTCDateTime: return "(now() at time zone 'UTC')"; case SystemMethods.CurrentUser: return "current_user"; } throw new NotImplementedException(string.Format("System method {0} is not implemented.", systemMethod)); }
protected override string FormatSystemMethods(SystemMethods systemMethod) { switch (systemMethod) { case SystemMethods.NewGuid: //need to run the script share/contrib/uuid-ossp.sql to install the uuid_generate4 function return("uuid_generate_v4()"); case SystemMethods.CurrentDateTime: return("now()"); case SystemMethods.CurrentUTCDateTime: return("(now() at time zone 'UTC')"); case SystemMethods.CurrentUser: return("current_user"); } throw new NotImplementedException(); }
protected void btnSaveChanges_Click(object sender, EventArgs e) { //deletes all used databases. SystemMethods.executeStoredProcedureWithVars("stpDeleteUsedDatabases", new string[1, 3] { { "@functionId", Page.RouteData.Values["functionId"].ToString(), "int" } }); //adds databases from checkbox gridview. foreach (GridViewRow row in gridUsedDatabase.Rows) { CheckBox cb = (CheckBox)row.FindControl("chkDatabaseSelector"); if (cb != null && cb.Checked) { SystemMethods.executeStoredProcedureWithVars("stpAddUsedDatabase", new string[2, 3] { { "@functionId", Page.RouteData.Values["functionId"].ToString(), "int" }, { "@databaseId", gridUsedDatabase.Rows[row.RowIndex].Cells[0].Text, "int" } }); } } Response.Redirect("~/Function/Update/" + Page.RouteData.Values["functionId"].ToString()); }
protected void btnSaveChanges_Click(object sender, EventArgs e) { //deletes all applications form database. SystemMethods.executeStoredProcedureWithVars("stpDeleteUsedApplications", new string[1, 3] { { "@functionId", Page.RouteData.Values["functionId"].ToString(), "int" } }); //checks to see what ones are check then adds them foreach (GridViewRow row in gridApplicationSelector.Rows) { CheckBox cb = (CheckBox)row.FindControl("chkApplicationSelector"); if (cb != null && cb.Checked) { SystemMethods.executeStoredProcedureWithVars("stpAddUsedApplication", new string[2, 3] { { "@functionId", Page.RouteData.Values["functionId"].ToString(), "int" }, { "@applicationId", gridApplicationSelector.Rows[row.RowIndex].Cells[0].Text, "int" } }); } } Response.Redirect("~/Function/Update/" + Page.RouteData.Values["functionId"].ToString()); }
public override string FormatSystemMethods(SystemMethods value) { switch (value) { case SystemMethods.NewSequentialId: case SystemMethods.NewGuid: return("NEWID()"); case SystemMethods.CurrentDateTimeOffset: case SystemMethods.CurrentDateTime: return("CURRENT TIMESTAMP"); case SystemMethods.CurrentUTCDateTime: return("CURRENT UTC TIMESTAMP"); case SystemMethods.CurrentUser: return("CURRENT USER"); } return(base.FormatSystemMethods(value)); }
protected void btnAdd_Click(object sender, EventArgs e) { //makes sure nothing is empty. if (txtBackup.Text == null || txtLocation.Text == null || txtName.Text == null || txtRecovery.Text == null || txtSupport.Text == null) { //error labError.Text = "Do not leave anything blank."; } else { //checks to see if it should add or update. if (btnAdd.Text[0] == 'A') { //sends data to add. SystemMethods.executeStoredProcedureWithVars("stpInsertDatabase", new string[5, 3] { { "@databaseName", txtName.Text, "varChar" }, { "@storageLocation", txtLocation.Text, "varChar" }, { "@backupStorageLocation", txtBackup.Text, "varChar" }, { "@supportManager", txtSupport.Text, "varChar" }, { "@recoveryTimeObjective", txtRecovery.Text, "varChar" } }); //moves pages after add. Response.Redirect("~/lvl1_adminDatabase.aspx"); } else { //sends data to database. SystemMethods.executeStoredProcedureWithVars("stpUpdateDatabase", new string[6, 3] { { "@databaseId", Page.RouteData.Values["databaseId"].ToString(), "int" }, { "@databaseName", txtName.Text, "varChar" }, { "@storageLocation", txtLocation.Text, "varChar" }, { "@backupStorageLocation", txtBackup.Text, "varChar" }, { "@supportManager", txtSupport.Text, "varChar" }, { "@recoveryTimeObjective", txtRecovery.Text, "varChar" } }); //moves pages after add. Response.Redirect("~/lvl1_adminDatabase.aspx"); } } }
/// <summary> /// This method Executes a Non Query StoredProcedure /// </summary> public PolymorphicObject ExecuteNonQuery(string procedureName, SqlParameter[] sqlParameters) { // initial value PolymorphicObject returnValue = new PolymorphicObject(); // locals List <PolymorphicObject> parameters = new List <PolymorphicObject>(); // create the parameters PolymorphicObject procedureNameParameter = new PolymorphicObject(); PolymorphicObject sqlParametersParameter = new PolymorphicObject(); // if the procedureName exists if (!String.IsNullOrEmpty(procedureName)) { // Create an instance of the SystemMethods object SystemMethods systemMethods = new SystemMethods(); // setup procedureNameParameter procedureNameParameter.Name = "ProcedureName"; procedureNameParameter.Text = procedureName; // setup sqlParametersParameter sqlParametersParameter.Name = "SqlParameters"; sqlParametersParameter.ObjectValue = sqlParameters; // Add these parameters to the parameters parameters.Add(procedureNameParameter); parameters.Add(sqlParametersParameter); // get the dataConnector DataAccessComponent.DataManager.DataConnector dataConnector = GetDataConnector(); // Execute the query returnValue = systemMethods.ExecuteNonQuery(parameters, dataConnector); } // return value return(returnValue); }
public override string FormatSystemMethods(SystemMethods value) { switch (value) { case SystemMethods.NewGuid: //need to run the script share/contrib/uuid-ossp.sql to install the uuid_generate4 function return("uuid_generate_v4()"); case SystemMethods.NewSequentialId: return("uuid_generate_v1()"); case SystemMethods.CurrentDateTime: return("now()"); case SystemMethods.CurrentUTCDateTime: return("(now() at time zone 'UTC')"); case SystemMethods.CurrentUser: return("current_user"); } return(base.FormatSystemMethods(value)); }
public override string FormatSystemMethods(SystemMethods value) { switch (value) { case SystemMethods.NewGuid: return("NEWID()"); case SystemMethods.NewSequentialId: return("NEWSEQUENTIALID()"); case SystemMethods.CurrentDateTime: return("GETDATE()"); case SystemMethods.CurrentDateTimeOffset: case SystemMethods.CurrentUTCDateTime: return("GETUTCDATE()"); case SystemMethods.CurrentUser: return("CURRENT_USER"); } return(base.FormatSystemMethods(value)); }
protected void btnAdd_Click(object sender, EventArgs e) { //checks to make sure everything is filled in. if (txtName.Text == null || txtLocation.Text == null || txtRecovery.Text == null || txtSupport.Text == null) { //error text labError.Text = "Do not leave anything blank"; } else { //a means add new. if (btnAdd.Text[0] == 'A') { //sends data to database to add new SystemMethods.executeStoredProcedureWithVars("stpInsertApplication", new string[4, 3] { { "@applicationName", txtName.Text, "varChar" }, { "@instalFilesLocation", txtLocation.Text, "varChar" }, { "@supportManager", txtSupport.Text, "varChar" }, { "@recoveryTimeline", txtRecovery.Text, "varChar" } }); //redirect you after added. Response.Redirect("~/lvl1_adminApplication.aspx"); } else { //this means update SystemMethods.executeStoredProcedureWithVars("stpUpdateApplication", new string[5, 3] { { "@applicationId", Page.RouteData.Values["applicationId"].ToString(), "int" }, { "@applicationName", txtName.Text, "varChar" }, { "@instalFilesLocation", txtLocation.Text, "varChar" }, { "@supportManager", txtSupport.Text, "varChar" }, { "@recoveryTimeObjective", txtRecovery.Text, "varChar" } }); //moves you after update. Response.Redirect("~/lvl1_adminApplication.aspx"); } } }
public static bool createUser(string firstname, string lastname, string email, string empId, string password, string salt, int role) { try { //this creates a user... SystemMethods.executeStoredProcedureWithVars("stpInsertUser", new string[7, 3] { { "@firstName", firstname, "varchar" }, { "@lastName", lastname, "varchar" }, { "@email", email, "varchar" }, { "@employeeId", empId, "varchar" }, { "@pass", SystemMethods.hash(password, salt), "varchar" }, { "@salt", salt, "varchar" }, { "@role", role.ToString(), "int" }, } ); } catch (Exception ex) { return(false); } return(true); }
public override string FormatSystemMethods(SystemMethods value) { switch (value) { case SystemMethods.NewGuid: case SystemMethods.NewSequentialId: return("sys_guid()"); case SystemMethods.CurrentDateTime: return("LOCALTIMESTAMP"); case SystemMethods.CurrentDateTimeOffset: return("CURRENT_TIMESTAMP"); case SystemMethods.CurrentUTCDateTime: return("sys_extract_utc(SYSTIMESTAMP)"); case SystemMethods.CurrentUser: return("USER"); } return(base.FormatSystemMethods(value)); }
protected void btnAdd_Click(object sender, EventArgs e) { if (btnAdd.Text[0] == 'U') { if (txtFirstName.Text == null || txtLastName.Text == null || txtEmail.Text == null) { labError.Text = "Fill out all info."; } else { //updates staff member SystemMethods.executeStoredProcedureWithVars("stpUpdateStaffMember", new string[7, 3] { { "@staffMemberId", Page.RouteData.Values["staffMemberId"].ToString(), "int" }, { "@firstName", txtFirstName.Text, "varChar" }, { "@lastName", txtLastName.Text, "varChar" }, { "@email", txtEmail.Text, "varChar" }, { "@homePhone", txtHome1.Text + txtHome2.Text + txtHome3.Text, "varChar" }, { "@mobliePhone", txtMobile1.Text + txtMobile2.Text + txtMobile3.Text, "varChar" }, { "@workPhone", txtWork1.Text + txtWork2.Text + txtWork3.Text, "varChar" } }); Response.Redirect("~/StaffMember/" + Page.RouteData.Values["staffMemberId"].ToString()); } } else { //add new staff member SystemMethods.executeStoredProcedureWithVars("stpNewStaffMember", new string[6, 3] { { "@firstName", txtFirstName.Text, "varChar" }, { "@lastName", txtLastName.Text, "varChar" }, { "@email", txtEmail.Text, "varChar" }, { "@homePhone", txtHome1.Text + txtHome2.Text + txtHome3.Text, "varChar" }, { "@mobliePhone", txtMobile1.Text + txtMobile2.Text + txtMobile3.Text, "varChar" }, { "@workPhone", txtWork1.Text + txtWork2.Text + txtWork3.Text, "varChar" } }); Response.Redirect("~/Default.aspx"); } }
protected void btnLock_Click(object sender, EventArgs e) { //locks an account and unlocks. if (btnLock.Text[0] == 'L') { SystemMethods.executeStoredProcedureWithVars( "stpLockUser", new string[1, 3] { { "@userId", Page.RouteData.Values["userId"].ToString(), "int" } } ); btnLock.Text = "Unlock User"; } else if (btnLock.Text[0] == 'U') { SystemMethods.executeStoredProcedureWithVars( "stpUnlockUser", new string[1, 3] { { "@userId", Page.RouteData.Values["userId"].ToString(), "int" } } ); btnLock.Text = "Lock User"; } }
/// <inheritdoc /> public ICreateTableColumnOptionBuilder WithDefault(SystemMethods method) { CurrentColumn.DefaultValue = method; return(this); }
protected override string FormatSystemMethods(SystemMethods systemMethod) { throw new NotImplementedException(); }
protected void Page_Load(object sender, EventArgs e) { //this defaults to false because we should assume people are not allowed in. btnAdmin.Visible = false; try { //this makes sure the ticket they have is vaild if (!Request.IsAuthenticated) { //if ticket not vaild goto login. Response.Redirect("~/login.aspx"); } //this decrpyts the ticket in order to retrive the userId and Role. FormsAuthenticationTicket ticket = FormsAuthentication.Decrypt(Request.Cookies["mysite.ASPXAUTH"].Value); //this makes sure the user is still allowed on the website. if (!SystemUser.userVaildCheck(Int32.Parse(ticket.Name), Session["key"].ToString())) { //if not allowed goto login. Response.Redirect("~/login.aspx"); } //this gets the user role out of ticket. int userRole = Int32.Parse(ticket.UserData); //check to see if admin tab should be shown if (userRole == 1 || userRole == 4) { //shows tab btnAdmin.Visible = true; } //puts the persons name on screen...makes them feel like a person....not a number i guess. menuPersonName.InnerText = Request.Cookies["name"].Value; } catch (Exception ex) { //if anything goes wrong here i assume they are not allowed and force them to login. Response.Redirect("~/login.aspx"); } clearButtons(); //this bit of code. gets the session that remembers what tab you were on between pages. //its almost like we care about people... //the only 3 options for this // dept // staff // admin switch (Session["tab"].ToString()) { case "dept": btnDepartment.CssClass = "tabSelected leftMenuButton"; accordContent.InnerHtml = CompanyDepartment.getDepartmentsForLeftMenu(); break; case "staff": btnStaff.CssClass = "tabSelected leftMenuButton leftMenuButtonMoveLeft"; accordContent.InnerHtml = CompanyStaffMember.getStaffMembersForLeftMenu(); break; case "admin": btnAdmin.CssClass = "tabSelected leftMenuButton leftMenuButtonMoveLeft"; accordContent.InnerHtml = SystemMethods.adminLeftMenu(); break; } }
protected abstract string FormatSystemMethods(SystemMethods systemMethod);
protected abstract string FormatSystemMethods(SystemMethods systemMethod);
public virtual string FormatSystemMethods(SystemMethods value) { throw new NotSupportedException($"The system method {value} is not supported."); }
protected override string FormatSystemMethods(SystemMethods systemMethod) { throw new NotImplementedException(); }
public ICreateColumnOptionBuilder WithDefault(SystemMethods method) { Expression.Column.DefaultValue = method; return(this); }
public static SystemUser attemptLogin(string enteredPass, string enteredEmail) { /* user accountStatus codes * 1 - Account Ok * 2 - Account Reset * 3 - Account Locked * 4 - Account Wrong * 5 - Not allowed to login */ //this trys to login a user. try { //this first lines attempt to find the account DataTable theUser = SystemUser.userLogin(enteredEmail, enteredPass); //from that some tests are done to see if its vaild and allowed to login. //first test is to get the user role and check if that role is allowed to login if (!SystemUser.allowedLogin(Int32.Parse(theUser.Rows[0]["roleId"].ToString()))) { //error 5 not allowed return(new SystemUser(5)); } //next makes sure the account is not locked. if (Int32.Parse(theUser.Rows[0]["locked"].ToString()) == 1) { //error 3 account locked return(new SystemUser(3)); } //this test makes sure your password is not 30 days old. if (DateTime.Parse(theUser.Rows[0]["resetDate"].ToString()) <= DateTime.Today) { //error code 2 reset password return(new SystemUser(2, Int32.Parse(theUser.Rows[0]["userId"].ToString()))); } //this checks to see if an admin is making you change your password. if (Int32.Parse(theUser.Rows[0]["reset"].ToString()) == 1) { //error code 2 reset password return(new SystemUser(2, Int32.Parse(theUser.Rows[0]["userId"].ToString()))); } //this then gets the user id. int userId = Int32.Parse(theUser.Rows[0]["userId"].ToString()); //this makes the user a session key to use. //this reuses the saltMaker so session keys are from 100-300 chars string SessionKey = SystemMethods.saltMaker(); //this adds a row into the loginTracker Table //it also gets the user ip. SystemUser.newUserLogin(userId, 0, SystemMethods.getIp()); //this updates the users lastLogin date. SystemUser.updateLoginDate(userId); //this makes them a row in the active sessions table. SystemUser.insertNewSession(userId, SessionKey); //this then returns the user back with the information need to go on. return(new SystemUser(Int32.Parse(theUser.Rows[0]["roleId"].ToString()), userId, theUser.Rows[0]["firstName"].ToString(), theUser.Rows[0]["lastName"].ToString(), theUser.Rows[0]["email"].ToString(), 1, SessionKey)); } catch (Exception ex) { //this means something when wrong. //this line add a new row into logintracker because it was still an attempt. //this also gets the users ip. SystemUser.newUserLogin(getUserIdByEmail(enteredEmail), 1, SystemMethods.getIp()); //this add 1 to failedlogins on an account. SystemUser.wrongLogin(enteredEmail); //error code 4 wrong login. return(new SystemUser(4)); } }
public IAlterTableColumnOptionOrAddColumnOrAlterColumnSyntax WithDefault(SystemMethods method) { CurrentColumn.DefaultValue = method; return(this); }
public IAlterColumnOptionSyntax WithDefault(SystemMethods method) { return(WithDefaultValue(method)); }