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));
}
