public List <BLLTeacherEnrollment> SelectTeachEnrollment() { List <BLLTeacherEnrollment> objlist = new List <BLLTeacherEnrollment>(); BLLTeacherEnrollment objbll = new BLLTeacherEnrollment(); SqlDataReader dr; objcon.OpenConnection(); dr = objcon.sqlcmdSelectAll("sp_selectteachenrollment"); while (dr.Read()) { objbll = new BLLTeacherEnrollment(); objbll.Id = Convert.ToInt32(dr["id"].ToString()); objbll.Emp_code = dr["emp_code"].ToString(); objbll.Name = dr["name"].ToString(); objbll.Session_id = dr["session"].ToString(); objbll.Course = dr["course_title"].ToString(); objbll.Status = Convert.ToBoolean(dr["status"].ToString()); objbll.Createdby = dr["createdby"].ToString(); objbll.Modifiedby = dr["modifiedby"].ToString(); objbll.Insert_date = Convert.ToDateTime(dr["insert_date"].ToString()); objbll.Update_date = Convert.ToDateTime(dr["update_date"].ToString()); objlist.Add(objbll); } objcon.CloseConnection(); return(objlist); }
public List <BLLTeacherEnrollment> Selectassigncoursebyteacher(BLLTeacherEnrollment objbll) { List <BLLTeacherEnrollment> objlist = new List <BLLTeacherEnrollment>(); SqlParameter param = new SqlParameter(); param = new SqlParameter("@emp_code", SqlDbType.NVarChar); param.Value = objbll.Emp_code; SqlDataReader dr; objcon.OpenConnection(); dr = objcon.sqlcmdSelectById("sp_selectassgincoursebyteacher", param); while (dr.Read()) { objbll = new BLLTeacherEnrollment(); objbll.Id = Convert.ToInt32(dr["id"].ToString()); objbll.Emp_code = dr["emp_code"].ToString(); objbll.Name = dr["name"].ToString(); objbll.Session_id = dr["description"].ToString(); objbll.Course = dr["course_title"].ToString(); objbll.Course_code = dr["course_code"].ToString(); objlist.Add(objbll); } objcon.CloseConnection(); return(objlist); }
public void SelectTeachertAssignCourses() { List <BLLTeacherEnrollment> objlist = new List <BLLTeacherEnrollment>(); BLLTeacherEnrollment objbll = new BLLTeacherEnrollment(); objlist = objbll.SelectTeachEnrollment(); if (objlist.Count > 0) { dgteacherenroll.DataSource = objlist; dgteacherenroll.DataBind(); for (int i = 0; i <= dgteacherenroll.Rows.Count - 1; i++) { string update = (string)Session["update"]; string delete = (string)Session["delete"]; if (update == "yes") { dgteacherenroll.Rows[i].Cells[1].Enabled = true; } else { dgteacherenroll.Rows[i].Cells[1].Enabled = false; } if (delete == "yes") { dgteacherenroll.Rows[i].Cells[2].Enabled = true; } else { dgteacherenroll.Rows[i].Cells[2].Enabled = false; } } } }
public void SelectAssignCourses() { BLLTeacherEnrollment objbll = new BLLTeacherEnrollment(); objbll.Emp_code = user; List <BLLTeacherEnrollment> objlist = new List <BLLTeacherEnrollment>(); objlist = objbll.Selectassigncoursebyteacher(objbll); if (objlist.Count > 0) { dgassigncourses.DataSource = objlist; dgassigncourses.DataBind(); } }
public void LoadCourses() { BLLTeacherEnrollment objbll = new BLLTeacherEnrollment(); objbll.Emp_code = user; List <BLLTeacherEnrollment> objlist = new List <BLLTeacherEnrollment>(); objlist = objbll.Selectassigncoursebyteacher(objbll); if (objlist.Count > 0) { cbcourses.DataSource = objlist; cbcourses.ValueField = "course_code"; cbcourses.TextField = "course"; cbcourses.DataBind(); } }
public void InsertTeacherEnroll() { int a = 0; BLLTeacherEnrollment objbll = new BLLTeacherEnrollment(); foreach (ListEditItem item in lbassigncourses.Items.Cast <ListEditItem>().ToList()) { objbll.Emp_code = cbemployeecode.SelectedItem.Value.ToString(); objbll.Name = txtname.Text; objbll.Session_id = cmbsession.SelectedItem.Value.ToString(); objbll.Course = item.Value.ToString(); objbll.Createdby = user; objbll.Modifiedby = user; a = objbll.InsertTeacherEnrollment(objbll); } if (a > 0) { lblresult.Text = "Courses Assign Successfully...."; BtnSave.Enabled = false; BtnNew.Enabled = true; } }
public int InsertTeacherEnrollment(BLLTeacherEnrollment objbll) { SqlParameter[] param = new SqlParameter[9]; param[0] = new SqlParameter("@emp_code", SqlDbType.NVarChar); param[0].Value = objbll.Emp_code; param[1] = new SqlParameter("@name", SqlDbType.NVarChar); param[1].Value = objbll.Name; param[2] = new SqlParameter("@session_id", SqlDbType.NVarChar); param[2].Value = objbll.Session_id; param[3] = new SqlParameter("@course", SqlDbType.NVarChar); param[3].Value = objbll.Course; param[4] = new SqlParameter("@status", SqlDbType.Bit); param[4].Value = objbll.Status; param[5] = new SqlParameter("@createdby", SqlDbType.NVarChar); param[5].Value = objbll.Createdby; param[6] = new SqlParameter("@modifiedby ", SqlDbType.NVarChar); param[6].Value = objbll.Modifiedby; param[7] = new SqlParameter("@Insert_Date", SqlDbType.DateTime); param[7].Value = objbll.Insert_date; param[8] = new SqlParameter("@Update_Date", SqlDbType.DateTime); param[8].Value = objbll.Update_date; objcon.OpenConnection(); int a = objcon.sqlcmdInsert("sp_insertteachenrollment", param); objcon.CloseConnection(); return(a); }
public List <BLLTeacherEnrollment> Selectassigncoursebyteacher(BLLTeacherEnrollment objbll) { DALTeacherEnrollment objdal = new DALTeacherEnrollment(); return(objdal.Selectassigncoursebyteacher(objbll)); }
public int InsertTeacherEnrollment(BLLTeacherEnrollment objbll) { DALTeacherEnrollment objdal = new DALTeacherEnrollment(); return(objdal.InsertTeacherEnrollment(objbll)); }