Ejemplo n.º 1
0
        public int InsertJournal(Journal journal)
        {
            int id = 0;
            using (SqlConnection con = DBConnection.GetConnection())
            {
                SqlCommand cmd = new SqlCommand("InsertJournal", con);
                cmd.CommandType = System.Data.CommandType.StoredProcedure;
                cmd.Parameters.Add(new SqlParameter("@date_entered", journal.DateEntered));
                cmd.Parameters.Add(new SqlParameter("@description", journal.Description));
                cmd.Parameters.Add(new SqlParameter("@image", journal.JournalImage));
                cmd.Parameters.Add(new SqlParameter("@crop_id_fk", journal.CropId));

                con.Open();
                //cmd.ExecuteNonQuery();
                SqlDataAdapter ad = new SqlDataAdapter(cmd);
                DataSet ds = new DataSet();
                ad.Fill(ds);
                DataTable result = ds.Tables[0];
                foreach (DataRow row in result.Rows)
                {
                    id = Int16.Parse(row[0].ToString());
                }
                con.Close();
            }
            return id;
        }
Ejemplo n.º 2
0
        public List<Journal> SelectJournalByCropId(int crop_id)
        {
            List<Journal> journals = new List<Journal>();
            try
            {
                using (SqlConnection con = DBConnection.GetConnection())
                {
                    SqlCommand cmd = new SqlCommand("SelectJournalByCropId", con);
                    cmd.CommandType = System.Data.CommandType.StoredProcedure;
                    cmd.Parameters.Add(new SqlParameter("@crop_id", crop_id));
                    con.Open();

                    SqlDataAdapter ad = new SqlDataAdapter(cmd);
                    DataSet ds = new DataSet();
                    ad.Fill(ds);
                    DataTable cropsTable = ds.Tables[0];
                    if (cropsTable == null)
                    {
                        return null;
                    }
                    else
                    {
                        foreach (DataRow row in cropsTable.Rows)
                        {
                            Journal journal = new Journal();
                            journal.JournalId = Int16.Parse(row[0].ToString());
                            journal.DateEntered = DateTime.Parse(row[1].ToString());
                            journal.Description = row[2].ToString();
                            journal.JournalImage = row[3] as byte[];
                            journal.CropId = Int16.Parse(row[4].ToString());
                            journals.Add(journal);
                        }
                    }
                    con.Close();
                }

            }
            catch (Exception e)
            {
                Console.WriteLine(e.StackTrace);
            }

            return journals;
        }