public UserDto Find(string userName)
{
var sqlQuery = new StringBuilder();
sqlQuery.AppendLine("SELECT ");
sqlQuery.AppendLine(" EMAIL_ADDR AS UserName ");
sqlQuery.AppendLine(" ,PASSWORD AS Password ");
sqlQuery.AppendLine(" ,EMPLR_ID AS EmployeeNo ");
sqlQuery.AppendLine(" ,EMAIL_ADDR AS Email ");
sqlQuery.AppendLine(" ,ENG_NAME AS EnglishName ");
sqlQuery.AppendLine(" ,LOCAL_NAME AS LocalName ");
sqlQuery.AppendLine(" ,ORG_NAME AS Organization ");
sqlQuery.AppendLine(" ,ORG_DESC AS OrganizationDescription ");
sqlQuery.AppendLine(" ,DIV_NAME AS Department ");
sqlQuery.AppendLine(" ,JOBTITLE_NAME AS Job ");
sqlQuery.AppendLine(" ,CELL_PH_NUM AS Tel ");
sqlQuery.AppendLine(" ,EXTENSION AS Extension ");
sqlQuery.AppendLine(" ,VOIP ");
sqlQuery.AppendLine(" ,manager AS Manager ");
sqlQuery.AppendLine(" FROM VW_people_finder ");
sqlQuery.AppendLine(" WHERE EMAIL_ADDR = @UserName ");
return(StorageManager.CreateInstance(StorageSettings.Ez)
.SelectFirstOrDefault <UserDto>(sqlQuery.ToString(), new { UserName = userName }));
}
private IDataReader GetDataReaderOfAttachment()
{
var report = this.GetReport(this._attachmentTopic.ReportId);
if (report == null)
{
this.SetErrorStatus("The report does not find.");
return(null);
}
var connectOpt = new ConnectionOptions
{
DataSource = report.Rdbms.Server,
InitialCatalog = report.Rdbms.Catalog,
UserId = report.Rdbms.UserId,
Password = report.Rdbms.Password,
ReadOnly = report.Rdbms.ReadOnly
};
var provider = report.Rdbms.Provider;
var sqlStatement = this._attachmentTopic.SqlStatement;
var parameters = this._attachmentTopic.Parameter;
if (String.IsNullOrWhiteSpace(parameters))
{
return(StorageManager.CreateInstance(connectOpt, provider).GetDataReader(sqlStatement));
}
var parms = StorageParameter.ConvertStringToParameter(parameters);
return(StorageManager.CreateInstance(connectOpt, provider).GetDataReader(sqlStatement, parms));
}
public void QueryList_Test()
{
var sql = "SELECT * FROM TestTemp";
var tests = StorageManager.CreateInstance(this._connectionName).Select <SqlServerTempTest>(sql);
Assert.IsNotNull(tests);
Assert.IsTrue(tests.Any());
var detail = Utils.LookupEntityDetail(tests);
Assert.IsNull(detail, detail);
}
public void Job_Test()
{
var sql = "SELECT PI_No, Bill_ID, Bill_Company, Contact, Email, RMA_NO, Modify_DT, Result, TAT FROM V_AASC_Pending_PO WHERE (RMA_NO > @YnTRx6AWek)";
var parms = new Dictionary <string, object>
{
{ "@YnTRx6AWek", "A161" }
};
var reader = StorageManager.CreateInstance("RMA").GetDataReader(sql, parms);
if (reader != null)
{
reader.Close();
}
}
public void QueryCount_Test()
{
var sql = "SELECT ID, Name, Age, Weight, Address, Enabled, CreatedDate FROM TestTemp WHERE Enabled = @Enabled";
var param = new Dictionary <string, object>
{
{ "Enabled", true }
};
var tests = StorageManager.CreateInstance(this._connectionName).Select <SqlServerTempTest>(sql, 1, 2, param);
Assert.IsNotNull(tests);
Assert.IsTrue(tests.Any());
var detail = Utils.LookupEntityDetail(tests);
Assert.IsNull(detail, detail);
}
