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;
}