protected void requestByMeGV_SelectedIndexChanged(object sender, EventArgs e) { requestBO getRequest = new requestBO(); viewRequestByMePanel.Visible = false; requestByMeDetailsPanel.Visible = true; //request to me viewRequestToMePanel.Visible = false; requestToMeDetailsPanel.Visible = false; //session by me sessionDetailsPanel.Visible = false; SessionByMePanel.Visible = false; SessionCreatedByMeBtn.Visible = true; GridViewRow row = requestByMeGV.SelectedRow; String requestBy = Request.Cookies["CurrentLoggedInUser"].Value; int requestId = Convert.ToInt32(requestByMeGV.SelectedRow.Cells[0].Text); requestEntity requestObj = getRequest.getRequestByMeByIdDetails(requestId, requestBy); myRequestId.Text = requestObj.requestId.ToString(); myRequestDetails.Text = requestObj.requestDetails.ToString(); myRequestTo.Text = requestObj.requestTo.ToString(); myRequestBy.Text = requestObj.requestBy.ToString(); myStatusLbl.Text = requestObj.status.ToString(); }
//filter request based on requestTo(current User is the tutor) public List <requestEntity> getTeachSessionList(String requestTo) { SqlDataAdapter da; DataSet ds = new DataSet(); //declare list to hold collection of events objs List <requestEntity> requestList = new List <requestEntity>(); //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 * from requestDB where requestTo = @pararequestTo"); //sqlCommand.AppendLine("from tutorSessionDB where tutorId = @paratutorId"); //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("@pararequestTo", requestTo); //fill dataset to table da.Fill(ds, "myRequestGV"); //if no record, set list to null int count = ds.Tables["myRequestGV"].Rows.Count; if (count == 0) { requestList = 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["myRequestGV"].Rows) { requestEntity objRequest = new requestEntity(); objRequest.requestId = Convert.ToInt32(row["requestId"]); objRequest.requestDetails = Convert.ToString(row["requestDetails"]); objRequest.requestTo = Convert.ToString(row["requestTo"]); objRequest.requestBy = Convert.ToString(row["requestBy"]); objRequest.status = Convert.ToString(row["status"]); requestList.Add(objRequest); } } return(requestList); }
//get request by me public requestEntity getRequestByMeByIdDetails(int requestId, String requestBy) { requestEntity result = null; result = objRequest.RequestByMeByIdDetails(requestId, requestBy); return(result); }
protected void updateBtn_Click(object sender, EventArgs e) { //statusDDL.SelectedValue = RequestToMeGV.SelectedRow.Cells[4].Text; requestBO setStatus = new requestBO(); requestEntity current_status = new requestEntity(); string status = statusDDL.SelectedValue; string tempStatus = current_status.status; if (tempStatus == "canceled") { cancelLbl.Visible = true; cancelLbl.Text = "This request was canceled by the requestee"; statusDDL.Visible = false; updateBtn.Enabled = false; } else { string confirmValue = Request.Form["confirm_value"]; if (confirmValue == "Yes") { //clear all input int requestId = Convert.ToInt32(RequestToMeGV.SelectedRow.Cells[0].Text); setStatus.acceptRequest(requestId, status); string display = "Request is Updated"; ClientScript.RegisterStartupScript(this.GetType(), "Request is updated successfully!", "alert('" + display + "');", true); loadRequestToMeData(); viewRequestToMePanel.Visible = true; 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; } else { string display = "Request not Updated!"; ClientScript.RegisterStartupScript(this.GetType(), "Request is not Updated!", "alert('" + display + "');", true); loadRequestToMeData(); viewRequestToMePanel.Visible = true; 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; } } }
//select the list of student to give points for students who accept request public List <requestEntity> getNumberOfRequestTeach() { SqlDataAdapter da; DataSet ds = new DataSet(); //declare list to hold collection of events objs List <requestEntity> requestTutionList = new List <requestEntity>(); //retrieve conn string from web config //done at class level //sql commant to select data from table StringBuilder sqlCommand = new StringBuilder(); sqlCommand.AppendLine("Select requestTo "); sqlCommand.AppendLine("from requestDB where status LIKE '%Completed%' GROUP BY requestTo HAVING COUNT(requestTo) > 2"); //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, "requestPointsGV"); //if no record, set list to null int count = ds.Tables["requestPointsGV"].Rows.Count; if (count == 0) { requestTutionList = 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["requestPointsGV"].Rows) { requestEntity objTuition = new requestEntity(); objTuition.requestTo = Convert.ToString(row["requestTo"]); // objTuition.tutorId = Convert.ToString(row["tutorId"]); requestTutionList.Add(objTuition); } } return(requestTutionList); }
//get requestToMe session details public requestEntity RequestToMeByIdDetails(int requestId, String requestTo) { SqlDataAdapter da; DataSet ds = new DataSet(); SqlCommand objCmd = new SqlCommand(); //declare list to hold collection of events objs requestEntity theRequest = new requestEntity(); //retrieve conn string from web config //done at class level //sql commant to select data from table StringBuilder sqlCommand = new StringBuilder(); sqlCommand.AppendLine("Select * "); sqlCommand.AppendLine("from requestDB where requestId= '" + requestId + "' and requestTo = '" + requestTo + "' "); //Instantiate sqlcommnd instance SqlConnection objsqlconn = new SqlConnection(DBConnect); objCmd = new SqlCommand(sqlCommand.ToString(), objsqlconn); //RETRIEVE RECORD USING DATAADAPTER da = new SqlDataAdapter(sqlCommand.ToString(), objsqlconn); objCmd.Parameters.AddWithValue("@pararequestTo", requestTo); //fill dataset to table da.Fill(ds, "RequestToMeGV"); //if no record, set list to null int count = ds.Tables["RequestToMeGV"].Rows.Count; if (count == 0) { theRequest = 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["RequestToMeGV"].Rows) { theRequest.requestId = Convert.ToInt32(row["requestId"]); theRequest.requestDetails = Convert.ToString(row["requestDetails"]); theRequest.requestTo = Convert.ToString(row["requestTo"]); theRequest.requestBy = Convert.ToString(row["requestBy"]); theRequest.status = Convert.ToString(row["status"]); } } return(theRequest); }
protected void RequestToMeGV_SelectedIndexChanged(object sender, EventArgs e) { requestBO getRequest = new requestBO(); viewRequestToMePanel.Visible = false; requestToMeDetailsPanel.Visible = true; //request by me panel viewRequestByMePanel.Visible = false; requestByMeDetailsPanel.Visible = false; //session created by me sessionDetailsPanel.Visible = false; SessionByMePanel.Visible = false; SessionCreatedByMeBtn.Visible = true; GridViewRow row = RequestToMeGV.SelectedRow; String requestTo = Request.Cookies["CurrentLoggedInUser"].Value; int requestId = Convert.ToInt32(RequestToMeGV.SelectedRow.Cells[0].Text); requestEntity requestObj = getRequest.getRequestToMeByIdDetails(requestId, requestTo); requestEntity current_status = new requestEntity(); string tempStatus = requestObj.status; if (tempStatus == "canceled") { cancelLbl.Visible = true; cancelLbl.Text = "This request was canceled by the requestee"; statusDDL.Visible = false; updateBtn.Enabled = false; requestIdLbl.Text = requestObj.requestId.ToString(); requestDetailsLbl.Text = requestObj.requestDetails.ToString(); requestToLbl.Text = requestObj.requestTo.ToString(); requestByLbl.Text = requestObj.requestBy.ToString(); //statusDDL.SelectedValue = requestObj.status.ToString(); } else { cancelLbl.Visible = false; statusDDL.Visible = true; updateBtn.Enabled = true; requestIdLbl.Text = requestObj.requestId.ToString(); requestDetailsLbl.Text = requestObj.requestDetails.ToString(); requestToLbl.Text = requestObj.requestTo.ToString(); requestByLbl.Text = requestObj.requestBy.ToString(); } }