private void btnSave_Click(object sender, RoutedEventArgs e) { // Show Loader myIndeterminateProbar.Visibility = Visibility.Visible; // Parameters CategoryRequest obj = new CategoryRequest(); obj.organizationId = _organizationId; // Logged In organizationId obj.categoryCode = txtcategoryName.Text; obj.categoryDescription = txtcategoryDescription.Text; obj.parentCategoryId = 0; // 0 for category and category id for subcategory if (Utilities.CheckInternetConnection()) { // ---------------------------------------------------------------------- // "Network Status: Connected." String data = string.Empty; if (Validation() == true) { //Initialize WebClient WebClient webClient = new WebClient(); //Set Header webClient.Headers[HttpRequestHeader.Authorization] = Utilities.GetAuthorization(); webClient.Headers["Content-Type"] = "application/x-www-form-urlencoded"; webClient.Headers[HttpRequestHeader.AcceptLanguage] = "en_US"; if (_mode == "Add") { data = "organizationId=" + obj.organizationId + "&categoryCode=" + obj.categoryCode + "&categoryDescription=" + obj.categoryDescription + "&parentCategoryId=" + obj.parentCategoryId; webClient.UploadStringAsync(new Uri(Utilities.GetURL("category/addCategory/")), "POST", data); } if (_mode == "Edit") { obj.categoryId = _categoryId; data = "organizationId=" + obj.organizationId + "&categoryId=" + obj.categoryId + "&categoryCode=" + obj.categoryCode + "&categoryDescription=" + obj.categoryDescription + "&parentCategoryId=" + obj.parentCategoryId; webClient.UploadStringAsync(new Uri(Utilities.GetURL("category/updateCategory/")), "POST", data); } //Assign Event Handler webClient.UploadStringCompleted += wc_UploadSaveCompleted; } } else { // ---------------------------------------------------------------------- // "Network Status: Not Connected." MessageBoxResult objMessageBox = MessageBox.Show("Right now you are in offline mode. data save and will be sent to the server the next time you are online.", "Network Status !", MessageBoxButton.OKCancel); if (objMessageBox == MessageBoxResult.OK) { try { if (Validation() == true) { if (_mode == "Add") { MessageBox.Show("You can not create a new category in offline mode."); } if (_mode == "Edit") { CategoryDataProvider _CategoryDataProvider = new CategoryDataProvider(); var result = _CategoryDataProvider.UpdateCategoryOffline(obj, "False"); if (result == true) { MessageBox.Show("successfully Updated."); } } } } catch (Exception ex) { MessageBox.Show("Something wrong happened."); } } } }
public CategoryListPage() { InitializeComponent(); IsolatedStorageFile ISOFile = IsolatedStorageFile.GetUserStoreForApplication(); 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("CurrentLoginUserDetails"))//read current user login details { using (IsolatedStorageFileStream fileStream = ISOFile.OpenFile("CurrentLoginUserDetails", FileMode.Open)) { DataContractSerializer serializer = new DataContractSerializer(typeof(LoginViewModel)); var ObjUserData = (LoginViewModel)serializer.ReadObject(fileStream); this.txtHeaderOrgName.Text = ObjUserData.organizationName; this.txtHeaderFullName.Text = ObjUserData.firstName + " " + ObjUserData.lastName; _employeeId = Convert.ToInt32(ObjUserData.employeeId); _organizationId = Convert.ToInt32(ObjUserData.organizationId); lstMenuItems.ItemsSource = Utilities.GetMenuItems(MenuCode.CatMngt); if (Utilities.CheckInternetConnection()) { // ---------------------------------------------------------------------- // "Network Status: Connected." //==================================================================================================================== // Category module Data Synchronization //==================================================================================================================== // Show Loader myIndeterminateProbar.Visibility = Visibility.Visible; CategoryDataProvider _CategoryDataProvider = new CategoryDataProvider(); var result = _CategoryDataProvider.GetsyncedCategoryOfflineList("False"); if (result != null) { if (result.Count > 0) { try { foreach (var itm in result) { // Parameters CategoryRequest obj = new CategoryRequest(); obj.organizationId = _organizationId; // Logged In organizationId obj.categoryId = Convert.ToInt32(itm.categoryId); obj.categoryCode = itm.categoryCode; obj.categoryDescription = itm.categoryDescription; obj.parentCategoryId = 0; // 0 for category and category id for subcategory String data = string.Empty; //Initialize WebClient WebClient webClient = new WebClient(); //Set Header webClient.Headers[HttpRequestHeader.Authorization] = Utilities.GetAuthorization(); webClient.Headers["Content-Type"] = "application/x-www-form-urlencoded"; webClient.Headers[HttpRequestHeader.AcceptLanguage] = "en_US"; data = "organizationId=" + obj.organizationId + "&categoryId=" + obj.categoryId + "&categoryCode=" + obj.categoryCode + "&categoryDescription=" + obj.categoryDescription + "&parentCategoryId=" + obj.parentCategoryId; webClient.UploadStringAsync(new Uri(Utilities.GetURL("category/updateCategory/")), "POST", data); //Assign Event Handler webClient.UploadStringCompleted += wc_UploadSaveCompleted; } } catch (Exception ex) { MessageBox.Show("Something wrong happened."); } } } } else { //==================================================================================================================== // Fill Category List From Offline DB //==================================================================================================================== CategoryDataProvider _CategoryDataProvider = new CategoryDataProvider(); ListCategoryData = new List<CategoryOfflineViewModel>(); foreach (var itm in _CategoryDataProvider.GetAllCategoryOfflineList()) { var Source = "/Assets/category/category_icon.png"; if (!string.IsNullOrEmpty(itm.imageName)) { Source = Utilities.GetMarketplaceURL() + uploadImagePath.CATEGORY + itm.imageName; } ListCategoryData.Add(new CategoryOfflineViewModel { 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, fullImagePath = Source }); }; this.lstCateoryItems.ItemsSource = ListCategoryData; } } } } } else { NavigationService.Navigate(new Uri("/Views/Login/LoginPage.xaml", UriKind.RelativeOrAbsolute)); } }
public bool UpdateCategoryOffline(CategoryRequest CustomerOffline, string _synced) { bool result = false; try { using (var db = new SQLite.SQLiteConnection(_dbPath)) { var objCategoryOffline = db.Query<PointePayApp.Model.CategoryOffline>("select * from CategoryOffline where categoryId=" + CustomerOffline.categoryId).FirstOrDefault(); if (objCategoryOffline != null) { //objCategoryOffline.categoryId = Convert.ToString(CustomerOffline.categoryId); //objCategoryOffline.organizationId = Convert.ToString(CustomerOffline.organizationId); objCategoryOffline.categoryCode = Convert.ToString(CustomerOffline.categoryCode); objCategoryOffline.categoryDescription = CustomerOffline.categoryDescription; objCategoryOffline.parentCategoryId = Convert.ToString(CustomerOffline.parentCategoryId); //objCategoryOffline.active = CustomerOffline.active; objCategoryOffline.synced = _synced; // i.e. Need to synced when online and Update the synced status = "True" db.RunInTransaction(() => { db.Update(objCategoryOffline); }); } } result = true; }//try catch (Exception ex) { }//catch return result; }
private void PhoneApplicationPage_Loaded(object sender, RoutedEventArgs e) { if (Utilities.CheckInternetConnection()) { // ---------------------------------------------------------------------- // "Network Status: Connected." // Show Loader myIndeterminateProbar.Visibility = Visibility.Visible; //==================================================================================================================== // Clear offline Customer table //==================================================================================================================== CategoryDataProvider _CategoryDataProvider = new CategoryDataProvider(); var result = _CategoryDataProvider.DeleteAllCategoryOffline(); if (result == true) { // Success } //==================================================================================================================== // Fill Category List //==================================================================================================================== // Parameters CategoryRequest obj = new CategoryRequest(); obj.organizationId = _organizationId; obj.set = 1; obj.count = Utilities.GetListCount(); String data = "organizationId=" + obj.organizationId + "&set=" + obj.set + "&count=" + obj.count; //Initialize WebClient WebClient webClient = new WebClient(); //Set Header webClient.Headers[HttpRequestHeader.Authorization] = Utilities.GetAuthorization(); webClient.Headers["Content-Type"] = "application/x-www-form-urlencoded"; webClient.Headers[HttpRequestHeader.AcceptLanguage] = "en_US"; webClient.UploadStringAsync(new Uri(Utilities.GetURL("category/categoryListing/")), "POST", data); //Assign Event Handler0 webClient.UploadStringCompleted += wc_UploadStringCompleted; } }