public ObservableCollection <Models.ListItem> GetAll()
{
var db = this.conn;
var view = new ObservableCollection <Models.ListItem>();
try
{//UPDATE Customer SET Name = ?, City = ?, Contact = ? WHERE Id=?
using (var statement = db.Prepare("SELECT * FROM item"))
{
while (statement.Step() == SQLiteResult.ROW)
{
var temp = ((string)statement[3]).Split('/');
var date1 = new DateTime(int.Parse(temp[2]), int.Parse(temp[0]), int.Parse(temp[1]));
var date = new DateTimeOffset(date1);
var titem = new Models.ListItem((string)statement[1], (string)statement[2], date,
(string)statement[4], (string)statement[0], ((Int64)statement[5]) == Int64.Parse("1") ? true : false);
view.Add(titem);
}
}
return(view);
}
catch (Exception ex)
{
// TODO: Handle error
return(view);
}
}
async public void UpdateListItem(string id, string title, string description, DateTime date, WriteableBitmap imageSource)
{
for (int i = 0; i < allItems.Count; ++i)
{
if (allItems[i].GetID() == id)
{
allItems[i].Title = title;
allItems[i].description = description;
allItems[i].date = date;
allItems[i].ImageSource = imageSource;
using (var conn = new SQLiteConnection("MyListDB.db"))
{
using (var statement = conn.Prepare("UPDATE ListItemTable SET Title = ?, Detail = ?, Date = ?, Complete = ?, Image = ? WHERE Id = ?"))
{
statement.Bind(1, title);
statement.Bind(2, description);
statement.Bind(3, date.ToString());
statement.Bind(4, allItems[i].Completed.ToString());
statement.Bind(5, await ImageTools.SaveToBytesAsync(allItems[i].ImageSource));
statement.Bind(6, id);
statement.Step();
}
}
}
}
selectedItem = null;
}
private ListItemViewModels()
{
selectedItem = null;
var db = App.conn;
using (var statement = db.Prepare(App.SQL_QUERY_VALUE))
{
while (SQLitePCL.SQLiteResult.ROW == statement.Step())
{
this.allItems.Add(new Models.ListItem(statement[0].ToString(), statement[1].ToString(),
Convert.ToDateTime(statement[2].ToString()), Convert.ToBoolean(statement[3].ToString()),
statement[4].ToString(), Convert.ToInt32(statement[5])));
}
}
/*
* ImageSource imgSource1 = new BitmapImage(new Uri("ms-appx:///Assets/Pics/1.jpg"));
* ImageSource imgSource2 = new BitmapImage(new Uri("ms-appx:///Assets/Pics/2.jpg"));
* ImageSource imgSource3 = new BitmapImage(new Uri("ms-appx:///Assets/Pics/3.jpg"));
* ImageSource imgSource4 = new BitmapImage(new Uri("ms-appx:///Assets/Pics/4.jpg"));
* Models.ListItem item1 = new Models.ListItem("数据结构", "Data Structure", DateTime.Now, imgSource1);
* item1.completed = true;
* Models.ListItem item2 = new Models.ListItem("现代操作系统应用开发", "MOSAD", DateTime.Now, imgSource2);
* allItems.Add(item1);
* allItems.Add(item2);
* allItems.Add(new Models.ListItem("操作系统（OS）", "Opreation System", DateTime.Now, imgSource3));
* allItems.Add(new Models.ListItem("计算机组成原理与接口技术", "Computer Organization and Design", DateTime.Now, imgSource4));
*/
}
private async Task ClearFilter()
{
competenceArea = competenceAreas.FirstOrDefault();
availableFrom = null;
organization = organizations.FirstOrDefault();
await UpdateFilter();
}
private ListItemViewModels()
{
allItems = Db.GetInstance().GetAll();
seleted = false;
editing_item = new Models.ListItem();
seleteItem = -1;
}
public IHttpActionResult PutListItem(int id, Models.ListItem listItem)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != listItem.ListItemID)
{
return(BadRequest());
}
db.Entry(listItem).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!ListItemExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public UpdateResult SetActiveStatus(string id, bool active, string lastUpdateUsername)
{
return(Execute(context =>
{
Guid lastUpdateAccountId = context.Accounts.Single(a => a.Username == lastUpdateUsername).AccountId;
Guid accountId = BaseModel.DecryptId(id);
if (lastUpdateAccountId == accountId)
{
return new UpdateResult("Cannot update your own status");
}
Models.ListItem listItem = DataAccess.ListItem.GetListItem("Status", active ? "Active" : "InActive");
Data.Account account = context.Accounts.Single(acc => acc.AccountId == accountId);
account.StatusId = listItem.GUID;
WriteAudit(context, lastUpdateAccountId);
account.LastUpdateAccountId = account.AccountId;
account.LastUpdateTimestamp = DateTime.Now;
context.SaveChanges();
return new UpdateResult(true);
}));
}
public void UpdateListItem(ImageSource img, double size, string title, string detail, DateTimeOffset date)
{
this.selectedItem.Img = img;
this.selectedItem.Size = size;
this.selectedItem.Title = title;
this.selectedItem.Detail = detail;
this.selectedItem.Date = date;
this.selectedItem = null;
}
public IHttpActionResult GetListItem(int id)
{
Models.ListItem listItem = db.ListItems.Find(id);
if (listItem == null)
{
return(NotFound());
}
return(Ok(listItem));
}
public void RemoveTodoItem(string id)
{
for (int i = 0; i < allItems.Count; i++)
{
if (allItems[i].id == id)
{
this.allItems.RemoveAt(i);
}
}
// set selectedItem to null after remove
this.selectedItem = null;
}
public IHttpActionResult PostListItem(Models.ListItem listItem)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.ListItems.Add(listItem);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = listItem.ListItemID }, listItem));
}
public IHttpActionResult DeleteListItem(int id)
{
Models.ListItem listItem = db.ListItems.Find(id);
if (listItem == null)
{
return(NotFound());
}
db.ListItems.Remove(listItem);
db.SaveChanges();
return(Ok(listItem));
}
public void UpdateTodoItem(string id, string title, string description, DateTime date, ImageSource img)
{
for (int i = 0; i < allItems.Count; i++)
{
if (allItems[i].id == id)
{
allItems[i].title = title;
allItems[i].description = description;
allItems[i].date = date;
allItems[i].img = img;
break;
}
}
// set selectedItem to null after update
this.selectedItem = null;
}
public Models.UpdateResult SaveListItem(Models.ListItem model)
{
return(Execute(context =>
{
Guid lastUpdateAccountId = context.Accounts.Single(a => a.Username == model.LastUpdateUsername).AccountId;
Data.ListItem listItem;
if (!string.IsNullOrEmpty(model.ID))
{
Guid listItemId = BaseModel.DecryptId(model.ID);
listItem = context.ListItems.Single(li => li.ListItemId == listItemId);
if (listItem.LastUpdateTimestamp.Ticks != model.Age)
{
return new UpdateResult(UpdateResult.ResultType.DataChanged);
}
}
else
{
listItem = new Data.ListItem
{
ParentId = BaseModel.DecryptNullableId(model.ParentID),
StatusId = GetListItem("Status", "Active").GUID
};
context.ListItems.Add(listItem);
}
if (!string.IsNullOrWhiteSpace(model.Name))
{
listItem.Name = model.Name;
}
listItem.Description = model.Description;
listItem.SortOrder = model.SortOrder;
listItem.Code = model.Code;
listItem.Value = model.Value;
WriteAudit(context, lastUpdateAccountId);
listItem.LastUpdateAccountId = lastUpdateAccountId;
listItem.LastUpdateTimestamp = DateTime.Now;
context.SaveChanges();
return new UpdateResult(true);
}));
}
async public void AddListItem(string title, string description, DateTime date, WriteableBitmap imageSource)
{
ListItem item = new Models.ListItem(title, description, date, imageSource);
this.allItems.Add(item);
using (var conn = new SQLiteConnection("MyListDB.db"))
{
using (var statement = conn.Prepare("INSERT INTO ListItemTable (Id, Title, Detail, Date, Complete, Image) VALUES (?, ?, ?, ?, ?, ?)"))
{
statement.Bind(1, item.GetID());
statement.Bind(2, title);
statement.Bind(3, description);
statement.Bind(4, date.ToString());
statement.Bind(5, item.Completed.ToString());
statement.Bind(6, await ImageTools.SaveToBytesAsync(item.ImageSource));
statement.Step();
}
}
}
public void RemoveListItem(string id)
{
for (int i = 0; i < allItems.Count; ++i)
{
if (allItems[i].GetID() == id)
{
using (var conn = new SQLiteConnection("MyListDB.db"))
{
using (var statement = conn.Prepare("DELETE FROM ListItemTable WHERE Id = ?"))
{
statement.Bind(1, id);
statement.Step();
}
}
allItems.RemoveAt(i); break;
}
}
selectedItem = null;
}
/*public static XmlDocument CreateTiles(Models.ListItem item)
* {
* XDocument xDoc = new XDocument(
* new XElement("tile", new XAttribute("version", 3),
* new XElement("visual",
* // Small Tile
* new XElement("binding", new XAttribute("branding", "none"),
* new XAttribute("displayName", "qqq"), new XAttribute("template", "TileSmall")
* ),
*
* // Medium Tile
* new XElement("binding", new XAttribute("branding", "name"),
* new XAttribute("displayName", "www"), new XAttribute("template", "TileMedium"),
* new XElement("group",
* new XElement("subgroup",
* new XElement("text", item.Plan_date, new XAttribute("hint-style", "caption")),
* new XElement("text", item.Title,
* new XAttribute("hint-style", "captionsubtle"), new XAttribute("hint-wrap", true),
* new XAttribute("hint-maxLines", 3))
* )
* )
* ),
*
* // Wide Tile
* new XElement("binding", new XAttribute("branding", "name"),
* new XAttribute("displayName", "eee"), new XAttribute("template", "TileWide"),
* new XElement("group",
* new XElement("subgroup",
* new XElement("text", item.Plan_date, new XAttribute("hint-style", "caption")),
* new XElement("text", item.Title,
* new XAttribute("hint-style", "captionsubtle"), new XAttribute("hint-wrap", true),
* new XAttribute("hint-maxLines", 3)),
* new XElement("text", item.Content,
* new XAttribute("hint-style", "captionsubtle"), new XAttribute("hint-wrap", true),
* new XAttribute("hint-maxLines", 3))
* ),
* new XElement("subgroup", new XAttribute("hint-weight", 15),
* new XElement("image", new XAttribute("placement", "inline"),
* new XAttribute("src", "Assets/StoreLogo.png"))
* )
* )
* ),
*
* //Large Tile
* new XElement("binding", new XAttribute("branding", "title"),
* new XAttribute("displayName", "rrr"), new XAttribute("template", "TileLarge"),
* new XElement("group",
* new XElement("subgroup",
* new XElement("text", item.Plan_date, new XAttribute("hint-style", "caption")),
* new XElement("text", item.Title,
* new XAttribute("hint-style", "captionsubtle"), new XAttribute("hint-wrap", true),
* new XAttribute("hint-maxLines", 3)),
* new XElement("text", item.Content,
* new XAttribute("hint-style", "captionsubtle"), new XAttribute("hint-wrap", true),
* new XAttribute("hint-maxLines", 3))
* ),
* new XElement("subgroup", new XAttribute("hint-weight", 15),
* new XElement("image", new XAttribute("placement", "inline"),
* new XAttribute("src", "Assets/StoreLogo.png"))
* )
* )
* )
* )
* )
* );
*
* XmlDocument xmlDoc = new XmlDocument();
* xmlDoc.LoadXml(xDoc.ToString());
* //Debug.WriteLine(xDoc);
* return xmlDoc;
* }*/
public static void Update(Models.ListItem item)
{
// In a real app, these would be initialized with actual data
string time = item.Plan_date.ToString();
string subject = item.Title;
string body = item.Content;
// Construct the tile content
TileContent content = new TileContent()
{
Visual = new TileVisual()
{
TileSmall = new TileBinding()
{
Content = new TileBindingContentAdaptive()
{
BackgroundImage = new TileBackgroundImage()
{
Source = "Assets/StoreLogo.png"
},
Children =
{
}
}
},
TileMedium = new TileBinding()
{
Content = new TileBindingContentAdaptive()
{
BackgroundImage = new TileBackgroundImage()
{
Source = item.ImagePath
},
Children =
{
new AdaptiveText()
{
Text = subject
},
new AdaptiveText()
{
Text = body,
HintStyle = AdaptiveTextStyle.CaptionSubtle
},
new AdaptiveText()
{
Text = time,
HintStyle = AdaptiveTextStyle.CaptionSubtle
}
}
}
},
TileWide = new TileBinding()
{
Content = new TileBindingContentAdaptive()
{
BackgroundImage = new TileBackgroundImage()
{
Source = item.ImagePath
},
Children =
{
new AdaptiveText()
{
Text = subject
},
new AdaptiveText()
{
Text = body,
HintStyle = AdaptiveTextStyle.CaptionSubtle
},
new AdaptiveText()
{
Text = time,
HintStyle = AdaptiveTextStyle.CaptionSubtle
}
}
}
}
}
};
// Then create the tile notification
var notification = new TileNotification(content.GetXml());
TileUpdateManager.CreateTileUpdaterForApplication().EnableNotificationQueue(true);
// And send the notification
TileUpdateManager.CreateTileUpdaterForApplication().Update(notification);
}
private async Task OnInitialize()
{
try
{
var foo = Mapper.ProjectTo <Models.ListItem>((
await CompetenceAreasClient.GetCompetenceAreasAsync()).AsQueryable()).ToList();
foo.Insert(0, new Models.ListItem()
{
Id = null, Name = "All"
});
competenceAreas = foo;
competenceArea = competenceAreas.FirstOrDefault();
}
/* catch (ApiException exc)
* {
* }
* catch (HttpRequestException exc)
* {
* } */
catch (Exception exc)
{
await JSHelpers.Alert(exc.Message);
}
try
{
var foo = Mapper.ProjectTo <Models.ListItem>((
await OrganizationsClient.GetOrganizationsAsync()).AsQueryable()).ToList();
foo.Insert(0, new Models.ListItem()
{
Id = null, Name = "All"
});
organizations = foo;
organization = organizations.FirstOrDefault();
}
/*catch (ApiException exc)
* {
*
* }
* catch (HttpRequestException exc)
* {
*
* }*/
catch (Exception exc)
{
await JSHelpers.Alert(exc.Message);
}
try
{
var result = await ConsultantGalleryClient.GetConsultantsAsync(pageNumber ++, numberOfItemsPerPage, null, null, null);
consultants = new List <ProfileShort>();
consultants.AddRange(result.Items);
total = result.TotalItems;
}
/*catch (ApiException exc)
* {
*
* }
* catch (HttpRequestException exc)
* {
*
* }*/
catch (Exception exc)
{
await JSHelpers.Alert(exc.Message);
}
}
public void RemoveListItem(Models.ListItem SelectedItem1)
{
this.allItems.Remove(SelectedItem1);
this.selectedItem = null;
}
public ListItemViewModel()
{
this.selectedItem = null;
}
