public static void AddDB(ConsecutivoModel consecutivoM)
{
using (efooddatabaseEntities db = new efooddatabaseEntities())
{
try
{
//Toda la data de la base de datos, se almacena en la lista numeroConsecutivo
var numeroConsecutivo = (from valor in db.Consecutives
select valor);
//Primary key
int code = numeroConsecutivo.Count() + 1;
//Tabla base de datos
Consecutive consecutive = new Consecutive
{
//Dando valor al objeto
ConsecutiveCode = code,
Description = consecutivoM.Description,
CurrentConsecutive = consecutivoM.CurrentConsecutive,
HasPrefix = consecutivoM.HasPrefix,
Prefix = consecutivoM.Prefix
};
//Se agrega el objeto a la base de datos
db.Consecutives.Add(consecutive);
//Commit a la base de datos
db.SaveChanges();
}
catch (Exception e) { ErrorLogModel.AddError(e); }
}
}
public Task <bool> InsertConsecutive(Consecutive consecutive)
{
try
{
using (var conn = _settings.GetConnection())
{
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
using (var cmd = new SqlCommand("INSERTA_CONSECUTIVO", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@TIPO", SqlDbType.Int).Value = consecutive.TypeConsecutive;
cmd.Parameters.Add("@ID_CONSECUTIVO", SqlDbType.Int).Value = consecutive.IdConsecutive;
cmd.Parameters.Add("@POSEE_PREFIJO", SqlDbType.Bit).Value = consecutive.HasPrefix;
cmd.Parameters.Add("@PREFIJO", SqlDbType.NVarChar).Value = consecutive.Prefix;
cmd.ExecuteNonQuery();
conn.Close();
}
}
return(Task.FromResult(true));
}
catch (Exception e)
{
Console.WriteLine(e);
return(Task.FromResult(false));
}
}
public async Task <ActionResult> ConsecutiveCreate(Consecutive data)
{
if (!ModelState.IsValid)
{
return(await Task.FromResult <ActionResult>(View(data)));
}
var result = _existsMethods.ExistConsecutive(data.TypeConsecutive, data.Prefix).Result;
switch (result)
{
case false:
var resultInsertConsecutive = await _insertMethods.InsertConsecutive(data);
if (resultInsertConsecutive)
{
return(RedirectToAction("ConsecutiveList"));
}
ModelState.AddModelError(key: "", errorMessage: "Ha ocurrido un error.\n");
return(await Task.FromResult <ActionResult>(View(data)));
case true:
ModelState.AddModelError("", "¡El consecutivo ya existe!\n");
return(await Task.FromResult <ActionResult>(View()));
default:
ModelState.AddModelError("", "¡Error! Conexion con servidor perdida.\n");
return(await Task.FromResult <ActionResult>(View()));
}
}
private void dataGrid_Selection(object sender, EventArgs e)
{
if (executedFirstTime)
{
executedFirstTime = false;
return;
}
try
{
int selectedIndex = dataGridViewSessions.SelectedRows[0].Index;
if (selectedIndex != -1)
{
if (dataGridViewSessions.SelectedRows[0].Cells[0].Value != null)
{
int id = int.Parse(dataGridViewSessions.SelectedRows[0].Cells[0].Value.ToString());
selectedConsecutive = new Consecutive();
selectedConsecutive = consecutiveService.GetConsecutive(id);
Console.WriteLine(id);
#region Set data to Fields
#endregion
btnDelete.Enabled = true;
}
}
}
catch (ArgumentOutOfRangeException es)
{
Console.WriteLine(es.Message);
}
}
public double[] CalculateFromSum(double sum)
{
svc = new Consecutive();
var result = svc.ConsecutiveFromSum(sum);
return(result);
}
private void btnRefresh_Click(object sender, EventArgs e)
{
populateData();
selectedConsecutive = new Consecutive();
btnDelete.Enabled = false;
btnUpdate.Enabled = false;
}
public void TestByImposibleNumber(double sum, double[] actrual)
{
svc = new Consecutive();
var result = svc.ConsecutiveFromSum(sum);
Assert.Equal(actrual, result);
}
public override void OnReceiveEvent(string time, string price, string volume)
{
if (int.TryParse(volume, out int vol))
{
var consecutive = new SendConsecutive(time, price, vol);
Consecutive?.Invoke(this, consecutive);
if (Current != consecutive.Price)
{
Revenue = (long)((consecutive.Price - Purchase) * Quantity);
Rate = consecutive.Price / (double)Purchase - 1;
Current = consecutive.Price;
}
}
}
public List <Consecutive> getAllConsecutives()
{
SQLiteConnection conn = new SQLiteConnection("Data Source=database.db;Version=3;");
List <Consecutive> arrayConsecutives = null;
try
{
string query = "SELECT * FROM consecutives";
conn.Open();
SQLiteCommand cmd = new SQLiteCommand(query, conn);
SQLiteDataReader rdr = cmd.ExecuteReader();
arrayConsecutives = new List <Consecutive>();
while (rdr.Read())
{
Consecutive consecutive = new Consecutive();
consecutive.Id = rdr.GetInt32(0);
consecutive.Con1_id = rdr.GetInt32(1);
try
{
consecutive.Con2_id = rdr.GetInt32(2);
}
catch (Exception er)
{
if (er.Message == "")
{
}
}
arrayConsecutives.Add(consecutive);
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
finally
{
conn.Close();
}
return(arrayConsecutives);
}
public Consecutive GetConsecutive(int id)
{
SQLiteConnection conn = new SQLiteConnection("Data Source=database.db;Version=3;");
Consecutive consecutive = new Consecutive();
try
{
string query = "SELECT * FROM consecutives WHERE id = @id";
conn.Open();
SQLiteCommand cmd = new SQLiteCommand(query, conn);
cmd.Parameters.AddWithValue("@id", id);
SQLiteDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
consecutive.Id = rdr.GetInt32(0);
consecutive.Con1_id = rdr.GetInt32(1);
try
{
consecutive.Con2_id = rdr.GetInt32(2);
}
catch (Exception er)
{
if (er.Message == "")
{
}
}
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
finally
{
conn.Close();
}
return(consecutive);
}
public List <Consecutive> searchConsecutive(string key, string type)
{
SQLiteConnection conn = new SQLiteConnection("Data Source=database.db;Version=3;");
List <Consecutive> arrayConsecutives = null;
try
{
string query = "SELECT * FROM consecutives WHERE " + type + " LIKE '%" + key + "%'";
conn.Open();
SQLiteCommand cmd = new SQLiteCommand(query, conn);
cmd.Parameters.AddWithValue("@type", type);
SQLiteDataReader rdr = cmd.ExecuteReader();
arrayConsecutives = new List <Consecutive>();
while (rdr.Read())
{
Consecutive consecutive = new Consecutive();
consecutive.Id = rdr.GetInt32(0);
consecutive.Con1_id = rdr.GetInt32(1);
consecutive.Con2_id = rdr.GetInt32(2);
arrayConsecutives.Add(consecutive);
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
finally
{
conn.Close();
}
return(arrayConsecutives);
}
public bool updateConsecutive(int id, Consecutive consecutive)
{
throw new NotImplementedException();
}
