public string bc() { string json = File.ReadAllText(@"c:\Users\Administrator\Documents\customer.txt", Encoding.UTF8); var list = JsonConvert.DeserializeObject <List <JObject> >(json); var customers = from jo in list select new TjCustomer { Name = jo["name"].ToString(), Email = jo["email"].ToString(), Phone = jo["phone"].ToString(), Company = jo["company"].ToString(), Region = jo["region"].ToString(), Location = jo["location"].ToString(), Industry = jo["industry"].ToString(), Owner = 0, ServiceBy = 0 }; var db = new ErpDbContext(); db.TjCustomers.AddRange(customers); db.SaveChanges(); return("ok"); }
private static User currentUser(string id) { using (var db = new ErpDbContext()) { return(db.Users.AsNoTracking().FirstOrDefault(x => x.UserId.ToString() == id)); } }
static void Main(string[] args) { using (var db = new ErpDbContext()) { //var res = db.Permissions.ToList(); //db.Users // .Include(i=>i.Roles) // .FirstOrDefault(f=> f.UserId==4) //.Roles //.ToList() //.ForEach(r=> r.PrintDump()); var re = from u in db.Users from r in u.Roles from p in r.Permissions join s in db.Permissions.DefaultIfEmpty() on p.PermissionId equals s.PermissionId where u.UserId == 4 select new { r, p }; re.ToList().ForEach(r => r.PrintDump()); //res.ForEach(r=> r.PrintDump()); } Console.ReadLine(); }
public string Get(string username, string password) { var db = new ErpDbContext(); var user = db.Users.FirstOrDefault(x => x.LoginName == "administrator"); if (user != null) { return(JwtManager.GenerateToken(user)); } throw new HttpResponseException(HttpStatusCode.Unauthorized); }
public ProjectRepository(ErpDbContext context , Iproject_partnerRepository <project_partnerModel> repo_project_partner , IGenericRepository <PartnerModel> repo_partner , IUnitOfWork unitOfWork) { _context = context; _repo_project_partner = repo_project_partner; _repo_partner = repo_partner; _unitOfWork = unitOfWork; }
public StatusService(ErpDbContext dbContext) : base(dbContext) { }
/// <summary> /// /// </summary> /// <param name="dbContext"></param> /// <param name="mapper"></param> public IconController(ErpDbContext dbContext, IMapper mapper) { _dbContext = dbContext; _mapper = mapper; }
public DesignationRepoImpl(ErpDbContext db) : base(db) { }
public QueryHelper(ErpDbContext context) { this.context = context; }
/// <summary> /// Constructor that takes a context /// </summary> /// <param name="context">An established data context</param> public GenericRepository(TContext context) { Context = new ErpDbContext(); //Context = context as ErpDbContext; }
public ValuesController(ErpDbContext db) { _db = db; }
public CurrencyConversionService(ErpDbContext dbContext) : base(dbContext) { }
public DesignationService(ErpDbContext dbContext) : base(dbContext) { }
public TaxRegisterDetailService(ErpDbContext dbContext) : base(dbContext) { }
public LedgerFinancialYearBalanceService(ErpDbContext dbContext) : base(dbContext) { }
public ModuleService(ErpDbContext dbContext) : base(dbContext) { }
public UserService(ErpDbContext dbContext) : base(dbContext) { }
public PurchaseInvoiceTaxService(ErpDbContext dbContext, IPurchaseInvoice _purchaseInvoice) : base(dbContext) { purchaseInvoice = _purchaseInvoice; }
public SalaryRepoImpl(ErpDbContext _Db) : base(_Db) { }
public DepartmentService(ErpDbContext dbContext) : base(dbContext) { }
public void Renew() { Context = new ErpDbContext(); }
public Project_partnerRepository(ErpDbContext context) { _context = context; }
public DocumentoService(ErpDbContext context, IProvedorService provedorService) { _context = context; _provedorService = provedorService; }
public TjCustomerController(ErpDbContext dbContext, IMapper mapper) { _dbContext = dbContext; this.mapper = mapper; }
public EmployeeService(ErpDbContext dbContext) : base(dbContext) { }
public ExpenditureRepository(ErpDbContext context) { _context = context; }
public ApplicationIdentityUserService(ErpDbContext dbContext) : base(dbContext) { }
public TipoPersonaService(ErpDbContext context) { _context = context; }
public ErpService() { context = ErpDbContext.Create(); }
public LoginController(ErpDbContext erpDbContext) { _dbContext = erpDbContext; }