public void Test_GenerateCode() { // Arrange _dbObjectName = "GET_RATE_GROUP_DEF"; _target.DbDataContext = _dbDataContext; _testSqlParameters = new List <SqlParameter>(); _dbSysUtilsMock.Setup(d => d.GetTablesFromSP(_connectionString, _dbObjectName)).Returns(_testParameters); _dbSysUtilsMock.Setup(d => d.GetParametersFromSP(_connectionString, _dbObjectName)).Returns(_testSqlParameters); var testClass = new StringBuilder(); testClass.AppendLine("public interface IRategroupdefRepo"); testClass.AppendLine("{"); testClass.AppendLine(" IEnumerable<TableRategroupdef> GetAll();"); testClass.AppendLine(" void Save(TableRategroupdef tableRategroupdef);"); testClass.AppendLine("}"); testClass.AppendLine(); testClass.AppendLine("public class RategroupdefRepo : DataAccessBaseRepo, IRategroupdefRepo"); testClass.AppendLine("{"); testClass.AppendLine(" public IEnumerable<TableRategroupdef> GetAll()"); testClass.AppendLine(" {"); testClass.AppendLine(" var tableRategroupdef = new List<TableRategroupdef>();"); testClass.AppendLine(); testClass.AppendLine(" using (var db = new TransitDbDataContext(ConnectionString))"); testClass.AppendLine(" {"); testClass.AppendLine(" var dataList = db.GET_RATE_GROUP_DEF().ToList();"); testClass.AppendLine(" tableRategroupdef.AddRange(dataList.Select(dataRategroupdef => new TableRategroupdef"); testClass.AppendLine(" {"); testClass.AppendLine(" Rate_group_code = dataRategroupdef.Rate_group_code,"); testClass.AppendLine(" Service_level_no = dataRategroupdef.Service_level_no,"); testClass.AppendLine(" Rate_group_description = dataRategroupdef.Rate_group_description,"); testClass.AppendLine(" User_id = dataRategroupdef.User_id,"); testClass.AppendLine(" Record_insert_timestamp = dataRategroupdef.Record_insert_timestamp.UtcDateTime"); testClass.AppendLine(" }));"); testClass.AppendLine(" }"); testClass.AppendLine(); testClass.AppendLine(" return tableRategroupdef;"); testClass.AppendLine(" }"); testClass.AppendLine(); testClass.AppendLine(" public void Save(TableRategroupdef tableRategroupdef)"); testClass.AppendLine(" {"); testClass.AppendLine(" using (var db = new TransitDbDataContext(ConnectionString))"); testClass.AppendLine(" {"); testClass.AppendLine(" db.SAVE_RATE_GROUP_DEF(tableRategroupdef.Rate_group_code, tableRategroupdef.Service_level_no, tableRategroupdef.Rate_group_description, tableRategroupdef.User_id, tableRategroupdef.Record_insert_timestamp);"); testClass.AppendLine(" }"); testClass.AppendLine(" }"); testClass.AppendLine("}"); // Act var result = _target.GenerateCode(_testProperties, _connectionString, _dbObjectName); // Assert Assert.IsTrue(testClass.Equals(result)); }
public IResult Add(Product product) { var result = BusinessRules.Run(CheckIfProductNameExists(product.Name)); if (result != null) { return(new ErrorResult(result.Message)); } product.Code = _codeGeneratorService.GenerateCode(product); product.CreateDate = DateTime.Now; product.Active = true; _productDal.Add(product); return(new SuccessResult(BusinessMessages.ProductAdded)); }
public void GenerateCode_Test() { // Arrange _modelPropertyControllerMock.Setup(m => m.GetNullableMarkIfApplicable(_testModelProperties[0])).Returns(""); _modelPropertyControllerMock.Setup(m => m.GetNullableMarkIfApplicable(_testModelProperties[1])).Returns(""); _modelPropertyControllerMock.Setup(m => m.GetNullableMarkIfApplicable(_testModelProperties[2])).Returns(""); _modelPropertyControllerMock.Setup(m => m.GetNullableMarkIfApplicable(_testModelProperties[3])).Returns(""); _modelPropertyControllerMock.Setup(m => m.GetNullableMarkIfApplicable(_testModelProperties[4])).Returns(""); _dbSysUtilsMock.Setup(d => d.GetTablesFromSP(_connectionString, _dbObjectName)).Returns(_testTables); var testClass = new StringBuilder(); testClass.AppendLine("public class TableRate_group_def"); testClass.AppendLine("{"); testClass.AppendLine(" public int Rate_group_code { get; set; }"); testClass.AppendLine(" public int Service_level_no { get; set; }"); testClass.AppendLine(" public string Rate_group_description { get; set; }"); testClass.AppendLine(" public string User_id { get; set; }"); testClass.AppendLine(" public DateTimeOffset Record_insert_timestamp { get; set; }"); testClass.AppendLine("}"); // Act var result = _target.GenerateCode(_testModelProperties, _connectionString, _dbObjectName); // Assert Assert.IsTrue(testClass.Equals(result)); }
public IActionResult GenerateCode([FromBody] CodeGenerateRequest request) { var response = new OperationResponse <GeneratedCode>(); try { response.Data = codeGeneratorService.GenerateCode(request.ProcedureName, request.Parameters); } catch (Exception exception) { response.State = ResponseState.Error; response.Messages.Add(exception.Message); _logger.LogError(exception, "Error Getting Procedure Params"); } return(Json(response)); }
/// <summary> /// handles the flow of user selection for code generator/reader /// </summary> /// <param name="codeReaderService"></param> /// <param name="codeGeneratorService"></param> /// <param name="configuration"></param> /// <param name="userSelection"></param> public static void ProcessUserSelection(ICodeReaderService codeReaderService, ICodeGeneratorService codeGeneratorService, IConfigurationRoot configuration, ConsoleKeyInfo userSelection, ILogger logger) { switch (userSelection.KeyChar) { case '1': codeReaderService.ReadCode(configuration, logger); break; case '2': codeGeneratorService.GenerateCode(configuration, logger); break; default: break; } }