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