public List <string> GetListOfProperty(CountryProperty prop) { if (dataStore == null || dataStore.Accumulated == null) { throw new FieldAccessException( "Data cannot be accessed, since it was not loaded yet.\n" + "Please call DataLoader.LoadAllData() first."); } List <string> available = new List <string>(); foreach (var item in dataStore.Accumulated.Countries) { switch (prop) { case CountryProperty.CODE: if (item.CountryCode != null) { available.Add(item.CountryCode); } break; case CountryProperty.SLUG: if (item.Slug != null) { available.Add(item.Slug); } break; case CountryProperty.NAME: if (item.Country != null) { available.Add(item.Country); } break; default: throw new NotImplementedException( "Property specified in APIHandler.GetListOfProperty()" + "is not implemented yet."); } } if (available.Count == 0) { throw new FieldAccessException( "Data cannot be accessed. There are no available country datapoints.\n" + "Please try to call DataLoader.LoadAllData() again."); } return(available); }
private void OnAddressChanged(object sender, PropertyChangeEventArgs e) { if (!e.Change.IncludesValue() || DataProperty.Equals(e.OldValue, e.NewValue)) { return; } Header addr = AddressIdProperty.Value; AddressLine1Property.SetValue(addr?[Enumerations.BusinessEntityAddress.Attributes.AddressLine1]); AddressLine2Property.SetValue(addr?[Enumerations.BusinessEntityAddress.Attributes.AddressLine2]); CityStateProperty.SetValue(addr == null ? null : addr[Enumerations.BusinessEntityAddress.Attributes.City] + ", " + addr[Enumerations.BusinessEntityAddress.Attributes.State]); PostalCodeProperty.SetValue(addr?[Enumerations.BusinessEntityAddress.Attributes.PostalCode]); CountryProperty.SetValue(addr?[Enumerations.BusinessEntityAddress.Attributes.Country]); }
protected void btnUpload_Click(object sender, EventArgs e) { var errMsg = ""; _objCommon = new Common(); try { _objCountryProperty = new CountryProperty(); DataSet _ds = new DataSet(); var _objClsOledbdatalayer = new ClsOleDBDataWrapper(); var excelSheets = new String[0]; string path = MapPath(fileUploadExcel.FileName); fileUploadExcel.SaveAs(path); excelSheets = _objClsOledbdatalayer.CountTotalSheets(path); if (excelSheets.Length > 0) { foreach (string t in excelSheets) { _ds = _objClsOledbdatalayer.getdata(path, t); if (_ds.Tables[0].Rows.Count > 0) { for (int j = 0; j <= _ds.Tables[0].Rows.Count - 1; j++) { int result = CountryProvider.Instance.InsertCountry(_ds.Tables[0].Rows[j]["CountryName"].ToString(), LoggedInUserId, out errMsg, _ds.Tables[0].Rows[j]["CountryCode"].ToString()); if (result > 0) { lblRecordsInserted.Text = ""; lblRecordsInserted.Text = j + " row inserted out of " + _ds.Tables[0].Rows.Count; } } lblSuccess.Text = _objCommon.GetErrorMessage("lblSucessMsg"); lblSuccess.Visible = true; //CountryMasterBind(); } } } else { lblError.Text = _objCommon.GetErrorMessage("lblErrMsg"); } } catch (Exception ex) { } }
private List <CountryProperty> BindCountryObject(DataTable dataTable) { if (dataTable == null) { throw new ArgumentNullException("dataTable"); } var objCountryList = new List <CountryProperty>(); try { if (dataTable.Rows.Count > 0) { for (var j = 0; j < dataTable.Rows.Count; j++) { var objCountry = new CountryProperty { CountryId = Convert.ToInt32(dataTable.Rows[j]["AjCountryId"]), CountryCode = Convert.ToString(dataTable.Rows[j]["AjCountryCode"]), CountryName = Convert.ToString(dataTable.Rows[j]["AjCountryName"]) }; objCountryList.Add(objCountry); } } } catch (Exception ex) { var err = ex.Message; if (ex.InnerException != null) { err = err + " :: Inner Exception :- " + ex.ToString(); } const string addInfo = "Error while executing BindCountryObject in Country.cs :: -> "; var objPub = new ClsExceptionPublisher(); objPub.Publish(err, addInfo); } return(objCountryList); }
set => SetValue(CountryProperty, value);