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