Problem
How to get label text from table reference on database based on TableName and FieldName dynamically from database
and show on view createEmployee .
Meaning i need to get label text dynamically from database not static from model
SO that Every Time i need to change text of label i will change it from database depend on reference table
AND No need to change from code .
IF You give me function or any thing general because i have more models and view i need to make like that)
Tools used sql server 2012 and visual studio 2017 asp.net core 2.1
Query Get Data from reference Table
SELECT TableName, FieldName,EnglishtextforLabel FROM ReferenceFile WHERE (FieldName = 'EmployeeId' ) AND TableName = 'Employee'
Database Have two tables Employee and ReferenceFileDatabase Have two tables Employee and Reference File(may be
increase
models and views so that if any thing general is prefer)
- Models classes Include HRContext
- public class ReferenceFile(have 3 key as composit keys(Code,TableName,FieldName))
- {
- public int Code { get; set; }
- public string TableName { get; set; }
- public string FieldName { get; set; }
- public string EnglishtextforLabel{ get; set; }
- }
- public class Employee
- {
- public int EmployeeId { get; set; }
- public string EmployeeName { get; set; }
- public int EmployeeAge { get; set; }
- }
- public class HRContext : DbContext
- {
- public HRContext(DbContextOptions
options) - : base(options)
- { }
- public DbSet
Employees { get; set; } - public DbSet
ReferenceFiles { get; set; } - protected override void OnModelCreating(ModelBuilder modelBuilder)
- {
- base.OnModelCreating(modelBuilder);
- modelBuilder.Entity
() - .HasKey(t => new { t.EmployeeId });
- modelBuilder.Entity
() - .HasKey(t => new { t.Code,t.TableName,t.FieldName });
- }
- }
- Employee View Create(this static and i dont need . i need view labels get from reference table)
-
-
-
-
-
-
-
Laxmidhar SahooPosted Dec 31, 2018, 1:14 AM
ahmed elbarbaryPosted Dec 29, 2018, 1:39 AM
Laxmidhar SahooPosted Dec 27, 2018, 11:39 PM