public List <CashMovement> ListByDateAndCategoryType(DateTime CMD1, DateTime CMD2, int categoryType) { var conn = new SqlConnection(); var command = new SqlCommand(); var dataBase = new DBConnect(); var List = new List <CashMovement>(); try { conn = dataBase.Open(); command.Connection = conn; command.CommandText = "ListCashMovementByDateAndCategoryType"; command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@Date1", CMD1); command.Parameters.AddWithValue("@Date2", CMD2); command.Parameters.AddWithValue("@CategoryTypeId", categoryType); var rdr = command.ExecuteReader(); while (rdr != null && rdr.Read()) { var reg = new CashMovement(); reg.Id = (int)rdr["Id"]; reg.CashMovementDate = (DateTime)rdr["Fecha"]; reg._category.Name = (string)rdr["Detalle"]; reg.Value = float.Parse(rdr["Valor"].ToString()); reg._category._categoryType.Name = (string)rdr["Tipo de movimiento"]; reg._users.Nick = (string)rdr["Usuario"]; reg._category.Id = int.Parse(rdr["cId"].ToString()); reg._category._categoryType.Id = int.Parse(rdr["ctId"].ToString()); reg._users.Id = int.Parse(rdr["uId"].ToString()); reg.Observation = (string)rdr["Observacion"]; List.Add(reg); } } catch (Exception e) { MessageBox.Show(String.Concat(e.Message, e.StackTrace), ""); } finally { if (conn.State == System.Data.ConnectionState.Open) { conn.Close(); conn.Dispose(); } } return(List); }
public bool NewCashMovement(CashMovement CM) { var conn = new SqlConnection(); var command = new SqlCommand(); var dataBase = new DBConnect(); bool answ; try { conn = dataBase.Open(); command.Connection = conn; command.CommandText = "NewCashMovement"; command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@CategoryId", CM._category.Id); command.Parameters.AddWithValue("@Value", CM.Value); command.Parameters.AddWithValue("@CashMovementDate", CM.CashMovementDate); command.Parameters.AddWithValue("@Observation", CM.Observation); command.Parameters.AddWithValue("@UserId", CM._users.Id); command.ExecuteNonQuery(); answ = true; } catch (Exception e) { MessageBox.Show(String.Concat(e.Message, e.StackTrace), ""); answ = false; } finally { if (conn.State == System.Data.ConnectionState.Open) { conn.Close(); conn.Dispose(); } } return(answ); }