/// <summary> /// The event handler of this entity container which occurs on each /// Request sent to the serivce. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> void ZGWSAMPLE_SRV_SendingRequest(object sender, System.Data.Services.Client.SendingRequestEventArgs e) { HttpWebRequest webRequest = e.Request as HttpWebRequest; //ADN Modif ServiceDetails serviceDetail = null; // ConfigurationReaderHandler.Instance.GetServiceDetails("ZGWSAMPLE_SRV"); if (serviceDetail == null) { serviceDetail = new ServiceDetails { Url = @"https://sapes1.sapdevcenter.com:443/sap/opu/odata/sap/ZGWSAMPLE_SRV/", Client = "", SSO = "BASIC" }; } string language = System.Globalization.CultureInfo.CurrentUICulture.Name; webRequest.Headers["Accept-Language"] = language; BusinessConnectivityHelper.HandleSAPConnectivity(serviceDetail,ref webRequest); //The Below section helps you handle delta token. If you wish to use the details then pass the AtomDeltaToken back to your application. //To enable this section please set the value of "EnableDeltaToken" for the corresponding service to "Enabled". if (serviceDetail.HandleDeltaTokenDecision) { DataService dataService = new DataService(); if (webRequest.Method == "GET") { HttpWebRequest clonedWebRequest = webRequest.CloneRequestForXSRFToken(webRequest.RequestUri.AbsoluteUri); HttpWebResponse webResponse = clonedWebRequest.GetResponse() as HttpWebResponse; if (webResponse.StatusCode == HttpStatusCode.OK) { string response = webResponse.ReadResponse(); this.AtomDeltaToken = dataService.ReadResponse<AtomDeltaTokens>(response); } } } }
public void Test1() { var ds = new DataService<NorthwindDB>(); var mp = ds.GetService(typeof(IDataServiceMetadataProvider)); }
/// <summary> /// Fire up the repos and service context in the constructor. /// </summary> /// <param name="oAuthorization"></param> public SyncService(OAuthorizationdto oAuthorization) { dataserviceFactory = new DataserviceFactory(oAuthorization); dataService = dataserviceFactory.getDataService(); syncObjects = new Syncdto(); syncRepository = new SyncRepository(); }
public MapViewModel(INavigationResolver resolver, DataService.IGeoDataService service) { _resolver = resolver; _service = service; Issues = new ObservableCollection<DataService.IssueItem>(); InitData(); }
public void AddRemoveCategory() { var context = new CoreDataContext(); var uow = new EntityFrameworkUnitOfWork(context); var repo = new EntityFrameworkRepository<Guid, Category, GuidIdInitializer>(context); var caregoryService = new DataService<Guid, Category, EntityFrameworkRepository<Guid, Category, GuidIdInitializer>>(uow, repo); var newCategory = caregoryService.Add(new Category { Name = "Computres", Categories = new List<Category> { new Category { Name = "-DeskTops" }, new Category { Name = "-Servers" }, new Category { Name = "-Laptops", Categories = new List<Category> { new Category { Name = "--Tablets" }, new Category { Name = "--Shmablets" }, } }, } }); var justAdded = caregoryService.Get(c => c.Id == newCategory.Id); Assert.AreEqual(justAdded.Categories.Count, newCategory.Categories.Count); caregoryService.Remove(justAdded); justAdded = caregoryService.Get(c => c.Id == newCategory.Id); Assert.IsNull(justAdded); }
public void TestDeleteValue() { DataService dataService = new DataService(); dataService.SetValue("TestKey", "TestValue"); dataService.DeleteValue("TestKey"); Assert.IsInstanceOf(typeof(KeyNotFoundException), dataService.GetValue("TestKey").ThrownException); }
public when_a_customer_is_requested() { fakeDataService = A.Fake<DataService>(); //A.CallTo(() => fakeDataService.AddMessage()).MustHaveHappened(); handler = new GetIndex(fakeDataService); }
public DataTable LayDsLoaiNguoiDung() { SqlCommand cmd = new SqlCommand("SELECT * FROM LOAINGUOIDUNG"); DataService dS = new DataService(); dS.Load(cmd); m_LoaiNguoiDungData = dS; return m_LoaiNguoiDungData; }
//Metodo para obtener las Respuestas desde la base de datos. public void getAnswers(){ ds = new DataService("medicina.db"); /*Especifia nombre de la base de datos*/ ds.CreateDB (); var respuestas=ds.GetRespuestas(); /*El numero 1 es el ID de la pregunta que estamos evaluando*/ foreach(var respuesta in respuestas){ answer = respuesta.Texto; } }
public DataTable LayDsKhoanChi(String sqlString) { SqlCommand cmd = new SqlCommand(sqlString); DataService dS = new DataService(); dS.Load(cmd); m_KhoanChiData = dS; return m_KhoanChiData; }
public DataTable LayDsKhoanChi() { SqlCommand cmd = new SqlCommand(TruyVanChung()); DataService dS = new DataService(); dS.Load(cmd); m_KhoanChiData = dS; return m_KhoanChiData; }
public int XoaPhieuThu(int SoPT) { SqlCommand cmd = new SqlCommand("dbo.Delete_PhieuThu"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@SoPT", SoPT)); DataService dS = new DataService(); return dS.ExecuteNoneQuery(cmd); }
public static int CapNhatTimKiemTuDong(Boolean timKiemTuDong) { DataService m_QuyDinhData = new DataService(); SqlCommand cmd = new SqlCommand("UPDATE QUYDINH SET TimKiemTuDong= @timKiemTuDong"); cmd.Parameters.Add("timKiemTuDong", SqlDbType.Bit).Value = timKiemTuDong; return m_QuyDinhData.Load(cmd); }
public DataTable LayDsQuyDinh() { SqlCommand cmd = new SqlCommand("SELECT * FROM QUYDINH"); DataService dS = new DataService(); dS.Load(cmd); m_QuyDinhData = dS; return m_QuyDinhData; }
public DataTable LayDsNhanVien(String sqlString) { SqlCommand cmd = new SqlCommand(sqlString); DataService dS = new DataService(); dS.Load(cmd); m_NhanVienData = dS; return m_NhanVienData; }
public DataTable LayDsNhanVien() { SqlCommand cmd = new SqlCommand(TruyVanChung()); DataService dS = new DataService(); dS.Load(cmd); m_NhanVienData = dS; return m_NhanVienData; }
void client_GetGestureDataCompleted(object sender, DataService.GetGestureDataCompletedEventArgs e) { if (e.Error == null) { gestureInfo = SerializationHelper.Desirialize(e.Result); defBuilder.AddGesture(gestureInfo); } }
public int XacNhanPhieuChi(int SoPC) { SqlCommand cmd = new SqlCommand("dbo.XacNhan_PhieuChi"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@SoPC", SoPC)); DataService dS = new DataService(); return dS.ExecuteNoneQuery(cmd); }
public void ApiOnline() { Task.Run(async () => { var ds = new DataService(); Assert.IsTrue(await ds.ApiOnline()); }); }
public SqliteEntityLiteProvider(DataService dataService) : base(dataService) { if (DataService.ProviderName != ProviderName) { throw new InvalidOperationException(this.GetType().Name + " is for " + ProviderName + ". Not for " + DataService.ProviderName); } }
private void Load_Data() { DataService dataservice = new DataService(); dataSet = dataservice.GetSubjectAndWords(); Page.Session["DataSet"] = dataSet; }
static void Main(string[] args) { DataService dataService = new DataService(new IntData()); dataService.SendAndReceive(); dataService.SetData(new StringData()); dataService.SendAndReceive(); }
public static int CapNhatTaiKhoanCo(Int64 taiKhoanCo) { DataService m_QuyDinhData = new DataService(); SqlCommand cmd = new SqlCommand("UPDATE QUYDINH SET TaiKhoanCo = TaiKhoanCo + @taiKhoanCo"); cmd.Parameters.Add("taiKhoanCo", SqlDbType.BigInt).Value = taiKhoanCo; return m_QuyDinhData.Load(cmd); }
// Use this for initialization void Start () { var ds = new DataService ("tempDatabase.db"); ds.CreateDB (); var people = ds.GetPersons (); ToConsole (people); people = ds.GetPersonsNamedRoberto (); ToConsole("Searching for Roberto ..."); ToConsole (people); }
public static int CapNhatThongTinSaoLuu(int lichSaoLuu, String viTriSaoLuu) { DataService m_QuyDinhData = new DataService(); SqlCommand cmd = new SqlCommand("UPDATE QUYDINH SET LichSaoLuu = @lichSaoLuu, ThoiDiemSaoLuuTiepTheo = dateadd(dd, @lichSaoLuu, getdate()), viTriSaoLuu = @viTriSaoLuu"); cmd.Parameters.Add("lichSaoLuu", SqlDbType.Int).Value = lichSaoLuu; cmd.Parameters.Add("viTriSaoLuu", SqlDbType.VarChar).Value = viTriSaoLuu; return m_QuyDinhData.Load(cmd); }
public void DoLiveCycle() { Task.Run(async () => { //arrange var usrInfo = new UserInformationEntity() { Color = "AF56EB", Name = "TestUser" }; var updateDrinkRequest = new DrinkerRequest(PossibleActions.Update, ApiTestHelper.TestUserGuid) { UserInformations = usrInfo }; var existDrinkRequest = new DrinkerRequest(PossibleActions.Exists, ApiTestHelper.TestUserGuid) { UserInformations = usrInfo }; var removeDrinkRequest = new DrinkerRequest(PossibleActions.Remove, ApiTestHelper.TestUserGuid) { UserInformations = usrInfo }; var ds = new DataService(); //act //check if already exists; var res = await ds.PostDrinker(existDrinkRequest); ApiAssertHelper.CheckBooleanResponseForFalse(res); //add res = await ds.PostDrinker(updateDrinkRequest); ApiAssertHelper.CheckBooleanResponse(res); //check for existence var drinker = await ds.GetDrinker(ApiTestHelper.TestUserGuid); CheckGetDrinkerResponse(drinker, updateDrinkRequest); //update updateDrinkRequest.UserInformations.Name = "NewName"; updateDrinkRequest.UserInformations.Color = "NewColor"; res = await ds.PostDrinker(updateDrinkRequest); ApiAssertHelper.CheckBooleanResponse(res); //check for updated values drinker = await ds.GetDrinker(ApiTestHelper.TestUserGuid); CheckGetDrinkerResponse(drinker, updateDrinkRequest); //delete drinker again res = await ds.PostDrinker(removeDrinkRequest); ApiAssertHelper.CheckBooleanResponse(res); //ensure Drinker is deleted; res = await ds.PostDrinker(existDrinkRequest); ApiAssertHelper.CheckBooleanResponseForFalse(res); }).GetAwaiter().GetResult(); }
private void TestForm_Shown(object sender, EventArgs e) { IDbAdapter adapter = new SQLiteDataAdapter(); DataService = new DataService {Adapter = adapter}; Builder = new SQLBuilder(DataService.Adapter); Builder.CreateStructure(); List<Equipment> users = DataService.GetAllForModel(ModelExtensions.CreateInstance<Equipment>); Grid.DataSource = users; }
public DataTable TimTheoMa(String id) { SqlCommand cmd = new SqlCommand("SELECT * FROM KhoanChi WHERE MaKC LIKE '%' + @id + '%'"); cmd.Parameters.Add("id", SqlDbType.VarChar).Value = id; DataService dS = new DataService(); dS.Load(cmd); m_KhoanChiData = dS; return m_KhoanChiData; }
public void getQuestions(){ ds= new DataService("medicina.db"); ds.CreateDB(); var preguntas= ds.GetPreguntas(); foreach(var pregunta in preguntas){ question = pregunta.Texto; } }
public DataTable TimTheoTen(String TenKC) { SqlCommand cmd = new SqlCommand("SELECT * FROM KhoanChi WHERE TenKC LIKE '%' + @TenKC + '%'"); cmd.Parameters.Add("TenKC", SqlDbType.NVarChar).Value = TenKC; DataService dS = new DataService(); dS.Load(cmd); m_KhoanChiData = dS; return m_KhoanChiData; }
private static void GetTableSchema() { if (!IsSchemaInitialized) { //Schema declaration TableSchema.Table schema = new TableSchema.Table("vw_aspnet_Users", TableType.View, DataService.GetInstance("ViewWeb")); schema.Columns = new TableSchema.TableColumnCollection(); schema.SchemaName = @"dbo"; //columns TableSchema.TableColumn colvarApplicationId = new TableSchema.TableColumn(schema); colvarApplicationId.ColumnName = "ApplicationId"; colvarApplicationId.DataType = DbType.Guid; colvarApplicationId.MaxLength = 0; colvarApplicationId.AutoIncrement = false; colvarApplicationId.IsNullable = false; colvarApplicationId.IsPrimaryKey = false; colvarApplicationId.IsForeignKey = false; colvarApplicationId.IsReadOnly = false; schema.Columns.Add(colvarApplicationId); TableSchema.TableColumn colvarUserId = new TableSchema.TableColumn(schema); colvarUserId.ColumnName = "UserId"; colvarUserId.DataType = DbType.Guid; colvarUserId.MaxLength = 0; colvarUserId.AutoIncrement = false; colvarUserId.IsNullable = false; colvarUserId.IsPrimaryKey = false; colvarUserId.IsForeignKey = false; colvarUserId.IsReadOnly = false; schema.Columns.Add(colvarUserId); TableSchema.TableColumn colvarUserName = new TableSchema.TableColumn(schema); colvarUserName.ColumnName = "UserName"; colvarUserName.DataType = DbType.String; colvarUserName.MaxLength = 256; colvarUserName.AutoIncrement = false; colvarUserName.IsNullable = false; colvarUserName.IsPrimaryKey = false; colvarUserName.IsForeignKey = false; colvarUserName.IsReadOnly = false; schema.Columns.Add(colvarUserName); TableSchema.TableColumn colvarLoweredUserName = new TableSchema.TableColumn(schema); colvarLoweredUserName.ColumnName = "LoweredUserName"; colvarLoweredUserName.DataType = DbType.String; colvarLoweredUserName.MaxLength = 256; colvarLoweredUserName.AutoIncrement = false; colvarLoweredUserName.IsNullable = false; colvarLoweredUserName.IsPrimaryKey = false; colvarLoweredUserName.IsForeignKey = false; colvarLoweredUserName.IsReadOnly = false; schema.Columns.Add(colvarLoweredUserName); TableSchema.TableColumn colvarMobileAlias = new TableSchema.TableColumn(schema); colvarMobileAlias.ColumnName = "MobileAlias"; colvarMobileAlias.DataType = DbType.String; colvarMobileAlias.MaxLength = 16; colvarMobileAlias.AutoIncrement = false; colvarMobileAlias.IsNullable = true; colvarMobileAlias.IsPrimaryKey = false; colvarMobileAlias.IsForeignKey = false; colvarMobileAlias.IsReadOnly = false; schema.Columns.Add(colvarMobileAlias); TableSchema.TableColumn colvarIsAnonymous = new TableSchema.TableColumn(schema); colvarIsAnonymous.ColumnName = "IsAnonymous"; colvarIsAnonymous.DataType = DbType.Boolean; colvarIsAnonymous.MaxLength = 0; colvarIsAnonymous.AutoIncrement = false; colvarIsAnonymous.IsNullable = false; colvarIsAnonymous.IsPrimaryKey = false; colvarIsAnonymous.IsForeignKey = false; colvarIsAnonymous.IsReadOnly = false; schema.Columns.Add(colvarIsAnonymous); TableSchema.TableColumn colvarLastActivityDate = new TableSchema.TableColumn(schema); colvarLastActivityDate.ColumnName = "LastActivityDate"; colvarLastActivityDate.DataType = DbType.DateTime; colvarLastActivityDate.MaxLength = 0; colvarLastActivityDate.AutoIncrement = false; colvarLastActivityDate.IsNullable = false; colvarLastActivityDate.IsPrimaryKey = false; colvarLastActivityDate.IsForeignKey = false; colvarLastActivityDate.IsReadOnly = false; schema.Columns.Add(colvarLastActivityDate); BaseSchema = schema; //add this schema to the provider //so we can query it later DataService.Providers["ViewWeb"].AddSchema("vw_aspnet_Users", schema); } }
private static void GetTableSchema() { if (!IsSchemaInitialized) { //Schema declaration TableSchema.Table schema = new TableSchema.Table("SalesReason", TableType.Table, DataService.GetInstance("Default")); schema.Columns = new TableSchema.TableColumnCollection(); schema.SchemaName = @"Sales"; //columns TableSchema.TableColumn colvarSalesReasonID = new TableSchema.TableColumn(schema); colvarSalesReasonID.ColumnName = "SalesReasonID"; colvarSalesReasonID.DataType = DbType.Int32; colvarSalesReasonID.MaxLength = 0; colvarSalesReasonID.AutoIncrement = true; colvarSalesReasonID.IsNullable = false; colvarSalesReasonID.IsPrimaryKey = true; colvarSalesReasonID.IsForeignKey = false; colvarSalesReasonID.IsReadOnly = false; colvarSalesReasonID.DefaultSetting = @""; colvarSalesReasonID.ForeignKeyTableName = ""; schema.Columns.Add(colvarSalesReasonID); TableSchema.TableColumn colvarName = new TableSchema.TableColumn(schema); colvarName.ColumnName = "Name"; colvarName.DataType = DbType.String; colvarName.MaxLength = 50; colvarName.AutoIncrement = false; colvarName.IsNullable = false; colvarName.IsPrimaryKey = false; colvarName.IsForeignKey = false; colvarName.IsReadOnly = false; colvarName.DefaultSetting = @""; colvarName.ForeignKeyTableName = ""; schema.Columns.Add(colvarName); TableSchema.TableColumn colvarReasonType = new TableSchema.TableColumn(schema); colvarReasonType.ColumnName = "ReasonType"; colvarReasonType.DataType = DbType.String; colvarReasonType.MaxLength = 50; colvarReasonType.AutoIncrement = false; colvarReasonType.IsNullable = false; colvarReasonType.IsPrimaryKey = false; colvarReasonType.IsForeignKey = false; colvarReasonType.IsReadOnly = false; colvarReasonType.DefaultSetting = @""; colvarReasonType.ForeignKeyTableName = ""; schema.Columns.Add(colvarReasonType); TableSchema.TableColumn colvarModifiedDate = new TableSchema.TableColumn(schema); colvarModifiedDate.ColumnName = "ModifiedDate"; colvarModifiedDate.DataType = DbType.DateTime; colvarModifiedDate.MaxLength = 0; colvarModifiedDate.AutoIncrement = false; colvarModifiedDate.IsNullable = false; colvarModifiedDate.IsPrimaryKey = false; colvarModifiedDate.IsForeignKey = false; colvarModifiedDate.IsReadOnly = false; colvarModifiedDate.DefaultSetting = @"(getdate())"; colvarModifiedDate.ForeignKeyTableName = ""; schema.Columns.Add(colvarModifiedDate); BaseSchema = schema; //add this schema to the provider //so we can query it later DataService.Providers["Default"].AddSchema("SalesReason", schema); } }
public static void DeleteData(DataTable table, string path) { string sPath = path.Contains("'") ? path.Replace("'", "''") : path; //DataRow[] rows = table.Select(string.Format("filepath = '{0}'", sPath)); DataRow[] rows = (from row in table.AsEnumerable() where row.RowState != DataRowState.Deleted && row.RowState != DataRowState.Deleted && row.Field <string>("filepath") == path select row).ToArray(); List <string> queryList = new List <string>(); foreach (DataRow row in rows) { string owner = row["fileowner"].ToString().Trim(); if (owner == GlobalService.User) { List <string> sharedList = GetSharedList(GlobalService.DbTable, sPath); foreach (string shared in sharedList) { if (shared == "-") { continue; } if (!UserUtil.IsCnMember(shared.Trim()) && !UserUtil.IsVnMember(shared.Trim()) && !UserUtil.IsJpMember(shared.Trim())) { string tableName = "TB_" + AdUtil.GetUserIdByUsername(shared, "kmhk.local"); string sharedText = string.Format("delete from " + tableName + " where r_path = N'{0}'", sPath); queryList.Add(sharedText); } else { string sharedText = string.Format("delete from TB_OUTSIDE_SHARE where o_path = N'{0}'", sPath); queryList.Add(sharedText); } } string ownerText = string.Format("delete from " + GlobalService.DbTable + " where r_path = N'{0}'", sPath); queryList.Add(ownerText); if (File.Exists(path)) { if (GlobalService.User == UserUtil.HrUserName1()) //if (GlobalService.User == "Ling Wai Man(凌慧敏,Velma)") { string directory = @"\\kdthk-dm1\project\IT System\MyCloud Record\" + DateTime.Today.ToString("yyyyMMdd"); if (!Directory.Exists(directory)) { Directory.CreateDirectory(directory); } string filename = Path.GetFileName(path); File.Copy(path, directory + @"\" + filename); } File.Delete(path); } string delQuery = string.Format("delete from S_OUT_SHARE where o_path = N'{0}'", sPath); DataServiceMes.GetInstance().ExecuteNonQuery(delQuery); } else { string tableName = "TB_" + AdUtil.GetUserIdByUsername(owner, "kmhk.local"); List <string> sharedList = GetSharedList(tableName, sPath); sharedList.Remove(GlobalService.User); string shared = string.Join(";", sharedList.ToArray()); if (shared == "") { shared = "-"; } string ownerText = string.Format("update " + tableName + " set r_shared = N'{0}' where r_path = N'{1}'", shared, sPath); queryList.Add(ownerText); string sharedText = string.Format("delete from " + GlobalService.DbTable + " where r_path = N'{0}'", sPath); queryList.Add(sharedText); } if (row.RowState != DataRowState.Deleted) { row.Delete(); } } string now = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"); string query = string.Format("insert into TB_LOG (log_datetime, log_category, log_path, log_by) values ('{0}', '{1}', N'{2}', N'{3}')", now, "Delete", sPath, GlobalService.User); queryList.Add(query); foreach (string text in queryList) { DataService.GetInstance().ExecuteNonQuery(text); } //QueryUtil.InsertDataToLocalDb(text); }
private static void GetTableSchema() { if (!IsSchemaInitialized) { //Schema declaration TableSchema.Table schema = new TableSchema.Table("phpss_usertrack_req", TableType.Table, DataService.GetInstance("RisProvider")); schema.Columns = new TableSchema.TableColumnCollection(); schema.SchemaName = @"dbo"; //columns TableSchema.TableColumn colvarId = new TableSchema.TableColumn(schema); colvarId.ColumnName = "id"; colvarId.DataType = DbType.Int64; colvarId.MaxLength = 0; colvarId.AutoIncrement = true; colvarId.IsNullable = false; colvarId.IsPrimaryKey = true; colvarId.IsForeignKey = false; colvarId.IsReadOnly = false; colvarId.DefaultSetting = @""; colvarId.ForeignKeyTableName = ""; schema.Columns.Add(colvarId); TableSchema.TableColumn colvarSessionfid = new TableSchema.TableColumn(schema); colvarSessionfid.ColumnName = "sessionfid"; colvarSessionfid.DataType = DbType.Int32; colvarSessionfid.MaxLength = 0; colvarSessionfid.AutoIncrement = false; colvarSessionfid.IsNullable = false; colvarSessionfid.IsPrimaryKey = false; colvarSessionfid.IsForeignKey = false; colvarSessionfid.IsReadOnly = false; colvarSessionfid.DefaultSetting = @""; colvarSessionfid.ForeignKeyTableName = ""; schema.Columns.Add(colvarSessionfid); TableSchema.TableColumn colvarAccountfid = new TableSchema.TableColumn(schema); colvarAccountfid.ColumnName = "accountfid"; colvarAccountfid.DataType = DbType.Int16; colvarAccountfid.MaxLength = 0; colvarAccountfid.AutoIncrement = false; colvarAccountfid.IsNullable = false; colvarAccountfid.IsPrimaryKey = false; colvarAccountfid.IsForeignKey = false; colvarAccountfid.IsReadOnly = false; colvarAccountfid.DefaultSetting = @""; colvarAccountfid.ForeignKeyTableName = ""; schema.Columns.Add(colvarAccountfid); TableSchema.TableColumn colvarTimestamp = new TableSchema.TableColumn(schema); colvarTimestamp.ColumnName = "timestamp"; colvarTimestamp.DataType = DbType.DateTime; colvarTimestamp.MaxLength = 0; colvarTimestamp.AutoIncrement = false; colvarTimestamp.IsNullable = false; colvarTimestamp.IsPrimaryKey = false; colvarTimestamp.IsForeignKey = false; colvarTimestamp.IsReadOnly = false; colvarTimestamp.DefaultSetting = @""; colvarTimestamp.ForeignKeyTableName = ""; schema.Columns.Add(colvarTimestamp); TableSchema.TableColumn colvarUsertrackUrlfid = new TableSchema.TableColumn(schema); colvarUsertrackUrlfid.ColumnName = "usertrack_urlfid"; colvarUsertrackUrlfid.DataType = DbType.Int32; colvarUsertrackUrlfid.MaxLength = 0; colvarUsertrackUrlfid.AutoIncrement = false; colvarUsertrackUrlfid.IsNullable = false; colvarUsertrackUrlfid.IsPrimaryKey = false; colvarUsertrackUrlfid.IsForeignKey = false; colvarUsertrackUrlfid.IsReadOnly = false; colvarUsertrackUrlfid.DefaultSetting = @""; colvarUsertrackUrlfid.ForeignKeyTableName = ""; schema.Columns.Add(colvarUsertrackUrlfid); BaseSchema = schema; //add this schema to the provider //so we can query it later DataService.Providers["RisProvider"].AddSchema("phpss_usertrack_req", schema); } }
private static void GetTableSchema() { if (!IsSchemaInitialized) { //Schema declaration TableSchema.Table schema = new TableSchema.Table("Sys_RelFormularioCobertura", TableType.Table, DataService.GetInstance("RisProvider")); schema.Columns = new TableSchema.TableColumnCollection(); schema.SchemaName = @"dbo"; //columns TableSchema.TableColumn colvarIdRelFormularioCobertura = new TableSchema.TableColumn(schema); colvarIdRelFormularioCobertura.ColumnName = "idRelFormularioCobertura"; colvarIdRelFormularioCobertura.DataType = DbType.Int32; colvarIdRelFormularioCobertura.MaxLength = 0; colvarIdRelFormularioCobertura.AutoIncrement = true; colvarIdRelFormularioCobertura.IsNullable = false; colvarIdRelFormularioCobertura.IsPrimaryKey = true; colvarIdRelFormularioCobertura.IsForeignKey = false; colvarIdRelFormularioCobertura.IsReadOnly = false; colvarIdRelFormularioCobertura.DefaultSetting = @""; colvarIdRelFormularioCobertura.ForeignKeyTableName = ""; schema.Columns.Add(colvarIdRelFormularioCobertura); TableSchema.TableColumn colvarIdFormulario = new TableSchema.TableColumn(schema); colvarIdFormulario.ColumnName = "idFormulario"; colvarIdFormulario.DataType = DbType.Int32; colvarIdFormulario.MaxLength = 0; colvarIdFormulario.AutoIncrement = false; colvarIdFormulario.IsNullable = false; colvarIdFormulario.IsPrimaryKey = false; colvarIdFormulario.IsForeignKey = true; colvarIdFormulario.IsReadOnly = false; colvarIdFormulario.DefaultSetting = @"((0))"; colvarIdFormulario.ForeignKeyTableName = "Rem_Formulario"; schema.Columns.Add(colvarIdFormulario); TableSchema.TableColumn colvarIdTipoCobertura = new TableSchema.TableColumn(schema); colvarIdTipoCobertura.ColumnName = "idTipoCobertura"; colvarIdTipoCobertura.DataType = DbType.Int32; colvarIdTipoCobertura.MaxLength = 0; colvarIdTipoCobertura.AutoIncrement = false; colvarIdTipoCobertura.IsNullable = false; colvarIdTipoCobertura.IsPrimaryKey = false; colvarIdTipoCobertura.IsForeignKey = true; colvarIdTipoCobertura.IsReadOnly = false; colvarIdTipoCobertura.DefaultSetting = @"((0))"; colvarIdTipoCobertura.ForeignKeyTableName = "Rem_TipoCobertura"; schema.Columns.Add(colvarIdTipoCobertura); BaseSchema = schema; //add this schema to the provider //so we can query it later DataService.Providers["RisProvider"].AddSchema("Sys_RelFormularioCobertura", schema); } }
private static void GetTableSchema() { if (!IsSchemaInitialized) { //Schema declaration TableSchema.Table schema = new TableSchema.Table("dashCommerce_Store_ShippingEstimate", TableType.Table, DataService.GetInstance("dashCommerceProvider")); schema.Columns = new TableSchema.TableColumnCollection(); schema.SchemaName = @"dbo"; //columns TableSchema.TableColumn colvarShippingEstimateId = new TableSchema.TableColumn(schema); colvarShippingEstimateId.ColumnName = "ShippingEstimateId"; colvarShippingEstimateId.DataType = DbType.Int32; colvarShippingEstimateId.MaxLength = 0; colvarShippingEstimateId.AutoIncrement = true; colvarShippingEstimateId.IsNullable = false; colvarShippingEstimateId.IsPrimaryKey = true; colvarShippingEstimateId.IsForeignKey = false; colvarShippingEstimateId.IsReadOnly = false; colvarShippingEstimateId.DefaultSetting = @""; colvarShippingEstimateId.ForeignKeyTableName = ""; schema.Columns.Add(colvarShippingEstimateId); TableSchema.TableColumn colvarName = new TableSchema.TableColumn(schema); colvarName.ColumnName = "Name"; colvarName.DataType = DbType.String; colvarName.MaxLength = 150; colvarName.AutoIncrement = false; colvarName.IsNullable = false; colvarName.IsPrimaryKey = false; colvarName.IsForeignKey = false; colvarName.IsReadOnly = false; colvarName.DefaultSetting = @""; colvarName.ForeignKeyTableName = ""; schema.Columns.Add(colvarName); TableSchema.TableColumn colvarCreatedBy = new TableSchema.TableColumn(schema); colvarCreatedBy.ColumnName = "CreatedBy"; colvarCreatedBy.DataType = DbType.String; colvarCreatedBy.MaxLength = 50; colvarCreatedBy.AutoIncrement = false; colvarCreatedBy.IsNullable = true; colvarCreatedBy.IsPrimaryKey = false; colvarCreatedBy.IsForeignKey = false; colvarCreatedBy.IsReadOnly = false; colvarCreatedBy.DefaultSetting = @""; colvarCreatedBy.ForeignKeyTableName = ""; schema.Columns.Add(colvarCreatedBy); TableSchema.TableColumn colvarCreatedOn = new TableSchema.TableColumn(schema); colvarCreatedOn.ColumnName = "CreatedOn"; colvarCreatedOn.DataType = DbType.DateTime; colvarCreatedOn.MaxLength = 0; colvarCreatedOn.AutoIncrement = false; colvarCreatedOn.IsNullable = false; colvarCreatedOn.IsPrimaryKey = false; colvarCreatedOn.IsForeignKey = false; colvarCreatedOn.IsReadOnly = false; colvarCreatedOn.DefaultSetting = @"(getutcdate())"; colvarCreatedOn.ForeignKeyTableName = ""; schema.Columns.Add(colvarCreatedOn); TableSchema.TableColumn colvarModifiedBy = new TableSchema.TableColumn(schema); colvarModifiedBy.ColumnName = "ModifiedBy"; colvarModifiedBy.DataType = DbType.String; colvarModifiedBy.MaxLength = 50; colvarModifiedBy.AutoIncrement = false; colvarModifiedBy.IsNullable = true; colvarModifiedBy.IsPrimaryKey = false; colvarModifiedBy.IsForeignKey = false; colvarModifiedBy.IsReadOnly = false; colvarModifiedBy.DefaultSetting = @""; colvarModifiedBy.ForeignKeyTableName = ""; schema.Columns.Add(colvarModifiedBy); TableSchema.TableColumn colvarModifiedOn = new TableSchema.TableColumn(schema); colvarModifiedOn.ColumnName = "ModifiedOn"; colvarModifiedOn.DataType = DbType.DateTime; colvarModifiedOn.MaxLength = 0; colvarModifiedOn.AutoIncrement = false; colvarModifiedOn.IsNullable = false; colvarModifiedOn.IsPrimaryKey = false; colvarModifiedOn.IsForeignKey = false; colvarModifiedOn.IsReadOnly = false; colvarModifiedOn.DefaultSetting = @"(getutcdate())"; colvarModifiedOn.ForeignKeyTableName = ""; schema.Columns.Add(colvarModifiedOn); BaseSchema = schema; //add this schema to the provider //so we can query it later DataService.Providers["dashCommerceProvider"].AddSchema("dashCommerce_Store_ShippingEstimate", schema); } }
private static void GetTableSchema() { if (!IsSchemaInitialized) { //Schema declaration TableSchema.Table schema = new TableSchema.Table("hitbl_WidgetInstanceText_WIT", TableType.Table, DataService.GetInstance("SqlDataProvider")); schema.Columns = new TableSchema.TableColumnCollection(); schema.SchemaName = @"dbo"; //columns TableSchema.TableColumn colvarInsId = new TableSchema.TableColumn(schema); colvarInsId.ColumnName = "INS_ID"; colvarInsId.DataType = DbType.Guid; colvarInsId.MaxLength = 0; colvarInsId.AutoIncrement = false; colvarInsId.IsNullable = false; colvarInsId.IsPrimaryKey = true; colvarInsId.IsForeignKey = true; colvarInsId.IsReadOnly = false; colvarInsId.DefaultSetting = @""; colvarInsId.ForeignKeyTableName = "hitbl_WidgetInstance_INS"; schema.Columns.Add(colvarInsId); TableSchema.TableColumn colvarWitLangCode = new TableSchema.TableColumn(schema); colvarWitLangCode.ColumnName = "WIT_LangCode"; colvarWitLangCode.DataType = DbType.AnsiString; colvarWitLangCode.MaxLength = 10; colvarWitLangCode.AutoIncrement = false; colvarWitLangCode.IsNullable = false; colvarWitLangCode.IsPrimaryKey = true; colvarWitLangCode.IsForeignKey = false; colvarWitLangCode.IsReadOnly = false; colvarWitLangCode.DefaultSetting = @""; colvarWitLangCode.ForeignKeyTableName = ""; schema.Columns.Add(colvarWitLangCode); TableSchema.TableColumn colvarWitTitle = new TableSchema.TableColumn(schema); colvarWitTitle.ColumnName = "WIT_Title"; colvarWitTitle.DataType = DbType.String; colvarWitTitle.MaxLength = 255; colvarWitTitle.AutoIncrement = false; colvarWitTitle.IsNullable = false; colvarWitTitle.IsPrimaryKey = false; colvarWitTitle.IsForeignKey = false; colvarWitTitle.IsReadOnly = false; colvarWitTitle.DefaultSetting = @""; colvarWitTitle.ForeignKeyTableName = ""; schema.Columns.Add(colvarWitTitle); BaseSchema = schema; //add this schema to the provider //so we can query it later DataService.Providers["SqlDataProvider"].AddSchema("hitbl_WidgetInstanceText_WIT", schema); } }
private async Task RegisterUserAsync() { #region Validation await CheckUniqueEmailAsync(); await CheckUniqueUsernameAsync(); if (string.IsNullOrWhiteSpace(New_Username) || New_Username.Length < 6) { await new MessageDialog("Your username must be at least 6 characters", "Please enter a valid username").ShowAsync(); } else if (string.IsNullOrWhiteSpace(New_Password) || New_Password.Length < 8) { await new MessageDialog("Your password must be at least 8 characters", "Please enter a valid password").ShowAsync(); } else if (New_Password != New_ConfirmPassword) { await new MessageDialog("Your passwords must match").ShowAsync(); } else if (string.IsNullOrWhiteSpace(New_Email) || !IsValidEmail(New_Email)) { await new MessageDialog("Please enter a valid email address").ShowAsync(); } else if (!EmailUnique) { await new MessageDialog("This email address is already taken").ShowAsync(); } else if (!UsernameUnique) { await new MessageDialog("This username is already taken").ShowAsync(); } #endregion else { #region Build User #region Format Languages/Countries foreach (var item in New_NativeLanguages) { item.language_name = null; } foreach (var item in New_StudyLanguages) { item.language_name = null; } #endregion var newUser = new HNNewUserContainer { user = new HNNewUser { name = New_Username, email = New_Email, password = New_Password, password_confirmation = New_ConfirmPassword, profile_attributes = new HNProfileAttributes { interface_id = 1 }, terms_of_use = "1", platform = "android", mail_setting_attributes = new HNMailSettingAttributes { info = false }, native_languages_attributes = New_NativeLanguages, study_languages_attributes = New_StudyLanguages, #region Notifications Attributes notifications_attributes = new ObservableCollection <HNNotificationsAttribute> { new HNNotificationsAttribute { platform = "android", token = "fRxU1CeWSL0:APA91bFcj4kOiCfgHNIj2UZHeVK3AUK5c1PasVuJQeSei9Mckx1eiC-BV78uaABOWtVXSWHDMFn4sjba8OKmQxdo_c1MibypzeHrhoaEv0e-J54z_5tCRFZw2kiHtrD8RcS61cQa0bqv" } } #endregion } }; #endregion try { var createdUser = await DataService.SignUp(newUser); LoggerService.LogEvent("User_registered"); ApplicationDataContainer localSettings = ApplicationData.Current.LocalSettings; if (createdUser.token != null) { localSettings.Values["API_Token"] = createdUser.token; localSettings.Values["User_ID"] = createdUser.profile.user_attributes.id; } App.ViewModelLocator.Shell.CheckLoggedIn(); App.ViewModelLocator.Main.CurrentUser = App.ViewModelLocator.Shell.CurrentUser; App.ViewModelLocator.Main.InitPageAsync(); _navigationService.NavigateTo(typeof(MainPage)); } catch (Exception ex) { Debug.WriteLine(ex.Message); if (ex is HttpRequestException) { await new MessageDialog("We're having trouble connecting to the HiNative servers").ShowAsync(); } await new MessageDialog("Sign up failed, try a different username and/or email").ShowAsync(); LoggerService.LogEvent("Registration_failed"); } } }
public SessionsController(DataService dataService) { _dataService = dataService; }
private void InitializeCommands() { LogInCommand = new RelayCommand(async() => { try { InCall = true; var res = await DataService.LogIn(Username, Password); ApplicationDataContainer localSettings = ApplicationData.Current.LocalSettings; localSettings.Values["User_ID"] = res.profile.user_attributes.id; localSettings.Values["API_Token"] = res.token; App.ViewModelLocator.Shell.CheckLoggedIn(); App.ViewModelLocator.Main.InitPageAsync(); _navigationService.NavigateTo(typeof(MainPage)); Username = string.Empty; Password = string.Empty; InCall = false; } catch (Exception ex) { if (ex is HttpRequestException) { await new MessageDialog("We're having trouble connecting to the HiNative servers").ShowAsync(); LoggerService.LogEvent("Login_failed"); } else { await new MessageDialog("The username or password your entered was incorrect").ShowAsync(); } } }); CheckUsernameConflictsCommand = new RelayCommand <TextChangedEventArgs>(args => { //CheckUniqueUsernameAsync(); }); CheckEmailConflictsCommand = new RelayCommand <TextChangedEventArgs>(args => { //CheckUniqueEmailAsync(); }); SignUpCommand = new RelayCommand(async() => { await RegisterUserAsync(); }); #region Add Languages and Countries AddNativeLanguageCommand = new RelayCommand(async() => { var diag = new SelectLanguageDialog(true); var res = await diag.ShowAsync(); if (res == ContentDialogResult.Primary) { New_NativeLanguages.Add(diag.SelectedLanguage); } }); AddStudyLanguageCommand = new RelayCommand(async() => { var diag = new SelectLanguageDialog(false); var res = await diag.ShowAsync(); if (res == ContentDialogResult.Primary) { New_StudyLanguages.Add(diag.SelectedLanguage); } }); AddNativeCountryCommand = new RelayCommand(async() => { var diag = new SelectCountriesDialog(); var res = await diag.ShowAsync(); if (res == ContentDialogResult.Primary) { New_NativeCountry = new ObservableCollection <HNCountry> { diag.SelectedCountry }; } }); AddInterestedCountryCommand = new RelayCommand(async() => { var diag = new SelectCountriesDialog(); var res = await diag.ShowAsync(); if (res == ContentDialogResult.Primary) { New_InterestedCountries.Add(diag.SelectedCountry); } }); #endregion }
private static void GetTableSchema() { if (!IsSchemaInitialized) { //Schema declaration TableSchema.Table schema = new TableSchema.Table("TST_AfiliadosISSN", TableType.Table, DataService.GetInstance("RisProvider")); schema.Columns = new TableSchema.TableColumnCollection(); schema.SchemaName = @"dbo"; //columns TableSchema.TableColumn colvarId = new TableSchema.TableColumn(schema); colvarId.ColumnName = "id"; colvarId.DataType = DbType.Int32; colvarId.MaxLength = 0; colvarId.AutoIncrement = true; colvarId.IsNullable = false; colvarId.IsPrimaryKey = true; colvarId.IsForeignKey = false; colvarId.IsReadOnly = false; colvarId.DefaultSetting = @""; colvarId.ForeignKeyTableName = ""; schema.Columns.Add(colvarId); TableSchema.TableColumn colvarTipoDoc = new TableSchema.TableColumn(schema); colvarTipoDoc.ColumnName = "TipoDoc"; colvarTipoDoc.DataType = DbType.AnsiString; colvarTipoDoc.MaxLength = 3; colvarTipoDoc.AutoIncrement = false; colvarTipoDoc.IsNullable = true; colvarTipoDoc.IsPrimaryKey = false; colvarTipoDoc.IsForeignKey = false; colvarTipoDoc.IsReadOnly = false; colvarTipoDoc.DefaultSetting = @""; colvarTipoDoc.ForeignKeyTableName = ""; schema.Columns.Add(colvarTipoDoc); TableSchema.TableColumn colvarNroDoc = new TableSchema.TableColumn(schema); colvarNroDoc.ColumnName = "NroDoc"; colvarNroDoc.DataType = DbType.Int32; colvarNroDoc.MaxLength = 0; colvarNroDoc.AutoIncrement = false; colvarNroDoc.IsNullable = true; colvarNroDoc.IsPrimaryKey = false; colvarNroDoc.IsForeignKey = false; colvarNroDoc.IsReadOnly = false; colvarNroDoc.DefaultSetting = @""; colvarNroDoc.ForeignKeyTableName = ""; schema.Columns.Add(colvarNroDoc); TableSchema.TableColumn colvarApeNom = new TableSchema.TableColumn(schema); colvarApeNom.ColumnName = "ApeNom"; colvarApeNom.DataType = DbType.AnsiString; colvarApeNom.MaxLength = 25; colvarApeNom.AutoIncrement = false; colvarApeNom.IsNullable = true; colvarApeNom.IsPrimaryKey = false; colvarApeNom.IsForeignKey = false; colvarApeNom.IsReadOnly = false; colvarApeNom.DefaultSetting = @""; colvarApeNom.ForeignKeyTableName = ""; schema.Columns.Add(colvarApeNom); TableSchema.TableColumn colvarDomicilio = new TableSchema.TableColumn(schema); colvarDomicilio.ColumnName = "Domicilio"; colvarDomicilio.DataType = DbType.AnsiString; colvarDomicilio.MaxLength = 25; colvarDomicilio.AutoIncrement = false; colvarDomicilio.IsNullable = true; colvarDomicilio.IsPrimaryKey = false; colvarDomicilio.IsForeignKey = false; colvarDomicilio.IsReadOnly = false; colvarDomicilio.DefaultSetting = @""; colvarDomicilio.ForeignKeyTableName = ""; schema.Columns.Add(colvarDomicilio); TableSchema.TableColumn colvarSimilarityLocalidad = new TableSchema.TableColumn(schema); colvarSimilarityLocalidad.ColumnName = "_Similarity_Localidad"; colvarSimilarityLocalidad.DataType = DbType.Single; colvarSimilarityLocalidad.MaxLength = 0; colvarSimilarityLocalidad.AutoIncrement = false; colvarSimilarityLocalidad.IsNullable = true; colvarSimilarityLocalidad.IsPrimaryKey = false; colvarSimilarityLocalidad.IsForeignKey = false; colvarSimilarityLocalidad.IsReadOnly = false; colvarSimilarityLocalidad.DefaultSetting = @""; colvarSimilarityLocalidad.ForeignKeyTableName = ""; schema.Columns.Add(colvarSimilarityLocalidad); TableSchema.TableColumn colvarReparticion = new TableSchema.TableColumn(schema); colvarReparticion.ColumnName = "Reparticion"; colvarReparticion.DataType = DbType.AnsiString; colvarReparticion.MaxLength = 4; colvarReparticion.AutoIncrement = false; colvarReparticion.IsNullable = true; colvarReparticion.IsPrimaryKey = false; colvarReparticion.IsForeignKey = false; colvarReparticion.IsReadOnly = false; colvarReparticion.DefaultSetting = @""; colvarReparticion.ForeignKeyTableName = ""; schema.Columns.Add(colvarReparticion); TableSchema.TableColumn colvarNroAfiliado = new TableSchema.TableColumn(schema); colvarNroAfiliado.ColumnName = "NroAfiliado"; colvarNroAfiliado.DataType = DbType.AnsiString; colvarNroAfiliado.MaxLength = 6; colvarNroAfiliado.AutoIncrement = false; colvarNroAfiliado.IsNullable = true; colvarNroAfiliado.IsPrimaryKey = false; colvarNroAfiliado.IsForeignKey = false; colvarNroAfiliado.IsReadOnly = false; colvarNroAfiliado.DefaultSetting = @""; colvarNroAfiliado.ForeignKeyTableName = ""; schema.Columns.Add(colvarNroAfiliado); TableSchema.TableColumn colvarCarga = new TableSchema.TableColumn(schema); colvarCarga.ColumnName = "Carga"; colvarCarga.DataType = DbType.AnsiString; colvarCarga.MaxLength = 2; colvarCarga.AutoIncrement = false; colvarCarga.IsNullable = true; colvarCarga.IsPrimaryKey = false; colvarCarga.IsForeignKey = false; colvarCarga.IsReadOnly = false; colvarCarga.DefaultSetting = @""; colvarCarga.ForeignKeyTableName = ""; schema.Columns.Add(colvarCarga); TableSchema.TableColumn colvarFechaNacimiento = new TableSchema.TableColumn(schema); colvarFechaNacimiento.ColumnName = "FechaNacimiento"; colvarFechaNacimiento.DataType = DbType.AnsiString; colvarFechaNacimiento.MaxLength = 8; colvarFechaNacimiento.AutoIncrement = false; colvarFechaNacimiento.IsNullable = true; colvarFechaNacimiento.IsPrimaryKey = false; colvarFechaNacimiento.IsForeignKey = false; colvarFechaNacimiento.IsReadOnly = false; colvarFechaNacimiento.DefaultSetting = @""; colvarFechaNacimiento.ForeignKeyTableName = ""; schema.Columns.Add(colvarFechaNacimiento); TableSchema.TableColumn colvarFechaIngreso = new TableSchema.TableColumn(schema); colvarFechaIngreso.ColumnName = "FechaIngreso"; colvarFechaIngreso.DataType = DbType.AnsiString; colvarFechaIngreso.MaxLength = 8; colvarFechaIngreso.AutoIncrement = false; colvarFechaIngreso.IsNullable = true; colvarFechaIngreso.IsPrimaryKey = false; colvarFechaIngreso.IsForeignKey = false; colvarFechaIngreso.IsReadOnly = false; colvarFechaIngreso.DefaultSetting = @""; colvarFechaIngreso.ForeignKeyTableName = ""; schema.Columns.Add(colvarFechaIngreso); TableSchema.TableColumn colvarFechaVencimiento = new TableSchema.TableColumn(schema); colvarFechaVencimiento.ColumnName = "FechaVencimiento"; colvarFechaVencimiento.DataType = DbType.AnsiString; colvarFechaVencimiento.MaxLength = 8; colvarFechaVencimiento.AutoIncrement = false; colvarFechaVencimiento.IsNullable = true; colvarFechaVencimiento.IsPrimaryKey = false; colvarFechaVencimiento.IsForeignKey = false; colvarFechaVencimiento.IsReadOnly = false; colvarFechaVencimiento.DefaultSetting = @""; colvarFechaVencimiento.ForeignKeyTableName = ""; schema.Columns.Add(colvarFechaVencimiento); TableSchema.TableColumn colvarLocalidadOriginal = new TableSchema.TableColumn(schema); colvarLocalidadOriginal.ColumnName = "LocalidadOriginal"; colvarLocalidadOriginal.DataType = DbType.AnsiString; colvarLocalidadOriginal.MaxLength = 20; colvarLocalidadOriginal.AutoIncrement = false; colvarLocalidadOriginal.IsNullable = true; colvarLocalidadOriginal.IsPrimaryKey = false; colvarLocalidadOriginal.IsForeignKey = false; colvarLocalidadOriginal.IsReadOnly = false; colvarLocalidadOriginal.DefaultSetting = @""; colvarLocalidadOriginal.ForeignKeyTableName = ""; schema.Columns.Add(colvarLocalidadOriginal); TableSchema.TableColumn colvarSysLocalidad = new TableSchema.TableColumn(schema); colvarSysLocalidad.ColumnName = "sys_Localidad"; colvarSysLocalidad.DataType = DbType.String; colvarSysLocalidad.MaxLength = 100; colvarSysLocalidad.AutoIncrement = false; colvarSysLocalidad.IsNullable = true; colvarSysLocalidad.IsPrimaryKey = false; colvarSysLocalidad.IsForeignKey = false; colvarSysLocalidad.IsReadOnly = false; colvarSysLocalidad.DefaultSetting = @""; colvarSysLocalidad.ForeignKeyTableName = ""; schema.Columns.Add(colvarSysLocalidad); TableSchema.TableColumn colvarIdLocalidad = new TableSchema.TableColumn(schema); colvarIdLocalidad.ColumnName = "idLocalidad"; colvarIdLocalidad.DataType = DbType.Int32; colvarIdLocalidad.MaxLength = 0; colvarIdLocalidad.AutoIncrement = false; colvarIdLocalidad.IsNullable = true; colvarIdLocalidad.IsPrimaryKey = false; colvarIdLocalidad.IsForeignKey = false; colvarIdLocalidad.IsReadOnly = false; colvarIdLocalidad.DefaultSetting = @""; colvarIdLocalidad.ForeignKeyTableName = ""; schema.Columns.Add(colvarIdLocalidad); TableSchema.TableColumn colvarSimilarity = new TableSchema.TableColumn(schema); colvarSimilarity.ColumnName = "_Similarity"; colvarSimilarity.DataType = DbType.Single; colvarSimilarity.MaxLength = 0; colvarSimilarity.AutoIncrement = false; colvarSimilarity.IsNullable = true; colvarSimilarity.IsPrimaryKey = false; colvarSimilarity.IsForeignKey = false; colvarSimilarity.IsReadOnly = false; colvarSimilarity.DefaultSetting = @""; colvarSimilarity.ForeignKeyTableName = ""; schema.Columns.Add(colvarSimilarity); TableSchema.TableColumn colvarConfidence = new TableSchema.TableColumn(schema); colvarConfidence.ColumnName = "_Confidence"; colvarConfidence.DataType = DbType.Single; colvarConfidence.MaxLength = 0; colvarConfidence.AutoIncrement = false; colvarConfidence.IsNullable = true; colvarConfidence.IsPrimaryKey = false; colvarConfidence.IsForeignKey = false; colvarConfidence.IsReadOnly = false; colvarConfidence.DefaultSetting = @""; colvarConfidence.ForeignKeyTableName = ""; schema.Columns.Add(colvarConfidence); TableSchema.TableColumn colvarApellido = new TableSchema.TableColumn(schema); colvarApellido.ColumnName = "Apellido"; colvarApellido.DataType = DbType.AnsiString; colvarApellido.MaxLength = 25; colvarApellido.AutoIncrement = false; colvarApellido.IsNullable = true; colvarApellido.IsPrimaryKey = false; colvarApellido.IsForeignKey = false; colvarApellido.IsReadOnly = false; colvarApellido.DefaultSetting = @""; colvarApellido.ForeignKeyTableName = ""; schema.Columns.Add(colvarApellido); TableSchema.TableColumn colvarNombre = new TableSchema.TableColumn(schema); colvarNombre.ColumnName = "Nombre"; colvarNombre.DataType = DbType.AnsiString; colvarNombre.MaxLength = 25; colvarNombre.AutoIncrement = false; colvarNombre.IsNullable = true; colvarNombre.IsPrimaryKey = false; colvarNombre.IsForeignKey = false; colvarNombre.IsReadOnly = false; colvarNombre.DefaultSetting = @""; colvarNombre.ForeignKeyTableName = ""; schema.Columns.Add(colvarNombre); TableSchema.TableColumn colvarFechaNacimiento2 = new TableSchema.TableColumn(schema); colvarFechaNacimiento2.ColumnName = "FechaNacimiento2"; colvarFechaNacimiento2.DataType = DbType.DateTime; colvarFechaNacimiento2.MaxLength = 0; colvarFechaNacimiento2.AutoIncrement = false; colvarFechaNacimiento2.IsNullable = true; colvarFechaNacimiento2.IsPrimaryKey = false; colvarFechaNacimiento2.IsForeignKey = false; colvarFechaNacimiento2.IsReadOnly = false; colvarFechaNacimiento2.DefaultSetting = @""; colvarFechaNacimiento2.ForeignKeyTableName = ""; schema.Columns.Add(colvarFechaNacimiento2); TableSchema.TableColumn colvarFechaIngreso2 = new TableSchema.TableColumn(schema); colvarFechaIngreso2.ColumnName = "FechaIngreso2"; colvarFechaIngreso2.DataType = DbType.DateTime; colvarFechaIngreso2.MaxLength = 0; colvarFechaIngreso2.AutoIncrement = false; colvarFechaIngreso2.IsNullable = true; colvarFechaIngreso2.IsPrimaryKey = false; colvarFechaIngreso2.IsForeignKey = false; colvarFechaIngreso2.IsReadOnly = false; colvarFechaIngreso2.DefaultSetting = @""; colvarFechaIngreso2.ForeignKeyTableName = ""; schema.Columns.Add(colvarFechaIngreso2); TableSchema.TableColumn colvarNumeroAfiliado = new TableSchema.TableColumn(schema); colvarNumeroAfiliado.ColumnName = "NumeroAfiliado"; colvarNumeroAfiliado.DataType = DbType.AnsiString; colvarNumeroAfiliado.MaxLength = 14; colvarNumeroAfiliado.AutoIncrement = false; colvarNumeroAfiliado.IsNullable = true; colvarNumeroAfiliado.IsPrimaryKey = false; colvarNumeroAfiliado.IsForeignKey = false; colvarNumeroAfiliado.IsReadOnly = false; colvarNumeroAfiliado.DefaultSetting = @""; colvarNumeroAfiliado.ForeignKeyTableName = ""; schema.Columns.Add(colvarNumeroAfiliado); BaseSchema = schema; //add this schema to the provider //so we can query it later DataService.Providers["RisProvider"].AddSchema("TST_AfiliadosISSN", schema); } }
private void SkillResponses(int responseID) { var model = GetDialogCustomData <Model>(); // This is the first click. Mark the distribution type and wait for confirmation on the next click. if (model.DistributionType != responseID) { model.DistributionType = responseID; } // This is confirmation to distribute the rank(s). Do it. else { int amount; // Figure out how much to increase the skill by. if (responseID == 1) { amount = 1; } else if (responseID == 2) { amount = 5; } else if (responseID == 3) { amount = 10; } else { // We shouldn't ever see this message, but just in case a future change breaks it... GetPC().FloatingText("You cannot distribute this number of ranks into this skill."); return; } // Ensure the player can distribute the ranks one more time. if (!CanDistribute(amount)) { GetPC().FloatingText("You cannot distribute these ranks into this skill."); return; } // Let's do the distribution. Normally, you would want to run the SkillService methods but in this scenario // all of that's already been applied. You don't want to reapply the SP gains because they'll get more than they should. // Just set the ranks on the DB record and recalc stats. var pcSkill = DataService.Single <PCSkill>(x => x.PlayerID == GetPC().GlobalID&& x.SkillID == model.SkillID); pcSkill.Rank += amount; DataService.SubmitDataChange(pcSkill, DatabaseActionType.Update); PlayerStatService.ApplyStatChanges(GetPC(), null); // Reduce the pool levels. Delete the record if it drops to zero. var pool = DataService.Single <PCSkillPool>(x => x.PlayerID == GetPC().GlobalID&& x.SkillCategoryID == model.SkillCategoryID); pool.Levels -= amount; if (pool.Levels <= 0) { DataService.SubmitDataChange(pool, DatabaseActionType.Delete); EndConversation(); return; } else { DataService.SubmitDataChange(pool, DatabaseActionType.Update); } model.DistributionType = 0; } LoadSkillPage(); }
public UtilitiesModule(DiscordSocketClient client, DataService dataService) { _client = client; _dataService = dataService; }
private static void GetTableSchema() { if (!IsSchemaInitialized) { //Schema declaration TableSchema.Table schema = new TableSchema.Table("PN_inciso", TableType.Table, DataService.GetInstance("sicProvider")); schema.Columns = new TableSchema.TableColumnCollection(); schema.SchemaName = @"dbo"; //columns TableSchema.TableColumn colvarIdInciso = new TableSchema.TableColumn(schema); colvarIdInciso.ColumnName = "id_inciso"; colvarIdInciso.DataType = DbType.Int32; colvarIdInciso.MaxLength = 0; colvarIdInciso.AutoIncrement = true; colvarIdInciso.IsNullable = false; colvarIdInciso.IsPrimaryKey = true; colvarIdInciso.IsForeignKey = false; colvarIdInciso.IsReadOnly = false; colvarIdInciso.DefaultSetting = @""; colvarIdInciso.ForeignKeyTableName = ""; schema.Columns.Add(colvarIdInciso); TableSchema.TableColumn colvarInsNombre = new TableSchema.TableColumn(schema); colvarInsNombre.ColumnName = "ins_nombre"; colvarInsNombre.DataType = DbType.AnsiString; colvarInsNombre.MaxLength = -1; colvarInsNombre.AutoIncrement = false; colvarInsNombre.IsNullable = true; colvarInsNombre.IsPrimaryKey = false; colvarInsNombre.IsForeignKey = false; colvarInsNombre.IsReadOnly = false; colvarInsNombre.DefaultSetting = @""; colvarInsNombre.ForeignKeyTableName = ""; schema.Columns.Add(colvarInsNombre); TableSchema.TableColumn colvarCodigo = new TableSchema.TableColumn(schema); colvarCodigo.ColumnName = "codigo"; colvarCodigo.DataType = DbType.AnsiString; colvarCodigo.MaxLength = 3; colvarCodigo.AutoIncrement = false; colvarCodigo.IsNullable = false; colvarCodigo.IsPrimaryKey = false; colvarCodigo.IsForeignKey = false; colvarCodigo.IsReadOnly = false; colvarCodigo.DefaultSetting = @"((0.0))"; colvarCodigo.ForeignKeyTableName = ""; schema.Columns.Add(colvarCodigo); BaseSchema = schema; //add this schema to the provider //so we can query it later DataService.Providers["sicProvider"].AddSchema("PN_inciso", schema); } }
private static void GetTableSchema() { if (!IsSchemaInitialized) { //Schema declaration TableSchema.Table schema = new TableSchema.Table("Sys_CIE10", TableType.Table, DataService.GetInstance("RisProvider")); schema.Columns = new TableSchema.TableColumnCollection(); schema.SchemaName = @"dbo"; //columns TableSchema.TableColumn colvarId = new TableSchema.TableColumn(schema); colvarId.ColumnName = "ID"; colvarId.DataType = DbType.Int32; colvarId.MaxLength = 0; colvarId.AutoIncrement = true; colvarId.IsNullable = false; colvarId.IsPrimaryKey = true; colvarId.IsForeignKey = false; colvarId.IsReadOnly = false; colvarId.DefaultSetting = @""; colvarId.ForeignKeyTableName = ""; schema.Columns.Add(colvarId); TableSchema.TableColumn colvarCapitulo = new TableSchema.TableColumn(schema); colvarCapitulo.ColumnName = "CAPITULO"; colvarCapitulo.DataType = DbType.String; colvarCapitulo.MaxLength = 255; colvarCapitulo.AutoIncrement = false; colvarCapitulo.IsNullable = true; colvarCapitulo.IsPrimaryKey = false; colvarCapitulo.IsForeignKey = false; colvarCapitulo.IsReadOnly = false; colvarCapitulo.DefaultSetting = @""; colvarCapitulo.ForeignKeyTableName = ""; schema.Columns.Add(colvarCapitulo); TableSchema.TableColumn colvarGRUPOCIE10 = new TableSchema.TableColumn(schema); colvarGRUPOCIE10.ColumnName = "GRUPOCIE10"; colvarGRUPOCIE10.DataType = DbType.String; colvarGRUPOCIE10.MaxLength = 255; colvarGRUPOCIE10.AutoIncrement = false; colvarGRUPOCIE10.IsNullable = true; colvarGRUPOCIE10.IsPrimaryKey = false; colvarGRUPOCIE10.IsForeignKey = false; colvarGRUPOCIE10.IsReadOnly = false; colvarGRUPOCIE10.DefaultSetting = @""; colvarGRUPOCIE10.ForeignKeyTableName = ""; schema.Columns.Add(colvarGRUPOCIE10); TableSchema.TableColumn colvarCausa = new TableSchema.TableColumn(schema); colvarCausa.ColumnName = "CAUSA"; colvarCausa.DataType = DbType.String; colvarCausa.MaxLength = 255; colvarCausa.AutoIncrement = false; colvarCausa.IsNullable = true; colvarCausa.IsPrimaryKey = false; colvarCausa.IsForeignKey = false; colvarCausa.IsReadOnly = false; colvarCausa.DefaultSetting = @""; colvarCausa.ForeignKeyTableName = ""; schema.Columns.Add(colvarCausa); TableSchema.TableColumn colvarSubcausa = new TableSchema.TableColumn(schema); colvarSubcausa.ColumnName = "SUBCAUSA"; colvarSubcausa.DataType = DbType.String; colvarSubcausa.MaxLength = 255; colvarSubcausa.AutoIncrement = false; colvarSubcausa.IsNullable = true; colvarSubcausa.IsPrimaryKey = false; colvarSubcausa.IsForeignKey = false; colvarSubcausa.IsReadOnly = false; colvarSubcausa.DefaultSetting = @""; colvarSubcausa.ForeignKeyTableName = ""; schema.Columns.Add(colvarSubcausa); TableSchema.TableColumn colvarCodigo = new TableSchema.TableColumn(schema); colvarCodigo.ColumnName = "CODIGO"; colvarCodigo.DataType = DbType.String; colvarCodigo.MaxLength = 255; colvarCodigo.AutoIncrement = false; colvarCodigo.IsNullable = true; colvarCodigo.IsPrimaryKey = false; colvarCodigo.IsForeignKey = false; colvarCodigo.IsReadOnly = false; colvarCodigo.DefaultSetting = @""; colvarCodigo.ForeignKeyTableName = ""; schema.Columns.Add(colvarCodigo); TableSchema.TableColumn colvarNombre = new TableSchema.TableColumn(schema); colvarNombre.ColumnName = "Nombre"; colvarNombre.DataType = DbType.String; colvarNombre.MaxLength = 255; colvarNombre.AutoIncrement = false; colvarNombre.IsNullable = true; colvarNombre.IsPrimaryKey = false; colvarNombre.IsForeignKey = false; colvarNombre.IsReadOnly = false; colvarNombre.DefaultSetting = @""; colvarNombre.ForeignKeyTableName = ""; schema.Columns.Add(colvarNombre); TableSchema.TableColumn colvarSinonimo = new TableSchema.TableColumn(schema); colvarSinonimo.ColumnName = "Sinonimo"; colvarSinonimo.DataType = DbType.String; colvarSinonimo.MaxLength = 255; colvarSinonimo.AutoIncrement = false; colvarSinonimo.IsNullable = true; colvarSinonimo.IsPrimaryKey = false; colvarSinonimo.IsForeignKey = false; colvarSinonimo.IsReadOnly = false; colvarSinonimo.DefaultSetting = @"('')"; colvarSinonimo.ForeignKeyTableName = ""; schema.Columns.Add(colvarSinonimo); TableSchema.TableColumn colvarDescripCap = new TableSchema.TableColumn(schema); colvarDescripCap.ColumnName = "DescripCap"; colvarDescripCap.DataType = DbType.String; colvarDescripCap.MaxLength = 255; colvarDescripCap.AutoIncrement = false; colvarDescripCap.IsNullable = true; colvarDescripCap.IsPrimaryKey = false; colvarDescripCap.IsForeignKey = false; colvarDescripCap.IsReadOnly = false; colvarDescripCap.DefaultSetting = @""; colvarDescripCap.ForeignKeyTableName = ""; schema.Columns.Add(colvarDescripCap); TableSchema.TableColumn colvarModif = new TableSchema.TableColumn(schema); colvarModif.ColumnName = "Modif"; colvarModif.DataType = DbType.Double; colvarModif.MaxLength = 0; colvarModif.AutoIncrement = false; colvarModif.IsNullable = true; colvarModif.IsPrimaryKey = false; colvarModif.IsForeignKey = false; colvarModif.IsReadOnly = false; colvarModif.DefaultSetting = @""; colvarModif.ForeignKeyTableName = ""; schema.Columns.Add(colvarModif); TableSchema.TableColumn colvarCepsap = new TableSchema.TableColumn(schema); colvarCepsap.ColumnName = "CEPSAP"; colvarCepsap.DataType = DbType.String; colvarCepsap.MaxLength = 50; colvarCepsap.AutoIncrement = false; colvarCepsap.IsNullable = true; colvarCepsap.IsPrimaryKey = false; colvarCepsap.IsForeignKey = false; colvarCepsap.IsReadOnly = false; colvarCepsap.DefaultSetting = @""; colvarCepsap.ForeignKeyTableName = ""; schema.Columns.Add(colvarCepsap); TableSchema.TableColumn colvarC2 = new TableSchema.TableColumn(schema); colvarC2.ColumnName = "C2"; colvarC2.DataType = DbType.Boolean; colvarC2.MaxLength = 0; colvarC2.AutoIncrement = false; colvarC2.IsNullable = false; colvarC2.IsPrimaryKey = false; colvarC2.IsForeignKey = false; colvarC2.IsReadOnly = false; colvarC2.DefaultSetting = @"((0))"; colvarC2.ForeignKeyTableName = ""; schema.Columns.Add(colvarC2); BaseSchema = schema; //add this schema to the provider //so we can query it later DataService.Providers["RisProvider"].AddSchema("Sys_CIE10", schema); } }
public bool Run(params object[] args) { NWPlaceable container = (Object.OBJECT_SELF); NWPlayer oPC = (_.GetLastDisturbed()); int type = _.GetInventoryDisturbType(); NWItem item = (_.GetInventoryDisturbItem()); var effectiveStats = PlayerStatService.GetPlayerItemEffectiveStats(oPC); if (type != _.INVENTORY_DISTURB_TYPE_ADDED) { return(false); } int plantID = item.GetLocalInt("PLANT_ID"); if (plantID <= 0) { ItemService.ReturnItem(oPC, item); oPC.SendMessage("You cannot plant that item."); return(true); } Plant plant = FarmingService.GetPlantByID(plantID); if (plant == null) { ItemService.ReturnItem(oPC, item); oPC.SendMessage("You cannot plant that item."); return(true); } int rank = SkillService.GetPCSkillRank(oPC, SkillType.Farming); if (rank + 2 < plant.Level) { ItemService.ReturnItem(oPC, item); oPC.SendMessage("You do not have enough Farming skill to plant that seed. (Required: " + (plant.Level - 2) + ")"); return(true); } item.Destroy(); string areaTag = container.Area.Tag; Location plantLocation = container.Location; int perkBonus = PerkService.GetPCPerkLevel(oPC, PerkType.FarmingEfficiency) * 2; int ticks = (int)(plant.BaseTicks - ((PerkService.GetPCPerkLevel(oPC, PerkType.ExpertFarmer) * 0.05f)) * plant.BaseTicks); Data.Entity.GrowingPlant growingPlant = new Data.Entity.GrowingPlant { PlantID = plant.ID, RemainingTicks = ticks, LocationAreaTag = areaTag, LocationOrientation = _.GetFacingFromLocation(plantLocation), LocationX = _.GetPositionFromLocation(plantLocation).m_X, LocationY = _.GetPositionFromLocation(plantLocation).m_Y, LocationZ = _.GetPositionFromLocation(plantLocation).m_Z, IsActive = true, DateCreated = DateTime.UtcNow, LongevityBonus = perkBonus }; DataService.SubmitDataChange(growingPlant, DatabaseActionType.Insert); NWPlaceable hole = (container.GetLocalObject("FARM_SMALL_HOLE")); NWPlaceable plantPlc = (_.CreateObject(_.OBJECT_TYPE_PLACEABLE, "growing_plant", hole.Location)); plantPlc.SetLocalString("GROWING_PLANT_ID", growingPlant.ID.ToString()); plantPlc.Name = "Growing Plant (" + plant.Name + ")"; container.Destroy(); hole.Destroy(); int xp = (int)SkillService.CalculateRegisteredSkillLevelAdjustedXP(200, plant.Level, rank); if (RandomService.Random(100) + 1 <= PerkService.GetPCPerkLevel(oPC, PerkType.Lucky) + effectiveStats.Luck) { xp *= 2; } SkillService.GiveSkillXP(oPC, SkillType.Farming, xp); return(true); }
/// <summary> /// /// </summary> /// <param name="context"></param> /// <param name="crypt"></param> public UserController(DataService context, BCrypt crypt) { Context = context; Crypt = crypt; }
private static void GetTableSchema() { if (!IsSchemaInitialized) { //Schema declaration TableSchema.Table schema = new TableSchema.Table("Sys_Poblacion", TableType.Table, DataService.GetInstance("RisProvider")); schema.Columns = new TableSchema.TableColumnCollection(); schema.SchemaName = @"dbo"; //columns TableSchema.TableColumn colvarIdPoblacion = new TableSchema.TableColumn(schema); colvarIdPoblacion.ColumnName = "idPoblacion"; colvarIdPoblacion.DataType = DbType.Int32; colvarIdPoblacion.MaxLength = 0; colvarIdPoblacion.AutoIncrement = true; colvarIdPoblacion.IsNullable = false; colvarIdPoblacion.IsPrimaryKey = true; colvarIdPoblacion.IsForeignKey = false; colvarIdPoblacion.IsReadOnly = false; colvarIdPoblacion.DefaultSetting = @""; colvarIdPoblacion.ForeignKeyTableName = ""; schema.Columns.Add(colvarIdPoblacion); TableSchema.TableColumn colvarNombre = new TableSchema.TableColumn(schema); colvarNombre.ColumnName = "nombre"; colvarNombre.DataType = DbType.String; colvarNombre.MaxLength = 50; colvarNombre.AutoIncrement = false; colvarNombre.IsNullable = false; colvarNombre.IsPrimaryKey = false; colvarNombre.IsForeignKey = false; colvarNombre.IsReadOnly = false; colvarNombre.DefaultSetting = @"('')"; colvarNombre.ForeignKeyTableName = ""; schema.Columns.Add(colvarNombre); BaseSchema = schema; //add this schema to the provider //so we can query it later DataService.Providers["RisProvider"].AddSchema("Sys_Poblacion", schema); } }
public frmChucVu() { InitializeComponent(); DataService.OpenConnection(); }
public OrdersViewModel() { instance = this; dataService = new DataService(); OrderDate = DateTime.Today; }
private static void GetTableSchema() { if (!IsSchemaInitialized) { //Schema declaration TableSchema.Table schema = new TableSchema.Table("PN_nino", TableType.Table, DataService.GetInstance("sicProvider")); schema.Columns = new TableSchema.TableColumnCollection(); schema.SchemaName = @"dbo"; //columns TableSchema.TableColumn colvarIdNino = new TableSchema.TableColumn(schema); colvarIdNino.ColumnName = "id_nino"; colvarIdNino.DataType = DbType.Int32; colvarIdNino.MaxLength = 0; colvarIdNino.AutoIncrement = true; colvarIdNino.IsNullable = false; colvarIdNino.IsPrimaryKey = true; colvarIdNino.IsForeignKey = false; colvarIdNino.IsReadOnly = false; colvarIdNino.DefaultSetting = @""; colvarIdNino.ForeignKeyTableName = ""; schema.Columns.Add(colvarIdNino); TableSchema.TableColumn colvarCuie = new TableSchema.TableColumn(schema); colvarCuie.ColumnName = "cuie"; colvarCuie.DataType = DbType.AnsiString; colvarCuie.MaxLength = 10; colvarCuie.AutoIncrement = false; colvarCuie.IsNullable = false; colvarCuie.IsPrimaryKey = false; colvarCuie.IsForeignKey = false; colvarCuie.IsReadOnly = false; colvarCuie.DefaultSetting = @""; colvarCuie.ForeignKeyTableName = ""; schema.Columns.Add(colvarCuie); TableSchema.TableColumn colvarClave = new TableSchema.TableColumn(schema); colvarClave.ColumnName = "clave"; colvarClave.DataType = DbType.AnsiString; colvarClave.MaxLength = 50; colvarClave.AutoIncrement = false; colvarClave.IsNullable = true; colvarClave.IsPrimaryKey = false; colvarClave.IsForeignKey = false; colvarClave.IsReadOnly = false; colvarClave.DefaultSetting = @""; colvarClave.ForeignKeyTableName = ""; schema.Columns.Add(colvarClave); TableSchema.TableColumn colvarClaseDoc = new TableSchema.TableColumn(schema); colvarClaseDoc.ColumnName = "clase_doc"; colvarClaseDoc.DataType = DbType.AnsiString; colvarClaseDoc.MaxLength = -1; colvarClaseDoc.AutoIncrement = false; colvarClaseDoc.IsNullable = true; colvarClaseDoc.IsPrimaryKey = false; colvarClaseDoc.IsForeignKey = false; colvarClaseDoc.IsReadOnly = false; colvarClaseDoc.DefaultSetting = @""; colvarClaseDoc.ForeignKeyTableName = ""; schema.Columns.Add(colvarClaseDoc); TableSchema.TableColumn colvarTipoDoc = new TableSchema.TableColumn(schema); colvarTipoDoc.ColumnName = "tipo_doc"; colvarTipoDoc.DataType = DbType.AnsiString; colvarTipoDoc.MaxLength = -1; colvarTipoDoc.AutoIncrement = false; colvarTipoDoc.IsNullable = true; colvarTipoDoc.IsPrimaryKey = false; colvarTipoDoc.IsForeignKey = false; colvarTipoDoc.IsReadOnly = false; colvarTipoDoc.DefaultSetting = @""; colvarTipoDoc.ForeignKeyTableName = ""; schema.Columns.Add(colvarTipoDoc); TableSchema.TableColumn colvarNumDoc = new TableSchema.TableColumn(schema); colvarNumDoc.ColumnName = "num_doc"; colvarNumDoc.DataType = DbType.Decimal; colvarNumDoc.MaxLength = 0; colvarNumDoc.AutoIncrement = false; colvarNumDoc.IsNullable = true; colvarNumDoc.IsPrimaryKey = false; colvarNumDoc.IsForeignKey = false; colvarNumDoc.IsReadOnly = false; colvarNumDoc.DefaultSetting = @""; colvarNumDoc.ForeignKeyTableName = ""; schema.Columns.Add(colvarNumDoc); TableSchema.TableColumn colvarApellido = new TableSchema.TableColumn(schema); colvarApellido.ColumnName = "apellido"; colvarApellido.DataType = DbType.AnsiString; colvarApellido.MaxLength = -1; colvarApellido.AutoIncrement = false; colvarApellido.IsNullable = true; colvarApellido.IsPrimaryKey = false; colvarApellido.IsForeignKey = false; colvarApellido.IsReadOnly = false; colvarApellido.DefaultSetting = @""; colvarApellido.ForeignKeyTableName = ""; schema.Columns.Add(colvarApellido); TableSchema.TableColumn colvarNombre = new TableSchema.TableColumn(schema); colvarNombre.ColumnName = "nombre"; colvarNombre.DataType = DbType.AnsiString; colvarNombre.MaxLength = -1; colvarNombre.AutoIncrement = false; colvarNombre.IsNullable = true; colvarNombre.IsPrimaryKey = false; colvarNombre.IsForeignKey = false; colvarNombre.IsReadOnly = false; colvarNombre.DefaultSetting = @""; colvarNombre.ForeignKeyTableName = ""; schema.Columns.Add(colvarNombre); TableSchema.TableColumn colvarFechaNac = new TableSchema.TableColumn(schema); colvarFechaNac.ColumnName = "fecha_nac"; colvarFechaNac.DataType = DbType.DateTime; colvarFechaNac.MaxLength = 0; colvarFechaNac.AutoIncrement = false; colvarFechaNac.IsNullable = true; colvarFechaNac.IsPrimaryKey = false; colvarFechaNac.IsForeignKey = false; colvarFechaNac.IsReadOnly = false; colvarFechaNac.DefaultSetting = @""; colvarFechaNac.ForeignKeyTableName = ""; schema.Columns.Add(colvarFechaNac); TableSchema.TableColumn colvarFechaControl = new TableSchema.TableColumn(schema); colvarFechaControl.ColumnName = "fecha_control"; colvarFechaControl.DataType = DbType.DateTime; colvarFechaControl.MaxLength = 0; colvarFechaControl.AutoIncrement = false; colvarFechaControl.IsNullable = true; colvarFechaControl.IsPrimaryKey = false; colvarFechaControl.IsForeignKey = false; colvarFechaControl.IsReadOnly = false; colvarFechaControl.DefaultSetting = @""; colvarFechaControl.ForeignKeyTableName = ""; schema.Columns.Add(colvarFechaControl); TableSchema.TableColumn colvarPeso = new TableSchema.TableColumn(schema); colvarPeso.ColumnName = "peso"; colvarPeso.DataType = DbType.Decimal; colvarPeso.MaxLength = 0; colvarPeso.AutoIncrement = false; colvarPeso.IsNullable = true; colvarPeso.IsPrimaryKey = false; colvarPeso.IsForeignKey = false; colvarPeso.IsReadOnly = false; colvarPeso.DefaultSetting = @""; colvarPeso.ForeignKeyTableName = ""; schema.Columns.Add(colvarPeso); TableSchema.TableColumn colvarTalla = new TableSchema.TableColumn(schema); colvarTalla.ColumnName = "talla"; colvarTalla.DataType = DbType.Decimal; colvarTalla.MaxLength = 0; colvarTalla.AutoIncrement = false; colvarTalla.IsNullable = true; colvarTalla.IsPrimaryKey = false; colvarTalla.IsForeignKey = false; colvarTalla.IsReadOnly = false; colvarTalla.DefaultSetting = @""; colvarTalla.ForeignKeyTableName = ""; schema.Columns.Add(colvarTalla); TableSchema.TableColumn colvarPerimCefalico = new TableSchema.TableColumn(schema); colvarPerimCefalico.ColumnName = "perim_cefalico"; colvarPerimCefalico.DataType = DbType.Decimal; colvarPerimCefalico.MaxLength = 0; colvarPerimCefalico.AutoIncrement = false; colvarPerimCefalico.IsNullable = true; colvarPerimCefalico.IsPrimaryKey = false; colvarPerimCefalico.IsForeignKey = false; colvarPerimCefalico.IsReadOnly = false; colvarPerimCefalico.DefaultSetting = @""; colvarPerimCefalico.ForeignKeyTableName = ""; schema.Columns.Add(colvarPerimCefalico); TableSchema.TableColumn colvarPercenPesoEdad = new TableSchema.TableColumn(schema); colvarPercenPesoEdad.ColumnName = "percen_peso_edad"; colvarPercenPesoEdad.DataType = DbType.AnsiString; colvarPercenPesoEdad.MaxLength = -1; colvarPercenPesoEdad.AutoIncrement = false; colvarPercenPesoEdad.IsNullable = true; colvarPercenPesoEdad.IsPrimaryKey = false; colvarPercenPesoEdad.IsForeignKey = false; colvarPercenPesoEdad.IsReadOnly = false; colvarPercenPesoEdad.DefaultSetting = @""; colvarPercenPesoEdad.ForeignKeyTableName = ""; schema.Columns.Add(colvarPercenPesoEdad); TableSchema.TableColumn colvarPercenTallaEdad = new TableSchema.TableColumn(schema); colvarPercenTallaEdad.ColumnName = "percen_talla_edad"; colvarPercenTallaEdad.DataType = DbType.AnsiString; colvarPercenTallaEdad.MaxLength = -1; colvarPercenTallaEdad.AutoIncrement = false; colvarPercenTallaEdad.IsNullable = true; colvarPercenTallaEdad.IsPrimaryKey = false; colvarPercenTallaEdad.IsForeignKey = false; colvarPercenTallaEdad.IsReadOnly = false; colvarPercenTallaEdad.DefaultSetting = @""; colvarPercenTallaEdad.ForeignKeyTableName = ""; schema.Columns.Add(colvarPercenTallaEdad); TableSchema.TableColumn colvarPercenPerimCefaliEdad = new TableSchema.TableColumn(schema); colvarPercenPerimCefaliEdad.ColumnName = "percen_perim_cefali_edad"; colvarPercenPerimCefaliEdad.DataType = DbType.AnsiString; colvarPercenPerimCefaliEdad.MaxLength = -1; colvarPercenPerimCefaliEdad.AutoIncrement = false; colvarPercenPerimCefaliEdad.IsNullable = true; colvarPercenPerimCefaliEdad.IsPrimaryKey = false; colvarPercenPerimCefaliEdad.IsForeignKey = false; colvarPercenPerimCefaliEdad.IsReadOnly = false; colvarPercenPerimCefaliEdad.DefaultSetting = @""; colvarPercenPerimCefaliEdad.ForeignKeyTableName = ""; schema.Columns.Add(colvarPercenPerimCefaliEdad); TableSchema.TableColumn colvarPercenPesoTalla = new TableSchema.TableColumn(schema); colvarPercenPesoTalla.ColumnName = "percen_peso_talla"; colvarPercenPesoTalla.DataType = DbType.AnsiString; colvarPercenPesoTalla.MaxLength = -1; colvarPercenPesoTalla.AutoIncrement = false; colvarPercenPesoTalla.IsNullable = true; colvarPercenPesoTalla.IsPrimaryKey = false; colvarPercenPesoTalla.IsForeignKey = false; colvarPercenPesoTalla.IsReadOnly = false; colvarPercenPesoTalla.DefaultSetting = @""; colvarPercenPesoTalla.ForeignKeyTableName = ""; schema.Columns.Add(colvarPercenPesoTalla); TableSchema.TableColumn colvarTripleViral = new TableSchema.TableColumn(schema); colvarTripleViral.ColumnName = "triple_viral"; colvarTripleViral.DataType = DbType.DateTime; colvarTripleViral.MaxLength = 0; colvarTripleViral.AutoIncrement = false; colvarTripleViral.IsNullable = true; colvarTripleViral.IsPrimaryKey = false; colvarTripleViral.IsForeignKey = false; colvarTripleViral.IsReadOnly = false; colvarTripleViral.DefaultSetting = @""; colvarTripleViral.ForeignKeyTableName = ""; schema.Columns.Add(colvarTripleViral); TableSchema.TableColumn colvarNinoEdad = new TableSchema.TableColumn(schema); colvarNinoEdad.ColumnName = "nino_edad"; colvarNinoEdad.DataType = DbType.Int32; colvarNinoEdad.MaxLength = 0; colvarNinoEdad.AutoIncrement = false; colvarNinoEdad.IsNullable = true; colvarNinoEdad.IsPrimaryKey = false; colvarNinoEdad.IsForeignKey = false; colvarNinoEdad.IsReadOnly = false; colvarNinoEdad.DefaultSetting = @""; colvarNinoEdad.ForeignKeyTableName = ""; schema.Columns.Add(colvarNinoEdad); TableSchema.TableColumn colvarObservaciones = new TableSchema.TableColumn(schema); colvarObservaciones.ColumnName = "observaciones"; colvarObservaciones.DataType = DbType.AnsiString; colvarObservaciones.MaxLength = -1; colvarObservaciones.AutoIncrement = false; colvarObservaciones.IsNullable = true; colvarObservaciones.IsPrimaryKey = false; colvarObservaciones.IsForeignKey = false; colvarObservaciones.IsReadOnly = false; colvarObservaciones.DefaultSetting = @""; colvarObservaciones.ForeignKeyTableName = ""; schema.Columns.Add(colvarObservaciones); TableSchema.TableColumn colvarFechaCarga = new TableSchema.TableColumn(schema); colvarFechaCarga.ColumnName = "fecha_carga"; colvarFechaCarga.DataType = DbType.DateTime; colvarFechaCarga.MaxLength = 0; colvarFechaCarga.AutoIncrement = false; colvarFechaCarga.IsNullable = true; colvarFechaCarga.IsPrimaryKey = false; colvarFechaCarga.IsForeignKey = false; colvarFechaCarga.IsReadOnly = false; colvarFechaCarga.DefaultSetting = @""; colvarFechaCarga.ForeignKeyTableName = ""; schema.Columns.Add(colvarFechaCarga); TableSchema.TableColumn colvarUsuario = new TableSchema.TableColumn(schema); colvarUsuario.ColumnName = "usuario"; colvarUsuario.DataType = DbType.AnsiString; colvarUsuario.MaxLength = -1; colvarUsuario.AutoIncrement = false; colvarUsuario.IsNullable = true; colvarUsuario.IsPrimaryKey = false; colvarUsuario.IsForeignKey = false; colvarUsuario.IsReadOnly = false; colvarUsuario.DefaultSetting = @""; colvarUsuario.ForeignKeyTableName = ""; schema.Columns.Add(colvarUsuario); BaseSchema = schema; //add this schema to the provider //so we can query it later DataService.Providers["sicProvider"].AddSchema("PN_nino", schema); } }
private static void GetTableSchema() { if (!IsSchemaInitialized) { //Schema declaration TableSchema.Table schema = new TableSchema.Table("UsersParagraphLink", TableType.Table, DataService.GetInstance("SSRepository")); schema.Columns = new TableSchema.TableColumnCollection(); schema.SchemaName = @"dbo"; //columns TableSchema.TableColumn colvarId = new TableSchema.TableColumn(schema); colvarId.ColumnName = "ID"; colvarId.DataType = DbType.Int32; colvarId.MaxLength = 0; colvarId.AutoIncrement = true; colvarId.IsNullable = false; colvarId.IsPrimaryKey = true; colvarId.IsForeignKey = false; colvarId.IsReadOnly = false; colvarId.DefaultSetting = @""; colvarId.ForeignKeyTableName = ""; schema.Columns.Add(colvarId); TableSchema.TableColumn colvarSourceType = new TableSchema.TableColumn(schema); colvarSourceType.ColumnName = "SourceType"; colvarSourceType.DataType = DbType.Int32; colvarSourceType.MaxLength = 0; colvarSourceType.AutoIncrement = false; colvarSourceType.IsNullable = true; colvarSourceType.IsPrimaryKey = false; colvarSourceType.IsForeignKey = false; colvarSourceType.IsReadOnly = false; colvarSourceType.DefaultSetting = @""; colvarSourceType.ForeignKeyTableName = ""; schema.Columns.Add(colvarSourceType); TableSchema.TableColumn colvarSourceID = new TableSchema.TableColumn(schema); colvarSourceID.ColumnName = "SourceID"; colvarSourceID.DataType = DbType.Int32; colvarSourceID.MaxLength = 0; colvarSourceID.AutoIncrement = false; colvarSourceID.IsNullable = true; colvarSourceID.IsPrimaryKey = false; colvarSourceID.IsForeignKey = false; colvarSourceID.IsReadOnly = false; colvarSourceID.DefaultSetting = @""; colvarSourceID.ForeignKeyTableName = ""; schema.Columns.Add(colvarSourceID); TableSchema.TableColumn colvarUserID = new TableSchema.TableColumn(schema); colvarUserID.ColumnName = "UserID"; colvarUserID.DataType = DbType.AnsiString; colvarUserID.MaxLength = 100; colvarUserID.AutoIncrement = false; colvarUserID.IsNullable = true; colvarUserID.IsPrimaryKey = false; colvarUserID.IsForeignKey = false; colvarUserID.IsReadOnly = false; colvarUserID.DefaultSetting = @""; colvarUserID.ForeignKeyTableName = ""; schema.Columns.Add(colvarUserID); TableSchema.TableColumn colvarDeleted = new TableSchema.TableColumn(schema); colvarDeleted.ColumnName = "Deleted"; colvarDeleted.DataType = DbType.Boolean; colvarDeleted.MaxLength = 0; colvarDeleted.AutoIncrement = false; colvarDeleted.IsNullable = false; colvarDeleted.IsPrimaryKey = false; colvarDeleted.IsForeignKey = false; colvarDeleted.IsReadOnly = false; colvarDeleted.DefaultSetting = @"((0))"; colvarDeleted.ForeignKeyTableName = ""; schema.Columns.Add(colvarDeleted); TableSchema.TableColumn colvarDeletedDate = new TableSchema.TableColumn(schema); colvarDeletedDate.ColumnName = "DeletedDate"; colvarDeletedDate.DataType = DbType.DateTime; colvarDeletedDate.MaxLength = 0; colvarDeletedDate.AutoIncrement = false; colvarDeletedDate.IsNullable = true; colvarDeletedDate.IsPrimaryKey = false; colvarDeletedDate.IsForeignKey = false; colvarDeletedDate.IsReadOnly = false; colvarDeletedDate.DefaultSetting = @""; colvarDeletedDate.ForeignKeyTableName = ""; schema.Columns.Add(colvarDeletedDate); TableSchema.TableColumn colvarDateAdded = new TableSchema.TableColumn(schema); colvarDateAdded.ColumnName = "DateAdded"; colvarDateAdded.DataType = DbType.DateTime; colvarDateAdded.MaxLength = 0; colvarDateAdded.AutoIncrement = false; colvarDateAdded.IsNullable = true; colvarDateAdded.IsPrimaryKey = false; colvarDateAdded.IsForeignKey = false; colvarDateAdded.IsReadOnly = false; colvarDateAdded.DefaultSetting = @""; colvarDateAdded.ForeignKeyTableName = ""; schema.Columns.Add(colvarDateAdded); BaseSchema = schema; //add this schema to the provider //so we can query it later DataService.Providers["SSRepository"].AddSchema("UsersParagraphLink", schema); } }
public DecrementMenuOrder(DataService dataService) { DataService = dataService; }
private static void GetTableSchema() { if (!IsSchemaInitialized) { //Schema declaration TableSchema.Table schema = new TableSchema.Table("L_MANUFACTURE", TableType.Table, DataService.GetInstance("ORM")); schema.Columns = new TableSchema.TableColumnCollection(); schema.SchemaName = @"dbo"; //columns TableSchema.TableColumn colvarId = new TableSchema.TableColumn(schema); colvarId.ColumnName = "ID"; colvarId.DataType = DbType.Int16; colvarId.MaxLength = 0; colvarId.AutoIncrement = true; colvarId.IsNullable = false; colvarId.IsPrimaryKey = true; colvarId.IsForeignKey = false; colvarId.IsReadOnly = false; colvarId.DefaultSetting = @""; colvarId.ForeignKeyTableName = ""; schema.Columns.Add(colvarId); TableSchema.TableColumn colvarSName = new TableSchema.TableColumn(schema); colvarSName.ColumnName = "sName"; colvarSName.DataType = DbType.String; colvarSName.MaxLength = 100; colvarSName.AutoIncrement = false; colvarSName.IsNullable = true; colvarSName.IsPrimaryKey = false; colvarSName.IsForeignKey = false; colvarSName.IsReadOnly = false; colvarSName.DefaultSetting = @""; colvarSName.ForeignKeyTableName = ""; schema.Columns.Add(colvarSName); TableSchema.TableColumn colvarSDesc = new TableSchema.TableColumn(schema); colvarSDesc.ColumnName = "sDesc"; colvarSDesc.DataType = DbType.String; colvarSDesc.MaxLength = 150; colvarSDesc.AutoIncrement = false; colvarSDesc.IsNullable = true; colvarSDesc.IsPrimaryKey = false; colvarSDesc.IsForeignKey = false; colvarSDesc.IsReadOnly = false; colvarSDesc.DefaultSetting = @""; colvarSDesc.ForeignKeyTableName = ""; schema.Columns.Add(colvarSDesc); BaseSchema = schema; //add this schema to the provider //so we can query it later DataService.Providers["ORM"].AddSchema("L_MANUFACTURE", schema); } }
private static void GetTableSchema() { if (!IsSchemaInitialized) { //Schema declaration TableSchema.Table schema = new TableSchema.Table("BillOfMaterials", TableType.Table, DataService.GetInstance("Default")); schema.Columns = new TableSchema.TableColumnCollection(); schema.SchemaName = @"Production"; //columns TableSchema.TableColumn colvarBillOfMaterialsID = new TableSchema.TableColumn(schema); colvarBillOfMaterialsID.ColumnName = "BillOfMaterialsID"; colvarBillOfMaterialsID.DataType = DbType.Int32; colvarBillOfMaterialsID.MaxLength = 0; colvarBillOfMaterialsID.AutoIncrement = true; colvarBillOfMaterialsID.IsNullable = false; colvarBillOfMaterialsID.IsPrimaryKey = true; colvarBillOfMaterialsID.IsForeignKey = false; colvarBillOfMaterialsID.IsReadOnly = false; colvarBillOfMaterialsID.DefaultSetting = @""; colvarBillOfMaterialsID.ForeignKeyTableName = ""; schema.Columns.Add(colvarBillOfMaterialsID); TableSchema.TableColumn colvarProductAssemblyID = new TableSchema.TableColumn(schema); colvarProductAssemblyID.ColumnName = "ProductAssemblyID"; colvarProductAssemblyID.DataType = DbType.Int32; colvarProductAssemblyID.MaxLength = 0; colvarProductAssemblyID.AutoIncrement = false; colvarProductAssemblyID.IsNullable = true; colvarProductAssemblyID.IsPrimaryKey = false; colvarProductAssemblyID.IsForeignKey = true; colvarProductAssemblyID.IsReadOnly = false; colvarProductAssemblyID.DefaultSetting = @""; colvarProductAssemblyID.ForeignKeyTableName = "Product"; schema.Columns.Add(colvarProductAssemblyID); TableSchema.TableColumn colvarComponentID = new TableSchema.TableColumn(schema); colvarComponentID.ColumnName = "ComponentID"; colvarComponentID.DataType = DbType.Int32; colvarComponentID.MaxLength = 0; colvarComponentID.AutoIncrement = false; colvarComponentID.IsNullable = false; colvarComponentID.IsPrimaryKey = false; colvarComponentID.IsForeignKey = true; colvarComponentID.IsReadOnly = false; colvarComponentID.DefaultSetting = @""; colvarComponentID.ForeignKeyTableName = "Product"; schema.Columns.Add(colvarComponentID); TableSchema.TableColumn colvarStartDate = new TableSchema.TableColumn(schema); colvarStartDate.ColumnName = "StartDate"; colvarStartDate.DataType = DbType.DateTime; colvarStartDate.MaxLength = 0; colvarStartDate.AutoIncrement = false; colvarStartDate.IsNullable = false; colvarStartDate.IsPrimaryKey = false; colvarStartDate.IsForeignKey = false; colvarStartDate.IsReadOnly = false; colvarStartDate.DefaultSetting = @"(getdate())"; colvarStartDate.ForeignKeyTableName = ""; schema.Columns.Add(colvarStartDate); TableSchema.TableColumn colvarEndDate = new TableSchema.TableColumn(schema); colvarEndDate.ColumnName = "EndDate"; colvarEndDate.DataType = DbType.DateTime; colvarEndDate.MaxLength = 0; colvarEndDate.AutoIncrement = false; colvarEndDate.IsNullable = true; colvarEndDate.IsPrimaryKey = false; colvarEndDate.IsForeignKey = false; colvarEndDate.IsReadOnly = false; colvarEndDate.DefaultSetting = @""; colvarEndDate.ForeignKeyTableName = ""; schema.Columns.Add(colvarEndDate); TableSchema.TableColumn colvarUnitMeasureCode = new TableSchema.TableColumn(schema); colvarUnitMeasureCode.ColumnName = "UnitMeasureCode"; colvarUnitMeasureCode.DataType = DbType.String; colvarUnitMeasureCode.MaxLength = 3; colvarUnitMeasureCode.AutoIncrement = false; colvarUnitMeasureCode.IsNullable = false; colvarUnitMeasureCode.IsPrimaryKey = false; colvarUnitMeasureCode.IsForeignKey = true; colvarUnitMeasureCode.IsReadOnly = false; colvarUnitMeasureCode.DefaultSetting = @""; colvarUnitMeasureCode.ForeignKeyTableName = "UnitMeasure"; schema.Columns.Add(colvarUnitMeasureCode); TableSchema.TableColumn colvarBOMLevel = new TableSchema.TableColumn(schema); colvarBOMLevel.ColumnName = "BOMLevel"; colvarBOMLevel.DataType = DbType.Int16; colvarBOMLevel.MaxLength = 0; colvarBOMLevel.AutoIncrement = false; colvarBOMLevel.IsNullable = false; colvarBOMLevel.IsPrimaryKey = false; colvarBOMLevel.IsForeignKey = false; colvarBOMLevel.IsReadOnly = false; colvarBOMLevel.DefaultSetting = @""; colvarBOMLevel.ForeignKeyTableName = ""; schema.Columns.Add(colvarBOMLevel); TableSchema.TableColumn colvarPerAssemblyQty = new TableSchema.TableColumn(schema); colvarPerAssemblyQty.ColumnName = "PerAssemblyQty"; colvarPerAssemblyQty.DataType = DbType.Decimal; colvarPerAssemblyQty.MaxLength = 0; colvarPerAssemblyQty.AutoIncrement = false; colvarPerAssemblyQty.IsNullable = false; colvarPerAssemblyQty.IsPrimaryKey = false; colvarPerAssemblyQty.IsForeignKey = false; colvarPerAssemblyQty.IsReadOnly = false; colvarPerAssemblyQty.DefaultSetting = @"((1.00))"; colvarPerAssemblyQty.ForeignKeyTableName = ""; schema.Columns.Add(colvarPerAssemblyQty); TableSchema.TableColumn colvarModifiedDate = new TableSchema.TableColumn(schema); colvarModifiedDate.ColumnName = "ModifiedDate"; colvarModifiedDate.DataType = DbType.DateTime; colvarModifiedDate.MaxLength = 0; colvarModifiedDate.AutoIncrement = false; colvarModifiedDate.IsNullable = false; colvarModifiedDate.IsPrimaryKey = false; colvarModifiedDate.IsForeignKey = false; colvarModifiedDate.IsReadOnly = false; colvarModifiedDate.DefaultSetting = @"(getdate())"; colvarModifiedDate.ForeignKeyTableName = ""; schema.Columns.Add(colvarModifiedDate); BaseSchema = schema; //add this schema to the provider //so we can query it later DataService.Providers["Default"].AddSchema("BillOfMaterials", schema); } }
public static string GetVpath(string filepath) { string query = string.Format("select top 1 r_vpath from " + GlobalService.DbTable + " where r_path = N'{0}'", filepath); return(DataService.GetInstance().ExecuteScalar(query).ToString().Trim()); }
private static void GetTableSchema() { if (!IsSchemaInitialized) { //Schema declaration TableSchema.Table schema = new TableSchema.Table("InternalPurchaseTable", TableType.Table, DataService.GetInstance("WWIprov")); schema.Columns = new TableSchema.TableColumnCollection(); schema.SchemaName = @"dbo"; //columns TableSchema.TableColumn colvarId = new TableSchema.TableColumn(schema); colvarId.ColumnName = "ID"; colvarId.DataType = DbType.Int32; colvarId.MaxLength = 0; colvarId.AutoIncrement = true; colvarId.IsNullable = false; colvarId.IsPrimaryKey = true; colvarId.IsForeignKey = false; colvarId.IsReadOnly = false; colvarId.DefaultSetting = @""; colvarId.ForeignKeyTableName = ""; schema.Columns.Add(colvarId); TableSchema.TableColumn colvarInvoiceNumber = new TableSchema.TableColumn(schema); colvarInvoiceNumber.ColumnName = "InvoiceNumber"; colvarInvoiceNumber.DataType = DbType.Int32; colvarInvoiceNumber.MaxLength = 0; colvarInvoiceNumber.AutoIncrement = false; colvarInvoiceNumber.IsNullable = true; colvarInvoiceNumber.IsPrimaryKey = false; colvarInvoiceNumber.IsForeignKey = true; colvarInvoiceNumber.IsReadOnly = false; colvarInvoiceNumber.DefaultSetting = @""; colvarInvoiceNumber.ForeignKeyTableName = "InternalInvoiceTable"; schema.Columns.Add(colvarInvoiceNumber); TableSchema.TableColumn colvarSupplierID = new TableSchema.TableColumn(schema); colvarSupplierID.ColumnName = "SupplierID"; colvarSupplierID.DataType = DbType.Int32; colvarSupplierID.MaxLength = 0; colvarSupplierID.AutoIncrement = false; colvarSupplierID.IsNullable = true; colvarSupplierID.IsPrimaryKey = false; colvarSupplierID.IsForeignKey = false; colvarSupplierID.IsReadOnly = false; colvarSupplierID.DefaultSetting = @""; colvarSupplierID.ForeignKeyTableName = ""; schema.Columns.Add(colvarSupplierID); TableSchema.TableColumn colvarEstimatedAmount = new TableSchema.TableColumn(schema); colvarEstimatedAmount.ColumnName = "EstimatedAmount"; colvarEstimatedAmount.DataType = DbType.Single; colvarEstimatedAmount.MaxLength = 0; colvarEstimatedAmount.AutoIncrement = false; colvarEstimatedAmount.IsNullable = true; colvarEstimatedAmount.IsPrimaryKey = false; colvarEstimatedAmount.IsForeignKey = false; colvarEstimatedAmount.IsReadOnly = false; colvarEstimatedAmount.DefaultSetting = @""; colvarEstimatedAmount.ForeignKeyTableName = ""; schema.Columns.Add(colvarEstimatedAmount); TableSchema.TableColumn colvarEstimationDate = new TableSchema.TableColumn(schema); colvarEstimationDate.ColumnName = "EstimationDate"; colvarEstimationDate.DataType = DbType.DateTime; colvarEstimationDate.MaxLength = 0; colvarEstimationDate.AutoIncrement = false; colvarEstimationDate.IsNullable = true; colvarEstimationDate.IsPrimaryKey = false; colvarEstimationDate.IsForeignKey = false; colvarEstimationDate.IsReadOnly = false; colvarEstimationDate.DefaultSetting = @""; colvarEstimationDate.ForeignKeyTableName = ""; schema.Columns.Add(colvarEstimationDate); TableSchema.TableColumn colvarAmount = new TableSchema.TableColumn(schema); colvarAmount.ColumnName = "Amount"; colvarAmount.DataType = DbType.Single; colvarAmount.MaxLength = 0; colvarAmount.AutoIncrement = false; colvarAmount.IsNullable = true; colvarAmount.IsPrimaryKey = false; colvarAmount.IsForeignKey = false; colvarAmount.IsReadOnly = false; colvarAmount.DefaultSetting = @""; colvarAmount.ForeignKeyTableName = ""; schema.Columns.Add(colvarAmount); TableSchema.TableColumn colvarDatePassed = new TableSchema.TableColumn(schema); colvarDatePassed.ColumnName = "DatePassed"; colvarDatePassed.DataType = DbType.DateTime; colvarDatePassed.MaxLength = 0; colvarDatePassed.AutoIncrement = false; colvarDatePassed.IsNullable = true; colvarDatePassed.IsPrimaryKey = false; colvarDatePassed.IsForeignKey = false; colvarDatePassed.IsReadOnly = false; colvarDatePassed.DefaultSetting = @""; colvarDatePassed.ForeignKeyTableName = ""; schema.Columns.Add(colvarDatePassed); TableSchema.TableColumn colvarPurchaseInvNumber = new TableSchema.TableColumn(schema); colvarPurchaseInvNumber.ColumnName = "PurchaseInvNumber"; colvarPurchaseInvNumber.DataType = DbType.String; colvarPurchaseInvNumber.MaxLength = 50; colvarPurchaseInvNumber.AutoIncrement = false; colvarPurchaseInvNumber.IsNullable = true; colvarPurchaseInvNumber.IsPrimaryKey = false; colvarPurchaseInvNumber.IsForeignKey = false; colvarPurchaseInvNumber.IsReadOnly = false; colvarPurchaseInvNumber.DefaultSetting = @""; colvarPurchaseInvNumber.ForeignKeyTableName = ""; schema.Columns.Add(colvarPurchaseInvNumber); TableSchema.TableColumn colvarRemarks = new TableSchema.TableColumn(schema); colvarRemarks.ColumnName = "Remarks"; colvarRemarks.DataType = DbType.String; colvarRemarks.MaxLength = 50; colvarRemarks.AutoIncrement = false; colvarRemarks.IsNullable = true; colvarRemarks.IsPrimaryKey = false; colvarRemarks.IsForeignKey = false; colvarRemarks.IsReadOnly = false; colvarRemarks.DefaultSetting = @""; colvarRemarks.ForeignKeyTableName = ""; schema.Columns.Add(colvarRemarks); TableSchema.TableColumn colvarValueForProfit = new TableSchema.TableColumn(schema); colvarValueForProfit.ColumnName = "ValueForProfit"; colvarValueForProfit.DataType = DbType.Single; colvarValueForProfit.MaxLength = 0; colvarValueForProfit.AutoIncrement = false; colvarValueForProfit.IsNullable = true; colvarValueForProfit.IsPrimaryKey = false; colvarValueForProfit.IsForeignKey = false; colvarValueForProfit.IsReadOnly = false; colvarValueForProfit.DefaultSetting = @""; colvarValueForProfit.ForeignKeyTableName = ""; schema.Columns.Add(colvarValueForProfit); BaseSchema = schema; //add this schema to the provider //so we can query it later DataService.Providers["WWIprov"].AddSchema("InternalPurchaseTable", schema); } }
/// <summary> /// Runs the code example. /// </summary> /// <param name="user">The AdWords user.</param> /// <param name="adGroupId">Id of the ad group for which keyword bid /// simulations are retrieved.</param> /// <param name="keywordId">Id of the keyword for which bid simulations are /// retrieved.</param> public void Run(AdWordsUser user, long adGroupId, long keywordId) { using (DataService dataService = (DataService)user.GetService( AdWordsService.v201802.DataService)) { // Create the selector. Selector selector = new Selector() { fields = new string[] { CriterionBidLandscape.Fields.AdGroupId, CriterionBidLandscape.Fields.CriterionId, CriterionBidLandscape.Fields.StartDate, CriterionBidLandscape.Fields.EndDate, BidLandscapeLandscapePoint.Fields.Bid, BidLandscapeLandscapePoint.Fields.LocalClicks, BidLandscapeLandscapePoint.Fields.LocalCost, BidLandscapeLandscapePoint.Fields.LocalImpressions, BidLandscapeLandscapePoint.Fields.BiddableConversions, BidLandscapeLandscapePoint.Fields.BiddableConversionsValue }, predicates = new Predicate[] { Predicate.Equals(CriterionBidLandscape.Fields.AdGroupId, adGroupId), Predicate.Equals(CriterionBidLandscape.Fields.CriterionId, keywordId) }, paging = Paging.Default }; CriterionBidLandscapePage page = new CriterionBidLandscapePage(); int landscapePointsFound = 0; int landscapePointsInLastResponse = 0; try { do { // Get bid landscape for keywords. page = dataService.getCriterionBidLandscape(selector); landscapePointsInLastResponse = 0; // Display bid landscapes. if (page != null && page.entries != null) { foreach (CriterionBidLandscape bidLandscape in page.entries) { Console.WriteLine("Found criterion bid landscape with ad group id '{0}', " + "keyword id '{1}', start date '{2}', end date '{3}', and landscape points:", bidLandscape.adGroupId, bidLandscape.criterionId, bidLandscape.startDate, bidLandscape.endDate); foreach (BidLandscapeLandscapePoint bidLandscapePoint in bidLandscape.landscapePoints) { Console.WriteLine("- bid: {0} => clicks: {1}, cost: {2}, impressions: {3}, " + "biddable conversions: {4:0.00}, biddable conversions value:{5:0.00}", bidLandscapePoint.bid.microAmount, bidLandscapePoint.clicks, bidLandscapePoint.cost.microAmount, bidLandscapePoint.impressions, bidLandscapePoint.biddableConversions, bidLandscapePoint.biddableConversionsValue); landscapePointsInLastResponse++; landscapePointsFound++; } } } // Offset by the number of landscape points, NOT the number // of entries (bid landscapes) in the last response. selector.paging.IncreaseOffsetBy(landscapePointsInLastResponse); } while (landscapePointsInLastResponse > 0); Console.WriteLine("Number of keyword bid landscape points found: {0}", landscapePointsFound); } catch (Exception e) { throw new System.ApplicationException("Failed to retrieve keyword bid landscapes.", e); } } }
public override string Filepath() { return(Path.Combine(AppConstants.SettingsDirectory, DataService.Filepath <MimeMap>())); }
protected override bool LoadData() { if (!File.Exists(Filepath())) { List <MimeMap> list = new List <MimeMap>(); list.Add(new MimeMap() { Id = "bmp", Extension = ".bmp", Display = "bmp", Name = "Bitmap", Mime = "image/bmp", View = typeof(ContentItemImageView).FullName }); list.Add(new MimeMap() { Id = "gif", Extension = ".gif", Display = "gif", Name = "GIF", Mime = "image/gif", View = typeof(ContentItemView).FullName }); list.Add(new MimeMap() { Id = "png", Extension = ".png", Display = "png", Name = "PNG", Mime = "image/png", View = typeof(ContentItemImageView).FullName }); list.Add(new MimeMap() { Id = "tiff", Extension = ".tiff", Display = "tiff", Name = "TIFF", Mime = "image/tiff", View = typeof(ContentItemImageView).FullName }); list.Add(new MimeMap() { Id = "jpg", Extension = ".jpg", Display = "jpg", Name = "JPG", Mime = "image/jpg", View = typeof(ContentItemImageView).FullName }); list.Add(new MimeMap() { Id = "pdf", Extension = ".pdf", Display = "pdf", Name = "PDF", Mime = "application/pdf", View = typeof(ContentItemFileView).FullName }); list.Add(new MimeMap() { Id = "xlsx", Extension = ".xlsx", Display = "xlsx", Name = "MS-Excel", Mime = "application/vnd.ms-excel", View = typeof(ContentItemFileView).FullName }); list.Add(new MimeMap() { Id = "xls", Extension = ".xls", Display = "xls", Name = "MS-Excel", Mime = "application/vnd.ms-excel", View = typeof(ContentItemFileView).FullName }); list.Add(new MimeMap() { Id = "docx", Extension = ".docx", Display = "docx", Name = "MS-Word", Mime = "application/msword", View = typeof(ContentItemWordView).FullName }); list.Add(new MimeMap() { Id = "doc", Extension = ".doc", Display = "doc", Name = "MS-Word", Mime = "application/msword", View = typeof(ContentItemFileView).FullName }); list.Add(new MimeMap() { Id = "csv", Extension = ".csv", Display = "csv", Name = "Comma Delimited", Mime = "text/plain", View = typeof(ContentItemTextfileView).FullName }); list.Add(new MimeMap() { Id = "xml", Extension = ".xml", Display = "xml", Name = "XML", Mime = "text/xml", View = typeof(ContentItemTextfileView).FullName }); list.Add(new MimeMap() { Id = "json", Extension = ".json", Display = "json", Name = "JSON", Mime = "application/json", View = typeof(ContentItemJsonView).FullName }); list.Add(new MimeMap() { Id = "js", Extension = ".js", Display = "js", Name = "Javascript", Mime = "text/javascript", View = typeof(ContentItemJavascriptView).FullName }); list.Add(new MimeMap() { Id = "java", Extension = ".java", Display = "java", Name = "Java", Mime = "text/java", View = typeof(ContentItemJavaView).FullName }); list.Add(new MimeMap() { Id = "c#", Extension = ".cs", Display = "c#", Name = "CSharp", Mime = "text/cs", View = typeof(ContentItemCSharpView).FullName }); list.Add(new MimeMap() { Id = "cshtml", Extension = ".cshtml", Display = "cshtml", Name = "CSHTML", Mime = "text/cshtml", View = typeof(ContentItemCSHTMLView).FullName }); list.Add(new MimeMap() { Id = "html", Extension = ".html", Display = "html", Name = "HTML", Mime = "text/html", View = typeof(ContentItemHTMLView).FullName }); list.Add(new MimeMap() { Id = "css", Extension = ".css", Display = "css", Name = "CSS", Mime = "text/css", View = typeof(ContentItemCSSView).FullName }); list.Add(new MimeMap() { Id = "vue", Extension = ".vue", Display = "vue", Name = "VUE", Mime = "text/vue", View = typeof(ContentItemVueJSView).FullName }); list.Add(new MimeMap() { Id = "sql", Extension = ".sql", Display = "sql", Name = "SQL", Mime = "text/sql", View = typeof(ContentItemSQLView).FullName }); list.Add(new MimeMap() { Id = "txt", Extension = ".txt", Display = "txt", Name = "TXT", Mime = "text/plain", View = typeof(ContentItemTextfileView).FullName }); list.Add(new MimeMap() { Id = "text", Extension = ".text", Display = "text", Name = "TEXT", Mime = "text/plain", View = typeof(ContentItemTextView).FullName }); list.Add(new MimeMap() { Id = "note", Extension = ".note", Display = "note", Name = "Note", Mime = "text/plain", View = typeof(ContentItemTextView).FullName }); list.Add(new MimeMap() { Id = "url", Extension = ".url", Display = "url", Name = "Url", Mime = "text/x-url", View = typeof(ContentItemUrlView).FullName }); list.Add(new MimeMap() { Id = "tab", Extension = ".csv", Display = "csv", Name = "CSV", Mime = "text/csv", View = typeof(ContentItemCsvView).FullName }); list.Add(new MimeMap() { Id = "rdx", Extension = ".json", Display = "json", Name = "JSON", Mime = "application/x-rolodex-card", View = typeof(ContentItemCardView).FullName }); DataService.TryWrite <MimeMap>(list, out string message, Filepath()); } return(base.LoadData()); }