public void ConnectionTest()
{
string expected = "Data Source=mssql.fhict.local;Initial Catalog=dbi414029;User ID=dbi414029;Password=***********";
string actual = AppSettingsJson.GetConnectionstring();
Assert.AreEqual(expected, actual);
}
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
{
var appSettingsJson = AppSettingsJson.GetAppSettings();
var connectionString = appSettingsJson["ConnectionStrings:DefaultConnection"];
optionsBuilder.UseSqlServer(connectionString);
}
public IActionResult Index()
{
var appSettingsJson = AppSettingsJson.GetAppSettings();
var connectionString = appSettingsJson["MssqlConnectionString"];
return(View());
}
public string SyncPatient()
{
try
{
Process p = new Process();
//设置要启动的应用程序
var appSettingsJson = AppSettingsJson.GetAppSettings();
var processpath = appSettingsJson["syncpatientapppath"];//admin12345
p.StartInfo.FileName = processpath;
//是否使用操作系统shell启动
p.StartInfo.UseShellExecute = false;
// 接受来自调用程序的输入信息
p.StartInfo.RedirectStandardInput = true;
//输出信息
p.StartInfo.RedirectStandardOutput = true;
// 输出错误
p.StartInfo.RedirectStandardError = true;
//不显示程序窗口
p.StartInfo.CreateNoWindow = false;
//启动程序
p.Start();
p.StandardInput.AutoFlush = true;
//等待程序执行完退出进程
p.WaitForExit();
p.Close();
return("同步成功");
}
catch (Exception)
{
return("同步失败");
}
}
public UserController()
{
Microsoft.Extensions.Configuration.IConfigurationRoot appSettingsJson = AppSettingsJson.GetAppSettings();
string connectionString = appSettingsJson["DefaultConnection"];
ConnectionString = connectionString;
}
public IActionResult Index(string username, string pwd, bool logout = false)
{
//user admin12345
if (logout || string.IsNullOrEmpty(username))
{
HttpContext.Session.SetString("user", "");
}
else
{
MD5CryptoServiceProvider md5Hasher = new MD5CryptoServiceProvider();
byte[] data = md5Hasher.ComputeHash(Encoding.Default.GetBytes(username + '-' + pwd));
StringBuilder sBuilder = new StringBuilder();
for (int i = 0; i < data.Length; i++)
{
sBuilder.Append(data[i].ToString("x2"));
}
var appSettingsJson = AppSettingsJson.GetAppSettings();
var userpwd = appSettingsJson["userpwd"];//admin12345
if (userpwd == sBuilder.ToString())
{
HttpContext.Session.SetString("user", "admin");
ViewBag.Username = "******";
}
else
{
ViewBag.ErrorMsg = "用户名密码错误";
}
}
return(View());
}
//连接数据库
public SqlConnection Sqlconnect()
{
var asp = AppSettingsJson.GetAppSettings()["ConnectionStrings"];
SqlConnection conn = new SqlConnection(asp);
conn.Open();
return(conn);
}
public static void SaveAppSettings(AppSettingsJson settings)
{
IOUtils.EnsureParentDirExists(Paths.AppSettingsFile);
File.WriteAllText(
Paths.AppSettingsFile,
JsonUtils.Serialize(settings)
);
}
public async Task <IActionResult> UploadFile(IFormFile FileToUpload, int fileGroupID)
{
if (FileToUpload == null || FileToUpload.Length == 0)
{
//return RedirectToAction("Manage", "LineItemGroups", new { id = fileGroupID });
return(Json("\"error\" : \"No file uploaded\""));
}
string fileName = Path.GetFileName(FileToUpload.FileName);
try {
// 1. Save the FileAttachment record
FileAttachment fileAttachment = new FileAttachment()
{
FileDate = DateTime.Now,
FileName = fileName, //file name gets changed in next step below; done in two steps so we have the ID
DisplayName = fileName,
GroupID = fileGroupID
};
_context.FileAttachments.Add(fileAttachment);
_context.SaveChanges();
// 2. Update the FileName to include the Attachment ID
// This is to make the filename in the UserFiles directory unique
// This will prevent overwrites by files with the same name
// The DisplayName will remain identical to what the user uploaded, so it can duplicate without conflict
fileAttachment.FileName = fileAttachment.AttachmentID + "_" + fileAttachment.FileName;
_context.FileAttachments.Update(fileAttachment);
_context.SaveChanges();
// 3. Save the file to the UserFiles directory, using the FileName, not the DisplayName
string filePath = AppSettingsJson.UserFilesPhysicalPath() + fileAttachment.FileName;
using (var stream = new FileStream(filePath, FileMode.Create))
{
await FileToUpload.CopyToAsync(stream);
}
// Assert: DisplayName = Filename.pdf, FileName = 123_Filename.pdf, file is stored in /UserFiles/123_Filename.pdf
string displayPath = AppSettingsJson.UserFilesPhysicalPath() + fileAttachment.DisplayName;
ViewData["FilePath"] = filePath;
ViewData["DisplayPath"] = displayPath;
// Add to ViewBag a list of all files associated with this encumbrance request
List <FileAttachment> files = _context.FileAttachments.Where(f => f.GroupID == fileGroupID).ToList();
ViewBag.Files = files;
//return RedirectToAction("Manage", "LineItemGroups", new { id = fileGroupID });
string returnString = "{\"fileID\" : \"" + fileAttachment.AttachmentID + "\", \"fileName\" : \"" + fileAttachment.DisplayName + "\", \"fileURL\" : \"\\\\UserFiles\\\\" + fileAttachment.FileName + "\"}";
return(Json(returnString));
}
catch (Exception e)
{
//Console.WriteLine(e.Message);
//TODO: If the file wasn't deleted, restore the FileAttachment record
//return Json("{'error': 'true', 'message' : 'The attachment was not saved.' }");
//return RedirectToAction("Manage", "LineItemGroups", new { id = fileGroupID });
return(Json("\"error\" : \"Could not upload file.\""));
}
}
public void Delete(int id)
{
using (SqlConnection connection = new SqlConnection(AppSettingsJson.GetConnectionstring()))
{
connection.Open();
string query = @"Delete from [Users] where UserId = '" + id + "'";
SqlCommand qry = new SqlCommand(query, connection);
qry.ExecuteNonQuery();
}
}
public void Add(UserModel user)
{
using (SqlConnection connection = new SqlConnection(AppSettingsJson.GetConnectionstring()))
{
connection.Open();
string query = @"insert into [Users] (Name,Password,Age,Weight,Height, Gender) values ('" + user.Name + "','" + user.Password + "','" +
user.Age + "','" + user.Weight + "','" + user.Height + "','" + user.Gender + "')";
SqlCommand qry = new SqlCommand(query, connection);
qry.ExecuteNonQuery();
}
}
public DataAccess(string connectionStringName = "GoodBooks", string Database = "GoodBooks")
{
//Get connection string from appsettings
var appSettingsJson = AppSettingsJson.GetAppSettings();
connString = appSettingsJson["Data:ConnectionStrings:" + connectionStringName];
//colnnect to cluster and select db
_client = new MongoClient(connString);
_db = _client.GetDatabase(Database);
}
public QueueSender()
{
var appSettings = AppSettingsJson.GetAppSettings();
_settings = new QueueSettings(
appSettings["SBusAzure:SBusConnectionString"],
appSettings["SBusAzure:SBusQueueName"]);
_queueClient = new QueueClient(
_settings.ConnectionString, _settings.QueueName);
}
public void UpdateUser(int id, string name, int age, int weight, int height, string gender)
{
using (SqlConnection conn = new SqlConnection(AppSettingsJson.GetConnectionstring()))
{
conn.Open();
var query = @"update Users set Name ='" + name + "', Age ='" + age + "', Weight ='" + weight + "', Height ='" + height + "', Gender ='" + gender + "' where UserId = '" + id + "'";
using (SqlCommand command = new SqlCommand(query, conn))
{
command.ExecuteNonQuery();
}
}
}
public async Task<UserLoginDTO> Register(UserRegisterDTO registerParam)
{
var Secret = AppSettingsJson.GetString("AppSettings:Secret");
var key = Encoding.ASCII.GetBytes(Secret);
#if !DEBUG
string encPassword = CyrptoHash.DecryptString(registerParam.Password, Convert.ToBase64String(key));
#else
string encPassword = registerParam.Password;
#endif
if (_userRepository.Get(x => x.Username == registerParam.Username) != null)
throw new Exception($"Username is already exist! Username: {registerParam.Username}");
try
{ MailAddress m = new MailAddress(registerParam.Email); }
catch (FormatException)
{ throw new Exception($"Email format is incorrect! Email: {registerParam.Email}"); }
var alreadyUser = await _userRepository.GetList(x => x.Email == registerParam.Email);
if (alreadyUser.Any())
throw new Exception($"Email is already exist! Email: {registerParam.Email}");
var hasNumber = new Regex(@"[0-9]+");
var hasUpperChar = new Regex(@"[A-Z]+");
var hasMinimum8Chars = new Regex(@".{8,}");
var isValidated = hasNumber.IsMatch(encPassword) && hasUpperChar.IsMatch(encPassword) && hasMinimum8Chars.IsMatch(encPassword);
if (!isValidated)
throw new Exception("The password must have at least one large character, one number and a length of more than 8 characters.");
if (string.IsNullOrEmpty(registerParam.Picture))
registerParam.Picture = "DefaultImg";
encPassword = HashData.SHA512(encPassword);
await _userRepository.Add(new User
{
Username = registerParam.Username,
Biography = registerParam.Biography,
CreateDate = DateTime.Now,
Email = registerParam.Email,
FullName = registerParam.FullName,
LastSeen = DateTime.Now,
Password = encPassword,
Picture = registerParam.Picture,
Status = Status.Active
});
return await Login(registerParam.Username, registerParam.Password);
}
// This method gets called by the runtime. Use this method to add services to the container.
public void ConfigureServices(IServiceCollection services)
{
services.Configure <CookiePolicyOptions>(options =>
{
// This lambda determines whether user consent for non-essential cookies is needed for a given request.
options.CheckConsentNeeded = context => true;
options.MinimumSameSitePolicy = SameSiteMode.None;
});
#region Configurarion Injection v1
var appConfig = new AppSettingsJson(); // 請先定義 AppSettings 類別
Configuration.Bind(appConfig);
services.AddSingleton <AppSettingsJson>(appConfig);
#endregion
#region Configurarion Injection v2
services.Configure <AppSettingsJson>(Configuration);
#endregion
#region Configuration Injection v3
services.Configure <AppSettingsSubJson>(
Configuration.GetSection("Sub"));
#endregion
#region DI 練習
services.AddTransient <IAppSettingsTransient, AppSettings>();
services.AddScoped <IAppSettingsScoped, AppSettings>();
services.AddSingleton <IAppSettingsSingleton, AppSettings>();
#endregion
#region 使用Session(建議不要用）
services.AddDistributedMemoryCache();
services.AddSession(options => { });
#endregion
services.AddMvc().SetCompatibilityVersion(CompatibilityVersion.Version_2_1);
}
public ApplicationDbContext CreateDbContext(string[] args)
{
// To prep each database uncomment the corresponding line below.
var appSettingsJson = AppSettingsJson.GetAppSettings();
var con = appSettingsJson["Finbuckle:MultiTenant:Stores:ConfigurationStore:Defaults:ConnectionString"];
var tenantInfo = new TenantInfo {
ConnectionString = con
};
var optionsBuilder = new DbContextOptionsBuilder <ApplicationDbContext>();
return(new ApplicationDbContext(tenantInfo, optionsBuilder.Options));
}
public QueueReceiver(IProcess processData, ILogger <QueueReceiver <T> > logger)
{
var appSettings = AppSettingsJson.GetAppSettings();
_settings = new QueueSettings(
appSettings["SBusAzure:SBusConnectionString"],
appSettings["SBusAzure:SBusQueueName"]);
_processData = processData;
_logger = logger;
_queueClient = new QueueClient(
_settings.ConnectionString, _settings.QueueName);
}
public ActionResult GetFileByName(string FileName, string DisplayName)
{
var fullName = AppSettingsJson.UserFilesPhysicalPath() + FileName;
if (System.IO.File.Exists(fullName))
{
FileStream fs = System.IO.File.OpenRead(fullName);
byte[] data = new byte[fs.Length];
int br = fs.Read(data, 0, data.Length);
if (br != fs.Length)
{
throw new IOException("Unable to completely read file.");
}
//get MIME type; tried using methods in Microsoft.AspNetCore.StaticFiles; but can't install that package without a bunch of other conflicting dependencies
string mimeType = "application/octet-stream"; //default; not recommended to use this generic, but no other extensions have been used to date beyond what's listed in the switch below
string extension = System.IO.Path.GetExtension(FileName);
switch (extension)
{
case ".doc":
mimeType = "application/msword";
break;
case ".docx":
mimeType = "application/vnd.openxmlformats-officedocument.wordprocessingml.document";
break;
case ".pdf":
mimeType = "application/pdf";
break;
case ".xls":
mimeType = "application/vnd.ms-excel";
break;
case ".xlsm":
mimeType = "application/vnd.ms-excel.sheet.macroEnabled.12";
break;
case ".xlsx":
mimeType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
break;
}
return(File(data, mimeType, DisplayName));
}
else
{
return(NotFound("File not found: " + FileName));
}
}
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
{
try
{
var appSettingsJson = AppSettingsJson.GetAppSettings();
var connectionStrings = appSettingsJson["ConnectionStrings"];
var connectionString = appSettingsJson["EPSContext"];
connectionString = "Data Source=USTLH1LT1506\\TurnpikeTest;Initial Catalog=EPSNew;Integrated Security=True";
}
catch (Exception e)
{
Console.Write(e.StackTrace.ToString());
}
}
// This method gets called by the runtime. Use this method to add services to the container.
public void ConfigureServices(IServiceCollection services)
{
services.AddCors();
services.AddMvc().SetCompatibilityVersion(CompatibilityVersion.Version_2_1);
#region JWT
var key = Encoding.ASCII.GetBytes(AppSettingsJson.GetString("AppSettings:Secret"));
services.AddAuthentication(x =>
{
x.DefaultAuthenticateScheme = JwtBearerDefaults.AuthenticationScheme;
x.DefaultChallengeScheme = JwtBearerDefaults.AuthenticationScheme;
})
.AddJwtBearer(x =>
{
x.RequireHttpsMetadata = false;
x.SaveToken = true;
x.TokenValidationParameters = new TokenValidationParameters
{
ValidateIssuerSigningKey = true,
IssuerSigningKey = new SymmetricSecurityKey(key),
ValidateIssuer = false,
ValidateAudience = false
};
});
#endregion
#region INJECTION
services.AddTransient <IUserService, UserManager>();
services.AddTransient <IUserRepository, EFUserRepository>();
services.AddScoped <IPostRepository, EFPostRepository>();
services.AddScoped <IPostService, PostManager>();
services.AddScoped <IFollowerRepository, EFFollowerRepository>();
services.AddScoped <IFollowerService, FollowerManager>();
services.AddScoped <IPhotoRepository, EFPhotoRepository>();
services.AddScoped <IPhotoService, PhotoManager>();
services.AddSingleton <IHttpContextAccessor, HttpContextAccessor>();
#endregion
}
public PackStartupWindowViewModel(
IAttachedWindowManipulator attachedWindowManipulator,
AppSettingsJson appSettings
)
{
_attachedWindowManipulator = attachedWindowManipulator;
_appSettings = appSettings;
CreateNewPackCommand = new ActionCommand(CreateNewPackCommand_Execute);
ChooseExistingPackCommand = new ActionCommand(ChooseExistingPackCommand_Execute);
LaunchConverterCommand = new ActionCommand(LaunchConverterCommand_Execute);
SwitchToEnglishCommand = new ActionCommand(() => SwitchLanguageTo("en-US"));
SwitchToRussianCommand = new ActionCommand(() => SwitchLanguageTo("ru-RU"));
PropertyChanged += OnPropertyChanged;
}
public JobContainer(IJobExecutionContext _Context)
{
var config = AppSettingsJson.GetAppSettings();
SqlConnectionStringBuilder sqlConnectionStringBuilder = new SqlConnectionStringBuilder(config.GetSection("ConnectionStrings:BaseDBContext").Value);
sqlConnectionStringBuilder.Password = Encryption.Decrypt(sqlConnectionStringBuilder.Password);
ConnString = sqlConnectionStringBuilder.ConnectionString;
stopwatch.Start();
Context = _Context;
JobName = JobGroup = MethodName = MethodParams = JobMessage = ExceptionInfo = "";
JobName = Context.JobDetail.Key.Name;
InitContainer();
}
// This method gets called by the runtime. Use this method to add services to the container.
// For more information on how to configure your application, visit https://go.microsoft.com/fwlink/?LinkID=398940
public void ConfigureServices(IServiceCollection services)
{
var appSettingsJson = AppSettingsJson.GetAppSettings();
services.AddDbContext <DataContext>(opts => opts.UseSqlServer(appSettingsJson["ConnectionString:ReceiptsDBAzure"]));
services.AddScoped <IDataRepository <Receipt>, ReceiptManager>();
services.AddScoped <IDataRepository <User>, UserManager>();
services.BuildServiceProvider().GetService <DataContext>().Database.Migrate();
services.AddOpenApiDocument(config => config.Title = "API");
services.AddControllers();
services.AddApiVersioning(config =>
{
config.DefaultApiVersion = new ApiVersion(1, 0);
config.AssumeDefaultVersionWhenUnspecified = true;
config.ReportApiVersions = true;
});
}
public JsonResult Delete(int id)
{
try
{
//Delete the FileAttachment Record
FileAttachment fileAttachment = _context.FileAttachments.SingleOrDefault(f => f.AttachmentID == id);
string fileName = fileAttachment.DisplayName;
_context.FileAttachments.Remove(fileAttachment);
_context.SaveChanges();
//Remove the file from UserFiles directory
DeleteFile(AppSettingsJson.UserFilesPhysicalPath() + fileAttachment.FileName);
return(new JsonResult("{\"fileName\" : \"" + fileName + "\"}"));
}catch (Exception e)
{
return(new JsonResult("result: error"));
}
}
public static async Task Main(string[] args)
{
var host = CreateHostBuilder(args).Build();
// Set up the databases for the sample if needed.
var env = host.Services.GetService <IWebHostEnvironment>();
if (env.EnvironmentName == "Development")
{
var appSettingsJson = AppSettingsJson.GetAppSettings();
var con = appSettingsJson["Finbuckle:MultiTenant:Stores:ConfigurationStore:Defaults:ConnectionString"];
using (var db = new ApplicationDbContext(new TenantInfo {
ConnectionString = con
}))
{
await db.Database.MigrateAsync();
}
}
await host.RunAsync();
}
public IActionResult PatientDetails()
{
List <string> OutPut = new List <string>();
//Dictionary<string, string> dict = new Dictionary<string, string>();
// string connectionString = "Server = demosql001.cc4mi4fhf4fo.ap-southeast-2.rds.amazonaws.com; Database = WHADemo; User Id = whadevfe; Password = 4MeW3%T7JxMA; ";
//string connectionString = "SELECT TOP (1000) [PersonID],[LastName],[FirstName],[Address],[City] FROM [testdatabase].[dbo].[Persons]";
//string connectionString = "Data Source=DESKTOP-SK0EJ1N;Initial Catalog=testdatabase;Integrated Security=True";
//var xxx = ConfigurationManager.ConnectionStrings["DefaultConnectString"];
//string myDb1ConnectionString = _configuration.GetConnectionString("myDb1");
var appSettingsJson = AppSettingsJson.GetAppSettings();
var connectionString = appSettingsJson["DefaultConnectString"];
//string connectionString = "dfa";
SqlConnection conn = new SqlConnection(connectionString);
conn.Open();
//SqlCommand com = new SqlCommand("select * from dbo.POBPatient where POBPatientID = 1;", conn);
SqlCommand com = new SqlCommand("select * from dbo.Persons;", conn);
var Returned = com.ExecuteReader();
while (Returned.Read())
{
for (int i = 0; i < Returned.FieldCount; i++)
{
OutPut.Add(Returned.GetName(i));
// columns.Add(Returned.GetName(i));
}
//OutPut.Add(Returned.GetString(3));
}
conn.Close();
var column = new PatientEmpolymentHistory();
//column.ColumnNames = OutPut;
return(Ok(OutPut));
}
public ApiRequest(string System, bool LoginFlag = false)
{
Stopwatch = new Stopwatch();
Stopwatch.Start();
_System = System;
_LoginFlag = LoginFlag;
try
{
var config = AppSettingsJson.GetAppSettings();
ConnString = config.GetSection("ConnectionStrings:BaseDBContext").Value;
SqlConnectionStringBuilder sqlConnectionStringBuilder = new SqlConnectionStringBuilder(ConnString);
sqlConnectionStringBuilder.Password = Encryption.Decrypt(sqlConnectionStringBuilder.Password);
ConnString = sqlConnectionStringBuilder.ConnectionString;
Server = config.GetSection(System + "Setting:Server").Value;
LoginUrl = config.GetSection(System + "Setting:LoginUrl").Value;
Uid = config.GetSection(System + "Setting:Uid").Value;
Pwd = config.GetSection(System + "Setting:Pwd").Value;
}
catch (Exception) { }
}
public UserModel FindById(int id)
{
using (SqlConnection connection = new SqlConnection(AppSettingsJson.GetConnectionstring()))
{
try
{
connection.Open();
SqlCommand dataCommand = new SqlCommand()
{
CommandText = "SELECT * FROM [dbo].[Users] WHERE [UserId] = '" + id + "'",
Connection = connection
};
using (SqlDataReader userReader = dataCommand.ExecuteReader())
{
userReader.Read();
return(new UserModel(Convert.ToInt32(userReader["UserId"]), userReader["Password"].ToString(), userReader["Name"].ToString(), Convert.ToInt32(userReader["Age"]), Convert.ToInt32(userReader["Weight"]), Convert.ToInt32(userReader["Height"]), userReader["Gender"].ToString()));
}
}
catch
{
return(null);
}
}
}
public async Task<UserLoginDTO> Login(string username, string password)
{
var key = Encoding.ASCII.GetBytes(AppSettingsJson.GetString("AppSettings:Secret"));
password = CyrptoHash.DecryptString(password, Convert.ToBase64String(key));
//Sql de şifreli tutuluor.
password = HashData.SHA512(password);
var user = await _userRepository.Get(x => x.Username == username && x.Password == password && x.Status == Status.Active);
if (user == null) return null;
var tokenHandler = new JwtSecurityTokenHandler();
var tokenDescriptor = new SecurityTokenDescriptor
{
Subject = new ClaimsIdentity(new Claim[]
{
new Claim(ClaimTypes.Name, user.Id.ToString()),
new Claim(ClaimTypes.Role,user.ProfileType.ToString())
}),
Expires = DateTime.UtcNow.AddDays(7),
SigningCredentials = new SigningCredentials(new SymmetricSecurityKey(key), SecurityAlgorithms.HmacSha256Signature)
};
var tokenSecret = tokenHandler.CreateToken(tokenDescriptor);
string token = tokenHandler.WriteToken(tokenSecret);
return new UserLoginDTO
{
FullName = user.FullName,
Id = user.Id,
Password = null,
Username = user.Username,
Token = token
};
}
