public bool AddSubCategoryOffline(SubCategoryOfflineViewModel newSubCategoryOffline, string _synced)
{
bool result = false;
try
{
using (var db = new SQLite.SQLiteConnection(_dbPath))
{
SubCategoryOffline objSubCategoryOffline = new SubCategoryOffline();
objSubCategoryOffline.categoryId = Convert.ToString(newSubCategoryOffline.categoryId);
objSubCategoryOffline.organizationId = Convert.ToString(newSubCategoryOffline.organizationId);
objSubCategoryOffline.categoryCode = Convert.ToString(newSubCategoryOffline.categoryCode);
objSubCategoryOffline.categoryDescription = newSubCategoryOffline.categoryDescription;
objSubCategoryOffline.parentCategoryId = newSubCategoryOffline.parentCategoryId;
objSubCategoryOffline.parentCategory = newSubCategoryOffline.parentCategory;
objSubCategoryOffline.imageName = newSubCategoryOffline.imageName;
objSubCategoryOffline.active = newSubCategoryOffline.active;
objSubCategoryOffline.synced = _synced; // i.e. Need to synced when online and Update the synced status = "True"
db.RunInTransaction(() =>
{
db.Insert(objSubCategoryOffline);
});
}
result = true;
}//try
catch (Exception ex)
{
}//catch
return result;
}
public SubCategoryDetailsPage()
{
InitializeComponent();
if (IsolatedStorageSettings.ApplicationSettings.Contains("islogin"))
{
if (!(Convert.ToString(IsolatedStorageSettings.ApplicationSettings["islogin"]).ToLower() == "yes"))
{
NavigationService.Navigate(new Uri("/Views/Login/LoginPage.xaml", UriKind.RelativeOrAbsolute));
}
else
{
if (ISOFile.FileExists("viewSubCategoryDetails"))//read current user login details
{
using (IsolatedStorageFileStream fileStream = ISOFile.OpenFile("viewSubCategoryDetails", FileMode.Open))
{
//====================================================================================================================
// Read Category Details
//====================================================================================================================
ObjSubCategoryData = new SubCategoryOfflineViewModel();
DataContractSerializer serializer = new DataContractSerializer(typeof(SubCategoryOfflineViewModel));
ObjSubCategoryData = (SubCategoryOfflineViewModel)serializer.ReadObject(fileStream);
lblSubCategory.Text = ObjSubCategoryData.categoryCode;
lblDescription.Text = ObjSubCategoryData.categoryDescription;
lblCategory.Text = ObjSubCategoryData.parentCategory;
if (!string.IsNullOrEmpty(ObjSubCategoryData.fullImagePath))
{
imgSubCategory.ImageSource = new BitmapImage(new Uri(ObjSubCategoryData.fullImagePath, UriKind.RelativeOrAbsolute));
}
else
{
imgSubCategory.ImageSource = new BitmapImage(new Uri("/Assets/category/icon_sub_categories.png", UriKind.RelativeOrAbsolute));
}
}
}
}
}
else
{
NavigationService.Navigate(new Uri("/Views/Login/LoginPage.xaml", UriKind.RelativeOrAbsolute));
}
}
void wc_UploadStringCompleted(object sender, UploadStringCompletedEventArgs e)
{
try
{
CategoryDataProvider _CategoryDataProvider = new CategoryDataProvider();
if (e.Result.Contains("no Sub Category found"))
{
ListSubCategoryData = new List<SubCategoryOfflineViewModel>();
this.lstSubCateoryItems.ItemsSource = ListSubCategoryData;
}
else
{
//Parse JSON result
var rootObject = JsonConvert.DeserializeObject<RootObject_SubCategory>(e.Result);
if (rootObject.success == 1)
{
foreach (var itm in rootObject.response.data)
{
SubCategoryOfflineViewModel obj = new SubCategoryOfflineViewModel();
obj.categoryId = Convert.ToString(itm.categoryId);
obj.organizationId = Convert.ToString(itm.organizationId);
obj.categoryCode = Convert.ToString(itm.categoryCode);
obj.categoryDescription = itm.categoryDescription;
obj.parentCategoryId = itm.parentCategoryId;
obj.parentCategory = itm.parentCategory;
obj.imageName = itm.imageName;
obj.active = itm.active;
_CategoryDataProvider = new CategoryDataProvider();
var result = _CategoryDataProvider.AddSubCategoryOffline(obj, "True");
if (result == true)
{
//MessageBox.Show("successfully registerd Sub Category.");
}
}
//====================================================================================================================
// Fill Sub Category List From Offline DB
//====================================================================================================================
_CategoryDataProvider = new CategoryDataProvider();
ListSubCategoryData = new List<SubCategoryOfflineViewModel>();
foreach (var itm in rootObject.response.data)
{
var Source = "/Assets/category/icon_sub_categories.png";
if (!string.IsNullOrEmpty(itm.imageName))
{
Source = Utilities.GetMarketplaceURL() + uploadImagePath.SUBCATEGORY + itm.imageName;
}
ListSubCategoryData.Add(new SubCategoryOfflineViewModel { categoryId = itm.categoryId, organizationId = itm.organizationId, categoryCode = itm.categoryCode, categoryDescription = itm.categoryDescription, imageName = itm.imageName, imagePath = itm.imagePath, active = itm.active, parentCategoryId = itm.parentCategoryId, createDt = itm.createDt, lastModifiedDt = itm.lastModifiedDt, lastModifiedBy = itm.lastModifiedBy, parentCategory = itm.parentCategory, fullImagePath = Source });
};
this.lstSubCateoryItems.ItemsSource = ListSubCategoryData;
// hide Loader
myIndeterminateProbar.Visibility = Visibility.Collapsed;
}
else
{
MessageBox.Show(rootObject.response.message.ToString());
}
}
}
catch (Exception ex)
{
MessageBox.Show("Something wrong happened.");
}
finally
{
// hide Loader
myIndeterminateProbar.Visibility = Visibility.Collapsed;
}
}
private void ImgAddSubCateory_Tap(object sender, System.Windows.Input.GestureEventArgs e)
{
if (Utilities.CheckInternetConnection())
{
// ----------------------------------------------------------------------
// "Network Status: Connected."
//====================================================================================================================
// Add new Sub Category
//====================================================================================================================
SubCategoryOfflineViewModel _CategoryDataContext = new SubCategoryOfflineViewModel();
// Set page mode for Add record of SubCategory
_redirectMode = "Add";
_CategoryDataContext.mode = "Add";
if (ISOFile.FileExists("viewSubCategoryDetails"))
{
ISOFile.DeleteFile("viewSubCategoryDetails");
}
using (IsolatedStorageFileStream fileStream = ISOFile.OpenFile("viewSubCategoryDetails", FileMode.Create))
{
DataContractSerializer serializer = new DataContractSerializer(typeof(SubCategoryOfflineViewModel));
serializer.WriteObject(fileStream, _CategoryDataContext);
NavigationService.Navigate(new Uri("/Views/SubCategory/SubCategoryAddEditPage.xaml", UriKind.RelativeOrAbsolute));
}
}
else
{
// ----------------------------------------------------------------------
// "Network Status: Not Connected."
MessageBox.Show("You can not create a new sub category in offline mode.");
}
}
private void ImgAddSubCateory_Tap(object sender, System.Windows.Input.GestureEventArgs e)
{
//====================================================================================================================
// Add new Sub Category
//====================================================================================================================
SubCategoryOfflineViewModel _CategoryDataContext = new SubCategoryOfflineViewModel();
// Set page mode for Add record of SubCategory
_redirectMode = "Add";
_CategoryDataContext.mode = "Add";
if (ISOFile.FileExists("viewSubCategoryDetails"))
{
ISOFile.DeleteFile("viewSubCategoryDetails");
}
using (IsolatedStorageFileStream fileStream = ISOFile.OpenFile("viewSubCategoryDetails", FileMode.Create))
{
DataContractSerializer serializer = new DataContractSerializer(typeof(SubCategoryOfflineViewModel));
serializer.WriteObject(fileStream, _CategoryDataContext);
NavigationService.Navigate(new Uri("/Views/SubCategory/SubCategoryAddEditPage.xaml", UriKind.RelativeOrAbsolute));
}
}
