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