public async Task <CheckListItems> UpdateItem(CheckListItems item)
{
using (IDbConnection conn = Connection){
CheckListItems _item = new CheckListItems {
CLITEMID = item.CLITEMID,
ITEMTITLE = item.ITEMTITLE,
USERID = item.USERID,
CHECKLISTID = item.CHECKLISTID,
ISCHECKED = item.ISCHECKED
};
var _params = new DynamicParameters();
_params.Add("@itemtitle", _item.ITEMTITLE);
_params.Add("@userid", _item.USERID);
_params.Add("@checklistid", _item.CHECKLISTID);
_params.Add("@ischecked", _item.ISCHECKED);
_params.Add("@clitemid", _item.CLITEMID);
string sQuery = @"update CHECKLISTITEMS set ";
sQuery += " ITEMTITLE=@itemtitle,";
sQuery += " ISCHECKED=@ischecked, ";
sQuery += " USERID=@USERID, ";
sQuery += " CHECKLISTID=@CHECKLISTID ";
sQuery += " where CLITEMID=@clitemid";
var affectedRows = await conn.ExecuteAsync(sQuery, _params);
if (affectedRows == 0)
{
return(null);
}
return(_item);
}
}
/// <summary>
/// Populate the list of checkboxes with teams' names,
/// And check the teams that are selected
/// </summary>
private void PopulateTeamsComboboxes()
{
CheckListItems.Clear();
//Get all team features from the layer
List <client.Graphic> allTeams = new List <client.Graphic>(teamFeatureLayer.Graphics);
//Listen to the property change event of each feature. Particularly, we will listen to the "Selected" property
foreach (client.Graphic team in allTeams)
{
team.PropertyChanged += team_PropertyChanged;
}
//Sort the names of all the teams for better presentation
List <string> allTeamNames = allTeams.Select(t => t.Attributes[nameAttribute].ToString()).ToList();
allTeamNames.Sort();
//populate the check list items
foreach (string teamName in allTeamNames)
{
MyCheckedListItem checkListItem = new MyCheckedListItem()
{
Caption = teamName,
IsChecked = recommendedTeams.Any(selectedTeam => selectedTeam.Attributes[nameAttribute].ToString() == teamName)
};
CheckListItems.Add(checkListItem);
}
}
public async Task <ActionResult <CheckListItems> > UpdateCheckListItem([FromBody] CheckListItems model)
{
var _item = new CheckListItems
{
CLITEMID = model.CLITEMID,
CHECKLISTID = model.CHECKLISTID,
ITEMTITLE = model.ITEMTITLE,
ISCHECKED = model.ISCHECKED,
USERID = model.USERID
};
var result = await _lists.UpdateItem(_item);
if (result == null)
{
return(BadRequest("Record is not updated 1"));
}
if (result.CLITEMID == -1)
{
return(BadRequest("Record is not updated 2"));
}
return(await Task.FromResult(result));
}
protected override void OnNavigatedTo(NavigationEventArgs e)
{
if (e.Parameter != null)
{
Advice advice = e.Parameter as Advice;
this.titlePathBox.TitlePath = advice?.Caption;
if (advice != null)
{
this._advice = advice;
this.PageTitle = advice.Caption;
Office o = advice.Office;
if (o != null)
{
this._office = o;
TimeSpan ts = o.GetMaxOpeningToday() - DateTime.Now;
if (ts.TotalMinutes > 0)
{
this._progress.Maximum = ts.TotalMinutes;
this._progress.Value = 10 + o.GetEstimatedWaitTimeInMinutes();
this.ExpectedNumber = (o.GetCurrentWaiting()).ToString();
this.ExpectedTime = DateTime.Now.AddMinutes(10 + o.GetEstimatedWaitTimeInMinutes()).ToString("h:mm tt");
}
else
{
this._progress.Maximum = 100;
this._progress.Value = 100;
this._progress.Foreground = new SolidColorBrush(Colors.DarkRed);
this.ExpectedNumber = "Closed";
}
}
foreach (CheckListItem item in advice.CheckListItems)
{
this.CheckListItems.Add(item);
}
bool allChecked = CheckListItems.All(checkListItem => checkListItem.IsChecked);
if (!allChecked)
{
this._officeGrid.Visibility = Visibility.Visible;
this._itemGrid.Visibility = Visibility.Collapsed;
this._lineGrid.Visibility = Visibility.Collapsed;
}
else
{
this._officeGrid.Visibility = Visibility.Collapsed;
this._itemGrid.Visibility = Visibility.Visible;
this._lineGrid.Visibility = Visibility.Collapsed;
this.EnableQueueNumberService = true;
if (o != null)
{
this._ticket = o.GetTicketForAdviceIfExists(DataService.Instance.CurrentAccount);
LoadTicket();
}
}
}
}
}
/// <summary>
/// When user selects/unselects a team feature on map, check/uncheck the corresponding check box on the team assignment page
/// </summary>
void team_PropertyChanged(object sender, System.ComponentModel.PropertyChangedEventArgs e)
{
if (e.PropertyName == "Selected")
{
client.Graphic team = sender as client.Graphic;
MyCheckedListItem checkListItem = CheckListItems.FirstOrDefault(item => item.Caption == team.Attributes[nameAttribute].ToString());
checkListItem.IsChecked = team.Selected;
}
}
/// <summary>
/// Open the form and get a return value.
/// </summary>
/// <param name="context"></param>
protected override void DoWork(CodeActivityContext context)
{
// Title for the complete form
string dialogCaption = String.IsNullOrEmpty(DialogCaption.Get(context)) ? " " : DialogCaption.Get(context);
// Inputs for the Radio Group box
string radioGroupTitle = String.IsNullOrEmpty(RadioGroupTitle.Get(context)) ? " " : RadioGroupTitle.Get(context);
List <string> radioGroupItems = RadioGroupItems.Get(context);
int rgIndex = RadioGroupIndex.Expression != null?RadioGroupIndex.Get(context) : -1;
// Inputs for the Check list box
string checkListTitle = String.IsNullOrEmpty(CheckListTitle.Get(context)) ? " " : CheckListTitle.Get(context);
List <string> checkListItems = CheckListItems.Get(context);
var form = new RadioGroupWithCheckListForm
{
RadioGroupItems = radioGroupItems,
Text = dialogCaption,
RadioGroupMessage = radioGroupTitle,
DefaultIndex = rgIndex,
CheckListMessage = checkListTitle,
CheckListItems = checkListItems
};
// Default to -1 for the Radio Group index and set all to False for the Check List
RadioGroupResult.Set(context, -1);
if (checkListItems != null)
{
List <bool> tempList = new List <bool>();
for (int i = 0; i < checkListItems.Count; i++)
{
tempList.Add(false);
}
CheckListResult.Set(context, tempList);
}
// Do not show the dialog if no items to show
if ((radioGroupItems == null) && (checkListItems == null))
{
return;
}
DialogResult result = form.ShowDialog();
if (result == System.Windows.Forms.DialogResult.OK)
{
RadioGroupResult.Set(context, form.SelectedIndex);
CheckListResult.Set(context, form.CheckListBoxResult);
}
DialogResult.Set(context, result);
}
/// <summary>
/// When user clicks the button, check if there's any selected team and the message to send is empty
/// If there is/are selected team(s) and the message is not empty, send the SMS
/// </summary>
private void btnAssign_Click(object sender, RoutedEventArgs e)
{
#region Error checking: no team selected or empty message
if (CheckListItems.Any(i => i.IsChecked) == false || string.IsNullOrEmpty(txtMessage.Text))
{
MessageBox.Show("Make sure one or more team is selected, and the message is not empty");
return;
}
#endregion
try
{
#region Get the selected teams and check if they have already been assigned to the designated area
//1. Get the captions of the checked list items
var checkedItemCaptions = from item in CheckListItems
where item.IsChecked == true
select item.Caption;
//2. Fom the caption, get the actual team items that are now checked
seletcedTeams = teamFeatureLayer.Graphics.Where(team => checkedItemCaptions.Contains(team.Attributes[nameAttribute].ToString())).ToList();
//3. Check if the same teams have already been assigned. Do not allow assignment if all selected teams have been assiged to that area
if (seletcedTeams.Any(team => team.Attributes[areaAttribute].ToString() != searchAreaName) == false)
{
MessageBox.Show("Teams have been assigned to the designated area already", "Teams Assigned ");
return;
}
#endregion
#region Update team assignment
//Assign teams by updating their SearchAreaName attributes
foreach (client.Graphic team in seletcedTeams)
{
team.Attributes[areaAttribute] = searchAreaName;
}
//Save the edits
commitEditCount = 0;
teamFeatureLayer.EndSaveEdits += teamFeatureLayer_EndSaveEdits;
teamFeatureLayer.SaveEdits();
#endregion
}
catch (Exception)
{
MessageBox.Show("Error sending message");
this.Close();
}
}
public async Task <CheckListItems> AddItem(CheckListItems item)
{
using (IDbConnection conn = Connection){
CheckListItems _item = new CheckListItems {
CLITEMID = -1,
ITEMTITLE = item.ITEMTITLE,
USERID = item.USERID,
CHECKLISTID = item.CHECKLISTID,
ISCHECKED = item.ISCHECKED
};
var _params = new DynamicParameters();
_params.Add("@itemtitle", _item.ITEMTITLE);
_params.Add("@userid", _item.USERID);
_params.Add("@checklistid", _item.CHECKLISTID);
_params.Add("@ischecked", _item.ISCHECKED);
_params.Add(name: "@v_clitemid", value: _item.CLITEMID, dbType: DbType.Int64,
direction: ParameterDirection.InputOutput);
string sQuery = @" begin ";
sQuery += " insert into CHECKLISTITEMS(ITEMTITLE,ISCHECKED,CHECKLISTID,USERID)";
sQuery += " values (@ITEMTITLE,@ISCHECKED,@CHECKLISTID,@USERID) ";
sQuery += " set @v_clitemid=SCOPE_IDENTITY()";
sQuery += " end ";
//try{
var affectedRows = await conn.ExecuteAsync(sQuery, _params);
if (affectedRows > 0)
{
Int64 newListId = _params.Get <Int64>("@v_clitemid");
_item.CLITEMID = newListId;
}
// }catch(Exception ex){
// return null;
// }
return(_item);
}
}
private void OnCheckListTapped(object sender, TappedRoutedEventArgs e)
{
bool allChecked = CheckListItems.All(checkListItem => checkListItem.IsChecked);
this.EnableQueueNumberService = allChecked;
}
