string getClietnInfo(string login, string password) { OracleConnection conn = DBUtils.GetDBConnection(); try { conn.Open(); // MessageBox.Show("Open1"); OracleCommand cmd = new OracleCommand(); cmd.Connection = conn; cmd.CommandText = "System.cwpack1.checkClientAccount"; cmd.CommandType = CommandType.StoredProcedure; // Добавить параметр @p_Emp_Id и настроить его значение = 100. cmd.Parameters.Add("login", OracleDbType.NVarchar2).Value = login; cmd.Parameters.Add("pass", OracleDbType.NVarchar2).Value = password; // Зарегистрировать параметр @v_Emp_No как OUTPUT. cmd.Parameters.Add("results", OracleDbType.Int64).Direction = ParameterDirection.Output; // Выполнить процедуру. cmd.ExecuteNonQuery(); string ct = cmd.Parameters["results"].Value.ToString(); if (int.Parse(ct) > 0) { return("consists"); } else { return("not consists"); } } catch (Exception ex) { MessageBox.Show("Error: " + ex); MessageBox.Show(ex.StackTrace); } finally { conn.Close(); conn.Dispose(); } return("not consists"); }
public void insertEmployeeToCombobox() { OracleConnection conn = DBUtils.GetDBConnection(); try { conn.Open(); OracleCommand cmd = new OracleCommand(); cmd.Connection = conn; cmd.CommandText = "System.cwpack1.getNameAndIdEmp"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("p_cursor", OracleDbType.RefCursor).Direction = ParameterDirection.Output; // Выполнить процедуру. OracleDataReader objReader = cmd.ExecuteReader(); // prvPrintReader(objReader); while (objReader.Read()) { Employee emp = new Employee() { Tempid = objReader.GetValue(0).ToString(), fio = objReader.GetValue(1).ToString() }; employeesList.Add(emp); } objReader.Close(); } catch (Exception ex) { MessageBox.Show("Error: " + ex); MessageBox.Show(ex.StackTrace); } finally { conn.Close(); conn.Dispose(); } }
public int getEquipmentId() { int result = 0; OracleConnection conn = DBUtils.GetDBConnection(); try { conn.Open(); // MessageBox.Show("Open1"); OracleCommand cmd = new OracleCommand(); cmd.Connection = conn; cmd.CommandText = "System.cwpack1.getEpuipmentIdForOrder"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("results", OracleDbType.Int64).Direction = ParameterDirection.Output; // Выполнить процедуру. cmd.ExecuteNonQuery(); string ct = cmd.Parameters["results"].Value.ToString(); result = int.Parse(ct.ToString()); } catch (Exception ex) { MessageBox.Show("Error: " + ex); MessageBox.Show(ex.StackTrace); } finally { conn.Close(); conn.Dispose(); } return(result); }
public void getClienIdAndName(string login, string pass) { OracleConnection conn = DBUtils.GetDBConnection(); try { conn.Open(); // MessageBox.Show("Open1"); OracleCommand cmd = new OracleCommand(); cmd.Connection = conn; cmd.CommandText = "System.cwpack1.getClienIdAndName"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("Login", OracleDbType.NVarchar2).Value = Login; cmd.Parameters.Add("Passw", OracleDbType.NVarchar2).Value = Password; cmd.Parameters.Add("idd", OracleDbType.Int64).Direction = ParameterDirection.Output; cmd.Parameters.Add("fio", OracleDbType.NVarchar2, 50).Direction = ParameterDirection.Output; // Выполнить процедуру. cmd.ExecuteNonQuery(); string name = cmd.Parameters["idd"].Value.ToString(); string id = cmd.Parameters["fio"].Value.ToString(); Name = id.ToString(); UserLabel.Text = id.ToString(); Id = int.Parse(name); } catch (Exception ex) { MessageBox.Show("Error: " + ex); MessageBox.Show(ex.StackTrace); } finally { conn.Close(); conn.Dispose(); } }