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