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