public bool InsertNewRoutine(RoutineDetail routineDetail)
{
string GetProductsQuery = string.Format(@"insert into RoutineDetail values (@RoutineTitle,@RoutineTime)");
try
{
var routine = new RoutineDetail();
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
if (conn.State == System.Data.ConnectionState.Open)
{
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = GetProductsQuery;
cmd.Parameters.AddWithValue("@RoutineTitle", SqlDbType.VarChar).Value = routineDetail.RoutineTitle;
cmd.Parameters.AddWithValue("@RoutineTime", SqlDbType.DateTime).Value = routineDetail.RoutineScheduleTime;
return(cmd.ExecuteNonQuery() > 0);
}
}
}
}
catch (Exception eSql)
{
Debug.WriteLine("Exception: " + eSql.Message);
}
return(false);
}
public static ObservableCollection <RoutineDetail> GetRoutines()
{
const string GetProductsQuery = "select * from RoutineDetail";
var routines = new ObservableCollection <RoutineDetail>();
try
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
if (conn.State == System.Data.ConnectionState.Open)
{
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = GetProductsQuery;
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
var routine = new RoutineDetail
{
RoutineId = reader.GetInt32(0),
RoutineTitle = reader.GetString(1),
RoutineScheduledFor = reader.GetDateTime(2),
RoutineScheduleTime = reader.GetDateTime(2).ToString("h:mm tt")
};
routines.Add(routine);
}
}
}
}
}
return(routines);
}
catch (Exception eSql)
{
Debug.WriteLine("Exception: " + eSql.Message);
}
return(null);
}
public static RoutineDetail GetSelectedRoutine(int SelectedRoutineId)
{
const string GetProductsQuery = "select * from RoutineDetail where RoutineId = @RoutineId";
try
{
var routine = new RoutineDetail();
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
if (conn.State == System.Data.ConnectionState.Open)
{
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = GetProductsQuery;
cmd.Parameters.AddWithValue("@RoutineId", SqlDbType.Int).Value = SelectedRoutineId;
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
routine.RoutineId = reader.GetInt32(0);
routine.RoutineTitle = reader.GetString(1);
routine.RoutineScheduledFor = reader.GetDateTime(2);
routine.RoutineScheduleTime = reader.GetDateTime(2).ToString("h:mm tt");
}
}
}
}
}
return(routine);
}
catch (Exception eSql)
{
Debug.WriteLine("Exception: " + eSql.Message);
}
return(null);
}
