public static List <Task> GetAllTasks()
{
DAL.ConnectDb();
List <Task> data = new List <Task> ();
string query = "SELECT * FROM " + TableName;
SQLiteCommand command = new SQLiteCommand(query, DAL.Conn);
SQLiteDataReader reader = command.ExecuteReader();
while (reader.HasRows)
{
while (reader.Read())
{
Task t = new Task();
t.Id = reader.GetInt32(0);
t.Owner = UserDAL.GetUserById(reader.GetInt32(1));
t.Title = reader.GetString(2);
t.Description = reader.GetString(3);
t.Status = (TaskStatus)reader.GetInt32(4);
t.StartDate = DateTime.Parse(reader.GetString(5));
t.EndDate = DateTime.Parse(reader.GetString(6));
t.IsPrivate = reader.GetBoolean(7);
t.Partners = PartnerDAL.GetAllPartners(t);
data.Add(t);
}
reader.NextResult();
}
return(data);
}
public static Task GetTaskById(int id)
{
DAL.ConnectDb();
Task t = new Task();
string query = "SELECT * FROM " + TableName + " WHERE Id = @TaskId";
SQLiteCommand command = new SQLiteCommand(query, DAL.Conn);
command.Parameters.AddWithValue("@TaskId", id);
SQLiteDataReader reader = command.ExecuteReader();
while (reader.Read())
{
t.Id = Int32.Parse(reader["Id"].ToString());
t.Owner = UserDAL.GetUserById(Int32.Parse(reader["OwnerId"].ToString()));
t.Title = reader["Title"].ToString();
t.Description = reader["Description"].ToString();
t.Status = (TaskStatus)Int32.Parse(reader["Status"].ToString());
t.StartDate = DateTime.Parse(reader["StartDate"].ToString());
t.EndDate = DateTime.Parse(reader["EndDate"].ToString());
t.IsPrivate = Boolean.Parse(reader["IsPrivate"].ToString() == "1" ? "true" : "false");
t.Partners = PartnerDAL.GetAllPartners(t);
}
return(t);
}
public static List <Comment> GetAllComments()
{
DAL.ConnectDb();
List <Comment> data = new List <Comment> ();
string query = "SELECT * FROM " + TableName;
SQLiteCommand command = new SQLiteCommand(query, DAL.Conn);
SQLiteDataReader reader = command.ExecuteReader();
while (reader.HasRows)
{
while (reader.Read())
{
Comment c = new Comment();
c.Id = reader.GetInt32(0);
c.Owner = UserDAL.GetUserById(reader.GetInt32(1));
c.Task = reader.GetInt32(2);
c.Content = reader.GetString(3);
c.Date = DateTime.Parse(reader.GetString(4));
data.Add(c);
}
reader.NextResult();
}
return(data);
}
public static List <User> GetAllPartners(Task task)
{
DAL.ConnectDb();
List <User> data = new List <User> ();
string query = "SELECT * FROM " + TableName + " WHERE TaskId = @TaskId";
SQLiteCommand command = new SQLiteCommand(query, DAL.Conn);
command.Parameters.AddWithValue("@TaskId", task.Id);
SQLiteDataReader reader = command.ExecuteReader();
while (reader.HasRows)
{
while (reader.Read())
{
int uId = reader.GetInt32(1);
data.Add(UserDAL.GetUserById(uId));
}
reader.NextResult();
}
return(data);
}
static protected Bill GetBill(MySqlDataReader reader)
{
Bill result = new Bill();
int AppID, UserID, PaymentID;
result.Bill_ID = reader.GetInt16("bill_Id");
AppID = reader.GetInt32("App_ID");
Application app = ApplicationDAL.GetApplicationById(AppID);
result.App = app;
UserID = reader.GetInt32("User_ID");
User user = UserDAL.GetUserById(UserID);
result.User = user;
PaymentID = reader.GetInt32("payment_id");
result.Payment = PaymentDAL.GetPaymentById(PaymentID);
result.UnitPrice = reader.GetDouble("UnitPrice");
result.DateCreate = reader.GetDateTime("DataCreate");
return(result);
}
public static Comment GetCommentById(int id)
{
DAL.ConnectDb();
Comment c = new Comment();
string query = "SELECT * FROM " + TableName + " WHERE Id = @CommentId";
SQLiteCommand command = new SQLiteCommand(query, DAL.Conn);
command.Parameters.AddWithValue("@CommentID", id);
SQLiteDataReader reader = command.ExecuteReader();
while (reader.Read())
{
c.Id = Int16.Parse(reader["Id"].ToString());
c.Owner = UserDAL.GetUserById(Int32.Parse(reader["UserId"].ToString()));
c.Task = Int32.Parse(reader["TaskId"].ToString());
c.Content = reader["Content"].ToString();
c.Date = DateTime.Parse(reader["Date"].ToString());
}
return(c);
}
