Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- using MySql.Data.MySqlClient;
- using System;
- using System.Collections.Generic;
- using System.Configuration;
- using System.Data;
- using System.Linq;
- using System.Text;
- using System.Threading.Tasks;
- namespace TicketManagementSystem
- {
- public class DataAccess
- {
- #region Constructor
- public DataAccess()
- {
- ConfigDB = ConfigurationManager.AppSettings.Get("dbSchema");
- ConfigServer = ConfigurationManager.AppSettings.Get("dbServer");
- ConfigDBUser = ConfigurationManager.AppSettings.Get("dbUsername");
- ConfigDBPassword = ConfigurationManager.AppSettings.Get("dbPassword");
- ConfigDBPort = "3306";
- }
- public DataAccess(string db, string server, string user, string pw)
- {
- ConfigDB = db ;
- ConfigServer = server;
- ConfigDBUser = user ;
- ConfigDBPassword = pw ;
- ConfigDBPort = "3306";
- }
- #endregion
- #region Private
- private string Server { get; set; }
- private string ConfigServer { get; set; }
- private string ConfigDBUser { get; set; }
- private string ConfigDBPassword { get; set; }
- private string ConfigDB { get; set; }
- private string ConfigDBPort { get; set; }
- #endregion
- #region Exposed Methods
- public string connectionString
- {
- get
- {
- return string.Format("SERVER={0};UID={1};PASSWORD={2};DATABASE={3};PORT={4}; respect binary flags=false;", ConfigServer, ConfigDBUser, ConfigDBPassword, ConfigDB, ConfigDBPort);
- }
- }
- public MySqlConnection Connection
- {
- get
- {
- return new MySqlConnection(connectionString);
- }
- }
- public DataTable FetchData(string sql)
- {
- return FetchData(sql, null);
- }
- public DataTable FetchData(string sql, List<MySqlParameter> param)
- {
- using (MySqlConnection conn = Connection)
- {
- MySqlCommand cmd = new MySqlCommand(sql, conn);
- if (param != null)
- {
- foreach (MySqlParameter par in param)
- {
- cmd.Parameters.AddWithValue(par.ParameterName, par.Value);
- }
- }
- cmd.Connection.Open();
- MySqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
- DataTable dt = new DataTable();
- dt.Load(rdr);
- cmd.Connection.Close();
- return dt;
- }
- }
- public void DBOps(string sql)
- {
- DBOps(sql, null);
- }
- public void DBOps(string sql, List<MySqlParameter> param)
- {
- using (MySqlConnection conn = Connection)
- {
- MySqlCommand cmd = new MySqlCommand(sql, conn);
- if (param != null)
- {
- foreach (MySqlParameter par in param)
- {
- cmd.Parameters.AddWithValue(par.ParameterName, par.Value);
- }
- }
- conn.Open();
- cmd.ExecuteNonQuery();
- cmd.Connection.Close();
- conn.Close();
- }
- }
- #endregion
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement