protected void JoinedSessionGV_SelectedIndexChanged(object sender, EventArgs e)
{
sessionIjoinedPanel.Visible = true;
sessionIjoinedDetailsPanel.Visible = true;
viewRequestToMePanel.Visible = false;
requestToMeDetailsPanel.Visible = false;
//request by me panel
viewRequestByMePanel.Visible = false;
requestByMeDetailsPanel.Visible = false;
//session created by me
sessionDetailsPanel.Visible = false;
SessionByMePanel.Visible = false;
SessionCreatedByMeBtn.Visible = true;
sessionBO getDetails = new sessionBO();
GridViewRow row = JoinedSessionGV.SelectedRow;
String tuteeId = Request.Cookies["CurrentLoggedInUser"].Value;
int sessionId = Convert.ToInt32(JoinedSessionGV.SelectedRow.Cells[0].Text);
tutionEntities tutionObj = getDetails.GetSessionJoinedById(sessionId, tuteeId);
SJDeatilsLbl.Text = tutionObj.SessionDetails.ToString();
SJDateLbl.Text = tutionObj.sessionDate.ToString();
SJSTimeLbl.Text = tutionObj.sessionSTime.ToString();
SJETimeLbl.Text = tutionObj.sessionETime.ToString();
SJTutorId.Text = tutionObj.tutorId.ToString();
SJTuteeId.Text = tutionObj.tuteeId.ToString();
}
protected void tuitionGrid_SelectedIndexChanged(object sender, EventArgs e)
{
sessionBO getDetails = new sessionBO();
viewRequestToMePanel.Visible = false;
requestToMeDetailsPanel.Visible = false;
//request by me panel
viewRequestByMePanel.Visible = false;
requestByMeDetailsPanel.Visible = false;
//session created by me
sessionDetailsPanel.Visible = true;
SessionByMePanel.Visible = false;
SessionCreatedByMeBtn.Visible = false;
GridViewRow row = tuitionGrid.SelectedRow;
String user_Id = Request.Cookies["CurrentLoggedInUser"].Value;
int sessionId = Convert.ToInt32(tuitionGrid.SelectedRow.Cells[0].Text);
tutionEntities tuitionObj = getDetails.GetTuitionById(sessionId);
tutionDescriptionLbl.Text = tuitionObj.SessionDetails.ToString();
tutorIdLbl.Text = user_Id;
tuteeIdLbl.Text = tuitionObj.tuteeId.ToString();
dateLbl.Text = tuitionObj.sessionDate.ToString();
stimeLbl.Text = tuitionObj.sessionSTime.ToString();
etimeLbl.Text = tuitionObj.sessionETime.ToString();
}
//------------------------------------------------------------------------------------------------------------------------------------//
//load all tuition session
public List <tutionEntities> LoadAllTutionSession()
{
SqlDataAdapter da;
DataSet ds = new DataSet();
//declare list to hold collection of events objs
List <tutionEntities> loadAllTuitionSession = new List <tutionEntities>();
//retrieve conn string from web config
//done at class level
//sql commant to select data from table
StringBuilder sqlCommand = new StringBuilder();
// sqlCommand.AppendLine("SELECT eventName, eventSDate ,FORMAT(eventSTime,'hh:mm tt') AS eventSTime, eventEDate,");
//sqlCommand.AppendLine("eventETime, eventDescription, maxCapacity, eventName, eventSDate ,FORMAT(eventSTime,'hh:mm tt') AS eventSTime, eventEDate,");
sqlCommand.AppendLine("Select sessionId, sessionDetails, sessionDate,sessionSTime, sessionETime, tutorId");
sqlCommand.AppendLine("from tutorSessionDB where tuteeId IS NULL");
//Instantiate sqlcommnd instance
SqlConnection objsqlconn = new SqlConnection(DBConnect);
//RETRIEVE RECORD USING DATAADAPTER
da = new SqlDataAdapter(sqlCommand.ToString(), objsqlconn);
da.SelectCommand.CommandType = System.Data.CommandType.StoredProcedure;
da.SelectCommand.CommandType = CommandType.Text;
//da.SelectCommand.Parameters.AddWithValue("@paratutorId", tutorId);
//fill dataset to table
da.Fill(ds, "viewAllTuition");
//if no record, set list to null
int count = ds.Tables["viewAllTuition"].Rows.Count;
if (count == 0)
{
loadAllTuitionSession = null;
}
else
{
// Step 7 : Iterate DataRow to extract table column tdTerm and tdRate and
// create interestRte instance and add the instance to a List collection
foreach (DataRow row in ds.Tables["viewAllTuition"].Rows)
{
tutionEntities objTuition = new tutionEntities();
objTuition.sessionId = Convert.ToInt32(row["SessionID"]);
objTuition.SessionDetails = Convert.ToString(row["sessionDetails"]);
objTuition.sessionDate = Convert.ToString(row["sessionDate"]);
objTuition.sessionSTime = Convert.ToString(row["sessionSTime"]);
objTuition.sessionETime = Convert.ToString(row["sessionETime"]);
objTuition.tutorId = Convert.ToString(row["tutorId"]);
loadAllTuitionSession.Add(objTuition);
}
}
return(loadAllTuitionSession);
}
public tutionEntities GetSessionJoinedById(int SessionID, String tuteeId)
{
tutionEntities result = null;
result = objSession.GetSesionJoinedById(SessionID, tuteeId);
return(result);
}
public tutionEntities GetTuitionById(int sessionId)
{
tutionEntities result = null;
result = objSession.GetTuitionById(sessionId);
return(result);
}
//select students who have tutorSession to give points
public List <tutionEntities> getNumberOfTutionTeach()
{
SqlDataAdapter da;
DataSet ds = new DataSet();
//declare list to hold collection of events objs
List <tutionEntities> TeachTutionList = new List <tutionEntities>();
//retrieve conn string from web config
//done at class level
//sql commant to select data from table
StringBuilder sqlCommand = new StringBuilder();
// sqlCommand.AppendLine("SELECT eventName, eventSDate ,FORMAT(eventSTime,'hh:mm tt') AS eventSTime, eventEDate,");
//sqlCommand.AppendLine("eventETime, eventDescription, maxCapacity, eventName, eventSDate ,FORMAT(eventSTime,'hh:mm tt') AS eventSTime, eventEDate,");
sqlCommand.AppendLine("Select tutorId ");
sqlCommand.AppendLine("from tutorSessionDB where status LIKE 'Completed' GROUP BY tutorId HAVING COUNT(tutorId) > 3");
//Instantiate sqlcommnd instance
SqlConnection objsqlconn = new SqlConnection(DBConnect);
//RETRIEVE RECORD USING DATAADAPTER
da = new SqlDataAdapter(sqlCommand.ToString(), objsqlconn);
da.SelectCommand.CommandType = System.Data.CommandType.StoredProcedure;
da.SelectCommand.CommandType = CommandType.Text;
//fill dataset to table
da.Fill(ds, "tutionPointsGV");
//if no record, set list to null
int count = ds.Tables["tutionPointsGV"].Rows.Count;
if (count == 0)
{
TeachTutionList = null;
}
else
{
// Step 7 : Iterate DataRow to extract table column tdTerm and tdRate and
// create interestRte instance and add the instance to a List collection
foreach (DataRow row in ds.Tables["tutionPointsGV"].Rows)
{
tutionEntities objTuition = new tutionEntities();
objTuition.tutorId = Convert.ToString(row["tutorId"]);
// objTuition.tutorId = Convert.ToString(row["tutorId"]);
TeachTutionList.Add(objTuition);
}
}
return(TeachTutionList);
}
//RETRIEVE THE Session DATA
public tutionEntities GetTuitionById(int SessionID)
{
SqlDataAdapter da;
DataSet ds = new DataSet();
//declare list to hold collection of events objs
tutionEntities getTuition = new tutionEntities();
//retrieve conn string from web config
//done at class level
//sql commant to select data from table
StringBuilder sqlCommand = new StringBuilder();
// sqlCommand.AppendLine("SELECT eventName, eventSDate ,FORMAT(eventSTime,'hh:mm tt') AS eventSTime, eventEDate,");
//sqlCommand.AppendLine("eventETime, eventDescription, maxCapacity, eventName, eventSDate ,FORMAT(eventSTime,'hh:mm tt') AS eventSTime, eventEDate,");
sqlCommand.AppendLine("Select * ");
sqlCommand.AppendLine("from tutorSessionDB where sessionId= '" + SessionID + "' ");
//Instantiate sqlcommnd instance
SqlConnection objsqlconn = new SqlConnection(DBConnect);
//RETRIEVE RECORD USING DATAADAPTER
da = new SqlDataAdapter(sqlCommand.ToString(), objsqlconn);
//fill dataset to table
da.Fill(ds, "tuitionGrid");
//if no record, set list to null
int count = ds.Tables["tuitionGrid"].Rows.Count;
if (count == 0)
{
getTuition = null;
}
else
{
// Step 7 : Iterate DataRow to extract table column tdTerm and tdRate and
// create interestRte instance and add the instance to a List collection
foreach (DataRow row in ds.Tables["tuitionGrid"].Rows)
{
getTuition.sessionId = Convert.ToInt32(row["SessionID"]);
getTuition.SessionDetails = Convert.ToString(row["sessionDetails"]);
getTuition.sessionDate = Convert.ToString(row["sessionDate"]);
getTuition.sessionSTime = Convert.ToString(row["sessionSTime"]);
getTuition.sessionETime = Convert.ToString(row["sessionETime"]);
getTuition.status = Convert.ToString(row["status"]);
getTuition.tutorId = Convert.ToString(row["tutorId"]);
getTuition.tuteeId = Convert.ToString(row["tuteeId"]);
}
}
return(getTuition);
}
protected void viewAllTuitionGV_SelectedIndexChanged1(object sender, EventArgs e)
{
//Panel1.Visible = true;
GridViewRow row = viewAllTuitionGV.SelectedRow;
detailsPanel.Visible = true;
tutionPanel.Visible = false;
sessionBO getDetails = new sessionBO();
String tuteeId = Request.Cookies["CurrentLoggedInUser"].Value;
int sessionId = Convert.ToInt32(viewAllTuitionGV.SelectedRow.Cells[0].Text);
string tutorId = Convert.ToString(viewAllTuitionGV.SelectedRow.Cells[5].Text);
tutionEntities tuitionObj = getDetails.GetTuitionById(sessionId);
tutionIdLbl.Text = tuitionObj.sessionId.ToString();
sessionDetailsLbl.Text = tuitionObj.SessionDetails.ToString();
dateLbl.Text = tuitionObj.sessionDate.ToString();
stimeLbl.Text = tuitionObj.sessionSTime.ToString();
etimeLbl.Text = tuitionObj.sessionETime.ToString();
tutorIdTB.Text = tuitionObj.tutorId.ToString();
tuteeIdTB.Text = tuteeId.ToString();
}
protected void EditBtn_Click(object sender, EventArgs e)
{
if (tuitionGrid.SelectedIndex < 0)
{
}
else
{
sessionBO getDetails = new sessionBO();
int sessionId = Convert.ToInt32(tuitionGrid.SelectedRow.Cells[0].Text);
tutionEntities tutionObj = getDetails.GetTuitionById(sessionId);
String user_Id = Request.Cookies["CurrentLoggedInUser"].Value;
Session["sessionId"] = Convert.ToInt32(tuitionGrid.SelectedRow.Cells[0].Text);
Session["tutionDesc"] = tutionDescriptionLbl.Text;
Session["sessionDate"] = dateLbl.Text.ToString();
Session["sessionSTime"] = stimeLbl.Text.ToString();
Session["sessionETime"] = etimeLbl.Text.ToString();
Session["ddlSelectedValue"] = myStatusLbl.Text.ToString();
Session["userIdSession"] = user_Id;
Response.Redirect("updateTuitionPage.aspx");
}
}
