public ToDo StatusNameByStatusId(int sid)
{
ToDo data = new ToDo();
SQLManager.SQLManager sqlConn = new SQLManager.SQLManager();
try
{
sqlConn.Connection = new SqlConnection(sqlConn.ConnectionString);
sqlConn.Query = "select StatusID,Name from tbl_status where StatusID=@ID";
sqlConn.Command = new SqlCommand(sqlConn.Query, sqlConn.Connection);
sqlConn.Command.Parameters.AddWithValue("@ID", sid);
sqlConn.Connection.Open();
using (sqlConn.Reader = sqlConn.Command.ExecuteReader())
{
while (sqlConn.Reader.Read())
{
// data.StatusID = Int32.Parse(sqlConn.Reader["StatusID"].ToString());
data.Name = sqlConn.Reader["Name"].ToString();
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (sqlConn.Reader != null)
sqlConn.Reader.Close();
sqlConn.Connection.Close();
sqlConn.Connection.Dispose();
}
return data;
}
public List<ToDo> GetOnlyToDo(int tid)
{
SQLManager.SQLManager sqlConn = new SQLManager.SQLManager();
ToDo tdo = new ToDo();
var doList = new List<ToDo>();
try
{
sqlConn.Connection = new SqlConnection(sqlConn.ConnectionString);
sqlConn.Query = "select * from tbl_ToDo where ToDoID=@id";
sqlConn.Command = new SqlCommand(sqlConn.Query, sqlConn.Connection);
sqlConn.Command.Parameters.AddWithValue("@id", tid);
sqlConn.Connection.Open();
using (sqlConn.Reader = sqlConn.Command.ExecuteReader())
{
while (sqlConn.Reader.Read())
{
doList.Add(new Admin.Models.ToDo.ToDo
{
ToDoID = Int32.Parse(sqlConn.Reader["ToDoID"].ToString()),
ToDoTitle = sqlConn.Reader["ToDoTitle"].ToString(),
ToDoDescription = sqlConn.Reader["ToDoDescription"].ToString(),
AssignedTo = Int32.Parse(sqlConn.Reader["AssignedTo"].ToString()),
CreatedAt = DateTime.Parse(sqlConn.Reader["CreatedAt"].ToString()),
Status=sqlConn.Reader["Status"].ToString(),
Deadline=DateTime.Parse(sqlConn.Reader["Deadline"].ToString()),
});
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (sqlConn.Reader != null)
sqlConn.Reader.Close();
sqlConn.Connection.Close();
sqlConn.Connection.Dispose();
}
return doList;
}
public List<ToDo> GetStatusName()
{
SQLManager.SQLManager sqlConn = new SQLManager.SQLManager();
ToDo mile = new ToDo();
var toList = new List<ToDo>();
try
{
sqlConn.Connection = new SqlConnection(sqlConn.ConnectionString);
sqlConn.Query = "select StatusID,Name from tbl_status";
sqlConn.Command = new SqlCommand(sqlConn.Query, sqlConn.Connection);
// sqlConn.Command.Parameters.AddWithValue("@id", sid);
sqlConn.Connection.Open();
using (sqlConn.Reader = sqlConn.Command.ExecuteReader())
{
while (sqlConn.Reader.Read())
{
toList.Add(new Admin.Models.ToDo.ToDo
{
StatusID = Int32.Parse(sqlConn.Reader["StatusID"].ToString()),
Name = sqlConn.Reader["Name"].ToString(),
});
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (sqlConn.Reader != null)
sqlConn.Reader.Close();
sqlConn.Connection.Close();
sqlConn.Connection.Dispose();
}
return toList;
}
public ToDo GetData(int tID)
{
ToDo to = new ToDo();
SQLManager.SQLManager sqlConn = new SQLManager.SQLManager();
try
{
sqlConn.Connection = new SqlConnection(sqlConn.ConnectionString);
sqlConn.Query = "select * from tbl_todo where ToDoID=@id";
sqlConn.Command = new SqlCommand(sqlConn.Query, sqlConn.Connection);
sqlConn.Command.Parameters.AddWithValue("@id", tID);
sqlConn.Connection.Open();
using (sqlConn.Reader = sqlConn.Command.ExecuteReader())
{
while (sqlConn.Reader.Read())
{
to.ProjectID = Int32.Parse(sqlConn.Reader["ProjectID"].ToString());
to.ToDoID = Int32.Parse(sqlConn.Reader["ToDoID"].ToString());
to.ToDoTitle = sqlConn.Reader["ToDoTitle"].ToString();
to.ToDoDescription = sqlConn.Reader["ToDoDescription"].ToString();
to.AssignedTo = Int32.Parse(sqlConn.Reader["AssignedTo"].ToString());
to.Status = sqlConn.Reader["Status"].ToString();
to.CreatedAt = DateTime.Parse(sqlConn.Reader["CreatedAt"].ToString());
to.Deadline = DateTime.Parse(sqlConn.Reader["Deadline"].ToString());
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (sqlConn.Reader != null)
sqlConn.Reader.Close();
sqlConn.Connection.Close();
sqlConn.Connection.Dispose();
}
return to;
}
