public IActionResult OnPost() { DatabaseConnect dbstring = new DatabaseConnect(); //creating an object from the class string DbConnection = dbstring.DatabaseString(); //calling the method from the class Console.WriteLine(DbConnection); SqlConnection conn = new SqlConnection(DbConnection); conn.Open(); Console.WriteLine(User.FirstName); Console.WriteLine(User.UserName); Console.WriteLine(User.Password); Console.WriteLine(User.Role); using (SqlCommand command = new SqlCommand()) { command.Connection = conn; command.CommandText = @"INSERT INTO UserTable (FirstName, UserName, Password, Role) VALUES (@FName, @UName, @Pwd, @Role)"; command.Parameters.AddWithValue("@FName", User.FirstName); command.Parameters.AddWithValue("@UName", User.UserName); command.Parameters.AddWithValue("@Pwd", User.Password); command.Parameters.AddWithValue("@Role", User.Role); command.ExecuteNonQuery(); } return(RedirectToPage("/Index")); }
public IActionResult OnPost() { DatabaseConnect dbstring = new DatabaseConnect(); //creating an object from the class string DbConnection = dbstring.DatabaseString(); //calling the method from the class Console.WriteLine(DbConnection); SqlConnection conn = new SqlConnection(DbConnection); conn.Open(); using (SqlCommand command = new SqlCommand()) { command.Connection = conn; command.CommandText = @"INSERT INTO Admin (AdminID, AdminName, AdminLastName, Email, Password) VALUES (@AID, @AName, @ALName, @Email, @PSWD)"; command.Parameters.AddWithValue("@AID", Admin.AdminID); command.Parameters.AddWithValue("@AName", Admin.AdminName); command.Parameters.AddWithValue("@ALName", Admin.AdminLastName); command.Parameters.AddWithValue("@Email", Admin.Email); command.Parameters.AddWithValue("@PSWD", Admin.Password); Console.WriteLine(Admin.AdminID); Console.WriteLine(Admin.AdminName); Console.WriteLine(Admin.AdminLastName); Console.WriteLine(Admin.Email); Console.WriteLine(Admin.Password); command.ExecuteNonQuery(); } return(RedirectToPage("./Index")); }
public async Task <IActionResult> Post(string value) { string buffer; DatabaseConnect dbConnect = new DatabaseConnect(); User user = new User(); HttpRequest request = HttpContext.Request; Microsoft.AspNetCore.Http.HttpRequestRewindExtensions.EnableBuffering(request); using (var sr = new StreamReader(request.Body)) { buffer = sr.ReadToEnd(); } user = JsonConvert.DeserializeObject <User>(buffer); bool exist = await dbConnect.User.Verify(user._userName, user._password); if (exist == true) { return(Ok(ModelState)); } else { return(BadRequest(ModelState)); } }
public IActionResult OnGet(int?Id) //we receive this Id from View.cs { DatabaseConnect DBCon = new DatabaseConnect(); SqlConnection conn = new SqlConnection(DBCon.DatabaseString()); conn.Open(); using (SqlCommand command = new SqlCommand()) { command.Connection = conn; command.CommandText = @"SELECT * FROM FileTable WHERE Id = @Id"; command.Parameters.AddWithValue("@Id", Id); var reader = command.ExecuteReader(); PlayerFileRec = new PlayerFile(); while (reader.Read()) { PlayerFileRec.Id = reader.GetInt32(0); PlayerFileRec.PlayerName = reader.GetString(1); //to display on the html page PlayerFileRec.FileName = reader.GetString(2); //to display on the html page } Console.WriteLine("File name : " + PlayerFileRec.FileName); } return(Page()); }
public IActionResult OnPost() { DatabaseConnect dbstring = new DatabaseConnect(); string DbConnection = dbstring.DatabaseString(); Console.WriteLine(DbConnection); SqlConnection conn = new SqlConnection(DbConnection); conn.Open(); Console.WriteLine(Users.FirstName); Console.WriteLine(Users.LastName); Console.WriteLine(Users.EmailAddress); Console.WriteLine(Users.Password); Console.WriteLine(Users.Role); using (SqlCommand command = new SqlCommand()) { command.Connection = conn; command.CommandText = @"INSERT INTO Users (FirstName, LastName, EmailAddress, Password, Role) VALUES (@FName, @LName, @EAddress, @Pwd, @Role)"; command.Parameters.AddWithValue("@FName", Users.FirstName); command.Parameters.AddWithValue("@LName", Users.LastName); command.Parameters.AddWithValue("@EAddress", Users.EmailAddress); command.Parameters.AddWithValue("@Pwd", Users.Password); command.Parameters.AddWithValue("@Role", Users.Role); command.ExecuteNonQuery(); } return(RedirectToPage("/Login/Login")); }
public IActionResult OnPost() { DatabaseConnect dbstring = new DatabaseConnect(); string DbConnection = dbstring.DatabaseString(); SqlConnection conn = new SqlConnection(DbConnection); conn.Open(); Console.WriteLine("User ID :" + Users.UserID); Console.WriteLine("User First Name : " + Users.FirstName); Console.WriteLine("User Last Name : " + Users.LastName); Console.WriteLine("User Email Address : " + Users.EmailAddress); Console.WriteLine("User Password : "******"User Role : " + Users.Role); using (SqlCommand command = new SqlCommand()) { command.Connection = conn; command.CommandText = "UPDATE Users SET FirstName=@FName, LastName=@LName, EmailAddress=@EAddress, Password=@PWD, Role=@URole WHERE UserID = @UID"; command.Parameters.AddWithValue("@UID", Users.UserID); command.Parameters.AddWithValue("@FName", Users.FirstName); command.Parameters.AddWithValue("@LName", Users.LastName); command.Parameters.AddWithValue("@EAddress", Users.EmailAddress); command.Parameters.AddWithValue("@PWD", Users.Password); command.Parameters.AddWithValue("@URole", Users.Role); command.ExecuteNonQuery(); } conn.Close(); return(RedirectToPage("/User/UserManagement")); }
public IActionResult OnGet(int?id) { DatabaseConnect dbstring = new DatabaseConnect(); string DbConnection = dbstring.DatabaseString(); SqlConnection conn = new SqlConnection(DbConnection); conn.Open(); Users = new Users(); using (SqlCommand command = new SqlCommand()) { command.Connection = conn; command.CommandText = "SELECT * FROM Users WHERE UserID = @UID"; command.Parameters.AddWithValue("@UID", id); Console.WriteLine("User ID : " + id); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { Users.UserID = reader.GetInt32(0); Users.FirstName = reader.GetString(1); Users.LastName = reader.GetString(2); Users.EmailAddress = reader.GetString(3); Users.Password = reader.GetString(4); Users.Role = reader.GetString(5); } } return(Page()); }
protected void CreateUser_Click(object sender, EventArgs e) { DatabaseConnect connectionObject = new DatabaseConnect(); int result = Int32.Parse(connectionObject.userExists(Convert.ToInt64(ID.Text)).ToString()); if (result != 0) { string script = "alert(\"User ID is taken" + result + "\");"; ScriptManager.RegisterStartupScript(this, GetType(), "ServerControlScript", script, true); } else { var host = Dns.GetHostEntry(Dns.GetHostName()); String IPAdress = ""; foreach (IPAddress ip in host.AddressList) { if (ip.AddressFamily == AddressFamily.InterNetwork) { IPAdress = ip.ToString(); } } connectionObject.InsertParticipant(Convert.ToInt64(ID.Text), GenderList.Text, UserName.Text, Date.Text, Job.Text, Email.Text, IPAdress, Password.Text); Response.Redirect("Login.aspx"); } }
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline. public void Configure(IApplicationBuilder app, IWebHostEnvironment env, IOptions <DatabaseFields> dbSettings, ILogger <Startup> logger) { if (DatabaseConnect.HasDatabase(dbSettings.Value)) { logger.LogInformation("Initializing database schema"); DatabaseConnect.CreateDatabase(dbSettings.Value, env); } else { logger.LogWarning("Database credentials are missing. Application will run without connecting to a database. Engagement events will not be persisted"); } app.UseSwagger(); app.UseSwaggerUI(c => c.SwaggerEndpoint("/swagger/v1/swagger.json", "Orca v1")); if (env.IsDevelopment()) { app.UseDeveloperExceptionPage(); } if (!env.IsDevelopment()) { app.UseHsts(); app.UseHttpsRedirection(); } app.UseRouting(); app.UseAuthorization(); app.UseEndpoints(endpoints => { endpoints.MapControllers(); }); }
public void OnGet() { DatabaseConnect dbstring = new DatabaseConnect(); //creating an object from the class string DbConnection = dbstring.DatabaseString(); //calling the method from the class Console.WriteLine(DbConnection); SqlConnection conn = new SqlConnection(DbConnection); conn.Open(); using (SqlCommand command = new SqlCommand()) { command.Connection = conn; command.CommandText = @"SELECT * FROM Customer"; SqlDataReader reader = command.ExecuteReader(); //SqlDataReader is used to read record from a table CustomerRec = new List <Customer>(); //this object of list is created to populate all records from the table while (reader.Read()) { Customer record = new Customer(); //a local var to hold a record temporarily record.Id = reader.GetInt32(0); //getting the first field from the table record.CustomerID = reader.GetString(1); //getting the second field from the table record.CustomerName = reader.GetString(2); //getting the third field from the table record.CustomerLastName = reader.GetString(3); record.Email = reader.GetString(4); CustomerRec.Add(record); //adding the single record into the list } // Call Close when done reading. reader.Close(); } }
public ModelInvokeResult <ServerPK> Update(string strServerId, Server server) { ModelInvokeResult <ServerPK> result = new ModelInvokeResult <ServerPK> { Success = true }; try { List <IBatisNetBatchStatement> statements = new List <IBatisNetBatchStatement>(); var parameterObject = server.ToStringObjectDictionary(false); parameterObject["OldServerId"] = strServerId; /***********************begin 自定义代码*******************/ /***********************end 自定义代码*********************/ string sql = BuilderFactory.DefaultBulder().GetSql("Server_Update2", parameterObject); statements.Add(new IBatisNetBatchStatement { StatementName = "Server_Update2", ParameterObject = parameterObject, Type = SqlExecuteType.UPDATE }); bool needDatabaseConnect = server.ServerId.StartsWith("Job"); if (needDatabaseConnect) { /***********************begin 自定义代码*******************/ DatabaseConnect databaseConnect = new DatabaseConnect { ConnectId = "Job-" + server.ServerId, ConnectName = "作业-" + server.ServerName, Provider = GlobalManager.DIKey_00015_SqlServer2005, ServerName = e0571.web.core.Service.ServiceManager.Instance.CryptoService.StringCrypto.Encrypt(server.IpAddress), DatabaseName = e0571.web.core.Service.ServiceManager.Instance.CryptoService.StringCrypto.Encrypt(GlobalManager.Job_Host_Database), UserCode = e0571.web.core.Service.ServiceManager.Instance.CryptoService.StringCrypto.Encrypt(GlobalManager.Job_Database_User), UserPassword = e0571.web.core.Service.ServiceManager.Instance.CryptoService.StringCrypto.Encrypt(GlobalManager.Job_Database_Password), IBatisMapId = "SqlMap-Job-" + server.ServerId, IbatisConfigFileRefer = GlobalManager.IbatisConfigFileRefer, IbatisConfigFileValue = e0571.web.core.Service.ServiceManager.Instance.CryptoService.StringCrypto.Encrypt(GlobalManager.IbatisConfigFileValue_Job) }; var parameterObject2 = databaseConnect.ToStringObjectDictionary(false); parameterObject2["OldConnectId"] = "Job-" + strServerId; statements.Add(new IBatisNetBatchStatement { StatementName = "DatabaseConnect_Update2", ParameterObject = parameterObject2, Type = SqlExecuteType.UPDATE }); /***********************end 自定义代码*********************/ } BuilderFactory.DefaultBulder().ExecuteNativeSqlNoneQuery(statements); result.instance = new ServerPK { ServerId = strServerId }; if (needDatabaseConnect) { //注册数据连接ase GlobalManager.RegisterDatabaseConnections(); } } catch (Exception ex) { result.Success = false; result.ErrorMessage = ex.Message; } return(result); }
public IActionResult OnGet(int?id) { DatabaseConnect dbstring = new DatabaseConnect(); //creating an object from the class string DbConnection = dbstring.DatabaseString(); //calling the method from the class Console.WriteLine(DbConnection); SqlConnection conn = new SqlConnection(DbConnection); conn.Open(); using (SqlCommand command = new SqlCommand()) { command.Connection = conn; command.CommandText = "SELECT * FROM Customer WHERE Id = @ID"; command.Parameters.AddWithValue("@ID", id); SqlDataReader reader = command.ExecuteReader(); CustomerRec = new Customer(); while (reader.Read()) { CustomerRec.Id = reader.GetInt32(0); CustomerRec.CustomerID = reader.GetString(1); CustomerRec.CustomerName = reader.GetString(2); CustomerRec.CustomerLastName = reader.GetString(3); CustomerRec.Email = reader.GetString(4); } } conn.Close(); return(Page()); }
public IActionResult OnGet(int?id) { DatabaseConnect DbCon = new DatabaseConnect(); SqlConnection conn = new SqlConnection(DbCon.DatabaseString()); conn.Open(); using (SqlCommand command = new SqlCommand()) { command.Connection = conn; command.CommandText = "SELECT * FROM PlayerTable WHERE Id = @ID"; command.Parameters.AddWithValue("@ID", id); SqlDataReader reader = command.ExecuteReader(); PlayerRec = new Player(); while (reader.Read()) { PlayerRec.Id = reader.GetInt32(0); PlayerRec.PlayerID = reader.GetString(1); PlayerRec.PlayerFirstName = reader.GetString(2); PlayerRec.PlayerSurname = reader.GetString(3); PlayerRec.PlayerAge = reader.GetInt32(4); } } conn.Close(); return(Page()); }
public IActionResult OnPost() { DatabaseConnect dbstring = new DatabaseConnect(); string DbConnection = dbstring.DatabaseString(); SqlConnection conn = new SqlConnection(DbConnection); conn.Open(); Console.WriteLine("Product ID : " + Products.ProductID); Console.WriteLine("Product Name : " + Products.ProductName); Console.WriteLine("Product Price : " + Products.ProductPrice); Console.WriteLine("Product Category : " + Products.ProductCategory); Console.WriteLine("Product Description : " + Products.ProductDescription); using (SqlCommand command = new SqlCommand()) { command.Connection = conn; command.CommandText = "UPDATE Products SET ProductName=@PName, ProductPrice=@PPrice, ProductCategory=@PCategory, ProductDescription=@PDescription WHERE ProductID = @PID"; command.Parameters.AddWithValue("@PID", Products.ProductID); command.Parameters.AddWithValue("@PName", Products.ProductName); command.Parameters.AddWithValue("@PPrice", Products.ProductPrice); command.Parameters.AddWithValue("@PCategory", Products.ProductCategory); command.Parameters.AddWithValue("@PDescription", Products.ProductDescription); command.ExecuteNonQuery(); } conn.Close(); return(RedirectToPage("/Product/ProductIndex")); }
public IActionResult OnPost() { if (!ModelState.IsValid) { return(Page()); } DatabaseConnect dbstring = new DatabaseConnect(); //creating an object from the class string DbConnection = dbstring.DatabaseString(); //calling the method from the class Console.WriteLine(DbConnection); SqlConnection conn = new SqlConnection(DbConnection); conn.Open(); Console.WriteLine(User.UserName); Console.WriteLine(User.Password); using (SqlCommand command = new SqlCommand()) { command.Connection = conn; command.CommandText = @"SELECT FirstName, UserName, UserRole FROM UserTable WHERE UserName = @UName AND UserPassword = @Pwd"; command.Parameters.AddWithValue("@UName", User.UserName); command.Parameters.AddWithValue("@Pwd", User.Password); var reader = command.ExecuteReader(); while (reader.Read()) { User.FirstName = reader.GetString(0); User.UserName = reader.GetString(1); User.Role = reader.GetString(2); } } if (!string.IsNullOrEmpty(User.FirstName)) { SessionID = HttpContext.Session.Id; HttpContext.Session.SetString("sessionID", SessionID); HttpContext.Session.SetString("username", User.UserName); HttpContext.Session.SetString("fname", User.FirstName); if (User.Role == "User") { return(RedirectToPage("/UserPages/UserIndex")); } else { return(RedirectToPage("/AdminPages/AdminIndex")); } } else { Message = "Invalid Username and Password!"; return(Page()); } }
public IActionResult OnGet(int?id) { DatabaseConnect dbstring = new DatabaseConnect(); string DbConnection = dbstring.DatabaseString(); SqlConnection conn = new SqlConnection(DbConnection); conn.Open(); Products = new Products(); using (SqlCommand command = new SqlCommand()) { command.Connection = conn; command.CommandText = @"SELECT * FROM Products WHERE ProductID = @PID"; command.Parameters.AddWithValue("@PID", id); Console.WriteLine("Product ID : " + id); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { Products.ProductID = reader.GetInt32(0); Products.ProductName = reader.GetString(1); Products.ProductPrice = reader.GetString(2); Products.ProductCategory = reader.GetString(3); Products.ProductDescription = reader.GetString(4); } } conn.Close(); return(Page()); }
public IActionResult OnPost() { var FileToUpload = Path.Combine(_env.WebRootPath, "Files", File.FileName);//this variable consists of file path Console.WriteLine("File Name : " + FileToUpload); using (var FStream = new FileStream(FileToUpload, FileMode.Create)) { File.CopyTo(FStream);//copy the file into FStream variable } DatabaseConnect DBCon = new DatabaseConnect(); string DbString = DBCon.DatabaseString(); SqlConnection conn = new SqlConnection(DbString); conn.Open(); using (SqlCommand command = new SqlCommand()) { command.Connection = conn; command.CommandText = @"INSERT StudentFile (StudentName, FileName) VALUES (@StdName, @FName)"; command.Parameters.AddWithValue("@StdName", FileRec.Name); command.Parameters.AddWithValue("@FName", File.FileName); Console.WriteLine("File name : " + FileRec.Name); Console.WriteLine("File name : " + File.FileName); command.ExecuteNonQuery(); } return(RedirectToPage("/index")); }
public IActionResult OnPost() { if (!ModelState.IsValid) { return(Page()); } DatabaseConnect dbConn = new DatabaseConnect(); string DbString = dbConn.DatabaseString(); var connStringBuilder = new SqliteConnectionStringBuilder(); connStringBuilder.DataSource = DbString; var conn = new SqliteConnection(connStringBuilder.ConnectionString); conn.Open(); var command = conn.CreateCommand(); Console.WriteLine(User.UserName); Console.WriteLine(User.Password); command.CommandText = @"SELECT FirstName, UserName, UserRole FROM UserTable WHERE UserName = @UName AND UserPassword = @Pwd"; command.Parameters.AddWithValue("@UName", User.UserName); command.Parameters.AddWithValue("@Pwd", User.Password); var reader = command.ExecuteReader(); while (reader.Read()) { User.FirstName = reader.GetString(0); User.UserName = reader.GetString(1); User.Role = reader.GetString(2); } if (!string.IsNullOrEmpty(User.FirstName)) { SessionID = HttpContext.Session.Id; HttpContext.Session.SetString("sessionID", SessionID); HttpContext.Session.SetString("username", User.UserName); HttpContext.Session.SetString("fname", User.FirstName); if (User.Role == "User") { return(RedirectToPage("/UserPages/UserIndex")); } else { return(RedirectToPage("/AdminPages/AdminIndex")); } } else { Message = "Invalid Username and Password!"; return(Page()); } }
private void StoreInDatabase(StudentEvent studentEvent) { _logger.LogInformation(studentEvent.ToString()); DatabaseConnect connect = new DatabaseConnect(); connect.StoreStudentToDatabase(studentEvent); connect.StoreEventToDatabase(studentEvent); }
public async Task <string> GetRecipes(string search) { DatabaseConnect Database = new DatabaseConnect(); List <Recipe> recipes = await Database.Recipe.GetListAsync(search); return(JsonConvert.SerializeObject(recipes)); }
private void XtraForm1_Load(object sender, EventArgs e) { //***** SET CONNECT DB ******** if (this.ConnectionString != null) { if (this.ConnectionString != "") { CONNECT_STRING = this.ConnectionString; } } this.DBC = new DatabaseConnect(CONNECT_STRING); if (this.DBC.chkCONNECTION_STING() == false) { this.DBC.setCONNECTION_STRING_INIFILE(); if (this.DBC.chkCONNECTION_STING() == false) { return; } } new ObjDE.setDatabase(this.DBC); //***************************** StringBuilder sbSQL = new StringBuilder(); sbSQL.Append("SELECT TOP (1) ReadWriteStatus FROM FunctionAccess WHERE (OIDUser = '******') AND(FunctionNo = 'M12') "); int chkReadWrite = this.DBC.DBQuery(sbSQL).getInt(); if (chkReadWrite == 0) { ribbonPageGroup1.Visible = false; } sbSQL.Clear(); sbSQL.Append("SELECT FullName, OIDUSER FROM Users ORDER BY OIDUSER "); new ObjDE.setGridLookUpEdit(glueCREATE, sbSQL, "FullName", "OIDUSER").getData(); new ObjDE.setGridLookUpEdit(glueUPDATE, sbSQL, "FullName", "OIDUSER").getData(); glueCREATE.EditValue = UserLogin.OIDUser; glueUPDATE.EditValue = UserLogin.OIDUser; //glueCode.Properties.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.Standard; //glueCode.Properties.AcceptEditorTextAsNewValue = DevExpress.Utils.DefaultBoolean.True; StringBuilder sbTYPE = new StringBuilder(); sbTYPE.Append("SELECT Name AS VendorType, No AS ID FROM ENUMTYPE WHERE (Module = N'Vendor') ORDER BY No "); new ObjDE.setGridLookUpEdit(glueVendor, sbTYPE, "VendorType", "ID").getData(); glueVendor.Properties.View.PopulateColumns(glueVendor.Properties.DataSource); glueVendor.Properties.View.Columns["ID"].Visible = false; //glueVendor.Properties.DataSource = vendorTypes; //glueVendor.Properties.DisplayMember = "NAME"; //glueVendor.Properties.ValueMember = "ID"; bbiNew.PerformClick(); }
// Checks if the email of the contractor has inputted his hours for the month public Boolean ValidEmail(string email) { var db = new DatabaseConnect().ConnectionString(); int contractID = 0; int empID = 0; using (SqlConnection con = new SqlConnection(db)) { string sql1 = "SELECT ContractorID FROM Contractor WHERE Email = '" + email + "'"; using (SqlCommand cmd = new SqlCommand(sql1, con)) { con.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { contractID = reader.GetInt32(0); } reader.Close(); con.Close(); } string sql2 = "SELECT ContractId FROM Contract WHERE ContractorId = " + empID + ""; using (SqlCommand cmd = new SqlCommand(sql2, con)) { con.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { contractID = reader.GetInt32(0); } reader.Close(); con.Close(); } string sql3 = "SELECT currentMonth FROM EmployeeHour WHERE ContractId = " + contractID + " AND Year = " + DateTime.Now.Year + " And Month =" + DateTime.Now.Month + ""; using (SqlCommand cmd = new SqlCommand(sql3, con)) { con.Open(); Object obj = cmd.ExecuteScalar(); con.Close(); // if it exists if (obj == null) { return(true); } } } return(false); }
public M07_01(DatabaseConnect DBase, int UserID, string TypeID, string TypeName, string CodeID) { InitializeComponent(); this.DB = DBase; this._UserID = UserID; this._TypeID = TypeID; this._TypeName = TypeName; this._CodeID = CodeID; }
public M08_01(DatabaseConnect DBase, int UserID, string BranchID, string BranchName, string LineID) { InitializeComponent(); this.DB = DBase; this._UserID = UserID; this._BranchID = BranchID; this._BranchName = BranchName; this._LineID = LineID; }
private void XtraForm1_Load(object sender, EventArgs e) {//***** SET CONNECT DB ******** if (this.ConnectionString != null) { if (this.ConnectionString != "") { CONNECT_STRING = this.ConnectionString; } } this.DBC = new DatabaseConnect(CONNECT_STRING); if (this.DBC.chkCONNECTION_STING() == false) { this.DBC.setCONNECTION_STRING_INIFILE(); if (this.DBC.chkCONNECTION_STING() == false) { return; } } new ObjDE.setDatabase(this.DBC); //***************************** StringBuilder sbSQL = new StringBuilder(); sbSQL.Append("SELECT TOP (1) ReadWriteStatus FROM FunctionAccess WHERE (OIDUser = '******') AND(FunctionNo = 'F03') "); int chkReadWrite = this.DBC.DBQuery(sbSQL).getInt(); if (chkReadWrite == 0) { ribbonPageGroup1.Visible = false; } sbSQL.Clear(); sbSQL.Append("SELECT FullName, OIDUSER FROM Users ORDER BY OIDUSER "); new ObjDE.setGridLookUpEdit(glueCREATE, sbSQL, "FullName", "OIDUSER").getData(); glueCREATE.EditValue = UserLogin.OIDUser; sbGROUP.Append("SELECT '0' AS [ID], 'Master' AS [Group Function] "); sbGROUP.Append("UNION ALL "); sbGROUP.Append("SELECT '1' AS [ID], 'Development' AS [Group Function] "); sbGROUP.Append("UNION ALL "); sbGROUP.Append("SELECT '2' AS [ID], 'MPS : Master Production Schedule' AS [Group Function] "); sbGROUP.Append("UNION ALL "); sbGROUP.Append("SELECT '3' AS [ID], 'MRP : Material Resource Planning' AS [Group Function] "); sbGROUP.Append("UNION ALL "); sbGROUP.Append("SELECT '4' AS [ID], 'Shipment' AS [Group Function] "); sbGROUP.Append("UNION ALL "); sbGROUP.Append("SELECT '5' AS [ID], 'EXIMs' AS [Group Function] "); sbGROUP.Append("UNION ALL "); sbGROUP.Append("SELECT '6' AS [ID], 'Administrator' AS [Group Function] "); NewData(); LoadData(); }
public IActionResult OnPost() { DatabaseConnect dbstring = new DatabaseConnect(); string DbConnection = dbstring.DatabaseString(); Console.WriteLine(DbConnection); SqlConnection conn = new SqlConnection(DbConnection); conn.Open(); Console.WriteLine(Login.Username); Console.WriteLine(Login.Password); using (SqlCommand command = new SqlCommand()) { command.Connection = conn; command.CommandText = @"SELECT FirstName, Username, User_Type FROM Logins WHERE Username = @Username AND Password = @Password"; command.Parameters.AddWithValue("@Username", Login.Username); command.Parameters.AddWithValue("@Password", Login.Password); var reader = command.ExecuteReader(); while (reader.Read()) { Login.FirstName = reader.GetString(0); Login.Username = reader.GetString(1); Login.User_Type = reader.GetString(2); } } if (!string.IsNullOrEmpty(Login.FirstName)) { SessionID = HttpContext.Session.Id; HttpContext.Session.SetString("SessionID", SessionID); HttpContext.Session.SetString("username", Login.Username); HttpContext.Session.SetString("fname", Login.FirstName); if (Login.User_Type == "Student") { return(RedirectToPage("/Student/StudentIndex")); } if (Login.User_Type == "Teacher") { return(RedirectToPage("/Login/Create")); } else { return(RedirectToPage("/Admin/AdminIndex")); } } else { Message = "Invalid Username or Password!"; return(Page()); } }
private void MainForm_Load(object sender, EventArgs e) { connect = new DatabaseConnect(); eventData = connect.EventData(); for (int i = 0; i < eventData.Count; i++) { cmbEvents.Items.Add(eventData[i][1]); } }
/// <summary> /// This method Creates and instans of the ingredient object, /// it calls method from diffrent classe to attempts to intrepret and edit the names to become more clear. /// </summary> /// <param name="ind">The raw ingrdient string with no editing or crossrefresing done</param> /// <param name="fatalError">A bool which is triggered if the ingredient is determined uninterpretable</param> /// <param name="dbConnect">Instace of the database used to save and edit the database</param> /// <param name="functionality">A instance of a classe which contains many of the nessesary funtionalitys for the method</param> /// <returns>Return a new instance</returns> private Ingredient CreateIngriedient(string ind, out bool fatalError, DatabaseConnect dbConnect, AssistingClasses functionality) { float amount = functionality.getDetermin().DeterminAmount(ind); String unit = functionality.getDetermin().DeterminUnit(ind); String name = functionality.getDetermin().DeterminName(ind).Trim(); name = nameEditing_Evalution(name, out fatalError, dbConnect, functionality); return(new Ingredient(name.Trim(), unit, amount)); }
private void openDatabaseWindow() { var databaseConnector = new DatabaseConnect(); databaseConnector.TopMost = true; databaseConnector.Show(); this.EnableDisable(false); databaseConnector.onConnect += (sender, e) => SetInitialConnectionStatus(e); databaseConnector.FormClosed += (sender, e) => this.EnableDisable(true); }
public IActionResult OnGet() { UserName = HttpContext.Session.GetString(SessionKeyName1); UserEmail = HttpContext.Session.GetString(SessionKeyName2); SessionID = HttpContext.Session.GetString(SessionKeyName3); Console.WriteLine("Current session: " + UserName); Console.WriteLine("Current session ID: " + SessionID); if (string.IsNullOrEmpty(UserName)) { Console.WriteLine("Session ended"); return(RedirectToPage("/Users/UserLogin")); } else { var connectionStringBuilder = new SqliteConnectionStringBuilder(); DatabaseConnect DBCon = new DatabaseConnect(); string dbStringConnection = DBCon.DBStringConnection(); //getting the connection string from this class connectionStringBuilder.DataSource = dbStringConnection; var connection = new SqliteConnection(connectionStringBuilder.ConnectionString); connection.Open(); var selectCmd = connection.CreateCommand(); selectCmd.CommandText = @"SELECT PicName FROM Picture WHERE Email=$email"; selectCmd.Parameters.AddWithValue("$email", UserEmail); var reader = selectCmd.ExecuteReader(); var fileName = ""; while (reader.Read()) { fileName = reader.GetString(0); } if (string.IsNullOrEmpty(fileName)) { pathPicture = "DefaulPic.jpeg"; Console.WriteLine("Default pic : " + pathPicture); return(Page()); } pathPicture = fileName; Console.WriteLine("File name is : " + fileName); pathPicture = fileName; return(Page()); } }