public List <Producto> ObtenerProducto() { dbConnector objConn = new dbConnector(); SqlConnection Conn = objConn.GetConnection; Conn.Open(); List <Producto> _listaProducto = new List <Producto>(); if (Conn.State != System.Data.ConnectionState.Open) { Conn.Open(); } SqlCommand cmd = new SqlCommand("SP_READ_PRODUCTO", Conn); cmd.CommandType = System.Data.CommandType.StoredProcedure; SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Producto prod = new Producto(); prod.ID_PRODUCTO = Convert.ToInt32(reader["ID_PRODUCTO"]); prod.NOMBRE = reader["NOMBRE"].ToString(); prod.DESCRIPCION = reader["DESCRIPCION"].ToString(); prod.PRECIO = Convert.ToInt32(reader["PRECIO"]); _listaProducto.Add(prod); } return(_listaProducto); }
private void btnSavePinConfiguration_Click(object sender, EventArgs e) { string text = cbConnectorType.Text; dbConnector connector = PromptForNewConnector(text, cbConnectorType, cbConnectorMatingType); if (connector != null) { List <ConnectorPin> pins = connectorPinList.ConnectorPins; var form = new ConnectorConfigurationForm(connector, pins); form.Configuration = cmbConnectorPinConfiguration.SelectedItem as dbConnectorConfiguration; if (DialogResult.OK == form.ShowDialog()) { dbConnectorConfiguration configuration = form.Configuration; foreach (object item in cmbConnectorPinConfiguration.Items) { if (configuration.configName.Equals(((dbConnectorConfiguration)item).configName)) { cmbConnectorPinConfiguration.Items.Remove(item); break; } } cmbConnectorPinConfiguration.SelectedIndex = cmbConnectorPinConfiguration.Items.Add(form.Configuration); } } }
public login() { InitializeComponent(); _dbConnector = new dbConnector(); _phamaPOSEntities = _dbConnector.getConn(); }
public Int32 AgregarProducto(Producto producto) { dbConnector objConn = new dbConnector(); SqlConnection Conn = objConn.GetConnection; Conn.Open(); int resultado = 0; if (Conn.State != System.Data.ConnectionState.Open) { Conn.Open(); } SqlCommand cmd = new SqlCommand("SP_CREATE_PRODUCTO", Conn); cmd.CommandType = System.Data.CommandType.StoredProcedure; // Add parameter that will be passed to stored procedure cmd.Parameters.Add(new SqlParameter("NOMBRE", producto.NOMBRE)); cmd.Parameters.Add(new SqlParameter("DESCRIPCION", producto.DESCRIPCION)); cmd.Parameters.Add(new SqlParameter("PRECIO", producto.PRECIO)); resultado = Convert.ToInt32(cmd.ExecuteScalar()); if (resultado > 0) { return(resultado); } else { return(0); } }
void Start() { anim = GetComponent <Animator>(); // Creates the controller controller = new AnimatorController(); controller.AddParameter("Go to A2", AnimatorControllerParameterType.Trigger); controller.AddParameter("Go to A1", AnimatorControllerParameterType.Trigger); controller.AddLayer("nakedLayer"); // Add StateMachines var rootStateMachine = controller.layers[0].stateMachine; //var stateMachineA = rootStateMachine.AddStateMachine("smA"); anim.runtimeAnimatorController = controller; dbcon = ScriptableObject.CreateInstance("dbConnector") as dbConnector; dbcon.LoadStuff(); pathReader = ScriptableObject.CreateInstance("PathReader") as PathReader; pathReader.Initialize(); mocapLoader = ScriptableObject.CreateInstance("MocapLoader") as MocapLoader; mocapLoader.Initialize(rootStateMachine); }
private Boolean empchecker(string fn, string ln, string mn) { var connect = new dbConnector(); using (MySqlConnection conn = connect.connector()) { string query = "SELECT * FROM employee WHERE first_name = '" + fn + "' " + "AND empID <> '" + id + "' " + "AND middle_name = '" + mn + "' " + "AND empID <> '" + id + "' " + "AND last_name = '" + ln + "' " + "AND empID <> '" + id + "';"; dt = new DataTable(); adapter = new MySqlDataAdapter(query, conn); adapter.Fill(dt); if (dt.Rows.Count > 0) { MessageBox.Show("EMPLOYEE WITH THE SAME NAME HAS ALREADY BEEN ADDED!", "ERROR!", MessageBoxButtons.OK, MessageBoxIcon.Error); return(true); } else { return(false); } } }
private void updater() { studdetails(comboBox1.Text, comboBox2.Text); var dbconnect = new dbConnector(); using (dbconnection = dbconnect.connector()) { dbconnection.Open(); foreach (string id in stdlistid) { string query2 = "UPDATE studdetails SET section = @sec, level = @lvl, department = @dept, level_dummyval = @dum, school_year = @sy, sectionid = @sectionid WHERE idstddet = @idstud;"; using (var command2 = new MySqlCommand(query2, dbconnection)) { command2.Parameters.AddWithValue("@sec", null); command2.Parameters.AddWithValue("@lvl", studdet["level"]); command2.Parameters.AddWithValue("@dept", studdet["dept"]); command2.Parameters.AddWithValue("@dum", comboBox2.Text); command2.Parameters.AddWithValue("@sy", comboBox3.Text); command2.Parameters.AddWithValue("@idstud", id); command2.Parameters.AddWithValue("@sectionid", null); command2.ExecuteNonQuery(); } string query = "UPDATE accountdetails SET fid = @fid WHERE spid = @idstud;"; using (var command = new MySqlCommand(query, dbconnection)) { command.Parameters.AddWithValue("@fid", studdet["feelevel"]); command.Parameters.AddWithValue("@idstud", id); command.ExecuteNonQuery(); } } } }
private void button1_Click(object sender, EventArgs e) { if (textBox1.Text != "" && textBox2.Text != "") { DialogResult res = MessageBox.Show("Confirm School Year Creation!", "WARNING", MessageBoxButtons.YesNo, MessageBoxIcon.Warning); if (res == DialogResult.Yes) { var dbconnect = new dbConnector(); using (dbconnection = dbconnect.connector()) { dbconnection.Open(); using (var com = new MySqlCommand("INSERT INTO schoolyear(syear, statussyear) VALUES(@syear, @stat)", dbconnection)) { com.Parameters.AddWithValue("@syear", textBox1.Text + " - " + textBox2.Text); com.Parameters.AddWithValue("@stat", "Ready"); com.ExecuteNonQuery(); } } readdata(); MessageBox.Show("School Year Created Successfully, NOTE: Newley Created S.Y. Is Still Not Open", "CAUTION", MessageBoxButtons.OK, MessageBoxIcon.Information); } } else { MessageBox.Show("PLEASE FILL ALL FIELDS", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public void loadData2() { var dbconnect = new dbConnector(); string query = "select * from studentprofile inner join studdetails on studentprofile.idstudentprofile = studdetails.idstddet WHERE studentprofile.Status = 1;"; using (dbconnection = dbconnect.connector()) { dbconnection.Open(); MySqlDataAdapter ad = new MySqlDataAdapter(query, dbconnection); DataSet data = new DataSet(); ad.Fill(data); dataGridView1.DataSource = data.Tables[0]; dataGridView1.Columns["idstudentprofile"].Visible = true; dataGridView1.Columns["FirstName"].Visible = true; dataGridView1.Columns["LastName"].Visible = true; dataGridView1.Columns["MiddleName"].Visible = true; dataGridView1.Columns["DateOfBirth"].Visible = true; dataGridView1.Columns["PlaceOfBirth"].Visible = false; dataGridView1.Columns["Sex"].Visible = true; dataGridView1.Columns["Religion"].Visible = false; dataGridView1.Columns["Nickname"].Visible = false; dataGridView1.Columns["idstuddet"].Visible = false; dataGridView1.Columns["Status"].Visible = false; dataGridView1.Columns["department"].Visible = false; dataGridView1.Columns["level"].Visible = false; dataGridView1.Columns["school_year"].Visible = true; dataGridView1.Columns["idstddet"].Visible = false; dataGridView1.Columns["section"].Visible = true; dataGridView1.Columns["image_path"].Visible = false; dataGridView1.Columns["sectionid"].Visible = false; dataGridView1.Columns["idstudentprofile"].ReadOnly = true; dataGridView1.Columns["FirstName"].ReadOnly = true; dataGridView1.Columns["LastName"].ReadOnly = true; dataGridView1.Columns["MiddleName"].ReadOnly = true; dataGridView1.Columns["DateOfBirth"].ReadOnly = true; dataGridView1.Columns["PlaceOfBirth"].ReadOnly = true; dataGridView1.Columns["Sex"].ReadOnly = true; dataGridView1.Columns["Religion"].ReadOnly = true; dataGridView1.Columns["Nickname"].ReadOnly = true; dataGridView1.Columns["idstuddet"].ReadOnly = true; dataGridView1.Columns["Status"].ReadOnly = true; dataGridView1.Columns["department"].ReadOnly = true; dataGridView1.Columns["level"].ReadOnly = true; dataGridView1.Columns["school_year"].ReadOnly = true; dataGridView1.Columns["idstddet"].ReadOnly = true; dataGridView1.Columns["section"].ReadOnly = true; dataGridView1.Columns["image_path"].ReadOnly = true; dataGridView1.Columns["sectionid"].ReadOnly = true; dataGridView1.Columns["idstudentprofile"].HeaderText = "Student ID No."; dataGridView1.Columns["FirstName"].HeaderText = "First Name"; dataGridView1.Columns["LastName"].HeaderText = "Last Name"; dataGridView1.Columns["MiddleName"].HeaderText = "Middle Name"; dataGridView1.Columns["DateOfBirth"].HeaderText = "Date of Birth"; dataGridView1.Columns["level_dummyval"].HeaderText = "Level"; } dbconnection.Close(); }
public ConnectorConfigurationForm(dbConnector connector, List <ConnectorPin> pins) { InitializeComponent(); _connector = connector; _pins = pins; Load += ConnectorConfigurationForm_Load; Saved += ConnectorConfigurationForm_Saved; }
public DataTable getDormitoryAll(String Name) { dbConnector db = new dbConnector(); SqlCommand cmd = new SqlCommand(@"SELECT * from dormitory inner join province on dormitory.id_province = province.id_province WHERE name_dormitory like '%' + @name + '%'"); cmd.Parameters.Add(new SqlParameter("name", SqlDbType.NVarChar)).Value = Name; DataTable dt = db.ExecuteDataSet(cmd, db.Connection).Tables[0]; return(dt); }
public string GetSpecificTicketmasterVenueEventSummary(string venue) { string qry = @"with ve as ( SELECT [venue_id] , [genre_name] , [name] as [Event] , [priceRanges_max] as [maxTicketCost] , [priceRanges_min] as [minTicketCost] , CAST ( [dates_start_dateTime] AS DATE ) as [Event Date] FROM tblTicketmasterVenueEvent ve -- filter to only include results from nost recent scrape WHERE CAST(scrapeDate AS DATE) IN ( SELECT TOP (1) CAST(scrapeDate AS DATE) from [tblTicketmasterVenueEvent] order by CAST(scrapeDate AS DATE) desc ) ) SELECT ve.[Event] as [Event Name] , ve.[Event Date] -- , ve.[genre_name] as [Genre] , ve.[maxTicketCost] as [Min Cost] , ve.[minTicketCost] as [Max Cost] FROM ve LEFT JOIN tblTicketmasterVenue v ON v.id = ve.venue_id WHERE ve.genre_name is not null AND [name] = '" + venue + @"' GROUP BY ve.[Event] , ve.[Event Date] , ve.[genre_name] , ve.[maxTicketCost] , ve.[minTicketCost] ORDER BY ve.[Event Date] , ve.[Event] FOR JSON PATH"; dbConnector db = new dbConnector(); string result = db.getQueryResultAsJsonString(qry); return(result); }
private void sectionupdater(string xy) { var dbconnect = new dbConnector(); using (dbconnection = dbconnect.connector()) { dbconnection.Open(); string query2 = "UPDATE studdetails SET section = @sec WHERE idstddet = @iddd;"; using (var command2 = new MySqlCommand(query2, dbconnection)) { command2.Parameters.AddWithValue("@sec", textBox1.Text); command2.Parameters.AddWithValue("@iddd", xy); command2.ExecuteNonQuery(); } } }
public void checkpayer() { var dbconnect = new dbConnector(); using (dbconnection = dbconnect.connector()) { dbconnection.Open(); string queryy = "UPDATE accountdetails SET paid_amount = @paidamount WHERE adid = @ayd;"; using (var command2 = new MySqlCommand(queryy, dbconnection)) { command2.Parameters.AddWithValue("@ayd", dic["adid"]); command2.Parameters.AddWithValue("@paidamount", paidforaccount(decimal.Parse(txtAmount.Text.TrimStart('₱')))); command2.ExecuteNonQuery(); } } }
public string GetSpecificTicketmasterVenueSummary(string venue) { string qry = @" with ve as ( select [venue_id] , [genre_name] , Count(1) as numberOfEvents , MAX([priceRanges_max]) as maxTicketCost , MIN([priceRanges_min]) as minTicketCost , AVG(CAST([priceRanges_max] AS NUMERIC)) as AVGmaxTicketCost , AVG(CAST([priceRanges_min] AS NUMERIC)) as AVGminTicketCost FROM tblTicketmasterVenueEvent WHERE venue_id IN ( select id from tblTicketmasterVenue where [name] = '" + venue + @"' ) AND CAST(scrapeDate AS DATE) IN (-- filter to only include results from nost recent scrape SELECT TOP (1) CAST(scrapeDate AS DATE) FROM [tblTicketmasterVenueEvent] ORDER BY CAST(scrapeDate AS DATE) desc ) group by [venue_id] , [genre_name] ) SELECT v.[name] [Name] , ve.[genre_name] [Genre] , ve.[numberOfEvents] [Event Count] , ve.maxTicketCost [Min Cost] , ve.minTicketCost [Max Cost] , ve.AVGminTicketCost [Avg Min Cost] , ve.AVGmaxTicketCost [Avg Max Cost] FROM ve LEFT JOIN tblTicketmasterVenue v ON v.id = ve.venue_id WHERE ve.genre_name is not null ORDER BY ve.[venue_id] , ve.[genre_name] FOR JSON PATH"; dbConnector db = new dbConnector(); string result = db.getQueryResultAsJsonString(qry); return(result); //return Ok(result); }
private string SerialMaker() { Int32 a; string date = DateTime.Now.ToString("yyyyMMdd"); string query2 = "SELECT COUNT(*) FROM payment"; var dbconnect = new dbConnector(); using (dbconnection = dbconnect.connector()) { using (var command2 = new MySqlCommand(query2, dbconnection)) { dbconnection.Open(); a = Convert.ToInt32(command2.ExecuteScalar().ToString()); } } return(date + a.ToString("10000")); }
public List <MasterTable> GetMasterTableData() { dbConnector _dbconnection = new dbConnector(); SqlConnection con = _dbconnection.GetConnection; con.Open(); try { List <MasterTable> _mat = new List <MasterTable>(); if (con.State != ConnectionState.Open) { con.Open(); } SqlCommand _cmd = new SqlCommand("select * from Usp_GetMasterData", con); _cmd.CommandType = CommandType.Text; SqlDataReader READER = _cmd.ExecuteReader(); while (READER.Read()) { MasterTable _mastertab = new MasterTable(); _mastertab.Master_Email = Convert.ToString(READER["Master_Email"]); _mastertab.PassWord = Convert.ToString(READER["PassWord"]); _mastertab.Master_Token = Convert.ToString(READER["Master_Token"]); _mastertab.Master_Name = Convert.ToString(READER["Master_Name"]); _mastertab.Id = Convert.ToInt32(READER["Id"]); _mat.Add(_mastertab); } return(_mat); } catch (Exception) { throw; } finally { if (con != null) { if (con.State == ConnectionState.Open) { con.Close(); } } } }
public void payQuery(IDictionary <string, string> dic1) { IDictionary <string, string> d = dic1; var dbconnect = new dbConnector(); using (dbconnection = dbconnect.connector()) { dbconnection.Open(); string query2 = "INSERT INTO payment" + "(payment_type, cheque_no, paymentStatus, amount_paid, date_paid, eid, adid, transaction_no, additional_details, payment_to, syear) " + "VALUES(@pt, @cqno, @pstatus, @apaid, @dpaid, @eid, @adid, @tansaction_no, @adet, @pto, @sy);"; using (var command2 = new MySqlCommand(query2, dbconnection)) { if (d["ptype"] == "Cheque") { command2.Parameters.AddWithValue("@pt", 2); command2.Parameters.AddWithValue("@cqno", d["cno"]); command2.Parameters.AddWithValue("@pstatus", 2); } else { command2.Parameters.AddWithValue("@pt", 1); command2.Parameters.AddWithValue("@cqno", null); command2.Parameters.AddWithValue("@pstatus", 1); } var a = d["adue"]; command2.Parameters.AddWithValue("@apaid", a); command2.Parameters.AddWithValue("@dpaid", d["pdate"]); command2.Parameters.AddWithValue("@eid", eid); command2.Parameters.AddWithValue("@adid", dic["adid"]); command2.Parameters.AddWithValue("@tansaction_no", d["tno"]); command2.Parameters.AddWithValue("@pto", d["pto"]); command2.Parameters.AddWithValue("@adet", d["addet"]); command2.Parameters.AddWithValue("@sy", d["sy"]); command2.ExecuteNonQuery(); } } if (d["ptype"] == "Cash") { checkpayer(); } }
public List <State> GetStateNameById(int cntId) { dbConnector _dbConnectors = new dbConnector(); SqlConnection con = _dbConnectors.GetConnection; con.Open(); try { List <State> _ListStates = new List <State>(); if (con.State != ConnectionState.Open) { con.Open(); } SqlCommand _command = new SqlCommand("USP_Get_stateName_By_ID", con); _command.CommandType = CommandType.StoredProcedure; _command.Parameters.AddWithValue("@CntId", cntId); SqlDataReader _Reader = _command.ExecuteReader(); while (_Reader.Read()) { State _states = new State(); _states.Sts_Id = Convert.ToInt32(_Reader["Sts_Id"]); _states.Sts_Name = Convert.ToString(_Reader["Sts_Name"]); _states.Sts_Cnt_Id = Convert.ToInt32(_Reader["Sts_Cnt_Id"]); _ListStates.Add(_states); } return(_ListStates); } catch (Exception ex) { throw ex; } finally { if (con != null) { if (con.State == ConnectionState.Open) { con.Close(); } } } throw new NotImplementedException(); }
private void creator2() { var dbconnect = new dbConnector(); using (dbconnection = dbconnect.connector()) { dbconnection.Open(); string query2 = "UPDATE sectionnames SET section_name = @section_name, department = @department, gradelevel = @gradelevel WHERE idsnames = @ids;"; using (var command2 = new MySqlCommand(query2, dbconnection)) { command2.Parameters.AddWithValue("@section_name", textBox1.Text); command2.Parameters.AddWithValue("@gradelevel", comboBox2.Text); var aa = comboBox1.SelectedIndex + 1; command2.Parameters.AddWithValue("@department", aa.ToString()); command2.Parameters.AddWithValue("@ids", x[0]); command2.ExecuteNonQuery(); } } }
public List <Pedido.PedidoGet> ObtenerPedidoId(int id) { dbConnector objConn = new dbConnector(); SqlConnection Conn = objConn.GetConnection; Conn.Open(); List <Pedido.PedidoGet> _listaPedido = new List <Pedido.PedidoGet>(); if (Conn.State != System.Data.ConnectionState.Open) { Conn.Open(); } SqlCommand cmd = new SqlCommand("SP_READ_PEDIDO_X_ID", Conn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("ID_PEDIDO", id)); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Pedido.PedidoGet ped = new Pedido.PedidoGet(); ped.ID_PEDIDO = Convert.ToInt32(reader["ID_PEDIDO"]); ped.ID_CLIENTE = Convert.ToInt32(reader["ID_CLIENTE"]); ped.IDENTIFICADOR = reader["IDENTIFICADOR"].ToString(); ped.CLIENTE_NOMBRE = reader["CLIENTE_NOMBRE"].ToString(); ped.ESTADO_PEDIDO = reader["ESTADO_PEDIDO"].ToString(); ped.VALOR_TOTAL = Convert.ToInt32(reader["VALOR_TOTAL"]); ped.COMUNA = reader["COMUNA"].ToString(); ped.CALLE = reader["CALLE"].ToString(); ped.NRO_DOMICILIO = reader["NRO_DOMICILIO"].ToString(); ped.NRO_DEPTO = reader["NRO_DEPTO"].ToString(); ped.COMENTARIO = reader["COMENTARIO"].ToString(); _listaPedido.Add(ped); } return(_listaPedido); }
//private MySqlConnection dbconnection; private void creator() { var dbconnect = new dbConnector(); using (dbconnection = dbconnect.connector()) { dbconnection.Open(); string query2 = "INSERT INTO sectionnames(section_name, department, gradelevel) VALUES(@section_name, @department, @gradelevel);"; using (var command2 = new MySqlCommand(query2, dbconnection)) { command2.Parameters.AddWithValue("@section_name", textBox1.Text); command2.Parameters.AddWithValue("@gradelevel", comboBox2.Text); var x = comboBox1.SelectedIndex + 1; command2.Parameters.AddWithValue("@department", x.ToString()); command2.ExecuteNonQuery(); } } }
public int InsertData(MasterTable _master) { dbConnector _dbconnector = new dbConnector(); SqlConnection con = _dbconnector.GetConnection; con.Open(); try { if (con.State != ConnectionState.Open) { con.Open(); } var _key = EncryptionLibrary.EncryptText(_master.PassWord); SqlCommand _commd = new SqlCommand("Usp_InsertMaster", con); _commd.CommandType = CommandType.StoredProcedure; _commd.Parameters.AddWithValue("@UserID", 1); _commd.Parameters.AddWithValue("@Master_Name", _master.Master_Name); _commd.Parameters.AddWithValue("@Master_Email", _master.Master_Email); _commd.Parameters.AddWithValue("@PassWord", _key); _commd.Parameters.AddWithValue("@ImageId", _master.ImageId); _commd.Parameters.AddWithValue("@ContryId", _master.ContryId); _commd.Parameters.AddWithValue("@StateId", _master.StateId); _commd.Parameters.AddWithValue("@CityId", _master.CityId); int _finalresult = _commd.ExecuteNonQuery(); // int _finalresult =Convert.ToInt32( _commd.ExecuteScalar()); return(_finalresult); } catch (Exception ex) { throw ex; } finally { if (con != null) { if (con.State == ConnectionState.Open) { con.Close(); } } } }
private dbConnector PromptForNewConnector(String type, ComboBox cbPrimary, ComboBox cbSecondary) { dbConnector conn = null; if (type != null && cbPrimary.SelectedIndex == -1) { var dao = new EquipmentDAO(); conn = dao.getConnector(type); if (conn == null) { if (DialogResult.Yes == MessageBox.Show( string.Format( "Connector type \"{0}\" does not exist in the Connector Database, would you like to add it?", type), @"Add Connector", MessageBoxButtons.YesNo, MessageBoxIcon.Question)) { conn = new dbConnector(); conn.DataState = BASEBean.eDataState.DS_ADD; conn.connectorType = type; conn.ID = Guid.NewGuid(); conn.IncludeKeyOnInsert = true; conn.pinCount = string.IsNullOrWhiteSpace(edtConnectorPinCount.Text) ? 0 : int.Parse(edtConnectorPinCount.Text); conn.save(); } } if (conn != null) { cbPrimary.SelectedIndex = cbPrimary.Items.Add(conn); cbSecondary.Items.Add(conn); } } else { conn = cbPrimary.SelectedItem as dbConnector; } return(conn); }
public List <City> GetCityById(int StateId) { dbConnector _dbConnectors = new dbConnector(); SqlConnection conn = _dbConnectors.GetConnection; conn.Open(); try { List <City> _citys = new List <City>(); if (conn.State != ConnectionState.Open) { conn.Open(); } SqlCommand _command = new SqlCommand("Usp_GetCityList", conn); _command.CommandType = CommandType.StoredProcedure; _command.Parameters.AddWithValue("@State_Id", StateId); SqlDataReader _Reader = _command.ExecuteReader(); while (_Reader.Read()) { City _ObjCity = new City(); _ObjCity.City_Id = Convert.ToInt32(_Reader["City_Id"]); _ObjCity.City_Name = Convert.ToString(_Reader["City_Name"]); _ObjCity.City_Sts_Id = Convert.ToInt32(_Reader["City_Sts_Id"]); _citys.Add(_ObjCity); } return(_citys); } catch (Exception ex) { throw ex; } finally { if (conn != null) { if (conn.State == ConnectionState.Open) { conn.Close(); } } } }
/// <summary> /// Getting Country List /// </summary> /// <returns></returns> // SqlConnectionImplemntation _dbConnectors = new SqlConnectionImplemntation(); public List <Country> GetCountry() { dbConnector _dbConnectors = new dbConnector(); using (SqlConnection Conn = _dbConnectors.GetConnection) { Conn.Open(); try { List <Country> _listCustomer = new List <Country>(); if (Conn.State != ConnectionState.Open) { Conn.Open(); } SqlCommand objCommand = new SqlCommand("Usp_GetCountryList", Conn); objCommand.CommandType = CommandType.StoredProcedure; SqlDataReader _Reader = objCommand.ExecuteReader(); while (_Reader.Read()) { Country objCust = new Country(); objCust.Cnt_Id = Convert.ToInt32(_Reader["Cnt_Id"]); objCust.Cnt_Name = Convert.ToString(_Reader["Cnt_Name"]); _listCustomer.Add(objCust); } return(_listCustomer); } catch (Exception ex) { throw ex; } finally { if (Conn != null) { if (Conn.State == ConnectionState.Open) { Conn.Close(); //Conn.Dispose(); } } } } }
public string GetSpecificStubhubVenueSummary(string venue) { string qry = @" SELECT ve.[name] [Event Name] , eventDate [Event Date] , [minListPrice] [Min Cost] , [maxListPrice] [Max Cost] FROM [tblStubhubVenueEvent] ve LEFT JOIN [tblStubhubVenue] v on ve.venue_id = v.id WHERE eventDate is not null AND v.[name] = '" + venue + @"' order by [eventDate] FOR JSON PATH"; dbConnector db = new dbConnector(); string result = db.getQueryResultAsJsonString(qry); return(result); //return Ok(result); }
private void btnclose_Click(object sender, EventArgs e) { DialogResult res = MessageBox.Show("School Year Will Be Closed!, Proceed?", "Warning", MessageBoxButtons.YesNo, MessageBoxIcon.Warning); if (res == DialogResult.Yes) { var dbconnect = new dbConnector(); using (dbconnection = dbconnect.connector()) { dbconnection.Open(); using (var com = new MySqlCommand("UPDATE schoolyear SET statussyear = @stat WHERE idSchoolYear = @ayd;", dbconnection)) { com.Parameters.AddWithValue("@ayd", idsyear); com.Parameters.AddWithValue("@stat", "Closed"); com.ExecuteNonQuery(); } } readdata(); MessageBox.Show("School Year Opened, Current School Year Will Be Reset", "CAUTION", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
private Boolean empcheck(string fn, string ln, string mn) { var connect = new dbConnector(); using (MySqlConnection conn = connect.connector()) { string query = "SELECT * FROM employee WHERE first_name = '" + fn + "' AND last_name = '" + ln + "' AND middle_name = '" + mn + "';"; dt = new DataTable(); adapter = new MySqlDataAdapter(query, conn); adapter.Fill(dt); if (dt.Rows.Count > 0) { MessageBox.Show("An Employee Has Already Been Added With The Same Name!", "CAUTION!", MessageBoxButtons.OK, MessageBoxIcon.Information); return(true); } else { return(false); } } }
private Boolean usercheck(string username) { var connect = new dbConnector(); using (MySqlConnection conn = connect.connector()) { string query = "SELECT * FROM usertable WHERE username = '******' AND userID <> '" + userID + "';"; dt = new DataTable(); adapter = new MySqlDataAdapter(query, conn); adapter.Fill(dt); if (dt.Rows.Count > 0) { MessageBox.Show("A User Has Already Been Added With The Same Username!", "CAUTION!", MessageBoxButtons.OK, MessageBoxIcon.Information); return(true); } else { return(false); } } }