public static void DeleteAppealOutcome(string code)
{
var sql = string.Format("DELETE FROM dbo.AdmissionsAppealStatus WHERE Code='{0}'", code);
DataAccessHelpers.Execute(sql);
}
public static void DeleteReasonAdmissionRejected(string code)
{
var sql = string.Format("DELETE FROM dbo.ApplicationRejectionReason WHERE Code='{0}'", code);
DataAccessHelpers.Execute(sql);
}
public static void DeleteApplicationStatus(string code)
{
var sql = string.Format("DELETE FROM dbo.ApplicationStatus WHERE Code='{0}'", code);
DataAccessHelpers.Execute(sql);
}
public static void DeleteLearnerConsentType(Guid learnerId)
{
string sql = String.Format("DELETE FROM dbo.LearnerConsentType WHERE Learner = '{0}' ", learnerId.ToString().ToUpper());
DataAccessHelpers.Execute(sql);
}
public static void DeleteSenProvisionType(string code)
{
var sql = string.Format("DELETE FROM dbo.SENProvisionType WHERE Code='{0}'", code);
DataAccessHelpers.Execute(sql);
}
public void Initialize( )
{
Helper = new DicomHelpers( );
DataAccessHelper = new DataAccessHelpers( );
}
protected override void OnCreate(Bundle savedInstanceState)
{
base.OnCreate(savedInstanceState);
// Create your application here
SetContentView(Resource.Layout.NewsObject_CustomeAdapter_Test_Layout);
//Toast.MakeText(this, "Hello and welcome to TestActivity!\n" + myResultStringMain, ToastLength.Long).Show();
if (myResultNewsObject != null)
{
Toast.MakeText(this, "Hello and welcome to Gord TestActivity!\n" + myResultNewsObject.ToString(), ToastLength.Long).Show();
}
DisplayListOBJECT = DataAccessHelpers.GetAllNewsObjectDataFromDatabase();
var newsObjectListView = FindViewById <ListView>(Resource.Id.listViewTestActivityCurrency);
newsObjectListView.Adapter = new NewsObject_CustomAdapter(this, DisplayListOBJECT);
newsObjectListView.ItemClick += NewsObjectListView_ItemClick;
//---------------------------------------------------------------------------------------------
string dateString = "04-15-2018";
string timeString = "10:45am";
DateTime dateTime = DataAccessHelpers.Convert_Strings_DateAndTime_To_SingleDateTimeObject(dateString, timeString, cultureInfo);
Log.Debug("DEBUG", "DateTime from my method: " + dateTime.ToString("dd/MM/yyyy HH:mm:ss"));
long ticksTime_1 = dateTime.Ticks;
Log.Debug("DEBUG", "No of ticks: " + ticksTime_1);
string dateString2 = "04-15-2018";
string timeString2 = "10:45pm";
DateTime dateTime2 = DataAccessHelpers.Convert_Strings_DateAndTime_To_SingleDateTimeObject(dateString2, timeString2, cultureInfo);
Log.Debug("DEBUG", "DateTime from my method: " + dateTime2.ToString("dd/MM/yyyy HH:mm:ss"));
long ticksTime_2 = dateTime2.Ticks;
Log.Debug("DEBUG", "No of ticks: " + ticksTime_2);
long timeDifference = ticksTime_2 - ticksTime_1;
Log.Debug("DEBUG", "Time difference in ticks: " + timeDifference);
TimeSpan elapsedSpan = new TimeSpan(timeDifference);
Log.Debug("DEBUG", "Elapsed time: " + elapsedSpan.TotalHours);
DateTime dateTime3 = new DateTime(2018, 03, 19, 23, 59, 00);
long myNum = dateTime3.Ticks;
Log.Debug("DEBUG", "No of ticks: " + myNum);
DateTime dateTime4 = new DateTime(myNum);
Log.Debug("DEBUG", "Re-converted dateTime: " + dateTime4.ToString("dd/MM/yyyy HH:mm:ss"));
// CultureInfo.InvariantCulture
// tt - gives am/pm
// hh - 12 hour clock
// HH = 24 hour clock
}// end OnCreate
