public List <Milestones> GetOnlyMilestones(int pid) { SQLManager.SQLManager sqlConn = new SQLManager.SQLManager(); Milestones mile = new Milestones(); var mileList = new List <Milestones>(); try { sqlConn.Connection = new SqlConnection(sqlConn.ConnectionString); sqlConn.Query = "select * from tbl_milestones where MilestonesID=@id"; sqlConn.Command = new SqlCommand(sqlConn.Query, sqlConn.Connection); sqlConn.Command.Parameters.AddWithValue("@id", pid); sqlConn.Connection.Open(); using (sqlConn.Reader = sqlConn.Command.ExecuteReader()) { while (sqlConn.Reader.Read()) { mileList.Add(new Admin.Models.Milestones.Milestones { MilestonesID = Int32.Parse(sqlConn.Reader["MilestonesID"].ToString()), MilestonesTitle = sqlConn.Reader["MilestonesTitle"].ToString(), MilestonesDescription = sqlConn.Reader["MilestonesDescription"].ToString(), Status = sqlConn.Reader["Status"].ToString(), Deadline = DateTime.Parse(sqlConn.Reader["Deadline"].ToString()), CreatedAt = DateTime.Parse(sqlConn.Reader["CreatedAt"].ToString()), UpdatedAt = DateTime.Parse(sqlConn.Reader["CreatedAt"].ToString()), }); } } } catch (Exception ex) { throw ex; } finally { if (sqlConn.Reader != null) { sqlConn.Reader.Close(); } sqlConn.Connection.Close(); sqlConn.Connection.Dispose(); } return(mileList); }
public List <Milestones> GetStatusName() { SQLManager.SQLManager sqlConn = new SQLManager.SQLManager(); Milestones mile = new Milestones(); var mileList = new List <Milestones>(); 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()) { mileList.Add(new Admin.Models.Milestones.Milestones { StatusID = Int32.Parse(sqlConn.Reader["StatusID"].ToString()), Name = sqlConn.Reader["Name"].ToString(), // MilestonesDescription = sqlConn.Reader["MilestonesDescription"].ToString(), // CreatedAt = DateTime.Parse(sqlConn.Reader["CreatedAt"].ToString()), }); } } } catch (Exception ex) { throw ex; } finally { if (sqlConn.Reader != null) { sqlConn.Reader.Close(); } sqlConn.Connection.Close(); sqlConn.Connection.Dispose(); } return(mileList); }
public Milestones GetData(int mID) { Milestones mile = new Milestones(); SQLManager.SQLManager sqlConn = new SQLManager.SQLManager(); try { sqlConn.Connection = new SqlConnection(sqlConn.ConnectionString); sqlConn.Query = "select * from tbl_milestones where MilestonesID=@id"; sqlConn.Command = new SqlCommand(sqlConn.Query, sqlConn.Connection); sqlConn.Command.Parameters.AddWithValue("@id", mID); sqlConn.Connection.Open(); using (sqlConn.Reader = sqlConn.Command.ExecuteReader()) { while (sqlConn.Reader.Read()) { mile.ProjectID = Int32.Parse(sqlConn.Reader["ProjectID"].ToString()); mile.MilestonesID = Int32.Parse(sqlConn.Reader["MilestonesID"].ToString()); mile.MilestonesTitle = sqlConn.Reader["MilestonesTitle"].ToString(); mile.MilestonesDescription = sqlConn.Reader["MilestonesDescription"].ToString(); mile.Deadline = DateTime.Parse(sqlConn.Reader["Deadline"].ToString()); mile.Status = sqlConn.Reader["Status"].ToString(); mile.UpdatedAt = DateTime.Parse(sqlConn.Reader["UpdatedAt"].ToString()); } } } catch (Exception ex) { throw ex; } finally { if (sqlConn.Reader != null) { sqlConn.Reader.Close(); } sqlConn.Connection.Close(); sqlConn.Connection.Dispose(); } return(mile); }
public Milestones Datamilestones(int pid) { Milestones data = new Milestones(); SQLManager.SQLManager sqlConn = new SQLManager.SQLManager(); try { sqlConn.Connection = new SqlConnection(sqlConn.ConnectionString); sqlConn.Query = "select ProjectID, MilestonesID,MilestonesTitle,MilestonesDescription from tbl_milestones where ProjectID=@ID"; sqlConn.Command = new SqlCommand(sqlConn.Query, sqlConn.Connection); sqlConn.Command.Parameters.AddWithValue("@ID", pid); sqlConn.Connection.Open(); using (sqlConn.Reader = sqlConn.Command.ExecuteReader()) { while (sqlConn.Reader.Read()) { data.ProjectID = Int32.Parse(sqlConn.Reader["ProjectID"].ToString()); data.MilestonesID = Int32.Parse(sqlConn.Reader["MilestonesID"].ToString()); data.MilestonesTitle = sqlConn.Reader["MilestonesTitle"].ToString(); data.MilestonesDescription = sqlConn.Reader["MilestonesDescription"].ToString(); data.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(data); }
public Milestones StatusNameByStatusId(int sid) { Milestones data = new Milestones(); 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(); // data.MilestonesTitle = sqlConn.Reader["MilestonesTitle"].ToString(); // data.MilestonesDescription = sqlConn.Reader["MilestonesDescription"].ToString(); } } } catch (Exception ex) { throw ex; } finally { if (sqlConn.Reader != null) { sqlConn.Reader.Close(); } sqlConn.Connection.Close(); sqlConn.Connection.Dispose(); } return(data); }
public Milestones StatusNameByStatusId(int sid) { Milestones data = new Milestones(); 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(); // data.MilestonesTitle = sqlConn.Reader["MilestonesTitle"].ToString(); // data.MilestonesDescription = sqlConn.Reader["MilestonesDescription"].ToString(); } } } catch (Exception ex) { throw ex; } finally { if (sqlConn.Reader != null) sqlConn.Reader.Close(); sqlConn.Connection.Close(); sqlConn.Connection.Dispose(); } return data; }
public List<Milestones> GetStatusName() { SQLManager.SQLManager sqlConn = new SQLManager.SQLManager(); Milestones mile = new Milestones(); var mileList = new List<Milestones>(); 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()) { mileList.Add(new Admin.Models.Milestones.Milestones { StatusID = Int32.Parse(sqlConn.Reader["StatusID"].ToString()), Name = sqlConn.Reader["Name"].ToString(), // MilestonesDescription = sqlConn.Reader["MilestonesDescription"].ToString(), // CreatedAt = DateTime.Parse(sqlConn.Reader["CreatedAt"].ToString()), }); } } } catch (Exception ex) { throw ex; } finally { if (sqlConn.Reader != null) sqlConn.Reader.Close(); sqlConn.Connection.Close(); sqlConn.Connection.Dispose(); } return mileList; }
public List<Milestones> GetOnlyMilestones(int pid) { SQLManager.SQLManager sqlConn = new SQLManager.SQLManager(); Milestones mile = new Milestones(); var mileList = new List<Milestones>(); try { sqlConn.Connection = new SqlConnection(sqlConn.ConnectionString); sqlConn.Query = "select * from tbl_milestones where MilestonesID=@id"; sqlConn.Command = new SqlCommand(sqlConn.Query, sqlConn.Connection); sqlConn.Command.Parameters.AddWithValue("@id", pid); sqlConn.Connection.Open(); using (sqlConn.Reader = sqlConn.Command.ExecuteReader()) { while (sqlConn.Reader.Read()) { mileList.Add(new Admin.Models.Milestones.Milestones { MilestonesID = Int32.Parse(sqlConn.Reader["MilestonesID"].ToString()), MilestonesTitle = sqlConn.Reader["MilestonesTitle"].ToString(), MilestonesDescription = sqlConn.Reader["MilestonesDescription"].ToString(), Status=sqlConn.Reader["Status"].ToString(), Deadline = DateTime.Parse(sqlConn.Reader["Deadline"].ToString()), CreatedAt = DateTime.Parse(sqlConn.Reader["CreatedAt"].ToString()), UpdatedAt = DateTime.Parse(sqlConn.Reader["CreatedAt"].ToString()), }); } } } catch (Exception ex) { throw ex; } finally { if (sqlConn.Reader != null) sqlConn.Reader.Close(); sqlConn.Connection.Close(); sqlConn.Connection.Dispose(); } return mileList; }
public Milestones GetData(int mID) { Milestones mile = new Milestones(); SQLManager.SQLManager sqlConn = new SQLManager.SQLManager(); try { sqlConn.Connection = new SqlConnection(sqlConn.ConnectionString); sqlConn.Query = "select * from tbl_milestones where MilestonesID=@id"; sqlConn.Command = new SqlCommand(sqlConn.Query, sqlConn.Connection); sqlConn.Command.Parameters.AddWithValue("@id", mID); sqlConn.Connection.Open(); using (sqlConn.Reader = sqlConn.Command.ExecuteReader()) { while (sqlConn.Reader.Read()) { mile.ProjectID = Int32.Parse(sqlConn.Reader["ProjectID"].ToString()); mile.MilestonesID = Int32.Parse(sqlConn.Reader["MilestonesID"].ToString()); mile.MilestonesTitle = sqlConn.Reader["MilestonesTitle"].ToString(); mile.MilestonesDescription = sqlConn.Reader["MilestonesDescription"].ToString(); mile.Deadline=DateTime.Parse(sqlConn.Reader["Deadline"].ToString()); mile.Status = sqlConn.Reader["Status"].ToString(); mile.UpdatedAt = DateTime.Parse(sqlConn.Reader["UpdatedAt"].ToString()); } } } catch (Exception ex) { throw ex; } finally { if (sqlConn.Reader != null) sqlConn.Reader.Close(); sqlConn.Connection.Close(); sqlConn.Connection.Dispose(); } return mile; }
public Milestones Datamilestones(int pid) { Milestones data = new Milestones(); SQLManager.SQLManager sqlConn = new SQLManager.SQLManager(); try { sqlConn.Connection = new SqlConnection(sqlConn.ConnectionString); sqlConn.Query = "select ProjectID, MilestonesID,MilestonesTitle,MilestonesDescription from tbl_milestones where ProjectID=@ID"; sqlConn.Command = new SqlCommand(sqlConn.Query, sqlConn.Connection); sqlConn.Command.Parameters.AddWithValue("@ID", pid); sqlConn.Connection.Open(); using (sqlConn.Reader = sqlConn.Command.ExecuteReader()) { while (sqlConn.Reader.Read()) { data.ProjectID = Int32.Parse(sqlConn.Reader["ProjectID"].ToString()); data.MilestonesID = Int32.Parse(sqlConn.Reader["MilestonesID"].ToString()); data.MilestonesTitle = sqlConn.Reader["MilestonesTitle"].ToString(); data.MilestonesDescription = sqlConn.Reader["MilestonesDescription"].ToString(); data.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 data; }