public int UpdateCourses(BLLCourses objbll)
{
SqlParameter[] param = new SqlParameter[7];
param[0] = new SqlParameter("@course_code", SqlDbType.NVarChar);
param[0].Value = objbll.Course_code;
param[1] = new SqlParameter("@course_title", SqlDbType.NVarChar);
param[1].Value = objbll.Course_title;
param[2] = new SqlParameter("@short_name", SqlDbType.NVarChar);
param[2].Value = objbll.Short_name;
param[3] = new SqlParameter("@credit_hours", SqlDbType.NVarChar);
param[3].Value = objbll.Credit_hours;
param[4] = new SqlParameter("@cetegory", SqlDbType.NVarChar);
param[4].Value = objbll.Cetegory;
param[5] = new SqlParameter("@modifiedby ", SqlDbType.NVarChar);
param[5].Value = objbll.Modifiedby;
param[6] = new SqlParameter("@Update_Date", SqlDbType.DateTime);
param[6].Value = objbll.Update_date;
objcon.OpenConnection();
int a = objcon.sqlcmdUpdateById("sp_updatecourses", param);
objcon.CloseConnection();
return(a);
}
public List <BLLCourses> Selectcoursewebsitecalender(BLLCourses objbll)
{
List <BLLCourses> objlist = new List <BLLCourses>();
SqlParameter param = new SqlParameter();
param = new SqlParameter("@course_code", SqlDbType.NVarChar);
param.Value = objbll.Course_code;
SqlDataReader dr;
objcon.OpenConnection();
dr = objcon.sqlcmdSelectById("sp_selectcoursewebsitecalender", param);
while (dr.Read())
{
objbll = new BLLCourses();
objbll.Id = Convert.ToInt32(dr["id"].ToString());
objbll.Course_code = dr["course_code"].ToString();
objbll.Topic = dr["topic"].ToString();
objbll.Lecture = dr["lecture"].ToString();
objbll.Resource = dr["resource"].ToString();
objlist.Add(objbll);
}
objcon.CloseConnection();
return(objlist);
}
public List <BLLCourses> SelectCoursesbyid(BLLCourses objbll)
{
List <BLLCourses> objlist = new List <BLLCourses>();
SqlParameter param = new SqlParameter();
param = new SqlParameter("@course_code", SqlDbType.NVarChar);
param.Value = objbll.Course_code;
SqlDataReader dr;
objcon.OpenConnection();
dr = objcon.sqlcmdSelectById("sp_selectcoursesbyid", param);
while (dr.Read())
{
objbll = new BLLCourses();
objbll.Id = Convert.ToInt32(dr["id"].ToString());
objbll.Course_code = dr["course_code"].ToString();
objbll.Course_title = dr["course_title"].ToString();
objbll.Short_name = dr["short_name"].ToString();
objbll.Credit_hours = dr["credit_hours"].ToString();
objbll.Cetegory = dr["cetegory"].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 void SelectCourses()
{
List <BLLCourses> objlist = new List <BLLCourses>();
BLLCourses objbll = new BLLCourses();
objlist = objbll.SelectCourses();
if (objlist.Count > 0)
{
dgcourses.DataSource = objlist;
dgcourses.DataBind();
for (int i = 0; i <= dgcourses.Rows.Count - 1; i++)
{
string update = (string)Session["update"];
string delete = (string)Session["delete"];
if (update == "yes")
{
dgcourses.Rows[i].Cells[2].Enabled = true;
}
else
{
dgcourses.Rows[i].Cells[2].Enabled = false;
}
if (delete == "yes")
{
dgcourses.Rows[i].Cells[3].Enabled = true;
}
else
{
dgcourses.Rows[i].Cells[3].Enabled = false;
}
}
}
}
public List <BLLCourses> Selectcontentbycourse(BLLCourses objbll)
{
List <BLLCourses> objlist = new List <BLLCourses>();
SqlParameter param = new SqlParameter();
param = new SqlParameter("@course_code", SqlDbType.NVarChar);
param.Value = objbll.Course_code;
SqlDataReader dr;
objcon.OpenConnection();
dr = objcon.sqlcmdSelectById("sp_selectcoursecontents", param);
while (dr.Read())
{
objbll = new BLLCourses();
objbll.Id = Convert.ToInt32(dr["id"].ToString());
objbll.Course_code = dr["course_code"].ToString();
objbll.Course_content = dr["course_content"].ToString();
objbll.Course_synopsis = dr["course_synopsis"].ToString();
objbll.Learning_outcomes = dr["learning_outcomes"].ToString();
objlist.Add(objbll);
}
objcon.CloseConnection();
return(objlist);
}
public void SelectCalenderbycourse()
{
BLLCourses objbll = new BLLCourses();
objbll.Course_code = cbcourses.SelectedItem.Value.ToString();
List <BLLCourses> objlist = new List <BLLCourses>();
objlist = objbll.Selectcalenderbycourse(objbll);
if (objlist.Count > 0)
{
dglecture.DataSource = objlist;
dglecture.DataBind();
for (int i = 0; i <= dglecture.Rows.Count - 1; i++)
{
if (i == 0)
{
dglecture.Rows[0].Enabled = true;
}
else
{
dglecture.Rows[i].Enabled = false;
}
}
}
}
public void LoadCourseWebsite()
{
BLLCourses objbll = new BLLCourses();
objbll.Course_code = course_code;
objbll.Course_title = course_title;
List <BLLCourses> objlist = new List <BLLCourses>();
objlist = objbll.Selectcoursewebsite(objbll);
if (objlist.Count > 0)
{
lblcourse_id.Text = objlist[0].Course_code;
lblcategory.Text = objlist[0].Cetegory;
lblcourse_title.Text = objlist[0].Course_title;
lblcourse_credithours.Text = objlist[0].Credit_hours;
lblinstructorname.Text = objlist[0].Name;
lblemail.Text = objlist[0].Email;
lblinstructor_biogrpahy.Text = objlist[0].About;
lblcourseContents.Text = objlist[0].Course_content;
lblCourse_synopsis.Text = objlist[0].Course_synopsis;
lblLearningoutcomes.Text = objlist[0].Learning_outcomes;
Image1.ImageUrl = objlist[0].Pic_name;
}
}
protected void btndelete_Click(object sender, EventArgs e)
{
LinkButton obj = (LinkButton)(sender);
string val = obj.CommandArgument.ToString();
BLLCourses objbll = new BLLCourses();
objbll.Course_code = val;
int a = objbll.DeleteCourse(objbll);
SelectCourses();
}
public int DeleteCourse(BLLCourses objbll)
{
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@course_code", SqlDbType.NVarChar);
param[0].Value = objbll.Course_code;
objcon.OpenConnection();
int a = objcon.sqlcmdUpdateById("sp_deletecourse", param);
objcon.CloseConnection();
return(a);
}
public void Selectcoursecodebyname()
{
BLLCourses objbll = new BLLCourses();
objbll.Course_title = cbcoursename.SelectedItem.Value.ToString();
List <BLLCourses> objlist = new List <BLLCourses>();
objlist = objbll.Selectcoursecodeebyname(objbll);
if (objlist.Count > 0)
{
txtcoursecode.Text = objlist[0].Course_code;
}
}
public void LoadCourseWebsiteCalender()
{
BLLCourses objbll = new BLLCourses();
objbll.Course_code = course_code;
List <BLLCourses> objlist = new List <BLLCourses>();
objlist = objbll.Selectcoursewebsitecalender(objbll);
if (objlist.Count > 0)
{
grdcoursecalender.DataSource = objlist;
grdcoursecalender.DataBind();
}
}
public void LoadCourses()
{
List <BLLCourses> objlist = new List <BLLCourses>();
BLLCourses objbll = new BLLCourses();
objlist = objbll.SelectCourses();
if (objlist.Count > 0)
{
cbcourses.DataSource = objlist;
cbcourses.ValueField = "course_code";
cbcourses.TextField = "course_title";
cbcourses.DataBind();
}
}
public void SelectContentbycourse()
{
BLLCourses objbll = new BLLCourses();
objbll.Course_code = cbcourses.SelectedItem.Value.ToString();
List <BLLCourses> objlist = new List <BLLCourses>();
objlist = objbll.Selectcontentbycourse(objbll);
if (objlist.Count > 0)
{
txtcontent.Text = objlist[0].Course_content;
txtsynopsis.Text = objlist[0].Course_synopsis;
txtlearning.Text = objlist[0].Learning_outcomes;
}
}
public void InsertCourseContent()
{
BLLCourses objbll = new BLLCourses();
objbll.Course_code = cbcourses.SelectedItem.Value.ToString();
objbll.Course_content = txtcontent.Text;
objbll.Course_synopsis = txtsynopsis.Text;
objbll.Learning_outcomes = txtlearning.Text;
int a = objbll.InsertCourseContent(objbll);
if (a == 1)
{
lblresult.Text = "Course Content Save Successfully";
BtnSave.Enabled = false;
BtnNew.Enabled = true;
}
}
public void LoadForm()
{
BLLCourses objbll = new BLLCourses();
objbll.Course_code = (string)Session["course_update"];
List <BLLCourses> objlist = new List <BLLCourses>();
objlist = objbll.SelectCoursesbyid(objbll);
if (objlist.Count > 0)
{
txtcoursecode.Text = objlist[0].Course_code;
txtcoursetitle.Text = objlist[0].Course_title;
txtshortname.Text = objlist[0].Short_name;
txtcredithours.Text = objlist[0].Credit_hours;
txtcetegory.Text = objlist[0].Cetegory;
}
}
public void InsertCourseCalendar()
{
for (int i = 0; i <= dglecture.Rows.Count - 1; i++)
{
TextBox txttopic = (TextBox)dglecture.Rows[i].Cells[1].FindControl("txt_topic");
TextBox txtlecture = (TextBox)dglecture.Rows[i].Cells[2].FindControl("txt_lecture");
TextBox txtresource = (TextBox)dglecture.Rows[i].Cells[3].FindControl("txt_resources");
BLLCourses objbll = new BLLCourses();
objbll.Course_code = cbcourses.SelectedItem.Value.ToString();
objbll.Topic = txttopic.Text;
objbll.Lecture = txtlecture.Text;
objbll.Resource = txtresource.Text;
int b = objbll.InsertCourseCalendar(objbll);
}
SelectCalenderbycourse();
}
public void UpdateCourses()
{
BLLCourses objbll = new BLLCourses();
objbll.Course_code = (string)Session["course_update"];
objbll.Course_title = txtcoursetitle.Text;
objbll.Short_name = txtshortname.Text;
objbll.Credit_hours = txtcredithours.Text;
objbll.Cetegory = txtcetegory.Text;
objbll.Modifiedby = user;
int a = objbll.UpdateCourses(objbll);
if (a == 1)
{
lblresult.Text = "Course Update Successfully....";
BtnSave.Enabled = false;
BtnNew.Enabled = true;
Session["mode"] = null;
}
}
public void InsertCourses()
{
BLLCourses objbll = new BLLCourses();
objbll.Course_code = txtcoursecode.Text;
objbll.Course_title = txtcoursetitle.Text;
objbll.Short_name = txtshortname.Text;
objbll.Credit_hours = txtcredithours.Text;
objbll.Cetegory = txtcetegory.Text;
objbll.Createdby = user;
objbll.Modifiedby = user;
int a = objbll.InsertCourses(objbll);
if (a == 3)
{
lblresult.Text = "Courses Information Save Successfully....";
BtnSave.Enabled = false;
BtnNew.Enabled = true;
}
}
public int InsertCourses(BLLCourses objbll)
{
SqlParameter[] param = new SqlParameter[10];
param[0] = new SqlParameter("@course_code", SqlDbType.NVarChar);
param[0].Value = objbll.Course_code;
param[1] = new SqlParameter("@course_title", SqlDbType.NVarChar);
param[1].Value = objbll.Course_title;
param[2] = new SqlParameter("@short_name", SqlDbType.NVarChar);
param[2].Value = objbll.Short_name;
param[3] = new SqlParameter("@credit_hours", SqlDbType.NVarChar);
param[3].Value = objbll.Credit_hours;
param[4] = new SqlParameter("@cetegory", SqlDbType.NVarChar);
param[4].Value = objbll.Cetegory;
param[5] = new SqlParameter("@status", SqlDbType.Bit);
param[5].Value = objbll.Status;
param[6] = new SqlParameter("@createdby", SqlDbType.NVarChar);
param[6].Value = objbll.Createdby;
param[7] = new SqlParameter("@modifiedby ", SqlDbType.NVarChar);
param[7].Value = objbll.Modifiedby;
param[8] = new SqlParameter("@Insert_Date", SqlDbType.DateTime);
param[8].Value = objbll.Insert_date;
param[9] = new SqlParameter("@Update_Date", SqlDbType.DateTime);
param[9].Value = objbll.Update_date;
objcon.OpenConnection();
int a = objcon.sqlcmdInsert("sp_insertcourses", param);
objcon.CloseConnection();
return(a);
}
public List <BLLCourses> Selectcoursecodeebyname(BLLCourses objbll)
{
List <BLLCourses> objlist = new List <BLLCourses>();
SqlParameter param = new SqlParameter();
param = new SqlParameter("@course_title", SqlDbType.NVarChar);
param.Value = objbll.Course_title;
SqlDataReader dr;
objcon.OpenConnection();
dr = objcon.sqlcmdSelectById("sp_selectcoursecodebyname", param);
while (dr.Read())
{
objbll = new BLLCourses();
objbll.Course_code = dr["course_code"].ToString();
objlist.Add(objbll);
}
objcon.CloseConnection();
return(objlist);
}
public int InsertCourseCalendar(BLLCourses objbll)
{
SqlParameter[] param = new SqlParameter[4];
param[0] = new SqlParameter("@course_code", SqlDbType.NVarChar);
param[0].Value = objbll.Course_code;
param[1] = new SqlParameter("@topic", SqlDbType.NVarChar);
param[1].Value = objbll.Topic;
param[2] = new SqlParameter("@lecture", SqlDbType.NVarChar);
param[2].Value = objbll.Lecture;
param[3] = new SqlParameter("@resource", SqlDbType.NVarChar);
param[3].Value = objbll.Resource;
objcon.OpenConnection();
int a = objcon.sqlcmdInsert("sp_insertcoursecalendar", param);
objcon.CloseConnection();
return(a);
}
public int InsertCourseContent(BLLCourses objbll)
{
SqlParameter[] param = new SqlParameter[4];
param[0] = new SqlParameter("@course_code", SqlDbType.NVarChar);
param[0].Value = objbll.Course_code;
param[1] = new SqlParameter("@course_content", SqlDbType.NVarChar);
param[1].Value = objbll.Course_content;
param[2] = new SqlParameter("@course_synopsis", SqlDbType.NVarChar);
param[2].Value = objbll.Course_synopsis;
param[3] = new SqlParameter("@learning_outcomes", SqlDbType.NVarChar);
param[3].Value = objbll.Learning_outcomes;
objcon.OpenConnection();
int a = objcon.sqlcmdInsert("sp_insertcoursecontent", param);
objcon.CloseConnection();
return(a);
}
public List <BLLCourses> Selectcoursewebsite(BLLCourses objbll)
{
List <BLLCourses> objlist = new List <BLLCourses>();
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@course_code", SqlDbType.NVarChar);
param[0].Value = objbll.Course_code;
param[1] = new SqlParameter("@course_title", SqlDbType.NVarChar);
param[1].Value = objbll.Course_title;
SqlDataReader dr;
objcon.OpenConnection();
dr = objcon.sqlcmdSelectByMultimoreprogram("sp_selectcoursewebsite", param);
while (dr.Read())
{
objbll = new BLLCourses();
objbll.Emp_code = dr["emp_code"].ToString();
objbll.Name = dr["name"].ToString();
objbll.Email = dr["email"].ToString();
objbll.About = dr["about"].ToString();
objbll.Pic_name = dr["pic_name"].ToString();
objbll.Course_code = dr["course_code"].ToString();
objbll.Course_title = dr["course_title"].ToString();
objbll.Credit_hours = dr["credit_hours"].ToString();
objbll.Cetegory = dr["cetegory"].ToString();
objbll.Course_content = dr["course_content"].ToString();
objbll.Course_synopsis = dr["course_synopsis"].ToString();
objbll.Learning_outcomes = dr["learning_outcomes"].ToString();
objlist.Add(objbll);
}
objcon.CloseConnection();
return(objlist);
}
public int InsertCourseCalendar(BLLCourses objbll)
{
DALCourses objdal = new DALCourses();
return(objdal.InsertCourseCalendar(objbll));
}
public List <BLLCourses> Selectcalenderbycourse(BLLCourses objbll)
{
DALCourses objdal = new DALCourses();
return(objdal.Selectcalenderbycourse(objbll));
}
public List <BLLCourses> Selectcoursewebsitecalender(BLLCourses objbll)
{
DALCourses objdal = new DALCourses();
return(objdal.Selectcoursewebsitecalender(objbll));
}
public List <BLLCourses> SelectCoursesbyid(BLLCourses objbll)
{
DALCourses objdal = new DALCourses();
return(objdal.SelectCoursesbyid(objbll));
}
public int UpdateCourses(BLLCourses objbll)
{
DALCourses objdal = new DALCourses();
return(objdal.UpdateCourses(objbll));
}
public int DeleteCourse(BLLCourses objbll)
{
DALCourses objdal = new DALCourses();
return(objdal.DeleteCourse(objbll));
}
public List <BLLCourses> Selectcoursecodeebyname(BLLCourses objbll)
{
DALCourses objdal = new DALCourses();
return(objdal.Selectcoursecodeebyname(objbll));
}
