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