private void SetupDropdown()
{
var isTesting = SessionVariables.IsTesting;
var activityData = ActivityDataManager.GetList(SessionVariables.RequestProfile);
UIHelper.LoadDropDown(activityData, drpActivityList, StandardDataModel.StandardDataColumns.Name, ActivityDataModel.DataColumns.ActivityId);
var taskAlgorithmItemIdData = TaskAlgorithmDataManager.GetList(SessionVariables.RequestProfile);
UIHelper.LoadDropDown(taskAlgorithmItemIdData, drpTaskAlgorithmList, StandardDataModel.StandardDataColumns.Name, TaskAlgorithmDataModel.DataColumns.TaskAlgorithmId);
if (isTesting)
{
drpActivityList.AutoPostBack = true;
drpTaskAlgorithmList.AutoPostBack = true;
if (drpActivityList.Items.Count > 0)
{
if (!string.IsNullOrEmpty(txtActivityId.Text.Trim()))
{
drpActivityList.SelectedValue = txtActivityId.Text;
}
else
{
txtActivityId.Text = drpActivityList.SelectedItem.Value;
}
}
if (drpTaskAlgorithmList.Items.Count > 0)
{
if (!string.IsNullOrEmpty(txtTaskAlgorithmId.Text.Trim()))
{
drpTaskAlgorithmList.SelectedValue = txtTaskAlgorithmId.Text;
}
else
{
txtTaskAlgorithmId.Text = drpTaskAlgorithmList.SelectedItem.Value;
}
}
txtActivityId.Visible = true;
txtTaskAlgorithmId.Visible = true;
}
else
{
if (!string.IsNullOrEmpty(txtActivityId.Text.Trim()))
{
drpActivityList.SelectedValue = txtActivityId.Text;
}
if (!string.IsNullOrEmpty(txtTaskAlgorithmId.Text.Trim()))
{
drpTaskAlgorithmList.SelectedValue = txtTaskAlgorithmId.Text;
}
}
}
private void UpdateData(ArrayList values)
{
var data = new ActivityDataModel();
data.ActivityId = int.Parse(values[0].ToString());
data.Name = values[1].ToString();
data.Description = values[2].ToString();
data.SortOrder = int.Parse(values[3].ToString());
data.LayerId = int.Parse(values[4].ToString());
ActivityDataManager.Update(data, SessionVariables.RequestProfile);
ReBindEditableGrid();
}
private int GetNextValidId(int tempId)
{
var dt = ActivityDataManager.GetList(SessionVariables.RequestProfile);
foreach (DataRow dr in dt.Rows)
{
if (dr[ActivityDataModel.DataColumns.ActivityId].ToString().Equals(tempId.ToString()))
{
tempId -= 1;
return(GetNextValidId(tempId));
}
}
return(tempId);
}
public override void LoadDropDownListSources(string fieldName, DropDownList dropDownListControl)
{
base.LoadDropDownListSources(fieldName, dropDownListControl);
if (fieldName.Equals("ActivityId"))
{
var activityData = ActivityDataManager.GetList(SessionVariables.RequestProfile);
UIHelper.LoadDropDown(activityData, dropDownListControl, StandardDataModel.StandardDataColumns.Name, ActivityDataModel.DataColumns.ActivityId);
}
if (fieldName.Equals("TaskAlgorithmId"))
{
var taskAlgorithmItemIdData = TaskAlgorithmDataManager.GetList(SessionVariables.RequestProfile);
UIHelper.LoadDropDown(taskAlgorithmItemIdData, dropDownListControl, StandardDataModel.StandardDataColumns.Name, TaskAlgorithmDataModel.DataColumns.TaskAlgorithmId);
}
}
protected void btnDelete_Click(object sender, EventArgs e)
{
try
{
string[] deleteIndexList = DeleteIds.Split(',');
foreach (string index in deleteIndexList)
{
var data = new ActivityDataModel();
data.ActivityId = int.Parse(index);
ActivityDataManager.Delete(data, SessionVariables.RequestProfile);
DeleteAndRedirect();
}
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}
protected override DataTable UpdateData()
{
var UpdatedData = new DataTable();
var data = new ActivityDataModel();
UpdatedData = ActivityDataManager.Search(data, SessionVariables.RequestProfile).Clone();
for (var i = 0; i < SelectedData.Rows.Count; i++)
{
data.ActivityId =
Convert.ToInt32(SelectedData.Rows[i][ActivityDataModel.DataColumns.ActivityId].ToString());
data.Name = SelectedData.Rows[i][StandardDataModel.StandardDataColumns.Name].ToString();
data.Description =
!string.IsNullOrEmpty(CheckAndGetRepeaterTextBoxValue(StandardDataModel.StandardDataColumns.Description))
? CheckAndGetRepeaterTextBoxValue(StandardDataModel.StandardDataColumns.Description)
: SelectedData.Rows[i][StandardDataModel.StandardDataColumns.Description].ToString();
data.SortOrder =
!string.IsNullOrEmpty(CheckAndGetRepeaterTextBoxValue(StandardDataModel.StandardDataColumns.SortOrder))
? int.Parse(CheckAndGetRepeaterTextBoxValue(StandardDataModel.StandardDataColumns.SortOrder))
: int.Parse(SelectedData.Rows[i][StandardDataModel.StandardDataColumns.SortOrder].ToString());
data.LayerId =
!string.IsNullOrEmpty(CheckAndGetRepeaterTextBoxValue(ActivityDataModel.DataColumns.LayerId))
? int.Parse(CheckAndGetRepeaterTextBoxValue(ActivityDataModel.DataColumns.LayerId))
: int.Parse(SelectedData.Rows[i][ActivityDataModel.DataColumns.LayerId].ToString());
ActivityDataManager.Update(data, SessionVariables.RequestProfile);
data = new ActivityDataModel();
data.ActivityId = Convert.ToInt32(SelectedData.Rows[i][ActivityDataModel.DataColumns.ActivityId].ToString());
var dt = ActivityDataManager.Search(data, SessionVariables.RequestProfile);
if (dt.Rows.Count == 1)
{
UpdatedData.ImportRow(dt.Rows[0]);
}
}
return(UpdatedData);
}
protected override DataTable GetData()
{
try
{
SuperKey = ApplicationCommon.GetSuperKey();
SetId = ApplicationCommon.GetSetId();
var selectedrows = new DataTable();
var activitydata = new ActivityDataModel();
selectedrows = ActivityDataManager.GetDetails(activitydata, SessionVariables.RequestProfile).Clone();
if (!string.IsNullOrEmpty(SuperKey))
{
var systemEntityTypeId = (int)PrimaryEntity;
var lstEntityKeys = ApplicationCommon.GetSuperKeyDetails(systemEntityTypeId, SuperKey);
foreach (var entityKey in lstEntityKeys)
{
activitydata.ActivityId = entityKey;
var result = ActivityDataManager.GetDetails(activitydata, SessionVariables.RequestProfile);
selectedrows.ImportRow(result.Rows[0]);
}
}
else
{
activitydata.ActivityId = SetId;
var result = ActivityDataManager.GetDetails(activitydata, SessionVariables.RequestProfile);
selectedrows.ImportRow(result.Rows[0]);
}
return(selectedrows);
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
return(null);
}
private void SetupDropdown()
{
var isTesting = SessionVariables.IsTesting;
var deliverableArtifactData = DeliverableArtifactDataManager.GetList(SessionVariables.RequestProfile);
UIHelper.LoadDropDown(deliverableArtifactData, drpDeliverableArtifactsList, StandardDataModel.StandardDataColumns.Name,
DeliverableArtifactDataModel.DataColumns.DeliverableArtifactId);
var activityData = ActivityDataManager.GetList(SessionVariables.RequestProfile);
UIHelper.LoadDropDown(activityData, drpActivityList, StandardDataModel.StandardDataColumns.Name,
ActivityDataModel.DataColumns.ActivityId);
var DeliverableArtifactsStatusData = DeliverableArtifactStatusDataManager.GetList(SessionVariables.RequestProfile);
UIHelper.LoadDropDown(DeliverableArtifactsStatusData, drpDeliverableArtifactsStatusList, StandardDataModel.StandardDataColumns.Name, DeliverableArtifactStatusDataModel.DataColumns.DeliverableArtifactStatusId);
if (isTesting)
{
drpActivityList.AutoPostBack = true;
drpDeliverableArtifactsList.AutoPostBack = true;
drpDeliverableArtifactsStatusList.AutoPostBack = true;
if (drpDeliverableArtifactsList.Items.Count > 0)
{
if (!string.IsNullOrEmpty(txtDeliverableArtifactsId.Text.Trim()))
{
drpDeliverableArtifactsList.SelectedValue = txtDeliverableArtifactsId.Text;
}
else
{
txtDeliverableArtifactsId.Text = drpDeliverableArtifactsList.SelectedItem.Value;
}
}
if (drpActivityList.Items.Count > 0)
{
if (!string.IsNullOrEmpty(txtActivityId.Text.Trim()))
{
drpActivityList.SelectedValue = txtActivityId.Text;
}
else
{
txtActivityId.Text = drpActivityList.SelectedItem.Value;
}
}
if (drpDeliverableArtifactsStatusList.Items.Count > 0)
{
if (!string.IsNullOrEmpty(txtDeliverableArtifactsStatusId.Text.Trim()))
{
drpDeliverableArtifactsStatusList.SelectedValue = txtDeliverableArtifactsStatusId.Text;
}
else
{
txtDeliverableArtifactsStatusId.Text = drpDeliverableArtifactsStatusList.SelectedItem.Value;
}
}
txtDeliverableArtifactsId.Visible = true;
txtActivityId.Visible = true;
txtDeliverableArtifactsStatusId.Visible = true;
}
else
{
if (!string.IsNullOrEmpty(txtDeliverableArtifactsId.Text.Trim()))
{
drpDeliverableArtifactsList.SelectedValue = txtDeliverableArtifactsId.Text;
}
if (!string.IsNullOrEmpty(txtActivityId.Text.Trim()))
{
drpActivityList.SelectedValue = txtActivityId.Text;
}
if (!string.IsNullOrEmpty(txtDeliverableArtifactsStatusId.Text.Trim()))
{
drpDeliverableArtifactsStatusList.SelectedValue = txtDeliverableArtifactsStatusId.Text;
}
}
}
private void ReBindEditableGrid()
{
var data = new ActivityDataModel();
var dtActivity = ActivityDataManager.Search(data, SessionVariables.RequestProfile);
}
protected override void OnInit(EventArgs e)
{
try
{
var superKey = "";
var newId = Framework.Components.Core.SystemEntityTypeDataManager.GetNextSequence("Activity", (int)Framework.Components.DataAccess.SystemEntity.Activity, SessionVariables.RequestProfile);
var Activitydata = new ActivityDataModel();
var systemdevdata = new SystemDevNumbersDataModel();
systemdevdata.ApplicationUserId = SessionVariables.RequestProfile.AuditId;
var dtnumbers = Framework.Components.Core.SystemDevNumbersDataManager.Search(systemdevdata, SessionVariables.RequestProfile);
var rangefrom =
Convert.ToInt32(dtnumbers.Rows[0][SystemDevNumbersDataModel.DataColumns.RangeFrom].ToString());
var rangeto =
Convert.ToInt32(dtnumbers.Rows[0][SystemDevNumbersDataModel.DataColumns.RangeTo].ToString());
if (Request.QueryString["SuperKey"] != null)
{
superKey = Request.QueryString["SuperKey"];
var data = new SuperKeyDetailDataModel();
data.SuperKeyId = Convert.ToInt32(superKey);
data.SystemEntityTypeId = (int)Framework.Components.DataAccess.SystemEntity.Activity;
var dt = Framework.Components.Core.SuperKeyDetailDataManager.Search(data, SessionVariables.RequestProfile);
if (dt != null && dt.Rows.Count > 0)
{
foreach (System.Data.DataRow dr in dt.Rows)
{
var key = Convert.ToInt32(dr[SuperKeyDetailDataModel.DataColumns.EntityKey]);
Activitydata.ActivityId = key;
var Activitydt = ActivityDataManager.GetDetails(Activitydata, SessionVariables.RequestProfile);
if (Activitydt.Rows.Count == 1)
{
var row = Activitydt.Rows[0];
if (Request.QueryString["Mode"].Equals("Test"))
{
Activitydata.ActivityId = GetNextValidId(rangefrom);
}
Activitydata.Name = Convert.ToString(row[StandardDataModel.StandardDataColumns.Name]);
Activitydata.Description = Convert.ToString(row[StandardDataModel.StandardDataColumns.Description]);
Activitydata.SortOrder = Convert.ToInt32(row[StandardDataModel.StandardDataColumns.SortOrder]);
ActivityDataManager.Create(Activitydata, SessionVariables.RequestProfile);
}
}
}
}
else if (Request.QueryString["SetId"] != null)
{
var key = int.Parse(Request.QueryString["SetId"]);
Activitydata.ActivityId = key;
var Activitydt = ActivityDataManager.GetDetails(Activitydata, SessionVariables.RequestProfile);
if (Activitydt.Rows.Count == 1)
{
var row = Activitydt.Rows[0];
var newActivitydata = new ActivityDataModel();
if (Request.QueryString["Mode"].Equals("Test"))
{
newActivitydata.ActivityId = newId = (int)GetNextValidId(rangefrom);
}
newActivitydata.Name = Convert.ToString(row[StandardDataModel.StandardDataColumns.Name]);
newActivitydata.Description = Convert.ToString(row[StandardDataModel.StandardDataColumns.Description]);
newActivitydata.SortOrder = Convert.ToInt32(row[StandardDataModel.StandardDataColumns.SortOrder]);
UpdatedFKDepenedencies(key, newId);
ActivityDataManager.Delete(Activitydata, SessionVariables.RequestProfile);
ActivityDataManager.Create(newActivitydata, SessionVariables.RequestProfile);
}
}
else if (Request.QueryString["Mode"].Equals("Renumber"))
{
var seed = int.Parse(Request.QueryString["Seed"]);
//ApplicationVariables.Seed;
var increment = int.Parse(Request.QueryString["Increment"]);
//ApplicationVariables.Increment;
ActivityDataManager.Renumber(seed, increment, SessionVariables.RequestProfile);
}
base.OnInit(e);
Response.Redirect("Default.aspx?Added=true", false);
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}
protected override DataTable GetData()
{
var dt = ActivityDataManager.Search(oSearchFilter.SearchParameters, SessionVariables.RequestProfile);
return(dt);
}
async void SendNotiClicked(object sender, System.EventArgs e)
{
/*CrossLocalNotifications.Current.Show("Medicine Notification", "Now: "+DateTime.Now+" is time to take pill" , 1);
* CrossLocalNotifications.Current.Show("Medicine Notification",
* "10 second later is time to take pill", 1,
* DateTime.Now.AddSeconds(10));
* MedicineDatabase medicineDatabase = new MedicineDatabase
* {
* Id="9311770597111",
* MedicineName="Swisse Liver Detox",
* Description="Swisse Ultiboost Liver Detox is a premium quality formula containing herbs traditionally " +
* "used to help support liver function and provide relief from indigestion and bloating.",
* Directions="Two tablets daily, during or immediately after a meal, or as directed by a healthcare professional.",
* Duration="30",
* TimesPerDay=1,
* Unit="Two tablets"
* };
*
* MedicineDatabaseManager medicineDatabaseManager = new MedicineDatabaseManager();
* await medicineDatabaseManager.SaveTaskAsync(medicineDatabase, true);
* PackageFoodDatabase medicineDatabase = new PackageFoodDatabase
* {
* Id="9310761130269",
* Title="Cheese Burger",
* Weight="161g",
* Energy="1090kJ",
* Description = "Tihs product contains gluten(wheat), milk, soy&sesame. May contain peanuts, and tree nuts duo to shared equipment.",
* Protein="13.1g",
* Fat="10.7g",
* Satfat = "4.5g",
* Carbs="27.6g",
* Sugar ="4.0g",
* Sodium="357mg"
*
* };
*
* PackageFoodDatabaseManager packageFoodDatabaseManager = new PackageFoodDatabaseManager();
* await packageFoodDatabaseManager.SaveTaskAsync(medicineDatabase, true);
* await DisplayAlert("ok", "creat succeed", "ok");
* PackageFoodDatabase Database = new PackageFoodDatabase
* {
* Id = "7622300689582",
* Title = "belVita Breakfast biscuits",
* Description = "belVita Breakfast biscuits are a convenient way to include quality wholegrains as parts of a delicious" +
* "breakfast for when you have a lot on your plate.",
* Weight = "50g",
* Energy = "1830kJ",
* Protein = "7.5g",
* Fat = "14.1g",
* Satfat = "1.4g",
* Carbs = "65.3g",
* Sugar = "22.2g",
* Fibre="8.9g",
* Sodium = "118mg"
*
* };
*
* await packageFoodDatabaseManager.SaveTaskAsync(Database, true);
* await DisplayAlert("ok", "creat succeed", "ok");
*/
ActivityDataManager activityDataManager = new ActivityDataManager();
Random ran = new Random();
int n = ran.Next(1400, 20000);
int m = ran.Next(0, 20);
ActivityData activityData = new ActivityData
{
Id = Guid.NewGuid().ToString(),
UserId = App.email,
date = new DateTime(2018, 6, 10),
steps = n,
climbedFloor = m,
walkedkm = (double)0.0007 * n
};
await activityDataManager.SaveTaskAsync(activityData, true);
//for (int i = 1; i < 7;i++){
// int n = ran.Next(1400, 20000);
// int m = ran.Next(0, 20);
// activityData = new ActivityData
// {
// Id = Guid.NewGuid().ToString(),
// UserId = App.email,
// date = new DateTime(2018, 6, i),
// steps = n,
// climbedFloor = m,
// walkedkm = (double) 0.0007*n
// };
// await activityDataManager.SaveTaskAsync(activityData, true);
//}
n = ran.Next(1400, 20000);
m = ran.Next(0, 20);
activityData = new ActivityData
{
Id = Guid.NewGuid().ToString(),
UserId = App.email,
date = new DateTime(2018, 6, 11),
steps = n,
climbedFloor = m,
walkedkm = (double)0.0007 * n
};
await activityDataManager.SaveTaskAsync(activityData, true);
n = ran.Next(1400, 20000);
m = ran.Next(0, 20);
activityData = new ActivityData
{
Id = Guid.NewGuid().ToString(),
UserId = App.email,
date = new DateTime(2018, 6, 12),
steps = n,
climbedFloor = m,
walkedkm = (double)0.0007 * n
};
await activityDataManager.SaveTaskAsync(activityData, true);
n = ran.Next(1400, 20000);
m = ran.Next(0, 20);
activityData = new ActivityData
{
Id = Guid.NewGuid().ToString(),
UserId = App.email,
date = new DateTime(2018, 6, 13),
steps = n,
climbedFloor = m,
walkedkm = (double)0.0007 * n
};
await activityDataManager.SaveTaskAsync(activityData, true);
await DisplayAlert("ok", "creat succeed", "ok");
}
