public void SavetolocalDba(string SelectedRow, string SegmentIndexRecon)
{
string SegmentIndex = SegmentIndexRecon;
string RowOption = SelectedRow;
var documentsPath = Environment.GetFolderPath(Environment.SpecialFolder.Personal);
var libraryPath = Path.Combine(documentsPath, DBConstant.SEPARATOR, DBConstant.LIBRARY);// Library Folder
var DbPath = Path.Combine(libraryPath, DBConstant.DB_NAME);
try
{
using (var conn = new SQLite.SQLiteConnection(DbPath))
{
conn.CreateTable <ReconditionValue>();
}
var record = new ReconditionValue {
RowOption = RowOption, SegmentIndex = SegmentIndex
};
using (var db = new SQLite.SQLiteConnection(DbPath))
{
var existingRecord = (db.Table <ReconditionValue>().Where(c => c.SegmentIndex == record.SegmentIndex)).SingleOrDefault();
if (existingRecord != null)
{
existingRecord.RowOption = record.RowOption;
db.Update(existingRecord);
}
else
{
db.Insert(record);
}
}
}
catch (Exception e)
{
Console.WriteLine(e);
}
//sqlitecode
}
async partial void ReconditionSaveBtn_Activated(UIBarButtonItem sender)
{
string labeltext = null;
string segmentIndex = null;
List <ReconditionValue> Saverecon = new List <ReconditionValue>();
var documentsPath = Environment.GetFolderPath(Environment.SpecialFolder.Personal); // Documents Folder
var libraryPath = Path.Combine(documentsPath, DBConstant.SEPARATOR, DBConstant.LIBRARY); // Library Folder
var DbPath = Path.Combine(libraryPath, DBConstant.DB_NAME);
ReconditionKBB recondata = new ReconditionKBB();
var connac = new SQLite.SQLiteConnection(DbPath);
connac.CreateTable <ReconditionValue>();
for (int i = 2; i >= 0; i--)
{
string segmentKey = i.ToString();
var existings = (connac.Table <ReconditionValue>().Where(
c => c.SegmentIndex == segmentKey)).SingleOrDefault();
if (existings == null)
{
if (i == 0)
{
globalInde.selectedSegmentIndex = "0";
setObjectRecon("0");
labeltext = "Mechanical";
ReconditionSegment.SelectedSegment = 0;
}
else if (i == 1)
{
globalInde.selectedSegmentIndex = "1";
setObjectRecon("1");
labeltext = "Interior";
ReconditionSegment.SelectedSegment = 1;
}
else if (i == 2)
{
globalInde.selectedSegmentIndex = "2";
setObjectRecon("2");
labeltext = "Exterior";
ReconditionSegment.SelectedSegment = 2;
}
//ReconditionSaveBtn.TintColor = UIColor.Red;
ReconditionSaveBtn.Title = "Next";
selectionAlertLabel.Hidden = false;
selectionAlertLabel.Text = "Please choose one of the " + labeltext + " options below";
selectionAlertLabel.TextColor = UIColor.Red;
var splitViewController = (UISplitViewController)AppDelegate.appDelegate.Window.RootViewController;
Utility.HideLoadingIndicator(splitViewController.View);
}
else
{
recondata.VehicleID = AppDelegate.appDelegate.vehicleID;
recondata.StoreID = AppDelegate.appDelegate.storeId;
recondata.InvtrID = AppDelegate.appDelegate.invtrId;
recondata.UserName = "******";
if (existings.SegmentIndex.ToString() == "0")
{
existings.SegmentIndex = "Mechanical";
ReconditionValue record1 = new ReconditionValue();
record1.RowOption = existings.RowOption.ToString();
record1.SegmentIndex = existings.SegmentIndex;
Saverecon.Add(record1);
string optionvalue = setCondition(existings.RowOption.ToString());
ReconAns recon1 = new ReconAns()
{
VehicleConditionCategoryName = "Mechanical",
VehicleConditionCategory = 0,
optionValue = optionvalue,
optionValueId = Int16.Parse(existings.RowOption)
};
recondata.Answers.Add(recon1);
}
else if (existings.SegmentIndex.ToString() == "1")
{
segmentIndex = "Exterior";
ReconditionValue record2 = new ReconditionValue();
record2.SegmentIndex = segmentIndex;
record2.RowOption = existings.RowOption.ToString();
Saverecon.Add(record2);
string optionvalue = setCondition(existings.RowOption.ToString());
ReconAns recon2 = new ReconAns()
{
VehicleConditionCategoryName = "Exterior",
VehicleConditionCategory = 1,
optionValue = optionvalue,
optionValueId = Int16.Parse(existings.RowOption)
};
recondata.Answers.Add(recon2);
}
else if (existings.SegmentIndex.ToString() == "2")
{
segmentIndex = "Interior";
ReconditionValue record3 = new ReconditionValue();
record3.SegmentIndex = segmentIndex;
record3.RowOption = existings.RowOption.ToString();
Saverecon.Add(record3);
string optionvalue = setCondition(existings.RowOption.ToString());
ReconAns recon3 = new ReconAns()
{
VehicleConditionCategoryName = "Interior",
VehicleConditionCategory = 2,
optionValue = optionvalue,
optionValueId = Int16.Parse(existings.RowOption)
};
recondata.Answers.Add(recon3);
}
}
}
if ((Saverecon.Count >= 3))
{
ReconditionSaveBtn.TintColor = UIColor.FromRGB(95, 165, 53);
ReconditionSaveBtn.Enabled = false;
var splitViewController = (UISplitViewController)AppDelegate.appDelegate.Window.RootViewController;
Utility.ShowLoadingIndicator(splitViewController.View, "Saving...", true);
await CallSaveReconService(recondata);
Utility.HideLoadingIndicator(splitViewController.View);
if (UserInterfaceIdiomIsPhone)
{
ReconditionSaveBtn.Title = "Save";
}
else
{
ReconditionSaveBtn.Title = "Next";
}
selectionAlertLabel.Text = "";
//savereconAPI(recondata);
//alert.TextColor = UIColor.Black;
//save recond api
// Navigate to Photograph
if (null == masterViewController)
{
if (!UserInterfaceIdiomIsPhone)
{
masterViewController = (MasterViewController)((UINavigationController)SplitViewController.ViewControllers[0]).TopViewController;
}
}
ViewWorker viewWorker = new ViewWorker();
viewWorker.WorkerDelegate = (ExtAppraisalApp.Utilities.WorkerDelegateInterface)masterViewController;
if (!AppDelegate.appDelegate.IsAllDataSaved)
{
if (!AppDelegate.appDelegate.IsReconditionsSaved)
{
viewWorker.PerformNavigation(6);
viewWorker.ShowPartialDoneImg(6);
viewWorker.ShowDoneImg(5);
if (UserInterfaceIdiomIsPhone)
{
var dictionary = new NSDictionary(new NSString("1"), new NSString("Reconditions"));
NSNotificationCenter.DefaultCenter.PostNotificationName((Foundation.NSString) "MenuSelection", null, dictionary);
}
}
else
{
viewWorker.PerformNavigation(6);
}
}
else
{
var storyboard = UIStoryboard.FromName("Main", null);
SummaryViewController summaryViewController = (SummaryViewController)storyboard.InstantiateViewController("SummaryViewController");
UINavigationController uINavigationController = new UINavigationController(summaryViewController);
uINavigationController.ModalTransitionStyle = UIModalTransitionStyle.CoverVertical;
uINavigationController.ModalPresentationStyle = UIModalPresentationStyle.FormSheet;
this.NavigationController.PresentViewController(uINavigationController, true, null);
}
AppDelegate.appDelegate.IsReconditionsSaved = true;
}
}
