public void loadRequest()
{
requestBO load = new requestBO();
studentGV.DataSource = load.loadAllStudent();
studentGV.DataBind();
}
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();
}
public void loadRequestByMeData()
{
requestBO getReqeuestByMe = new requestBO();
String requestBy = Request.Cookies["CurrentLoggedInUser"].Value;
requestByMeGV.DataSource = getReqeuestByMe.loadRequestByMe(requestBy);
requestByMeGV.DataBind();
}
public void loadRequestToMeData()
{
requestBO getRequest = new requestBO();
String requestTo = Request.Cookies["CurrentLoggedInUser"].Value;
RequestToMeGV.DataSource = getRequest.loadRequestToMe(requestTo);
RequestToMeGV.DataBind();
}
protected void Form_Request_ItemInserting(object sender, FormViewInsertEventArgs e)
{
try
{
_rqstbo = CreateRequest();
_rqstbo.InsUpdFlag = 0;
_rqstbo.statusId = 1;
_rqstbo.assignedTo = 1;
if (Session["UserBO"] == null)
{
Response.Redirect("Login.aspx", false);
}
else
{
_userBO = new UserBO();
_userBO = (UserBO)Session["UserBO"];
// change after adding branch drop down for admin
if (_userBO.RoleID == 1)
{
_rqstbo.branchId = 1;
}
else
{
_rqstbo.branchId = _userBO.BranchID;
}
}
// change after login page
_rqstbl = new requestBL();
var tranid = _rqstbl.insertUpdateRequest(_rqstbo);
if (!(tranid.Equals(0)))
{
lblMessage.Text = "Request placed succesfully";
lblMessage.Visible = true;
Form_Request.ChangeMode(FormViewMode.ReadOnly);
FillRequestDetails(tranid);
FillStatusDropDown(tranid);
lblWmsIdValue.Text = tranid.ToString();
}
else
{
lblMessage.Text = "Request creation failed. Please try again";
lblMessage.Visible = true;
}
}
catch (Exception ex)
{
Session["wmsId"] = null;
throw;
}
finally
{
_rqstbo = null;
_rqstbl = null;
}
}
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;
}
}
}
protected void requestPointsGV_SelectedIndexChanged(object sender, EventArgs e)
{
requestBO getDetails = new requestBO();
eventBO test = new eventBO();
AllocationToRequestPointsPanel.Visible = true;
AllocationToTutionPointsPanel.Visible = false;
allocatePanel.Visible = false;
GridViewRow row = requestPointsGV.SelectedRow;
string status;
String requestTo = "";
requestTo = Convert.ToString(requestPointsGV.SelectedRow.Cells[0].Text);
// status = Convert.ToString(viewParticipatorsGV.SelectedRow.Cells[5].Text);
}
protected void cancelRequestBtn_Click(object sender, EventArgs e)
{
requestBO setStatus = new requestBO();
string confirmValue = Request.Form["confirm_value"];
if (confirmValue == "Yes")
{
//clear all input
string status = "canceled";
int requestId = Convert.ToInt32(requestByMeGV.SelectedRow.Cells[0].Text);
setStatus.acceptRequest(requestId, status);
requestByMeDetailsPanel.Visible = true;
loadRequestByMeData();
string display = "Request is Canceled";
ClientScript.RegisterStartupScript(this.GetType(), "Request is Canceled successfully!", "alert('" + display + "');", true);
viewRequestToMePanel.Visible = false;
requestToMeDetailsPanel.Visible = false;
//request by me panel
viewRequestByMePanel.Visible = true;
requestByMeDetailsPanel.Visible = false;
//session created by me
sessionDetailsPanel.Visible = false;
SessionByMePanel.Visible = false;
SessionCreatedByMeBtn.Visible = true;
loadRequestToMeData();
}
else
{
string display = "Request is not Canceled!";
ClientScript.RegisterStartupScript(this.GetType(), "Request is not Canceled!", "alert('" + display + "');", true);
viewRequestToMePanel.Visible = false;
requestToMeDetailsPanel.Visible = false;
//request by me panel
viewRequestByMePanel.Visible = true;
requestByMeDetailsPanel.Visible = false;
//session created by me
sessionDetailsPanel.Visible = false;
SessionByMePanel.Visible = false;
SessionCreatedByMeBtn.Visible = true;
loadRequestToMeData();
}
}
public int insertUpdateRequest(requestBO rqstbo)
{
try
{
var cmd = new SqlCommand
{
CommandType = CommandType.StoredProcedure,
Connection = _sqlcon,
CommandText = "sp_rqst_InsUpd"
};
cmd.Parameters.Add("@BranchID", SqlDbType.Int).Value = rqstbo.branchId;
cmd.Parameters.Add("@PriorityID", SqlDbType.Int).Value = rqstbo.priorityId;
cmd.Parameters.Add("@AffectOperation", SqlDbType.NVarChar).Value = rqstbo.affectOperation;
cmd.Parameters.Add("@Scope", SqlDbType.VarChar).Value = rqstbo.scope;
cmd.Parameters.Add("@Floor", SqlDbType.Int).Value = rqstbo.floor;
cmd.Parameters.Add("@SectionID", SqlDbType.Int).Value = rqstbo.sectionId;
cmd.Parameters.Add("@OtherSection", SqlDbType.VarChar).Value = rqstbo.otherSection;
cmd.Parameters.Add("@Category", SqlDbType.VarChar).Value = rqstbo.categoryId;
cmd.Parameters.Add("@Remarks", SqlDbType.VarChar).Value = rqstbo.remarks;
cmd.Parameters.Add("@Requestor", SqlDbType.VarChar).Value = rqstbo.requestor;
cmd.Parameters.Add("@StatusID", SqlDbType.Int).Value = rqstbo.statusId;
cmd.Parameters.Add("@AssignedID", SqlDbType.Int).Value = rqstbo.assignedTo;
// cmd.Parameters.Add("@Flag", SqlDbType.VarChar).Value = rqstbo.flag;
cmd.Parameters.Add("@WMSID", SqlDbType.VarChar).Value = rqstbo.wmsId;
cmd.Parameters.Add("@InsUpd_Flag", SqlDbType.Int).Value = rqstbo.InsUpdFlag;
SqlParameter WMSID_Out = new SqlParameter("@WMSID_Out", SqlDbType.Int)
{
Direction = ParameterDirection.Output
};
cmd.Parameters.Add(WMSID_Out);
_sqlcon.Open();
cmd.ExecuteNonQuery();
int result = Convert.ToInt16(WMSID_Out.Value);
return(result);
}
catch (Exception ex)
{
return(0);
}
finally
{
_sqlcon.Close();
}
}
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();
}
}
protected void RaddPointsBtn_Click(object sender, EventArgs e)
{
string confirmValue = Request.Form["confirm_value"];
if (confirmValue == "Yes")
{
requestBO getDetails = new requestBO();
string requestTo = TuserIdLbl.Text;
// status = Convert.ToString(viewParticipatorsGV.SelectedRow.Cells[5].Text);
int ccaPoints = int.Parse(TCCAPointsLbl.Text.ToString());
int orion_points = int.Parse(TOrionPointsLbl.Text.ToString());
getDetails.givePoints(requestTo, ccaPoints, orion_points);
}
else
{
}
}
private requestBO CreateRequest()
{
_rqstbo = new requestBO();
try
{
var ddlpriority = (DropDownList)Form_Request.FindControl("ddlPriorityEdit");
_rqstbo.priorityId = Convert.ToInt16(ddlpriority.SelectedValue);
var ddlAffecting = (DropDownList)Form_Request.FindControl("ddlAffectingEdit");
_rqstbo.affectOperation = ddlAffecting.SelectedValue;
var txtScope = (TextBox)Form_Request.FindControl("txtScopeEdit");
_rqstbo.scope = txtScope.Text;
var ddlFloor = (DropDownList)Form_Request.FindControl("ddlFloorEdit");
_rqstbo.floor = Convert.ToInt16(ddlFloor.SelectedValue);
var ddlSection = (DropDownList)Form_Request.FindControl("ddlSectionEdit");
_rqstbo.sectionId = Convert.ToInt16(ddlSection.SelectedValue);
var txtOtherSection = (TextBox)Form_Request.FindControl("txtOtherSectionEdit");
_rqstbo.otherSection = txtOtherSection.Text;
var chkCategory = (CheckBoxList)Form_Request.FindControl("chkCategoryEdit");
string category = String.Join(", ", chkCategory.Items.Cast <ListItem>().Where(i => i.Selected));
_rqstbo.categoryId = category;
var txtRemarks = (TextBox)Form_Request.FindControl("txtRemarksEdit");
_rqstbo.remarks = txtRemarks.Text;
var txtRequestor = (TextBox)Form_Request.FindControl("txtRequestorEdit");
_rqstbo.requestor = txtRequestor.Text;
_rqstbo.createdDate = DateTime.Now;
_rqstbo.statusId = 1;
_rqstbo.assignedTo = 1;
}
catch (Exception ex)
{
lblMessage.Visible = true;
lblMessage.Text = "Something went wrong please try again";
}
return(_rqstbo);
}
protected void studentGV_SelectedIndexChanged(object sender, EventArgs e)
{
GridViewRow row = studentGV.SelectedRow;
requestBO getDetails = new requestBO();
//available session panels
tutionPanel.Visible = false;
detailsPanel.Visible = false;
//request panels
requestPanel.Visible = true;
detailsTable.Visible = true;
tutorListPanel.Visible = false;
String requestBy = Request.Cookies["CurrentLoggedInUser"].Value;
requestByLbl.Text = requestBy;
requestToLbl.Text = studentGV.SelectedRow.Cells[0].Text;
String checkRequestBy = requestToLbl.Text.ToString();
}
public void loadAllData()
{
if (Request.Cookies["CurrentLoggedInUser"].Value != null)
{
//creatorId = Session["userIdSession"].ToString();
//eventId = int.Parse(Session["eventIdSession"].ToString());
eventBO filltable = new eventBO();
sessionBO loadTable = new sessionBO();
requestBO fillGV = new requestBO();
String creatorId = Request.Cookies["CurrentLoggedInUser"].Value;
viewParticipatorsGV.DataSource = filltable.loadParticipatorList(creatorId);
viewParticipatorsGV.DataBind();
tutionPointsGV.DataSource = loadTable.getNumOfSession();
tutionPointsGV.DataBind();
requestPointsGV.DataSource = fillGV.getNumOfSession();
requestPointsGV.DataBind();
}
}
protected void sendRequestBtn_Click(object sender, EventArgs e)
{
String temprequestBy = requestByLbl.Text;
String temprequestTo = requestToLbl.Text;
if (temprequestBy.Equals(temprequestTo))
{
sendRequestBtn.Enabled = false;
}
Boolean valid = true;
if (valid == true)
{
String requestBy = Request.Cookies["CurrentLoggedInUser"].Value;
requestByLbl.Text = requestBy;
String requestTo = studentGV.SelectedRow.Cells[0].Text;
requestToLbl.Text = requestTo;
requestBO getDetails = new requestBO();
requestBy = requestByLbl.Text;
requestTo = requestToLbl.Text;
String status = "Pending";
String requestDetails = Request.Form["requestDetails"].ToString();
String currentEduLevel = Request.Cookies["Current_Edu_Level"].Value;
String eduLevelGV = studentGV.SelectedRow.Cells[1].Text;
getDetails.sendRequest(requestDetails, requestTo, requestBy, status);
string display = "Request Sent!";
ClientScript.RegisterStartupScript(this.GetType(), "Request Is successfully sent!", "alert('" + display + "');", true);
//available session panels
tutionPanel.Visible = false;
detailsPanel.Visible = false;
//request panels
tutorListPanel.Visible = true;
requestPanel.Visible = true;
detailsTable.Visible = false;
}
else if (valid == false)
{
String currentEduLevel = Request.Cookies["Current_Edu_Level"].Value;
String eduLevelGV = studentGV.SelectedRow.Cells[1].Text;
String requestByUser = requestByLbl.Text;
String requestToUser = requestToLbl.Text;
if (currentEduLevel == "Secondary")
{
if (eduLevelGV.Contains("Primary") == true)
{
string displayErr = "You cannot request to User that has lower education level than you!!";
ClientScript.RegisterStartupScript(this.GetType(), "You cannot request to User that has lower education level than you!", "alert('" + displayErr + "');", true);
valid = false;
}
}
else if (currentEduLevel == "JC")
{
if (eduLevelGV.Contains("Primary") == true)
{
string displayErr = "You cannot request to User that has lower education level than you!!";
ClientScript.RegisterStartupScript(this.GetType(), "You cannot request to User that has lower education level than you!", "alert('" + displayErr + "');", true);
valid = false;
}
else if (eduLevelGV.Contains("Secondary") == true)
{
string displayErr = "You cannot request to User that has lower education level than you!!";
ClientScript.RegisterStartupScript(this.GetType(), "You cannot request to User that has lower education level than you!", "alert('" + displayErr + "');", true);
valid = false;
}
}
}
else
{
string display = "Request Fail to Send!";
ClientScript.RegisterStartupScript(this.GetType(), "Request Fail to Send!", "alert('" + display + "');", true);
viewAllTutionPanel.Visible = false;
requestPanel.Visible = true;
}
}
public int insertUpdateRequest(requestBO objActivityBO)
{
requestDA objRequestDA = new requestDA();
return(objRequestDA.insertUpdateRequest(objActivityBO));
}
