public async Task GivenValidModel_WhenPostRegisterRequest_ThenReturnOk()
{
// Arrange
var model = new EmployeeTestModel();
// Act
var response = await _fixture.Client.PostAsJsonAsync($"{API_URL}/register", model);
// Assert
response.EnsureSuccessStatusCode();
var updatedModel = await _fixture.Context.Employees.FirstAsync(m => m.FullName == model.FullName);
Assert.Equal(updatedModel.FullName, model.FullName);
Assert.Equal(updatedModel.CardNo, model.CardNo);
Assert.Equal(updatedModel.Position, model.Position);
var assertAccount = await AuthExtensions.GetJwt(
_fixture,
new LoginViewModel
{
UserName = model.UserName,
Password = model.Password
}
);
Assert.NotEmpty(assertAccount);
}
/// <summary>
/// 添加考试记录信息
/// </summary>
/// <param name="model">考试信息</param>
/// <returns></returns>
public static bool InsertEmployeeTestInfo(EmployeeTestModel model)
{
#region 插入SQL拼写
StringBuilder insertSql = new StringBuilder();
insertSql.AppendLine(" INSERT INTO officedba.EmployeeTest ");
insertSql.AppendLine(" (CompanyCD ");
insertSql.AppendLine(" ,TestNo ");
insertSql.AppendLine(" ,Title ");
insertSql.AppendLine(" ,Teacher ");
insertSql.AppendLine(" ,StartDate ");
insertSql.AppendLine(" ,EndDate ");
insertSql.AppendLine(" ,Addr ");
insertSql.AppendLine(" ,TestContent ");
insertSql.AppendLine(" ,TestResult ");
insertSql.AppendLine(" ,Remark ");
insertSql.AppendLine(" ,Status ");
insertSql.AppendLine(" ,Attachment ");
insertSql.AppendLine(" ,AttachmentName ");
insertSql.AppendLine(" ,AbsenceCount ");
insertSql.AppendLine(" ,ModifiedDate ");
insertSql.AppendLine(" ,ModifiedUserID) ");
insertSql.AppendLine(" VALUES ");
insertSql.AppendLine(" (@CompanyCD ");
insertSql.AppendLine(" ,@TestNo ");
insertSql.AppendLine(" ,@Title ");
insertSql.AppendLine(" ,@Teacher ");
insertSql.AppendLine(" ,@StartDate ");
insertSql.AppendLine(" ,@EndDate ");
insertSql.AppendLine(" ,@Addr ");
insertSql.AppendLine(" ,@TestContent ");
insertSql.AppendLine(" ,@TestResult ");
insertSql.AppendLine(" ,@Remark ");
insertSql.AppendLine(" ,@Status ");
insertSql.AppendLine(" ,@Attachment ");
insertSql.AppendLine(" ,@AttachmentName ");
insertSql.AppendLine(" ,@AbsenceCount ");
insertSql.AppendLine(" ,getdate() ");
insertSql.AppendLine(" ,@ModifiedUserID) ");
#endregion
//定义更新基本信息的命令
SqlCommand comm = new SqlCommand();
comm.CommandText = insertSql.ToString();
//设置保存的参数
SetSaveParameter(comm, model);
//定义更新列表
ArrayList lstInsert = new ArrayList();
//添加基本信息更新命令
lstInsert.Add(comm);
//考核结果
EditResultInfo(lstInsert, model.ScoreList, model.TestNo, model.CompanyCD, model.ModifiedUserID);
//执行更新操作并返回更新结果
return(SqlHelper.ExecuteTransWithArrayList(lstInsert));
}
/// <summary>
/// 保存时基本信息参数设置
/// </summary>
/// <param name="comm">命令</param>
/// <param name="model">保存信息</param>
private static void SetSaveParameter(SqlCommand comm, EmployeeTestModel model)
{
//设置参数
comm.Parameters.Add(SqlHelper.GetParameterFromString("@CompanyCD", model.CompanyCD)); //公司代码
comm.Parameters.Add(SqlHelper.GetParameterFromString("@TestNo", model.TestNo)); //考试编号
comm.Parameters.Add(SqlHelper.GetParameterFromString("@Title", model.Title)); //主题
comm.Parameters.Add(SqlHelper.GetParameterFromString("@Teacher", model.Teacher)); //考试负责人ID(对应员工表ID)
comm.Parameters.Add(SqlHelper.GetParameterFromString("@StartDate", model.StartDate)); //开始时间
comm.Parameters.Add(SqlHelper.GetParameterFromString("@EndDate", model.EndDate)); //结束时间
comm.Parameters.Add(SqlHelper.GetParameterFromString("@Addr", model.Addr)); //考试地点
comm.Parameters.Add(SqlHelper.GetParameterFromString("@TestContent", model.TestContent)); //考试内容摘要
comm.Parameters.Add(SqlHelper.GetParameterFromString("@TestResult", model.TestResult)); //考试结果
comm.Parameters.Add(SqlHelper.GetParameterFromString("@Remark", model.Remark)); //备注
comm.Parameters.Add(SqlHelper.GetParameterFromString("@Status", model.Status)); //考试状态(0未开始，1已结束)
comm.Parameters.Add(SqlHelper.GetParameterFromString("@Attachment", model.PageAttachment)); //附件
comm.Parameters.Add(SqlHelper.GetParameterFromString("@AttachmentName", model.AttachmentName)); //附件名称
comm.Parameters.Add(SqlHelper.GetParameterFromString("@AbsenceCount", model.AbsenceCount)); //缺考人数
comm.Parameters.Add(SqlHelper.GetParameterFromString("@ModifiedUserID", model.ModifiedUserID)); //更新用户ID
}
public async Task GivenValidEmployee_WhenPutRequest_ThenReturnOkWithUpdatedModel()
{
// Arrange
var testModel = new EmployeeTestModel();
var model = _fixture.Context.Employees.Last();
model.FullName = testModel.FullName;
model.CardNo = testModel.CardNo;
model.Position = testModel.Position;
// Act
var response = await _fixture.Client.PutAsJsonAsync(API_URL, model);
// Assert
response.EnsureSuccessStatusCode();
var updatedModel = _fixture.Context.Employees.Find(model.Id);
Assert.Equal(model, updatedModel);
}
/// <summary>
/// 更新考试记录信息
/// </summary>
/// <param name="model">保存信息</param>
/// <returns></returns>
public static bool UpdateEmployeeTestInfo(EmployeeTestModel model)
{
#region 更新SQL拼写
StringBuilder updateSql = new StringBuilder();
updateSql.AppendLine(" UPDATE officedba.EmployeeTest ");
updateSql.AppendLine(" SET ");
updateSql.AppendLine(" Title = @Title ");
updateSql.AppendLine(" ,Teacher = @Teacher ");
updateSql.AppendLine(" ,StartDate = @StartDate ");
updateSql.AppendLine(" ,EndDate = @EndDate ");
updateSql.AppendLine(" ,Addr = @Addr ");
updateSql.AppendLine(" ,TestContent = @TestContent ");
updateSql.AppendLine(" ,TestResult = @TestResult ");
updateSql.AppendLine(" ,Remark = @Remark ");
updateSql.AppendLine(" ,Status = @Status ");
updateSql.AppendLine(" ,Attachment = @Attachment ");
updateSql.AppendLine(" ,AttachmentName = @AttachmentName ");
updateSql.AppendLine(" ,AbsenceCount = @AbsenceCount ");
updateSql.AppendLine(" ,ModifiedDate = getdate() ");
updateSql.AppendLine(" ,ModifiedUserID = @ModifiedUserID ");
updateSql.AppendLine(" WHERE ");
updateSql.AppendLine(" CompanyCD = @CompanyCD ");
updateSql.AppendLine(" AND TestNo = @TestNo ");
#endregion
//定义更新基本信息的命令
SqlCommand comm = new SqlCommand();
comm.CommandText = updateSql.ToString();
//设置保存的参数
SetSaveParameter(comm, model);
//定义更新列表
ArrayList lstUpdate = new ArrayList();
//添加基本信息更新命令
lstUpdate.Add(comm);
//登陆或者更新进度安排信息
EditResultInfo(lstUpdate, model.ScoreList, model.TestNo, model.CompanyCD, model.ModifiedUserID);
//执行更新操作并返回更新结果
return(SqlHelper.ExecuteTransWithArrayList(lstUpdate));
}
public async Task GivenInvalidEmployee_WhenPutRequest_ThenReturnBadRequest(string identityId, string fullName, string cardNo)
{
// Arrange
var testModel = new EmployeeTestModel();
var model = _fixture.Context.Employees.Last();
model.IdentityId = identityId ?? model.IdentityId;
model.FullName = fullName ?? model.FullName;
model.CardNo = cardNo ?? model.CardNo;
if (cardNo == "existing_card_no")
{
var existingCardNo = _fixture.Context.Employees.First().CardNo;
model.CardNo = existingCardNo;
}
// Act
var response = await _fixture.Client.PutAsJsonAsync(API_URL, model);
// Assert
Assert.Equal(HttpStatusCode.BadRequest, response.StatusCode);
}
static void Main(string[] args)
{
try
{
var db = new LiteDatabase(@"C:\Users\Ashley Johansson\Documents\Intern\TestProj\LitedbTestProj\LitedbTestProj\TestDB\Test.db");
// Get Employee collection if it exists, otherwise create a new one
var Employees = db.GetCollection <EmployeeTestModel>("EmployeeTestModel");
// Create a new Employee
var EmployeeTestModel = new EmployeeTestModel
{
EmployeeName = "Tapas Pal",
CompanyName = "TCS",
Department = "IT",
Skill = ".NET,C#,SQL,HTML",
PhoneNumber = "1234567890",
Address = "Kolkata,India"
};
// Create another Employee
var Employee1 = new EmployeeTestModel
{
EmployeeName = "XYZ ZYZ",
CompanyName = "TCS",
Department = "IT",
Skill = ".NET,C#,SQL,HTML",
PhoneNumber = "1234567899",
Address = "Kolkata,India"
};
//Insert Records
Employees.Insert(EmployeeTestModel);
Employees.Insert(Employee1);
Console.WriteLine(EmployeeTestModel.EmployeeId);
Console.WriteLine(Employee1.EmployeeId);
//Update Record
EmployeeTestModel.EmployeeName = "New Employee";
Employees.Upsert(EmployeeTestModel);
int eID = EmployeeTestModel.EmployeeId;
//Find Record
var collection = db.GetCollection <EmployeeTestModel>("EmployeeTestModel");
var EmployeeFine = collection.FindById(EmployeeTestModel.EmployeeId);
Console.WriteLine(EmployeeFine.EmployeeName + " " + EmployeeFine.EmployeeId);
var results = collection.Find(x => x.Address.Contains("Kolkata"));
Console.WriteLine(results.ElementAt(EmployeeFine.EmployeeId - 1).EmployeeId +
" " + EmployeeFine.EmployeeName + " " + results.ElementAt(Employee1.EmployeeId - 1).EmployeeId +
" " + Employee1.EmployeeName);
//Create Index
Employees.EnsureIndex("EmployeeId");
Employees.Delete(EmployeeTestModel.EmployeeId);
Employees.Delete(Employee1.EmployeeId);
}
catch (Exception ex)
{
}
}
/// <summary>
/// 编辑考试记录信息
/// </summary>
/// <param name="model">保存信息</param>
/// <returns></returns>
public static bool SaveTestInfo(EmployeeTestModel model)
{
//获取登陆用户信息
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
//设置公司代码
model.CompanyCD = userInfo.CompanyCD;
model.ModifiedUserID = userInfo.UserID;
//定义返回变量
bool isSucc = false;
//操作日志
LogInfoModel logModel = InitLogInfo(model.TestNo);
//更新
if (ConstUtil.EDIT_FLAG_UPDATE.Equals(model.EditFlag))
{
try
{
logModel.Element = ConstUtil.LOG_PROCESS_UPDATE;
//执行更新操作
isSucc = EmployeeTestDBHelper.UpdateEmployeeTestInfo(model);
}
catch (Exception ex)
{
//输出系统日志
WriteSystemLog(userInfo, ex);
}
}
//插入
else
{
try
{
logModel.Element = ConstUtil.LOG_PROCESS_INSERT;
//执行插入操作
isSucc = EmployeeTestDBHelper.InsertEmployeeTestInfo(model);
}
catch (Exception ex)
{
//输出系统日志
WriteSystemLog(userInfo, ex);
}
}
//更新成功时
if (isSucc)
{
//设置操作成功标识
logModel.Remark = ConstUtil.LOG_PROCESS_SUCCESS;
}
//更新不成功
else
{
//设置操作成功标识
logModel.Remark = ConstUtil.LOG_PROCESS_FAILED;
}
//登陆日志
LogDBHelper.InsertLog(logModel);
return(isSucc);
}
