public AddMachineMasterResponseDto AddMachineMaster(AddMachineMasterRequestDto addMachineMasterRequestDto) { var cModel = new AddMachineMasterCM() { MachineName = addMachineMasterRequestDto.MachineName, AddedDate = addMachineMasterRequestDto.AddedDate }; var response = machineMastersRepository.AddMachineMaster(cModel); return(new AddMachineMasterResponseDto()); }
public AddMachineMasterQM AddMachineMaster(AddMachineMasterCM addMachineMasterCM) { using (var connection = new DbConnectionProvider().CreateConnection()) { connection.Open(); var command = new MachineMasterInsertCommand { Connection = connection }; command.Execute(addMachineMasterCM); } return(new AddMachineMasterQM()); }
public int Execute(AddMachineMasterCM model) { using (var sqlCommand = CreateCommand()) { sqlCommand.Connection = Connection; sqlCommand.CommandText = "[dbo].[uspAddMachineMaster]"; sqlCommand.CommandType = CommandType.StoredProcedure; sqlCommand.Parameters.Add(AddParameter("@MachineName", SsDbType.VarChar, ParameterDirection.Input, model.MachineName)); sqlCommand.Parameters.Add(AddParameter("@AddedDate", SsDbType.DateTime, ParameterDirection.Input, model.AddedDate)); 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("@MachineCode", SsDbType.Decimal, ParameterDirection.Output, default(int))); sqlCommand.ExecuteNonQuery(); return(Convert.ToInt32(sqlCommand.Parameters["@MachineCode"].Value)); } }