public AddSubcontractProcessMasterResponseDto AddSubcontractProcessMaster(AddSubcontractProcessMasterRequestDto addSubcontractProcessMasterRequestDto) { var cModel = new AddSubcontractProcessMasterCM { ProcessDescription = addSubcontractProcessMasterRequestDto.ProcessDescription, CreatedBy = new Guid("783F190B-9B66-42AC-920B-E938732C1C01"), //Later needs to be remove CreatedDateTime = System.DateTime.UtcNow }; var response = subcontractProcessMasterRepository.AddSubcontractProcessMaster(cModel); return(new AddSubcontractProcessMasterResponseDto()); }
public AddSubcontractProcessMasterQM AddSubcontractProcessMaster(AddSubcontractProcessMasterCM addSubcontractProcessMasterCM) { using (var connection = new DbConnectionProvider().CreateConnection()) { connection.Open(); var command = new SubcontractProcessMasterInsertCommand { Connection = connection }; command.Execute(addSubcontractProcessMasterCM); } return(new AddSubcontractProcessMasterQM()); }
public int Execute(AddSubcontractProcessMasterCM model) { using (var sqlCommand = CreateCommand()) { sqlCommand.Connection = Connection; sqlCommand.CommandText = "[dbo].[uspAddSubContractProcessMaster]"; sqlCommand.CommandType = CommandType.StoredProcedure; sqlCommand.Parameters.Add(AddParameter("@ProcessDescription", SsDbType.VarChar, ParameterDirection.Input, model.ProcessDescription)); sqlCommand.Parameters.Add(AddParameter("@CreatedBy", SsDbType.UniqueIdentifier, ParameterDirection.Input, new Guid())); sqlCommand.Parameters.Add(AddParameter("@CreatedDateTime", SsDbType.DateTime, ParameterDirection.Input, DateTime.UtcNow)); sqlCommand.Parameters.Add(AddParameter("@ProcessCode", SsDbType.Decimal, ParameterDirection.Output, default(int))); sqlCommand.ExecuteNonQuery(); return(Convert.ToInt32(sqlCommand.Parameters["@ProcessCode"].Value)); } }