public student(string line) { var split = line.Split(","); if (split.Length < 9) { throw new NotEnoughFieldsException("Za mało pól exception"); } foreach (var s in split) { if (s.Trim() == string.Empty) { throw new EmptyFieldsException("Puste pola Exception"); } } firstname = split[0]; lastname = split[1]; studia = new Studia { nazwa = split[2], tryb = split[3] }; indexNumber = $"s{IntegerType.FromObject(split[4])}"; birthday = split[5]; email = split[6]; mothersName = split[7]; fathersName = split[8]; }
protected override void Paint(Graphics g, Rectangle bounds, CurrencyManager source, int rowNum, Brush backBrush, Brush foreBrush, bool alignToRight) { g.FillRectangle(backBrush, bounds); Rectangle controlBounds = this.GetControlBounds(bounds); if (this.m_stretchToFit) { controlBounds.Width = bounds.Width - (this.Padding.Left + this.Padding.Right); controlBounds.X = bounds.X + this.Padding.Left; } Rectangle rect = new Rectangle(controlBounds.X + 2, controlBounds.Y + 2, controlBounds.Width - 3, controlBounds.Height - 3); int width = rect.Width; double num = ((double)rect.Width) / 100.0; rect.Width = (int)Math.Round((double)(IntegerType.FromObject(this.GetColumnValueAtRow(source, rowNum)) * num)); if (rect.Width > width) { rect.Width = width; } using (Pen pen = new Pen(new SolidBrush(Color.Black))) { g.DrawRectangle(pen, controlBounds); } using (SolidBrush brush = new SolidBrush(Color.Red)) { g.FillRectangle(brush, rect); } }
private int ExisteClientePortatil() { this.Cursor = Cursors.WaitCursor; int num1 = 0; try { SqlCommand sqlCommand = new SqlCommand("spPTLClienteZonaEconomica", Globals.GetInstance.cnSigamet); sqlCommand.Parameters.Add("@Configuracion", SqlDbType.SmallInt).Value = (object)1; sqlCommand.Parameters.Add("@Cliente", SqlDbType.Int).Value = (object)this._Cliente; sqlCommand.Parameters.Add("@ZonaEconomica", SqlDbType.TinyInt).Value = (object)((ComboBase)this.cboZonaEconomica).Identificador; sqlCommand.Parameters.Add("@Ruta", SqlDbType.SmallInt).Value = (object)((ComboBase)this.cboRuta).Identificador; sqlCommand.Parameters.Add("@ClientePortatil", SqlDbType.Int).Value = (object)IntegerType.FromString(((TextBox)this.txtClientePortatil).Text); sqlCommand.CommandType = CommandType.StoredProcedure; Globals.GetInstance.cnSigamet.Open(); SqlDataReader sqlDataReader = sqlCommand.ExecuteReader(CommandBehavior.CloseConnection); while (sqlDataReader.Read()) { num1 = IntegerType.FromObject(sqlDataReader[1]); } Globals.GetInstance.cnSigamet.Close(); } catch (Exception ex) { ProjectData.SetProjectError(ex); int num2 = (int)MessageBox.Show(ex.Message, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Hand); ProjectData.ClearProjectError(); } this.Cursor = Cursors.Default; return(num1); }
public Student GetStudent(string indexNumber) { using var connection = new SqlConnection(connectionString); using var command = new SqlCommand { Connection = connection, CommandText = "SELECT * FROM Student WHERE IndexNumber = @indexNumber" }; command.Parameters.AddWithValue("indexNumber", indexNumber); connection.Open(); var dataReader = command.ExecuteReader(); if (dataReader.Read()) { var student = new Student { IndexNumber = dataReader["IndexNumber"].ToString(), FirstName = dataReader["FirstName"].ToString(), LastName = dataReader["LastName"].ToString(), BirthDate = dataReader["BirthDate"].ToString(), IdEnrollment = IntegerType.FromObject(dataReader["IdEnrollment"]) }; return(student); } return(null); }
public void RegistrayModifica(int Secuencia, int Cliente, Decimal Factor, DateTime FInicio, DateTime FFinal, string Status, bool ResguardoComision, string Usuario, bool ResguardoPorTanque, Decimal Cuota) { try { this.cnSigamet = new SqlConnection(Globals.GetInstance._CadenaConexion); SqlCommand sqlCommand = new SqlCommand("spPTLClienteFactor", this.cnSigamet); sqlCommand.Parameters.Add("@Configuracion", SqlDbType.SmallInt).Value = (object)this.Configuracion; sqlCommand.Parameters.Add("@Cliente", SqlDbType.Int).Value = (object)Cliente; sqlCommand.Parameters.Add("@Secuencia", SqlDbType.Int).Value = (object)Secuencia; sqlCommand.Parameters.Add("@Factor", SqlDbType.Decimal).Value = (object)Decimal.Round(Factor, 6); sqlCommand.Parameters.Add("@FInicio", SqlDbType.DateTime).Value = (object)FInicio; sqlCommand.Parameters.Add("@FFinal", SqlDbType.DateTime).Value = (object)FFinal; sqlCommand.Parameters.Add("@Status", SqlDbType.VarChar).Value = (object)Status; sqlCommand.Parameters.Add("@ResguardoComision", SqlDbType.Bit).Value = (ResguardoComision == true) ? 1 : 0; sqlCommand.Parameters.Add("@Usuario", SqlDbType.VarChar).Value = (object)Usuario; sqlCommand.Parameters.Add("@ResguardoPorTanque", SqlDbType.Bit).Value = (ResguardoPorTanque == true) ? 1 : 0; sqlCommand.Parameters.Add("@Cuota", SqlDbType.Money).Value = (object)Cuota; sqlCommand.CommandType = CommandType.StoredProcedure; this.cnSigamet.Open(); this.drReader = sqlCommand.ExecuteReader(CommandBehavior.CloseConnection); while (this.drReader.Read()) { this._Factor = IntegerType.FromObject(this.drReader[0]); } this.cnSigamet.Close(); } catch (Exception ex) { ProjectData.SetProjectError(ex); Exception exception = ex; EventLog.WriteEntry("Consulta cliente factor" + exception.Source, exception.Message, EventLogEntryType.Error); int num = (int)MessageBox.Show(exception.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Hand); ProjectData.ClearProjectError(); } }
public cClienteDeduccion(int _Configuracion, int Cliente, int Secuencia, int DeduccionPrestacion, Decimal Monto, DateTime FDeduccion, string Usuario) { try { this.cnSigamet = new SqlConnection(Globals.GetInstance._CadenaConexion); SqlCommand sqlCommand = new SqlCommand("spPTLClienteDeduccion", this.cnSigamet); sqlCommand.Parameters.Add("@Configuracion", SqlDbType.SmallInt).Value = (object)_Configuracion; sqlCommand.Parameters.Add("@Cliente", SqlDbType.Int).Value = (object)Cliente; sqlCommand.Parameters.Add("@Secuencia", SqlDbType.Int).Value = (object)Secuencia; sqlCommand.Parameters.Add("@DeduccionPrestacion", SqlDbType.Int).Value = (object)DeduccionPrestacion; sqlCommand.Parameters.Add("@Monto", SqlDbType.Money).Value = (object)Monto; sqlCommand.Parameters.Add("@FDeduccion", SqlDbType.DateTime).Value = (object)FDeduccion; sqlCommand.Parameters.Add("@Usuario", SqlDbType.VarChar).Value = (object)Usuario; sqlCommand.CommandType = CommandType.StoredProcedure; this.cnSigamet.Open(); this.drReader = sqlCommand.ExecuteReader(CommandBehavior.CloseConnection); while (this.drReader.Read()) { this._Cliente = IntegerType.FromObject(this.drReader[0]); this._Secuencia = IntegerType.FromObject(this.drReader[1]); this._Status = StringType.FromObject(this.drReader[2]); } this.cnSigamet.Close(); } catch (Exception ex) { ProjectData.SetProjectError(ex); Exception exception = ex; EventLog.WriteEntry("Consulta cliente factor" + exception.Source, exception.Message, EventLogEntryType.Error); int num = (int)MessageBox.Show(exception.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Hand); ProjectData.ClearProjectError(); } }
public Enrollment GetStudentEnrollment(string indexNumber) { using var connection = SqlConnection; using var command = new SqlCommand { Connection = connection, CommandText = "SELECT Enrollment.IdEnrollment, Semester, StartDate, Name " + "FROM Student " + "INNER JOIN Enrollment ON Student.IdEnrollment = Enrollment.IdEnrollment " + "INNER JOIN Studies ON Enrollment.IdStudy = Studies.IdStudy " + "WHERE IndexNumber = @indexNumber" }; command.Parameters.AddWithValue("indexNumber", indexNumber); connection.Open(); using var dataReader = command.ExecuteReader(); if (dataReader.Read()) { var enrollment = new Enrollment { IdEnrollment = IntegerType.FromObject(dataReader["IdEnrollment"]), Semester = IntegerType.FromObject(dataReader["Semester"]), StartDate = DateTime.Parse(dataReader["StartDate"].ToString()), //Name = dataReader["Name"].ToString(), }; return(enrollment); } return(new Enrollment()); }
public void Borra(int ClienteFactor) { try { this.cnSigamet = new SqlConnection(Globals.GetInstance._CadenaConexion); SqlCommand sqlCommand = new SqlCommand("spPTLClienteFactorProducto", this.cnSigamet); sqlCommand.Parameters.Add("@Configuracion", SqlDbType.SmallInt).Value = (object)2; sqlCommand.Parameters.Add("@ClienteFactor", SqlDbType.Int).Value = (object)ClienteFactor; sqlCommand.Parameters.Add("@Producto", SqlDbType.SmallInt).Value = (object)0; sqlCommand.Parameters.Add("@Descuento", SqlDbType.Decimal).Value = (object)0; sqlCommand.CommandType = CommandType.StoredProcedure; this.cnSigamet.Open(); this.drReader = sqlCommand.ExecuteReader(CommandBehavior.CloseConnection); while (this.drReader.Read()) { ClienteFactor = IntegerType.FromObject(this.drReader[0]); } this.cnSigamet.Close(); } catch (Exception ex) { ProjectData.SetProjectError(ex); Exception exception = ex; EventLog.WriteEntry("Consulta cliente factor" + exception.Source, exception.Message, EventLogEntryType.Error); int num = (int)MessageBox.Show(exception.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Hand); ProjectData.ClearProjectError(); } }
public Enrollment SemesterPromotion(int idStudy, int semester) { using var connection = SqlConnection; using var command = new SqlCommand { Connection = connection, CommandText = "sp_SemesterPromotion", CommandType = CommandType.StoredProcedure }; command.Parameters.AddWithValue("id_study", idStudy); command.Parameters.AddWithValue("semester", semester); connection.Open(); using var dataReader = command.ExecuteReader(); if (dataReader.Read()) { var enrollment = new Enrollment { IdEnrollment = IntegerType.FromObject(dataReader["IdEnrollment"]), Semester = IntegerType.FromObject(dataReader["Semester"]), StartDate = dataReader["StartDate"].ToString(), IdStudy = IntegerType.FromObject(dataReader["IdStudy"]) }; return(enrollment); } return(null); }
public IEnumerable <Student> GetStudents(string orderBy) { if (orderBy == null) { orderBy = "IndexNumber"; } List <Student> students = new List <Student>(); using var connection = new SqlConnection(connectionString); using var command = new SqlCommand() { Connection = connection, CommandText = $"SELECT * FROM Student ORDER BY {orderBy}" }; connection.Open(); var dataReader = command.ExecuteReader(); while (dataReader.Read()) { var student = new Student { IndexNumber = dataReader["IndexNumber"].ToString(), FirstName = dataReader["FirstName"].ToString(), LastName = dataReader["LastName"].ToString(), BirthDate = dataReader["BirthDate"].ToString(), IdEnrollment = IntegerType.FromObject(dataReader["IdEnrollment"]) }; students.Add(student); } return(students); }
public Student GetStudent(string indexNumber, string password) { using var connection = SqlConnection; using var command = new SqlCommand { Connection = connection, CommandText = "SELECT * FROM Student WHERE IndexNumber = @indexNumber AND Password = @password" }; command.Parameters.AddWithValue("indexNumber", indexNumber); command.Parameters.AddWithValue("password", password); connection.Open(); using var dataReader = command.ExecuteReader(); if (dataReader.Read()) { var student = new Student { IndexNumber = dataReader["IndexNumber"].ToString(), FirstName = dataReader["FirstName"].ToString(), LastName = dataReader["LastName"].ToString(), BirthDate = DateTime.Parse(dataReader["BirthDate"].ToString()), IdEnrollment = IntegerType.FromObject(dataReader["IdEnrollment"]), Password = dataReader["Password"].ToString(), Salt = dataReader["Salt"].ToString() }; return(student); } return(null); }
private void CargarDatosPrestacion() { ClienteFactor.cClientePrestacion clientePrestacion = new ClienteFactor.cClientePrestacion(0); clientePrestacion.Consulta(this._Cliente); while (clientePrestacion.drReader.Read()) { this.dtpFInicio.Value = DateType.FromObject(clientePrestacion.drReader[3]); this.cboStatus.SelectedIndex = 0; this.DesplegarDatos(IntegerType.FromObject(clientePrestacion.drReader[5]), StringType.FromObject(clientePrestacion.drReader[7]), DecimalType.FromObject(clientePrestacion.drReader[6])); } }
static Enrollment enrollmentMapper(SqlDataReader reader) { var enrollment = new Enrollment { IdEnrollment = IntegerType.FromObject(reader["IdEnrollment"]), Semester = IntegerType.FromObject(reader["Semester"]), StartDate = reader["StartDate"].ToString(), IdStudy = IntegerType.FromObject(reader["IdStudy"]) }; reader.Close(); return(enrollment); }
public void setup_generate_random1(object setup_low_rand, object setup_high_rand) { setup_rand_finished = false; while (!setup_rand_finished) { VBMath.Randomize(); setup_random1 = IntegerType.FromObject(Conversion.Int(ObjectType.AddObj(ObjectType.MulObj(ObjectType.AddObj(setup_high_rand, 1), VBMath.Rnd()), 0))); if (!BooleanType.FromObject(ObjectType.BitAndObj(ObjectType.ObjTst(setup_random1, setup_low_rand, false) >= 0, ObjectType.ObjTst(setup_random1, setup_high_rand, false) <= 0))) { continue; } setup_rand_finished = true; } }
public Enrollment EnrollStudent(EnrollStudentRequest request) { using (var db = new s18838Context()) { if (request.Studies == null || request.BirthDate == null || request.FirstName == null || request.IndexNumber == null || request.LastName == null) { throw new Exception(); } using (var transaction = db.Database.BeginTransaction()) { var study = GetStudies(request.Studies); if (study == null) { transaction.Rollback(); throw new Exception(); } Enrollment enrollment = GetLastEnrollmentForStudy(study.IdStudy); if (enrollment == null) { enrollment = new Enrollment() { Semester = 1, IdStudy = study.IdStudy, StartDate = DateType.FromString(DateTime.Now.ToString("MM.dd.yyyy")) }; SaveEnrollment(db, enrollment); } if (CheckIfStudentExists(request.IndexNumber)) { transaction.Rollback(); throw new Exception(); } var student = new Student() { IndexNumber = request.IndexNumber, FirstName = request.FirstName, LastName = request.LastName, BirthDate = DateType.FromString(request.BirthDate), IdEnrollment = IntegerType.FromObject(enrollment.IdEnrollment) }; SaveStudent(db, student); transaction.Commit(); return(enrollment); } } }
public void RegistrarAbonos(int Año, int AlmacenGas, int MovimientoAlmacen, DateTime FVenta, string Usuario) { int num1 = 0; int num2 = checked (this._Registros - 1); int index = num1; while (index <= num2) { Decimal num3 = DecimalType.FromObject(this.dgDatos[index, 2]); int num4 = IntegerType.FromObject(this.dgDatos[index, 0]); int num5 = IntegerType.FromObject(this.dgDatos[index, 1]); new Consulta.cCobroComisionista().Actualizar((short)1, 0, Año, this._Cliente, num3, AlmacenGas, MovimientoAlmacen, FVenta, Usuario, 0, "", num4, num5, (short)0, DateAndTime.Now); checked { ++index; } } }
private void RegistrarInformacion() { ClienteFactor.cClientePrestacion clientePrestacion = new ClienteFactor.cClientePrestacion(0); clientePrestacion.Borra(this._Cliente); int num1 = 0; int num2 = checked (this.dtDatos.Rows.Count - 1); int index = num1; while (index <= num2) { clientePrestacion.Registra(this._Cliente, IntegerType.FromObject(this.dgDatos[index, 2]), DecimalType.FromObject(this.dgDatos[index, 1]), this.dtpFInicio.Value, this.dtpFInicio.Value, this.cboStatus.Text, Globals.GetInstance._Usuario); checked { ++index; } } this.DatosSalvados = true; this.Close(); }
private bool ExistePrestacion(int Identificador) { bool flag = false; int num1 = 0; int num2 = checked (this.dtDatos.Rows.Count - 1); int index = num1; while (index <= num2) { if (IntegerType.FromObject(this.dgDatos[index, 2]) == Identificador) { flag = true; } checked { ++index; } } return(flag); }
private void toolStripButton9_Click(object sender, EventArgs e) { ToolStripButton button = sender as ToolStripButton; if (button == null) { return; } ClsTerrain clsTerrain = (ClsTerrain)this.GroupSelect.SelectedItem; if (clsTerrain == null) { return; } this.iTransition.SetHashKey(IntegerType.FromObject(button.Tag), checked ((byte)clsTerrain.GroupID)); this.PictureBox1.Refresh(); }
public Models_Zadanie10.Enrollment EnrollStudent(EnrollStudentReq req) { using (var db = new s18734Context()) { using (var transaction = db.Database.BeginTransaction()) { var study = DoStudiesExist(req.Studies); if (study == null) { transaction.Rollback(); throw new Exception("Studia nie istnieja"); } Models_Zadanie10.Enrollment enrollment = GetEnrollment(study.IdStudy); if (enrollment == null) { enrollment = new Models_Zadanie10.Enrollment() { Semester = 1, IdStudy = study.IdStudy, StartDate = DateType.FromString(DateTime.Now.ToString("MM.dd.yyyy")) }; db.Enrollment.Add(enrollment); db.SaveChanges(); } if (checkIfStudentExist(req.IndexNumber)) { transaction.Rollback(); throw new Exception(); } var stud = new Models_Zadanie10.Student { IndexNumber = req.IndexNumber, FirstName = req.FirstName, LastName = req.LastName, BirthDate = DateType.FromString(req.BirthDate), IdEnrollment = IntegerType.FromObject(enrollment.IdEnrollment) }; db.Student.Add(stud); db.SaveChanges(); transaction.Commit(); return(enrollment); } } }
protected override void Edit(CurrencyManager source, int rowNum, Rectangle bounds, bool readOnly, string instantText, bool cellIsVisible) { Debug.WriteLine("ComboBox Edit"); Point point = this.DataGridTableStyle.DataGrid.PointToClient(Cursor.Position); Rectangle controlBounds = this.GetControlBounds(bounds); Rectangle rectangle2 = new Rectangle(point.X, point.Y, 1, 1); this.m_comboBox.SelectedIndex = IntegerType.FromObject(this.GetColumnValueAtRow(source, rowNum)); Debug.WriteLine(DoubleType.FromString("SelectedItem: ") + this.m_comboBox.SelectedIndex); Point point2 = new Point(controlBounds.X, controlBounds.Y); this.m_comboBox.Location = point2; this.m_comboBox.Visible = true; if (rectangle2.IntersectsWith(controlBounds)) { this.m_comboBox.DroppedDown = true; } this.m_previouslyEditedCellRow = rowNum; }
protected override void Paint(Graphics g, Rectangle bounds, CurrencyManager source, int rowNum, Brush backBrush, Brush foreBrush, bool alignToRight) { g.FillRectangle(new SolidBrush(Color.White), bounds); StringFormat format = new StringFormat(); format.Alignment = StringAlignment.Near; format.LineAlignment = StringAlignment.Center; Rectangle controlBounds = this.GetControlBounds(bounds); int num = IntegerType.FromObject(this.GetColumnValueAtRow(source, rowNum)); string text = this.m_comboBox.Items[num].ToString(); RectangleF layoutRectangle = new RectangleF((float)(controlBounds.X + 1), (float)(controlBounds.Y + 4), (float)(controlBounds.Width - 3), (float)((int)Math.Round((double)g.MeasureString(text, this.m_comboBox.Font).Height))); g.DrawString(text, this.m_comboBox.Font, foreBrush, layoutRectangle); ControlPaint.DrawBorder3D(g, controlBounds, Border3DStyle.Sunken); Rectangle rectangle = controlBounds; rectangle.Inflate(-2, -2); ControlPaint.DrawComboButton(g, rectangle.X + (controlBounds.Width - 20), rectangle.Y, 0x10, 0x11, ButtonState.Normal); }
public Studies GetStudies(string studiesName) { using var connection = SqlConnection; using var command = new SqlCommand { Connection = connection, CommandText = "SELECT * FROM Studies WHERE Name = @studiesName" }; command.Parameters.AddWithValue("studiesName", studiesName); connection.Open(); using var dataReader = command.ExecuteReader(); if (dataReader.Read()) { Studies studies = new Studies { IdStudy = IntegerType.FromObject(dataReader["IdStudy"]), Name = dataReader["Name"].ToString() }; return(studies); } return(null); }
private void Imprimir() { if (this.Grid.VisibleRowCount <= 0) { return; } if (StringType.StrCmp(StringType.FromObject(this.Grid[this.Grid.CurrentRowIndex, 9]), "1", false) == 0) { if (StringType.StrCmp(StringType.FromObject(this.Grid[this.Grid.CurrentRowIndex, 7]), "AUTORIZADO", false) == 0) { this.ImprimirReporte((int)Globals.GetInstance._Sucursal, IntegerType.FromObject(this.Grid[this.Grid.CurrentRowIndex, 0]), IntegerType.FromObject(this.Grid[this.Grid.CurrentRowIndex, 1])); } else { int num1 = (int)MessageBox.Show("Para imprimir un vale, el anticipo debe ser autorizado.", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } } else { int num2 = (int)MessageBox.Show("Los vales solo se generan de los anticipos de comisión.", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } }
public void Borra(int Año, int Mes, string Usuario) { try { this.cnSigamet = new SqlConnection(Globals.GetInstance._CadenaConexion); SqlCommand sqlCommand = new SqlCommand("spPTLClienteComisionista", this.cnSigamet); sqlCommand.Parameters.Add("@Configuracion", SqlDbType.SmallInt).Value = (object)1; sqlCommand.Parameters.Add("@Cliente", SqlDbType.Int).Value = (object)0; sqlCommand.Parameters.Add("@Año", SqlDbType.Int).Value = (object)Año; sqlCommand.Parameters.Add("@Mes", SqlDbType.Int).Value = (object)Mes; sqlCommand.Parameters.Add("@ComisionDiaria", SqlDbType.Money).Value = (object)0; sqlCommand.Parameters.Add("@ComisionPorTanque", SqlDbType.Money).Value = (object)0; sqlCommand.Parameters.Add("@Prestaciones", SqlDbType.Money).Value = (object)0; sqlCommand.Parameters.Add("@Deducciones", SqlDbType.Money).Value = (object)0; sqlCommand.Parameters.Add("@ComisionMensual", SqlDbType.Money).Value = (object)0; sqlCommand.Parameters.Add("@Total", SqlDbType.Money).Value = (object)0; sqlCommand.Parameters.Add("@Factor", SqlDbType.Decimal).Value = (object)0; sqlCommand.Parameters.Add("@Kilos", SqlDbType.Decimal).Value = (object)0; sqlCommand.Parameters.Add("@Usuario", SqlDbType.VarChar).Value = (object)Usuario; sqlCommand.Parameters.Add("@AjustePorTanque", SqlDbType.Money).Value = (object)0; sqlCommand.CommandType = CommandType.StoredProcedure; this.cnSigamet.Open(); this.drReader = sqlCommand.ExecuteReader(CommandBehavior.CloseConnection); while (this.drReader.Read()) { this.Secuencia = IntegerType.FromObject(this.drReader[0]); } this.cnSigamet.Close(); } catch (Exception ex) { ProjectData.SetProjectError(ex); Exception exception = ex; EventLog.WriteEntry("Consulta cliente factor" + exception.Source, exception.Message, EventLogEntryType.Error); int num = (int)MessageBox.Show(exception.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Hand); ProjectData.ClearProjectError(); } }
public Enrollment CreateStudentEnrollment( string indexNumber, string firstName, string lastName, DateTime birthDate, string studiesName) { using var connection = SqlConnection; connection.Open(); using var transaction = connection.BeginTransaction(); using var command = new SqlCommand { Connection = connection, Transaction = transaction }; try { // Checking if studies exists command.CommandText = "SELECT * FROM Studies WHERE Name = @name"; command.Parameters.AddWithValue("name", studiesName); using var studiesDataReader = command.ExecuteReader(); if (!studiesDataReader.Read()) { studiesDataReader.Close(); transaction.Rollback(); throw new ArgumentException("Studies dosen't exists"); } var studies = new Studies { IdStudy = IntegerType.FromObject(studiesDataReader["IdStudy"]), Name = studiesDataReader["Name"].ToString() }; studiesDataReader.Close(); // Checking if enrollment exisits command.CommandText = "SELECT * " + "FROM Enrollment " + "WHERE IdStudy = @idStudy AND Semester = 1"; command.Parameters.AddWithValue("idStudy", studies.IdStudy); using var entrollmentDataReader = command.ExecuteReader(); Enrollment enrollment;
public static String Oct(Object Number) { if (Number == null) { throw new ArgumentNullException("Number"); } switch (ObjectType.GetTypeCode(Number)) { case TypeCode.Byte: return(Oct(ByteType.FromObject(Number))); case TypeCode.Int16: return(Oct(ShortType.FromObject(Number))); case TypeCode.Boolean: case TypeCode.Char: case TypeCode.SByte: case TypeCode.UInt16: case TypeCode.Int32: return(Oct(IntegerType.FromObject(Number))); case TypeCode.Int64: return(Oct(LongType.FromObject(Number))); case TypeCode.UInt32: case TypeCode.UInt64: case TypeCode.Single: case TypeCode.Double: case TypeCode.Decimal: return(Oct(LongType.FromObject(Number))); case TypeCode.String: return(Oct(LongType.FromString (StringType.FromObject(Number)))); } throw new ArgumentException(S._("VB_InvalidNumber"), "Number"); }
// Raise a particular error. public void Raise(int Number, [Optional][DefaultValue(null)] Object Source, [Optional][DefaultValue(null)] Object Description, [Optional][DefaultValue(null)] Object HelpFile, [Optional][DefaultValue(null)] Object HelpContext) { if (Number == 0) { throw new ArgumentException (S._("VB_InvalidErrorNumber"), "Number"); } this.Number = Number; this.Source = StringType.FromObject(Source); this.Description = StringType.FromObject(Description); this.HelpFile = StringType.FromObject(HelpFile); this.HelpContext = IntegerType.FromObject(HelpContext); this.exception = CreateExceptionFromNumber (Number, this.Description); #if !ECMA_COMPAT this.exception.Source = this.Source; this.exception.HelpLink = this.HelpFile; #endif throw this.exception; }
public Enrollment GetEnrollment(int idEnrollment) { using var connection = SqlConnection; using var command = new SqlCommand { Connection = connection, CommandText = "SELECT * FROM Enrollment WHERE IdEnrollment = @idEnrollment" }; command.Parameters.AddWithValue("idEnrollment", idEnrollment); connection.Open(); using var dataReader = command.ExecuteReader(); if (dataReader.Read()) { var enrollment = new Enrollment { IdEnrollment = IntegerType.FromObject(dataReader["IdEnrollment"]), Semester = IntegerType.FromObject(dataReader["Semester"]), StartDate = DateTime.Parse(dataReader["StartDate"].ToString()), IdStudy = IntegerType.FromObject(dataReader["IdStudy"]) }; return(enrollment); } return(null); }
public void FromObject_ThrowsOverflowException(object value) { Assert.Throws <OverflowException>(() => IntegerType.FromObject(value)); }