/// <summary>
/// Opens the Connection Create Dialog
/// </summary>
/// <param name="sender">The sender.</param>
/// <param name="e">The <see cref="RoutedEventArgs"/> instance containing the event data.</param>
private void Btn_OpenCreateNewConnection_Click(object sender, RoutedEventArgs e)
{
using (ConnectionManger connectionManger = new ConnectionManger())
{
connectionManger.ShowDialog();
this.ReloadConnections();
}
}
protected void btnReject_Click(object sender, EventArgs e)
{
connectionManger = new ConnectionManger();
Session["Result"] = "Rejected";
Session["AdminReflex"] = txtRequestID.Text;
string str = "update Request set AdminVIPApproval = 0 where RequestId = '" + txtRequestID.Text + "'";
connectionManger.ConnMan(str);
}
protected void ddlLocation_SelectedIndexChanged1(object sender, EventArgs e)
{
connectionManger = new ConnectionManger();
string QueryForCascading = "SELECT CanteenId, CanteenName FROM Canteen WHERE LocationId = " + ddlLocation.SelectedValue;
DataSet dataSet = connectionManger.Fill(QueryForCascading);
if (dataSet.Tables[0].Rows.Count > 0)
{
ddlCanteen.DataSource = dataSet.Tables[0];
ddlCanteen.DataTextField = "CanteenName";
ddlCanteen.DataValueField = "CanteenId";
ddlCanteen.DataBind();
ddlCanteen.Items.Insert(0, "--Select--");
}
}
private void AutoFillLoc()
{
connectionManger = new ConnectionManger();
string QueryForAutoFillingLoc = "SELECT LocationId, LocationName FROM Location";
DataSet dataSet = connectionManger.Fill(QueryForAutoFillingLoc);
if (dataSet.Tables[0].Rows.Count > 0)
{
ddlLocation.DataSource = dataSet.Tables[0];
ddlLocation.DataTextField = "LocationName";
ddlLocation.DataValueField = "LocationId";
ddlLocation.DataBind();
//ddlLocation.Items.Insert(0, "--Select--");
}
}
protected void DropDownListCanteen_SelectedIndexChanged(object sender, EventArgs e)
{
string QueryForNoOfRequest = "select count(*) as NoOfRequests from Request group by DATEPART(mm, FromDate),LocId,CanteenId having DATEPART(mm, FromDate) =" + ddlMonth.SelectedValue + " and LocId =" + ddlLocation.SelectedValue + " and CanteenId =" + ddlCanteen.SelectedValue;
connectionManger = new ConnectionManger();
txtNoOfRequest.Text = connectionManger.Selection(QueryForNoOfRequest, "RequestId");
string QueryForNoOfConsumed = "select count(*) as NoOfConsumed from Request R full outer join ServedDetails S on R.RequestId = S.RequestId where S.IfServed = 1 group by DATEPART(mm, R.FromDate) ,LocId,CanteenId having DATEPART(mm, R.FromDate) = " + ddlMonth.SelectedValue + " and LocId =" + ddlLocation.SelectedValue + " and CanteenId =" + ddlCanteen.SelectedValue;
connectionManger = new ConnectionManger();
txtNoOfRequest.Text = connectionManger.Selection(QueryForNoOfConsumed, "RequestId");
string QueryForNoOfTotalCost = "select SUM(S.Cost) as TotalCost from Request R full outer join ServedDetails S on R.RequestId = S.RequestId where S.IfServed = 1 group by DATEPART(mm, FromDate) ,LocId,CanteenId having DATEPART(mm, FromDate) =" + ddlMonth.SelectedValue + " and LocId =" + ddlMonth.SelectedValue + " and CanteenId =" + ddlCanteen.SelectedValue;
connectionManger = new ConnectionManger();
txtTotalCost.Text = connectionManger.Selection(QueryForNoOfConsumed, "Cost");
}
public RedisSubPub()
{
_subscriber = ConnectionManger.GetSubscriber();
}
