private void RefreshAvailable() { AvailableGRD.Rows.Clear(); var dt = Scheduling.GetUnassignedGuards(_extraQueryParams, ContractStart, ContractEnd); foreach (DataRow row in dt.Rows) { if (!_gidS.Contains(int.Parse(row[0].ToString()))) { AvailableGRD.Rows.Add(row[0], row[1], row[2]); } } AvailableGRD.Columns[0].Visible = false; AvailableGRD.Columns[1].HeaderText = "NAME"; AvailableGRD.Columns[1].Width = 200; AvailableGRD.Columns[2].HeaderText = "LOCATION"; AvailableGRD.Columns[2].Width = 240; }
private void RefreshData() { var dt = Scheduling.GetAssignmentRequestDetails(Raid); ClientLBL.Text = dt.Rows[0]["name"].ToString(); PermAddLBL.Text = "Location: " + dt.Rows[0]["location"]; _contractStart = ContractStartLBL.Text = "Contract Start: " + dt.Rows[0]["contractstart"]; _contractEnd = ContractEndLBL.Text = "Contract End: " + dt.Rows[0]["contractend"]; _numGuards = int.Parse(dt.Rows[0]["noguards"].ToString()); NoLBL.Text = "Guards Needed: " + _numGuards; UnassignedPNL.Visible = false; if (dt.Rows[0]["rstatus"].ToString().Equals(Enumeration.RequestStatus.Pending.ToString())) { AssignBTN.Text = "APPROVE"; StatusLBL.Text = "Status: Pending"; if (Login.AccountType == 2) { AssignBTN.Visible = false; DeclineBTN.Visible = false; } ApprovedBy.Visible = false; } else if (dt.Rows[0]["rstatus"].ToString().Equals(Enumeration.RequestStatus.Approved.ToString())) { AssignBTN.Text = "ASSIGN"; StatusLBL.Text = "Status: Approved"; AssignBTN.Location = new Point(220, 411); if (Login.AccountType == 2) { AssignBTN.Visible = false; } DeclineBTN.Visible = false; ApprovedBy.Text = "Approved by: " + dt.Rows[0]["uname"]; } else { AssignBTN.Visible = false; AvailablePNL.Visible = false; DeclineBTN.Visible = false; if (dt.Rows[0]["rstatus"].ToString().Equals(Enumeration.RequestStatus.Active.ToString())) { StatusLBL.Text = "Status: Active"; ApprovedBy.Text = "Approved by: " + dt.Rows[0]["uname"]; UnassignedPNL.Visible = true; LoadRequestedGuard(); } else if (dt.Rows[0]["rstatus"].ToString().Equals(Enumeration.RequestStatus.Inactive.ToString())) { StatusLBL.Text = "Status: Inctive"; UnassignedPNL.Visible = true; LoadRequestedGuard(); } else if (dt.Rows[0]["rstatus"].ToString().Equals(Enumeration.RequestStatus.Declined.ToString())) { StatusLBL.Text = "Status: Decline"; ApprovedBy.Text = "Declined by: " + dt.Rows[0]["uname"]; } } NeededLBL.ForeColor = _numGuards > Scheduling.GetNumberOfUnassignedGuards() ? Color.Salmon : Color.OliveDrab; NeededLBL.Text = Scheduling.GetUnassignedGuards("", ContractStartLBL.Text, ContractEndLBL.Text).Rows.Count + " available guards"; }