public void SelectSchedule() { List <BLLSchedule> objlist = new List <BLLSchedule>(); BLLSchedule objbll = new BLLSchedule(); objlist = objbll.SelectSchedule(); if (objlist.Count > 0) { dgschedule.DataSource = objlist; dgschedule.DataBind(); for (int i = 0; i <= dgschedule.Rows.Count - 1; i++) { string update = (string)Session["update"]; string delete = (string)Session["delete"]; if (update == "yes") { dgschedule.Rows[i].Cells[2].Enabled = true; } else { dgschedule.Rows[i].Cells[2].Enabled = false; } if (delete == "yes") { dgschedule.Rows[i].Cells[3].Enabled = true; } else { dgschedule.Rows[i].Cells[3].Enabled = false; } } } }
public List <BLLSchedule> SelectSchedule() { List <BLLSchedule> objlist = new List <BLLSchedule>(); BLLSchedule objbll = new BLLSchedule(); SqlDataReader dr; objcon.OpenConnection(); dr = objcon.sqlcmdSelectAll("sp_selectschedule"); while (dr.Read()) { objbll = new BLLSchedule(); objbll.Id = Convert.ToInt32(dr["id"].ToString()); objbll.Session_id = dr["session"].ToString(); objbll.Emp_code = dr["emp_code"].ToString(); objbll.Name = dr["name"].ToString(); objbll.Course_title = dr["course_title"].ToString(); objbll.Course_code = dr["course_code"].ToString(); objbll.Day = dr["day"].ToString(); objbll.Time_from = dr["time_from"].ToString(); objbll.Time_to = dr["time_to"].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 <BLLSchedule> Selectschedulebyrollno(BLLSchedule objbll) { List <BLLSchedule> objlist = new List <BLLSchedule>(); SqlParameter param = new SqlParameter(); param = new SqlParameter("@rollno", SqlDbType.NVarChar); param.Value = objbll.Rollno; SqlDataReader dr; objcon.OpenConnection(); dr = objcon.sqlcmdSelectById("sp_selectschedulebyrollno", param); while (dr.Read()) { objbll = new BLLSchedule(); objbll.Id = Convert.ToInt32(dr["id"].ToString()); objbll.Session_id = dr["session_id"].ToString(); objbll.Rollno = dr["rollno"].ToString(); objbll.Name = dr["name"].ToString(); objbll.Course_title = dr["course_title"].ToString(); objbll.Course_code = dr["course_code"].ToString(); objbll.Day = dr["day"].ToString(); objbll.Time_from = dr["time_from"].ToString(); objbll.Time_to = dr["time_to"].ToString(); objbll.Status = Convert.ToBoolean(dr["status"].ToString()); objlist.Add(objbll); } objcon.CloseConnection(); return(objlist); }
public void InsertSchedule() { BLLSchedule objbll = new BLLSchedule(); objbll.Session_id = cbsession.SelectedItem.Value.ToString(); objbll.Emp_code = cbemployeecode.SelectedItem.Value.ToString(); objbll.Name = txtname.Text; objbll.Course_title = cbcoursename.SelectedItem.Value.ToString(); objbll.Course_code = txtcoursecode.Text; objbll.Day = cbday.SelectedItem.ToString(); objbll.Time_from = timefrom.Text; objbll.Time_to = timeto.Text; objbll.Createdby = user; objbll.Modifiedby = user; int a = objbll.InsertSchedule(objbll); if (a == 1) { lblresult.Text = "Lecutre Time Assign Successfully...."; BtnSave.Enabled = false; BtnNew.Enabled = true; } else { lblresult.Text = "Lecutre Time Already Assign...."; } }
public int InsertSchedule(BLLSchedule objbll) { SqlParameter[] param = new SqlParameter[13]; param[0] = new SqlParameter("@session_id", SqlDbType.NVarChar); param[0].Value = objbll.Session_id; param[1] = new SqlParameter("@emp_code", SqlDbType.NVarChar); param[1].Value = objbll.Emp_code; param[2] = new SqlParameter("@name", SqlDbType.NVarChar); param[2].Value = objbll.Name; param[3] = new SqlParameter("@course_title", SqlDbType.NVarChar); param[3].Value = objbll.Course_title; param[4] = new SqlParameter("@course_code", SqlDbType.NVarChar); param[4].Value = objbll.Course_code; param[5] = new SqlParameter("@day", SqlDbType.NVarChar); param[5].Value = objbll.Day; param[6] = new SqlParameter("@time_from", SqlDbType.NVarChar); param[6].Value = objbll.Time_from; param[7] = new SqlParameter("@time_to", SqlDbType.NVarChar); param[7].Value = objbll.Time_to; param[8] = new SqlParameter("@status", SqlDbType.Bit); param[8].Value = objbll.Status; param[9] = new SqlParameter("@createdby", SqlDbType.NVarChar); param[9].Value = objbll.Createdby; param[10] = new SqlParameter("@modifiedby ", SqlDbType.NVarChar); param[10].Value = objbll.Modifiedby; param[11] = new SqlParameter("@Insert_Date", SqlDbType.DateTime); param[11].Value = objbll.Insert_date; param[12] = new SqlParameter("@Update_Date", SqlDbType.DateTime); param[12].Value = objbll.Update_date; objcon.OpenConnection(); int a = objcon.sqlcmdInsert("sp_insertschedule", param); objcon.CloseConnection(); return(a); }
public List <BLLSchedule> Selectschedulebyrollno(BLLSchedule objbll) { DALSchedule objdal = new DALSchedule(); return(objdal.Selectschedulebyrollno(objbll)); }
public List <BLLSchedule> Selectschedulebyempcode(BLLSchedule objbll) { DALSchedule objdal = new DALSchedule(); return(objdal.Selectschedulebyempcode(objbll)); }
public int InsertSchedule(BLLSchedule objbll) { DALSchedule objdal = new DALSchedule(); return(objdal.InsertSchedule(objbll)); }