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