public List <Colleges> getcollegedetails(int id) { List <Colleges> listcollege = null; SqlParameter[] Pararmeters = new SqlParameter[] { new SqlParameter("@Id", id) }; using (DataTable table = DBHelper.ExecuteParamerizedSelectCommand("sp_GetCollegeDetails", CommandType.StoredProcedure, Pararmeters)) { if (table.Rows.Count > 0) { listcollege = new List <Colleges>(); foreach (DataRow row in table.Rows) { Colleges colleges = new Colleges(); colleges.CollegeId = Convert.ToInt32(row["College_Id"]); colleges.CollegeName = row["College_Name"].ToString(); colleges.CollegeLogo = row["College_logo"].ToString(); colleges.CollegeEstablish = Convert.ToDateTime(row["College_Establish"]); colleges.CollegeLocation = row["College_Location"].ToString(); colleges.CollegeWebSite = row["College_Website"].ToString(); colleges.CollegeAbout = row["College_About"].ToString(); colleges.CollegeShow = Convert.ToBoolean(row["College_Show"]); listcollege.Add(colleges); } } } return(listcollege); }
//-----------------Get public List <Colleges> getallcolleges() { List <Colleges> listcollege = null; using (DataTable table = DBHelper.ExecuteSelectCommand("sp_GetAllColleges", CommandType.StoredProcedure)) { if (table.Rows.Count > 0) { listcollege = new List <Colleges>(); foreach (DataRow row in table.Rows) { Colleges colleges = new Colleges(); colleges.CollegeId = Convert.ToInt32(row["College_Id"]); colleges.CollegeName = row["College_Name"].ToString(); colleges.CollegeLogo = row["College_logo"].ToString(); colleges.CollegeEstablish = Convert.ToDateTime(row["College_Establish"]); colleges.CollegeLocation = row["College_Location"].ToString(); colleges.CollegeWebSite = row["College_Website"].ToString(); colleges.DepartmentAbout = row["College_About"].ToString(); colleges.CollegeShow = Convert.ToBoolean(row["College_Show"]); listcollege.Add(colleges); } } } return(listcollege); }
public List <Colleges> getfieldbydepartment(int department) { List <Colleges> ListRequest = null; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@Department", department) }; using (DataTable table = DBHelper.ExecuteParamerizedSelectCommand("sp_GetFieldByDepartment", CommandType.StoredProcedure, parameters)) { if (table.Rows.Count > 0) { ListRequest = new List <Colleges>(); foreach (DataRow row in table.Rows) { Colleges colleges = new Colleges(); colleges.FieldID = Convert.ToInt32(row["Field_Id"]); colleges.FieldTitle = row["Field_Title"].ToString(); colleges.FieldAbout = row["Field_About"].ToString(); colleges.DepartmentId = Convert.ToInt32(row["Dept_Id"]); ListRequest.Add(colleges); } } } return(ListRequest); }
public List <Colleges> getdepartmentbycollege(int college) { List <Colleges> ListRequest = null; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@College", college) }; using (DataTable table = DBHelper.ExecuteParamerizedSelectCommand("sp_GetDepartmentbyCollege", CommandType.StoredProcedure, parameters)) { if (table.Rows.Count > 0) { ListRequest = new List <Colleges>(); foreach (DataRow row in table.Rows) { Colleges colleges = new Colleges(); colleges.DepartmentId = Convert.ToInt32(row["Dept_Id"]); colleges.DepartmentName = row["Dept_Name"].ToString(); colleges.DepartmentAbout = row["Dept_About"].ToString(); colleges.CollegeId = Convert.ToInt32(row["College_Id"]); ListRequest.Add(colleges); } } } return(ListRequest); }
public bool deletefield(Colleges colleges) { SqlParameter[] Pararmeters = new SqlParameter[] { new SqlParameter("Id", colleges.FieldID) }; return(DBHelper.ExecuteNonQuery("sp_DeleteField", CommandType.StoredProcedure, Pararmeters)); }
public bool deletedepartment(Colleges colleges) { SqlParameter[] Pararmeters = new SqlParameter[] { new SqlParameter("Id", colleges.DepartmentId) }; return(DBHelper.ExecuteNonQuery("sp_DeleteDepartment", CommandType.StoredProcedure, Pararmeters)); }
public bool newfield(Colleges cg) { SqlParameter[] Pararmeters = new SqlParameter[] { new SqlParameter("@Title", cg.FieldTitle), new SqlParameter("@About", cg.FieldAbout), new SqlParameter("@Department", cg.DepartmentId) }; return(DBHelper.ExecuteNonQuery("sp_NewField", CommandType.StoredProcedure, Pararmeters)); }
public bool newdepartment(Colleges cg) { SqlParameter[] Pararmeters = new SqlParameter[] { new SqlParameter("@Name", cg.DepartmentName), new SqlParameter("@About", cg.DepartmentAbout), new SqlParameter("@College", cg.CollegeId) }; return(DBHelper.ExecuteNonQuery("sp_NewDepartment", CommandType.StoredProcedure, Pararmeters)); }
public bool updatefield(Colleges colleges) { SqlParameter[] Pararmeters = new SqlParameter[] { new SqlParameter("Id", colleges.FieldID), new SqlParameter("@Title", colleges.FieldTitle), new SqlParameter("@About", colleges.FieldAbout) }; return(DBHelper.ExecuteNonQuery("sp_UpdateField", CommandType.StoredProcedure, Pararmeters)); }
public bool updatedepartment(Colleges colleges) { SqlParameter[] Pararmeters = new SqlParameter[] { new SqlParameter("Id", colleges.DepartmentId), new SqlParameter("@Name", colleges.DepartmentName), new SqlParameter("@About", colleges.DepartmentAbout) }; return(DBHelper.ExecuteNonQuery("sp_UpdateDepartment", CommandType.StoredProcedure, Pararmeters)); }
//-----------------New public bool newcollege(Colleges cg) { SqlParameter[] Pararmeters = new SqlParameter[] { new SqlParameter("@Name", cg.CollegeName), new SqlParameter("@Logo", cg.CollegeLogo), new SqlParameter("@Establish", cg.CollegeEstablish), new SqlParameter("@Location", cg.CollegeLocation), new SqlParameter("@WebSite", cg.CollegeWebSite), new SqlParameter("@About", cg.CollegeAbout), new SqlParameter("@Show", cg.CollegeShow) }; return(DBHelper.ExecuteNonQuery("sp_NewCollege", CommandType.StoredProcedure, Pararmeters)); }
public List <Colleges> getalldepartments() { List <Colleges> listcollege = null; using (DataTable table = DBHelper.ExecuteSelectCommand("sp_GetAllDepartments", CommandType.StoredProcedure)) { if (table.Rows.Count > 0) { listcollege = new List <Colleges>(); foreach (DataRow row in table.Rows) { Colleges colleges = new Colleges(); colleges.DepartmentId = Convert.ToInt32(row["Dept_Id"]); colleges.DepartmentName = row["Dept_Name"].ToString(); colleges.DepartmentAbout = row["Dept_About"].ToString(); colleges.CollegeId = Convert.ToInt32(row["College_Id"]); listcollege.Add(colleges); } } } return(listcollege); }