private void btnAdd_Click(object sender, EventArgs e)
{
int times = 0; int cyclenum = 0; string cycleunit = string.Empty;
var type = getFrequencyInfo(ref times, ref cyclenum, ref cycleunit);
var model = new Model.Schedule();
model.Name = txtName.Text;
model.Note = txtNote.Text;
model.FrequencyType = type;
model.StartDate = Convert.ToDateTime(dtpickStart.Text);
//model.EndDate = Convert.ToDateTime("1900-01-01 00:00:00");
model.FrequencyTimes = times;
model.FrequencyCycleNum = cyclenum;
model.FrequencyCycleUnit = cycleunit;
model.CreatedOn = DateTime.Now;
model.CreatedBy = "";
model.ModifedOn = DateTime.Now;
model.ModifiedBy = "";
model.Deleted = false;
var result = ScheduleAdapter.Insert(model);
if (result)
{
MessageBox.Show("Succeed ^_^");
}
}
/// <summary>
/// Initializes a new instance of the ScheduleAdapterConnectionFactory class
/// </summary>
public ScheduleAdapterConnectionFactory(ConnectionUri connectionUri
, ClientCredentials clientCredentials
, ScheduleAdapter adapter)
{
this.clientCredentials = clientCredentials;
this.adapter = adapter;
ConnectionUri = connectionUri as ScheduleAdapterConnectionUri;
}
public override void OnCreate(Bundle savedInstanceState)
{
base.OnCreate(savedInstanceState);
using (var sr = new StreamReader (Activity.Assets.Open ("calendar.json"))) {
var json = sr.ReadToEnd ();
items = schedRepo.GetCalendarItems(json);
}
_adapter = new ScheduleAdapter (Activity, items);
ListAdapter = _adapter;
SetHasOptionsMenu (true);
_spinnerAdapter = new ArrayAdapter (Activity, Resource.Array.filter_division);
Activity.ActionBar.NavigationMode = ActionBarNavigationMode.List;
Activity.ActionBar.SetListNavigationCallbacks (_spinnerAdapter, new ScreenNavigationListener (Activity, _spinnerAdapter));
}
private void bind()
{
// All Schedules
var scheduleList = ScheduleAdapter.Query("AND FrequencyType<>'Only Once'");
// All Records
var recordList = new List <Model.Record>();
#region ToDoList bind
scheduleList.ForEach(x =>
{
var status = recordList.Exists(y => y.ScheduleID != null && y.ScheduleID == x.ID)
? (recordList.FirstOrDefault(y => y.ScheduleID == x.ID).Status)
: 0;
var statusname = status == 1 ? "Done" : (status == 2 ? "Fail":"");
var frequenctytype = string.Empty;
switch (x.FrequencyType)
{
case "Custom":
frequenctytype = x.FrequencyTimes.ToString() + " Times " + x.FrequencyCycleNum.ToString() + " " + x.FrequencyCycleUnit;
break;
default:
frequenctytype = x.FrequencyType;
break;
}
ListViewItem lvitem = new ListViewItem();
lvitem.Name = x.Name;
lvitem.SubItems.Add(frequenctytype);
lvitem.SubItems.Add(statusname);
lvToDoList.Items.Add(lvitem);
});
#endregion
#region OtherRecord bind
// 获取当天的所有记录
#endregion
}
public void UpdateTable(string tablename, ScheduleServicesDS ds)
{
ScheduleAdapter a = new ScheduleAdapter(DbConnection, DbTransaction);
a.UpdateTable(tablename, ds);
}
public void FillSchedule(ScheduleServicesDS ds, bool soloNonEseguiti)
{
ScheduleAdapter a = new ScheduleAdapter(DbConnection, DbTransaction);
a.FillSchedule(ds, soloNonEseguiti);
}
private void bind()
{
var list = ScheduleAdapter.Query();
}
/// <summary>
/// Instantiate the adapter.
/// </summary>
/// <returns></returns>
protected override BindingElement CreateBindingElement()
{
ScheduleAdapter adapter = new ScheduleAdapter();
this.ApplyConfiguration(adapter);
return adapter;
}
