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