public void AddEntry(String investmentTypeID, String entryName, int calculateType, int compoundingType, int calendarType, double initialPayment, double futurePayment, double rate, String timetoGet, String startTimeToGet, String endTimeToGet, int depositFlag, double depositPayment)
{
Guid newId = Guid.NewGuid();
TblEntry newItem = new TblEntry {
InvestmentTypeID = investmentTypeID, EntryName = entryName, CalculateType = calculateType, CompoundingType = compoundingType, CalendarType = calendarType, InitialPayment = (float)initialPayment, FuturePayment = (float)futurePayment, Rate = (float)rate, TimeToGet = timetoGet, StartTimeToGet = startTimeToGet, EndTimeToGet = endTimeToGet, DepositFlag = depositFlag, DepositPayment = (float)depositPayment, Deleted = 0
};
Insert(newItem);
}
public TblEntry GetEntryWithId(int uid)
{
try{
TblEntry entry = (from s in Table <TblEntry>() where s.ID == uid select s).FirstOrDefault();
return(entry);
}
catch (Exception ex) {
}
return(null);
}
public void UpdateEntryWithId(TblEntry entryItem)
{
Update(entryItem);
}
protected override void OnCreate(Bundle bundle)
{
base.OnCreate(bundle);
SetContentView(Resource.Layout.AddEntry);
_dateStart = _dateEnd = DateTime.Today;
ImageView imgBack = FindViewById <ImageView>(Resource.Id.imgBack);
imgBack.Click += imgBack_Click;
ImageView imgCalculate = FindViewById <ImageView>(Resource.Id.imgCalculate);
imgCalculate.Click += imgCalculate_Click;
ImageView imgSave = FindViewById <ImageView>(Resource.Id.imgSave);
imgSave.Click += imgSave_Click;
ImageButton imgSelectStartDate = FindViewById <ImageButton>(Resource.Id.imgSelectStartDate);
imgSelectStartDate.Click += imgSelectStartDate_Click;
ImageButton imgSelectEndDate = FindViewById <ImageButton>(Resource.Id.imgSelectEndDate);
imgSelectEndDate.Click += imgSelectEndDate_Click;
linearMuchInvesting = FindViewById <LinearLayout>(Resource.Id.linearMuchInvesting);
linearMuchFuture = FindViewById <LinearLayout>(Resource.Id.linearMuchFuture);
linearSelectCalendar = FindViewById <LinearLayout>(Resource.Id.linearSelectCalendar);
linearPeriod = FindViewById <LinearLayout>(Resource.Id.linearPeriod);
linearRate = FindViewById <LinearLayout>(Resource.Id.linearRate);
spinnerType = FindViewById <Spinner>(Resource.Id.spinnerInvestType);
spinnerCalculate = FindViewById <Spinner>(Resource.Id.spinnerCalculate);
spinnerCompounding = FindViewById <Spinner>(Resource.Id.spinnerCompounding);
spinnerCalendar = FindViewById <Spinner>(Resource.Id.spinnerMonthYear);
// Read Investment Types from table
investTypeList = Util.GetDatabaseMgr().GetInvestmentTypes();
String[] investTypesArr = new String[investTypeList.Count];
for (int i = 0; i < investTypeList.Count; i++)
{
investTypesArr[i] = investTypeList[i].Name;
}
ArrayAdapter <String> adapter_type_group = new ArrayAdapter <String>(this, Resource.Layout.SpinnerText, investTypesArr);
adapter_type_group.SetDropDownViewResource(Resource.Layout.SpinnerText);
spinnerType.Adapter = adapter_type_group;
spinnerType.ItemSelected += delegate(object sender, AdapterView.ItemSelectedEventArgs e)
{
if (e.Position != -1) // && _selGroupId != e.Position)
{
FindViewById <TextView>(Resource.Id.lblMuchInvesting).Text = investTypeList[e.Position].Present;
FindViewById <TextView>(Resource.Id.lblMuchFuture).Text = investTypeList[e.Position].Future;
FindViewById <TextView>(Resource.Id.lblRate).Text = investTypeList[e.Position].Rate;
FindViewById <TextView>(Resource.Id.lblGetDate).Text = investTypeList[e.Position].TimetoGet;
FindViewById <TextView>(Resource.Id.lblDeposit).Text = investTypeList[e.Position].Periodic;
if (String.IsNullOrEmpty(investTypeList[e.Position].Periodic) == false)
{
isPeriodic = true;
}
else
{
isPeriodic = false;
}
ChangeUILayout();
}
};
ArrayAdapter <String> adapter_calculate_group = new ArrayAdapter <String>(this, Resource.Layout.SpinnerText, Util.CALCULATE_TYPES);
adapter_calculate_group.SetDropDownViewResource(Resource.Layout.SpinnerText);
spinnerCalculate.Adapter = adapter_calculate_group;
spinnerCalculate.ItemSelected += delegate(object sender, AdapterView.ItemSelectedEventArgs e)
{
if (e.Position != -1)// && _selGroupId != e.Position)
{
calculateOption = e.Position;
ChangeUILayout();
}
};
ArrayAdapter <String> adapter_compounding_group = new ArrayAdapter <String>(this, Resource.Layout.SpinnerText, Util.COMPOUNDING_TYPES);
adapter_compounding_group.SetDropDownViewResource(Resource.Layout.SpinnerText);
spinnerCompounding.Adapter = adapter_compounding_group;
spinnerCompounding.ItemSelected += delegate(object sender, AdapterView.ItemSelectedEventArgs e)
{
if (e.Position != -1)// && _selGroupId != e.Position)
{
compoundOption = e.Position;
ChangeUILayout();
}
};
ArrayAdapter <String> adapter_calendar_group = new ArrayAdapter <String>(this, Resource.Layout.SpinnerText, Util.CALENDAR_TYPES);
adapter_calendar_group.SetDropDownViewResource(Resource.Layout.SpinnerText);
spinnerCalendar.Adapter = adapter_calendar_group;
spinnerCalendar.ItemSelected += delegate(object sender, AdapterView.ItemSelectedEventArgs e)
{
if (e.Position != -1)// && _selGroupId != e.Position)
{
}
};
linearMuchInvesting.Visibility = ViewStates.Invisible;
linearMuchFuture.Visibility = ViewStates.Invisible;
linearSelectCalendar.Visibility = ViewStates.Invisible;
linearPeriod.Visibility = ViewStates.Invisible;
curEntryItemId = -1;
if (this.Intent != null)
{
int curId = this.Intent.GetIntExtra("UID", -1);
if (curId != -1)
{
TblEntry entryItem = Util.GetDatabaseMgr().GetEntryWithId(curId);
if (entryItem != null)
{
curEntryItemId = curId;
curEntryItem = entryItem;
try{
spinnerType.SetSelection(GetIndexFromInvestTypeId(entryItem.InvestmentTypeID));
spinnerCalculate.SetSelection(entryItem.CalculateType);
spinnerCalendar.SetSelection(entryItem.CalendarType);
spinnerCompounding.SetSelection(entryItem.CompoundingType);
FindViewById <TextView>(Resource.Id.txtInvestName).Text = entryItem.EntryName;
FindViewById <TextView>(Resource.Id.txtMuchInvesting).Text = "" + entryItem.InitialPayment;
FindViewById <TextView>(Resource.Id.txtMuchFuture).Text = "" + entryItem.FuturePayment;
FindViewById <TextView>(Resource.Id.txtRate).Text = "" + entryItem.Rate * 100;
FindViewById <TextView>(Resource.Id.txtGetDate).Text = entryItem.TimeToGet;
FindViewById <CheckBox>(Resource.Id.chkAtPeriod).Checked = (entryItem.DepositFlag == 1);
FindViewById <TextView>(Resource.Id.txtDeposit).Text = "" + entryItem.DepositPayment;
FindViewById <TextView>(Resource.Id.txtStartDate).Text = IsValidDateTime(entryItem.StartTimeToGet, true) ? _dateStart.ToString("d") : "";
FindViewById <TextView>(Resource.Id.txtEndDate).Text = IsValidDateTime(entryItem.EndTimeToGet, false) ? _dateEnd.ToString("d") : "";
}
catch (Exception ex) {
}
}
}
}
}
